Wednesday, December 8, 2021
dbametrix
More
    HomeDatabase TechnologyQuery Cache in MySQL

    Query Cache in MySQL

    Hi friends,

    MySQL stores every SQL text and results of the same in memory. When identical SQL text executes again that time MySQL retrieves data from CACHE and provides output. Indeed memory scan is faster than a disk scan.

    - Advertisement -
    dbametrix

    This CACHE called QUERY CACHE.

    For enabling Query Cache in MySQL.
    Modify my.cnf with the following parameters.

    Set query_cache_type = 0 means it is disabled
    Set query_cache_type = 1 means it is enabled
    Set query_cache_type = 2 means it is enabled but works on demand

    Another parameter is query_cache_size. This parameter stands for the total size of the Query Cache.
    for better performance, we can set it to 25MB. Modify this parameter in my.cnf and put bytes.

    - Advertisement -
    dbametrix

    Thanks and regards,

    Remote Assistance DBA team

    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    Recent Comments