… in 5.5.30 can’t do those except parallel, the one in 5.5.31 will handle them all, also XB 2.1 is… with a single serving process (we are adding one in 5.5.31), looking for optimizations with HAProxy to account for high…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
Comment: Converting Character Sets
June 12, 2013 By 22 Comments
Approach number 1 is correct. There was no truncation: MEDIUMTEXT is bigger than … explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For a column that has a…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…you try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql>… # Summary of indexes # ######################################################################## # Size Duplicate Indexes 9 # Total Duplicate Indexes 1 # Total Indexes 2 By the way, if you…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce the release of Percona Server 5.1.69-14.7… could lead to unresolved package dependencies when installing Percona Server 5.1. Bug fixed #893860. The log tracker thread was unaware of…, bug fixed #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online documentation. Bugs…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only… InnoDB. SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database is cold… better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make… configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure only one of… try to reconfigure the master? This time, replication on slave #1 will stop: 2013-05-17 13:32:08 2563 [ERROR…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
It seems that in 5.5 the second log file is touched even if a rotation …:24:15 CDT 2013 Log sequence number 17750981011 -rw-rw—- 1 mysql mysql 536870912 May 21 22:24 /var/lib/mysql… And from the manual: http://dev.mysql.com/doc/refman/5.5/en/innodb-performance-recovery.html “If you kept the size…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… on MySQL 5.6 GTIDs. You can find part one here. Our goal will be to go from setup #1 to setup…=’rsandbox’,master_password=’rsandbox’,master_port=10001,master_auto_position=1; s0> start slave; # For s1, s3 and s4 mysql> stop… t; +———-+ | count(*) | +———-+ | 0 | +———-+ Can we still use master_auto_position = 1? Let’s hope so, as it is one of the…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… discussed on a previous post in our blog. Starting with 5.1, the new plugin API gives us more flexibility by allowing… Percona Server version I was using for the test (5.5.28-29.1). This is needed as the plugin needs the offset…_offsets=6464, 6512, 4072, 4512, 104, 2584 audit_json_file=1 audit_json_socket_name=/tmp/audit.sock #audit_json_socket…
