function dba_mysql_report_help_innodb_flush in Database Administration 7

1 call to dba_mysql_report_help_innodb_flush()

dba_mysql_report_output in database/mysql.report.inc

Build mysqlreport output.

File

database/mysql.report.inc, line 600

Provides database driver specific report functions.

Code

function dba_mysql_report_help_innodb_flush() {
  return t("By default, InnoDB is ACID compliant. This means that each transaction needs to be immediately flushed to disk. If you can afford to loose one second of transactions in the event of a database or server failure, you should tune InnoDB to only flush to disk once every second.\n\nSet the innodb_flush_log_at_trx_commit tunable to 0 to have InnoDB only flush to disk once every second.");
}