Monthly Archives - April 2011

Sysbench with support of multi-tables workload

We just pushed to sysbench support for workload against multiple tables ( traditionally it used only single table).
It is available from launchpad source tree lp:sysbench .
This is set of LUA scripts for sysbench 0.5 ( it supports scripting), and it works following way:
– you should use –test=tests/db/oltp.lua to run OLTP test
i.e. prepare

Shell

./sysbench –test=tests/db/oltp.lua –oltp-tables-count=25 […]

Read more

Scalr and MNPP

Good news for all Percona Software users out there. There are more ways how you can get access to Percona Software. If you’re using Scalr (See also Scalr Project on Google Code) you might be interested in Percona Server roles support Scalr team has announced recently. If you’re Mac user […]

Read more

Percona Server 5.5.11-20.2 Stable Release

Percona Server 5.5.11-20.2 is now available for download, including an experimental build for MacOS. Released on April 28, 2011, it is the current stable release in the the 5.5 series.

New Features

HandlerSocket, a NoSQL plugin for MySQL, has been updated to the latest stable version as April 11th, 2011.

InnoDB fast index creation now works […]

Read more

Effective MySQL, a New York City Meetup

Kudos to Ronald Bradford for creating a new MySQL meetup group in New York city and giving MySQL related talks. The next one is tonight, titled “MySQL Idiosyncrasies That Bite”. Information on it can be found at http://ny.effectivemysql.com/events/16884850/.
We’ll have a contingent from our New York office there this evening. We went to the last […]

Read more

Performance Schema overhead

As continuation of my CPU benchmarks it is interesting to see what is scalability limitation in MySQL 5.6.2, and I am going to check that using PERFORMANCE SCHEMA, but before that let’s estimate what is potential overhead of using PERFORMANCE SCHEMA. So I am going to run the same benchmarks (sysbench read-only and […]

Read more

MySQL at Facebook, present and future

Harrison Fisk, from the Facebook database team, will be in New York City delivering the closing keynote at Percona Live next month. He’ll be talking about the present status and future plans for MySQL inside Facebook’s environment. As you probably know, Facebook is one of the largest users of MySQL, with their […]

Read more