Articles having tag: INSIGHT FOR DEVELOPERS

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

I’m excited by all of the recent developments surrounding the Percona Live MySQL Conference and Expo! Our own Baron Schwartz will moderate the Diamond Keynote Panel entitled "Future Perfect: The Road Ahead for MySQL" which will feature a panel...

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

By Terry Erisman

The Percona Live MySQL Conference & Expo is going to be awesome! Great 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...

How to convert MySQL’s SHOW PROFILES into a real profile

By Baron Schwartz

SHOW PROFILES shows how much time MySQL spends in various phases of query execution, but it isn’t a full-featured profile. By that, I mean that it doesn’t show similar phases aggregated together, doesn’t sort them by worst-first, and doesn’t...

Optimize Your SQL With Percona’s Online Query Advisor!

By Baron Schwartz

Wouldn’t it be nice if you could get expert advice on your SQL queries to find problems in them, the same way that programmers can use lint-check tools to warn about bugs in their C? if ( execute = 1 ) { launch_missile(); } Such a simple mistake, but...

linux.conf.au 2012 roundup

By Stewart Smith

I spent last week at linux.conf.au in Ballarat, Victoria (that’s the Victoria in Australia, not wherever else there may be one) which is only a pleasant two hour drive from my home town of Melbourne (Australia, not Florida). I sent an email internally...

MySQL Training in Frankfurt, Germany

By David Hildebrandt

We will be holding our highly acclaimed MySQL workshops in Frankfurt, Germany the week of February 13th. Early registration is open; enroll today and secure your seat. Detail and enrollment can be found here.

MySQL Training in Washington, DC

By DaveH

Many of you have seen the announcement for our Percona Live in Washington, DC in January! But did you know we also have our highly rated MySQL Training coming to Washington, DC the week of\xa0January\xa016h? Full details can be found on the Percona website....

When Does InnoDB Update Table Statistics? (And When It Can Bite)

By Jervin Real

An InnoDB table statistics is used for JOIN optimizations and helping the MySQL optimizer choose the appropriate index for a query. If a table’s statistics or index cardinality becomes outdated, you might see queries which previously performed well suddenly...

Preprocessing Data

By Jonathan Levin

There are many ways of improving response times for users. There are some people that spend a lot of time, energy and money on trying to have the application respond as fast as possible at the time when the users made the request. Those people may miss out...

Percona Server 5.1.57-12.8 Stable Release

By Rodrigo Gadea

Released on June 8, 2011 (Downloads are available\xa0here and from the\xa0Percona Software Repositories. Percona Server 5.1.57-12.8 is now the current stable release in the 5.1 series. It is is based on MySQL 5.1.57. Bug Fixes Fixed InnoDB I/O code so that...