Welcome to Centmin Mod Community
Register Now

MariaDB Do you advice query-cache-strip-comments parameter ?

Discussion in 'MariaDB & General MySQL news & discussions' started by negative, Jan 29, 2016.

  1. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    1:02 PM
    1.9.10
    10.1.11
    Hello


    I have seen the query-cache-strip-comments parameter in my.cnf and it disabled default. I research about that parameter and this variable is great for those who want to append comments to various queries, but still want the query cache to be able to serve such queries.

    So what do you think about this ?

    query-cache-strip-comments = 1
     
  2. eva2000

    eva2000 Administrator Staff Member

    55,417
    12,256
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,837
    Local Time:
    8:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    trial and error, see if it's best for your usage :)
     
  3. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    1:02 PM
    1.9.10
    10.1.11
    I enabled it and testing on xenforo + wordpress real time. we will look then :)
     
  4. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    1:02 PM
    1.9.10
    10.1.11
    There is no problem until this time, so it may enabling safely i think.