MySQL

Category to track posts in PlanetMySQL

Getting around optimizer limitations with an IN() list

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 tips you can throw my way..
J

A few people commented that some solutions wouldn’t scale. […]

Read more

Star Schema Bechmark: InfoBright, InfiniDB and LucidDB

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/, https://www.percona.com/blog/2009/10/26/air-traffic-queries-in-luciddb/, https://www.percona.com/blog/2009/11/02/air-traffic-queries-in-infinidb-early-alpha/). Addressing these issues, I took Star Schema Benchmark, which is TPC-H modification, and tried run queries against InfoBright, InfiniDB, LucidDB and MonetDB. I did not get results for […]

Read more

Upgrading MySQL

Upgrading MySQL Server is a very interesting task as you can approach it with so much different “depth”. For some this is 15 minutes job for others it is many month projects. Why is that ?
Performing MySQL upgrade two things should normally worry you. It is Regressions – functionality regressions when […]

Read more

Percona is hiring a consultant

We’re hiring. We are looking for the following qualifications:

Expert knowledge of MySQL. Not just “certified” — years of production experience with it. You need to know server internals, for example. You need to be able to do anything from optimizing difficult queries to moving high-volume services between data centers without […]

Read more

There will be no separate Percona Performance Conference in April 2010

Now that O’Reilly has announced they’re going to have a MySQL conference independently of Sun/MySQL, we have decided not to proceed with plans for our own Performance Conference. We are participating in the O’Reilly conference, and we will do everything possible to make that a great success for everyone. See you there!

Read more

xtrabackup-1.0

Dear Community,
As of today release 1.0 is available.
In this release there are following changes:
Changelog:

XtraBackup is ported to Windows. The .MSI package as well as .tar.gz is available for 32 bit platform
Be more verbose on reporting scp errors

Fixed bugs:

Bug #463691 in Percona-XtraBackup: “innobackupex-1.5.1 –help goes to STDERR”
Bug #463709 in Percona-XtraBackup: “innobackupex-1.5.1 –help still references innobackup […]

Read more