• Kristofer Pettersson's avatar
    Bug#37416 When SQL_NO_CACHE is used, MySQL still lookup into the query cache · 5c42a6cf
    Kristofer Pettersson authored
                
    The query cache module did not check for the SQL_NO_CACHE keyword before
    attempting to query the hash lookup table. This had a small performance impact.
    
    By introducing a check on the query string before obtaining the hash mutex
    we can gain some performance if the SQL_NO_CACHE directive is used often.
    
    
    sql/sql_cache.cc:
      * Introduced new helper function, has_no_cache_directive, for checking the
        existance of a SQL_NO_CACHE directive before actual parsing of the query.
    5c42a6cf
sql_cache.cc 143 KB