where is the mysql cache?

[mer2]

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

 

[cPanelMichael]

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.

 

[mer2]

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?

 

[cPanelMichael]

Hello

cPanel does not configure that value in your /etc/my.cnf file. It's documented here if you want to read about what exactly it does:

MySQL :: MySQL 5.5 Reference Manual :: 8.9.3.3 Query Cache Configuration

Thank you.

 

[mer2]

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

 

[cPanelMichael]

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.

 

[feldon27]

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.

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.