what does the Command-Type "update multi" mean on the Command-Statistics tab?
| User, date | Message |
|---|---|
|
Written by paericksen
4 months ago Category: General 1 posts since Fri, 22 Feb 13 |
I couldn't find any documentation, for HeidiSQL. If there is any documentation that answers my question I would appreciate the link to it. Can anyone tell me what the Command-Type "update multi" mean on the Command-Statistics tab? 
|
|
Written by ansgar
4 months ago 4020 posts since Fri, 07 Apr 06 |
I guess these are UPDATEs with multiple joined tables. |
|
Written by TTSneko
4 months ago 15 posts since Thu, 19 Jul 12 |
That has nothing to do with HeidiSQL ... the com_update_multi statistics are provided by the MySQL server status variables. http://dev.mysql.com/doc/refman/4.1/en/server-status-variables.html#statvar_Com_xxx The UPDATE MULTI stat refers to how many queries accessed/updated multiple tabs at once (e.g. invoked by UPDATE in combination with a CASE clause). |
|
Please login to leave a reply, or register at first. |