… year of storage engines, focused on showing what is on top is what really matters. Falcon, SolidDB, NitroSecurity, PBXT, StorageEngine for… do you have from you attending MySQL Conference over last 10 years. Please leave comment and share your experiences! Thank you…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…, I started of data gathering metrics like: pt-stalk, vmstat, top, iostat, etc all saving to disk with the current time… process, the cron job started at 10am. Fri Mar 22 10:03:22 UTC 2013 procs ———–memory———- —swap– —–io—- –system– —–cpu—– Fri Mar 22 10:03:22 UTC 2013 r b swpd free buff cache…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… as warmup time; the remaining 3600 seconds were averaged into 10-second intervals. All tests were conducted with approximately 78GiB of… the system during all these various tests. Clockwise from the top left in the next graph, we have “no cache”, “FlashCache…_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet = 16M binlog_cache…
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: Webinar: 10 Percona Toolkit tools every MySQL DBA should know about
December 12, 2012 By Leave a Comment
… Pacific, I will be giving a webinar entitled “10 Percona Toolkit Tools Every MySQL DBA Should Know About”. As … this experience to select what I consider to be the top 10 tools everyone working with MySQL should know about. I will…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 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 34 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”.
