MySQL "optimize table"

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

Should I be running “OPTIMIZE TABLE” occasionally on SuiteCRM tables?

https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html

#2

We need an answer from a MySQL guy. I am really interested in this.

#3

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…

best regards

1 Like
#4

Mikebeck strikes again! I love you mike!

1 Like
#5

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.