MySQL which small - huge .cnf

hirohitosan

hirohitosan

Hi there. I'm planning to install Joomla on my server. I installed MySQL 5.1 and now I have to chose my.cnf. There are many example files
Code: 
ls /usr/local/share/mysql/*.cnf
/usr/local/share/mysql/my-huge.cnf
/usr/local/share/mysql/my-innodb-heavy-4G.cnf
/usr/local/share/mysql/my-large.cnf
/usr/local/share/mysql/my-medium.cnf
/usr/local/share/mysql/my-small.cnf
My box has 4G of RAM and mysql is for Joomla!

Any advices which one to chose?

Thanks
 
They are just examples and should be treated as such. Run your database for a few days then run the MySQL tuning script. Adjust the parameters, let it run for a few days, then run the script again. Keep doing that until it performs as expected.
 
/usr/local/share/mysql/my-huge.cnf for very big sites, many visitors at day or at some time.
/usr/local/share/mysql/my-innodb-heavy-4G.cnf, I don't know about this.
/usr/local/share/mysql/my-large.cnf for big sites.
/usr/local/share/mysql/my-medium.cnf if you have acceptable number of visitor's.
/usr/local/share/mysql/my-small.cnf if you run it in local host and you use only for testing.
This configuration are made to be as template to start with it, you can modifier it at time.
Thanks SirDice! In this case which one you suggest to copy to /usr/local/etc/my.cnf?
Click to expand...
Depend in your number of visitors of yours, at start you can begin with small configuration later use another configuration if you want.
 
Note: you don't need a /usr/local/etc/my.cnf. It doesn't need to exist.
 
DutchDaemon said:
It simply uses its built-in defaults.
Click to expand...

And why the hell you should be happy with defaults? I've come here just to increase the connection limit, and actually a huge profile suits me more because the database goes down or goes out of connection limit.
 
The discussion is not about being happy with the defaults but where they could be found if you need to look them up.
 
You must log in or register to reply here.
Back
Top