Join the community today
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

    55,944
    12,283
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,870
    Local Time:
    7:35 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  2. pamamolf

    pamamolf Well-Known Member

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +838
    Local Time:
    12:35 PM
    Nginx-1.26.x
    MariaDB 10.6.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?
     
  3. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    12:35 PM
    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

    55,944
    12,283
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,870
    Local Time:
    7:35 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    fixed
    see Mysqltuner | Centmin Mod Community
     
  5. rdan

    rdan Well-Known Member

    5,451
    1,412
    113
    May 25, 2014
    Ratings:
    +2,206
    Local Time:
    5:35 PM
    Mainline
    10.2
    Mine was:
     
  6. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    12:35 PM
    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

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +838
    Local Time:
    12:35 PM
    Nginx-1.26.x
    MariaDB 10.6.x
    We need a benchmark for this :)
     
  8. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    12:35 PM
    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

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +838
    Local Time:
    12:35 PM
    Nginx-1.26.x
    MariaDB 10.6.x
    Don't know :(
     
  10. rdan

    rdan Well-Known Member

    5,451
    1,412
    113
    May 25, 2014
    Ratings:
    +2,206
    Local Time:
    5:35 PM
    Mainline
    10.2
    Be sure almost all of your tables are on Innodb and nothing on MyIsam.