information_schema Database

[progravix]

In OPS, I show two mySQL databases. When I click on "Administer" and bring up phpMyAdmin, it shows three databases in the left frame. The two that I recognize, and then a third called "information_schema" with 17 tables.

Does anybody know what this is?

[IanS]

It's been mentioned recently as being a control file that the system uses. I think the opinion was it should be left well alone. Contact support about it. The main thing is it is not a breach of security to have, Powweb placed it their and you're not supposed to see it.

[mixerson]

The information_schema database is part of MySQL.

From http://dev.mysql.com/doc/refman/5.0/en/information-schema.html:
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.

[HalfaBee]

And they are really slow to open/query sometimes, this is why phpmyadmin is soooooo slow.

[YvetteKuhns]

I contacted support on another issue and mentioned the information schema database that appears in MySQL5. Support said not to worry about it. I never did. I only asked when others started spreading rumors that it was not supposed to be visible.