June 18, 2013

Post: Testing the Group Commit Fix

… online. There are two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix applied….96 344.57 64 60.05 633.89 128 58.18 1066.05 256 57.62 1669.11 As you may… trx=1, Binlog sync=0 trx=1, Binlog sync=1 1 382.39 371.17 381.03 2 800.89 676.39 748.53 4 1385…

Post: Copying InnoDB tables between servers

… remote server you have to run MySQL server ® with XtraDB6 storage engine, you can take one of our binary builds with 5.1.36. On new server we…: 2 indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Post: How Percona does a MySQL Performance Audit

…@db1 ~]$ uname -a Linux hostname.domain 2.6.18-92.el5 #1 SMP Tue Apr 29 13:16:…2.00GHz stepping : 11 cpu MHz : 1995.022 cache size : 4096 KB physical id : 1 siblings : 4 core id : 3 cpu cores : 4MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server

Post: Make your file system error resilient

… good for system running mySQL Server. As far as I understand this problem is limited to EXT2/3/4 while over systems like… 22 23:18:25 2011 Last write time: Wed Aug 24 00:01:56 2011 Mount count: 2 Maximum mount count: -1 Last… is probably not needed for partition you store MySQL data on, as chances are MySQL server is only one doing writes on this…

Post: XtraDB benchmarks - 1.5X gain in IO-bound load

… with CentOS 5.2 as OS. This is quite typical server we recommend to run MySQL on. What is …_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size … remember as Linux kernels 2.6.18+ (which are used on CentOS / RedHat 5.2) are coming with CFQ …

Post: Advanced index analysis with mk-index-usage

MySQL instance — that took ten seconds. And then I set up an SSH tunnel from my laptop to the MySQL Performance Blog server2 | 15 | 30.0000 | | 7675136724153707161 | mpb_wordpress.wp_comments.comment_approved | 2 | 18 | 2.4129 | | 7675136724153707161 | mpb_wordpress.wp_comments.comment_post_ID | 2

Post: MySQL on Amazon RDS part 2: Determining Peak Throughput

… ran a series of 60-second benchmarks on the RDS server, and extracted the transactions per second from them, then used… benchmarks, with the following thread counts: #Threads #TPS 1 44.26 2 78.66 4 183.47 8 316.79 16 527.50… 1333.63 72 1312.06 80 1203.37 88 900.18 96 733.57 104 655.50 112 567.87 The…

Post: Improved InnoDB fast index creation

MySQL bug #57583 MySQL bug #49120 Fast Index Creation page in Percona Server

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

MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In part 1, …18) NOT NULL DEFAULT ”) ENGINE=InnoDB DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.02 sec) mysql: SET GLOBAL innodb_ft_server… the same with a setting of 1 versus a setting of 4. This may or may not be …

Comment: Announcing Percona XtraDB Cluster 5.5.29-23.7.1

1 root root 20427834 Jan 30 18:44 Percona-XtraDB-Cluster-server-5.5.29-23.7.1… kB 00:00 extras | 2.1 kB 00:00 updates | 1.9 kB 00…29-23.7.1.387.rhel5.x86_64 3.4 M Transaction Summary…1.387.rhel5.x86_64 mysql-server conflicts with Percona-XtraDB-Cluster-server-5.5.29-23.7.1.387.rhel5.x86_64 Complete! (1