We have a database with around 290 MB in size running MySQL 5.5.37 using innodb tables.
The server config is: 20 Core Processor – 64GB Ram - SSD Disk.
what would be the best mysql configuration you suggest for Fast Query Processing and best Caching.
installed wordpress using with nginx fastcgi_cache (ee installation only ) [has memcached - ubuntu 64x].
Suggestions are really appreciated to improve query speed and cache performance
(80% read and 20% write) Thanks!