- Server operating system version
- CentOS 7
- Plesk version and microupdate number
- Plesk Obsidian Web Pro Edition Version 18.0.41 Update #1
Hello, I want to increase the query_cache_size value.
So I made the request :
If I do SHOW VARIABLES LIKE '%query_cache%'; the new value has been taken into account.
However, if I restart mariadb service (service mariadb restart), the value is the old value which returns...
Do you have any idea please?
Thanks in advance
So I made the request :
Code:
plesk db;
SET GLOBAL query_cache_size=16777216; (Query OK, 0 rows affected)
Code:
+------------------------------+----------+
| Variable_name | Value |
+------------------------------+----------+
| query_cache_size | 16777216
+------------------------------+----------+
Code:
+------------------------------+----------+
| Variable_name | Value |
+------------------------------+----------+
| query_cache_size | 1048576
+------------------------------+----------+
Thanks in advance