search

souravventuras / Class_PF_Testing

0 stars 0 forks source link

MYSQL is taking too much CPU at the Server #98

Open sowadalmughni opened 7 years ago

sowadalmughni commented 7 years ago

screenshot 2016-12-04 15 42 05

We turned on the MySQL Slow Query log to keep an eye on any queries that take a long time - to find any queries locking up key tables for too long.

Also, monitoring the process list, buffer sizes, table cache, query cache and innodb_buffer_pool_size (the memory allocations can have an affect on query performance which can cause MySQL to eat up CPU). We probably have to set them up manually.

Good Read: http://dev.mysql.com/doc/refman/5.7/en/memory-use.html http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html

sowadalmughni commented 7 years ago

Problem to be solved: Server side slow response.

Possible Solution: Find out slow queries and optimize the queries.

Timeline: This is a continuous process.

screenshot 2016-12-05 17 03 27

Progress so far.

sowadalmughni commented 7 years ago

Looking into

https://github.com/box/Anemometer

To see if we can implement it into our project.

sowadalmughni commented 7 years ago

Issue still isn't fixed.