Shulou(Shulou.com)06/01 Report--

Introduction of MyCAT Command Line Monitoring tool

(1)。 Check the operation of the system

Mysql > show @ @ server

(2)。 View ThreadPool information

Mysql > show @ @ threadpool

(3)。 View front-end connection information

Mysql > show @ @ connection

(4)。 View backend connection (pooling) information:

Mysql > show @ @ backend

(5)。 Check to see if the heartbeat is normal

Mysql > show @ @ heartbeat

(6)。 View NIO Reactor information

Mysql > show @ @ processor

Note: NIOReactor is a class in NIO that specifically implements selector. When an event of interest occurs, it notifies the last logic for specific processing. Therefore, the number of data in NIOReactor is equal to the number of specific event handlers.

If the configuration of the system allows, you should increase the number of NIOReactor as much as possible. The default value is the number of system cores. Since writes are written directly by other threads when the channel is idle, write events are registered only when the write is busy and then distributed by the NIOReactor. So NIOReactor mainly deals with read operations.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.