James Bachini

innodb_buffer_pool

  • High CPU usage on mysqld but low memory usage

    Had a problem with a server that was running alot of traffic and doing a lot of logging and updating mysql tables. The CPU usage was through the roof and it’s an 8 core server with 30GB of RAM. The strange thing was that mysqld was using all the processing power but hardly any memory…