by Yves Trudeau | Oct 9, 2009 | Insight for DBAs, MySQL
As my first contribution to the MySQL Performance Blog, I joined Percona at the beginning September, I chose to cover the various high-availability (HA) options available for MySQL. I have done dozen of MySQL HA related engagements while working for Sun/MySQL over...
by Tokutek | Oct 9, 2009 | MySQL
White Paper: Scaling High Performance MySQL Databases
by Baron Schwartz | Oct 8, 2009 | MySQL, Percona Events
I’m happy to extend a warm welcome to two new members of the Percona team. First is Yves Trudeau, about whom I can say many things: One of the top MySQL Cluster (NDB Cluster) experts in the world. An expert on all things High Availability, including DRBD and...
by Vadim Tkachenko | Oct 2, 2009 | Benchmarks, MySQL
Accidentally me and Baron played with InfoBright (see https://www.percona.com/blog/2009/09/29/quick-comparison-of-myisam-infobright-and-monetdb/) this week. And following Baron’s example I also run the same load against MonetDB. Reading comments to Baron’s...
by Baron Schwartz | Oct 2, 2009 | MySQL, Percona Events
I spoke at EdUIConf 2009, a new conference in my hometown of Charlottesville, Virginia. My presentation was on web interface performance; it’s basically a twist on front-end performance in general. I slanted the talk towards web developers, rather than assuming...
by John.Partridge | Oct 1, 2009 | MySQL
TokuDB for MySQL Datasheet
by John.Partridge | Oct 1, 2009 | MySQL
TokuDB for MySQL Performance Brief Performance of TokuDB storage engine as measured by benchmarks and customer lab tests.
by Tokutek | Oct 1, 2009 | MySQL
TokuDB for MySQL Pricing Pricing and licensing terms for TokuDB for MySQL
by Tokutek | Oct 1, 2009 | MySQL
TokuDB for MySQL Evaluation Guide Recommendations for a meaningful evaluation of TokuDB v5.0.
by Vadim Tkachenko | Sep 30, 2009 | MySQL, Percona Events
(This note should not go to PlanetMySQL, sorry if it goes). We again have problem with comments to blog posts. It’s technical problem, we did upgrade some components and it seems it affected captcha. We are working on fix. We are sorry for the inconvenience and...
by Baron Schwartz | Sep 29, 2009 | MySQL
Recently I was doing a little work for a client who has MyISAM tables with many columns (the same one Peter wrote about recently). The client’s performance is suffering in part because of the number of columns, which is over 200. The queries are generally pretty...
by Peter Zaitsev | Sep 28, 2009 | Benchmarks, Insight for Developers, MySQL
It is pretty understood the tables which have long rows tend to be slower than tables with short rows. I was interested to check if the row length is the only thing what matters or if the number of columns we have to work with also have an important role. I was...
by Baron Schwartz | Sep 28, 2009 | Insight for DBAs, MySQL
This is a very old draft, from early 2007 in fact. At that time I started to look into something interesting with the index cardinality statistics reported by InnoDB tables. The cardinality varies because it’s derived from estimates, and I know a decent amount...
by Morgan Tocker | Sep 25, 2009 | MySQL, Percona Events
Our Santa Clara/San Francisco training went great – 100% of survey respondents said they would recommend the same course to a friend. I’m pleased to announce that such an opportunity exists – our next training location will be New York City on...
by Morgan Tocker | Sep 24, 2009 | MySQL, Percona Events
This is a quick announcement to say that I’ll be speaking at HighLoad++ this year (October 12-14 in Moscow). I’ll be presenting on a few topics: MySQL Performance Tuning (Conference Session) Quick Wins with Third Party Patches for MySQL (Conference...
by Peter Zaitsev | Sep 20, 2009 | Insight for Developers, MySQL
I spend large portion of my life working on MySQL Performance Optimization and so MySQL Optimizer is quite important to me. For probably last 10 years I chased first Monty and later Igor with Optimizer complains and suggestions. Here are some general ideas which I...
by Peter Zaitsev | Sep 19, 2009 | Insight for DBAs, MySQL
The mistake I commonly see among MySQL users is how indexes are created. Quite commonly people just index individual columns as they are referenced in where clause thinking this is the optimal indexing strategy. For example if I would have something like AGE=18 AND...
by Tokutek | Sep 18, 2009 | MySQL
We often hear from customers and MySQL experts that fragmentation causes problems such as wasting disk space, increasing backup times, and degrading performance. Typical remedies include periodic “optimize table” or dump and re-load (for example, see...
by Ryan Lowe | Sep 16, 2009 | Insight for DBAs
We often encounter customers who have partitioned their applications among a number of databases within the same instance of MySQL (think application service providers who have a separate database per customer organization … or wordpress-mu type of apps). For...
by Yasufumi Kinoshita | Sep 15, 2009 | Benchmarks, Percona Software
As you may know, InnoDB has 2 limits for unflushed modified blocks in the buffer pool. The one is from physical size of the buffer pool. And the another one is oldness of the block which is from the capacity of transaction log files. In the case of heavy updating...
