UBB.Developers Forums Community Development Programming MySQL and Server Configuration Let's tune MySQL!

Hi everyone,

I've been tweaking my my.cnf file, first attempt. Judging from details gathered, most indicators are fine.

However, now my site is busy, there are two indicators that aren't so good:

Open_tables | 512 | 100% of table_cache in use

I can just up that figure, I guess.

But this one:
Key_read_requests | 92766222 | | Key_reads | 40777

That's 4.39. WAY over the recommendation here.

Which area of the cnf file should I target to bring this in control? Scenario 4 in the intial post seems to similar to this, but there's no elaboration on what it means.

Thanks!