How to find out why the MySQL server is causing a high level of CPU usage?




  • Avatar
    Mike Rodriguez (Edited )

    A few other points specific to high CPU usage:

    1. Make sure your queries are properly using indexes

    2. Make sure innodb_buffer_pool_size is 80% of available memory on server

    3. Try using Dynimizer. It's a JIT compiler for MySQL and some other programs. Can significantly improve CPU efficiency of MySQL:

    4. If all else fails then definitely see if upgrading to a server with more cores helps. The latest versions of MySQL scale well with many cores.

  • Avatar
    Artyom Baranov

    @Mike Rodriguez,

    Thanks for the advice! I believe it will be helpful for other Pleskians.

Please sign in to leave a comment.

Have more questions? Submit a request