EmergencyEMERGENCY? Get 24/7 Help Now!

My “hot” list for next InnoDB features

 | March 30, 2009 |  Posted In: Insight for DBAs

Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24 cores boxes for many workloads. And now it is time to look on systems with 32GB+ of RAM which are not rare nowadays. Working with real customer systems I have wish-list of features I would like to see […]

Read More

xtrabackup-0.4, going beta, progress meter

 | March 30, 2009 |  Posted In: Percona Software

We added some new features to our backup tool, namely: Now we can handle log file taken during backup with size exceeding 4GB, it may happen if backup takes too long and you have a lot of updates on InnoDB tables Progress meter during recovery step, now you can see what percentage of log file […]

Read More

Adjusting Innodb for Memory resident workload

 | March 25, 2009 |  Posted In: Insight for DBAs

As larger and larger amount of memory become common (512GB is something you can fit into relatively commodity server this day) many customers select to build their application so all or most of their database (frequently Innodb) fits into memory. If all tables fit in Innodb buffer pool the performance for reads will be quite […]

Read More

Sphinx Technologies launches Sphinx Support

 | March 24, 2009 |  Posted In: Events and Announcements

A couple of weeks ago Sphinx Technologies, a company behind Sphinx Full Text Search Engine launched Sphinx Support Packages which I think is a great value for everyone using Sphinx in Production. This is also a great way to support the project and get something in return – even if you’re not actively using support […]

Read More

PROCEDURE ANALYSE

 | March 23, 2009 |  Posted In: Insight for DBAs

Quite common task during schema review is to find the optimal data type for the column value – for example column is defined as INT but is it really needed or may be SMALLINT or even TINYINT will do instead. Does it contain any NULLs or it can be defined NOT NULL which reduces space […]

Read More

MySQL random freezes could be the query cache

 | March 19, 2009 |  Posted In: Insight for DBAs

I feel like I’ve been seeing this a lot lately. occasionally, seemingly innocuous selects take unacceptably long. Or Over the past few weeks, we’ve been having bizarre outages during which everything seems to grind to a halt… and then fixes itself within 5 minutes. We’ve got plenty of memory, we’re not running into swap, and […]

Read More

MySQL insert performance with iiBench Python client

 | March 18, 2009 |  Posted In: Tokutek, TokuView

Mark Callaghan recently developed and released an enhanced Python version of Tokutek’s iiBench benchmark (Thanks Mark!). We’re happy to see a Python version of the benchmark as it can now more easily be run by a broader group of people in more diverse environments. Going forward, we will continue building upon Mark’s work on the […]

Read More

Converting Character Sets

 | March 17, 2009 |  Posted In: Insight for Developers

The web is going the way of utf8. Drizzle has chosen it as the default character set, most back-ends to websites use it to store text data, and those who are still using latin1 have begun to migrate their databases to utf8. Googling for “mysql convert charset to utf8” results in a plethora of sites, […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.