• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Does caching Innodb really matter?

Moshe1010

Well-known member
#1
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

XenForo moderator
Staff member
#2
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.
 

Set3sh

Active member
#3
Hello,

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


Kind regards,
George.
 

Moscato

Active member
#4
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.