function dba_mysql_report_help_tmp_disk_table in Database Administration 7

1 call to dba_mysql_report_help_tmp_disk_table()

dba_mysql_report_output in database/mysql.report.inc

Build mysqlreport output.

File

database/mysql.report.inc, line 572

Provides database driver specific report functions.

Code

function dba_mysql_report_help_tmp_disk_table() {
  return t("Temporary tables are frequently being created on the filesystem, reducing performance. One cause of this is when temporary tables have TEXT or BLOB fields, as then they can't be built in memory. To allocate more memory for temporary tables, adjust both the tmp_table_size and max_heap_table_size to the same value.  Note that this memory is allocated per-connection, so be careful to not increase it too quickly. It is rarely beneficial to increase these tunables above 32M on a Drupal website.");
}