… release in the 2.0 series. New Features: This version of Percona XtraBackup has implemented full support for … and slow IO then XtraBackup can spend a lot of time opening all the tablespaces. Optimization … has. Fixed by adding -DENABLE_DTRACE=OFF build option for innodb56 as well. Bug fixed #1169509…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…a lot of things like how to build…version is, and I check (with the ‘file’ command) whether /usr/libexec/mysqld is a 64-bit build, if I’m on a…a few snapshots of SHOW FULL PROCESSLIST, and look for odd values in this. For example, if I see a lot…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…a build phase and a probe phase. Let’s consider the case of joining two tables on a… has a nicely simplified version of … `o_totalprice` decimal(10,2) DEFAULT NULL, `o_…a where clause on a ‘non-indexed’ column In this test we can clearly see that Hash Join gives a lot…join condition (Full Join). The…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… think results will differ a lot with today versions. Results are as follows: The system was 2* Quad Core Xeon … read-write lock split patch (found in Percona Builds) though it is not very significant for this … there is not enough runnable threads to cause full CPU usage, or you may be waiting by…
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
…Full Text Search index configuration and setting proper ft_min_word_len value. Searching for Audi A6 will give you a lot… to be using value 2 because it is …analyze word frequencies and build stop word list which …versions you can set the time limit on query execution it is rather safe to search a…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… Yes. If a page becomes less than half full, a merge is …delete a lot of scattered rows you may not see a “…version with a single thread. Only one read-ahead can be happening on Unix at a… is larger than 768. 2. InnoDB will allocate …build up INSERTS on our clients and insert values 50 or so at a…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…Innodb tables may take a lot of time. Fast Index creation will allow Innodb to build indexes by … instead of handling auto increment lock for full statement duration. The problem with multi value …2 or even MySQL 5.1. I surely would like to see it sooner at least in more flexible community version…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…you will need to build the database binaries from source…pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector –param=ssp… create a backup of the un-patched version in case you… in a comma-separated string. [qc_miss, full_scan, full_join, … slow logging may consume a lot of IO bandwidth and…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… version 0.9.9-rc2 there is a support for MySQL wire protocol and…full text search performance, we already know Sphinx is much faster than MySQL build in full…index for sort MySQL will be a lot faster. First – Sorting. Sphinx is smart…of queries Sphinx was just 1.5-2 times faster. I honestly hoped for …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…command which prints out a lot of internal Innodb performance counters… are different in different versions), you get no …;; 3: len 10; hex 61202020202020202020; asc a ;; *** (2) TRANSACTION: TRANSACTION 0 42313620,… 16K – page size, for full table scan or … is hash index Innodb builds for some pages …
