B-Tree Index As MySQL's default index type, a b-tree index is reasonably fast to insert new items into, and is fast at looking up individual items or even ranges.  The index is stored as a branching tree, so looking up any one item is not an expensive operation.  Each level of branching allows an order of magnitude more items.  It's not always the best solution, but in some cases it may be the

If you plan to use the MySQL Workbench Migration Wizard to migrate databases from PostgreSQL to MySQL you first need to configure an ODBC driver to connect to your PostgreSQL server.

In this post I’ll cover how to set up and configure psqlODBC, the official ODBC driver for PostgreSQL.

Installing the psqlODBC Driver

The procedure is different for every platform so make sure to follow the instructions that correspond to the OS where you have MySQL Workbench installed. The driver needs to be installed in that machine, as explained in the MySQL Workbench documentation.

Windows

If you are running MySQL Workbench on Windows download the MSI package for psqlODBC. Go to its download page ( …

2013 is near… and so is the next FOSDEM edition !

This year again, MySQL will be represented by its Community.
If you want to discuss with friends of MySQL it’s the place to be in
February !

Like every year, FOSDEM takes place the first week-end of February in
Brussels.

We will again have a room in the H building (100 seat). The MySQL &
Friends dev room will be open all day Sunday, February 3rd.

Call for Papers is open until December 21st here.

This year all submissions will be reviewed by a committee that will
create the schedule.
The committee is composed by :

* Andrew Hutchings (HP)
* Andrew Morgan (Oracle)
* Sergey Petrunia (MariaDB) …

For those who do not read opensqlcamp group — CfP for FOSDEM 2013 conference is open!

Original email from lefred:

“2013 is near… and so is the next FOSDEM edition !

This year again, MySQL will be represented by its Community.
If you want to discuss with friends of MySQL it’s the place to be in
February !

Like every year, FOSDEM takes place the first week-end of February in
Brussels.

We will again have a room in the H building (100 seat). The MySQL &
Friends dev room will be open all day Sunday, February 3rd.

Call for Papers is open until December 21st

https://docs.google.com/a/percona.com/spreadsheet/viewform?formkey=dHF5VXdwa2FGUHIzTGI3ZGE4MkpaS2c6MA#gid=0

This year all submissions will be reviewed by a committee that will
create the schedule.
The committee is composed by :

* Andrew Hutchings (HP)
* Andrew …

Money has proclaimed being a Database Administrataor as being the fifth best job in America. And they are telling the world exactly what we do, well as best they can in very few words.

What they do all day? It’s no understatement to say that corporate America is in the middle of an information explosion. Somebody has to keep track of it all. A database administrator (DBA) minds all the data in a company’s storehouse, keeps it safe and makes sure it’s easily accessible.

But what if you are not a DBA already?

How to get the job? A degree in computer science is recommended, followed by years of experience. Many employers require certification in the most widely used programs, including MySQL, Oracle and DB2. And since the technology is always changing, re-training is a constant.

So why would …

Three ways to rename a MySQL database 1. Table renaming For InnoDB, the following seems to work: create the new empty database, then rename each table in turn into the new database: RENAME TABLE old_db.TABLE TO new_db.TABLE; After the rename you have to adjust the permissions of the table! To generate a script to generate [...]

Last month Ubuntu 12.10 was released and we tried to install MySQL Workbench on it. So we went to http://www.mysql.com/downloads/workbench/ and downloaded the .deb file for the most recent Workbench version (5.2.44 as of this writing). We then opened the .deb file with the Ubuntu Software Center application and tried to install it. Unfortunately the following message appeared:

Dependency is not satisfiable: libctemplate0

The problem here is that the libctemplate package provided by Ubuntu 12.10 corresponds to a higher version (libctemplate2). Installing this version instead wouldn’t work since MySQL Workbench is linked against the older one. We’ll handle this dependency issue in future releases, but here’s a workaround:

Download the …

This week, we continue our series going through the Operations Report Card as it applies to database administrators. This week in Ear Candy, we talk about a hidden client value for max_allowed_packet (separate from the session variable). In At the Movies, we present Karen Tegan Padir of Enterprise DB presenting The More Things Change, the More They Stay the Same.

Events
Oracle's "Scale with MySQL" seminars:
Madrid, Tuesday 27 November

read more

Tweet

MySQL is the world’s most popular open-source database, and powers websites and applications of numerous leading and fast-growing organizations. In this streamed video from a MySQL community event in Barcelona, we cover everything you need to know to successfully scale out and replicate your MySQL databases and make your applications highly available.  

Video streaming by Ustream