I finally got around to cleaning up old contact me messages. One of the messages raises a question about RESULT_CACHE functions. The writer wanted an example implementing both a standalone schema and package RESULT_CACHE function.

The question references a note from the Oracle Database 11g PL/SQL Programming book (on page 322). More or less, that note points out that at the time of writing a RESULT_CACHE function worked as a standalone function but failed inside a package. When you tried it, you raised the following error message:

PLS-00999: Implementation Restriction (may be temporary)

It’s no longer true in Oracle 11gR2, but it was true in Oracle 11gR1. I actually mentioned in a …

Today we will talk how do you can easily rename a database in MySQL.
At the MySQL version 5.1.7 was added a command to do this job named RENAME DATABASE

RENAME {DATABASE | SCHEMA} db_name TO new_db_name;

But it was removed on the MySQL version 5.1.23 because maybe it would result in data lost’s like you can see on this link of MySQL documentation

Then, lets see some ways which we can do this:

1. Using the RENAME TABLE command

As long as two databases are on the same file system, you can use RENAME TABLE to move a table from one database to another:

RENAME TABLE current_db.tbl_name TO other_db.tbl_name;

RENAME TABLE Syntax na Documentacao do MySQL

The MySQL Connect call for papers will be closing soon. We have received some very good submissions but yours needs to be included! . No need to panic but May 6th is the cut off date and that is just a few days away. So tell us how you solved problems with MySQL, your approach to scaling, how you teach with MySQL, or something you would like to share.

…

Virtualization is important and Dave Welch from the House of Brick gave a great presentation of experiences with VMWare and Tier 1 databases. It was a comprehensive presentation, but the white paper was easier to follow. The slides were complete but the volume of information was a lot for an hour presentation. Well worth the time though.

Utah Oracle User Group (UTOUG) announced a call for Fall Symposium papers today. The Fall Symposium will be in Salt Lake City on 9/6/2012. If you’re interested in presenting on Oracle or MySQL, the call for presentations will be open until 6/15/2012.

The conference party was tonight, and it provided some nice orderves and pizza. The theme was a return to 1980s music, and …

I will be at the Indiana Linux Fest this weekend, presenting the Care and Feeding of a MySQL Database for Linux Administrators on Saturday just before lunch. Later this month I will be in Las Vegas for Collaborate 12 to present MySQL for Oracle DBAs or How to Speak MySQL for beginners on April 25th at 12:15. And later this summer I will presenting a Moodle=dentric look at MySQL administration on August 1st at 1:15 at the West Coast Moodle Moot.

…

MariaDB 5.3 is now GA, and MariaDB 5.5 is RC. One of the primary features in these releases is all-round coverage with subquery optimizations. Practically every kind of subquery available in SQL has got some new optimization.

We do a lot of testing, so these new optimizations should be now reasonably stable. What is missing is performance testing with real-world queries on real-world data. I expect most of the time you will see a speedup, however, there can also be cases where the new version will be slower. New optimizations make query plan search space much bigger, this means the new optimizer will have lots of room to make errors where previously was none.

Back at MySQL Ab, I could use bugs/support …

A number of people have already mentioned this, but the Percona Live MySQL Conference and Expo is just around the corner.
As Stewart has already blogged, there are a number of great sessions this year and I’m looking forward to several of them.

I’ll be giving a talk there as well –
It’s essentially all in the abstract, but I’ll be speaking about various functional testing tools that exist for MySQL-based systems.
Come to learn more about the …

At #POSSCON and looking for MySQL SWAG? Find me in Lexington A at 10AM where I am presenting MySQL 5.6 and 20 MySQL Tips in 20 Minutes.

Come and get 'em -- MySQL thumb drives, stickers, and now buttons!

…

POSSCON, The Palmetto Open Source Software Conference, is being held next week on the 27th and 28th in Columbia, South Carolina. I was asked to combine two presentations so be prepared for MySQL Update & 20 MySQL Tips in 20 Minutes. This is a great conference in a thriving community. The local government, tech sector, and schools are working together to make a strong partnership to develop more high tech businesses in the area.

…

We here at www.perconas.com are thrilled about the upcoming Percona Live Conference. We are excited and are gearing up for our first multi-day conference. It is sure to be three days of technical sessions and networking among the MySQL Community and we are proud to be a part of the conference.

We can’t wait to see you there!