Discover Centmin Mod today
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 Member

    216
    21
    18
    Apr 11, 2015
    Ratings:
    +49
    Local Time:
    5:29 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

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    12:29 AM
    Nginx 1.13.x
    MariaDB 5.5
    trial and error, see if it's best for your usage :)
     
  3. negative

    negative Member

    216
    21
    18
    Apr 11, 2015
    Ratings:
    +49
    Local Time:
    5:29 PM
    1.9.10
    10.1.11
    I enabled it and testing on xenforo + wordpress real time. we will look then :)
     
    • Creative Creative x 1
  4. negative

    negative Member

    216
    21
    18
    Apr 11, 2015
    Ratings:
    +49
    Local Time:
    5:29 PM
    1.9.10
    10.1.11
    There is no problem until this time, so it may enabling safely i think.
     
    • Informative Informative x 1