function dba_mysql_report_help_qc_usage in Database Administration 7

1 call to dba_mysql_report_help_qc_usage()

dba_mysql_report_output in database/mysql.report.inc

Build mysqlreport output.

File

database/mysql.report.inc, line 548

Provides database driver specific report functions.

Code

function dba_mysql_report_help_qc_usage() {
  return t("Your query cache is getting full, you may want to allocate more memory.  However, the query cache has many limitations so it should not be blindly increased on the assumption that this will help.  Prior to MySQL 5.0.50 there was a locking bug in MySQL which prevented you from being able to increase your query cache beyond 64M in size.  Even in later version of MySQL it is not recommend you increase the cache beyond 256M unless you've found a measurable improvement in performance.\n\nTo adjust the size of your query cache, set the query_cache_size tunable.");
}