Want more timely Centmin Mod News Updates?
Become a Member

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:21 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,917
    12,281
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,868
    Local Time:
    8:21 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:21 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:21 PM
    1.9.10
    10.1.11
    There is no problem until this time, so it may enabling safely i think.