How about this ?? (MySQL 4.1-alpha) +---------------------------------+------------------------+ | Variable_name | Value | +---------------------------------+------------------------+ | have_innodb | YES | | innodb_additional_mem_pool_size | 31457280 | | innodb_buffer_pool_size | 251658240 | | innodb_buffer_pool_awe_mem_mb | 0 | | innodb_data_file_path | ibdata1:10M:autoextend | | innodb_data_home_dir | | | innodb_file_io_threads | 4 | | innodb_force_recovery | 0 | | innodb_thread_concurrency | 8 | | innodb_flush_log_at_trx_commit | 1 | | innodb_fast_shutdown | ON | | innodb_flush_method | | | innodb_lock_wait_timeout | 50 | | innodb_log_arch_dir | ./ | | innodb_log_archive | OFF | | innodb_log_buffer_size | 1048576 | | innodb_log_file_size | 5242880 | | innodb_log_files_in_group | 2 | | innodb_log_group_home_dir | ./ | | innodb_mirrored_log_groups | 1 | +---------------------------------+------------------------+
Best regards Nils Valentin Tokyo/Japan 2003年 7月 8日 火曜日 07:22、Subhakar Burri さんは書きました: > 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] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]