June 18, 2013

Post: Top 5 Wishes for MySQL

June 29, 2007 By 10 Comments

… support. 4. Be Solid MySQL has very good stability track record, with exception of MySQL 5.0 it was typically safe…

Filed Under: Insight for DBAs Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… Records, Criminal Records And Background Checks | 21.23662567138672 | | 66 | Michigan Free Public Records, Criminal Records And Background checks | 5.363710880279541 | | 44 | Alabama Free Public Records…” and “Peterson”, and we should expect the record from Arizona to be towards the top of the list. With 5.5, this…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Shard-Query adds parallelism to queries

November 15, 2010 By 18 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…

Filed Under: Insight for Developers, MySQL Tagged With: , , , ,

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…

Filed Under: Insight for Developers Tagged With: , , , ,

Post: Read/Write Splitting with PHP Webinar Questions Followup

January 23, 2013 By 4 Comments

… visit the webinar registration page and get access to the recording and slides. Q: Are there similar plugins or resources for… of work? A: Yes, if you layer an ORM on top of the DAL, this makes it inconvenient to choose the… a Dual-Master Setup.” I encourage you to watch the recording of Jay’s presentation. Percona XtraDB Cluster reduces the hazards…

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , ,

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…

Filed Under: Insight for Developers Tagged With:

Post: Data mart or data warehouse?

July 15, 2010 By 14 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…

Filed Under: Insight for Developers, MySQL

Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization

September 17, 2007 By 14 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…

Filed Under: Benchmarks, Insight for Developers Tagged With:

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…

Filed Under: MySQL

Post: How to find MySQL queries worth optimizing ?

September 11, 2012 By 6 Comments

… case if I index the table I get the following record in the slow query log: # Time: 120911 17:18:05… actual rows which are found and returned up to the top level MySQL part for processing are counted the Rows_examined…

Filed Under: Insight for DBAs, MySQL
« Older Posts