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

I am in replication set mode. Add an authentication parameter-- authenticationDatabase

Mongostat-- port 20012-uadmin-pendant xxxxxx'--authenticationDatabase admin

Explanation of each field:

Insert/s: the official explanation is the number of objects inserted into the database per second. If it is slave, the value is preceded by *, which means replication set operation.

Query/s: number of query operations per second

Update/s: number of update operations per second

Delete/s: number of delete operations per second

Getmore/s: the number of getmore operations per second when querying cursor (cursors)

Command: the number of commands executed per second. Two values are displayed in the master-slave system (for example, 3 | 0). The sub-table represents the local | copy command.

Note: the number of commands executed in a second, such as bulk insert, is only considered to be a command (so it should not be meaningful)

Dirty: for WiredTiger engine only, the official website interprets as the cache percentage of dirty data bytes

Used: for WiredTiger engine only, the official website explains the percentage of cache in use

Flushes:

For WiredTiger engine: the number of times checkpoint is triggered during a polling interval

For MMAPv1 engine: the number of times fsync is executed per second to write data to the hard disk

Note: it is usually 0, and the discontinuity will be 1. By calculating the interval between the two 1s, you can roughly understand how long it takes to flush. The cost of flush is very high. If there is frequent flush, you may have to find out why.

Vsize: virtual memory usage in MB (this is the total data of the last call in mongostat)

Res: physical memory usage in MB (this is the total data in the last call to mongostat)

Note: this is the same as what you can see with top, vsize generally does not change much, res will rise slowly, if res often drops suddenly, check to see if any other programs are eating memory.

Qr: the length of the queue that the client waits to read data from the MongoDB instance

Qw: the length of the queue that the client waits to write data from the MongoDB instance

Ar: number of active clients performing read operations

Aw: number of live clients performing write operations

Note: if these two values are large, then DB is blocked and the processing speed of DB is not as fast as the request speed. See if there are expensive slow queries. If everything is normal and the load is really heavy, the machine will need to be added.

Network inbound traffic of netIn:MongoDB instance

Network outbound traffic of netOut:MongoDB instance

Note: the network bandwidth pressure of the table name of these two fields will not become a bottleneck in general.

Conn: the total number of open connections, which is the sum of qr,qw,ar,aw

Note: MongoDB creates a thread for each connection, and thread creation and release will also have overhead, so try to configure the startup parameters of the number of connections properly.

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.