WARNING! Certain amount of irony to follow!Do not read while driving or operating heavy machinery

Just so you know, those at and those not at the MySQL User Conference, no, MySQL / Sun / Oracle hasn't been acquired. It feels real strange to have been not-acquired for such a long time, about a year now, but I guess I have to learn to live with it. And the User Conference isn't over yet, so who knows what will happen. I mean, not MySQL has taken control of Oracle, Sun, InnoDB, TimesTen and many other application, but we still have a few more companies to get control over.

/Karlsson
Part of the MySQL team conquering the world

Chief Corporate Architect at Oracle, been at Oracle since 1986, technology and architecture decisions, responsible for all open source at Oracle. Company-wide initiatives on standards management and security — http://en.oreilly.com/mysql2010/public/schedule/detail/12440.

Where MySQL fits within Oracle’s structure.

Oracle’s Strategy: Complete. Open. Integrated. (compare with MySQL’s strategy: Fast, Reliable, Easy to Use).

Most of the $$ spent by companies is not on software, but on integration. So Oracle makes software based on open standards that integrates well.

Most of the components talk to each other through open standards, so that customers can use other products, and standardize on the technology, which makes it much more likely that customers will continue to use Oracle.

Oracle invested …

Some of you might have seen my post on the MySQL Audit API that is included with MySQL 5.5 m3 and some of you might not have. Well, the code that is part of that is real simple, it's more to show a concept than something you would want to run in your production servers. But it was an attempt to check if there was any interest in something like this. And there was.

So I will develop this further into something much more useful. I have had several comments and suggestions already, and keep those coming, and I am listening. What I will implement for sure in an upcoming first release is four things:

• More configurability and status.
• Means of turning the plugin on and off.
• More data provided through the INFORMATION_SCHEMA table.
• Some means of limiting and controlling …

Not My Sequel.

• Share this on Facebook
• Tweet This!
• Share this on del.icio.us
• …

The MySQL 5.5.4-m3 beta version contains a number of
interesting new scalability features.

It contains the following InnoDB improvements:
Multiple Buffer Pool instances
- For example if the buffer pool is 8 GByte in size
the buffer pool can be split into 4 buffer pools
each containing 2 GBytes. Each page is mapped into
one and only one of these buffer pools.
Split Log_sys mutex
- We have ensured that the Log mutex and the buffer
pool mutex is more independent of each other. Also
the log_sys mutex is through this split less
contended.
Split out flush list from buffer pool mutex
Split Rollback Segment mutex into 128 instances
Separate Purge Thread from Master Thread
- Splitting out the purge thread from the master thread
is very important to ensure that performance is stable.
Extended Change buffering, now also Deletes and purges …

Today we have something to celebrate - the MySQL 5.5.4 was announced! And a huge number of performance improvement made in this version make me very happy :-))

I've got an immense pleasure to participate in this story and seek for the most optimal solutions together with all these talented engineers from MySQL/Sun/InnoDB/Oracle teams (and in few months all Oracle :-)) - and I think it was a huge step ahead to see how well we may all work together :-))

And now I'm happy to share with you my results obtained with MySQL 5.5.4 on dbSTRESS benchmark. All tests were executed on the 32cores Intel server running Fedora 10 and having 128GB RAM and absolutely fast internal SSD drives (and if from the memory I've used only 16GB for the buffer pools, the SSD drives helped a lot to reduce any dependency on the I/O activity).

Test scenario :

• Workload(s): Read-Only, Read-Write
• Sessions: 1, 2, 4, 8, 16, 32, 64, …

I am not sure when this will actually get posted online since I currently have no internet in my room. My one gripe (perhaps other than the chairs) about the conference is that the hotel does not offer free Internet and it is just expensive enough to cause me to use some discretion.

Be that as it may, day 1 was fun. Admittedly, some of the talk by Percona were things I already knew, though I did learn a few nice things (mostly about how to approach problems the right way since I do tend to jump into problems perhaps a bit prematurely at times). Some of the concepts Baron pointed out, while simply, are things I do not always think of when approaching a problem. I am almost excited to start putting such ideas to good use, in fact.

Likewise, the Drizzle talk, while quite interesting, went above my head. That is not saying much though since I have not touched C++ in a long time and have not really looked at the internals …

Since the Sun acquisition and the following announcement of the Oracle acquisition, the owner of MySQL have been fairly silent in terms of stated directions of MySQL.   This has allowed a lot of FUD to be spread throughout the user community.  At the MySQL users conference there are going to be some excellent keynotes helping customers get an update on MySQL technology.  It will be very

HTML 5 video is coming, but which codec is going to be used to deliver it?

Internet Explorer, Safari and Chrome have chosen on H.264, while Firefox and Opera are going for Ogg Theora. For us developers this sucks, because there is no one codec we can bet on to work in any browser. There's flash, which is more ubiquitous than any single browser, but it's a whole new toolchain to learn, and in my opinion it's a declining technology which will one day join the ranks of shockwave and <applet>. The future is in HTML, so what to do? Unfortunately there's no easy answer, so the most I can do is give an overview of what is going on today.

Choose multiple

First and foremost, keep in mind that the standard for the <video> tag allows multiple codes. You can easily specify a video tag with both an ogg vorbis and an H.264 source. This works as follows:

1. <video controls="true">
2. <source …

The newly released MySQL 5.5 beta version MySQL 5.5.4-m3
has a large number of significant performance improvements.
These improvements makes it possible for MySQL to scale
well even on 32-core servers. The graph below shows how
MySQL 5.5.4-m3 scales from 12 cores to 32 cores using a
single thread per core. The benchmark used here is
dbStress. dbStress uses a number of tables which spreads
the impact of mutexes and improves scalability.



The graph below shows a similar scalability analysis on a
smaller server where the benchmark used was Sysbench RW.
The red line shows the scalability of MySQL 5.1.45, the
green line shows scalability of MySQL 5.5.3-m3 and the
blue line shows MySQL 5.5.4-m3. So this graph shows that
even with …