The branch, master has been updated
via 1c872ed13345460c43fd363ba50fc03bc0e7dbbc (commit)
from 6b786f7c55dd6419533b2d3b82685a375f498195 (commit)
- Log -----------------------------------------------------------------
commit 1c872ed13345460c43fd363ba50fc03bc0e7dbbc
Author: Marc Delisle <[email protected]>
Date: Wed Oct 5 12:56:33 2011 -0400
Typo
-----------------------------------------------------------------------
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 1bc5023..8216a49 100644
--- a/libraries/advisory_rules.txt
+++ b/libraries/advisory_rules.txt
@@ -255,7 +255,7 @@ rule 'Temp disk rate'
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>
- Rate of temporay tables being written to disk: %s, this value should be
less than 1 per hour | PMA_bytime(value,2)
+ 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.
# Several independent Blog entries suggest
(http://ronaldbradford.com/blog/more-on-understanding-sort_buffer_size-2010-05-10/
and http://www.xaprb.com/blog/2010/05/09/how-to-tune-mysqls-sort_buffer_size/)
hooks/post-receive
--
phpMyAdmin
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Phpmyadmin-git mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-git
