I use it in Oracle and notice there are 10 days missed, but i didn't see it in MySQL.

Author's announcement that the MySQL Bible, for beginner and intermediate MySQL DBA's, is available. The book is suitable for those completely new to databases, or those that are familiar with another RDBMS (such as Oracle or Microsoft SQL Server) and want to learn how MySQL works.

It's been a while since the MySQL Management Plug-in 0.42 was released. Since then, I quietly updated it to version 1.0. The changes were very few; the biggest news was that the plug-in was certified by Oracle and added to OTN Oracle 10g Grid Control Extensions Exchange (see at the bottom).I think the ne

About six months ago, the question of storing images in a database came up. This is one of my favorite topics, and has many database-agnostic parts.Personally, I think "tell me about storing images in a database" is actually a great interview question, because you will be able to see the difference between someone who has just memorized "what's right" versus someone who is really thinking. It also helps you see how someone will communicate -- if they just say "NEVER do it, it's as bad as crossing the streams!" then they are a type of person that gives you a short answer, without much explanation, and without many nuances. (That may be what you are looking for, but usually you want someone who gives reasons for why they strongly feel one way or another).Consider the following cases:

Hello everyone,Reading PlanetMySQL today, I discovered that Alex Gorbachev's announcement that he has released the first public beta of his Oracle Grid Control plugin for MySQL was not aggregated! This is probably because Alex is primarily working on our Oracle space and so his feed isn't on planet.This p

Recently, I had an opportunity to participate in a stress-testing exercise. By stress-testing, I mean simulating an expected peak load on the database and observing how the database performs. The objective is to make sure the particular hardware can handle the expected load and also to test where the physical limit of the machine lies if we keep increasing the number of concurrent users. I searched for tools available out there. On forums, most people were talking about Hammerora, and although some people recommended high end tools for big bucks, I decided to try this free tool that promised to do exactly what I needed it to do. The open source Hammerora turned out to be excellent tool for the purpose of simulating a typical transactions load in any number of threads. It's built with the Tcl scripting language and it can simulate a real workload with as many client user sessions as your system can handle.So if you're looking for  []

Last week, I was at the NetApp office in North Sydney for the presentation on

Pythian DBA's have daily reports for each monitored database and some of the components are using charts to visualize the data. I'm a big fan of charts myself (when applied appropriately) and want to show how you can generate simple charts directly from the database. You'd be very surprised how easy it can be done from *any* database without installing any additional software or configuring something special.This method is not limited to Oracle by any means -- use it with MySQL, SQL Server or any other database as well as without a database -- yes, visualize your sar data now!In this example, we will plot a pie diagram with Oracle tablespaces. This would be very handy when you are starting to analyze the space allocation for a database. Here is the end result of the report for my Grid Control repository test database:

The Oracle gateway for ODBC provides an almost seamless data integration between Oracle and other RDBMS. I won't argue about its performance, limits, or relevance. It serves a few purposes; set it up and you'll be able, for example, to create database links between Oracle and MySQL. After all, wouldn't it be nice if you could run some of the following SQL statements? "select o.col1, m.col1 from oracle_tabo, mysql_tab@mysql m where o.col1=m.col1;" "insert into oracle_tab (select * from mysql_tab@mysql);"This post is intended to share, the same way Karun did it for SQL Server last year, some tips related to the setup of the Oracle Gateway for ODBC with MySQL Connector ODBC on Linux.PrerequisitesI've installed all the configuration on my laptop to test it. It's running Ubuntu Intrepid Ibex 32bits, but I won't dig into the challenge of installing the MySQL Connector ODBC 5.1 on it. All I'll tell you is that, if  []

Continuent CTO Robert Hodges talks about future of database clustering and how Tungsten open source project fits in that picture