ow
(http://i.imgur.com/ET2yI7t.png)
should be FINE now
or not
christ
mysql decided to degrade today or something (ongoing phenomenon)
I reverted all settings
-------- Performance Metrics -------------------------------------------------
[--] Up for: 59m 16s (17K q [4.972 qps], 461 conn, TX: 42M, RX: 3M)
[--] Reads / Writes: 88% / 12%
[--] Total buffers: 168.0M global + 2.8M per thread (151 max threads)
[OK] Maximum possible memory usage: 583.2M (31% of installed RAM)
[OK] Slow queries: 0% (0/17K)
[OK] Highest usage of available connections: 9% (15/151)
[OK] Key buffer size / total MyISAM indexes: 8.0M/8.0M
[OK] Key buffer hit rate: 99.4% (83K cached / 478 reads)
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 644 sorts)
[!!] Temporary tables created on disk: 36% (158 on disk / 431 total)
[!!] Thread cache is disabled
[OK] Table cache hit rate: 81% (81 open / 100 opened)
[OK] Open file limit used: 6% (62/1K)
[OK] Table locks acquired immediately: 100% (20K immediate / 20K locks)
[!!] InnoDB buffer pool / data size: 128.0M/645.4M
[OK] InnoDB log waits: 0
Need 24 hours of data then will optimize again
going to look at getting rid of this innodb/isam bs doodthing;