In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Kiss Gabor) writes:
Most leallitottam azt a programot, amelyik folyvast _irta_ az adatbazist.
Elindult egy torles. A masik ablakban ezt latom:
mysql> show full processlist\G
*************************** 1. row ***************************
Id: 9
User: root
Host: localhost
db: nfsenalarm
Command: Query
Time: 171
State: invalidating query cache entries (key)
Info: delete from alarms where id<4000
*************************** 2. row ***************************
Id: 10
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: show full processlist
2 rows in set (0.00 sec)
Aztan csak a Time novekszik a 9-es processnel.
| 4653 | 1182508996 | 1182510025 | live | ddos |
| 4654 | 1182509640 | 1182509991 | live | ddos |
| 4655 | 1182509503 | 1182509991 | live | ddos |
| 4656 | 1182509636 | 1182509990 | live | ddos |
| 4657 | 1182509653 | 1182509887 | live | ddos |
| 4658 | 1182508282 | 1182509995 | live | ddos |
+------+------------+------------+---------+------+
2659 rows in set (0.10 sec)
mysql> delete from alarms where id<4000;
Query OK, 2000 rows affected (11 min 11.65 sec)
mysql>
kissg
_________________________________________________
linux lista - [email protected]
http://mlf2.linux.rulez.org/mailman/listinfo/linux
