innodb database conversion

[kendallchenoweth]

Hello,

I'm trying to convert the mysql database from myisam to innodb and my dba is seeing "optimize table" which is going to be performance hit and unnecessary with innodb. How is this initiated and how can we control this behavior? Are there any other "gotchas" with the innodb conversion?

[jdalrymple]

Hi kendallchenoweth,

Please reference this forum post from someone who wanted to do something similar:

http://support.nagios.com/forum/viewtop ... 16&t=11744

At this point the situation stands, we only support myisam and as such our ability to offer proper and complete support to your system after this conversion would be impossible. If you are experiencing performance problems with the database please feel free to reach out to us and we'll do our best to help you optimize.

[kendallchenoweth]

Okay, setting aside the MYISAM/INNODB question, my basic problem is that the scheduled table optimizations conflict with the RDS Amazon scheduled backup process. I'm sure that this has already been reported. If I can just resolve this last conflict, maybe that would be enough. My DBA is prepared to handle the table optimizations himself. Is it possible to disable the scheduled table optimizations and if so how? What's the impact of just this change?

Thanks for your help!

[jdalrymple]

What you want to do can be achieved by commenting out the relevant section of /etc/cron.d/nagiosxi (the line with dbmaint.php) however this will get overwritten during an upgrade. Furthermore it may be preferable to lower its frequency or adjust the timeperiod rather than disable it completely.

does that help?

[kendallchenoweth]

thanks, I'll try it. I appreciate your help.

[lmiltchev]

kendallchenoweth, let us know if it is OK to lock this topic.