Re: System Tables

[Sanja Byelkin]

Hi!

On Thu, Nov 10, 2005 at 09:43:42PM -0300, Fabricio Mota wrote:
> Hi All,

[skip]

> I've searched where is the management of system tables in MySQL, but the
> only thing I've found was a test source code file that creates the system
> tables for tests. But no access management I've fould (such as data
> retrieval, insertion, updating or deletion for system management).
> Anybody can help me?

Mysql have not so much system tables, all they collected into mysql
database. there are tables of ACL system (see sql/sql_acl.*), table to
store "stored procedures" (see sql/sp_head.* sql/sp.*) and help
information.  All other information stored into so-called .frm file. one
file per table. there are two formats of that files old - for base
tables (see sql/sql_base.cc sql/unireg.cc sql/table.*) and new one
(just a text) for storing view information (sql/sql_view.cc
sql/table.*).

To show all this information mysql use SHOW command family and
INFORMATION SCHEMA, both can be found into sql/sql_show.*

Some engines have its own meta-information about tables, it is innodb
and ndb for example.

I hope I answered your question.

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Oleksandr Byelkin <sanja@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Lugansk, Ukraine
       <___/   www.mysql.com