… support. 4. Be Solid MySQL has very good stability track record, with exception of MySQL 5.0 it was typically safe…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… tests the most basic aggregation (count(*)) on a range of records. This table is partitioned by month which means that MySQL…:normal;overflow:hidden;text-indent:0px;padding-left:3px;border-top:1px solid #CCC;border-right:1px solid #CCC;border-bottom…:normal;overflow:hidden;text-indent:0px;padding-left:3px;border-top:1px solid #CCC;border-right:1px solid #CCC;border-bottom…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… their clients. Clicks by day, by customer, top ads by clicks, top ads by click-through ratio, and so on for… now. You can have the clicks column record the total, and the blue_clicks column record only blue clicks; to find out…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… paste everything I see into it. If there’s no record later that someone else can follow, I am not doing… slow /path/to/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the… instant messaging chat and tell the customer “here’s the top thing you can start working on while I keep investigating…
Post: Data mart or data warehouse?
July 15, 2010 By 13 Comments
… of data warehousing is to collect and make a historical record of the information from another system. This might be an… off for historical accuracy. This is often described as the “top-down” approach. What is a data mart? The second approach… methods is of course allowed. A company might take the top-down approach where they maintain a large historical data warehouse…
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 12 Comments
Quite typical query for reporting applications is to find top X values. If you analyze Web Site logs you would … reporting you may be interested in best selling product or top sales people. This information may often need simple select query… our goal of real time reporting on 10.000.000+ recorded events. UPDATE: Looking a bit further into it I found…
Comment: Innodb vs MySQL index counts
November 30, 2011 By 6 Comments
… column `foo`; Query OK, 3 rows affected (0.02 sec) Records: 3 Duplicates: 0 Warnings: 0 > select * from test; +—-+——-+ | id | data….00 sec) ## copy the .frm with 3 columns back on top > flush tables; Query OK, 0 rows affected (0.00 sec… ENGINE=Innodb; Query OK, 5 rows affected (0.01 sec) Records: 5 Duplicates: 0 Warnings: 0 > select * from test; +—-+——-+——+ | id | data…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… default 0; Query OK, 300024 rows affected (13.28 sec) Records: 300024 Duplicates: 0 Warnings: 0 mysql> update employees set age… this is still a valid backup method of course on top of your regularly tested (offsite) backups. Another ideal use case…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
December 1, 2011 By 94 Comments
… stuff to do something. Yes, I started reading from the top, silly me. When that didn’t satisfy me, I then… used it for one line of code eventually.) For the record, I did learn Symbian. I get stuff done with autotools…
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
October 16, 2010 By 46 Comments
Beautiful function. I was on the verge of using a conditional update statement until i discovered this. Anyone knows if there is a mysql function that will shift all records key id down? by adding 1 when I add a new key, say 0 on the TOP of the table?
