| Bug #18528 | mysql instance manager doesn't report changes to instance | ||
|---|---|---|---|
| Submitted: | 27 Mar 2006 4:53 | Modified: | 31 May 2006 12:06 |
| Reporter: | Brian Aker | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Instance Manager | Severity: | S3 (Non-critical) |
| Version: | 5.1 | OS: | Linux (Linux, FC4 AMD64) |
| Assigned to: | Alexander Nozdrin | CPU Architecture: | Any |
[5 Apr 2006 12:25]
Valeriy Kravchuk
Thank you for a bug report. Verified just as described with 5.0.21-BK (ChangeSet@1.2135, 2006-04-04 15:40:42+05:00) on Linux. To repeat, configure IM, start it, connect to it and start instance mysqld, then: show instance options mysqld; SET mysqld.datadir=<new_value>; show instance options mysqld; flush instances; show instance options mysqld;
[23 May 2006 8:22]
Alexander Nozdrin
Pushed into 5.1-tree, currently tagged 5.1.12-beta.
[31 May 2006 12:06]
Paul DuBois
No changelog entry needed.
Description: Session information is not updated for instance even though set has been called. How to repeat: mysql> show instance options mysqld; +---------------+---------------------------------+ | option_name | value | +---------------+---------------------------------+ | instance_name | mysqld | | mysqld-path | /usr/local/mysql/libexec/mysqld | | basedir | /usr/local/mysql | | pid-file | mysqld-purgatory.pid | +---------------+---------------------------------+ 4 rows in set (0.00 sec) mysql> SET mysql.datadir=/usr/local/mysql/var -> ; ERROR 3000 (HY000): Bad instance name. Check that the instance with such a name exists mysql> SET mysqld.datadir=/usr/local/mysql/var; Query OK, 0 rows affected (0.00 sec) mysql> show instance options mysqld; +---------------+---------------------------------+ | option_name | value | +---------------+---------------------------------+ | instance_name | mysqld | | mysqld-path | /usr/local/mysql/libexec/mysqld | | basedir | /usr/local/mysql | | pid-file | mysqld-purgatory.pid | +---------------+---------------------------------+ 4 rows in set (0.00 sec) mysql> FLUSH INSTANCES; Query OK, 0 rows affected (0.01 sec) mysql> show instance options mysqld; +---------------+---------------------------------+ | option_name | value | +---------------+---------------------------------+ | instance_name | mysqld | | mysqld-path | /usr/local/mysql/libexec/mysqld | | basedir | /usr/local/mysql | | datadir | /usr/local/mysql/var | | pid-file | mysqld-purgatory.pid | +---------------+---------------------------------+ 5 rows in set (0.00 sec) Suggested fix: Even before a flush occurs, the show command should show the changes in the current session.