Schooner has a blog post showing that one node of their product beats 9 nodes of Clustrix’s in throughput. But this reduces everything to a single number, and that’s not everything that matters. If you’ve looked at Vadim’s white paper about Clustrix’s (paid-for) performance evaluation with Percona, you see there is a lot of detail about how consistent the throughput and response time are.

I’d love to see that level of details in any product comparison. A single number often isn’t enough to judge how good the performance is — fast is not the only thing that matters.

I have absolutely no doubts that a single node of Schooner’s product can run like a deer. It isn’t doing any cross-node …

[...] MySQL: An Introduction for Oracle DBAs « Patrick Hurley. Share this:TwitterFacebookMe gusta:Me gustaSé el primero en decir que te gusta esta post. [...]

http://collaborate12.ioug.org   Double Down at COLLABORATE 12- The IOUG Forum with Two Ways to Save- and a Chance to Win! The user-driven Oracle event of the year is fast-approaching, and IOUG wants you to make youreducational experience a sure bet. Between … Continue reading →

Thanks to everyone who has already taken part in our survey exploring changing attitudes to MySQL following its acquisition by Oracle and examining the competitive dynamic between MySQL and other database technologies, including NoSQL and NewSQL.

The response has been great and even a quick look at the results makes for interesting reading, particularly in the light of our previous findings which indicated declining MySQL usage.

I am really looking forward to having the opportunity for a deep dive into the results and break out the figures to get a better understanding of the potential impact of alternative MySQL distribution and support providers, as well as NoSQL and NewSQL, on continued usage of MySQL.

The survey results will be …

If you’ve tried compiling MySQL/MariaDB/XtraDB from source code on Windows, you may have run into the following error:

C:\GnuWin32\bin\bison.exe: m4: Invalid argument

Now, it is a known bug to receive this error if you install it to a location with spaces in the path. So don’t do that!

But, there are cases when you have not installed it to a path with spaces, and you still receive this error.

I’ve encountered it a number of times, and I’m not the only one (btw, thanks Venu for your existing work-around up to this point!).

…

Problem:

Compile MySQL/MariaDB/XtraDB on Windows and receive the following error …

I’ll be speaking on April 11th at 4:30 pm in Room 4 in at the Percona Conference and Expo Talk. The topic will be “Creating a Benchmark Infrastructure That Just Works.”

Throughout my career I’ve been involved with maintaining the performance of database applications and therefore created many benchmark frameworks. At Tokutek, an important part of my role is measuring the performance of our storage engine over time and versus competing solutions. There is nothing proprietary about what I’ve created, it can be used anywhere.

My presentation will cover how I created the benchmark infrastructure at Tokutek:

• Hardware and software …

Let me tell you a very touching story about these awards.
As I said in the comments : Sometimes we think about something and the next minute we did it…
And it exactly what happened, I took my inspiration from the TUAW Best Of 2011 (Yes, I’m also an Apple fan boy, sorry :-)), and a few minutes later, MySQL[plus] awards 2011 were live !

I thought I could have 50 voters, perhaps 100 voters, in my wildest dreams…

But more than 300 voters and more than 4000 views later, the reality is there : You are amazing !

But, no, it wasn’t perfect !

Shlomi said “You’ve got yourself into a bottomless pit!”, and it’s …

Percona recently evaluated the performance of Clustrix appliances by running tpcc-mysql benchmark at a scale factor of 5000 warehouse. Based on Percona’s blog, each Clustrix appliance node comprises of the following:

• 2x Intel 4-core processors (Xeon)
• 48GB RAM (40GB allocated to InnoDB buffer pool)
• 7x Intel SSD G2 (160GB each), software RAID0

The following results are taken from the report for Clustrix (tpcc-mysql new-order transactions/ 10 seconds):

For convenience, the above results have been converted to TPM (transactions/minute):
…

Gearman is awesome. If you do not know what it is, its a queue and load balancing system for an arbitrary number of workers which enables distributed computing across many nodes. Some of the same guys who worked on mySQL source worked on Gearman.

Feel free to search my blog on other gearman uses.

The Problem:

We store a lot of stats, make a lot of changes and we want to see the result of the stats in realtime. Our stat system is pretty slick. For each tag increment the application increments a count and group said tag by minute, hour, month with a hash tag numeric representation of the text for compact writes. This means 1 tag write produces 4 SQL statements. We track over 239211 …

If you connect to Cisco WebVPN with port-forwarding and get the message “applet not initialized” although Java applets work in your browser, you may have to enable third-party cookies in your browser.