About one month ago, the MySQL team at Oracle released MySQL 8.0, with a large list of changes. One of the most interesting features in the new release is also one that does not show up much, also because the team has gone to great length to keep most of its implementation hidden: the data dictionary.

What makes the data dictionary so interesting, despite its scarce visibility, is the effect that it has on performance. Up to MySQL 5.7, searching the information_schema was an onerous operation, potentially crippling the system. In MySQL 8.0, the same operations are …

This Log Buffer Edition gathers a wide sample of blogs and then purifies the best ones from Oracle, SQL Server and MySQL.

Oracle:

• If you take a look at the “alter user” command in the old 9i documentation, you’ll see this: DEFAULT ROLE Clause.
• There’s been an interesting recent discussion on the OTN Database forum regarding “Index blank blocks after a large update that was rolled back.”
• 12c Parallel Execution New Features: 1 SLAVE distribution
• Index Tree Dumps in Oracle 12c …

Beware of bugs in the above code; I have only proved it correct, not tried it.
Donald Knuth

Bugs in software are a fact of life. MySQL, as part of Oracle, issues of Critical Patch Updates and Security Alerts notices. You may have seen Daniel van Eeden‘s blog on the January announcement.

Daniel’s summary:

For MySQL 5.6 you should upgrade to 5.6.15
For MySQL 5.5 you should upgrade to 5.5.35
For MySQL 5.1 you should upgrade to 5.1.73

But you probably missed the executive summary.

But how do YOU get this information when it become available? …

My slides for presentations on MySQL Backup and Recovery Essentials and Understanding and using MySQL in the Cloud from the Oracle Technology Network (OTN) event in Medellín‎ Colombia are now available.

Thank you to the Colombia Oracle Users Group for inviting me to the event.

MySQL is the world’s most popular open-source database, and powers websites and applications of numerous leading and fast-growing organizations.


On March 12, we’re hosting the first Virtual Developer Day: MySQL at 9am PST to give you a one-stop shop to learn all the essential MySQL skills and the latest features in MySQL 5.6 GA. With a combination of presentations and hands-on lab experience, you’ll have the opportunity to practice in your own environment and gain more in-depth knowledge to successfully design, develop, and manage your MySQL databases.


Featuring speakers coming from Oracle’s MySQL …

On July 4 I gave two presentations at the OTN Tour Day, and on July 5 I have three presentations at the MySQL Training Days. This was my 3rd visit to Colombia and it was great to see a receptive audience. Thanks to Robin for organizing the events in 2010, 2011 and 2012.

You can download all presentations from the provided links.

• MySQL Backup and Recovery Essentials
• MySQL Security Essentials
• MySQL Performance Analysis Essentials
• …

The following are short interviews from the Oracle Technology Network (OTN) event in Cali, Colombia. One with myself and another with Sheeri Cabral.

These Videos are sourced from OTN Tour Latin America 2012.

We organized our first OTN Developer Day: MySQL earlier this year in Santa Clara, CA, and the result far exceeded our expectation. Before we kicked off the seminar at 9am, the attendees had already taken every single seat in the beautiful auditorium in Oracle's Santa Clara campus, and there was still a line in front of the registration desk. We recruited MySQL experts from several teams to present, and had great questions and discussions along the way and at the end. I personally received many positive comments saying that the seminar …

Oracle Technology Network (OTN) Developer Day for MySQL will take place on May 3rd in Santa Clara, CA to help DBAs and Developers get started and get better with MySQL. In this free, one-day event, we will cover topics from database design, application development, to MySQL administration and management. You'll also learn the guidelines and best practices in performance tuning and scalability. 


Attend this event and gain the knowledge to:
    •    Develop your new applications cost-effectively using MySQL
    •    Improve performance of your existing MySQL databases
    •    Manage your MySQL environment more efficiently

Don't miss this exclusive opportunity to network with your peers, and hear the technical tips from the MySQL experts at Oracle. No matter you're a DBA or a Developer, come find out how …

Oracle Technology Network (OTN) Developer Day for MySQL will take place on May 3rd in Santa Clara, CA to help DBAs and Developers get started and get better with MySQL. In this free, one-day event, we will cover topics from database design, application development, to MySQL administration and management. You'll also learn the guidelines and best practices in performance tuning and scalability. 


Attend this event and gain the knowledge to:
    •    Develop your new applications cost-effectively using MySQL
    •    Improve performance of your existing MySQL databases
    •    Manage your MySQL environment more efficiently

Don't miss this exclusive opportunity to network with your peers, and hear the technical tips from the MySQL experts at Oracle. No matter you're a DBA or a Developer, come find out how …