Buy Percona ServicesBuy Now!

Innodb Table Locks

 | July 31, 2012 |  Posted In: Insight for DBAs, MySQL

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:

As you can […]

Read More

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

 | July 30, 2012 |  Posted In: Events and Announcements, Insight for Developers, MySQL

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

SQL Injection Questions Followup

 | July 26, 2012 |  Posted In: Insight for Developers, MySQL

I presented a webinar today about SQL Injection, to try to clear up some of the misconceptions that many other blogs and articles have about this security risk.  You can register for the webinar even now that I’ve presented it, and you’ll be emailed a link to the recording, which will be available soon. During […]

Read More

Thursday’s Emerging Business Technology Meetup in Boston

 | July 24, 2012 |  Posted In: Tokutek, TokuView

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 panel […]

Read More

New variable slave_max_allowed_packet for slave servers

 | July 24, 2012 |  Posted In: MySQL

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 […]

Read More

Webinar: Understanding Indexing

 | July 23, 2012 |  Posted In: Tokutek, TokuView

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

 | July 21, 2012 |  Posted In: MySQL

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