Hi, I tried SHOW VARIABLES LIKE '%innodb%'; but I couldn't find any variables that show information about auto extend property. Please clarify...
For my second question, I need only the table_name and table_type information, and avoid the rest, for an instance. I tried the tables_priv table in mysql database, but of no use. Any idea where MYSQL stores the status information inside the database? Thankx in advance, SB -----Original Message----- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 2:24 PM To: [EMAIL PROTECTED] Subject: Re: AUTOEXTEND Subhakar, ----- Original Message ----- From: ""Subhakar Burri"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, July 07, 2003 11:52 PM Subject: AUTOEXTEND > Sorry to post the same question again .. last time when I sent I = > received a couple of mails with some error messages .. so, not sure if = > my question was posted ... > Here we go again .. > > Hi,=20 > > I have a couple of questions, and really appreciate your help ... > > How can I find out if a data file is set to auto-extend without looking = > in my.cnf file? i.e... is there any variable that stores this = > information inside a database that I can query? please try SHOW VARIABLES LIKE '%innodb%'; > I need the table_name & table_type of all the tables in a instance (to = > run check table). Is there a way I can get that info from a single = > query? If not, what's the best way to get that info? Try SHOW TABLE STATUS FROM yourdatabasename; > Thankx in advance, > SB Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
