… thread counter and other shared data. These are going to get more attention as people run into them more. I feel…) time to execute. To give some context, normally these take 75 microseconds. I can see it clearly when I scan the slow query log… the query cache) are executing in no more than 12 microseconds, worst-case. So the contention that’s blocking these queries for shockingly long times is…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… running MySQL with slow query log with microsecond resolution so I could check exactly which update queries take most time to execute. Unfortunately it did… clear everything but in my case it did exactly what was needed. Now running mysqlsla to get most common queries: ./mysqlsla-1.4…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…compression. The downside in gzip is increased usage of CPU time. PZ: We …the queue but did not start executing yet will innodb has to …query where clause when it was not resolved by index HT: That is already implemented in…in less than 100 microseconds. And if you do not have, then the only way to get…
