Portal Home > Knowledgebase > Articles Database > mysql for high traffic
mysql for high traffic
| Posted by mystycs, 04-12-2010, 09:33 AM |
| My VPS has a fresh install of Mysql, is there anything i have to change such as max connections or what not to handle a high traffic site with a bunch of users, or should i leave it as is?
|
| Posted by madaboutlinux, 04-12-2010, 09:59 AM |
| If the traffic you are expecting is very low, you can leave the default settings as it is...
Also setting parameters in my.cnf entirely depends on the number of websites hosted, the processing time of queries that will be executed and above all the traffic you are expecting. But for now, it is ok to leave the default settings for a low traffic website.
|
| Posted by vapetrov, 04-12-2010, 12:58 PM |
| First day run mysql with default setting.
Than run mysqltuner.pl (download it from http://mysqltuner.pl/). It will recommend you optimal parameters.
But read manual and think a lot before set any parameter - this is best way to high performance
|
| Posted by shawn_linux, 04-13-2010, 09:56 AM |
| enable mysql caching to reduce this will help in making vps faster.
|
| Posted by assistanz247, 04-13-2010, 10:22 AM |
| Do not allow MySQL persistent connections [pconnect()] and optimizing Query Cache etc will add more performance.
|
Add to Favourites 
Print this Article
Also Read
