How do i rectify the mysql problem

A

algore

Verified User
Joined
Aug 9, 2007
Messages
13
Why Do i face the same problem again and again

I am using a VPS ( Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz ) 8 cores of 1.1 Ghz and 2 gb dedicated ram

I don't even know why this happens .. please see the pic below

Why do i see too many mysql processes



Can anyone please tell me what is happening to mysql and httpd here

I basically use a forum ( ipb ) and an imagehost with decent traffic

Thx graphs are below ( 1 day cpu and memory usage )



Can u please solve the problem
 
I'm not sure of your question here?

It looks like you have some decent traffic on your forum, what is the issue exactly?

From the looks of it, you have approx 120 simultaneous users... that's on the high side for a vps though.
 
But why do the mysql go crazy and the sites are all down as they cant utilize the mysql resource and i have to restart httpd and also stop and then start mysql
 
Have you created an optimized my.cnf file based on your usage?

You write:
I am using a VPS ( Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz ) 8 cores of 1.1 Ghz and 2 gb dedicated ram
Click to expand...
Do you mean you get 2gb of guaranteed ram? Do you get even one full core? Your spec doesn't make much sense to me; I don't understand how you can get 1.1 GHz cores out of a 2.6GH i7 CPU.

If you continue to have the problem even with an optimized my.cnf file then you should probably bring up the issue with your VPS provider.
Can u please solve the problem
Click to expand...
I hope you're not really expecting one of us to solve your problem.

Jeff
 
Hello ,

I am not sure but from the images I can only say that your mysql configuration is not correct there are may queries which are in locked status and sleeping status . You can decrease the time out value and also you can decrease max_user conection value . If these values are not there in your my.cnf then provide these value (sufficient) .
 
pratapsingh said:
Hello ,

I am not sure but from the images I can only say that your mysql configuration is not correct there are may queries which are in locked status and sleeping status . You can decrease the time out value and also you can decrease max_user connection value . If these values are not there in your my.cnf then provide these value (sufficient) .
Click to expand...

How ... i am a noob can u tell me the steps .. i can do it myself

how do i provide the my.cnf values

If you continue to have the problem even with an optimized my.cnf file then you should probably bring up the issue with your VPS provider.
Click to expand...

How do i optimize the my.cnf

Where can i find my.cnf

If its /etc/my.cnf [ I used HyperVM to navigate to this path ]

I only see 2 entries here

[mysqld]
local-infile=0

That's it
 
Last edited:
I am using a VPS ( Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz ) 8 cores of 1.1 Ghz and 2 gb dedicated ram
Click to expand...

I mean the dedicated dox specs are Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz

I see in my DA

Intel(R) Core(TM) i7 CPU 920 8 times with 1.1 Ghz each

Yes i have garanteed 2 GB ram with 3 GB burstable

The MySQL is going crazy day by day ... every time i have to restart the httpd services to get things back to normal

I have good traffic ... i am running an IPB forum ( abt 80 to 120 people online ) and 1 image hosting site ( abt 50 to 80 users online )

The load of server goes max to 5 that too sometimes ...

I hope u understand i cant monitor my site 24 hrs a day

Things are going worse regularly
 
Last edited:
200 users at the same time is pushing a vps to its limits in most cases. You might want to cinsider a dedicated box.
 
The poster and I have discussed this off-forum. He doesn't know how much of a core he's got, and that's really the key; he's got 2G of dedicated memory. I have a friend who runs huge multi-core servers and rents out dedicated VPS instances which have greater capacity than most of my servers, so while you're probably right, it may be too broad a statement.

Jeff
 
You must log in or register to reply here.
Back
Top