Changing mysql query_cache_limit without having root priviledges

Question

Can query_cache_limit in mysql 5 be set locally for a specific database? I don't have root privileges to change the global variable.

Can query_cache_limit be set locally for each database?

Steve · Accepted Answer · 2014-04-04 20:47:25Z

up vote 1 down vote accepted

No, it can only be done by someone with root as you already understand.

But if it were me, I would check with them. They may be able to give you a custom my.cnf file.

answered Apr 4 '14 at 20:47

Steve
818315

Are there any other caching options that I can enable instead without having root access ? – Marek Andreansky Apr 5 '14 at 0:18

add a comment |

1 Answer 1