June 18, 2013

Post: Testing the Group Commit Fix

July 13, 2011 By 13 Comments

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

Filed Under: MySQL

Post: Copying InnoDB tables between servers

July 31, 2009 By 11 Comments

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

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

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…@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 : 4… MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server …

Filed Under: Insight for Developers Tagged With:

Post: Make your file system error resilient

August 24, 2011 By 8 Comments

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

Filed Under: Hardware and Storage, Insight for DBAs, MySQL

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

December 18, 2008 By 30 Comments

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

Filed Under: Benchmarks Tagged With:

Post: Advanced index analysis with mk-index-usage

November 11, 2010 By 2 Comments

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

Filed Under: Insight for DBAs, MySQL

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

March 28, 2011 By 4 Comments

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

Filed Under: Benchmarks, Cloud and NoSQL, MySQL

Post: Improved InnoDB fast index creation

November 6, 2011 By 4 Comments

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

Filed Under: Benchmarks, Insight for DBAs, MySQL

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

March 4, 2013 By 7 Comments

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

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

Comment: Announcing Percona XtraDB Cluster 5.5.29-23.7.1

February 3, 2013 By 8 Comments

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

Filed Under: Events and Announcements, MySQL, Percona Software, XtraDB Cluster
« Older Posts
Newer Posts »