June 19, 2013

Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL

May 1, 2013 By 10 Comments

… to achieve better consistency, if you have an async master <= 5.0 though, you can workaround this by turning off wsrep_auto… the previous bug has been fixed on latest release (5.5.30-23.7.4), table without PK imposes an additional overhead, and…

Filed Under: Insight for DBAs, MySQL, Percona Software, XtraDB Cluster Tagged With: , , , ,

Comment: Percona Server 5.5.30 with TokuDB for MySQL

April 25, 2013 By 26 Comments

….percona.com) 5.5.30-tokudb-7.0.1-tokudb-7.0.1-tokudb-7.0.1-tokudb-7.0.1-tokudb-7.0.1-tokudb-7.0.1-tokudb-7.0.1-tokudb-7.0.1-29.3 started; log sequence number 1597971 Version: ‘5.5.30-tokudb-7.0.1-tokudb-7.0…

Filed Under: MySQL, Percona Server, Percona Software Tagged With: ,

Comment: Percona Server 5.5.30 with TokuDB for MySQL

April 29, 2013 By 26 Comments

…/mariadb-5.5.30-tokudb-7.0.1/storage/tokudb TOKUPORTABILITY_LIB linked by target “tokudb” in directory /data/tmp/mariadb-5.5.30-tokudb-7.0.1…

Filed Under: MySQL, Percona Server, Percona Software Tagged With: ,

Comment: Percona Server 5.5.30 with TokuDB for MySQL

April 27, 2013 By 26 Comments

For Fedora users, Fedora 18 binaries are there http://www.percona.com/redir/downloads/TESTING/Percona-TokuDB/percona-5.5.30-tokudb-7.0.1-fedora-x86_64.tar.gz

Filed Under: MySQL, Percona Server, Percona Software Tagged With: ,

Post: MySQL 5.6.7-RC in tpcc-mysql benchmark

October 8, 2012 By 22 Comments

…, I bumped into two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql workload… how MySQL 5.6.7 performs Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel(R) Xeon(R) CPU E5-2660 0 @ 2.20GHz Memory: 192GB Storage: Very Fast PCIe Flash Card Filesystem: ext4 Software OS: CentOS 6.3 MySQL Version: 5.6.7…

Filed Under: Benchmarks, MySQL

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

…0.000049 | 0.000117 | 0.000000 | 0.001000 | 0 | 0 | 0 | 0 | 3 | 3 | | 8 | optimizing | 0.000048 | 0.000048 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0 | 8 | 8 | | 7 | System lock | 0.000031 | 0.000031 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0…

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

Post: TPC-H Run on MySQL 5.1 and 6.0

April 10, 2008 By 16 Comments

… than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query1370.50372.161… you can get an idea – This system has geomean of 7.7 sec for Power test which is good order of magnitude… more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737.540.99 Query2NANANA Query3NANANA Query4NANANA Query5NANANA…

Filed Under: Benchmarks

Post: Implications of Metadata Locking Changes in MySQL 5.5

February 1, 2013 By 9 Comments

… number of MySQL 5.0 and 5.1 installations that would upgrade or are in the process of upgrading to MySQL 5.5, I thought… 1 end_log_pos 726 Query thread_id=7 exec_time=0 error_code=0 SET TIMESTAMP=1359714099/*!*/; BEGIN /*!*/; # at 726 # at 773… table metadata lock | ALTER TABLE test_2 DROP COLUMN c | | 7 | msandbox | localhost | test | Query | 195 | Waiting for table metadata lock…

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

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

March 4, 2013 By 7 Comments

… here, but even if there isn’t, 143+130+439 < 0.5 * 7150, so none of these should be treated as stopwords… Wesley Abbott Iii | 0 | | 3 | William Doyle Abbott Jr | 0 | | 5 | Robert Jack Abraham | 0 | | 7 | Mark Allen Abrell | 0 | +——-+————————–+——-+ And with 5.6: mysql: SELECT id…

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

Post: Solving RPM installation conflicts in CentOS 5 and CentOS 6

February 21, 2013 By 6 Comments

… dependencies: Percona-Server-client-55 x86_64 5.5.29-rel29.4.401.rhel6 percona 7.0 M Percona-Server-shared-51 x86_64… to install PS 5.5 alongside packages that depend on 5.1/5.0, the -shared packages will work together. For example installing 5.5 and postfix… PS 5.5 without conflict. The current package candidates for versions 5.0.92 (which required an update), 5.1.67-14.3 and 5.5.29…

Filed Under: MySQL Tagged With: , , , , , ,
« Older Posts
Newer Posts »