On Wed, Dec 28, 2011 at 3:10 PM, J. Bakshi
<bakshi12@gmail.com> wrote:
Dear list,
Let me arise all-time favorite topic mysql performance tuning once again.
I have a ***dedicated server only for mysql; equipped with i5 processor and 8GB RAM.***
It is debian squeeze. The tables are mixed types i.e. some are InnoDB and some are MyISAM.
I have installed mysqltuner and I am filtering out the interested findings and my questions
*****
- [OK] Maximum possible memory usage: 5.6G (72% of installed RAM)
---> How can I increase the limit ? I have 8 GB RAM.
*****
- [!!] Key buffer hit rate: 94.6% (821K cached / 44K reads)
---> What should I do here ?
*****
- [!!] Table cache hit rate: 0% (4K open / 596K opened)
---> What should I do here ?
*****
- [!!] InnoDB data size / buffer pool: 4.9G/8.0M
---> What should I do here ?
mysqltuner also suggest the following
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
table_cache (> 4000)
innodb_buffer_pool_size (>= 4G)
`````````````
So, Please suggest me based on my H/W how can I get optimum from mysql ?
Thanks
--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Archive: [🔎] 20111228171006.487c5b99@shiva.selfip.org" target="_blank">http://lists.debian.org/[🔎] 20111228171006.487c5b99@shiva.selfip.org