How to optimize my.cnf file

memoriess

Verified User
Joined
Jan 5, 2006
Messages
22
Hi,

My database retrieving is slow, how do I optimize my.cnf file?

Please advice. Thanks
 
Hello,
First see via SSH : mysqladmin extended-status

How much RAM you have ?

You can start with some sample files from /usr/share/mysql/ :


my-huge.cnf
my-large.cnf
my-medium.cnf
my-small.cnf


Depends on your requirements you can fine tune it.



Thanks.
 
Back
Top