Command identified by MySQL instance manager _ MySQL

Once you have set a password file for the MySQL instance manager and IM is running, you can connect to the command identified by the MySQL instance manager. You can use the mysql client tool to connect to MySQL through the standard mysql API. The following is a list of commands that can be received by the MySQL instance manager.

? START INSTANCE

This command will try to start an instance:

Mysql> start instance mysqld4;
Query OK, 0 rows affected (0, 00 sec)
? STOP INSTANCE

Will try to stop an instance:

Mysql> stop instance mysqld4;
Query OK, 0 rows affected (0, 00 sec)
? SHOW INSTANCES

Show all loaded instance names:

Mysql> show instances;
+ --------------- + --------- +
| Instance_name | status |
+ --------------- + --------- +
| Mysqld3 | offline |
| Mysqld4 | online |
| Mysqld2 | offline |
+ --------------- + --------- +
3 rows in set (0, 04 sec)
? SHOW INSTANCE STATUS

Displays the status and version information of the selected instance:

Mysql> show instance status mysqld3;
+ --------------- + -------- + --------- +
| Instance_name | status | version |
+ --------------- + -------- + --------- +
| Mysqld3 | online | unknown |
+ --------------- + -------- + --------- +
1 row in set (0.00 sec)
? SHOW INSTANCE OPTIONS

Display the options used by the instance:

Mysql> show instance options mysqld3;
+ ------------- + ---------------------------------------------------- +
| Option_name | value |
+ ------------- + ---------------------------------------------------- +
| Instance_name | mysqld3 |
| Mysqld-path |/home/cps/mysql/trees/mysql-4.1/SQL/mysqld |
| Port | 1, 3309 |
| Socket |/tmp/mysql. sock3 |
| Pid-file | hostname. pid3 |
| Datadir |/home/cps/mysql_data/data_dir1/|
| Language |/home/cps/mysql/trees/mysql-4.1/SQL/share/english |
+ ------------- + ---------------------------------------------------- +
7 rows in set (0.01 sec)
? SHOW LOG FILES