May 26, 2012

Post: Troubleshooting MySQL Memory Usage

… post is dual. I would encourage MySQL Team at Oracle, MariaDB team or Drizzle team to take a look into solving this problem…

Comment: Benchmarks challenges of XtraDB Cluster

I would be interested to see if IPv4 or IPv6 makes a difference in the benchmarks. And of course MTU size and jumbo frames could be a factor. What about using network bonding or nic teaming (new in linux 3.3?)? This could provide more bandwidth if there are enough network ports available.

Post: Percona welcomes Drizzle 7.1

The Drizzle team has published the first Drizzle 7.1 stable release. The …

Comment: Percona Toolkit 2.1 with New Online Schema Change Tool

Is there any performance report about the tool? My team deal with a big table, and always need to alter it by adding a column for business need. And i also want to know if it’s usefull for MySQL5.5 GA or it’s just for Percona?

Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release

… on coming MySQL User Conference, both Codership and Percona development team will be there, you will have a chance to ask…

Comment: Troubleshooting MySQL Memory Usage

I think it’s worth to say here that the InnoDB team has already made some effort to address memory usage problems: http://blogs.innodb.com/wp/2011/12/improving-innodb-memory-usage-continued/ . Results seem very promising, and also maybe these fixes will allow more precise memory usage monitoring.

Comment: How Does Semisynchronous MySQL Replication Work?

The official documentation agrees with Mark. The important phrase is “a transaction commit on the master blocks AFTER the commit is done.” Mark knows what he’s talking about – he was part of the MySQL team at Google that created semisynchronous replication.

Post: Percona team at Turkey

… believe there is a real job real company and real team mates you work with :) This year we also missed few guys from the team meeting which had to stay home due to various reason but this is surely majority of the team. It is fun to compare this picture to one from…

Post: MySQL Optimizer team comments on TPC-H Results

… a chance to speak to Igor – head of MySQL optimizer team and Timur – both of them expressed concern with TPC-H…-H queries are not targeted ? The reason is MySQL Optimizer Team did not have the goal of optimizing TPC-H queries… TPC-H queries does NOT mean to quantify MySQL Optimizer Team work in any way:)

Post: Announcing Training for Operations Teams

… their technical staff between development, and operations.  The operations team is responsible for tasks such as capacity planning, backup/disaster… a hands on class.  Attendees will be divided into teams, and given a series of challenges to complete on EC2…