Skip to content

Instantly share code, notes, and snippets.

@nirbhayc

nirbhayc/query_cache_type

Last active July 22, 2016 19:48
Show Gist options
  • Save nirbhayc/68611e05e83c0ed47b9052c12df721d9 to your computer and use it in GitHub Desktop.
Save nirbhayc/68611e05e83c0ed47b9052c12df721d9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query_cache_type
MariaDB 10.1.15
===============
a) ./bin/mysqld
MariaDB [test]> select @@query_cache_size, @@query_cache_type;
+--------------------+--------------------+
| @@query_cache_size | @@query_cache_type |
+--------------------+--------------------+
| 1048576 | OFF |
+--------------------+--------------------+
b) ./bin/mysqld --query-cache-size=50K
MariaDB [test]> select @@query_cache_size, @@query_cache_type;
+--------------------+--------------------+
| @@query_cache_size | @@query_cache_type |
+--------------------+--------------------+
| 51200 | ON |
+--------------------+--------------------+
MariaDB 10.1.6
==============
a) ./bin/mysqld
MariaDB [(none)]> select @@query_cache_size, @@query_cache_type;
+--------------------+--------------------+
| @@query_cache_size | @@query_cache_type |
+--------------------+--------------------+
| 0 | ON |
+--------------------+--------------------+
b) ./bin/mysqld --query-cache-size=50K
MariaDB [(none)]> select @@query_cache_size, @@query_cache_type;
+--------------------+--------------------+
| @@query_cache_size | @@query_cache_type |
+--------------------+--------------------+
| 51200 | ON |
+--------------------+--------------------+
1 row in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment