Description:
We have distributed applications which make extensive use of the
get_lock() function
to acquire a system-wide lock. Occasionally, all copies of a given
application
block attempting to acquire a lock on the same lock string. Using
is_used_lock() reports
that the lock is held by a particular thread ID.
In one instance, this thread ID did not exist.
In another instance, it did exist, but after killing that thread,
is_used_lock()
still reported the same (now non-existent) thread as holding the lock.
Here is an example:
output from 'mysql newsnow -unewsnow -e "select is_used_lock('1 1
11')"':
is_used_lock('1 1 11')
1111166
mysqladmin processlist output at same time - note that the above thread
ID is not listed:
+---------+----------+------------------------------------------+---------+----------------+-------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command
| Time | State | Info |
+---------+----------+------------------------------------------+---------+----------------+-------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+
| 29 | DELAYED | | newsnow | Delayed insert
| 0 | Waiting for INSERT | |
| 36 | DELAYED | | newsnow | Delayed insert
| 0 | Waiting for INSERT | |
| 66 | DELAYED | | newsnow | Delayed insert
| 0 | Waiting for INSERT | |
| 152 | DELAYED | | newsnow | Delayed insert
| 0 | Waiting for INSERT | |
| 1270 | repl | gilligan.webcluster.newsnow.co.uk:55619
| | Binlog Dump | 49399 | Has sent all
binlog to slave; waiting for binlog to be updated |
|
| 1931 | newsnow | fw-2.webcluster.newsnow.co.uk:34872
| newsnow | Sleep | 21 | | |
| 303482 | newsnow | king.webcluster.newsnow.co.uk:40739
| newsnow | Query | 0 | Locked | /*
SouAutFre */ select distinct(substring(FDate, 1, 10))
as _Date, dayofweek(FDate) as _Day from Ref |
| 764780 | champ | bush.newsnow.net:55504 | newsnow
| Sleep | 2 | | |
| 764781 | champ | bush.newsnow.net:55505 | newsnow
| Sleep | 3 | | |
| 764782 | champ | bush.newsnow.net:55506 | newsnow
| Sleep | 2 | | |
| 770544 | newsnow | fw-1.webcluster.newsnow.co.uk:46897
| newsnow | Sleep | 2 | | |
| 993861 | newsnow | ford.webcluster.newsnow.co.uk:42566
| newsnow | Sleep | 3 | | |
| 993865 | newsnow | ford.webcluster.newsnow.co.uk:42567
| newsnow | Sleep | 4 | | |
| 994002 | newsnow | simpson.webcluster.newsnow.co.uk:36279
| newsnow | Sleep | 5 | | |
| 994021 | newsnow | db-1.webcluster.newsnow.co.uk:46345
| newsnow | Sleep | 0 | | |
| 994023 | newsnow | db-1.webcluster.newsnow.co.uk:46346
| newsnow | Sleep | 3 | | |
| 994026 | newsnow | db-2.webcluster.newsnow.co.uk:45053
| newsnow | Sleep | 3 | | |
| 994092 | newsnow | fw-2.webcluster.newsnow.co.uk:42534
| newsnow | Sleep | 5 | | |
| 994116 | newsnow | db-1.webcluster.newsnow.co.uk:46347
| newsnow | Sleep | 4 | | |
| 994475 | newsnow | king.webcluster.newsnow.co.uk:40726
| newsnow | Sleep | 1 | | |
| 999805 | newsnow | www-2.webcluster.newsnow.co.uk:37533
| newsnow | Sleep | 4 | | |
| 1000512 | newsnow | king.webcluster.newsnow.co.uk:41318
| newsnow | Sleep | 3 | | |
| 1055442 | newsnow | db-2.webcluster.newsnow.co.uk:48367
| newsnow | Sleep | 5 | | |
| 1069420 | champ | bush.newsnow.net:59271 | newsnow
| Sleep | 3 | | |
| 1082340 | newsnow | ford.webcluster.newsnow.co.uk:42627
| newsnow | Sleep | 3 | | |
| 1083492 | newsnow | pilger.webcluster.newsnow.co.uk:51545
| newsnow | Sleep | 2302 | | |
| 1103671 | newsnow | pilger.webcluster.newsnow.co.uk:38456
| newsnow | Sleep | 2303 | | |
| 1104668 | newsnow | pilger.webcluster.newsnow.co.uk:39304
| newsnow | Sleep | 2279 | | |
| 1104691 | newsnow | pilger.webcluster.newsnow.co.uk:39328
| newsnow | Sleep | 2302 | | |
| 1105458 | newsnow | pilger.webcluster.newsnow.co.uk:39994
| newsnow | Sleep | 2301 | | |
| 1105526 | newsnow | pilger.webcluster.newsnow.co.uk:40045
| newsnow | Sleep | 2299 | | |
| 1106150 | newsnow | pilger.webcluster.newsnow.co.uk:40547
| newsnow | Sleep | 2303 | | |
| 1106190 | newsnow | pilger.webcluster.newsnow.co.uk:40597
| newsnow | Sleep | 2303 | | |
| 1106387 | newsnow | pilger.webcluster.newsnow.co.uk:40987
| newsnow | Sleep | 2303 | | |
| 1106463 | newsnow | pilger.webcluster.newsnow.co.uk:41075
| newsnow | Sleep | 2294 | | |
| 1106622 | newsnow | pilger.webcluster.newsnow.co.uk:41271
| newsnow | Sleep | 2302 | | |
| 1107053 | newsnow | pilger.webcluster.newsnow.co.uk:41883
| newsnow | Sleep | 2301 | | |
| 1107139 | newsnow | pilger.webcluster.newsnow.co.uk:41974
| newsnow | Sleep | 2300 | | |
| 1107210 | newsnow | pilger.webcluster.newsnow.co.uk:42060
| newsnow | Sleep | 2281 | | |
| 1107256 | newsnow | pilger.webcluster.newsnow.co.uk:42114
| newsnow | Sleep | 2302 | | |
| 1107327 | newsnow | pilger.webcluster.newsnow.co.uk:42195
| newsnow | Sleep | 2303 | | |
| 1107335 | newsnow | pilger.webcluster.newsnow.co.uk:42217
| newsnow | Sleep | 2271 | | |
| 1107348 | newsnow | pilger.webcluster.newsnow.co.uk:42227
| newsnow | Sleep | 2303 | | |
| 1107411 | newsnow | pilger.webcluster.newsnow.co.uk:42319
| newsnow | Sleep | 2303 | | |
| 1107444 | newsnow | pilger.webcluster.newsnow.co.uk:42497
| newsnow | Sleep | 2303 | | |
| 1107482 | newsnow | pilger.webcluster.newsnow.co.uk:42558
| newsnow | Sleep | 2301 | | |
| 1107501 | newsnow | pilger.webcluster.newsnow.co.uk:42579
| newsnow | Sleep | 2303 | | |
| 1107592 | newsnow | pilger.webcluster.newsnow.co.uk:42651
| newsnow | Sleep | 2302 | | |
| 1107821 | newsnow | pilger.webcluster.newsnow.co.uk:42911
| newsnow | Sleep | 2297 | | |
| 1107842 | newsnow | pilger.webcluster.newsnow.co.uk:42926
| newsnow | Sleep | 2291 | | |
| 1107903 | newsnow | pilger.webcluster.newsnow.co.uk:42989
| newsnow | Sleep | 2296 | | |
| 1107905 | newsnow | pilger.webcluster.newsnow.co.uk:42991
| newsnow | Sleep | 2276 | | |
| 1108050 | newsnow | pilger.webcluster.newsnow.co.uk:43150
| newsnow | Sleep | 2297 | | |
| 1108099 | newsnow | pilger.webcluster.newsnow.co.uk:43266
| newsnow | Sleep | 2295 | | |
| 1108129 | newsnow | pilger.webcluster.newsnow.co.uk:43294
| newsnow | Sleep | 2297 | | |
| 1108161 | newsnow | pilger.webcluster.newsnow.co.uk:43342
| newsnow | Sleep | 2302 | | |
| 1108171 | newsnow | pilger.webcluster.newsnow.co.uk:43347
| newsnow | Sleep | 2302 | | |
| 1108260 | newsnow | pilger.webcluster.newsnow.co.uk:43468
| newsnow | Sleep | 2298 | | |
| 1108283 | newsnow | pilger.webcluster.newsnow.co.uk:43485
| newsnow | Sleep | 2302 | | |
| 1108417 | newsnow | pilger.webcluster.newsnow.co.uk:43646
| newsnow | Sleep | 2302 | | |
| 1108480 | newsnow | pilger.webcluster.newsnow.co.uk:43712
| newsnow | Sleep | 2302 | | |
| 1108482 | newsnow | pilger.webcluster.newsnow.co.uk:43717
| newsnow | Sleep | 2302 | | |
| 1108538 | newsnow | pilger.webcluster.newsnow.co.uk:43799
| newsnow | Sleep | 2273 | | |
| 1108603 | newsnow | pilger.webcluster.newsnow.co.uk:43911
| newsnow | Sleep | 2298 | | |
| 1108623 | newsnow | pilger.webcluster.newsnow.co.uk:43956
| newsnow | Sleep | 2301 | | |
| 1108645 | newsnow | pilger.webcluster.newsnow.co.uk:43994
| newsnow | Sleep | 2291 | | |
| 1108648 | newsnow | pilger.webcluster.newsnow.co.uk:44000
| newsnow | Sleep | 2302 | | |
| 1108710 | newsnow | pilger.webcluster.newsnow.co.uk:44081
| newsnow | Sleep | 2297 | | |
| 1108749 | newsnow | pilger.webcluster.newsnow.co.uk:44115
| newsnow | Sleep | 2297 | | |
| 1108795 | newsnow | pilger.webcluster.newsnow.co.uk:44183
| newsnow | Sleep | 2296 | | |
| 1108796 | newsnow | pilger.webcluster.newsnow.co.uk:44184
| newsnow | Sleep | 2273 | | |
| 1108824 | newsnow | pilger.webcluster.newsnow.co.uk:44219
| newsnow | Sleep | 2293 | | |
| 1108865 | newsnow | pilger.webcluster.newsnow.co.uk:44252
| newsnow | Sleep | 2297 | | |
| 1108874 | newsnow | pilger.webcluster.newsnow.co.uk:44273
| newsnow | Sleep | 2294 | | |
| 1108913 | newsnow | pilger.webcluster.newsnow.co.uk:44313
| newsnow | Sleep | 2311 | | |
| 1108948 | newsnow | pilger.webcluster.newsnow.co.uk:44344
| newsnow | Sleep | 2272 | | |
| 1109024 | newsnow | pilger.webcluster.newsnow.co.uk:44392
| newsnow | Sleep | 2291 | | |
| 1109218 | newsnow | pilger.webcluster.newsnow.co.uk:44563
| newsnow | Sleep | 2304 | | |
| 1109267 | newsnow | pilger.webcluster.newsnow.co.uk:44620
| newsnow | Sleep | 2297 | | |
| 1109317 | newsnow | pilger.webcluster.newsnow.co.uk:44665
| newsnow | Sleep | 2297 | | |
| 1109562 | newsnow | pilger.webcluster.newsnow.co.uk:44896
| newsnow | Sleep | 2277 | | |
| 1109598 | newsnow | pilger.webcluster.newsnow.co.uk:44926
| newsnow | Sleep | 2299 | | |
| 1109616 | newsnow | pilger.webcluster.newsnow.co.uk:44942
| newsnow | Sleep | 2292 | | |
| 1109625 | newsnow | pilger.webcluster.newsnow.co.uk:44953
| newsnow | Sleep | 2291 | | |
| 1109658 | newsnow | pilger.webcluster.newsnow.co.uk:44977
| newsnow | Sleep | 2297 | | |
| 1109686 | newsnow | pilger.webcluster.newsnow.co.uk:45009
| newsnow | Sleep | 2297 | | |
| 1109691 | newsnow | pilger.webcluster.newsnow.co.uk:45014
| newsnow | Sleep | 2295 | | |
| 1109712 | newsnow | pilger.webcluster.newsnow.co.uk:45042
| newsnow | Sleep | 2294 | | |
| 1109772 | newsnow | pilger.webcluster.newsnow.co.uk:45100
| newsnow | Sleep | 2297 | | |
| 1109786 | newsnow | pilger.webcluster.newsnow.co.uk:45117
| newsnow | Sleep | 2290 | | |
| 1109813 | newsnow | pilger.webcluster.newsnow.co.uk:45146
| newsnow | Sleep | 2297 | | |
| 1109820 | newsnow | pilger.webcluster.newsnow.co.uk:45157
| newsnow | Sleep | 2308 | | |
| 1109846 | newsnow | pilger.webcluster.newsnow.co.uk:45198
| newsnow | Sleep | 2297 | | |
| 1109857 | newsnow | pilger.webcluster.newsnow.co.uk:45204
| newsnow | Sleep | 2298 | | |
| 1109954 | newsnow | pilger.webcluster.newsnow.co.uk:45302
| newsnow | Sleep | 2296 | | |
| 1109957 | newsnow | pilger.webcluster.newsnow.co.uk:45329
| newsnow | Sleep | 2301 | | |
| 1109970 | newsnow | pilger.webcluster.newsnow.co.uk:45342
| newsnow | Sleep | 2301 | | |
| 1110002 | newsnow | pilger.webcluster.newsnow.co.uk:45553
| newsnow | Sleep | 2296 | | |
| 1110008 | newsnow | pilger.webcluster.newsnow.co.uk:45562
| newsnow | Sleep | 2300 | | |
| 1110015 | newsnow | pilger.webcluster.newsnow.co.uk:45565
| newsnow | Sleep | 2300 | | |
| 1110084 | newsnow | pilger.webcluster.newsnow.co.uk:45609
| newsnow | Sleep | 2273 | | |
| 1110124 | newsnow | pilger.webcluster.newsnow.co.uk:45659
| newsnow | Sleep | 2300 | | |
| 1110147 | newsnow | pilger.webcluster.newsnow.co.uk:45674
| newsnow | Sleep | 2289 | | |
| 1110155 | newsnow | pilger.webcluster.newsnow.co.uk:45678
| newsnow | Sleep | 2325 | | |
| 1110167 | newsnow | pilger.webcluster.newsnow.co.uk:45683
| newsnow | Sleep | 2299 | | |
| 1110191 | newsnow | pilger.webcluster.newsnow.co.uk:45690
| newsnow | Sleep | 2295 | | |
| 1110194 | newsnow | pilger.webcluster.newsnow.co.uk:45695
| newsnow | Sleep | 2301 | | |
| 1110414 | newsnow | pilger.webcluster.newsnow.co.uk:45903
| newsnow | Sleep | 2282 | | |
| 1110419 | newsnow | pilger.webcluster.newsnow.co.uk:45907
| newsnow | Sleep | 2290 | | |
| 1110423 | newsnow | pilger.webcluster.newsnow.co.uk:45910
| newsnow | Sleep | 2289 | | |
| 1110459 | newsnow | pilger.webcluster.newsnow.co.uk:45938
| newsnow | Sleep | 2294 | | |
| 1110500 | newsnow | pilger.webcluster.newsnow.co.uk:45971
| newsnow | Sleep | 2299 | | |
| 1110514 | newsnow | pilger.webcluster.newsnow.co.uk:45993
| newsnow | Sleep | 2301 | | |
| 1110529 | newsnow | pilger.webcluster.newsnow.co.uk:46004
| newsnow | Sleep | 2296 | | |
| 1110652 | newsnow | pilger.webcluster.newsnow.co.uk:46103
| newsnow | Sleep | 2295 | | |
| 1110656 | newsnow | pilger.webcluster.newsnow.co.uk:46108
| newsnow | Sleep | 2278 | | |
| 1110750 | newsnow | pilger.webcluster.newsnow.co.uk:46194
| newsnow | Sleep | 2269 | | |
| 1110793 | newsnow | pilger.webcluster.newsnow.co.uk:46236
| newsnow | Sleep | 2272 | | |
| 1110796 | newsnow | pilger.webcluster.newsnow.co.uk:46237
| newsnow | Sleep | 2296 | | |
| 1110803 | newsnow | pilger.webcluster.newsnow.co.uk:46244
| newsnow | Sleep | 2301 | | |
| 1110910 | newsnow | pilger.webcluster.newsnow.co.uk:46273
| newsnow | Sleep | 2301 | | |
| 1110980 | newsnow | pilger.webcluster.newsnow.co.uk:46333
| newsnow | Sleep | 2301 | | |
| 1111028 | newsnow | pilger.webcluster.newsnow.co.uk:46398
| newsnow | Sleep | 2301 | | |
| 1111079 | newsnow | pilger.webcluster.newsnow.co.uk:46448
| newsnow | Sleep | 2326 | | |
| 1111085 | newsnow | pilger.webcluster.newsnow.co.uk:46452
| newsnow | Sleep | 2301 | | |
| 1111091 | newsnow | pilger.webcluster.newsnow.co.uk:46456
| newsnow | Sleep | 2273 | | |
| 1111094 | newsnow | pilger.webcluster.newsnow.co.uk:46460
| newsnow | Sleep | 2326 | | |
| 1111136 | newsnow | pilger.webcluster.newsnow.co.uk:46503
| newsnow | Connect | 2328 | Reading from net
| |
| 1111154 | newsnow | pilger.webcluster.newsnow.co.uk:46517
| newsnow | Sleep | 2286 | | |
| 1111159 | newsnow | pilger.webcluster.newsnow.co.uk:46526
| newsnow | Sleep | 2309 | | |
| 1111164 | newsnow | pilger.webcluster.newsnow.co.uk:46532
| newsnow | Sleep | 2326 | | |
| 1111167 | newsnow | pilger.webcluster.newsnow.co.uk:46535
| newsnow | Sleep | 2296 | | |
| 1111178 | newsnow | pilger.webcluster.newsnow.co.uk:46543
| newsnow | Sleep | 2296 | | |
| 1111195 | newsnow | pilger.webcluster.newsnow.co.uk:46553
| newsnow | Sleep | 2277 | | |
| 1111198 | newsnow | pilger.webcluster.newsnow.co.uk:46555
| newsnow | Sleep | 2291 | | |
| 1111215 | newsnow | pilger.webcluster.newsnow.co.uk:46562
| newsnow | Sleep | 2309 | | |
| 1111224 | newsnow | www-1.webcluster.newsnow.co.uk:39821 |
newsnow | Query | 42 | User lock | /* WInd
*/ SELECT GET_LOCK("WIndexWord called",60) AS
WIndexWordL |
| 1111251 | newsnow | pilger.webcluster.newsnow.co.uk:46605
| newsnow | Sleep | 2299 | | |
| 1111255 | newsnow | pilger.webcluster.newsnow.co.uk:46606
| newsnow | Connect | 2300 | Reading from net
| |
| 1111288 | newsnow | pilger.webcluster.newsnow.co.uk:46613
| newsnow | Sleep | 2295 | | |
| 1111330 | newsnow | pilger.webcluster.newsnow.co.uk:46615
| newsnow | Sleep | 2291 | | |
| 1111429 | newsnow | pilger.webcluster.newsnow.co.uk:46624
| newsnow | Sleep | 2277 | | |
| 1111430 | newsnow | pilger.webcluster.newsnow.co.uk:46625
| newsnow | Sleep | 2279 | | |
| 1114037 | newsnow | pilger.webcluster.newsnow.co.uk:32960
| newsnow | Sleep | 1 | | |
| 1114038 | newsnow | pilger.webcluster.newsnow.co.uk:32961
| newsnow | Sleep | 2 | | |
| 1114047 | newsnow | pilger.webcluster.newsnow.co.uk:32968
| newsnow | Sleep | 15 | | |
| 1114084 | newsnow |
backend-1.webcluster.newsnow.co.uk:32779 | newsnow | Sleep
| 13 | | |
| 1114132 | newsnow | www-1.webcluster.newsnow.co.uk:32984
| newsnow | Sleep | 11 | | |
| 1114159 | newsnow |
backend-1.webcluster.newsnow.co.uk:32801 | newsnow | Sleep
| 4 | | |
| 1121203 | newsnow | db-2.webcluster.newsnow.co.uk:50394
| newsnow | Sleep | 7 | | |
| 1124244 | mysqltop |
fw-2.webcluster.newsnow.co.uk:55414 | | Sleep | 1
| | |
| 1125263 | newsnow | simpson.webcluster.newsnow.co.uk:50419
| newsnow | Sleep | 11 | | |
| 1125273 | newsnow | simpson.webcluster.newsnow.co.uk:50499
| newsnow | Sleep | 11 | | |
| 1125276 | newsnow | king.webcluster.newsnow.co.uk:41573
| newsnow | Connect | 897 | Reading from net
| |
| 1125282 | newsnow | simpson.webcluster.newsnow.co.uk:50600
| newsnow | Sleep | 4 | | |
| 1125292 | newsnow | king.webcluster.newsnow.co.uk:41690
| newsnow | Connect | 891 | Reading from net
| |
| 1125308 | newsnow | simpson.webcluster.newsnow.co.uk:50721
| newsnow | Sleep | 8 | | |
| 1125361 | newsnow | king.webcluster.newsnow.co.uk:41910
| newsnow | Sleep | 2 | | |
| 1125376 | newsnow | db-2.webcluster.newsnow.co.uk:59439
| newsnow | Connect | 868 | Reading from net
| |
| 1125394 | newsnow | db-2.webcluster.newsnow.co.uk:59643
| newsnow | Sleep | 12 | | |
| 1125404 | newsnow | db-2.webcluster.newsnow.co.uk:59720
| newsnow | Sleep | 14 | | |
| 1125413 | newsnow | db-2.webcluster.newsnow.co.uk:60014
| newsnow | Sleep | 1 | | |
| 1125414 | newsnow | db-2.webcluster.newsnow.co.uk:60018
| newsnow | Sleep | 8 | | |
| 1125416 | newsnow | simpson.webcluster.newsnow.co.uk:51496
| newsnow | Sleep | 7 | | |
| 1125417 | newsnow | db-2.webcluster.newsnow.co.uk:60042
| newsnow | Sleep | 11 | | |
| 1125418 | newsnow | db-2.webcluster.newsnow.co.uk:60054
| newsnow | Sleep | 9 | | |
| 1125421 | newsnow | db-2.webcluster.newsnow.co.uk:60079
| newsnow | Sleep | 12 | | |
| 1125422 | newsnow | db-2.webcluster.newsnow.co.uk:60090
| newsnow | Sleep | 3 | | |
| 1125423 | newsnow | db-2.webcluster.newsnow.co.uk:60102
| newsnow | Sleep | 1 | | |
| 1125424 | newsnow | simpson.webcluster.newsnow.co.uk:51609
| newsnow | Sleep | 6 | | |
| 1125425 | newsnow | db-2.webcluster.newsnow.co.uk:60131
| newsnow | Sleep | 3 | | |
| 1125426 | newsnow | simpson.webcluster.newsnow.co.uk:51618
| newsnow | Sleep | 6 | | |
| 1125427 | newsnow | db-2.webcluster.newsnow.co.uk:60141
| newsnow | Sleep | 11 | | |
| 1125428 | newsnow | db-2.webcluster.newsnow.co.uk:60152
| newsnow | Sleep | 5 | | |
| 1125430 | newsnow | db-2.webcluster.newsnow.co.uk:60163
| newsnow | Sleep | 5 | | |
| 1125442 | newsnow | db-2.webcluster.newsnow.co.uk:60209
| newsnow | Sleep | 0 | | |
| 1125443 | newsnow | db-2.webcluster.newsnow.co.uk:60222
| newsnow | Sleep | 10 | | |
| 1125452 | newsnow | db-2.webcluster.newsnow.co.uk:60253
| newsnow | Sleep | 16 | | |
| 1125458 | newsnow | db-2.webcluster.newsnow.co.uk:60274
| newsnow | Sleep | 11 | | |
| 1125563 | newsnow | db-2.webcluster.newsnow.co.uk:60861
| newsnow | Sleep | 13 | | |
| 1125576 | newsnow | db-2.webcluster.newsnow.co.uk:60979
| newsnow | Sleep | 11 | | |
| 1125591 | newsnow | db-2.webcluster.newsnow.co.uk:32846
| newsnow | Sleep | 13 | | |
| 1125592 | newsnow | db-2.webcluster.newsnow.co.uk:32870
| newsnow | Sleep | 10 | | |
| 1125601 | newsnow | simpson.webcluster.newsnow.co.uk:52621
| newsnow | Sleep | 4 | | |
| 1125623 | newsnow | db-2.webcluster.newsnow.co.uk:33048
| newsnow | Sleep | 6 | | |
| 1125631 | newsnow | db-2.webcluster.newsnow.co.uk:33093
| newsnow | Sleep | 8 | | |
| 1125633 | newsnow | db-2.webcluster.newsnow.co.uk:33102
| newsnow | Sleep | 19 | | |
| 1125638 | newsnow | db-2.webcluster.newsnow.co.uk:33114
| newsnow | Sleep | 1 | | |
| 1125650 | newsnow | db-2.webcluster.newsnow.co.uk:33195
| newsnow | Sleep | 15 | | |
| 1125655 | newsnow | db-2.webcluster.newsnow.co.uk:33261
| newsnow | Sleep | 12 | | |
| 1125665 | newsnow | simpson.webcluster.newsnow.co.uk:53221
| newsnow | Sleep | 8 | | |
| 1125691 | newsnow | simpson.webcluster.newsnow.co.uk:53529
| newsnow | Sleep | 8 | | |
| 1125699 | newsnow | king.webcluster.newsnow.co.uk:44577
| newsnow | Sleep | 8 | | |
| 1125723 | newsnow | simpson.webcluster.newsnow.co.uk:53777
| newsnow | Sleep | 11 | | |
| 1125724 | newsnow | simpson.webcluster.newsnow.co.uk:53786
| newsnow | Sleep | 7 | | |
| 1125725 | newsnow | simpson.webcluster.newsnow.co.uk:53795
| newsnow | Sleep | 9 | | |
| 1125781 | newsnow | king.webcluster.newsnow.co.uk:45265
| newsnow | Sleep | 4 | | |
| 1125799 | newsnow | king.webcluster.newsnow.co.uk:45360
| newsnow | Sleep | 5 | | |
| 1125807 | newsnow | db-2.webcluster.newsnow.co.uk:34722
| newsnow | Sleep | 3 | | |
| 1125835 | newsnow | simpson.webcluster.newsnow.co.uk:54631
| newsnow | Sleep | 4 | | |
| 1125841 | newsnow | simpson.webcluster.newsnow.co.uk:54856
| newsnow | Sleep | 3 | | |
| 1125842 | newsnow | simpson.webcluster.newsnow.co.uk:54859
| newsnow | Sleep | 9 | | |
| 1125845 | mysqltop |
fw-2.webcluster.newsnow.co.uk:55990 | | Sleep | 1
| | |
| 1125847 | newsnow | simpson.webcluster.newsnow.co.uk:55074
| newsnow | Sleep | 6 | | |
| 1125958 | newsnow | simpson.webcluster.newsnow.co.uk:55621
| newsnow | Sleep | 9 | | |
| 1125960 | newsnow | simpson.webcluster.newsnow.co.uk:55650
| newsnow | Sleep | 1 | | |
| 1125964 | newsnow | simpson.webcluster.newsnow.co.uk:55657
| newsnow | Sleep | 6 | | |
| 1125965 | newsnow | simpson.webcluster.newsnow.co.uk:55697
| newsnow | Sleep | 4 | | |
| 1125969 | newsnow | simpson.webcluster.newsnow.co.uk:55708
| newsnow | Sleep | 12 | | |
| 1125972 | newsnow | simpson.webcluster.newsnow.co.uk:55759
| newsnow | Connect | 542 | Reading from net
| |
| 1125977 | newsnow | simpson.webcluster.newsnow.co.uk:55783
| newsnow | Sleep | 8 | | |
| 1125996 | newsnow | simpson.webcluster.newsnow.co.uk:55949
| newsnow | Sleep | 4 | | |
| 1125997 | newsnow | simpson.webcluster.newsnow.co.uk:55955
| newsnow | Sleep | 8 | | |
| 1126012 | newsnow | simpson.webcluster.newsnow.co.uk:56050
| newsnow | Sleep | 1 | | |
| 1126018 | newsnow | simpson.webcluster.newsnow.co.uk:56068
| newsnow | Sleep | 2 | | |
| 1126019 | newsnow | simpson.webcluster.newsnow.co.uk:56079
| newsnow | Sleep | 9 | | |
| 1126031 | newsnow | db-2.webcluster.newsnow.co.uk:36429
| newsnow | Sleep | 9 | | |
| 1126032 | newsnow | simpson.webcluster.newsnow.co.uk:56126
| newsnow | Sleep | 3 | | |
| 1126058 | newsnow | simpson.webcluster.newsnow.co.uk:56230
| newsnow | Sleep | 1 | | |
| 1126064 | newsnow | simpson.webcluster.newsnow.co.uk:56273
| newsnow | Sleep | 6 | | |
| 1126065 | newsnow | simpson.webcluster.newsnow.co.uk:56282
| newsnow | Sleep | 10 | | |
| 1126128 | newsnow | db-2.webcluster.newsnow.co.uk:37091
| newsnow | Sleep | 13 | | |
| 1126167 | newsnow | pilger.webcluster.newsnow.co.uk:37886
| newsnow | Query | 1 | User lock |
select get_lock('1 1 11',60) as L |
| 1126209 | DELAYED | | newsnow | Delayed insert
| 13 | Waiting for INSERT | |
| 1126236 | newsnow | db-2.webcluster.newsnow.co.uk:37459
| newsnow | Sleep | 8 | | |
| 1126239 | newsnow | db-2.webcluster.newsnow.co.uk:37473
| newsnow | Sleep | 15 | | |
| 1126260 | newsnow | simpson.webcluster.newsnow.co.uk:57252
| newsnow | Sleep | 14 | | |
| 1126283 | newsnow | simpson.webcluster.newsnow.co.uk:57299
| newsnow | Sleep | 9 | | |
| 1126312 | newsnow | simpson.webcluster.newsnow.co.uk:57348
| newsnow | Sleep | 10 | | |
| 1126333 | newsnow | db-2.webcluster.newsnow.co.uk:37684
| newsnow | Sleep | 9 | | |
| 1126334 | newsnow | db-2.webcluster.newsnow.co.uk:37687
| newsnow | Sleep | 5 | | |
| 1126337 | newsnow | db-2.webcluster.newsnow.co.uk:37689
| newsnow | Sleep | 4 | | |
| 1126343 | newsnow | simpson.webcluster.newsnow.co.uk:57405
| newsnow | Sleep | 1 | | |
| 1126371 | newsnow | db-2.webcluster.newsnow.co.uk:37758
| newsnow | Sleep | 7 | | |
| 1126421 | newsnow | db-2.webcluster.newsnow.co.uk:37901
| newsnow | Sleep | 6 | | |
| 1126550 | newsnow | db-2.webcluster.newsnow.co.uk:38203
| newsnow | Sleep | 11 | | |
| 1126565 | newsnow | db-2.webcluster.newsnow.co.uk:38255
| newsnow | Sleep | 2 | | |
| 1126700 | newsnow | simpson.webcluster.newsnow.co.uk:58435
| newsnow | Sleep | 7 | | |
| 1126716 | newsnow | simpson.webcluster.newsnow.co.uk:58497
| newsnow | Sleep | 1 | | |
| 1126737 | newsnow | simpson.webcluster.newsnow.co.uk:58565
| newsnow | Sleep | 1 | | |
| 1126764 | newsnow | simpson.webcluster.newsnow.co.uk:58627
| newsnow | Sleep | 12 | | |
| 1126902 | newsnow | king.webcluster.newsnow.co.uk:50100
| newsnow | Sleep | 5 | | |
| 1126935 | newsnow | simpson.webcluster.newsnow.co.uk:58970
| newsnow | Sleep | 7 | | |
| 1126971 | newsnow | king.webcluster.newsnow.co.uk:50239
| newsnow | Sleep | 7 | | |
| 1126975 | newsnow | king.webcluster.newsnow.co.uk:50257
| newsnow | Sleep | 3 | | |
| 1126976 | newsnow | king.webcluster.newsnow.co.uk:50258
| newsnow | Sleep | 9 | | |
| 1126992 | newsnow | king.webcluster.newsnow.co.uk:50285
| newsnow | Sleep | 6 | | |
| 1126993 | newsnow | king.webcluster.newsnow.co.uk:50288
| newsnow | Sleep | 4 | | |
| 1126995 | newsnow | king.webcluster.newsnow.co.uk:50294
| newsnow | Sleep | 7 | | |
| 1127001 | newsnow | king.webcluster.newsnow.co.uk:50303
| newsnow | Sleep | 9 | | |
| 1127003 | newsnow | king.webcluster.newsnow.co.uk:50308
| newsnow | Sleep | 3 | | |
| 1127004 | newsnow | king.webcluster.newsnow.co.uk:50311
| newsnow | Sleep | 2 | | |
| 1127006 | newsnow | king.webcluster.newsnow.co.uk:50316
| newsnow | Sleep | 0 | | |
| 1127035 | newsnow | simpson.webcluster.newsnow.co.uk:59151
| newsnow | Sleep | 3 | | |
| 1127039 | DELAYED | | newsnow | Delayed insert
| 20 | Waiting for INSERT | |
| 1127047 | newsnow | king.webcluster.newsnow.co.uk:50365
| newsnow | Sleep | 10 | | |
| 1127054 | newsnow | king.webcluster.newsnow.co.uk:50370
| newsnow | Sleep | 9 | | |
| 1127067 | newsnow | king.webcluster.newsnow.co.uk:50383
| newsnow | Sleep | 9 | | |
| 1127071 | newsnow | king.webcluster.newsnow.co.uk:50394
| newsnow | Sleep | 10 | | |
| 1127081 | newsnow | king.webcluster.newsnow.co.uk:50431
| newsnow | Sleep | 1 | | |
| 1127090 | newsnow | king.webcluster.newsnow.co.uk:50446
| newsnow | Sleep | 8 | | |
| 1127135 | newsnow | db-2.webcluster.newsnow.co.uk:39583
| newsnow | Connect | 305 | Reading from net
| |
| 1127136 | newsnow | king.webcluster.newsnow.co.uk:50559
| newsnow | Sleep | 5 | | |
| 1127154 | newsnow | king.webcluster.newsnow.co.uk:50586
| newsnow | Sleep | 9 | | |
| 1127156 | newsnow | king.webcluster.newsnow.co.uk:50592
| newsnow | Sleep | 3 | | |
| 1127163 | newsnow | king.webcluster.newsnow.co.uk:50599
| newsnow | Sleep | 4 | | |
| 1127166 | newsnow | king.webcluster.newsnow.co.uk:50612
| newsnow | Sleep | 7 | | |
| 1127167 | newsnow | king.webcluster.newsnow.co.uk:50633
| newsnow | Sleep | 4 | | |
| 1127168 | newsnow | king.webcluster.newsnow.co.uk:50634
| newsnow | Sleep | 6 | | |
| 1127173 | newsnow | king.webcluster.newsnow.co.uk:50639
| newsnow | Sleep | 2 | | |
| 1127225 | newsnow | king.webcluster.newsnow.co.uk:50650
| newsnow | Sleep | 9 | | |
| 1127235 | newsnow | king.webcluster.newsnow.co.uk:50654
| newsnow | Sleep | 3 | | |
| 1127236 | newsnow | king.webcluster.newsnow.co.uk:50655
| newsnow | Sleep | 1 | | |
| 1127277 | newsnow | king.webcluster.newsnow.co.uk:50727
| newsnow | Sleep | 8 | | |
| 1127278 | newsnow | king.webcluster.newsnow.co.uk:50732
| newsnow | Sleep | 9 | | |
| 1127288 | newsnow | king.webcluster.newsnow.co.uk:50752
| newsnow | Sleep | 1 | | |
| 1127296 | newsnow | king.webcluster.newsnow.co.uk:50767
| newsnow | Sleep | 4 | | |
| 1127306 | newsnow | king.webcluster.newsnow.co.uk:50772
| newsnow | Sleep | 7 | | |
| 1127309 | newsnow | king.webcluster.newsnow.co.uk:50776
| newsnow | Sleep | 6 | | |
| 1127312 | newsnow | king.webcluster.newsnow.co.uk:50783
| newsnow | Sleep | 10 | | |
| 1127323 | newsnow | king.webcluster.newsnow.co.uk:50801
| newsnow | Sleep | 1 | | |
| 1127326 | newsnow | king.webcluster.newsnow.co.uk:50805
| newsnow | Sleep | 5 | | |
| 1127346 | newsnow | king.webcluster.newsnow.co.uk:50817
| newsnow | Sleep | 6 | | |
| 1127348 | newsnow | king.webcluster.newsnow.co.uk:50824
| newsnow | Sleep | 7 | | |
| 1127353 | newsnow | king.webcluster.newsnow.co.uk:50840
| newsnow | Sleep | 2 | | |
| 1127362 | newsnow | king.webcluster.newsnow.co.uk:50855
| newsnow | Sleep | 2 | | |
| 1127380 | newsnow | king.webcluster.newsnow.co.uk:50888
| newsnow | Sleep | 7 | | |
| 1127392 | newsnow | simpson.webcluster.newsnow.co.uk:59642
| newsnow | Connect | 282 | Reading from net
| |
| 1127399 | newsnow | king.webcluster.newsnow.co.uk:50906
| newsnow | Sleep | 6 | | |
| 1127405 | newsnow | simpson.webcluster.newsnow.co.uk:59663
| newsnow | Sleep | 4 | | |
| 1127408 | newsnow | king.webcluster.newsnow.co.uk:50918
| newsnow | Sleep | 4 | | |
| 1127412 | newsnow | king.webcluster.newsnow.co.uk:50925
| newsnow | Sleep | 3 | | |
| 1127421 | newsnow | king.webcluster.newsnow.co.uk:50935
| newsnow | Sleep | 1 | | |
| 1127424 | newsnow | king.webcluster.newsnow.co.uk:50939
| newsnow | Sleep | 6 | | |
| 1127428 | newsnow | king.webcluster.newsnow.co.uk:50951
| newsnow | Sleep | 3 | | |
| 1127437 | newsnow | king.webcluster.newsnow.co.uk:50980
| newsnow | Sleep | 8 | | |
| 1127473 | newsnow | www-1.webcluster.newsnow.co.uk:35537
| newsnow | Query | 14 | User lock |
select get_lock('1 1 11',60) as L |
| 1127529 | newsnow | db-2.webcluster.newsnow.co.uk:40102
| newsnow | Sleep | 9 | | |
| 1127555 | newsnow | db-2.webcluster.newsnow.co.uk:40133
| newsnow | Sleep | 9 | | |
| 1127568 | newsnow | db-2.webcluster.newsnow.co.uk:40145
| newsnow | Sleep | 8 | | |
| 1127574 | newsnow | king.webcluster.newsnow.co.uk:51189
| newsnow | Sleep | 1 | | |
| 1127577 | newsnow | king.webcluster.newsnow.co.uk:51205
| newsnow | Sleep | 5 | | |
| 1127610 | newsnow | db-2.webcluster.newsnow.co.uk:40347
| newsnow | Sleep | 6 | | |
| 1127611 | newsnow | king.webcluster.newsnow.co.uk:51410
| newsnow | Sleep | 2 | | |
| 1127617 | newsnow | db-2.webcluster.newsnow.co.uk:40402
| newsnow | Sleep | 4 | | |
| 1127661 | newsnow | db-2.webcluster.newsnow.co.uk:40540
| newsnow | Sleep | 1 | | |
| 1127672 | newsnow | simpson.webcluster.newsnow.co.uk:60252
| newsnow | Sleep | 239 | | |
| 1127785 | newsnow | db-2.webcluster.newsnow.co.uk:40704
| newsnow | Sleep | 5 | | |
| 1127858 | newsnow | simpson.webcluster.newsnow.co.uk:60455
| newsnow | Sleep | 12 | | |
| 1127904 | newsnow | simpson.webcluster.newsnow.co.uk:60498
| newsnow | Sleep | 3 | | |
| 1127914 | newsnow | king.webcluster.newsnow.co.uk:51819
| newsnow | Sleep | 18 | | |
| 1127924 | newsnow | simpson.webcluster.newsnow.co.uk:60524
| newsnow | Sleep | 17 | | |
| 1127952 | newsnow | simpson.webcluster.newsnow.co.uk:60570
| newsnow | Sleep | 5 | | |
| 1127966 | newsnow | simpson.webcluster.newsnow.co.uk:60583
| newsnow | Sleep | 12 | | |
| 1128001 | newsnow | king.webcluster.newsnow.co.uk:51942
| newsnow | Sleep | 10 | | |
| 1128111 | newsnow | king.webcluster.newsnow.co.uk:52130
| newsnow | Sleep | 6 | | |
| 1128168 | newsnow | simpson.webcluster.newsnow.co.uk:60919
| newsnow | Sleep | 3 | | |
| 1128229 | newsnow | simpson.webcluster.newsnow.co.uk:32827
| newsnow | Sleep | 5 | | |
| 1128547 | newsnow | simpson.webcluster.newsnow.co.uk:33256
| newsnow | Sleep | 9 | | |
| 1128725 | newsnow | simpson.webcluster.newsnow.co.uk:33531
| newsnow | Sleep | 7 | | |
| 1128842 | newsnow | simpson.webcluster.newsnow.co.uk:33708
| newsnow | Sleep | 10 | | |
| 1128860 | newsnow | db-2.webcluster.newsnow.co.uk:42434
| newsnow | Sleep | 3 | | |
| 1128909 | newsnow | db-2.webcluster.newsnow.co.uk:42499
| newsnow | Sleep | 2 | | |
| 1128928 | newsnow | simpson.webcluster.newsnow.co.uk:33877
| newsnow | Sleep | 7 | | |
| 1128931 | newsnow | db-2.webcluster.newsnow.co.uk:42528
| newsnow | Sleep | 0 | | |
| 1128933 | newsnow | db-2.webcluster.newsnow.co.uk:42531
| newsnow | Sleep | 15 | | |
| 1129108 | newsnow | localhost | newsnow |
Sleep | 98 | | |
| 1129125 | newsnow | db-2.webcluster.newsnow.co.uk:42810
| newsnow | Sleep | 6 | | |
| 1129168 | newsnow | db-2.webcluster.newsnow.co.uk:42871
| newsnow | Sleep | 4 | | |
| 1129188 | newsnow | db-2.webcluster.newsnow.co.uk:42900
| newsnow | Sleep | 1 | | |
| 1129268 | champ | bush.newsnow.net:50422 | newsnow
| Sleep | 84 | | |
| 1129348 | newsnow | simpson.webcluster.newsnow.co.uk:34388
| newsnow | Sleep | 10 | | |
| 1129367 | newsnow | simpson.webcluster.newsnow.co.uk:34409
| newsnow | Sleep | 6 | | |
| 1129453 | newsnow | simpson.webcluster.newsnow.co.uk:34534
| newsnow | Sleep | 1 | | |
| 1129667 | newsnow |
backend-1.webcluster.newsnow.co.uk:38219 | newsnow | Sleep
| 40 | | |
| 1129719 | newsnow | www-2.webcluster.newsnow.co.uk:42926
| newsnow | Query | 24 | Locked | /*
NNDObjGen */ update NNDirectClientData set
ObjectID='6250',Val='20050907093814',Type='State',Tag |
| 1129726 | champ | monkees.newsnow.net:53908 |
newsnow | Query | 24 | Writing to net |
/* NNDObjSen */ select * from NNDirectClientData
where UserID in (18199,18198,18197,18196,18195,1819 |
| 1129746 | newsnow | www-1.webcluster.newsnow.co.uk:46047
| newsnow | Sleep | 35 | | |
| 1129787 | newsnow | www-2.webcluster.newsnow.co.uk:42953
| newsnow | Query | 24 | Locked | /*
NNDObjGen */ update NNDirectClientData set
ObjectID='5979',Val='20050907093815',Type='State',Tag |
| 1129790 | newsnow | www-2.webcluster.newsnow.co.uk:42955
| newsnow | Query | 21 | Locked | /*
NNDObjSen */ select * from NNDirectClientData where
UserID in (18199,18198,18197,18196,18195,1819 |
| 1129798 | champ | monkees.newsnow.net:53923 |
newsnow | Query | 24 | Locked | /*
NNDObjGen */ select * from NNDirectClientData where
UserID in (81, -1) and ObjectID in (365, -1)
|
| 1129800 | champ | monkees.newsnow.net:53925 |
newsnow | Sleep | 29 | | |
| 1129801 | champ | monkees.newsnow.net:53926 |
newsnow | Sleep | 0 | | |
| 1129822 | newsnow | www-2.webcluster.newsnow.co.uk:42972
| newsnow | Query | 24 | Locked | /*
NNDObjGen */ update NNDirectClientData set
ObjectID='5674',Val='20050907093815',Type='State',Tag |
| 1129823 | newsnow | db-2.webcluster.newsnow.co.uk:43730
| newsnow | Sleep | 3 | | |
| 1129832 | newsnow | www-2.webcluster.newsnow.co.uk:42981
| newsnow | Query | 24 | Locked | /*
NNDObjGen */ update NNDirectClientData set
ObjectID='5510',Val='20050907093813',Type='State',Tag |
| 1129842 | newsnow | www-2.webcluster.newsnow.co.uk:42989
| newsnow | Query | 24 | Locked | /*
NNDObjGen */ select count(*) as C from
NNDirectClientData where Type = 'State' and Tag =
'LastBui |
| 1129963 | newsnow | simpson.webcluster.newsnow.co.uk:35337
| newsnow | Sleep | 5 | | |
| 1129980 | newsnow | simpson.webcluster.newsnow.co.uk:35384
| newsnow | Sleep | 2 | | |
| 1129984 | newsnow | www-1.webcluster.newsnow.co.uk:46288
| newsnow | Query | 1 | Sending data |
/* Mut */ select * from Refs where (Site_FK=14355)
and URL in ('http://actu.wanadoo.fr/Article/mmd-- |
| 1129985 | newsnow | www-1.webcluster.newsnow.co.uk:46290
| newsnow | Query | 0 | Locked | /*
Mut */ insert into Refs(Text,LFDate,URL,Active,FDate,Site_FK)
values('Typhon Nabi: au moins 10 m |
| 1129986 | newsnow | pilger.webcluster.newsnow.co.uk:41628
| newsnow | Query | 0 | Locked | /*
Mut */ insert into Refs(Text,LFDate,URL,Active,FDate,Site_FK)
values('Weiter viel Sonne in Deuts |
| 1129992 | newsnow | pilger.webcluster.newsnow.co.uk:41633
| newsnow | Sleep | 1 | | |
| 1129993 | newsnow | localhost | | Query
| 0 | | show processlist |
+---------+----------+------------------------------------------+---------+----------------+-------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+
How-To-Repeat:
We're not sure at this point how to reproduce this problem.
Fix:
No fix identified.
Submitter-Id: <submitter ID>
Originator: Adam Newby <[EMAIL PROTECTED]>
Organization: NewsNow Publishing Ltd
MySQL support: none
Synopsis: Locks acquired with get_lock() persisting, even after MySQL
thread has exited
Severity: critical
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-4.1.11-Debian_4 (Source distribution)
C compiler: gcc (GCC) 3.3.6 (Debian 1:3.3.6-5)
C++ compiler: g++ (GCC) 3.3.6 (Debian 1:3.3.6-5)
Environment:
(Debian 3.0 'woody' distribution, with MySQL packages from current Debian 3.1
dist)
System: Linux craven 2.4.24dell-poweredge-2650 #1 SMP Tue Jan 6 13:09:17 GMT
2004 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc' CFLAGS='-DBIG_JOINS=1 -O3' CXX='g++'
CXXFLAGS='-DBIG_JOINS=1 -felide-constructors -fno-rtti -O3' LDFLAGS=''
ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Aug 4 10:21 /lib/libc.so.6 -> libc-2.3.2.so
-rwxr-xr-x 1 root root 1244688 May 10 21:01 /lib/libc-2.3.2.so
-rw-r--r-- 1 root root 2642066 May 10 21:01 /usr/lib/libc.a
-rwxr-xr-x 1 root root 204 May 10 20:53 /usr/lib/libc.so
Configure command: ./configure '--build=i386-linux' '--host=i386-linux'
'--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin'
'--datadir=/usr/share' '--sysconfdir=/etc/mysql'
'--localstatedir=/var/lib/mysql' '--includedir=/usr/include'
'--infodir=/usr/share/info' '--mandir=/usr/share/man'
'--with-server-suffix=-Debian_4' '--enable-shared' '--enable-static'
'--enable-thread-safe-client' '--enable-assembler' '--enable-local-infile'
'--with-raid' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock'
'--with-mysqld-user=mysql' '--with-libwrap' '--with-client-ldflags=-lstdc++'
'--with-vio' '--without-openssl' '--without-docs' '--without-bench'
'--without-readline' '--with-extra-charsets=all' '--with-berkeley-db'
'--with-innodb' '--with-isam' '--with-archive-storage-engine'
'--with-csv-storage-engine' '--without-embedded-server' '--with-ndbcluster'
'--with-ndb-shm' '--without-ndb-sci' '--without-ndb-test'
'--with-embedded-server' '--with-embedded-privilege-control' '--with-ndb-docs'
'CC=gcc' 'CFLAGS=-DBIG_JOINS=1 -O3' 'CXXFLAGS=-DBIG_JOINS=1
-felide-constructors -fno-rtti -O3' 'CXX=g++' 'build_alias=i386-linux'
'host_alias=i386-linux'
--
____________________________________
Adam Newby
Head of IT
NewsNow Publishing Limited
Tel: +44 (0)20 7471 0400
____________________________________
http://www.NewsNow.co.uk/
Online Media Monitoring
Receive fast updating news about
your company, competitors, industry,
products, clients & prospects
____________________________________
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]