…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would…. Are you using the 2.0 version of this tool? It was completely rewritten in version 2.1. Q: qw() as use… That sounds like you’re using an old version of the tool. Q: Old version of PT OSC said risk in replication…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… of interest and feedback. I am happy to announce next version Percona XtraDB Cluster 5.5.23, which comes with bug… and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
… even be differences based on the database engine and/or MySQL version. Regards, Stefan
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…-%E2%80%93-the-wait-is-over/) on a newer version of iiBench showed that with 16GB of RAM, Inno hits… URL for iibench is slightly incorrect. The correct URL for version you used is http://tokutek.com/downloads/iiBench-1.0… advantages of the newer version of iiBench (the python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
… merge executes in 3.8 secs. I dont understand why MySQL uses index merge after a couple of mins when previously….customize_access, FileTbl.fromdate, FileTbl.todate,LinksTbl2.main_version_id,LinksTbl2.major_version,LinksTbl2.minor_version, LinksTbl2.target, LinksTbl2.item_desc FROM LinksTbl2…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
… Server 12.04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql 5.5 the statement “CHANGE MASTER… see, Yves fixed this in his the last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… connections. Version: ’5.0.95′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution Also, I don’t see how MySQL could be… other conf file other than /etc/my.cnf [root@tstlx1 mysql]# locate my.cnf /etc/my.cnf /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file # Set .._log_file…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… and MySQL. Now as far as the benchmark itself is concerned, I made no code changes to iiBench, and used the version…
Comment: Announcement of Percona XtraDB Cluster 5.5.23
May 15, 2012 By 11 Comments
Thanks for this new version. The IP addresses list feature is a very good idea ! … be announced soon ? Because actually we have to create another mysql instance to do this and it’s not really convenient.
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… statement about replication? I’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs the binary…
