by Vadim Tkachenko | Feb 2, 2011 | MySQL, Percona Events
On February 10, We will be giving a webinar “Managing Big Data with Percona Server, XtraBackup and Tungsten”. This is joint Continuent and Percona Webinar with full description: Big data is a big problem for growing SaaS businesses and large web...
by Morgan Tocker | Feb 2, 2011 | MySQL, Percona Events
We’re down to less than 25 tickets remaining for Percona Live. If you are planning on attending, it might be a good idea to purchase your ticket(s) as soon as possible – we are expecting to sell out.
by Baron Schwartz | Feb 2, 2011 | Insight for Developers, MySQL
The “slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and in the case of Percona Server, a great deal of additional performance and other diagnostic information....
by Tokutek | Feb 1, 2011 | MySQL
Links to the FAQ Sections can be found here: General Information Open Source Technical Details Best Practices and Tools General Information ANY CHARACTER HERE 1. What is TokuDB? TokuDB is an ACID compliant storage engine for MySQL that is specifically designed for...
by Baron Schwartz | Feb 1, 2011 | Insight for Developers, MySQL
Sometimes you just need some data to test and stress things. But randomly generated data is awful — it doesn’t have realistic distributions, and it isn’t easy to understand whether your results are meaningful and correct. Real or quasi-real data is...
by Kenny Gryp | Jan 31, 2011 | MySQL, Percona Events
Kris Buytaert organized a MySQL Meetup at FOSDEM last year, and because of the success we’ll be doing it again this year, in the same restaurant: Sogno d’Italia.Everybody is invited to come to the dinner. Just register on...
by Baron Schwartz | Jan 31, 2011 | Insight for DBAs, MySQL
If you’ve used MySQL’s mysqlbinlog tool, you’ve probably seen something like the following in the output: “exec_time=0” What is the exec_time? It seems to be the query’s execution time, but it is not. In most cases, the exec_time...
by Morgan Tocker | Jan 28, 2011 | MySQL, Percona Events
We’re excited to announce that as well as Percona Live – we will also be holding an evening of Ignite talks on February 16th. For those not familiar the format, you should check out the Best of Ignite from the MySQL conference last year, as well as...
by Martin.FarachColton | Jan 28, 2011 | MySQL
Review In part one, I presented a very brief and particular view of partitioning. I covered what partitioning is, with hardly a mention of why one would use partitioning. In this post, I’ll talk about a few use cases often cited as justification for using...
by Baron Schwartz | Jan 26, 2011 | Hardware and Storage, MySQL
Mat Keep’s blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB’s scalability as the number of cores in the server increases. Vadim runs lots of benchmarks that measure what happens...
by Morgan Tocker | Jan 25, 2011 | MySQL, Percona Events
Today we are announcing Venu Anuganti as a guest speaker to Percona Live: San Francisco. Venu works as a Data architect, evaluating and implementing high performance SQL/NoSQL data store solutions for large scale OLTP and OLAP infrastructure; and previously worked as...
by Martin.FarachColton | Jan 21, 2011 | MySQL
Why Partition a Database? Partitioning is a commonly touted method for achieving performance in MySQL and other databases. (See here, here, here and many other examples.) I started wondering where the performance from partitions comes from, and I’ve summarized...
by Baron Schwartz | Jan 16, 2011 | Percona Events
After more than four years of using a theme that can charitably be described as rustic, we’ve updated our look. We’re using the News theme from StudioPress, which is a bargain; their themes and theme framework are an engineering marvel. We’re still...
by Vadim Tkachenko | Jan 13, 2011 | Benchmarks, MySQL
In my recent benchmarks, such as this one about the Virident TachIon card, I used different values for innodb_buffer_pool_size, like 13GB, 52GB, and 144GB, for testing the tpcc-mysql database with size 100G. This was needed in order to test different memory/dataset...
by Peter Zaitsev | Jan 12, 2011 | Insight for DBAs, MySQL
You might know if you have long running transactions you’re risking having a lot of “garbage” accumulated in undo segment size which can cause performance degradation as well as increased disk space usage. Long transactions can also be bad for other...
by Peter Zaitsev | Jan 12, 2011 | Insight for DBAs, MySQL
A lot of people are running MySQL Master-Master replication pairs in Active-Passive mode for purpose of high availabilities using MMM or other solutions. Such solutions generally have one major problem – you have to be very carefully switching writes as if you...
by Morgan Tocker | Jan 12, 2011 | MySQL, Percona Events
Mark Callaghan has graciously accepted to be the closing keynote speaker for Percona Live: San Francisco! Mark is best known for his work behind MySQL @ Facebook, where he and his team maintain one of the largest MySQL installations around. They also contribute back...
by Peter Zaitsev | Jan 11, 2011 | Insight for Developers, MySQL
When does Innodb Start Transaction ? The answer looks obvious – when you issue “BEGIN” command. This is however wrong answer from engine point of you. Run “SHOW INNODB STATUS” and you will see “not started” status in...
by Peter Zaitsev | Jan 11, 2011 | MySQL, Percona Events
Due to bad weather my flight to Charlotte was canceled today and the only time they could rebook me was the red eye on Friday to arrive on Saturday morning – later than I suppose to be back. As such we have to cancel MySQL Meetup which was scheduled for...
by Fred Linhoss | Jan 11, 2011 | MySQL, Percona Software
Percona Server version 5.1.54-12.5 is now available for download. It is now the current stable release version. Functionality Added or Changed Percona Server 5.1.54-12.5 is based on MySQL 5.1.54. New Features Added: None Other Changes: Added system variable...
