Optimize MySQL

H

hammerfall

Verified User
Joined
Mar 25, 2007
Messages
15
my config is

http://help.directadmin.com/item.php?id=44


But the server is overloaded at times much traffic



info sever



Processor Name Intel(R) Pentium(R) 4 CPU 3.00GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 2994.598
Processor Name Intel(R) Pentium(R) 4 CPU 3.00GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 2994.598
Total Memory 2066812 kB
Free Memory 699568 kB
Total Swap Memory 2031608 kB
Free Swap Memory 2017992 kB
MySQL 4.1.22
DirectAdmin 1.31.0


As Optimize configuration in my.cnf ??

I speak little English sorry

thanks
 
There really isn't a simple answer; it all depends on the mix of domains you have on your servers, how much they use MySQL, where the load issues are, etc.

You should probably start by finding in these forums the posts concerning the change you can make so that you can see which MySQL requests are taking too long to process.

Then you might have an idea of what configuration setting you'd need to change. Nothing like a good MySQL book to give you some insight, or perhaps find and hire a good MySQL administrator to watch your server for a period of time and make some recommendations.

Jeff
 
Quick question with all this.

One of my clients experienced a too many [concurrent] connections error message a few weeks ago [he forgot to mention it] so obviously was a one off but its made me think about optimising mysql a bit.

Now, as i understand it, you dont have to specify all the options in the /etc/my.cnf option file, so i was wondering if anyone has any suggestions on how i should proceed to tackle this?

I havent looked up yet [as he has only just mentioned it] the default amount of concurrent connections but i wonder if just upping this a bit might be a good idea?

I was looking at this post [ http://www.directadmin.com/forum/showpost.php?p=105266&postcount=87 ] and thinking that ,aybe i should implement part of this.

Not really knowing a great deal on the options of mysql, is it safer to inplement the whole file [with a few changes i.e. thread_concurrency=4 as i have a dual core cpu] or just part of it, leaving the rest as default?

I didnt want to implement just a bit, without knowing whether its good practice to do so, which is why i thought i'd ask first ;)

Many thanks if anyone can help me with this.

My server is a AMD Athlon 64 X2 4200+ with 1Gig [soon to be 2Gig] of RAM.

Cheers
Nath.
 
tarquel said:
Quick question with all this.

One of my clients experienced a too many [concurrent] connections error message a few weeks ago [he forgot to mention it] so obviously was a one off but its made me think about optimising mysql a bit.

Now, as i understand it, you dont have to specify all the options in the /etc/my.cnf option file, so i was wondering if anyone has any suggestions on how i should proceed to tackle this?

I havent looked up yet [as he has only just mentioned it] the default amount of concurrent connections but i wonder if just upping this a bit might be a good idea?

I was looking at this post [ http://www.directadmin.com/forum/showpost.php?p=105266&postcount=87 ] and thinking that ,aybe i should implement part of this.

Not really knowing a great deal on the options of mysql, is it safer to inplement the whole file [with a few changes i.e. thread_concurrency=4 as i have a dual core cpu] or just part of it, leaving the rest as default?

I didnt want to implement just a bit, without knowing whether its good practice to do so, which is why i thought i'd ask first ;)

Many thanks if anyone can help me with this.

My server is a AMD Athlon 64 X2 4200+ with 1Gig [soon to be 2Gig] of RAM.

Cheers
Nath.
Click to expand...
Yes. its a good practise to follow that optimisation method.
 
You must log in or register to reply here.
Back
Top