May 26, 2012

Post: How Percona does a MySQL Performance Audit

…#1 SMP Tue Apr 29 13:16:15 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux […/proc/cpuinfo power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : Intel(R) …/path/to/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the…

Post: Shard-Query adds parallelism to queries

… never takes advantage of more than a single CPU when aggregating data and fetching rows from …hidden;text-indent:0px;padding-left:3px;border-top:1px solid #CCC;border-right:1px solid #CCC…2008-12-31′ GROUP BY Origin ORDER BY c DESC LIMIT 10; Q4 – SELECT carrier, count(*) FROM ontime WHERE DepDelay>10