Web Hosting Talk : Web Hosting Main Forums : Web Hosting : Mysql Issue

[paraghost]

Hello,

We have issue with mysql is cpu utilization process all ways goes high on linux server.

Where can i find cpu utilization log files?

How can i resolved this issue?

Thanks,

[qtriangle]

see it using "ps" command.
You may need to restart mysql daemon.
May be some customer of yours is abusing it.

[MikeDVB]

MyTOP is one good way to see what queries are being executed that are causing issues. It's not installed by default so you'll have to download and install it.

[paraghost]

Hello,

I use to mysqladmin processlist command check it.

However its not use.

Can you tell how can i find which mysql process is causing for it.

Where cpu utilization log files can you provide the address?

Thanks

[MikeDVB]

If the MySQL CPU usage is high then it's one of two things generally:

1. Several intense queries taking a long time to execute - this would be obvious in the processlist from MySQL.
2. A *ton* of small queries, this isn't obvious from the processlist usually but you can see the queries per second with "mysqladmin status".

[paraghost]

Hello,

How can i find particular mysql process is causing for high cpu utilization?

Where cpu utilization log files can you provide the address?

Thanks

[MikeDVB]

Originally Posted by paraghost

How can i find particular mysql process is causing for high cpu utilization?

mytop or the MySQL show process list.

Originally Posted by paraghost

Where cpu utilization log files can you provide the address?

There aren't any.

Originally Posted by paraghost

Thanks

Welcome.

[paraghost]

Hello,

Both commands are not working.

Please advise

[MikeDVB]

Well MyTOP has to be installed, it's not installed by default and you said above "I use to mysqladmin processlist command check it." so I sort of assumed you knew how to view the process list.

I'd suggest hiring a server administration company at this point as it sounds like you're in over your head when it comes to diagnosing this.

[paraghost]

Hello,

Is there any way to resolve this issue?

By any command or log file?

[Matt R]

Originally Posted by paraghost

Hello,

Is there any way to resolve this issue?

By any command or log file?

I couldn't agree with Mike more in this case. At this point, it's obvious that you don't know what you're doing. I'd suggest hiring a management company like Platinum Server Management or BX Server Management.

Doing it yourself just isn't working out, and no matter how many times we point you in the right direction, short of doing it for you you're likely not going to get it any time soon.

[MikeDVB]

If only it were that simple, but no... Generally there isn't any command you can run to easily diagnose MySQL abuse.

You can run this to see the active queries at the point you run the command:

mysql -e 'show processlist;'

You can run this to see the queries per second:

mysqladmin status

How you use/interpret that information to resolve your issues is what becomes important... I can give you all the data in the world but if you don't know how to use it - it won't do you any good.

Again, I'd suggest hiring a server administrator to look into this and resolve this for you.

[paraghost]

Hello,

We have got the result of mysql -e 'show processlist;'

As +--------+--------------+-----------+----------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+--------------+-----------+----------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
| 225341 | DELAYED | localhost | atworkbe_stats | Delayed insert | 283 | Waiting for INSERT |

Is it means the database as atworkbe_stats is causing for the high cpu utilization?

Please advise

[MikeDVB]

No, it doesn't... I normally try to be as nice as I possibly can be but it's obvious you have no idea what you're doing.

Hire a server administrator to help you with this.

[paraghost]

Hello,

However its increasing Delayed insert for the database as atworkbe_stats

Please advise