broj upita na sat, na minut, na sekund ..na dan, od kada je server startovan ?
ako samo kucnes "status;" dobices dosta korisnih informacija ... na primer:
Code:
mysql> status
--------------
mysql Ver 14.14 Distrib 5.5.8, for linux2.6 (x86_64) using EditLine wrapper
Connection id: 793661
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.8-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 13 hours 36 min 31 sec
Threads: 3 Questions: 6669268 Slow queries: 3 Opens: 6958 Flush tables: 1 Open tables: 332 Queries per second avg: 136.132
--------------
mysql>
e sad ... imas gomilu COM_* statusa koje ti daju trenutne vrednosti:
Code:
mysql> show global status like '%com_update%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Com_update | 49621 |
| Com_update_multi | 29 |
+------------------+-------+
2 rows in set (0.00 sec)
mysql> show global status like '%com_insert%';
+-------------------+--------+
| Variable_name | Value |
+-------------------+--------+
| Com_insert | 436678 |
| Com_insert_select | 45 |
+-------------------+--------+
2 rows in set (0.00 sec)
dakle bilo je 49621+29 update-a, 436678+45 inserta
imas mnogo raznih tih com_% ... com_select npr ...
mozes na primer:
Code:
mysql> select SUM(VARIABLE_VALUE) nekibroj from INFORMATION_SCHEMA.GLOBAL_STATUS where VARIABLE_NAME like 'com_%';
+----------+
| nekibroj |
+----------+
| 4044277 |
+----------+
1 row in set, 1 warning (0.00 sec)
naravno, ne bi trebalo samo like 'com_%' posto tamo stvarno ima stvari koje te ne zanimaju :D