Re: Help make my big new server fast

[Jason Rhoades]

Great, thanks Rick. Took backups, then restarted mysql with innodb enabled. Converted five of the hardest hit tables to InnoDB using alter table [table] engine=innodb. Also made four new MyISAM key caches, and assigned each one to a big and heavily-hit MyISAM table that would take too long to convert to InnoDB in tonight's window.

Gave innodb_buffer_pool_size 20G, when the size of all my .ibd files in sum is only about 14GB.

Things are started back up and looking okay, will see how it goes. Here's my innodb lines in my.cnf:

innodb_buffer_pool_size=20G
innodb_log_file_size=512M
innodb_log_buffer_size=32M
innodb_thread_concurrency=24
innodb_flush_log_at_trx_commit=2
innodb_file_per_table
innodb_flush_method=O_DIRECT