I also have the same problem upgrading from 4.1.15 to 5.0.15; this query
hang mysql:
INSERT DELAYED INTO phpads_adstats SET clicks = 0, views = 1, day =
NOW(), hour = HOUR(NOW()), bannerid = '97', zoneid = '15', source = ''
This is happening with every linux mysql 5.0.15 binary distribuition
>Description:
I have a 1M hit a day web server that logs ad hits to mysql. Always
been solid as a rock. Most recently on mysql 4.1.14. We upgraded
our backup servers to 5.0.15, no problem. We upgraded the live
server and the mysqld crashes about once a second.