?

Log in

No account? Create an account

Regression, The Bummer

« previous entry | next entry »
Jun. 10th, 2009 | 12:14 pm

Wahoo!

We finally found the regression problem in Drizzle that we have been looking for over the last couple of months.

In the processes of doing this was have walked every line of code. I sat the other night doing a single step through the entire sysbench run looking for anything out of place. Nothing came up at all.

Eric was the person who finally asked the question "could it be tcmalloc"? No one had assumed it because it typically is a good solution (and we will be looking into why it turned out to be at fault, we will probably push now to more aggressively remove the MEMROOT system we inherited since we suspect it/it doesn't play well with C++).

We have not been able to push any patches in the last couple of months that really fixed other performance issues that we know exist.

Why?

Because we feared complicating the problem of finding the original problem. We have all spent time looking through our ancestors to see if there was something we missed.

1) Could it be C++?
2) Could reducing the number of locks, creating a traffic jam around a single lock?
3) Was UTF-8 at fault?

In the end it was none of these :)

So for us?

We have patches coming soon to optimize the UTF-8 system, to minimize LOCK_open, optimize/simplify the THR lock system simpler, and to partition caches internally.
chart.png

Link | Leave a comment | Share

Comments {1}

Thrad Handling Bottlenecks

from: ext_193286
date: Jun. 11th, 2009 09:40 am (UTC)
Link

Hi Brian,

Can you do the same benchmark on Solaris systems? Following article pictures a solid performance on Solaris when # of threads increases. Although, Allan benchmarked MySQL 5.4 on Linux and Solaris, I wonder how it will go using drizzle.
http://blogs.sun.com/allanp/entry/mysql_5_4_scaling_on

Kind regards,
--
Mikiya

Reply | Thread