The branch, master has been updated via c64ac7291ecd57f719e3ce90e8d707bf1dd5ee60 (commit) from d3aa1ece3def7d8e63ad3dc966ea9452284eec65 (commit)

- Log ----------------------------------------------------------------- commit c64ac7291ecd57f719e3ce90e8d707bf1dd5ee60 Author: Marc Delisle marc@infomarc.info Date: Fri Oct 7 07:57:30 2011 -0400

Typos

-----------------------------------------------------------------------

Summary of changes: libraries/advisory_rules.txt | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/libraries/advisory_rules.txt b/libraries/advisory_rules.txt index 8216a49..f127e29 100644 --- a/libraries/advisory_rules.txt +++ b/libraries/advisory_rules.txt @@ -254,7 +254,7 @@ rule 'Temp disk rate' Created_tmp_disk_tables / Uptime value * 60 * 60 > 1 Many temporary tables are being written to disk instead of being kept in memory. - Increasing {max_heap_table_size} and {tmp_table_size} might help. However some temporary tables are always being written to disk, independent of the value of these variables. To eliminate these you will have to rewrite your queries to avoid those conditions (Within a temprorary table: Presence of a BLOB or TEXT column or presence of a column bigger than 512 bytes) as mentioned in in the <a href="http://dev.mysql.com/doc/refman/5.5/en/internal-temporary-tables.html">MySQL Documentation</a> + Increasing {max_heap_table_size} and {tmp_table_size} might help. However some temporary tables are always being written to disk, independent of the value of these variables. To eliminate these you will have to rewrite your queries to avoid those conditions (Within a temporary table: Presence of a BLOB or TEXT column or presence of a column bigger than 512 bytes) as mentioned in the <a href="http://dev.mysql.com/doc/refman/5.5/en/internal-temporary-tables.html">MySQL Documentation</a> Rate of temporary tables being written to disk: %s, this value should be less than 1 per hour | PMA_bytime(value,2)

# I couldn't find any source on the internet that suggests a direct relation between high counts of temporary tables and any of these variables.

hooks/post-receive