what does the Command-Type "update multi" mean on the Command-Statistics tab?

[expired user #6820]'s profile image [expired user #6820] posted 11 years ago in General Permalink
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?

ansgar's profile image ansgar posted 11 years ago Permalink
I guess these are UPDATEs with multiple joined tables.
TTSneko's profile image TTSneko posted 11 years ago Permalink
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.