Buy Percona ServicesBuy Now!

Percona Server scalability on multi-cores server

 | September 29, 2010 |  Posted In: Benchmarks, MySQL

We now have hardware in our test lab that represents the next generation of commodity servers for databases. It’s a Cisco UCS C250 server, powered by two Intel Westmere CPUs (X5670 @ 2.93GHz). Each CPU has 6 cores and 12 threads. The most amazing part is the amount of memory. It has 384GB of RAM, which is […]

Read More

Diagnosing and fixing MySQL Performance Problems in Russian in Moscow, Russia

 | September 27, 2010 |  Posted In: Events and Announcements, MySQL

During my visit to Moscow, Russia next month I’m going to give a full day training/tutorial presentation on Diagnosing and Fixing MySQL Performance Problems . This even will be based on updated and expanded tutorial from MySQL Conference & Expo which was so popular it was sold out earlier this year. This also will be […]

Read More

Percona Server 5.1.50-rel11.4

 | September 27, 2010 |  Posted In: MySQL, Percona Software

Dear Community, Percona Server version 5.1.50-rel11.4 is now available for download. The changes in this release include: New features The primary purpose of this release is to update to the latest version of MySQL 5.1. Percona Server 5.1.50-rel11.4 is now based on MySQL 5.1.50. Fixed bugs innodb_use_sys_stats_table – The

table is now used only […]

Read More

More on dangers of the caches

 | September 23, 2010 |  Posted In: Insight for Developers, MySQL

I wrote couple of weeks ago on dangers of bad cache design. Today I’ve been troubleshooting the production down case which had fair amount of issues related to how cache was used. The deal was as following. The update to the codebase was performed and it caused performance issues, so it was rolled back but […]

Read More

Instrumentation and the cost of Foreign Keys

 | September 20, 2010 |  Posted In: Insight for Developers, MySQL

I occasionally get in to light arguments healthy discussions with students about whether or not to use Foreign Key constraints on InnoDB tables.  My standard response has always been: “it depends on how much of a tradeoff you are willing to make for performance. In some situations the cost can be considerable”. .. that’s when […]

Read More

Scenarios where TokuDB’s Loader is Used

 | September 16, 2010 |  Posted In: Tokutek, TokuView

TokuDB’s loader uses the available multicore computing resources of the machine to presort and insert the data. In the last couple of posts (here and here), Rich and Dave presented performance results of TokuDB’s loader. Comparing load times with TokuDB 2.1.0, Rich found a 2.1x speedup on a 2 core machine, and a 4.2x speedup […]

Read More

Percona Server 5.1.49-rel12.0

 | September 15, 2010 |  Posted In: MySQL, Percona Software

Dear Community, Starting with this release, we introduce a new release model for Percona Server. From now on, we will have both Stable and Release Candidate releases. Release Candidates will introduce new features not yet available in Stable releases. Along with new features, our new 5.1.49-12.0 RC contains a couple of patches from the Facebook-MySQL […]

Read More

Cache Miss Storm

 | September 10, 2010 |  Posted In: Insight for Developers, MySQL

I worked on the problem recently which showed itself as rather low MySQL load (probably 5% CPU usage and close to zero IO) would spike to have hundreds instances of threads running at the same time, causing intense utilization spike and server very unresponsive for anywhere from half a minute to ten minutes until everything […]

Read More

Percona Server 5.1.49-rel11.3

 | September 10, 2010 |  Posted In: Percona Software

Dear Community, Percona Server version 5.1.49-rel11.3 is now available for download. The changes in this release include: New features Percona Server 5.1.49-rel11.3 is based on MySQL 5.1.49. A new variable was introduced: innodb_use_sys_stats_table. If ON, the table’s statistics are stored statically in the internal table SYS_STATS. The table is populated with the ANALYZE TABLE command. […]

Read More

First Sphinx Conference is Announced

 | September 10, 2010 |  Posted In: Events and Announcements

The First ever Sphinx Users Conference is announced to take place in Moscow, Russia on October 24th, which is the Sunday before conference, so if you’re attending that you may just drop by to this event too. this is going to be free technically focused event, close in spirit to Percona Performance Conference, we […]

Read More