Bug #7744 Server does not recognize parameters set in my.ini
| Submitted: | 8 Jan 2005 14:18 | Modified: | 8 Jan 2005 19:57 |
|---|---|---|---|
| Reporter: | [ name withheld ] (Basic Quality Contributor) | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
| Version: | 4.1.8-nt-max | OS: | Windows (Windows 2000 server) |
| Assigned to: | Heikki Tuuri | CPU Architecture: | Any |
[8 Jan 2005 14:18]
[ name withheld ]
[8 Jan 2005 19:57]
MySQL Verification Team
I wasn't able to repeat please see below: C:\mysql\bin>type d:\windows\my.ini [mysqld] basedir= c:/mysql datadir= c:/mysql/data port = 3306 innodb_data_home_dir = c:/mysql/data innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = c:/mysql/data innodb_log_arch_dir = c:/mysql/data innodb_additional_mem_pool_size = 8M innodb_buffer_pool_size = 16M C:\mysql\bin>mysqld-max-nt --install Service successfully installed. C:\mysql\bin>net start mysql O serviço de MySQL está sendo iniciado. O serviço de MySQL foi iniciado com êxito. C:\mysql\bin>mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.8-nt-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show variables like 'innodb%pool_size'; +---------------------------------+----------+ | Variable_name | Value | +---------------------------------+----------+ | innodb_additional_mem_pool_size | 8388608 | | innodb_buffer_pool_size | 16777216 | +---------------------------------+----------+ 2 rows in set (0.00 sec) mysql> exit Bye C:\mysql\bin>net stop mysql O serviço de MySQL está sendo finalizado .. O serviço de MySQL foi finalizado com êxito. C:\mysql\bin>type d:\windows\my.ini [mysqld] basedir= c:/mysql datadir= c:/mysql/data port = 3306 innodb_data_home_dir = c:/mysql/data innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = c:/mysql/data innodb_log_arch_dir = c:/mysql/data innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 32M C:\mysql\bin>net start mysql O serviço de MySQL está sendo iniciado. O serviço de MySQL foi iniciado com êxito. C:\mysql\bin>mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.8-nt-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show variables like 'innodb%pool_size'; +---------------------------------+----------+ | Variable_name | Value | +---------------------------------+----------+ | innodb_additional_mem_pool_size | 16777216 | | innodb_buffer_pool_size | 33554432 | +---------------------------------+----------+ 2 rows in set (0.00 sec) mysql>
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.