Resolved mysql 5.5 and query cache size

[Franco]

Hi,
on my installation I have noticed that the query_cache_type is ON, but the size is 0. I edited /etc/my.cnf to include the query_cache_size, but it is ignored, even after a reboot. Perhaps Plesk uses a different file for that or is it somewhere in the Plesk interface? Could not find it...

Thank you for your kind help

 

[UFHH01]

Hi Franco,

pls. provide the output of the following commands:

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

mysql> show variables like '%cache%';​

 

[Franco]

Hi,
here it is:

+------------------------------+----------------------+
| Variable_name | Value |
+------------------------------+----------------------+
| binlog_cache_size | 32768 |
| binlog_stmt_cache_size | 32768 |
| have_query_cache | YES |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| max_binlog_cache_size | 18446744073709547520 |
| max_binlog_stmt_cache_size | 18446744073709547520 |
| metadata_locks_cache_size | 1024 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| stored_program_cache | 256 |
| table_definition_cache | 400 |
| table_open_cache | 400 |
| thread_cache_size | 0 |
+------------------------------+----------------------+

 

[Bitpalast]

What is the content of your /etc/my.cnf?

 

[Franco]

[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
bind-address=127.0.0.1
sort_buffer_size=2M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
query_cache_size=268435456
query_cache_type=1
query_cache_limit=1048576

 

[Bitpalast]

Please try to move

query_cache_size=268435456
query_cache_type=1
query_cache_limit=1048576

into the [mysqld] section. Then restart MySQL/MariaDB.

 

[Franco]

It works now, thank
Silly of me...