Hi,
I have strange problem with mysql. When I run mysqladmin processlist i get
output (I cut off selects):
| 4045633 | konkursy | targi1.wp.pl | konkursy2 | Query |
14 | Locked | insert into bb2_ludzie_tak values
('Marzena') |
| 4046092 | konkursy | targi1.wp.pl | konkursy2 | Query |
97 | update | insert into bb2_ludzie_tak values
('David') |
| 4046334 | konkursy | targi1.wp.pl | konkursy2 | Query |
87 | Locked | insert into bb2_ludzie_tak values
('Basia') |
| 4046623 | konkursy | targi2.wp.pl | konkursy2 | Query |
24 | Locked | insert into bb2_ludzie_tak values
('Wojciech') | 4045633 | konkursy | targi1.wp.pl |
konkursy2 | Query | 14 | Locked | insert into
bb2_ludzie_tak values
('Marzena') |
| 4046092 | konkursy | targi1.wp.pl | konkursy2 | Query |
97 | update | insert into bb2_ludzie_tak values
('David') |
| 4046334 | konkursy | targi1.wp.pl | konkursy2 | Query |
87 | Locked | insert into bb2_ludzie_tak values
('Basia') |
| 4046623 | konkursy | targi2.wp.pl | konkursy2 | Query |
24 | Locked | insert into bb2_ludzie_tak values
('Wojciech')
Why is mysql locking table during insert operastion? The version is 3.23.22, so
it shouldn't behave like this...
--
_/ _/ _/_/_/ ----- Rafał Jank [EMAIL PROTECTED] -----
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
_/ _/ _/ --------==* http://szukaj.wp.pl *==----------
---------------------------------------------------------------------
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