In the manual, it states "if Key_reads is big, then your key_cahce is 
probably too small."....so what exactly is BIG???

        Same thing for opened_tables, it states "if opened_tables is big then your 
then your table_cache variable is probably too small". Can someone please 
define BIG????

        Im just using a default RH 7.1 install of mysql 3.23.36, no tweaks as of 
yet. PII 300 has 128 meg of RAM. My current opened_tables is 69 and my 
key_reads is 210251. My current db consists of 4 small tables.


---------------------------------
Larry Hotchkiss



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to