June 19, 2013

Post: MySQL Life Cycle. Your Feedback is needed.

November 18, 2011 By 6 Comments

… old MySQL versions not being upgraded to the most recent version in series. It is frequent to see something like MySQL 5.0.44 which went in as release in some of distributions. As many people use MySQL releases which come… is Supported all the way to MySQL 5.5 yet it does not seems to be available from download pages. It looks like that…

Filed Under: MySQL, Percona Software

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

March 4, 2013 By 7 Comments

…Download Idaho Tax Forms for Individual or Business Needs | 0.9273209571838379 | | 7113 | Illinois Tax Forms for Individuals and Business | 0… And Background checks | 5.363710880279541 | | 44 …0 Warnings: 0 As far as I can tell, this little gotcha doesn’t appear to be mentioned anywhere in the MySQL 5…

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

Post: What is stored InnoDB buffer pool

September 28, 2008 By 8 Comments

…_list | | | | | 61 | 0 | 61 | 69 | 0 | 0 | 0 | 63 | 4 | ibuf_free_list | | | | | 62 | 0 | 62 | 44 | 0 | 0 | 0 | 64 | 4 | ibuf_free_list | | | | | 63 | 0 | 63 | 44 | 0 | 0 | 0 | 65 | 2… source code also available to download P.S. There is Jeremy Cole’s patch for InnoDB plugin MySQL 5.1, and main idea…

Filed Under: Insight for DBAs Tagged With: , ,

Post: Identifying the load with the help of pt-query-digest and Percona Server

December 29, 2011 By 3 Comments

… connections as in MySQL. This is … would want to download the “slow query …0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film # 9 0xCFC0642B5BBD9AC7 0.0987 1.2% 50 0.0020 1.00 0…0 71 # InnoDB: # IO r bytes 0 0 0 0 0 0 0 0 # IO r ops 0 0 0 0 0 0 0 0 # IO r wait 0 0 0 0 0 0 0 0 # pages distin 40 11.77k 34 44…

Filed Under: Insight for DBAs, MySQL

Comment: Announcing Percona XtraDB Cluster 5.5.29-23.7.1

February 3, 2013 By 8 Comments

…44 Percona-XtraDB-Cluster-server-5.5…Downloading Packages: Running rpm_check_debug ERROR with rpm_check_debug vs depsolve: mysql conflicts with Percona-XtraDB-Cluster-client-5.5…

Filed Under: Events and Announcements, MySQL, Percona Software, XtraDB Cluster

Post: Analyzing air traffic performance with InfoBright and MonetDB

October 2, 2009 By 50 Comments

… 1988 to 2009 in chunks per month, so I downloaded 252 files (for 1988-2008 years) with size from …: 0.5s for MonetDB and 2.92s for InfoBright. Warnings: do not try EXPLAIN this query in InfoBright. MySQL is …Years, InfoBright, MonetDB 1y, 1.74s, 0.55s 2y, 3.68s, 1.10s 3y, 5.44s, 1.69s 4y, 7.22s, 2….

Filed Under: Benchmarks, MySQL Tagged With: , , ,