NOTE: this article I've started to write yet before summer vacations, but timing was against me, and I'm able to finish and publish it only now. While my investigations are continuing, you'll find here the explanations why Vadim observed unexpected performance improvements when using a single InnoDB BP instance rather 8, and some other things as well..

* * *
The InnoDB Buffer Pool (BP) Instances feature was introduced since MySQL 5.5.4 and presented for the first time during MySQL UC2010. This solution was the key point on its time, as without BP instances no one from other newly added great features was able to show any positive impact on performance (as otherwise all the stuff was still …

With its proven ease-of-use, performance, and scalability, MySQL has become the leading database choice for web-based applications, used by high profile web properties including Google, Yahoo!, Facebook, YouTube, Wikipedia and thousands of mid-sized companies.

Many organizations deploy both Oracle Database and MySQL side by side to serve different needs, and as a database professional you can find training courses on both topics at Oracle University! Check out the upcoming Oracle Database training courses and MySQL training courses. Even if you're only managing Oracle Databases at this point of time, getting familiar with MySQL Database will broaden your career path with growing job demand.

Hone your skills as a MySQL Database Administrator by taking the MySQL for Database Administrators course which teaches you how to secure privileges, set resource limitations, access …

HERMES Medical Solutions was established in 1976 in Stockholm, Sweden, and is a leading innovator in medical imaging hardware/software products for health care facilities worldwide. HERMES delivers a plethora of different medical imaging solutions to optimize hospital workflow.

HERMES advanced algorithms make it possible to detect the smallest changes under therapies important and necessary to optimize different therapeutic methods and doses.

Challenges

• Fighting illness & disease requires state-of-the-art imaging modalities and software in order to diagnose accurately, stage disease appropriately and select the best treatment available.
• Selecting and implementing a new database platform that would deliver the needed performance, reliability, security and flexibility required by the high-end medical solutions offered by HERMES.
…

This webinar will examine best practices around scaling MySQL databases. To register, click here. There are thousands of new online and mobile apps launching every day…but what happens when demand climbs for these apps and databases can’t keep up?  The long-term success of any app hangs on a company’s ability to provide uninterrupted access and availability – [...] Read More

Here is the MySQL-Performance Schema presentation which I used at OSI, 2012.

http://www.slideshare.net/mayankmysql/osimysqlperformance-schema

Here is the MySQL-Performance Schema presentation which I used at OSI, 2012.

http://www.slideshare.net/mayankmysql/osimysqlperformance-schema

Last week I had an enlightening experience. It may sound strange, but I found I have super powers... let me explain.

I had a meeting with a big customer of mine to show the value of MySQL Enterprise and Cluster CGE and to share with them the latest and greatest features available in our commercial offerings. During the discussion I said: "Imagine if your MySQL database has a problem at 3pm. Thanks to My Oracle Support and MySQL Enterprise Monitor you can quickly resolve your issues and restore the service".

Well, this is exactly what happened at 2.50pm... I missed the prophecy by just 10m and found I have super powers!

You could imagine how happy the …

Just a quick note that the Colorado MySQL User Group will be have Craig Sylvester in town November 7th 2012 for a MySQL Cluster talk. Please feel free to RSVP and join us!

First of all a big thank you to all of you who attended my two Hands-On Labs (HOL) session at this year’s MySQL Connect. I ended up doing two sessions as there was a last minute cancellation, so in addition to the previously announced session about the Performance Schema, I also did an introduction to MySQL.

The slides and the workbook for the Performance Schema session will become available from the official Oracle OpenWorld/MySQL Connect catalog, but you can also get the files from my blog which for the Performance Schema session will also include the helper functions and procedures used and some sample queries used to create load on the …

This is part one of a series where we will explore the Operations Report Card and explain how it applies to DBAs. Listen and grade your own organization, this is a great opportunity to get some new ideas on how to organize your department and make your job more efficient and streamlined.

News
Alaska Airlines system crash

Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30 October

read more