… similar no-tables, no-storage-engines queries are varying from 50 microseconds to half a second, *real* queries that actually touch real tables and… 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…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…times of individual queries. This is the completion time minus the arrival time (a duration). We can also compute the average concurrency, throughput, response time… typical response time is under a millisecond — maybe it’s 50 microseconds, maybe…. If the stall was long enough, the red curve (inbound…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
…read” performance will drop 4 times if write load growth by only 50%. – Delays in replication MySQL replication is fast which means in average delay is small. Typically microseconds…avoid master overload in such case. – No long queries – As I already wrote these cause …
