function dba_mysql_report_help_innodb_buffer in Database Administration 7

1 call to dba_mysql_report_help_innodb_buffer()

dba_mysql_report_output in database/mysql.report.inc

Build mysqlreport output.

File

database/mysql.report.inc, line 592

Provides database driver specific report functions.

Code

function dba_mysql_report_help_innodb_buffer() {
  return t("As a general rule, if you are using InnoDB, approximately 70% of your available RAM should be given to MySQL's InnoDB Buffer Pool.  Most of your buffer pool is being used, you should look into making more RAM available to InnoDB. You do not ever want your Buffer Pool to be 100% full.  However, you also don't ever want MySQL to cause your operating system to swap.\n\nTo allocate more memory for the InnoDB buffer pool, adjust the innodb_buffer_pool_size tunable.");
}