EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Live NYC Schedule Posted

 | April 22, 2011 |  Posted In: Events and Announcements, MySQL

The first Percona Live conference in San Francisco in February was a huge success, and we’re planning to run several each year. The next one is May 26th in New York City. We’ve just confirmed a number of sought-after speakers and posted the schedule online. We are in the process of confirming sessions from a […]

Read More

Reality of Innodb Caching

 | April 21, 2011 |  Posted In: Insight for DBAs, MySQL

I have mentioned few times Innodb caches data in pages and even if you have working set consisting of relatively few rows your working set in terms of pages can be rather large. Now I came to do a little benchmark to show it in practice. I’m using standard “sbtest” with 10mil rows with data […]

Read More

Percona XtraBackup 1.6 for Windows “try me” edition

 | April 21, 2011 |  Posted In: Events and Announcements, Insight for DBAs, Percona Software

Previously we had XtraBackup Windows binaries for 1.0 and 1.2 releases, and they were based on Cygwin compilation of MySQL. After MySQL 5.5 moved to CMake, and cygwin compilation is not supported anymore, it took some efforts for us to come up with native Windows builds, but they are there already. We consider them “alpha” […]

Read More

Drop table performance

 | April 20, 2011 |  Posted In: Benchmarks, Insight for DBAs, Insight for Developers, MySQL, Percona Software

There have been recent discussions about DROP TABLE performance in InnoDB. (You can refer to Peter’s post https://www.percona.com/blog/2011/02/03/performance-problem-with-innodb-and-drop-table/ and these bug reports: http://bugs.mysql.com/bug.php?id=51325 and http://bugs.mysql.com/bug.php?id=56332.) It may not sound that serious, but if your workload often uses DROP TABLE and you have a big buffer pool, it may be a significant issue. This can get […]

Read More

Coast to Coast – Review of Conferences

 | April 19, 2011 |  Posted In: Tokutek, TokuView

What a busy week – between O’Reilly and Collaborate we gave a number of talks, sponsored a booth, and took some long flights in between the shows. But what an interesting week. The MySQL conference is a great time to catch up with customers and, as always, we heard some excellent feedback on a variety […]

Read More

MySQL Connection Timeouts

 | April 19, 2011 |  Posted In: Insight for DBAs, MySQL

Sometimes on very busy MySQL server you will see sporadic connection timeouts, such as Can’t connect to MySQL server on ‘mydb’ (110). If you have connects timed in your application you will see some successful connections taking well over the second. The problem may start very slow and be almost invisible for long time, for […]

Read More

Percona’s O’Reilly MySQL Conference Community Awards

 | April 18, 2011 |  Posted In: Events and Announcements, MySQL

Percona, and Yasufumi Kinoshita who works for Percona, received two awards from the O’Reilly MySQL Conference co-chairs on behalf of the committee that voted on the nominees. The awards were: to Yasufumi as O’Reilly MySQL Community Contributor of the Year 2011 for InnoDB performance improvements, and to XtraBackup as O’Reilly MySQL Application of the Year […]

Read More

How to use tcpdump on very busy hosts

 | April 18, 2011 |  Posted In: Insight for DBAs, MySQL

Often I run into problems when trying to use mk-query-digest with tcpdump on “very” busy hosts. You might be thinking, “very busy is a relative and unquantifiable term,” and you’d be right, so I’ll phrase this differently. Let me give a little background to the problem first. Mk-query-digest tries to handle dropped or missing packets […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.