by Jervin Real | Dec 29, 2011 | Insight for DBAs
Upgrades are usually one of the biggest part of any database infrastructure maintenance. Even with enough planning something else can go bad after sending your production application to the version you’ve upgraded to. Let’s look at how one Percona Toolkit...
by Miguel Angel Nieto | Dec 29, 2011 | MySQL
Until MySQL 5.5 the only variable used to identify a network connectivity problem between Master and Slave was slave-net-timeout. This variable specifies the number of seconds to wait for more Binary Logs events from the master before abort the connection and...
by Ovais Tariq | Dec 29, 2011 | Insight for DBAs, MySQL
Overview Profiling, analyzing and then fixing queries is likely the most oft-repeated part of a job of a DBA and one that keeps evolving, as new features are added to the application new queries pop up that need to be analyzed and fixed. And there are not too many...
by kuszmaul | Dec 28, 2011 | MySQL
The MySQL council is looking for candidates for 2012. Based on community feedback, this will be an open nomination process (and you can nominate yourself). The MySQL council advocates for the MySQL community, and needs community leaders to help address issues such as...
by David Hildebrandt | Dec 27, 2011 | Insight for DBAs, Insight for Developers, MySQL, Percona Events
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.
by Peter Zaitsev | Dec 23, 2011 | Insight for DBAs, MySQL
Many of us find INFORMATION_SCHEMA painfully slow to work it when it comes to retrieving table meta data. Many people resort to using file system tools instead to find for example how much space innodb tables are using and things like it. Besides being just slow...
by Baron Schwartz | Dec 23, 2011 | Insight for DBAs, MySQL, Percona Events
Update: Percona will no longer be offering the free services of Query Analyzer and MySQL Configuration Generator hosted at tools.percona.com. We made this decision based on observed low usage numbers, outdated technology, and lack of support for MySQL 5.7+, MongoDB,...
by Tokutek | Dec 22, 2011 | MySQL
Hot Schema changes are a powerful capability which we use to minimize downtime during system-wide upgrades and shorten our application/schema development cycle.
by Stewart Smith | Dec 22, 2011 | MySQL
Once upon a time, it would have been considered madness to even attempt to create 30,000 tables in InnoDB. That time is now a memory. We have customers with a lot more tables than a mere 30,000. There have historically been no tests for anything near this many tables...
by patrick.crews | Dec 21, 2011 | MySQL
Not everyone may know this, but there are precious few innodb crash recovery tests available. Some folks have noticed this and asked for something to be done about it, but unfortunately, no tests have been created for the main MySQL branch. The MySQL at Facebook...
by Tokutek | Dec 20, 2011 | MySQL
It’s almost the end of the year – that means holiday cards, shopping, cooking, parties, and the inevitable year-end top lists (including gems like this one). In the spirit of end of year list making, we fed our 60+ blogs this year through Google...
by Baron Schwartz | Dec 20, 2011 | MySQL, Percona Events
Not to be outdone by Vadim’s announcement, I also have one: Percona Toolkit’s manual is now available as PDF (requires registration). You can get it here: https://www.percona.com/software/percona-toolkit/ Thanks to Mauricio Stekl, who did all the hard work...
by Vadim Tkachenko | Dec 20, 2011 | Percona Software
This is to announce that we released the PDF version of Percona Server documentation (5.1 and 5.5 releases), you can download it from our web site https://www.percona.com/software/percona-server/ (it will require registration).
by Stewart Smith | Dec 19, 2011 | MySQL
Percona is glad to announce the release of Percona XtraBackup 1.6.4 on 19 December, 2011 (Downloads are available here and from the Percona Software Repositories). These release notes are (as always) available from the online Percona XtraBackup documentation. This...
by Stewart Smith | Dec 19, 2011 | MySQL
Percona is glad to announce the release of Percona Server 5.5.18-23.0 on December 19th, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.18, including all the bug fixes in it, Percona Server 5.5.18-23.0 is now the...
by Stewart Smith | Dec 16, 2011 | MySQL, Percona Software
Percona is glad to announce the release of Percona Server 5.1.60-13.1 on December 16, 2011 (Downloads are available from Percona Server 5.1.60-13.1 downloads and from the Percona Software Repositories). Based on MySQL 5.1.60, including all the bug fixes in it, Percona...
by Jay Janssen | Dec 16, 2011 | MySQL
There are about a gazillion FAQs and HOWTOs out there that talk about XFS configuration, RAID IO alignment, and mount point options. I wanted to try to put some of that information together in a condensed and simplified format that will work for the majority of use...
by Miguel Angel Nieto | Dec 16, 2011 | MySQL
Statement based replication writes the queries that modify data in the Binary Log to replicate them on the slave or to use it as a PITR recovery. Here we will see what is the behavior of the MySQL when it needs to log “not usual” queries like Events,...
by Tokutek | Dec 14, 2011 | MySQL
Limelight Networks Issue addressed: Managing metadata at exabyte scale Delivering Agile Storage in the Cloud with Billions of Assets The Company: Founded in 2001, Limelight Networks, Inc (NASDAQ: LLNW) is an Internet platform and services company that integrates the...
by Frederic Descamps | Dec 14, 2011 | MySQL, Percona Events
2012 is near… and so is the next FOSDEM edition ! This year again, MySQL will be represented by its Community. If you want to discuss with friend’s of MySQL it’s the place to be in February ! Like every year, FOSDEM takes place the first week-end of...
