key_reads and opened_tables.

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

Re: key_reads and opened_tables.

Larry Hotchkiss wrote: In the manual, it states if Key_reads is big, then your key_cahce is probably too small.so what exactly is BIG??? Its all about ratios, you just want a hit cache hit, so that your read_requests are a lot larger than your actual reads. |