I couldn't find answer for my situation.
I have a windows server 2008 with 2 cores and 7 GB RAM (Azure D1 VM).
I'm running mariadb 10.0.14 on it. I have 2 databases (1.5GB and 9GB in size).
Statistics are in general:
AVG 1192590 SELECTs per hour (70% of all)
AVG 163555 UPDATEs per hour (10% of all)
AVG 87728 INSERTs per hour (5% of all)
AVG 5920 DELETEs per hour (0.3% of all)
innodb_buffer_pool_size set=4G and the whole server was running terribly slow.
CPU was utilized avg 10-15% but queries was executed very slowly.
Now I have set
innodb_buffer_pool_size=1G and it's running much much faster.
The interesting this is that I have commited 1,5 GB RAM by mysqld.exe
So 5 GB RAM are still free.
- Why setting innodb_buffer_pool_size larger means slower queries?
- What should I configure more to use this free RAM to gain more performance on mysql (mariadb)?