We are pleased to announce that MySQL Enterprise Monitor 2.3.7 is now available for download on the My Oracle Support (MOS) web site as our latest GA release. It will also be available via Oracle E-Delivery in approximately 1 week. This is a maintenance release that fixes a number of bugs and includes the following new features:

• MySQL Enterprise Monitor Plugins for PHP that allow your PHP applications to provide data to the Query Analyzer so you can monitor and analyze the SQL statements executed by those applications
• Support for PAM authentication in MySQL Server 5.5.16
• New graphs and rules for the Thread Pool plugin

You can find more information on the contents of this release in …

We are pleased to announce that MySQL Enterprise Monitor 2.3.7 is now available for download on the My Oracle Support (MOS) web site as our latest GA release. It will also be available via Oracle E-Delivery in approximately 1 week. This is a maintenance release that fixes a number of bugs and includes the following new features:

• MySQL Enterprise Monitor Plugins for PHP that allow your PHP applications to provide data to the Query Analyzer so you can monitor and analyze the SQL statements executed by those applications
• Support for PAM authentication in MySQL Server 5.5.16
• New graphs and rules for the Thread Pool plugin

You can find more information on the contents of this release in …

MySQL Enterprise Monitor Advisors version 2.3.7.2104 is now available.

MySQL Enterprise Monitor Advisors version 2.3.7.2104 is now available.

Did you know that the following query actually performs a JOIN? You can’t see it, but it’s there:

SELECT the_day, COUNT(*), SUM(clicks), SUM(cost)
FROM ad_clicks_by_day
WHERE the_day >= …

Databases are the center of today’s web, enterprise and embedded applications, storing and protecting an organization’s most valuable assets and supporting business-critical applications. Just minutes of downtime can result in significant lost revenue and dissatisfied customers. Ensuring database highly availability is therefore a top priority for any organization.

The new MySQL Guide to High Availability solutions is designed to navigate users through the HA maze, discussing:

- The causes, effects and impacts of downtime;

- Methodologies to select the right HA solution;

- Different approaches to delivering highly available MySQL services;

- Operational best practices to meet Service Level Agreements (SLAs).

As discussed in the new Guide, selecting the high availability solution …

“I want to ensure that the MySQL code base (under the name of MariaDB) will survive as open source, in spite of what Oracle may do.” -- Michael “Monty” Widenius. Michael “Monty” Widenius is the main author of the original version of the open-source MySQL database and a founding member of the MySQL AB company. [...]

Databases are the center of today’s web, enterprise and embedded applications, storing and protecting an organization’s most valuable assets and supporting business-critical applications. Just minutes of downtime can result in significant lost revenue and dissatisfied customers. Ensuring database highly availability is therefore a top priority for any organization.

The new MySQL Guide to High Availability solutions is designed to navigate users through the HA maze, discussing:

- The causes, effects and impacts of downtime;

- Methodologies to select the right HA solution;

- Different approaches to delivering highly available MySQL services;

- Operational best practices to meet Service Level Agreements (SLAs).

As discussed in the new Guide, selecting the high availability solution …

Note: this article was originally published on http://blogs.innodb.com on Sept 28, 2011 by Calvin Sun.

Sunny and I will be presenting at the Oracle OpenWorld next week:

• Introduction to InnoDB, MySQL’s Default Storage Engine,  10/04/11 Tuesday 01:15 PM,   Marriott Marquis – Golden Gate C3,     Calvin Sun
• InnoDB Performance Tuning,  10/04/11 Tuesday  03:30 PM,   Marriott Marquis – Golden Gate C2,   Sunny Bains

The first session is for beginners, who are new to InnoDB and MySQL. The second session will cover many new performance features in MySQL 5.5 and 5.6, and share some tuning tips to maximize MySQL performance.

What to learn more about MySQL? There will be something for …

I wrote about Intel 320 SSD write performance before, but I was not satisfied with these results.

Somewhat each time on Intel 320 SSD I was getting different write performance, so it made me looking into this with details.

So let’s run experiment as in previous post, this is sysbench fileio random write on different file size, from 10GiB to 140GiB with 10GiB step. I use ext4 filesystem, and I perform filesystem format before increasing filesize.

The results are pretty much as in previous post, the throughput drops as we increase filesize:

However, there is when interesting stuff begin. Now when we run the same iterations again, the result will look like:

…