1.检查集群
show @@time.current ;
show @@time.startup ;
show @@version ;
show @@server ;
show @@threadpool;
show @@database ;
show @@datanode;
show @@datanode where schema = ?
show @@datasource ;
show @@datasource where dataNode = ?
show @@datasource.synstatus ;
show @@datasource.syndetail where name=?
show @@datasource.cluster ;
show @@processor ;
show @@command ;
show @@connection ;
show @@cache;
show @@backend ;
show @@session ;
show @@connection.sql ;
show @@sql.execute ;
show @@sql.detail where id = ?
show @@sql ;
show @@sql.high ;
show @@sql.slow ;
show @@sql.resultset ;
show @@sql.sum ;
show @@sql.sum.user ;
show @@sql.sum.table ;
show @@parser ;
show @@router ;
show @@heartbeat ;
show @@heartbeat.detail where name=?
show @@slow where schema = ?
show @@slow where datanode = ?
show @@sysparam ;
show @@syslog limit=?
show @@white ;
show @@white.set=?,?
show @@directmemory=1 or 2
2.结果展示
"sspu@192.168.1.11"> show @@time.current ;
+---------------+
| TIMESTAMP |
+---------------+
| 1724208107858 |
+---------------+
1 row in set (0.00 sec)
"sspu@192.168.1.11">show @@time.startup ;
+---------------+
| TIMESTAMP |
+---------------+
| 1724208024961 |
+---------------+
1 row in set (0.00 sec)
"sspu@192.168.1.11"> show @@version
-> ;
+---------------------------------------+
| VERSION |
+---------------------------------------+
| 5.6.29-mycat-1.6.5-DEV-20161231120132 |
+---------------------------------------+
1 row in set (0.00 sec)
"sspu@192.168.1.11"> show @@server ;
+-------------+-------------+--------------+------------+---------------+---------------+---------+--------+
| UPTIME | USED_MEMORY | TOTAL_MEMORY | MAX_MEMORY | RELOAD_TIME | ROLLBACK_TIME | CHARSET | STATUS |
+-------------+-------------+--------------+------------+---------------+---------------+---------+--------+
| 2m 7s 732ms | 44787752 | 123666432 | 1978597376 | 1724208024961 | -1 | gbk | ON |
+-------------+-------------+--------------+------------+---------------+---------------+---------+--------+
1 row in set (0.00 sec)
"sspu@192.168.1.11"> show @@threadpool;
+------------------+-----------+--------------+-----------------+----------------+------------+
| NAME | POOL_SIZE | ACTIVE_COUNT | TASK_QUEUE_SIZE | COMPLETED_TASK | TOTAL_TASK |
+------------------+-----------+--------------+-----------------+----------------+------------+
| Timer | 2 | 0 | 0 | 328 | 328 |
| BusinessExecutor | 4 | 0 | 0 | 22 | 22 |
+------------------+-----------+--------------+-----------------+----------------+------------+
"sspu@192.168.1.11"> show @@database ;
+----------+
| DATABASE |
+----------+
| mycatdb1 |
| mycatdb2 |
| mycatdb3 |
| mycatdb4 |
| mycatdb5 |
| mycatdb6 |
| mycatdb7 |
| mycatdb8 |
| mycatdb9 |
+----------+
9 rows in set (0.00 sec)
"sspu@192.168.1.11"> show @@datanode;
+------------+----------------+-------+-------+--------+------+------+---------+------------+----------+---------+---------------+
| NAME | DATHOST | INDEX | TYPE | ACTIVE | IDLE | SIZE | EXECUTE | TOTAL_TIME | MAX_TIME | MAX_SQL | RECOVERY_TIME |
+------------+----------------+-------+-------+--------+------+------+---------+------------+----------+---------+---------------+
| dnmycatdb1 | mysql1/sspudb1 | 0 | mysql | 0 | 3 | 1000 | 3 | 0 | 0 | 0 | -1 |
| dnmycatdb2 | mysql1/sspudb2 | 0 | mysql | 0 | 4 | 1000 | 21 | 0 | 0 | 0 | -1 |
| dnmycatdb3 | mysql1/sspudb3 | 0 | mysql | 0 | 3 | 1000 | 3 | 0 | 0 | 0 | -1 |
| dnmycatdb4 | mysql2/sspudb4 | 0 | mysql | 0 | 3 | 1000 | 22 | 0 | 0 | 0 | -1 |
| dnmycatdb5 | mysql2/sspudb5 | 0 | mysql | 0 | 2 | 1000 | 3 | 0 | 0 | 0 | -1 |
| dnmycatdb6 | mysql2/sspudb6 | 0 | mysql | 0 | 1 | 1000 | 3 | 0 | 0 | 0 | -1 |
| dnmycatdb7 | mysql3/sspudb7 | 0 | mysql | 0 | 1 | 1000 | 3 | 0 | 0 | 0 | -1 |
| dnmycatdb8 | mysql3/sspudb8 | 0 | mysql | 0 | 3 | 1000 | 22 | 0 | 0 | 0 | -1 |
| dnmycatdb9 | mysql3/sspudb9 | 0 | mysql | 0 | 2 | 1000 | 4 | 0 | 0 | 0 | -1 |
+------------+----------------+-------+-------+--------+------+------+---------+------------+----------+---------+---------------+
9 rows in set (0.01 sec)
"sspu@192.168.1.11"> show @@datasource ;
+------------+--------------+-------+--------------+------+------+--------+------+------+---------+-----------+------------+
| DATANODE | NAME | TYPE | HOST | PORT | W/R | ACTIVE | IDLE | SIZE | EXECUTE | READ_LOAD | WRITE_LOAD |
+------------+--------------+-------+--------------+------+------+--------+------+------+---------+-----------+------------+
| dnmycatdb4 | 192.168.1.12 | mysql | 192.168.1.12 | 3306 | W | 0 | 6 | 1000 | 38 | 0 | 0 |
| dnmycatdb5 | 192.168.1.12 | mysql | 192.168.1.12 | 3306 | W | 0 | 6 | 1000 | 38 | 0 | 0 |
| dnmycatdb2 | 192.168.1.11 | mysql | 192.168.1.11 | 3306 | W | 0 | 10 | 1000 | 37 | 0 | 0 |
| dnmycatdb3 | 192.168.1.11 | mysql | 192.168.1.11 | 3306 | W | 0 | 10 | 1000 | 37 | 0 | 0 |
| dnmycatdb1 | 192.168.1.11 | mysql | 192.168.1.11 | 3306 | W | 0 | 10 | 1000 | 37 | 0 | 0 |
| dnmycatdb8 | 192.168.1.13 | mysql | 192.168.1.13 | 3306 | W | 0 | 6 | 1000 | 39 | 0 | 0 |
| dnmycatdb9 | 192.168.1.13 | mysql | 192.168.1.13 | 3306 | W | 0 | 6 | 1000 | 39 | 0 | 0 |
| dnmycatdb6 | 192.168.1.12 | mysql | 192.168.1.12 | 3306 | W | 0 | 6 | 1000 | 38 | 0 | 0 |
| dnmycatdb7 | 192.168.1.13 | mysql | 192.168.1.13 | 3306 | W | 0 | 6 | 1000 | 39 | 0 | 0 |
+------------+--------------+-------+--------------+------+------+--------+------+------+---------+-----------+------------+
9 rows in set (0.00 sec)
"sspu@192.168.1.11">show @@datasource.synstatus ;
Empty set (0.01 sec)
"sspu@192.168.1.11"> show @@datasource.cluster ;
Empty set (0.00 sec)
"sspu@192.168.1.11"> show @@processor ;
+------------+--------+---------+-------------+---------+---------+--------------+--------------+------------+----------+----------+----------+
| NAME | NET_IN | NET_OUT | REACT_COUNT | R_QUEUE | W_QUEUE | FREE_BUFFER | TOTAL_BUFFER | BU_PERCENT | BU_WARNS | FC_COUNT | BC_COUNT |
+------------+--------+---------+-------------+---------+---------+--------------+--------------+------------+----------+----------+----------+
| Processor0 | 11294 | 15330 | 0 | 0 | 0 | 171798691840 | 171798691840 | 0 | 0 | 1 | 28 |
+------------+--------+---------+-------------+---------+---------+--------------+--------------+------------+----------+----------+----------+
1 row in set (0.00 sec)
"sspu@192.168.1.11"> show @@command ;
+------------+---------+-------+--------------+--------------+------------+------+------+------+-------+
| PROCESSOR | INIT_DB | QUERY | STMT_PREPARE | STMT_EXECUTE | STMT_CLOSE | PING | KILL | QUIT | OTHER |
+------------+---------+-------+--------------+--------------+------------+------+------+------+-------+
| Processor0 | 0 | 46 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
+------------+---------+-------+--------------+--------------+------------+------+------+------+-------+
1 row in set (0.01 sec)
"sspu@192.168.1.11"> show @@connection ;
+------------+------+--------------+------+------------+------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+
| PROCESSOR | ID | HOST | PORT | LOCAL_PORT | USER | SCHEMA | CHARSET | NET_IN | NET_OUT | ALIVE_TIME(S) | RECV_BUFFER | SEND_QUEUE | txlevel | autocommit |
+------------+------+--------------+------+------------+------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+
| Processor0 | 1 | 192.168.1.11 | 9066 | 42528 | sspu | NULL | gbk:28 | 1170 | 12403 | 332 | 4096 | 0 | | |
+------------+------+--------------+------+------------+------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+
1 row in set (0.00 sec)
"sspu@192.168.1.11"> show @@cache;
+-------------------------------------+-------+------+--------+------+------+-------------+----------+
| CACHE | MAX | CUR | ACCESS | HIT | PUT | LAST_ACCESS | LAST_PUT |
+-------------------------------------+-------+------+--------+------+------+-------------+----------+
| ER_SQL2PARENTID | 1000 | 0 | 0 | 0 | 0 | 0 | 0 |
| SQLRouteCache | 10000 | 0 | 0 | 0 | 0 | 0 | 0 |
| TableID2DataNodeCache.TESTDB_ORDERS | 50000 | 0 | 0 | 0 | 0 | 0 | 0 |
+-------------------------------------+-------+------+--------+------+------+-------------+----------+
3 rows in set (0.01 sec)
"sspu@192.168.1.11"> show @@backend ;
+------------+------+---------+--------------+------+--------+--------+---------+------+--------+----------+------------+---------+---------+---------+------------+
| processor | id | mysqlId | host | port | l_port | net_in | net_out | life | closed | borrowed | SEND_QUEUE | schema | charset | txlevel | autocommit |
+------------+------+---------+--------------+------+--------+--------+---------+------+--------+----------+------------+---------+---------+---------+------------+
| Processor0 | 1 | 11861 | 192.168.1.11 | 3306 | 59704 | 164 | 88 | 369 | false | false | 0 | sspudb3 | gbk:28 | 3 | true |
| Processor0 | 2 | 11862 | 192.168.1.11 | 3306 | 59706 | 164 | 88 | 369 | false | false | 0 | sspudb1 | gbk:28 | 3 | true |
| Processor0 | 3 | 11866 | 192.168.1.11 | 3306 | 59714 | 732 | 232 | 369 | false | false | 0 | sspudb2 | gbk:28 | 3 | true |
| Processor0 | 4 | 11863 | 192.168.1.11 | 3306 | 59708 | 732 | 232 | 369 | false | false | 0 | sspudb2 | gbk:28 | 3 | true |
| Processor0 | 5 | 11867 | 192.168.1.11 | 3306 | 59716 | 164 | 88 | 369 | false | false | 0 | sspudb3 | gbk:28 | 3 | true |
| Processor0 | 6 | 11865 | 192.168.1.11 | 3306 | 59712 | 164 | 88 | 369 | false | false | 0 | sspudb1 | gbk:28 | 3 | true |
| Processor0 | 7 | 11860 | 192.168.1.11 | 3306 | 59702 | 732 | 232 | 369 | false | false | 0 | sspudb2 | gbk:28 | 3 | true |
| Processor0 | 8 | 11864 | 192.168.1.11 | 3306 | 59710 | 164 | 88 | 369 | false | false | 0 | sspudb3 | gbk:28 | 3 | true |
| Processor0 | 9 | 11869 | 192.168.1.11 | 3306 | 59720 | 164 | 88 | 369 | false | false | 0 | sspudb1 | gbk:28 | 3 | true |
| Processor0 | 10 | 11868 | 192.168.1.11 | 3306 | 59718 | 732 | 232 | 369 | false | false | 0 | sspudb2 | gbk:28 | 3 | true |
| Processor0 | 11 | 277786 | 192.168.1.13 | 3306 | 37418 | 945 | 286 | 369 | false | false | 0 | sspudb8 | gbk:28 | 3 | true |
| Processor0 | 12 | 277787 | 192.168.1.13 | 3306 | 37420 | 164 | 88 | 369 | false | false | 0 | sspudb9 | gbk:28 | 3 | true |
| Processor0 | 13 | 277788 | 192.168.1.13 | 3306 | 37422 | 164 | 88 | 369 | false | false | 0 | sspudb7 | gbk:28 | 3 | true |
| Processor0 | 14 | 277789 | 192.168.1.13 | 3306 | 37424 | 945 | 286 | 369 | false | false | 0 | sspudb8 | gbk:28 | 3 | true |
| Processor0 | 15 | 299301 | 192.168.1.12 | 3306 | 50418 | 164 | 88 | 369 | false | false | 0 | sspudb5 | gbk:28 | 3 | true |
| Processor0 | 16 | 299302 | 192.168.1.12 | 3306 | 50420 | 164 | 88 | 369 | false | false | 0 | sspudb6 | gbk:28 | 3 | true |
| Processor0 | 17 | 299300 | 192.168.1.12 | 3306 | 50416 | 945 | 286 | 369 | false | false | 0 | sspudb4 | gbk:28 | 3 | true |
| Processor0 | 18 | 299303 | 192.168.1.12 | 3306 | 50422 | 945 | 286 | 369 | false | false | 0 | sspudb4 | gbk:28 | 3 | true |
| Processor0 | 19 | 299304 | 192.168.1.12 | 3306 | 50424 | 164 | 88 | 369 | false | false | 0 | sspudb5 | gbk:28 | 3 | true |
| Processor0 | 20 | 277791 | 192.168.1.13 | 3306 | 37442 | 945 | 286 | 368 | false | false | 0 | sspudb8 | gbk:28 | 3 | true |
| Processor0 | 21 | 277792 | 192.168.1.13 | 3306 | 37444 | 93 | 70 | 368 | false | false | 0 | sspudb9 | gbk:28 | 3 | true |
| Processor0 | 22 | 299306 | 192.168.1.12 | 3306 | 50436 | 945 | 286 | 368 | false | false | 0 | sspudb4 | gbk:28 | 3 | true |
| Processor0 | 23 | 299911 | 192.168.1.12 | 3306 | 54062 | 93 | 70 | 68 | false | false | 0 | sspudb5 | gbk:28 | 3 | true |
| Processor0 | 24 | 12476 | 192.168.1.11 | 3306 | 35152 | 93 | 70 | 68 | false | false | 0 | sspudb3 | gbk:28 | 3 | true |
| Processor0 | 25 | 278397 | 192.168.1.13 | 3306 | 41082 | 164 | 88 | 68 | false | false | 0 | sspudb8 | gbk:28 | 3 | true |
| Processor0 | 26 | 299910 | 192.168.1.12 | 3306 | 54060 | 164 | 88 | 68 | false | false | 0 | sspudb4 | gbk:28 | 3 | true |
| Processor0 | 27 | 12474 | 192.168.1.11 | 3306 | 35140 | 164 | 88 | 68 | false | false | 0 | sspudb2 | gbk:28 | 3 | true |
| Processor0 | 28 | 278398 | 192.168.1.13 | 3306 | 41084 | 93 | 70 | 68 | false | false | 0 | sspudb9 | gbk:28 | 3 | true |
+------------+------+---------+--------------+------+--------+--------+---------+------+--------+----------+------------+---------+---------+---------+------------+
28 rows in set (0.01 sec)
"sspu@192.168.1.11"> show @@session ;
Empty set (0.01 sec)
"sspu@192.168.1.11"> show @@connection.sql ;
+------+--------------+------+--------+---------------+--------------+-----------------------+
| ID | HOST | USER | SCHEMA | START_TIME | EXECUTE_TIME | SQL |
+------+--------------+------+--------+---------------+--------------+-----------------------+
| 1 | 192.168.1.11 | sspu | NULL | 1724208427333 | 0 | show @@connection.sql |
+------+--------------+------+--------+---------------+--------------+-----------------------+
1 row in set (0.00 sec)
"sspu@192.168.1.11"> show @@sql.execute ;
+--------+---------+-------+----------+----------+
| SQL_ID | EXECUTE | TIME | MAX_TIME | MIN_TIME |
+--------+---------+-------+----------+----------+
| 1000 | 100 | 898.9 | 8.8 | 1 |
| 2000 | 100 | 898.9 | 8.8 | 1 |
| 3000 | 100 | 898.9 | 8.8 | 1 |
+--------+---------+-------+----------+----------+
3 rows in set (0.01 sec)
"sspu@192.168.1.11"> show @@sql ;
Empty set (0.00 sec)
"sspu@192.168.1.11"> show @@sql.high ;
Empty set (0.00 sec)
"sspu@192.168.1.11"> show @@sql.slow;
Empty set (0.00 sec)
"sspu@192.168.1.11"> show @@sql.resultset ;
Empty set (0.00 sec)
"sspu@192.168.1.11"> show @@sql.sum ;
Empty set (0.00 sec)
"sspu@192.168.1.11"> show @@parser ;
+----------------+-------------+------------+----------------+------------------+--------------+------------+
| PROCESSOR_NAME | PARSE_COUNT | TIME_COUNT | MAX_PARSE_TIME | MAX_PARSE_SQL_ID | CACHED_COUNT | CACHE_SIZE |
+----------------+-------------+------------+----------------+------------------+--------------+------------+
| NULL | NULL | NULL | NULL | NULL | NULL | NULL |
+----------------+-------------+------------+----------------+------------------+--------------+------------+
1 row in set (0.01 sec)
"sspu@192.168.1.11"> show @@router ;
+----------------+-------------+------------+----------------+------------------+
| PROCESSOR_NAME | ROUTE_COUNT | TIME_COUNT | MAX_ROUTE_TIME | MAX_ROUTE_SQL_ID |
+----------------+-------------+------------+----------------+------------------+
| Processor0 | NULL | NULL | NULL | NULL |
+----------------+-------------+------------+----------------+------------------+
1 row in set (0.00 sec)
"sspu@192.168.1.11"> show @@heartbeat ;
+--------------+-------+--------------+------+---------+-------+--------+---------+--------------+---------------------+-------+
| NAME | TYPE | HOST | PORT | RS_CODE | RETRY | STATUS | TIMEOUT | EXECUTE_TIME | LAST_ACTIVE_TIME | STOP |
+--------------+-------+--------------+------+---------+-------+--------+---------+--------------+---------------------+-------+
| 192.168.1.11 | mysql | 192.168.1.11 | 3306 | 1 | 0 | idle | 0 | 1,4,4 | 2024-08-21 10:49:25 | false |
| 192.168.1.13 | mysql | 192.168.1.13 | 3306 | 1 | 0 | idle | 0 | 1,1,1 | 2024-08-21 10:49:25 | false |
| 192.168.1.12 | mysql | 192.168.1.12 | 3306 | 1 | 0 | idle | 0 | 1,2,2 | 2024-08-21 10:49:25 | false |
+--------------+-------+--------------+------+---------+-------+--------+---------+--------------+---------------------+-------+
3 rows in set (0.00 sec)
"sspu@192.168.1.11"> show @@sysparam;
+-------------------------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| PARAM_NAME | PARAM_VALUE | PARAM_DESCR |
+-------------------------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| processors | 1 | ҪԃԚָ¶¨ϵͳ¿ʓõŏ߳͊ЖµΪRuntime.getRuntime().availableProcessors()·½·¨·µ»صŖµ¡£ҪӰЬprocessorBufferPool¡¢processorBufferLocalPercent¡¢processorExecutor˴є¡£NIOProcessorµĸ²ˇԉ֢¸Զ¨ӥµģ¬̹ӔµŊ±ºՊʵ±µĵ˴є¡£ |
| processorBufferChunk | 4096B | ָ¶¨ÿ´ηׅ㒯cket Direct BufferµĴ𐡣¬Ĭɏˇ4096¸ڡ£֢¸Ւ²ӰЬbuffer poolµij¤¶ȡ£ |
| processorBufferPool | 2097152B | ָ¶¨bufferPool¼Njᠱɀʓۃ¿´ϖ´ѐNIO¶a¢д²ڗ钪ʹԃµ½buffer£¬ϵͳ³¯µŊ±º¨bһ¶¨³¤¶ȵâuffer³ـ´¼ӿ췁¡¢дµŐ§Ê£¬¼¨bbufferµŊ±¼➠ |
| processorBufferLocalPercent | 100 | ¾ΊȓĀ´¿ٖƷׅ喢¸lµĴ𐢓õģ¬µ«ǤҲ²¢²»ˇһ¸·µŖµ£¬Ҳˇһ¸˴єĬɏֵΪ100¡£П³̻º´汙·ֱƠ= bufferLocalPercent / processors˴є¡£ |
| processorExecutor | 4 | ҪԃԚָ¶¨NIOProcessorʏ¹²ЭµâusinessExecutor¹̶¨П³̳ش𐡡£mycat՚ѨҪ´¦mһЩӬ²½ß¼µŊ±º҈ώ»µ½֢¸̳ٖС£т°汾א֢¸ӳصŊ¹ԃƵʲ»ˇºܴ⋣¬¿ʒՉ闃һ¸¡µŖµ¡£ |
| sequnceHandlerType | ±¾µَļþ·½ʽ | ָ¶¨ʹԃMycatȫ¾אŀᑍ¡£ |
| Mysql_packetHeaderSize | 4B | ָ¶¨MysqlЭөאµı¨τͷ³¤¶ȡ£Ĭɏ4 |
| Mysql_maxPacketSize | 16M | ָ¶¨MysqlЭө¿ʒՐ¯´¾ޗ³¤¶ȡ£Ĭɏ16M |
| Mysql_idleTimeout | 30·זѠ | ָ¶¨l½ӵĿ֏г¬ʱʱ¼䡣ijl½Ԕڷ¢ǰ¿֏м쳩Ђ£¬·¢Ж¾ၫʏ´ϊ¹ԃ³¬¹֏ъ±¼䣬Ňô֢¸ӻᱻ»يգ¬¾ΊDZ»ֱ½ӵĹرյ𡤄¬ɏ30·זѠ |
| Mysql_charset | utf8 | l½ӵij¯ؖ·娛ĬɏΪutf8 |
| Mysql_txIsolation | REPEATED_READ | ǰ¶́¬½ӵij¯˂ϱ¸¶±𣭖»՚³¯µŊ±ºã¬ºṹ¾ݿͻ§¶˴«µݹԺ¬½ӽ²½¡£ĬɏΪREPEATED_READ |
| Mysql_sqlExecuteTimeout | 300ī | SQLִѐ³¬ʱµŊ±¼䣬Mycat»Ὤ²ꁬ½ԉЗһ´ϖ´ѐSQLµŊ±¼䣬ɴ³¬¹±¼啲»▱½ӹر֕ぬ½ӡ£Ĭɏʱ¼厪300ī |
| Mycat_processorCheckPeriod | 1ī | ȥmNIOProcessorʏǰº֏С¢³¬ʱºرց¬½ӵļ乴ʱ¼䡣Ĭɏˇ1ī |
| Mycat_dataNodeIdleCheckPeriod | 300ī | ¶Ժ¬½ӽА¡¢³¬ʱ¼쳩µŊ±¼佤¸𣭄¬ɏˇ300ī |
| Mycat_dataNodeHeartbeatPeriod | 10ī | ¶Ժ¡¢д¿ⷢǰфµļ乴ʱ¼䣬Ĭɏˇ10ī |
| Mycat_bindIp | 0.0.0.0 | mycat·þϱ¼µÉPµٖ·£¬ĬɏֵΪ0.0.0.0 |
| Mycat_serverPort | 8066 | mycatµŊ¹ԃ¶˿ڣ¬ĬɏֵΪ8066 |
| Mycat_managerPort | 9066 | mycatµĹ݀ڣ¬ĬɏֵΪ9066 |
+-------------------------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
18 rows in set (0.00 sec)
"sspu@192.168.1.11"> show @@white ;
Empty set (0.00 sec)