Monthly Archives - July 2012

Innodb Table Locks

Innodb uses row level locks right ? So if you see locked tables reported in SHOW ENGINE INNODB STATUS you might be confused and rightfully so as Innodb table locking is a bit more complicated than traditional MyISAM table locks.
Let me start with some examples. First lets run SELECT Query:

Shell

—TRANSACTION 12303, ACTIVE 26 […]

Read more

Percona’s “Developer Training for MySQL” is now available via Live Virtual Training

Today, Percona announces that Live Virtual Training is now an option for busy professionals.
We set out to develop a training solution that balances the time to deliver the content with the amount of time an attendee can participate in a live virtual training (LVT) session. The goal was to ensure there was still time […]

Read more

Thursday’s Emerging Business Technology Meetup in Boston

I’ll be presenting TokuDB at the Emerging Business Technology Meetup in Boston this Thursday night at 6pm at 290 Congress St (near South Station).  The meeting topic is “NewSQL: SQL Technologies Keeping NoSQL Promises” and also includes presentations from Akiban and VoltDB.  Each of us will be highlighting our technology and use-cases, with a […]

Read more

New variable slave_max_allowed_packet for slave servers

One month ago I wrote about how a big read_buffer_size could break the replication. The bug is not solved but now there is an official workaround to ease this problem using a new configuration variable:
slave_max_allowed_packet
This new variable will be available in 5.1.64, 5.5.26, and 5.6.6 and can establish a different limit on the max_allowed_packet […]

Read more

Webinar: Understanding Indexing

Three rules on making indexes around queries to provide good performance
Application performance often depends on how fast a query can respond and query performance almost always depends on good indexing. So one of the quickest and least expensive ways to increase application performance is to optimize the indexes. This talk presents three simple and […]

Read more

Announcing Percona Server 5.5.25a-27.1

Percona is glad to announce the release of Percona Server 5.5.25a-27.1 on July 21st, 2012 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.5.25a, including all the bug fixes in it, Percona Server 5.5.25a-27.1 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can […]

Read more

News Flash: SQL Injection Still a Problem

The threat of SQL injection has appeared prominently in the news recently:

An SQL injection vulnerability resulted in an urgent June bugfix release of Ruby on Rails 3.x.  Make sure you upgrade if you use Rails 3.0, 3.1, or 3.2!  Also you should disable mass assignment in any Rails project.
Yahoo! Voices was hacked in July.  The attack […]

Read more