May 23, 2012

Post: Zero-Downtime Schema Changes In MySQL

… be resumable, although we don’t yet have a “resume” feature implemented. Q: periodically the ALTER isn’t written to the…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would… the second question, the 2.1 version of the tool does NOT have any features to disable the binary log; my experience…

Comment: Version 1.0 of Percona Monitoring Plugins Released

Hi Baron, I see that the pmp-check-mysql-innodb plugin for Nagios leaves a lot of files (e.g. pmp-check-mysql-innodb.1196) in /tmp. Is that a desired feature? Thanks Daysen

Post: Troubleshooting MySQL Memory Usage

… allocated. This was not much of the problem in MySQL 3.23 when there would only handful of places where memory could be… data feature is used as it can increase amount of resources prepared statements take on server. There is no comparable variables of how… it should be and I’m very hopeful future releases of MySQL, MariaDB or Drizzle bring improvements in this space allowing us…

Post: BOFs and Lightning Talks Announced for Percona Live MySQL Conference & Expo

… speakers, an A-list of sponsors, countless opportunities to engage with the community, and an enthusiastic crowd of MySQL users ensure this is going to be a great event. The conference features 72 breakout sessions, keynotes by leading industry luminaries, an optional day of 16 tutorial sessions, a…

Post: MariaDB 5.3 is released as GA!

… a great development for MySQL users. Users now have more choice than ever — there are three great versions of MySQL that suit different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL

Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release

of the GA release of our new product Percona XtraDB Cluster. Percona XtraDB Cluster is a High Availability and Scalability solution for MySQL… posts on this topic: Percona XtraDB Cluster Feature 1: High Availability Percona XtraDB Cluster Feature 2: Multi-Master replication Create 3 nodes…

Post: InnoDB's gap locks

One of the most important features of InnoDB is the row level locking. This feature provides better concurrency under heavy write load but needs… size 1248, 3 row lock(s), undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id 163… a good source of information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ…

Post: Early Bird Pricing Ends Today for Percona Live MySQL Conference & Expo

… hotel room by registering now. The conference features 72 breakout sessions, an optional day of 16 tutorial sessions, a bustling exhibit hall… Reception and the Wednesday Night Community Networking Reception which will feature the Community Awards and Lightning Talks. Keynote speakers will include… is the “must attend” MySQL event of the year. Already planning to attend? The calls for Birds of a Feather and Lightning Talk…

Post: Diamond Keynote Panel, BOFs, Lightning Talks, and McAfee and AOL Sponsorships

… Ahead for MySQL” which will feature a panel of MySQL industry leaders, including: Sundar Raghavan, director product management at Amazon; Paul Mikesell, CEO of Clustrix… of Lightning Talks, a series of five-minute speaking opportunities during which attendees will propose, explain, exhort, and rant on a variety of MySQL

Post: Community events around Percona Live MySQL Conference and Expo 2012

…: Pythian is stepping in to organize traditional MySQL Community Dinner event during Tutorial Day of the conference (April 10th) SkySQL and MariaDB are hosting SkySQL Solutions Day (April 13) which will feature keynotes by…) whenever you’re attending MySQL Conference and Expo or not. Furthermore Birds of the Feather sessions on Percona Live MySQL Conference and Expo…