Tuesday, August 11, 2020
dbametrix
More
    Home Database Technology Query 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

    0
    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    ASM Disk creation issue

    The article explains how to troubleshoot Oracle ASM disk creation. Solution of Oracle ASM disk creation with ASMLIB

    Oracle Tuning Basics Part-2

    This is the 2nd part of Oracle database tuning basics including depth of every aspects.

    Oracle Tuning Basics Part-1

    The article explains Oracle database performance tuning basics details.

    When you finding new job

    The article guides you 10 things to remember when you are searching a new job to improve yourself including skills and better growth for every DBA.

    Recent Comments