Buy Percona ServicesBuy Now!

Rebuilding MySQL with same options

 | April 8, 2010 |  Posted In: Insight for DBAs, MySQL

Every so often I am working on the system with custom compiled MySQL. How to upgrade to the new MySQL Options while preserving as much of original compilation options as possible if original build scripts are not available ? MySQL distribution has a great script called mysqlbug which was supposed to be used for bug […]

Read More

Announcing New Training Venues for May-August

 | April 8, 2010 |  Posted In: Events and Announcements, MySQL

We’ve just launched training for London, Seattle, San Francisco, Atlanta, Orlando, Columbus, Dallas, San Diego, Denver, Minneapolis, New York City, Chicago & Washington DC.  This is in addition to Los Angeles, Raleigh & Toronto – which had previously been scheduled. If you organize a meetup group in one of these cities, get in touch.  In […]

Read More

Should I buy a Fast SSD or more memory?

 | April 8, 2010 |  Posted In: Hardware and Storage, MySQL

While a scale-out solution has traditionally been popular for MySQL, it’s interesting to see what room we now have to scale up – cheap memory, fast storage, better power efficiency.  There certainly are a lot of options now – I’ve been meeting about a customer/week using Fusion-IO cards.  One interesting choice I’ve seen people make […]

Read More

See us at the O’Reilly MySQL Conference & Expo

 | April 7, 2010 |  Posted In: Tokutek, TokuView

At this year’s O’Reilly MySQL Conference we will be showing the latest version of our MySQL storage engine, TokuDB v3.1. Come visit us at Table T1 in the OEM section of the Exhibit Hall. We will be talking about how TokuDB can dramatically improve performance for: Social Networking applications eCommerce Personalization Logfile Analysis High-speed Webcrawling […]

Read More

fadvise – may be not what you expect

 | April 2, 2010 |  Posted In: Hardware and Storage, MySQL

I often hear suggestion to use

system call to avoid caching in OS cache. We recently made patch for

, which supposes to create archive without polluting OS cache, as like in case with backup, you do not really expect any benefits from caching. However working on the patch, I noticed, that

with […]

Read More