Portal Home > Knowledgebase > Articles Database > large server: get rigth setting for mysql my.conf
large server: get rigth setting for mysql my.conf
Posted by aussie_dude, 11-10-2007, 09:13 PM |
hi guys,
i was wondering if someone could give me some suggestion/feedback on optimizing mysql
My server specs:
my.conf file:
is this good enough or we could fine tunning it more?
thanks guys
|
Posted by activelobby4u, 11-10-2007, 09:26 PM |
Mysql optimization is a continuous process and you need to monitor it over next 48 hours (if you have already optimized it), by logging the slow queries and verifying the queries during the peak times.
The parameters you have used are fine, but you will need to monitor it over time as the best configuration for "a" server may not be that good for another.
|
Posted by blessen, 11-11-2007, 07:46 AM |
My suggestion will be to have a good and experienced DBA to check your servers. He/She will be of great help to you.
|
Add to Favourites Print this Article
Also Read