How can “set timestamp” be a slow query?

by

Timestamp is a data type and a built-in function in MySQL. What are you trying to achive with the following statement?

SET timestamp=1273826821;

UPD: I am sorry, I didn’t know about the used MySQL hacks.

It seems that SET TIMESTAMP is used as a solution to exclude some queries from the slow log.

The OP is using the Microslow patch to enhance stat info in the slow query log, and the statement is common before statements on InnoDB tables.

Thus, the answer to OP’s question is that the COMMIT statement is the slow query and not the SET TIMESTAMP.

More Related Contents:

  1. Mysql replication with UPDATE JOIN on an ignored table
  2. MyISAM versus InnoDB [closed]
  3. How can i optimize MySQL’s ORDER BY RAND() function?
  4. MYSQL OR vs IN performance
  5. Why does MYSQL higher LIMIT offset slow the query down?
  6. How to Perform an UPSERT so that I can use both new and old values in update part
  7. Is there a REAL performance difference between INT and VARCHAR primary keys?
  8. JDBC batch insert performance
  9. MySQL: Fastest way to count number of rows
  10. Why is MySQL InnoDB insert so slow?
  11. MySQL stored procedures use them or not to use them
  12. Scaling solutions for MySQL (Replication, Clustering)
  13. UUID performance in MySQL?
  14. MySQL “IN” operator performance on (large?) number of values
  15. How can I speed up a MySQL query with a large offset in the LIMIT clause?
  16. Optimal MySQL settings for queries that deliver large amounts of data?
  17. DOs and DONTs for Indexes [closed]
  18. MySql views performance [closed]
  19. MySQL performance: multiple tables vs. index on single table and partitions
  20. INSERT … ON DUPLICATE KEY UPDATE with WHERE?
  21. MySQL view performance
  22. “SELECT COUNT(*)” is slow, even with where clause
  23. Does Order of Fields of Multi-Column Index in MySQL Matter
  24. MySQL load data infile – acceleration?
  25. is php sort better than mysql “order by”?
  26. Would it help to add index to BIGINT column in MySQL?
  27. ALTER TABLE ADD COLUMN takes a long time
  28. Why is connecting to MySQL server so slow?
  29. Mysql performance on 6 million row table
  30. Composite Primary Key performance drawback in MySQL

Leave a Comment