…NAME | SPACE | +————–+—–+——–+——+——–+———+————–+——-+ | sakila/actor | 741 | 4 | 1 | 0 | 0 | | 738 | +————–+—–+——–+——+——–+———+————–+——-+ SYS_INDEXES This… DECIMAL(5,2) type sys_parser will generate DECIMAL(5,0). It…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… cluster permission to continue replication. This setting traditionally defaulted to 0.5, meaning the queue had to fall below 50% of the… Sync T/T 0 29 0 0 0 0 1.0 0 109 0 0 09:22:24 myclu P 3 3 node3 Sync T/T 0 29 0 0 0 0 1.0 0 109 0 0 09:22… Sync T/T 0 29 0 0 0 0 1.0 0 109 0 0 09:22:22 myclu P 3 3 node3 Sync T/T 0 29 0 0 0 0 1.0 0 109 0 0 Notice node3…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… benchmark tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. Each test was… –rand-init=on –report-interval=1 –rand-type=pareto \ –forced-shutdown=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root…_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… MySQL 2.0.6, plus the following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0. Basic support means that these versions… with all the bugfixes for Percona XtraBackup for MySQL 2.1.0-beta1 are available in our online documentation. Bugs can be…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… is glad to announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads are available from our….0 series at the time of writing). New Features: This version of Percona XtraBackup has implemented full support for new MySQL 5… guide. Bugs Fixed: Percona XtraBackup would crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… not work? mysql> select version()\G *************************** 1. row *************************** version(): 5.5.25a-27.1-log 1 row in set (0.00 sec) mysql> show variables like ‘%thread_handling%’\G *************************** 1. row *************************** Variable_name: thread…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… Peter Zaitsev from Percona and the keynote panel on MySQL 5.6 and the future of MySQL in the cloud with… development discipline MySQL 5.0 and 5.1 were rushed and not properly tested but 5.5 and 5.6 were significantly improved and 5.7 promises to… bright with a total projected market size of nearly US$1 billion within the next few years despite the buzz created…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… falling over on 5.0.27. Of course now it’s common to see much higher numbers from NDB and 5.5.x clusters… and stability than life back in the days of MySQL 5.0.x. On that end, I’m in the process of…/wordpress/2013/03/01/building-a-mysql-private-cloud-step-1/ — this will be a series of posts over time (as…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 25, 2013 By 26 Comments
….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…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… $ID=monotonically non-decreasing ID $K=rand(0,10000) // distributed by pareto distribution BEGIN INSERT INTO…safe] numa-interleave malloc-lib=/usr/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/…extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql….
