Changes between Version 32 and Version 33 of InstallationGuidelines/MySQL

Timestamp:

09/06/10 09:12:47 (14 years ago)

Author:

Dan Zubey

Comment:

--

InstallationGuidelines/MySQL

@@ -102 +102 @@
 Outside of this, the usual tools for monitoring memory/cpu usage is effective. 
 
-Note that high mysql cpu usage may indicate a high io-wait condition. (iowait is time spent reading/writing to io; in this case, disk). [BR]
-This can occur when attempting to view or sort massive quantities of data in eden. [BR] Using the above tips for increasing mysql ram usage will give mysql space to do sorts in memory.
+Note that high mysql cpu usage may indicate a high io-wait condition, as many programs
+do not report iowait seperately from user / sys cpu usage. This hides the real issue. top is your friend. 
+(iowait is time spent reading/writing to io; in this case, disk).
+High iowait can occur when attempting to view or sort massive quantities of data in eden.
+Using the above tips for increasing mysql ram usage will give mysql space to do sorts in memory.
+
 ---
 == Replication ==