Recently I discovered our MySQL 5.6 database is not using any query caching and I wanted to change that.
[mysqld] query_cache_type = 1 query_cache_size = 50M query_cache_limit = 2M
to a file called my-default.ini which is located under
C:\Program Files\MySQL\MySQL Server 5.6. I could not find any other .ini file or .cnf file in any directory, and this computer does not have a
C:\ProgramData directory where I usually would find it.
SHOW VARIABLES LIKE 'have_query_cache' does show
have_query_cache YES. But
SHOW VARIABLES LIKEquery_cache_type
. AndSHOW STATUS LIKE 'qcache%'` shows all zeros.
Is it possible my my.cnf is missing or deleted? Do I have to recreate it, or rename the my-default.ini to just my.ini? I think perhaps a coworker changed the file name or moved it not knowing what it was potentially.
End of the day, how can I ensure that query caching is enabled on my MySQL 5.6 server?
Running it on Windows Server 2003.