Mysql state invalidating dating ru dina

Rated 3.86/5 based on 908 customer reviews

Measure the time spent in Query Cache::invalidate()A patch for this bug has been committed.

After review, it may be pushed to the relevant source trees for release in the next version.

mysql state invalidating-13

mysql state invalidating-65

mysql state invalidating-68

That is, even if the query cache is not enabled, the mutex (slow, by nature) to access the (not existing) query cache is acquired for every binlog event.

By using the command line option --query_cache_type=0, the user can disable the query cache permanently and avoid taking the query cache mutex.

At this time there is no plan to backport the fix to a stable release as it changes the behavior of the query_cache_type command line option.

去slave从库上查看运行状态,果然Seconds_Behind_Master: 28810,而且提示Slave_SQL_Running_State: System lock而且这个是变化的,有的时候提示Slave_SQL_Running_State: invalidating query cache entries (table),而且Seconds_Behind_Master: 29086 不停的增长着: show slave status\G*************************** 1.

row ***************************Slave_IO_State: Waiting for master to send event Master_Host: 10.249.3.11Master_User: repl Master_Port: 3317Connect_Retry: 60Master_Log_File: mysql-bin.000027Read_Master_Log_Pos: 909456416Relay_Log_File: mysql-relay-bin.000020Relay_Log_Pos: 19878093Relay_Master_Log_File: mysql-bin.000014Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0Last_Error: Skip_Counter: 0Exec_Master_Log_Pos: 19877880Relay_Log_Space: 14868115381Until_Condition: None Until_Log_File: Until_Log_Pos: 0Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 29090Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0Last_IO_Error: Last_SQL_Errno: 0Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 12001Master_UUID: cfc81670-fca1-11e5-926d-0017fa0041c0Master_Info_File: mysql.slave_master_info SQL_Delay: 0SQL_Remaining_Delay: NULLSlave_SQL_Running_State: System lock Master_Retry_Count: 86400Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: Auto_Position: 0Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: 1 row in set (0.00 sec)mysql show engine innodb status\G*************************** 1.

Leave a Reply