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:Heikki.Tuuri@stripped]
> Sent: Monday, July 07, 2003 2:24 PM
> To: mysql@stripped
> Subject: Re: AUTOEXTEND
>
>
> Subhakar,
>
> ----- Original Message -----
> From: ""Subhakar Burri"" <sburri@stripped>
> 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/mysql?unsub=1
--
---
Valentin Nils
Internet Technology
E-Mail: nils@stripped
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
