List:Cluster« Previous MessageNext Message »
From:Jon Stephens Date:October 26 2009 10:35am
Subject:Re: why i can not see ndb_schema use "show tables"?
View as plain text  
ch huang wrote:
> i find there are three table in mysql DB ,but i am very stange why i just
> can see ndb_apply_status and ndb_binlog_index use comnand "show tables"??
> 

As stated at 
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-schema.html

"The ndb_schema table is used to track schema changes made to NDB 
tables. It is defined as ...

... [T]he ndb_schema table is not visible either to MySQL SHOW 
statements, or in any INFORMATION_SCHEMA tables; however, it can be seen 
in the output of ndb_show_tables...

It is also possible to SELECT from this table in mysql and other MySQL 
client applications..."

Note also that 
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-schema.html 
is the first page listed in the results when you search the 5.1 Manual 
for 'ndb_schema'.

cheers

jon.

-- 


Jon Stephens - jon.stephens@stripped
Technical Writer
MySQL Documentation Team
Sun Microsystems AB
MySQL and Software Infrastructure Group
Liljeholmen (Stockholm), Sweden
Summer: UTC +02.00 / Winter: UTC +01.00
Mobile: +46 (0) 736 773 993
Skype: plastic-fish
MySQL: www.mysql.com
Sun: www.sun.com

Thread
why i can not see ndb_schema use "show tables"?ch huang26 Oct
  • Re: why i can not see ndb_schema use "show tables"?Jon Stephens26 Oct