Tuesday, October 20, 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

    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Differences Raw Device, ASM Device and CFS

    The article explains basic differences of ASM device, raw device and Oracle cluster file system cfs with fundamentals

    What is a Database Administrator?

    The blog post explains what is the work of database administrator called DBA in database domain and what is the importance.

    Top Reasons to Implement Remote Database Monitoring

    The blog post explains top three reasons and ideas to get remote monitoring services from outer support company.

    Recent Comments