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.

Instead of the usual text-heavy blog posts that appear here, I thought it would be fun to mix things up and do a screencast showing exactly how easy it is to upgrade MySQL to MariaDB:

Some notes:

• The laptop I’m using had MySQL 5.1.55 installed with one database (apart from the system database). Installing MariaDB does not impact existing data in any way and once the install completed I had instant access to my data.
• As part of the install you are given the option to set a new password for the root user. I choose to do it in the video, but you don’t need to. If you leave the password field blank the root password will not be changed. Other database users are preserved, of course.
• As with any database upgrade, before doing this to a production system you should have backups and test.

Links:

Links shown or mentioned in the video:

• …

I will be in Austin for SITE presenting Teaching Database Concepts with Open Source Software on Wednesday, March 6th. So if you are a teacher attending SITE, please come attend my session. And bring your boots so we can hit 6th Street afterwards!

…