I’m running a small MySQL database on the $10/mo server (1GB memory/1 core) and every time I do a “top” & look at NewRelic server monitor, the system is reporting mysql is running at 97-100% CPU.
All the queries seem to be running ok and returning properly. Is there something I should be doing like upgrading to a larger plan? I’m very concerned about the 100% CPU and not really sure what that means.
I have 2 databases running and they report (in terms of size)
SELECT table_schema “DB Name”, Round(Sum(data_length + index_length) / 1024 / 1024, 1) “DB Size in MB” FROM information_schema.tables GROUP BY table_schema;
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.