Just as a reminder – tomorrow, May-9, 2012, at 11am PDT I will be giving a free webinar “MySQL and SSD”. This is the same talk I gave on Percona Live MySQL Conference, so if you were there – you probably will find nothing new. Otherwise, you are welcome to join!
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would… in replication environment, I didn’t see that in the new version, does it mean the tool has been well tested…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated… other nodes Improvements to XtraBackup SST methods, better error handling New SST wsrep_sst_method=skip, useful when you start all…. backup) Ability to pass list of IP addresses for a new node, it will connect to the first available Binaries are…
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
… available here and from the Percona Software Repositories). Based on MySQL 5.5.23, including all the bug fixes in it… is now fixed by detecting the corruption and creating a new SYS_STATS table. Bug fixed #978036 (Laurynas Biveinis). Release notes…
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… available here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it… in the 5.1.62-13.3 milestone at Launchpad. New option rewrite-db has been added to the mysqlbinlog utility…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… a partition gets bigger and bigger, then we start a new partition, and Inno starts catching up and the performance starts getting better, and then the new partition starts getting too big, so Inno starts slowing down… python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…:51:16 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size…: ready for connections. Version: ’5.0.95′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution Also, I don’t see how MySQL could be using any other conf file other than /etc…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
… benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO card…? I’m new to Fusion-IO and I am going to do some testing with a couple of MySQL servers with ioDrive2…
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 … be announced soon ? Because actually we have to create another mysql instance to do this and it’s not really convenient.
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… the essential suite of administrative tools for MySQL. With this release we introduce a new version of pt-online-schema-change, a… interruption. With this new version of the tool, one of the most painful things anyone experiences with MySQL is significantly alleviated. If… example, to support new types of RAID controllers. Percona Toolkit is a hot topic at the upcoming MySQL Conference and there will…
