… –file-block-size=16384 –report-interval=10 run You may see I gather metrics every 10 sec to see how stable the… (8 async IO threads): In general it shows stable throughput topping to 148 MiB/sec, but every 20 min, there is…
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… 4072 (Warning: Incompatible change!). Â (see docs). All of these 10 items will be covered in our Training workshops for InnoDB… next post in this series will be on XtraDB: The Top 10 Configuration Parameters.
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… one. We can use the new MV (dashboard_top_customers) to list the top 10 customers nearly instantly. Note that every MV gets…, customer_id, total_price, total_lines from demo.dashboard_top_customers limit 10; +——+————-+————-+————-+ | rank | customer_id | total_price | total_lines | +——+————-+————-+————-+ | 1 | 689…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… mk-query-digest groups and orders data by default. Fixing top 10 queries on the list indeed will most likely reduce the… mk-query-digest to list me top slowest queries, I asked it to list me top slowest sessions: mk-query-digest –group… session I needed to focus on was right at the top. And what do you know, 519 queries were run during…
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…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… at a couple of all-in-one commands. For example, ‘top -n 1′ and ‘uptime’. That shows me what processes are… slow /path/to/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way… instant messaging chat and tell the customer “here’s the top thing you can start working on while I keep investigating…
Post: Why you don't want to shard.
August 6, 2009 By 33 Comments
… While the IO system can be improved with a RAID 10 controller w/battery backed write cache, the slave delay problem… that is going to be in the course – “XtraDB: The top 10 enhancements”, and in Part 3 “XtraDB: The top 10 parameters”.
Comment: Why MySQL could be slow with large tables ?
May 27, 2009 By 139 Comments
… of clicks/views etc. I’m testing with table with ~ 10 000 000 rows generated randomly. In first table I store…. 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…
Comment: Innodb performance gotcha w Larger queries.
September 28, 2009 By 7 Comments
… dominating in the 5.1.30 codebase, disappear from the top 10 functions in 5.1.37 codebase. Though unlike your success…
Post: How to Outrun the Lions
July 13, 2008 By 10 Comments
… titled Outrun the Lions. Our customers run several of the top 10 applications on Facebook right now (as measured by the number…
