Make WordPress Core

Changes between Version 1 and Version 2 of Ticket #24044, comment 54


Ignore:
Timestamp:
08/24/2016 01:38:57 PM (8 years ago)
Author:
jkhongusc
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #24044, comment 54

    v1 v2  
    1111huge database server sized for our usage + growth (8 vCPUs, 16GB RAM)
    1212
    13 One day our database CPU went to 100%.  I noticed lots of slow queries (doing full table scans) -
     13One day our database CPU went to 100%.  I noticed lots of slow queries doing full table scans.  When I ran 'show processlist' I saw hundreds of these -
    1414SELECT option_name, option_value FROM mywp_options WHERE autoload = 'yes';
    1515I immediately dropped an index on it and the cpu usage went from 100% to under 5%: