Author: mysqldoc
Date: 2011-05-13 15:06:16 +0200 (Fri, 13 May 2011)
New Revision: 26210
Log:
Automatic update from ET
Modified:
trunk/mysql-monitor-2.3/mem-reference-advgraph-core.xml
Modified: trunk/mysql-monitor-2.3/mem-reference-advgraph-core.xml
===================================================================
--- trunk/mysql-monitor-2.3/mem-reference-advgraph-core.xml 2011-05-13 13:06:11 UTC (rev 26209)
+++ trunk/mysql-monitor-2.3/mem-reference-advgraph-core.xml 2011-05-13 13:06:16 UTC (rev 26210)
Changed blocks: 3, Lines Added: 12, Lines Deleted: 4; 1770 bytes
@@ -3655,9 +3655,8 @@
this key buffer is limited in size to 4 GB, <literal>even on
64-bit operating systems</literal>. If set to a larger value,
mysqld may crash when it tries to increase the actual buffer
- beyond 4 GB. Note that key_buffer_size is limited to 4GB on
- both 32-bit and 64-bit Windows systems, even in MySQL version
- 5.0.52 and later.
+ beyond 4 GB. Note that key_buffer_size remains limited to 4GB
+ on 64-bit Windows systems until MySQL version 5.1.31.
</para>
<para>
@@ -3700,7 +3699,10 @@
<para>
The target server does not appear to have sufficient memory
devoted to the key cache. On a dedicated server, this cache is
- commonly about 25%-50% of total RAM.
+ commonly about 25%-50% of total RAM, when the MyISAM storage
+ engine is in use within the database instance. This advisor
+ also checks whether the Key Buffer usage has been greater than
+ 75% full since the instance started, by default.
</para>
<para>
@@ -4759,6 +4761,12 @@
</para>
<para>
+ This advisor triggers when more than 25% of the Query Cache is
+ being used, and the ratio of Query Cache hits to Query Cache
+ inserts is low.
+ </para>
+
+ <para>
<emphasis role="bold">Default frequency</emphasis> 00:05:00
</para>
| Thread |
|---|
| • svn commit - mysqldoc@oter02: r26210 - trunk/mysql-monitor-2.3 | mysqldoc | 13 May |
