Check MySQL CPU Usage (internally)

Question

From outside MySQL, I know I can do many things to know what the CPU usage of a process is, ie. top.

But, from an internal standpoint, I would like to know if it is possible to run a query from MySQL to know what the system CPU is or the CPU consumption of the current thread is.

I'm running massive queries nightly through the Event Scheduler and my DB server gets stuck at 100% CPU for a few minutes blocking or slowing down users around the globe.

I've tried to research a way to limit CPU usage by thread or user, but it doesn't seem to be possible yet.

So, I'm trying to do something along the lines of the following in my Event:

IF (SELECT CPU_USAGE() > 0.8) THEN
    REPEAT
        SLEEP(0.01);
    UNTIL (SELECT CPU_USAGE() < 0.25)
    END REPEAT;
END IF;

Obviously CPU_USAGE() doesn't exist, but if there is something similar I can do to accomplish a similar effect, I'm all ears. Thanks.

P.S. I'm on Amazon RDS

It might be easier/better to limit the number of threads your tasks can use at a given time. — Vatev
– Vatev, Commented Mar 24, 2014 at 15:21

Cedric Simon · Accepted Answer · 2014-03-24 15:20:52Z

2

I am afraid there is no such option select option natively in MySQL.

If you are inside mysql client command line, you can call the "top" command from inside the MySQL client using this command : \! top, but I don't think this is what you need.

The best answer is probably to use a UDF from SYS functions. More info here. I have no experience using it but it seems the closest to what you need.

answered Mar 24, 2014 at 15:20

Cedric Simon

4,6694 gold badges43 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kevin Jose Martin Over a year ago

This would be great in an ideal situation and maybe in the future, but I am on Amazon RDS which unfortunately doesn't allow me to import those UDF's.

Collectives™ on Stack Overflow

Check MySQL CPU Usage (internally)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related