Schlagwort: status

Einmal an die eigene Notizwand gekritzelt:

1. MySQL Verbindungen + weitere Verbindungsrelevante Infos anzeigen:

   root@localhost [(none)]> show status like '%onn%'; +--------------------------+--------+ | Variable_name | Value | +--------------------------+--------+ | Aborted_connects | 0 | | Connections | 440921 | | Max_used_connections | 67 | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_finished_connects | 0 | | Threads_connected | 2 | +--------------------------+--------+ 7 rows in set (0.00 sec)

   root@localhost [(none)]> show status like '%onn%'; +--------------------------+--------+ | Variable_name | Value | +--------------------------+--------+ | Aborted_connects | 0 | | Connections | 440921 | | Max_used_connections | 67 | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_finished_connects | 0 | | Threads_connected | 2 | +--------------------------+--------+ 7 rows in set (0.00 sec)

2. MySQL Prozessliste anzeigen:

   root@localhost [(none)]> show processlist; +--------+-------+-----------+-------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +--------+-------+-----------+-------+---------+------+-------+------------------+ | 440912 | ttrss | localhost | ttrss | Sleep | 0 | | NULL | | 440919 | root | localhost | NULL | Query | 0 | NULL | show processlist | +--------+-------+-----------+-------+---------+------+-------+------------------+ 2 rows in set (0.00 sec)

   root@localhost [(none)]> show processlist; +--------+-------+-----------+-------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +--------+-------+-----------+-------+---------+------+-------+------------------+ | 440912 | ttrss | localhost | ttrss | Sleep | 0 | | NULL | | 440919 | root | localhost | NULL | Query | 0 | NULL | show processlist | +--------+-------+-----------+-------+---------+------+-------+------------------+ 2 rows in set (0.00 sec)

3. Der status Parameter der mysqladmin Binary auf der Kommandozeile:

   root@host ~ $ mysqladmin status
   Uptime: 1621495  Threads: 2  Questions: 18982236  Slow queries: 6  Opens: 83474  Flush tables: 1  Open tables: 400  Queries per second avg: 11.706
   

4. Und last but not least auch noch einmal die Prompt-Einstellung aus der /etc/mysql/my.cnf festgehalten:

   [mysql] prompt = \u@\h [\d]>\_

   [mysql] prompt = \u@\h [\d]>\_

Die MySQL Befehle habe ich von dieser Webseite kopiert. Die Prompt Einstellungen weiß ich nicht mehr woher…