…, I started of data gathering metrics like: pt-stalk, vmstat, top, iostat, etc all saving to disk with the current time… 10am. Fri Mar 22 10:03:22 UTC 2013 procs ———–memory———- —swap– —–io—- –system– —–cpu—– Fri Mar 22 10:03:22 UTC 2013… the cache one going up and then swapping starting at 10:03:36. Also, the server is reading a lot (~150MB…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
… to shard. This week I’m following up with the top 10 enhancements that XtraDB has over the built-in InnoDB included… highest impact and are most applicable to all workloads first: CPU scalability fixes – XtraDB improves performance on systems with multi-cpus… next post in this series will be on XtraDB: The Top 10 Configuration Parameters.
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… 25 /proc/cpuinfo power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : Intel(R) Xeon(R… siblings : 4 core id : 3 cpu cores : 4 fpu : yes fpu_exception : yes cpuid level : 10 wp : yes flags : fpu vme de… slow /path/to/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way…
Post: How fast can you sort data with MySQL ?
August 18, 2007 By 26 Comments
… MySQL can sort 1.000.000 rows, or rather return top 10 rows from sorted result set which is the most typical… | | 99999 | 81980bcd9dbaa565f22a93ce1faf9e9d53407f0a | +——–+——————————————+ 10 rows in set (0.56 sec) Not bad ! Even though MySQL does not optimize “get top N sorted rows…-250K which is quite smaller than even default value. The CPU in question was Pentium 4 having 1024K of cache. A…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
…more frequently. IO Bound workload is quite different from CPU bound one, which happens when your working set (…reads you will have query taking at least 5-10 second, or more under the load which is …especially if you have some form of caching on top of that. For IO bound application you however …
Comment: Why MySQL could be slow with large tables ?
May 27, 2009 By 141 Comments
…. The most common query in such cases is to get top N results for browsers/platforms/countries etc in any time… CHARSET=latin1 AUTO_INCREMENT=91748 ; So the query to get top 10 countries will be SELECT iplist.code COUNT(stat.ip_interval… BY count DESC LIMIT 0, 10 This query takes ~13 seconds to run (2GHZ Dual Core CPU, 2GB RAM). EXPLAIN this query…
Comment: Air traffic queries in InfiniDB: early alpha
November 6, 2009 By 19 Comments
…. You should be able to verify with top that cpu utilization approaches 200% with a two cpu system. For example, this is what I see when running Q9 with 6 of 8 cores disable: [root@srvalpha2 ~]# top… 14.8g 2.8g 7000 S 195 17.9 68:10.75 PrimProc 26264 root 18 -1 14.8g 2.8g…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… really bad is Parallel query. Reporting with group by over 10.000.000 of rows in real time is one painful… handle complex queries well, being able to use only one CPU effectively on single node and no true federation support. 4…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
… takes advantage of more than a single CPU when aggregating data and fetching rows from…text-indent:0px;padding-left:3px;border-top:1px solid #CCC;border-right:1px solid …2052.8482.73935.9037091732036.20541715621952.84753513336182.7391619682312.10 year40.567.0243.0623.10140.5600171089177….
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… page by server backend. CPU Time This is the CPU time needed to generate … 0.9226436892381 | | 09 | 4810 | 6.330725168364 | 0.60329631087965 | | 10 | 5445 | 3.8355732669953 | 0.53918653169648 | | 11 | 5283 |… layer significantly. Such goal based from top to bottom approach is especially helpful…
