Should I be running “OPTIMIZE TABLE” occasionally on SuiteCRM tables?
We need an answer from a MySQL guy. I am really interested in this.
please, read this blog post http://www.xaprb.com/blog/2010/02/07/how-often-should-you-use-optimize-table/ is old but gold, also read the comments, they’re important too…
Mikebeck strikes again! I love you mike!
I was reading Jim Mackin’s book “SuiteCRM for Developers” and he has a small advice about MySQL optimisation.
[quote=“Jim Mackin - SuiteCRM for Developers - page 101” ]
MySQL is notorious for having small default settings. Fully optimising MySQL is outside the scope of this book (however checkout mysqltuner.pl for a helpful Perl script which will provide setting recommendations - note that you should be careful when running files from an unknown source). One small change that can make a big difference is increasing the innodb_buffer_pool_size.
If you have migrated or imported a significant amount of data it is possible that some tables will be fragmented. Running OPTIMIZE TABLE tablename can increase performance.