Configure mysql server with settings

  • Query cache type is 1
  • Query cache limit is 1MB
  • Query cache size is 32MB

Answer:

Add the below lines in the /etc/my.cnf file,under the [mysqld] section

#vim /etc/my.cnf

To set Query cache type is 1

query_cache_type = 1

To set Query cache size is 32MB

query_cache_size = 32MB

To set Query cache limit is 1MB
query_cache_limit = 1MB

Leave a Reply

Your email address will not be published. Required fields are marked *