Subhakar, it is a bug which was fixed in 3.23.57:
http://www.mysql.com/doc/en/News-3.23.57.html " D.4.2 Changes in release 3.23.57 (06 Jun 2003) ... SHOW VARIABLES LIKE 'innodb_data_file_path' displayed only the name of the first datafile (bug #468). ... " Regards, Heikki ................................................ Subject: RE: AUTOEXTEND From: Subhakar Burri Date: Tue, 8 Jul 2003 10:10:26 -0700 Hi, sorry to keep this thread going ... I'm sending you the output of my results ... I don't see the autoextend string in my output. I'm using 3.23.56 I have the following entry in my .cnf file: innodb data file path=innodb data01:5M;innodb data02:5M:autoextend:max:10M And the output of my variables is as follows: | have innodb | YES | innodb additional mem pool size | 5242880 | innodb buffer pool size | 5242880 | innodb data file path | innodb data01 | innodb data home dir | /usr/local/mysql/data innodb | 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 | /usr/local/mysql/data innodb/log | innodb log archive | ON | innodb log buffer size | 262144 | innodb log file size | 1048576 | innodb log files in group | 3 | innodb log group home dir | /usr/local/mysql/data innodb/log | innodb mirrored log groups | 1 I noticed Nils version is 4.1 alpha, Is this unavailable in 3.23.56? Moreover, why doesn't the second file (innodb data02)show up? Please advise. Thankx in advance, SB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
