MySQL 5.0.67

As announced a month ago, today our main server was upgraded from MySQL 4.1.X to v. 5.0.67-community. I have visited several of our database driven websites and all seem to be working fine.

Should you visit phpMyAdmin you'll find a new database: information_schema (17). This is a virtual database that MySQL 5 uses to describe your databases. It can be safely ignored.

From the MySQL 5.x documentation:

Chapter 19. INFORMATION_SCHEMA Tables

INFORMATION_SCHEMA provides access to database metadata.

Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes are used for this information are data dictionary and system catalog.

INFORMATION_SCHEMA is the information database, the place that stores information about all the other databases that the MySQL server maintains. Inside INFORMATION_SCHEMA there are several read-only tables. They are actually views, not base tables, so there are no files associated with them.

In effect, we have a database named INFORMATION_SCHEMA, although the server does not create a database directory with that name. It is possible to select INFORMATION_SCHEMA as the default database with a USE statement, but it is possible only to read the contents of tables. You cannot insert into them, update them, or delete from them.

Chapter 19. INFORMATION_SCHEMA Tables

captainccs

February 21, 2009