Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

when I tried to delete some records from a MYSQL server (version 5.0.95-log) and checked the process list I got the result as follows

mysql> show processlist \G
*************************** 2. row ***************************
     Id: 3480
   User: admin
   Host:
     db: test_db1
Command: Connect
   Time: 8367
  State: invalidating query cache entries (key)
   Info: NULL

I would like know what is this "invalidating query cache entries (key)" and is this due to any configuration settings.Replication is configured in this machine and it acts as the Master Server.

Please find the my.cnf file setting blow

[mysqld]

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
lower_case_table_names = 1
default-storage-engine=InnoDB
innodb_buffer_pool_size=5G
innodb_log_file_size=512M
query_cache_size=512M
table_cache=64
innodb_flush_method=O_DIRECT

#Replication 

log-bin=mysql-bin
server-id=1
sync_binlog=1
innodb_flush_log_at_trx_commit=1

binlog-do-db=test_db1
binlog-do-db=test_db2

# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid
share|improve this question
add comment

1 Answer

I addressed this question : Is the overhead of frequent query cache invalidation ever worth it?

In that post, I mentioned the interaction between the InnoDB Storage Engine and the Query Cache.

The easiest solution for this is to disable the query cache with the following:

STEP 01 : Run this in mysql

mysql> SET GLOBAL query_cache_size = 0;

STEP 02 : Add this to my.cnf for the query cache to stay off after a reboot

[mysqld]
query_cache_size = 0

Give it a Try !!!

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.