by Baron Schwartz | Feb 21, 2011 | MySQL, Percona Software
This week’s announcement is short: last week was pretty much all-hands-on-deck for our first 5.5.8 release. Still, it wasn’t ALL about the new release: The beta release of Percona Server 5.5.8 is out! More details in the release notes. There are ongoing...
by Tokutek | Feb 18, 2011 | MySQL
This was an interesting week for data discussions in the Boston area. There were two back-to-back events this week — Big Data on Wednesday night hosted by TiE Boston and Channeling the Big Data Tsunami by MassTLC on Thursday morning. With desperate sounding...
by Baron Schwartz | Feb 17, 2011 | Insight for DBAs, MySQL
For a long time, I’ve used a little trick to check whether there are syntax errors in a server’s my.cnf file. I do this when I need to shut down and restart the server, and I’ve either made changes to the file, or I’m worried that someone else...
by Fred Linhoss | Feb 16, 2011 | MySQL, Percona Software
It’s finally here! Percona Server Percona Server 5.5.8-20.0 is now available for download. This is a beta release of Percona’s enhancements to the MySQL 5.5.8 server. Here are some highlights: Performance and scalability improvements throughout the server...
by Yves Trudeau | Feb 16, 2011 | Cloud, MySQL
This post is the sixth of a series that started here. From the previous posts of this series, we now have an HA MySQL service running on EC2. We now need to find a way to point the web servers or application servers to the HA MySQL service. Normally, in an HA setup,...
by Yves Trudeau | Feb 15, 2011 | Cloud, MySQL
This post is the fifth of a series that started here. From the previous posts of this series, we now have nearly everything setup, only a few pieces are missing. One of the missing pieces is the Pacemaker script that run on the MySQL instance. First, this script is...
by Baron Schwartz | Feb 14, 2011 | MySQL, Percona Events
This is a cross-posting of an article we wrote for Engine Yard: Rails makes database interaction so simple that it’s easy to forget that the database isn’t always happy with what Rails does to it. Here are three leading mistakes that hurt many Rails applications....
by Michael.Bender | Feb 14, 2011 | MySQL
I gave a talk entitled “How to Index Massive Data Sets Quickly” at the Morrelly Homeland Security Center. The event was hosted at the Long Island Forum for Technology (LIFT) and was jointly supported by NYSTAR and the Stony Brook Sensor CAT. The audience...
by Bill Karwin | Feb 14, 2011 | Insight for Developers, MySQL
Many software developers find they need to store hierarchical data, such as threaded comments, personnel org charts, or nested bill-of-materials. Sometimes it’s tricky to do this in SQL and still run efficient queries against the data. In this blog, I’ll...
by Baron Schwartz | Feb 14, 2011 | Insight for DBAs, MySQL
Much has been written about tools to inspect Linux systems, and much has been written about Solaris’s Big Important Tools such as DTrace. But I don’t recall seeing much in the MySQL blogs about basic tools to find one’s way around a Solaris system...
by Baron Schwartz | Feb 13, 2011 | MySQL, Percona Software
Here’s the second installment of the weekly Percona Server news roundup. There’s no team or personnel-related news, so let’s dive right in. Percona Server news: We are working hard on the final touches to Percona Server based on MySQL 5.5! Watch for...
by Peter Zaitsev | Feb 10, 2011 | Insight for DBAs, MySQL
The performance problems caused by battery auto learning go many years back. We wrote about it, other people from MySQL Community too. The situation did not get better, at least not with Dell RAID controllers, H700 and H800 have the same problem too. At the same time...
by Vadim Tkachenko | Feb 7, 2011 | Insight for DBAs, MySQL
Percona was working closely with Virident on evaluating tachIOn as solution for MySQL, and as result you can find whitepaper “Scaling MySQL Deployments Efficiently Using Virident tachIOn Drives”, available from Virident website. It was done as part of our...
by Baron Schwartz | Feb 7, 2011 | Insight for DBAs, MySQL
About a year ago, I started a study of emergency incidents that our customers filed with us. What I found was really surprising, and defied conventional wisdom. I learned a lot about preventing emergencies. I just published the outcome as a white paper, including...
by Baron Schwartz | Feb 6, 2011 | MySQL, Percona Software
I decided to try a series of blog posts keeping people informed about what’s happening in Percona Server and Percona XtraBackup once a week. I’ll try to digest things, but it turns out to be hard — I want to provide details and links for everything,...
by Peter Zaitsev | Feb 5, 2011 | MySQL, Percona Events
I was going to visit Charlotte,NC and talk on MySQL Meetup in January but weather did not cooperate. I’m trying again and I hope this time I’m more lucky. As such I’m speaking on MySQL Meetup in Charlotte,NC 8th of February. If you’re...
by Baron Schwartz | Feb 4, 2011 | Insight for DBAs, MySQL
A customer called with an emergency issue: A server that normally runs many MySQL instances wouldn’t start them up. Not only would it not start all of them, it wouldn’t even start the first one. The multiple instances were started through the mysql_multi...
by Peter Zaitsev | Feb 3, 2011 | Insight for DBAs, MySQL
I’ve been working with an application which does a lot of CREATE and DROP table for Innodb tables and we’ve discovered DROP TABLE can take a lot of time and when it happens a lot of other threads stall in “Opening Tables” State. Also contrary...
by Ewen Fortune | Feb 3, 2011 | Insight for DBAs, MySQL
Xaprb (Baron) recently blogged about how InnoDB performs a checkpoint , I thought it might be useful to explain another important mechanism that affects both response time and throughput – The transaction log. The InnoDB transaction log handles REDO logging,...
by Tokutek | Feb 2, 2011 | MySQL
I am delighted to announce that Dr. Bradley Kuszmaul, Co-Founder and Chief Architect at Tokutek, has been appointed to the IOUG’s first MySQL Council. In the announcement on the IUOG website, president Andy Flower spoke highly of the MySQL Council’s new members Sarah...
