June 19, 2013

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

… 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…

Comment: Percona Server 5.5.30 with TokuDB for MySQL

….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

Comment: Percona Server 5.5.30 with TokuDB for MySQL

…/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…

Comment: Percona Server 5.5.30 with TokuDB for MySQL

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

Post: MySQL 5.6.7-RC in tpcc-mysql benchmark

…, 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

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

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

Post: TPC-H Run on MySQL 5.1 and 6.0

… 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…

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

… 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…

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

… 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…