1. 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?

Discussion in 'Server Configuration and Hosting' started by Moshe1010, Jun 21, 2015.

  1. Moshe1010

    Moshe1010 Well-Known Member

    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.
  2. Slavik

    Slavik XenForo Moderator Staff Member

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

    Set3sh Active Member


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

    Kind regards,
  4. Moscato

    Moscato Active Member

    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.
    Set3sh likes this.

Share This Page