Hi guys,
I have a few huge databases with 6000+ tables in it so everytime i try to load one of then with phpmyadmin it takes from 3secs to a whole minute to load. I noticed this is related to table_open_cache, because phpmyadmin needs to open all tables in that particular database, so, i reised my table_open_cache to those values:
table_open_cache=16384
table_definition_cache=16384
It worked for a while(consuming almost 1gb of ram in the meantime), but eventually my opened tables filled up and again it took a minute to load phpmyadmin.
So, what's my problem? Is phpmyadmin just inneficient? Is there some option to fix it? Is 6k+ tables too much? Thanks!!
I have a few huge databases with 6000+ tables in it so everytime i try to load one of then with phpmyadmin it takes from 3secs to a whole minute to load. I noticed this is related to table_open_cache, because phpmyadmin needs to open all tables in that particular database, so, i reised my table_open_cache to those values:
table_open_cache=16384
table_definition_cache=16384
It worked for a while(consuming almost 1gb of ram in the meantime), but eventually my opened tables filled up and again it took a minute to load phpmyadmin.
So, what's my problem? Is phpmyadmin just inneficient? Is there some option to fix it? Is 6k+ tables too much? Thanks!!