May 25, 2012

Post: Zero-Downtime Schema Changes In MySQL

…, as well as a PDF of my slide deck, is now available. You can watch the recording and get the slides…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would…

Post: Percona Server 5.5.23-25.3 released!

… on MySQL 5.5.23, including all the bug fixes in it, Percona Server 5.5.23-25.3 is now the… internal SYS_STATS table was corrupted or overwritten. This is now fixed by detecting the corruption and creating a new SYS…

Post: Announcement of Percona XtraDB Cluster 5.5.23

…. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes…

Post: Zero-downtime schema changes webinar recording

The recording and slides for my webinar on zero-downtime schema changes with MySQL are available now. Don’t miss Vadim’s webinar tomorrow!

Post: Percona Server 5.1.62-13.3 released!

… on MySQL 5.1.62, including all the bug fixes in it, Percona Server 5.1.62-13.3 is now the…

Post: Percona Server 5.5.22-25.2 released!

… on MySQL 5.5.22, including all the bug fixes in it, Percona Server 5.5.22-25.2 is now the…

Post: Benchmarking single-row insert performance on Amazon EC2

… 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made… that the insert rate was decreased. Conclusion As we all now there are pros and cons to using secondary indexes. While…

Post: Testing Intel SSD 520

… with some instability, which I will research in later charts. Now, random reads, still asynchronous It gives almost stable 370 MiB… good question how does it affect MySQL performance, and I am going to run some MySQL workloads on these cards to understand… you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It…

Comment: How to calculate a good InnoDB log file size

Hi! I come from Viet Nam. Now i want to check capacity (free space & used space) of datafile on InnoDB (MySQL). How to command? I just research for MySQL, hope you help me. Big thanks!

Comment: mysql-proxy, urgh performance and scalability ?

… long trial we have given up on mysqld, and now moving towards mysql-proxy as a solution for production server. was wondering…