Add an explanation of what a State of "updating reference tables" means to section 1.
Bug #13462: Doc bug: 'updating reference tables' processlist state not defined in docs: Submitted: : Modified: : Reporter: [ name withheld ] Email Updates. When I profile the query, here's the results I see: starting 0.
Mysqladmin processlist 명령이나 mysql 접속 후 show processlist.
Explore Ontario Attractions in Ottawa, Gatineau, Almonte, Nepean & Perth. Download the mobile apps on App Store or Google Play Cupid - Official Site Our online dating site will help you target potential matches according to location and it covers many of the major cities.
Free Dating Sites For Single Moms Are you a single mom or single dad?
SHOW PROFILE FOR QUERY 3; --------------------------- ----------- | Status | Duration | --------------------------- ----------- | starting | 0.000075 | | checking permissions | 0.000013 | | checking permissions | 0.000012 | | Opening tables | 0.000073 | | checking permissions | 0.000011 | | checking permissions | 0.000013 | | System lock | 0.000023 | | init | 0.000021 | | updating main table | 0.000014 | | optimizing | 0.000020 | | statistics | 0.000117 | | preparing | 0.000028 | | executing | 0.000011 | | Sending data | 31.940094 | I have a few other UPDATE queries with similar symptoms.
Customer ID 1 Using where id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE D index PRIMARY Diff Time 9 NULL 4044212 Using index 1 SIMPLE V ref Order ID_Customer ID, Customer ID_Order ID Order ID_Customer ID 9 D. However it does not include an explanation of what 'updating reference tables' means, which is especially unfortunate as I have a long running query in that state that is negatively impacting the performance of my server. The overall query was very slow so I began breaking it down into smaller pieces (1. SHOW PROCESSLIST Syntax) lists many of the different processlist State values with an explanation of each. SQL update statement takes around 7 seconds and I'm wondering how to improve its performance. Since the query is spending most of its time 'updating'. Customer ID 1 NULL I have accepted your answer, @Rolando My SQLDBA, thanks for your help!The query has finally moved out of "Sending Data" state and is now "Updating Reference Tables" - so the query will probably complete within an hour or so.The WHERE clause is used to specify the conditions that identify which rows to be updated.