WordPress.org
Get WordPress

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #24044, comment 43


Ignore:
Timestamp:
09/02/2015 07:13:16 PM (9 years ago)
Author:
dandruczyk
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #24044, comment 43

    initial v1  
    11I was having unusual (and climbing) CPU usages and frequent showings in the slow query log of this query, so I added the index for each Wordpress blog on my SQL server (118 of them),   CPU usage for MySQL alone dropped by a factor of 3+  (from about 30-35% to 10%).  NO OTHER changes were made..
    22
    3 The databases are a mix of MyISAM (older blogs) and InnoDB (newer ones).  MySQL is 5.5.44 running on Ubuntu 14.04 64 bit on a VMware ESXi host backed by enterprise grade SAN storage.  The MySQL server is quad (virtual) core, 8GB ram.
     3The databases are a mix of MyISAM (older blogs) and InnoDB (newer ones), ALL blogs except 1 are current Wordpress 4.3.  MySQL is 5.5.44 running on Ubuntu 14.04 64 bit on a VMware ESXi host backed by enterprise grade SAN storage.  The MySQL server is quad (virtual) core, 8GB ram.
    44
    55The change to all blogs was made at 13:20 (see picture linked below).  The remaining blogs had the index added over a 10 minute period starting around 13:30