MySQL Lists are EOL. Please join:

List:Internals« Previous MessageNext Message »
From:Sanja Byelkin Date:November 11 2005 7:57am
Subject:Re: System Tables
View as plain text  
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
Thread
System TablesFabricio Mota11 Nov
  • Re: System TablesPeter M. Groen11 Nov
  • Re: System TablesSanja Byelkin11 Nov
    • RES: System TablesFabricio Mota12 Nov
      • Re: RES: System TablesSanja Byelkin12 Nov
        • RES: RES: System TablesFabricio Mota12 Nov
          • RES: RES: System TablesFabricio Mota12 Nov
          • Re: RES: RES: System TablesSanja Byelkin12 Nov
          • Re: RES: RES: System TablesSGreen12 Nov
            • RES: RES: RES: System TablesFabricio Mota13 Nov
              • Re: RES: RES: RES: System TablesSGreen13 Nov
                • RES: RES: RES: RES: System TablesFabricio Mota13 Nov
                  • Re: RES: RES: RES: RES: System TablesSanja Byelkin13 Nov
                    • RES: RES: RES: RES: RES: System TablesFabricio Mota13 Nov