Hi,

what does mean following ...

mysql> show processlist;
+--------+------+-----------+----------+----------------+-------+-----------------+------------------+

| Id     | User | Host      | db       | Command        | Time  |
State           | Info             |
+--------+------+-----------+----------+----------------+-------+-----------------+------------------+

|      5 |      |           | autocz   | Delayed_insert | 1     |
Waiting on cond | dt               |
|     12 |      |           | abanners | Delayed_insert | 1     |
Waiting on cond | statistics       |
|     18 |      |           | formule1 | Delayed_insert | 3     |
Waiting on cond | pristup          |
|   9405 |      |           | carnext  | Delayed_insert | 6863  |
Waiting on cond | dailytraffic     |
|  10782 |      |           | auto_cz  | Delayed_insert | 18453 |
Waiting on cond | obrazky_stat     |
| 277825 |      |           | autonews | Delayed_insert | 67010 |
Waiting on cond | pristup          |
| 277826 |      |           | autonews | Delayed_insert | 68166 |
Waiting on cond | obrazky_stat     |
| 314346 |      |           | formule1 | Delayed_insert | 56880 |
Waiting on cond | obrazky_stat     |
| 350836 | root | localhost | auto_cz  | Sleep          | 189   |
NULL            | NULL             |
| 361247 | root | localhost | auto_cz  | Sleep          | 1910  |
NULL            | NULL             |
| 361471 | root | localhost | auto_cz  | Sleep          | 1919  |
NULL            | NULL             |
| 364842 | root | localhost | auto_cz  | Sleep          | 291   |
NULL            | NULL             |
| 365388 | root | localhost | auto_cz  | Sleep          | 184   |
NULL            | NULL             |
| 365940 | root | localhost | auto_cz  | Sleep          | 151   |
NULL            | NULL             |
| 365950 | root | localhost | auto_cz  | Sleep          | 67    |
NULL            | NULL             |
| 367387 | root | localhost | auto_cz  | Sleep          | 1126  |
NULL            | NULL             |
| 367567 | root | localhost | auto_cz  | Sleep          | 1248  |
NULL            | NULL             |
| 367903 | root | localhost | auto_cz  | Sleep          | 474   |
NULL            | NULL             |
| 368390 | root | localhost | auto_cz  | Sleep          | 869   |
NULL            | NULL             |
| 368810 | root | localhost | auto_cz  | Sleep          | 2010  |
NULL            | NULL             |
| 368924 | root | localhost | auto_cz  | Sleep          | 736   |
NULL            | NULL             |
| 368995 | root | localhost | auto_cz  | Sleep          | 119   |
NULL            | NULL             |
| 370074 | root | localhost | auto_cz  | Sleep          | 301   |
NULL            | NULL             |
| 370141 | root | localhost | auto_cz  | Sleep          | 805   |
NULL            | NULL             |
| 370532 | root | localhost | auto_cz  | Sleep          | 796   |
NULL            | NULL             |
| 370613 | root | localhost | auto_cz  | Sleep          | 464   |
NULL            | NULL             |
| 370677 | root | localhost | auto_cz  | Sleep          | 452   |
NULL            | NULL             |
| 371171 | root | localhost | auto_cz  | Sleep          | 92    |
NULL            | NULL             |
| 371216 | root | localhost | auto_cz  | Sleep          | 1557  |
NULL            | NULL             |
<cut>

and after while server goues to hell ...

Server status is ....
mysql> status
--------------
mysql  Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)

Connection id:          456292
Current database:
Current user:           root@localhost
Server version          3.22.32
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 1 day 17 hours 5 min 22 sec

Threads: 102  Questions: 9955492  Slow queries: 4  Opens: 39241  Flush
tables: 1  Open tables: 63
--------------


TIA, Mirek Novak


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to