Welcome to Centmin Mod Community
Register Now

Beta Branch disable query_cache with mariadb 10.1 default installs

Discussion in 'Centmin Mod Github Commits' started by eva2000, Mar 22, 2016.

  1. eva2000

    eva2000 Administrator Staff Member

    30,992
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,423
    Local Time:
    4:24 PM
    Nginx 1.13.x
    MariaDB 5.5
    • Like Like x 3
    • Informative Informative x 1
  2. pamamolf

    pamamolf Well-Known Member

    2,825
    253
    83
    May 31, 2014
    Ratings:
    +449
    Local Time:
    8:24 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    For me this one was not able to disable it:

    Code:
    query_cache_type = 0
    at least mysqltuner can't see it as disable.....

    I had to set to 0 also this:

    Code:
    query_cache_size = 0
    Then all ok :)

    Maybe you must set this also to 0 on the Centminmod mycnf templates?
     
    • Informative Informative x 1
  3. negative

    negative Member

    217
    22
    18
    Apr 11, 2015
    Ratings:
    +50
    Local Time:
    8:24 AM
    1.9.10
    10.1.11
    So, do you advice to disable query_cache on innodb tables in mariadb ?

    I have about 10gigabyte innodb database on my xenforo board and using query_cache with very big config size. :confused:
     
  4. eva2000

    eva2000 Administrator Staff Member

    30,992
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,423
    Local Time:
    4:24 PM
    Nginx 1.13.x
    MariaDB 5.5
    fixed
    see Mysqltuner | Centmin Mod Community
     
  5. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    2:24 PM
    1.11
    10.2
    Mine was:
     
  6. negative

    negative Member

    217
    22
    18
    Apr 11, 2015
    Ratings:
    +50
    Local Time:
    8:24 AM
    1.9.10
    10.1.11
    I tried a few days disabled the query_cache but i observe the negative effect on performance. I didn't any test but i feel the latency while open the thread_view pages especially. So i enabled it again. My database server only runs the mariadb and has 48gb of ram so cache maybe better, i don't know :)
     
  7. pamamolf

    pamamolf Well-Known Member

    2,825
    253
    83
    May 31, 2014
    Ratings:
    +449
    Local Time:
    8:24 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    We need a benchmark for this :)
     
  8. negative

    negative Member

    217
    22
    18
    Apr 11, 2015
    Ratings:
    +50
    Local Time:
    8:24 AM
    1.9.10
    10.1.11
    How can i benchmark it ? If you tell me a way, then i can do it and share with you. But personally, i see that page generate times some increased after query_cache disabled.
     
  9. pamamolf

    pamamolf Well-Known Member

    2,825
    253
    83
    May 31, 2014
    Ratings:
    +449
    Local Time:
    8:24 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    Don't know :(
     
  10. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    2:24 PM
    1.11
    10.2
    Be sure almost all of your tables are on Innodb and nothing on MyIsam.