by Baron Schwartz | Mar 15, 2011 | MySQL, Percona Software
The xtrabackup compiled C binary (as distinct from XtraBackup, which is the combination of the C binary and the Perl script) has support for printing out stats on InnoDB tables and indexes. This can be useful to examine whether you’d benefit from...
by Baron Schwartz | Mar 15, 2011 | Cloud, MySQL
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see SSD versus EBS death match), and one of them wanted to evaluate RDS as a...
by Ryan Lowe | Mar 14, 2011 | Cloud, MySQL, Percona Events
On March 29th, I’ll be giving a webinar whose title is “Understanding HandlerSocket – A NoSQL PlugIn For MySQLâ€. This is a continuation and extension of the talk I gave during the Percona Live Event in San Francisco back in February. We’ll ask, and...
by Baron Schwartz | Mar 13, 2011 | MySQL, Percona Software
Welcome to the weekly roundup and progress report. What’s new this week in Percona Server: As you might have seen, we released Percona Server 5.1.55-12.6. This release also updated our repositories for Debian Squeeze. We’re enhancing the PROCESSLIST to...
by Martin.FarachColton | Mar 11, 2011 | MySQL
In Part 1, and Part 2 of this series, I presented some thoughts on partitioning. I heard some great feedback on why people use partitioning. Here, I present a flow chart that summarizes what I’ve learned. In summary: with TokuDB in the picture there’s...
by Peter Zaitsev | Mar 8, 2011 | Insight for DBAs, MySQL
There are many angles you can look at the system to predict in performance, the model baron has published for example is good for measuring scalability of the system as concurrency growths. In many cases however we’re facing a need to answer a question how much...
by Baron Schwartz | Mar 8, 2011 | Insight for DBAs, MySQL
Among the many things that can cause a “server stall” is a long-running transaction. If a transaction remains open for a very long time without committing, and has modified data, then other transactions could block and fail with a lock wait timeout. The...
by Baron Schwartz | Mar 8, 2011 | Percona Events
Customer 1000 has signed on with Percona (press release). Many thanks to all of our customers!
by Fred Linhoss | Mar 7, 2011 | MySQL, Percona Software
Percona Server version 5.1.55-12.6 is now available for download. It is now the current stable release version. Changes Fixed compiler warnings in both the core server and in XtraDB. (Alxey Kopytov, Yasufumi Kinoshita) Bugs Fixed Bug #602047 – The ROWS_READ...
by Baron Schwartz | Mar 6, 2011 | MySQL, Percona Software
What’s new this week in Percona Server: For users who upgraded to Squeeze, the new version of Debian, we’re expecting to support Squeeze in our repositories on the next release based on MySQL 5.1.55, which we estimate will be released on March 9th. This...
by Baron Schwartz | Mar 3, 2011 | Insight for DBAs, MySQL
We receive many requests for help with server stalls. They come under various names: lockup, freeze, sudden slowdown. When something happens only once or twice a day, it can be difficult to catch it in action. Unfortunately, this often leads to trial-and-error...
by Tokutek | Mar 3, 2011 | MySQL
As Huey Lewis once noted, sometimes it’s “Hip To Be Square.” Apparently, occasionally, someone even pays attention to you when you are. Xconomy just featured “10 Boring Boston-Area Tech Companies That Are Actually Interesting” and we made the cut. As they note...
by Baron Schwartz | Mar 2, 2011 | Insight for DBAs, MySQL
A common misunderstanding about innodb_support_xa is that it enables user-initiated XA transactions, that is, transactions that are prepared and then committed on multiple systems, with an external transaction coordinator. This is actually not precisely what this...
by Baron Schwartz | Feb 28, 2011 | Benchmarks, MySQL
Before I begin, a disclaimer. VoltDB is not a customer, and did not pay Percona or me to investigate VoltDB’s scalability or publish this blog post. More disclaimers at the end. Short version: VoltDB is very scalable; it should scale to 120 partitions, 39...
by Baron Schwartz | Feb 28, 2011 | Hardware and Storage, MySQL
We’ve published a new white paper that explains how to stop sharding and start scaling vertically with PCI-E flash drives, specifically the Virident tachIOn drive, which offers consistent, low-latency IO performance. I’ve been beating this drum for a...
by Vadim Tkachenko | Feb 27, 2011 | Percona Events
Percona is pleased to extend a belated welcome to Alexey Kopytov. He actually joined us back in November, 2010, but we somehow overlooked blogging then about his switch from Oracle to Percona. Alexey has over six years of work deep in MySQL source code as part of...
by Baron Schwartz | Feb 27, 2011 | MySQL, Percona Software
Percona Server has a new logo: Other news for Percona Server: Many users noticed that our repositories don’t work for Debian Squeeze, the new version of Debian. Our repositories will support Squeeze on the next release, which will be based on MySQL 5.1.55. We...
by Baron Schwartz | Feb 24, 2011 | MySQL, Percona Events
We have a special Friends of Percona discount code that you can use to get 20% off of registration at the MySQL conference in April: mys11pkb. If you click the image to the left, or this special link, it will pre-fill the code for you when you check out. Read on to...
by Tokutek | Feb 24, 2011 | MySQL
John Partridge, President and CEO of Tokutek, sits down to talk about MySQL performance and scalability with the Wikibon Project’s Dave Vellante at last week’s MassTLC Big Data Summit....
by Baron Schwartz | Feb 21, 2011 | Cloud, Hardware and Storage, MySQL
Is it a good idea to deploy your database into the cloud? It depends. I have seen it work well many times, and cause trouble at other times. In this blog post I want to examine cloud-based I/O. I/O matters a lot when a) the database’s working set is bigger than...
