At 16:29 +0300 8/17/03, Dmitry Kosoy wrote:
Hi,

Is there any possibility to check existing of autoextend option
for InnoDB ?

I mean by any sql command and not by searching in my.ini file ?

If you mean you want to find out the setting of the innodb_data_file_path variable, you can use this statement:

mysql> show variables like 'innodb_data_file_path';
+-----------------------+-------------+
| Variable_name         | Value       |
+-----------------------+-------------+
| innodb_data_file_path | ibdata1:20M |
+-----------------------+-------------+


Regards, Dmitry


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified? http://www.mysql.com/certification/


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to