Does caching Innodb really matter?

[Moshe1010]

I did several speed tests via chrome inspect elements and some speed flow charts with different websites. I couldn't really find any significant difference between caching my database (2GB) or not. Has somebody did here some benchmarks to check how significant is it? I'm wondering if I should disable it or not since it consumes tons of RAM.

 

[Slavik]

I did several speed tests via chrome inspect elements and some speed flow charts with different websites. I couldn't really find any significant difference between caching my database (2GB) or not. Has somebody did here some benchmarks to check how significant is it? I'm wondering if I should disable it or not since it consumes tons of RAM.

If you have a small site with low activity the difference will be un-noticeable.

 

[PlayStage]

Hello,

Caching queries results performed on InnoDB tables is pointless because of innodb_buffer_pool_size variable.


Kind regards,
George.

 

[Moscato]

You will want basic file caching, xenforo caching, and innodb_buffer_pool_size all set correctly.

Query cache actually can slow your DB down under some circumstances.