by Morgan Tocker | Apr 22, 2009 | Percona Events
Having trouble finding the Percona Performance Conference? It’s upstairs near where the registration desk was (aka above the exhibition hall). Hope to see you there today & tomorrow!
by Morgan Tocker | Apr 20, 2009 | Percona Events
This year we’ve assembled a team of seven Perconian representatives for the MySQL Conference & Expo/Percona Performance Conference. If you like a particular blog post we’ve written over the last year, have any other feedback, or just want to say hello...
by Peter Zaitsev | Apr 19, 2009 | Insight for Developers
In the recently released Sphinx version 0.9.9-rc2 there is a support for MySQL wire protocol and SphinxQL – SQL-like language to query Sphinx indexes. This support is currently in its early preview stage but it is still fun to play with. A thing to mention...
by Tokutek | Apr 17, 2009 | MySQL
Tokutek officially announced the TokuDB for MySQL v2.0 Storage Engine, v2.0 on April 16th, 2009. TokuDB uses Fractal Tree (TM) technology to boost MySQL performance for users challenged with interactive querying in high volume, always-on applications. As a pure SW...
by Baron Schwartz | Apr 15, 2009 | Insight for DBAs
Sometimes a MySQL server running InnoDB takes a long time to shut down. The usual culprit is flushing dirty pages from the buffer pool. These are pages that have been modified in memory, but not on disk. If you kill the server before it finishes this process, it will...
by kuszmaul | Apr 10, 2009 | MySQL
Posted by Bradley C. Kuszmaul and David Wells Executive Summary: A MySQL straight join can speed up a query that is very similar to TPC-H Q2 by a factor of 159 on MySQL. Recently, we began looking at TPC-H performance on MySQL. Our early tests yielded unexpectedly...
by Evgeniy Stepchenko | Apr 8, 2009 | Percona Software
Today we glad to announce release 1.0.3-4 of our XtraDB storage engine. Here is a list of enhancements in this release: Move to MySQL 5.1.33 Move to InnoDB plugin 1.0.3 more reliable replication, innodb_overwrite_relay_log_info patch now included in the release fix...
by Vadim Tkachenko | Apr 7, 2009 | Percona Software
I am happy to announce next build of our backup tool. This version contains several bugfixes and introduces initial implementation of incremental backup. Incremental backup works in next way. When you do regular backup, at the end of procedure you can see output: The...
by Vadim Tkachenko | Apr 6, 2009 | Insight for DBAs
No, this is not about Sun and IBM 🙂 This is about MySQL. If you download latest 5.1.33 source code you may find there storage/ibmdb2i directory, which obviously is IBM DB2 related. Interesting that there is no mentioning of new engine in Announcement...
by Vadim Tkachenko | Mar 30, 2009 | Insight for DBAs
Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24 cores boxes for many workloads. And now it is time to look on systems with 32GB+ of RAM which are not rare nowadays. Working with real customer systems...
by Vadim Tkachenko | Mar 30, 2009 | Percona Software
We added some new features to our backup tool, namely: Now we can handle log file taken during backup with size exceeding 4GB, it may happen if backup takes too long and you have a lot of updates on InnoDB tables Progress meter during recovery step, now you can see...
by Peter Zaitsev | Mar 25, 2009 | Insight for DBAs
As larger and larger amount of memory become common (512GB is something you can fit into relatively commodity server this day) many customers select to build their application so all or most of their database (frequently Innodb) fits into memory. If all tables fit in...
by Ryan Lowe | Mar 24, 2009 | Percona Events
The schedule for the 2009 Percona Performance Conference has been released. Take a look, see what interests you, and (optionally) register to come. We look forward to seeing you all there!
by Peter Zaitsev | Mar 24, 2009 | Percona Events
A couple of weeks ago Sphinx Technologies, a company behind Sphinx Full Text Search Engine launched Sphinx Support Packages which I think is a great value for everyone using Sphinx in Production. This is also a great way to support the project and get something in...
by Peter Zaitsev | Mar 23, 2009 | Insight for DBAs
Quite common task during schema review is to find the optimal data type for the column value – for example column is defined as INT but is it really needed or may be SMALLINT or even TINYINT will do instead. Does it contain any NULLs or it can be defined NOT...
by Peter Zaitsev | Mar 20, 2009 | Benchmarks, Percona Events
So a while ago I wrote about fun post about MySQL Scalability to 256 way…. Besides discussion on the thread itself I had a lot of private comments in my mail from Sun/MySQL employees which tended to agree with me on this being the a large stretch. I would hope...
by Baron Schwartz | Mar 19, 2009 | Insight for DBAs
I feel like I’ve been seeing this a lot lately. occasionally, seemingly innocuous selects take unacceptably long. Or Over the past few weeks, we’ve been having bizarre outages during which everything seems to grind to a halt… and then fixes itself...
by Tokutek | Mar 18, 2009 | MySQL
Mark Callaghan recently developed and released an enhanced Python version of Tokutek’s iiBench benchmark (Thanks Mark!). We’re happy to see a Python version of the benchmark as it can now more easily be run by a broader group of people in more diverse...
by Ryan Lowe | Mar 17, 2009 | Insight for Developers
The web is going the way of utf8. Drizzle has chosen it as the default character set, most back-ends to websites use it to store text data, and those who are still using latin1 have begun to migrate their databases to utf8. Googling for “mysql convert charset to...
by Vadim Tkachenko | Mar 16, 2009 | Benchmarks, Insight for DBAs
Playing with last version of xtrabackup and compress it I noticed that gzip is unacceptable slow for both compression and decompression operations. Actually Peter wrote about it some time ago, but I wanted to review that data having some new information. In current...
