The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

where is the mysql cache?

Discussion in 'Database Discussions' started by mer2, May 22, 2014.

  1. mer2

    mer2 Member

    Joined:
    Sep 28, 2013
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    In the folder var/lib/mysql there is the db's folder;
    if I delete all the inner files and remain only the folder void the site work however;
    I suppose that use a cache; where is?

    I need delete the db's inner files, directly and not using cpanel;I need to do test with the same db with
    defferent files version
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you elaborate on what specific cache you are looking for? You should delete the databases through cPanel or via:

    /scripts/dropmysqldb

    This will ensure it's correctly removed.

    Thank you.
     
  3. mer2

    mer2 Member

    Joined:
    Sep 28, 2013
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    type cache not know (third part code)

    in the my.cnf I have this
    [mysqld]
    collation_server = utf8_general_ci
    character_set_server = utf8
    default-storage-engine=MYISAM
    query_cache_type = 0


    why also if I have the query_cache_type = 0
    the cache remain always? I need use other code?
    I have mysql 5.5.36-cll

    I tested also to use in the mysql prompt the command
    RESET QUERY CACHE; but not work



    other in the my.cnf I have default-storage-engine=MYISAM but with SHOW VARIABLES LIKE "%version%"; I read this


    +-------------------------+------------------------------+
    | Variable_name | Value |
    +-------------------------+------------------------------+
    | innodb_version | 5.5.36 |
    |
    | version | 5.5.36-cll |


    is there in cpanel or whm code that override my.cnf?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  5. mer2

    mer2 Member

    Joined:
    Sep 28, 2013
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    the only solution for delete the db's cache is delete the db by cpanel and recreate the db?


    I tested this query_cache_type = 0
    and
    mysql prompt the command
    RESET QUERY CACHE; but not work
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    I'm not sure what you mean when you refer to deleting a database's cache. What specifically are you referring to, and what's it's purpose?

    Thank you.
     
  7. feldon27

    feldon27 Well-Known Member

    Joined:
    Mar 12, 2003
    Messages:
    111
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Houston, TX
    Clearing a database's (or table's) cache is CRUCIAL for performance testing. The first time you run a poorly coded query it might take 40 seconds. The second time you run it, it might come back in .15 seconds. Being able to clear the cache is absolutely necessary.

    That said, I've tried RESET QUERY CACHE, FLUSH TABLES, etc. and none of it works. Next step is to delete the actual cache files in the folder. Amazing that MySQL takes such brute force to get it to let go of its cache files.
     
Loading...

Share This Page