MySQL

Category to track posts in PlanetMySQL

Shard-Query turbo charges Infobright community edition (ICE)

Shard-Query is an open source tool kit which helps improve the performance of queries against a MySQL database by distributing the work over multiple machines and/or multiple cores. This is similar to the divide and conquer approach that Hive takes in combination with Hadoop. Shard-Query applies a clever approach to parallelism which […]

Read more

Want a discount to Percona Live?

We’ve given discount coupon codes to all of our Percona Live sponsors, so watch the Twitter tag #perconalive to find discount announcements. Here’s the list of sponsoring organizations: Clustrix Vork Continuent Fusion-io Infobright Pentaho Schooner Information Technology SkySQL Virident Webyog Akiban Couchbase EffectiveMySQL Facebook New Relic OmniTI Sphinx Tokutek We Build Pages Zmanda […]

Read more

Performance Schema tables stats

My previous benchmark on Performance Schema was mainly in memory workload and against single tables.
Now after adding multi-tables support to sysbench, it is interesting to see what statistic we can get from workload that produces some disk IO.
So let’s run sysbench against 100 tables, each 5000000 rows (~1.2G ) and buffer pool 30G.
The scripts […]

Read more

Percona Server and XtraBackup for MacOS – experimental binaries

We see demand on MacOS binaries and decided to prepare binaries you can download and use. The are marked as “experimental”, as we do not have big history of using MacOS in production, so we are looking for your feedback and bug reports.
Binaries:

Percona Server 5.5 : https://www.percona.com/downloads/TESTING/Percona-Server-55/Percona-Server-5.5.11-20.2/release-5.5.11-20.2/114/MacOSX/
Percona Server 5.1: https://www.percona.com/downloads/TESTING/Percona-Server-51/Percona-Server-5.1.56-12.7/release-5.1.56-12.7/226/MacOSX/
Percona XtraBackup: https://www.percona.com/downloads/TESTING/XtraBackup-MacOSX/

Please report […]

Read more

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

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