做主从数据库时,Navicat 8中的控制台(Console)进行查看slave是运行状态,命令是:show slave status\G;
Navicat总是报语法错误!而在mysql的命令行控制台却能正常执行!~~~看来Navicat还有待进一步加强!
\G或\g是用来干嘛的?以下的代码就可以告诉你了!
1、show slave status; 同:show slave status\g;
+----------------------+-------------+-------------+-------------+-------------- -+------------------+---------------------+----------------------------------+-- -------------+-----------------------+------------------+-------------------+--- --------------+---------------------+--------------------+---------------------- --+-------------------------+-----------------------------+------------+-------- ----+--------------+---------------------+-----------------+-----------------+-- --------------+---------------+--------------------+--------------------+------- -------------+-----------------+-------------------+----------------+----------- ------------+ | Slave_IO_State | Master_Host | Master_User | Master_Port | Connect_Retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | R elay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Re plicate_Do_DB | Replicate_Ignore_DB | Replicate_Do_Table | Replicate_Ignore_Tabl e | Replicate_Wild_Do_Table | Replicate_Wild_Ignore_Table | Last_Errno | Last_Er ror | Skip_Counter | Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition | U ntil_Log_File | Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File | Master _SSL_CA_Path | Master_SSL_Cert | Master_SSL_Cipher | Master_SSL_Key | Seconds_Be hind_Master | +----------------------+-------------+-------------+-------------+-------------- -+------------------+---------------------+----------------------------------+-- -------------+-----------------------+------------------+-------------------+--- --------------+---------------------+--------------------+---------------------- --+-------------------------+-----------------------------+------------+-------- ----+--------------+---------------------+-----------------+-----------------+-- --------------+---------------+--------------------+--------------------+------- -------------+-----------------+-------------------+----------------+----------- ------------+ | Connecting to master | localhost | slaver | 3308 | 60 | mysql-bin.000301 | 461 | ccf-3acf6017ef4-relay-bin.000001 | 98 | mysql-bin.000301 | No | Yes | te st1 | | | | | | 0 | | 0 | 461 | 98 | None | | 0 | No | | | | | | | +----------------------+-------------+-------------+-------------+-------------- -+------------------+---------------------+----------------------------------+-- -------------+-----------------------+------------------+-------------------+--- --------------+---------------------+--------------------+---------------------- --+-------------------------+-----------------------------+------------+-------- ----+--------------+---------------------+-----------------+-----------------+-- --------------+---------------+--------------------+--------------------+------- -------------+-----------------+-------------------+----------------+----------- ------------+2、show slave status\G;
mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: Connecting to master Master_Host: localhost Master_User: slaver Master_Port: 3308 Connect_Retry: 60 Master_Log_File: mysql-bin.000301 Read_Master_Log_Pos: 461 Relay_Log_File: ccf-3acf6017ef4-relay-bin.000001 Relay_Log_Pos: 98 Relay_Master_Log_File: mysql-bin.000301 Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_Do_DB: test1 Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 461 Relay_Log_Space: 98 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL 1 row in set (0.00 sec) ERROR: No query specified
这就是区别了!!排版的更友好一些吧!!
以此类推,凡是用到 status 的,加上一个\G 可以使信息更容易看一些!
show slave status\G; 不要用分号!
正确 的应该是:show slave status\G