Status Komutu

Giriş

Açıklaması şöyle

The "status" command is a client-side command that provides basic information about the server, including the version, connection ID, current user, and current database. It is executed within the MariaDB client, and the output is displayed in the console.

On the other hand, the "show status" command is a server-side command that displays a list of server status variables and their values. It provides detailed information about the server's internal state, such as the number of queries executed, the number of connections, and the amount of memory used.

Örnek

Şöyle yaparız

> status
--------------
mysql  Ver 15.1 Distrib 10.9.3-MariaDB, for debian-linux-gnu (x86_64) using  
EditLine wrapper

Connection id:          4
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server:                 MariaDB
Server version:         10.9.3-MariaDB-1:10.9.3+maria~ubu2204 mariadb.org 
binary distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /run/mysqld/mysqld.sock
Uptime:                 11 min 43 sec

Threads: 1  Questions: 6  
Slow queries: 0  Opens: 17  Open tables: 10  Queries per second avg: 0.008
--------------