Mysql Optimization

Posted in: Newspaper
Post count: 3
abmra
#263122
Nov 21, 2018 at 8:22 am

Hi,

We are using newspaper theme on our site.

We have following configuration for our VM:

10 gb ram, 4 Core CPU.

Our CPU usage goes 100% on specific period like 10.00 am to 11.00 am.

Mysql consuming more cpu usage around 150% to 300% on that period out of 4 CPU core.

Please help us how could we solve this issue or how we optimize mysql.

Thanks,
Abmra.

Post count: 35449
Calin
#263199
Nov 21, 2018 at 1:43 pm

Hi,

Please read this documentation about How to Enable the query cache in MySQL -> http://www.aodba.com/enable-query-cache-mysql/
Please tread thsi documentation about How to Optimize Your WordPress Database with One Click:
https://www.wpbeginner.com/plugins/optimize-your-wordpress-database-with-one-click/
Hope this will help you.

Thank you.

Viewing 2 posts - 1 through 2 (of 2 total)
The forum ‘Newspaper’ is closed to new topics and replies.