Query Statistics...
Chris Knipe <[email protected]>
| Newsgroups | gmane.comp.db.mysql.general |
|---|---|
| Message-ID | <CA+4TWFuaqatazqfANxj3jMHMJ1h7-4v04QxvjXRavUfPyoWctg@mail.gmail.com> |
Hi All, Perhaps a bit of a trivial question, but in terms of query statistics (i.e. how many SELECT / INSERT / DELETE / etc. queries has been ran against the server)... When you take an INSERT ... ON DUPLICATE KEY UPDATE ... Under the two conditions (i.e. either INSERT, or UPDATE if the record already exist), how is this query logged in the statistics? When the ON DUPLICATE KEY UPDATE runs (i.e. it's updating a record), is it still logged as a INSERT query, or is it logged as a UPDATE query? Thnx. -- Regards, Chris Knipe