Percona's MySQL & InnoDB performance and scalability blog
… total, 113 unique, 28.36 QPS, 0.04x concurrency _________ # total min max avg 95% stddev median # Exec time 4s 11us 2s 1ms… included in the report because it matches –limit. # pct total min max avg 95% stddev median # Count 24 657 # Exec time 87…
… total, 6 unique, 0.15 QPS, 0.00x concurrency ________________ # total min max avg 95% stddev median # Exec time 114ms 0 101ms 14ms… included in the report because it matches –limit. # pct total min max avg 95% stddev median # Count 12 1 # Exec time 88…
… of these MAGIC_history_cols values: pct|avt|cnt|sum|min|max|pct_95|stddev|median|rank If the column ends with… following useful columns populated in query_review_history table: * `user_max` varchar(64) DEFAULT NULL – User who executed the query. * `host… NULL – Current database that comes from USE database statements. * `hostname_max` varchar(64) NOT NULL – Hostname of the server where slow…
… 
we do indeed have a small block index. We save min/max column values for every 128 rows. When doing a full…
I added the following to the post: *MIN/MAX are only distributable in INSERT-only workloads See this information …
… 16:12:13 to 16:14:45 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 519 # Exec time 2…
… have! Here’s one report I got today: … # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 5088s 1us 171s 2ms…
… so many problems is that aggregate functions outside of SUM/MIN/MAX/AVG are not supported. Many of the tests use VAR…
…, 1.27k unique, 558.56 QPS, 0.37x concurrency ______ # total min max avg 95% stddev median # Exec time 819s 1us 92s 669us…
… can no longer easily perform aggregation functions on the data (MIN, MAX, AVG). You are storing the data in a way that…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.