Take the 2-minute tour ×  I'm running a fairly popular website
with the following stats and setup.  stats: ~250,000 pageviews
per day, rendering ~47 queries / second to MySQL setup: the
MySQL instance is running alone on a Linode512 on Debian 6.0.
Nothing else runs there, for performance reasons. Using MyISAM
and the ini for "large" mysql.  I see the following figures
right now from MYSQLREPORT.  Please advice. The site performance
is quite OK but I'm not sure what the 256 MB key buffer
indicates and if that is tannable in the long run or not. I'm
not very good at understanding the inner workings of MYSQL.
Also, I can't figure out why the QC is being hit so low i.e. why
isn't it using all of the QC.  -- Key -- Buffer used   226.52M
of 256.00M  %Used:  88.49   Current     256.00M
Write hit      64.93%  Read hit      100.00%  -- Questions --
Total         139.38M    47.0/s   QC Hits      51.28M    17.3/s
%Total:  36.79   DMS          41.99M    14.2/s           30.12
Com-         30.75M    10.4/s