The branch, master has been updated
via c64ac7291ecd57f719e3ce90e8d707bf1dd5ee60 (commit)
from d3aa1ece3def7d8e63ad3dc966ea9452284eec65 (commit)
- Log -----------------------------------------------------------------
commit c64ac7291ecd57f719e3ce90e8d707bf1dd5ee60
Author: Marc Delisle <[email protected]>
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
--
phpMyAdmin
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2dcopy2
_______________________________________________
Phpmyadmin-git mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-git
