…what is easily computed using built in aggregate functions. We most likely would…for search pages within 1 second, acceptable as response within 3 seconds and anything over that will be considered unacceptable: mysql> select sum…over 99% cases. I consider this a lot more meaningful number for business…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…for optimization when replication can’t catch up but yet optimization process we’re going to use relays on replication being functional and…query-digest is sum of query execution time vs time range the log file covers. In this case…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
…MySQL process (filter) data using it current architecture ? I decided to test the most simple case – what if we take the in memory table with very narrow row and run simple query…function calls for each row. Lets see if we do some row function…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…cases and below 3 seconds in 99% cases“. Note We’re specific to the user interaction – people are used…functionality to the application. All the same. Once you found the queries…for complex applications using mutliple components (like sphinx and MySQL) or multiple MySQL Servers because in these cases…
