Mysql Windows Performance Problem
I will be crazy. Only 20k line data and 10 online client how can be slow like fax :S
My system uses SSD disk.
SHOW GLOBAL STATUS pastebin.com/gLvTkZ6s
SHOW GLOBAL VARIABLES pastebin.com/UcJkxRKb
SHOW FULL PROCESSLIST pastebin.com/AaWGFurJ
SHOW ENGINE INNODB STATUS pastebin.com/aQYLW1FH
SELECT name, count FROM information_schema.innodb_metrics ORDER BY name pastebin.com/Wdz1WhU6My
My system generates query like : SELECT count(id) FROM gr_msgs WHERE gid = '1-573' AND id &gt; '5989' gr_msgs