Invalidating query cache entries mysql

Rated 4.9/5 based on 793 customer reviews

with any other pre-production release, caution should be taken when installing on production level systems or systems with critical data.The manual didn't lie to you, any queries which alter data in a table invalidate any cache entries that reference that *************************** Id: 7929352 User: system user Host: db: NULL Command: Connect Time: 69899 State: invalidating query cache entries (table) Info: NULL replication shows Seconds_Behind_Master: 70429 Once the invalidating query cache entries (table) process has finished the slave catches up.sql/sql_select.cc:10660: thd_proc_info(thd, save_proc_info); sql/sql_table.cc:3517: thd_proc_info(thd, “creating table”); sql/sql_table.cc:3586: thd_proc_info(thd, “After create”); sql/sql_table.cc:5096: thd_proc_info(thd, “discard_or_import_tablespace”); sql/sql_table.cc:5113: thd_proc_info(thd, “end”); sql/sql_table.cc:6068: thd_proc_info(thd, “init”); sql/sql_table.cc:6271: thd_proc_info(thd, “setup”); sql/sql_table.cc:6327: thd_proc_info(thd, “rename”); sql/sql_table.cc:6724: thd_proc_info(thd, “copy to tmp table”); sql/sql_table.cc:6898: thd_proc_info(thd, “rename result table”); sql/sql_table.cc:7013: thd_proc_info(thd, “end”); sql/mysql_priv.h:619:#define thd_proc_info(thd, msg) set_thd_proc_info(thd, msg, __func__, __FILE__, __LINE__) sql/mysql_priv.h:681: The meat of thd_proc_info(THD*, char*), a macro that packs the last sql/mysql_priv.h:685:const char *set_thd_proc_info(THD *thd, const char *info, sql/mysql_priv.h.pp:1694:const char *thd_proc_info(void* thd, const char *info); sql/mysql_priv.h.pp:2394:const char *set_thd_proc_info(THD *thd, const char *info, storage/csv/ha_tina.cc:1552: old_proc_info= thd_proc_info(thd, “Checking table”); storage/csv/ha_tina.cc:1582: thd_proc_info(thd, old_proc_info); storage/myisam/ha_myisam.cc:752: thd_proc_info(thd, “Checking table”); storage/myisam/ha_myisam.cc:826: thd_proc_info(thd, old_proc_info); storage/myisam/ha_myisam.cc:1112: thd_proc_info(thd, buf); storage/myisam/ha_myisam.cc:1115: thd_proc_info(thd, “Repair done”); // to reset proc_info, as storage/myisam/ha_myisam.cc:1120: thd_proc_info(thd, “Repair by sorting”); storage/myisam/ha_myisam.cc:1127: thd_proc_info(thd, “Repair with keycache”); storage/myisam/ha_myisam.cc:1141: thd_proc_info(thd, “Sorting index”); storage/myisam/ha_myisam.cc:1149: thd_proc_info(thd, “Analyzing”); storage/myisam/ha_myisam.cc:1156: thd_proc_info(thd, “Saving state”); storage/myisam/ha_myisam.cc:1194: thd_proc_info(thd, old_proc_info); storage/myisam/ha_myisam.cc:1409: thd_proc_info(thd, “Creating index”); storage/myisam/ha_myisam.cc:1434: thd_proc_info(thd, save_proc_info); storage/archive/ha_archive.cc:1553: old_proc_info= thd_proc_info(thd, “Checking table”); storage/archive/ha_archive.cc:1568: thd_proc_info(thd, old_proc_info); So there you go, now you know what the “state” values are, except for a few like “Resuming”.Starting with version 5.1.28, there is a new table INFORMATION_SCHEMA.duration The my_getsystime() function in sql/my_getsystime.c gets time of day with one of: clock_gettime() available on many Unix systems Query Performance Counter() Windows only NXGet Time() Net Ware only gettimeofday() the default if there’s nothing else All these time-of-day functions are slow on most platforms, but they only get called a few times per statement, because a typical statement has ten or fewer “Stages”.

By using grep on the source code, I have been able to collect a list of the server functions which invoke get_thd_proc_info().sql/item_func.cc:3393: thd_proc_info(thd, “User lock”); sql/item_func.cc:3418: thd_proc_info(thd, 0); sql/item_func.cc:3509: thd_proc_info(thd, “User lock”); sql/item_func.cc:3552: thd_proc_info(thd, 0); sql/item_func.cc:3737: thd_proc_info(thd, “User sleep”); sql/item_func.cc:3749: thd_proc_info(thd, 0); sql/log_event.cc:5926: thd_proc_info(thd, proc_info); sql/log_event.cc:5979: thd_proc_info(thd, 0); sql/log_event.cc:6101: thd_proc_info(thd, proc_info); sql/log_event.cc:6135: thd_proc_info(thd, 0); sql/sql_delete.cc:62: thd_proc_info(thd, “init”); sql/sql_delete.cc:253: thd_proc_info(thd, “updating”); sql/sql_delete.cc:336: thd_proc_info(thd, “end”); sql/sql_delete.cc:582: thd_proc_info(thd, “deleting from main table”); sql/sql_delete.cc:897: thd_proc_info(thd, “deleting from reference tables”); sql/sql_delete.cc:906: thd_proc_info(thd, “end”); sql/sql_class.cc:264:const char *set_thd_proc_info(THD *thd, const char *info, sql/sp_head.cc:2734: thd_proc_info(thd, “closing tables”); sql/sp_head.cc:2737: thd_proc_info(thd, 0); sql/lock.cc:258: thd_proc_info(thd, “System lock”); sql/lock.cc:269: thd_proc_info(thd, “Table lock”); sql/lock.cc:317: thd_proc_info(thd, 0); sql/lock.cc:332: thd_proc_info(thd, 0); sql/sql_base.cc:940: thd_proc_info(thd, “Flushing tables”); sql/sql_base.cc:1008: thd_proc_info(thd, 0); sql/sql_base.cc:2140: thd_proc_info(thd, “Waiting for table”); sql/sql_base.cc:2160: thd_proc_info(thd, proc_info); sql/sql_base.cc:3532: thd_proc_info(thd, “Waiting for tables”); sql/sql_base.cc:3548: thd_proc_info(thd, “Reopen tables”); sql/sql_base.cc:3553: thd_proc_info(thd, 0); sql/sql_base.cc:4450: thd_proc_info(thd, “Opening tables”); sql/sql_base.cc:4729: thd_proc_info(thd, 0); sql/sql_base.cc:4878: thd_proc_info(thd, “Opening table”); sql/sql_base.cc:4918: thd_proc_info(thd, 0); sql/sql_base.cc:8511: thd_proc_info(thd, “FULLTEXT initialization”); sql/sql_view.cc:669: thd_proc_info(thd, “end”); sql/sql_update.cc:235: thd_proc_info(thd, “init”); sql/sql_update.cc:464: thd_proc_info(thd, “Searching rows for update”); sql/sql_update.cc:533: thd_proc_info(thd, “Updating”); sql/sql_update.cc:766: thd_proc_info(thd, “end”); sql/sql_update.cc:1260: thd_proc_info(thd, “updating main table”); sql/sql_update.cc:1974: thd_proc_info(thd, “updating reference tables”); sql/sql_update.cc:1986: thd_proc_info(thd, “end”); sql/sql_insert.cc:618: thd_proc_info(thd, “init”); sql/sql_insert.cc:703: thd_proc_info(thd, “update”); sql/sql_insert.cc:923: thd_proc_info(thd, “end”); sql/sql_insert.cc:1796: thd_proc_info(thd, “waiting for delay_list”); sql/sql_insert.cc:1878: thd_proc_info(thd, “Creating delayed handler”); sql/sql_insert.cc:1924: thd_proc_info(thd, “waiting for handler open”); sql/sql_insert.cc:1930: thd_proc_info(thd, “got old table”); sql/sql_insert.cc:2007: thd_proc_info(client_thd, “waiting for handler lock”); sql/sql_insert.cc:2013: thd_proc_info(client_thd, “got handler lock”); sql/sql_insert.cc:2031: thd_proc_info(client_thd, “allocating local table”); sql/sql_insert.cc:2116: thd_proc_info(thd, “waiting for handler insert”); sql/sql_insert.cc:2120: thd_proc_info(thd, “storing row into queue”); sql/sql_insert.cc:2366: thd_proc_info(&(di-thd), 0); sql/sql_insert.cc:2543: thd_proc_info(&thd, “upgrading lock”); sql/sql_insert.cc:2556: thd_proc_info(&thd, “insert”); sql/sql_insert.cc:2694: thd_proc_info(&thd, “reschedule”); sql/sql_insert.cc:2715: thd_proc_info(&thd, “insert”); sql/sql_insert.cc:2721: thd_proc_info(&thd, 0); sql/slave.cc:1054: thd_proc_info(thd, “Creating table from master dump”); sql/slave.cc:1069: thd_proc_info(thd, “Opening master dump table”); sql/slave.cc:1085: thd_proc_info(thd, “Reading master dump table data”); sql/slave.cc:1097: thd_proc_info(thd, “Rebuilding the index on master dump table”); sql/slave.cc:1586: thd_proc_info(thd, “Waiting for the next event in relay log”); sql/slave.cc:1588: thd_proc_info(thd, “Waiting for master update”); sql/slave.cc:2311: thd_proc_info(thd, “Connecting to master”); sql/slave.cc:2338: thd_proc_info(thd, “Checking master version”); sql/slave.cc:2347: thd_proc_info(thd, “Registering slave on master”); sql/slave.cc:2377: thd_proc_info(thd, “Requesting binlog dump”); sql/slave.cc:2408: thd_proc_info(thd, “Waiting for master to send event”); sql/slave.cc:2452: thd_proc_info(thd, “Queueing master event to the relay log”); sql/slave.cc:2527: thd_proc_info(thd, “Waiting for slave mutex on exit”); sql/slave.cc:2714: thd_proc_info(thd, “Reading event from the relay log”); sql/slave.cc:2801: thd_proc_info(thd, “Waiting for slave mutex on exit”); sql/sql_cache.cc:760: thd_proc_info(thd, “storing result in query cache”); sql/sql_cache.cc:813: thd_proc_info(thd, “storing result in query cache”); sql/sql_cache.cc:1262: thd_proc_info(thd, “checking query cache for query”); sql/sql_cache.cc:1346: thd_proc_info(thd, “checking privileges on cached query”); sql/sql_cache.cc:1441: thd_proc_info(thd, “sending cached result to client”); sql/sql_cache.cc:1518: thd_proc_info(thd, “invalidating query cache entries (table list)”); sql/sql_cache.cc:1544: thd_proc_info(thd, “invalidating query cache entries (table)”); sql/sql_class.h:1298: Set it using the thd_proc_info(THD *thread, const char *message) sql/sql_parse.cc:386: thd_proc_info(thd, “Execution of init_command”); sql/sql_parse.cc:447: thd_proc_info(thd, 0); sql/sql_parse.cc:1575: thd_proc_info(thd, “cleaning up”); sql/sql_parse.cc:1577: thd_proc_info(thd, 0); sql/sql_parse.cc:1608: thd_proc_info(thd, “logging slow query”); sql/sql_parse.cc:1618: thd_proc_info(thd, “logging slow query”); sql/sql_parse.cc:3220: thd_proc_info(thd, “init”); sql/sql_parse.cc:4799: thd_proc_info(thd, “query end”); sql/sql_parse.cc:5037: thd_proc_info(thd, “checking permissions”); sql/sql_parse.cc:5805: thd_proc_info(thd, “freeing items”); sql/repl_failsafe.cc:104: thd_proc_info(thd, “Thread initialized”); sql/repl_failsafe.cc:619: thd_proc_info(thd, “Processing request”); sql/repl_failsafe.cc:974: thd_proc_info(thd, “purging old relay logs”); sql/repl_failsafe.cc:1001: thd_proc_info(thd, “starting slave”); sql/repl_failsafe.cc:1013: thd_proc_info(thd, 0); sql/sql_repl.cc:658: thd_proc_info(thd, “Sending binlog event to slave”); sql/sql_repl.cc:696: thd_proc_info(thd, “Finished reading one binlog; switching to next binlog”); sql/sql_repl.cc:742: thd_proc_info(thd, “Waiting to finalize termination”); sql/sql_repl.cc:749: thd_proc_info(thd, “Waiting to finalize termination”); sql/sql_repl.cc:903: thd_proc_info(thd, “Killing slave”); sql/sql_repl.cc:930: thd_proc_info(thd, 0); sql/sql_repl.cc:1089: thd_proc_info(thd, “Changing master”); sql/sql_repl.cc:1220: thd_proc_info(thd, “Purging old relay logs”); sql/sql_repl.cc:1281: thd_proc_info(thd, 0); sql/sql_select.cc:762: thd_proc_info(thd, “optimizing”); sql/sql_select.cc:944: thd_proc_info(thd, “statistics”); sql/sql_select.cc:954: thd_proc_info(thd, “preparing”); sql/sql_select.cc:1408: thd_proc_info(thd, “Creating tmp table”); sql/sql_select.cc:1458: thd_proc_info(thd, “Sorting for group”); sql/sql_select.cc:1479: thd_proc_info(thd, “Sorting for order”); sql/sql_select.cc:1638: thd_proc_info(thd, “executing”); sql/sql_select.cc:1777: thd_proc_info(thd, “Copying to tmp table”); sql/sql_select.cc:1904: thd_proc_info(thd, “Creating sort index”); sql/sql_select.cc:1918: thd_proc_info(thd, “Copying to group table”); sql/sql_select.cc:1977: thd_proc_info(thd, “Removing duplicates”); sql/sql_select.cc:2040: thd_proc_info(thd, “Sorting result”); sql/sql_select.cc:2177: thd_proc_info(thd, “Sending data”); sql/sql_select.cc:2337: thd_proc_info(thd, “init”); sql/sql_select.cc:2382: thd_proc_info(thd, “end”); sql/sql_select.cc:10527: thd_proc_info(thd, “removing tmp table”); sql/sql_select.cc:10549: thd_proc_info(thd, save_proc_info); sql/sql_select.cc:10583: thd_proc_info(thd, “converting HEAP to My ISAM”); sql/sql_select.cc:10647: thd_proc_info(thd, (!Basic information is in the reference manual and in an introductory article.A bit of a caveat: I was totally against adding this feature, and some of my bias might show.Fix initialization failure when removing old Bouncy Castle library fails. Prevent invalid query operator from invalidating user's web session.Improve error message when publishing an already published change edit.

Leave a Reply

  1. datingwithme com 21-Sep-2020 01:43

    She never limited her up to one field only and always became spread her in different places.

  2. we love dating 30-Dec-2019 16:04

    Come join our video games chat rooms, Meet with hundreds of cool gamers from around the world here.