if($innodb_thread_concurrency < 16) { write("Increase the innodb_thread_concurrency to 16, Current size is $innodb_thread_concurrency.
",$client,$hostname,$today); write_cr("# Increase the innodb_thread_concurrency to 16, Current size is $innodb_thread_concurrency.\n",$client,$hostname,$today); } if($innodb_commit_concurrency < 8) { write("Increase the innodb_commit_concurrency to 8, Current size is $innodb_commit_concurrency.
",$client,$hostname,$today); write_cr("# Increase the innodb_commit_concurrency to 8, Current size is $innodb_commit_concurrency.\n",$client,$hostname,$today); } if($innodb_file_per_table == 'OFF') { write("Set innodb_file_per_table. Currently not enabled.
",$client,$hostname,$today); write_cr("# Set innodb_file_per_table. Currently not enabled.\n",$client,$hostname,$today); } $innodb_buffer_pool_sizeHR=sizeFormat($innodb_buffer_pool_size); write("Current innodb_buffer_pool_size = $innodb_buffer_pool_sizeHR.
",$client,$hostname,$today); write("Depending on how much space your innodb indexes take up it may be safe
",$client,$hostname,$today); write("to increase this value to up to 2/3 of total system memory.

",$client,$hostname,$today); if(($Innodb_buffer_pool_pages_free == 0) || ($Innodb_buffer_pool_pages_total == 0)) { $Innodb_buffer_pool_pages_total = 1; $Innodb_buffer_pool_pages_free = 1; } $Innodb_buffer_pool_pages_ratio=round(($Innodb_buffer_pool_pages_free/$Innodb_buffer_pool_pages_total),2); if($Innodb_buffer_pool_pages_ratio > .75) { write("Current Innodb_buffer_pool_pages_ratio = $Innodb_buffer_pool_pages_ratio : 1
",$client,$hostname,$today); write("You may want to consider increasing the innodb_buffer_pool_size
",$client,$hostname,$today); $innodb_map = '1'; write_cr("# Increase the innodb_buffer_pool_size if possible, Current size is $innodb_buffer_pool_sizeHR.\n",$client,$hostname,$today); } else { write("Current Innodb_buffer_pool_pages_ratio = $Innodb_buffer_pool_pages_ratio : 1
",$client,$hostname,$today); write("Your Innodb_buffer_pool_pages_ratio looks ok.
",$client,$hostname,$today); }