where is the mysql cache?

mer2

Member
Sep 28, 2013
9
0
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,229
463
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

Member
Sep 28, 2013
9
0
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?
 

mer2

Member
Sep 28, 2013
9
0
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,229
463
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

Well-Known Member
Mar 12, 2003
122
15
168
Houston, TX
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.