by Vadim Tkachenko | Jan 28, 2010 | Benchmarks, MySQL
I’ve seen my posts on Ontime Air traffic and Star Schema Benchmark got a lot of interest (links: https://www.percona.com/blog/2010/01/07/star-schema-bechmark-infobright-infinidb-and-luciddb/...
by Fernando Ipar | Jan 26, 2010 | Percona Events
Percona is hiring. As part of our growth process, we introduced the role of the Shift Support Captain in 2009 (see the original announcement here) to provide customers with a 24×7 technical contact person. The Shift Support Team dispatches incoming emergencies,...
by Morgan Tocker | Jan 22, 2010 | MySQL, Percona Events
February and March as busy months for Community events. There’s MySQL University, Fosdem, the Seattle MySQL Meetup & Confoo.ca. Here are the details: February 4th – I’ll be presenting a talk via MySQL University on Optimizing Queries with...
by Morgan Tocker | Jan 21, 2010 | Insight for Developers, MySQL
A while back Friendfeed posted a blog post explaining how they changed from storing data in MySQL columns to serializing data and just storing it inside TEXT/BLOB columns. It seems that since then, the technique has gotten more popular with Ruby gems now around to do...
by Vadim Tkachenko | Jan 20, 2010 | MySQL, Percona Software
We recently released XtraDB-9, and while we did not highlight it in announcement, the release-making feature is ability to save and restore InnoDB buffer pool. The idea is not new and was originally developed by Jeremy Cole (sorry, I do not have the link on hands)...
by Peter Zaitsev | Jan 18, 2010 | Insight for DBAs, MySQL
So you get MySQL or other applications using too much memory on the box or OS behaving funny and using more memory for cache and pushing application to the swap. This causes swapping and causes performance problems. This much is obvious. But how bad is it ? Should you...
by Vadim Tkachenko | Jan 18, 2010 | Benchmarks, MySQL
I appreciate opportunity Jos van Dongen from Tholis Consulting gave me. He granted me access to servers with 8 attached Intel X-25M 80GB MLC cards. The cards attached to 2 Adaptec 5805 raid controllers, with 4 cards per controller. The cost of setup is 8 x 260$...
by Peter Zaitsev | Jan 16, 2010 | Insight for DBAs, MySQL
I generally thought about MySQL replication as being quite low overhead on Master, depending on number of Slaves. What kind of load extra Slave causes ? Well it just gets a copy of binary log streamed to it. All slaves typically get few last events in binary log so it...
by Morgan Tocker | Jan 14, 2010 | MySQL, Percona Events
After a nice long vacation, it’s time to unveil our destinations for public classes in 2010. We are now offering a course for Developers as well as DBAs.  The dates are: Seattle 16 February San Francisco 18-19 February Boston 22-23 February New York City...
by Aleksandr Kuzminsky | Jan 13, 2010 | MySQL, Percona Software
Dear Community, As of today Release 9 of XtraDB storage engine is available. The release includes following new features: The release is base on 1.0.6 version of InnoDB plugin. MySQL 5.1.42 as a base release Separate purge thread and LRU dump is implemented (this...
by Tokutek | Jan 13, 2010 | MySQL
In a follow-up experiment to an earlier post on TokuDB recovery times, I tried to create a better apples-to-apples comparison to InnoDB recovery time. If I measure recovery times when both DBs are doing the same amount of work, TokuDB requires only 2s to recover from...
by Vadim Tkachenko | Jan 13, 2010 | Benchmarks, MySQL
To continue fun with FusionIO cards, I wanted to check how MySQL / InnoDB performs here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin 1.0.6, and XtraDB 1.0.6-9 ( InnoDB with Percona patches). As benchmark engine I used tpcc-mysql with 1000...
by Vadim Tkachenko | Jan 11, 2010 | Benchmarks, MySQL
After my previous benchmarks of FusionIO 160GB SLC card, FusionIO team sent me for the tests another card, FusionIO 320GB MLC. I should say I really appreciate an opportunity to play with this card and with combination of two cards. This card is also not cheap, the...
by Peter Zaitsev | Jan 10, 2010 | Insight for Developers, MySQL
One of the problems I have with Memcache is this cache is passive, this means it only stores cached data. This means application using Memcache has to has to special logic to handle misses from the cache, being careful updating the cache – you may have multiple...
by Morgan Tocker | Jan 9, 2010 | Insight for Developers, MySQL
There was a discussion on LinkedIn one month ago that caught my eye: Database search by “within x number of miles” radius? Anyone out there created a zipcode database and created a “search within x numer of miles” function ? Thankful for any...
by Vadim Tkachenko | Jan 7, 2010 | Benchmarks, MySQL
In my previous rounds with DataWarehouse oriented engines I used single table without joins, and with small (as for DW) datasize (see https://www.percona.com/blog/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/,...
by Rich.Prohaska | Jan 5, 2010 | MySQL
We recently made transactions in TokuDB 3.0 durable. We write table changes into a log file so that in the event of a crash, the table changes up to the last checkpoint can be replayed. Durability requires the log file to be fsync’ed when a transaction is...
