by Peter Zaitsev | Jan 27, 2014 | MySQL, Percona Services, Webinars
We are nearing the one-year anniversary since MySQL 5.6 went GA – which is typically a good time even for the most conservative users to start thinking about upgrading. At this point there is a fair amount of practical use and experience; many bugs have also...
by Kenny Gryp | Jan 27, 2014 | MySQL, Percona Events
This weekend, on 1-2 February, FOSDEM 2014 will take place in Brussels, Belgium. There will be MySQL talks on Saturday in the MySQL Devroom and a MySQL Community dinner afterward. 30 people have already signed up for the community dinner, we’re almost at the...
by Nilnandan Joshi | Jan 24, 2014 | Insight for DBAs, MySQL, Percona Services
There are many blog posts already written on topics related to “MySQL server memory usage,” but nevertheless there are some who still get confused when troubleshooting issues associated with memory usage for MySQL. As a Percona support engineer, I’m...
by Hrvoje Matijakovic | Jan 24, 2014 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.7 on January 24th, 2014. Downloads are available from our download site here and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.1 series....
by Alexey Stroganov | Jan 23, 2014 | Benchmarks, MySQL, Percona Software
By default, for every client connection the MySQL server spawns a separate thread which will process all statements for this connection. This is the ‘one-thread-per-connection’ model. It’s simple and efficient until some number of connections N is...
by Frederic Descamps | Jan 23, 2014 | MySQL, Percona Events
FOSDEM is a free, yearly event that offers open source communities a place to meet, share ideas and collaborate. It takes place in Brussels, Belgium each February. 10 years ago now, the first MySQL devroom was organized there by David Axmark, marking the first time...
by Stewart Smith | Jan 22, 2014 | MySQL
Early this month I spoke at linux.conf.au in Perth, Australia, where I presented “Past, Present and Future of MySQL and variants.” Here’s my presentation in its entirety. Please let me know if you have any questions or comments. (linux.conf.au is...
by Dave Rosenlund | Jan 21, 2014 | MySQL
You love MySQL and MariaDB for its ease of deployment, but what if you could increase performance and save significant time and money when your application starts to scale without having to change your applications? Register Now! SPEAKER: Tim Callaghan, VP of...
by Ovais Tariq | Jan 21, 2014 | Insight for DBAs, MySQL, Percona Services
The other day I was working on an issue where one of the slaves was showing unexpected lag. Interestingly with only the IO thread running the slave was doing significantly more IO as compared to the rate at which the IO thread was fetching the binary log events from...
by Vadim Tkachenko | Jan 20, 2014 | Percona Software
We’re looking for a full-time web back-end developer to join our team and help continue building the Percona Cloud Tools back end. We use the Go language, so we would love to find a Go programmer, but since Go is a very new language, we’re looking for any great...
by Yves Trudeau | Jan 20, 2014 | Insight for DBAs, MySQL
Over the last few days, I integrated the MySQL 5.6 GTID version of the Percona Replication Manager (PRM) work of Frédéric Descamps, a colleague at Percona. The agent supports the GTID replication mode of MySQL 5.6 and if the master suffers a hard crash, it picks the...
by Jervin Real | Jan 17, 2014 | Insight for DBAs, MySQL
This is a followup to Jay Janssen’s October post, “HaProxy would. keepalived is a simple load balancer with HA capabilities, which means it can proxy TCP services behind it and at the same time, keep itself highly available using VRRP as failover...
by Kenny Gryp | Jan 16, 2014 | MySQL
FOSDEM is coming to town again here in Brussels this February 1-2, and as usual, there is a MySQL Devroom. Traditionally, a MySQL and Friends community dinner is also held during the event and this year is no different – we’ve organized one for Saturday,...
by Vadim Tkachenko | Jan 16, 2014 | MySQL, Percona Software, Webinars
This blog, MySQLPerformanceBlog.com, is powered by WordPress, but we never really looked into what kind of queries to MySQL are used by WordPress. So for couple months we ran a Query Analytics (part of Percona Cloud Tools) agent there, and now it is interesting to...
by Hrvoje Matijakovic | Jan 16, 2014 | Percona Software
Percona Cloud Tools, a new service currently in beta, applies Percona’s MySQL expertise to identify the best opportunities for application performance improvement. The first component of Percona Cloud Tools that’s now available is Query Analytics. Based on...
by Terry Erisman | Jan 15, 2014 | MySQL, Percona Events, Percona Live
I’m very pleased to announce that the breakout session and tutorial schedules for the third annual Percona Live MySQL Conference and Expo 2014 are now online. The conference will be at The Hyatt Regency Santa Clara and Santa Clara Convention Center, April 1-4,...
by Jay Janssen | Jan 15, 2014 | MySQL, Webinars
I’ve been blogging a lot about some of the new things you can expect with Percona XtraDB Cluster 5.6 and Galera 3.x – and GA is coming soon. To get prepared, I’ll be giving a webinar on February 5th at 1PM EST/10AM PST to talk about some of the big...
by Fernando Laudares Camargos | Jan 14, 2014 | Insight for Developers, MySQL
UPDATED: explaining the role of innodb_strict_mode and correcting introduction of innodb_file_format Compressed tables is an example of an InnoDB feature that became available with the Barracuda file format, introduced in the InnoDB plugin. They can bring significant...
by Bill Karwin | Jan 13, 2014 | Insight for DBAs, Insight for Developers, Webinars
On January 22 I’ll be presenting the first of a series of two new webinars focusing on avoiding common MySQL mistakes: How to Avoid Common (but Deadly) MySQL Operations Mistakes. “Don’t bother me with DBA ‘best practices,’ we have real work to get done.” So go...
by Yves Trudeau | Jan 10, 2014 | Insight for DBAs, MySQL, Percona Software
Most technologies achieving high-availability for MySQL need a load-balancer to spread the client connections to a valid database host, even the Tungsten special connector can be seen as a sophisticated load-balancer. People often use hardware load balancer or...
