Changes between Version 1 and Version 2 of Ticket #24044, comment 54
- Timestamp:
- 08/24/2016 01:38:57 PM (8 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #24044, comment 54
v1 v2 11 11 huge database server sized for our usage + growth (8 vCPUs, 16GB RAM) 12 12 13 One day our database CPU went to 100%. I noticed lots of slow queries (doing full table scans)-13 One 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 - 14 14 SELECT option_name, option_value FROM mywp_options WHERE autoload = 'yes'; 15 15 I immediately dropped an index on it and the cpu usage went from 100% to under 5%: