I am getting errors from time to time (about once a day) in the sql.errors log:
23862: Deadlock found when trying to get lock; try restarting
transaction: insert into dspam_token_data(uid, token, spam_hits, innocent_hits,
last_hit) values
Additionally, if I manually dump the sql database and then run:
7za a -t7z -m0=lzma -mx=9 -mfb=64 -md=32m -ms=on 2e2l2.7z dspamNOW.sql
I get:
7-Zip (A) 4.57 Copyright (c) 1999-2007 Igor Pavlov 2007-12-06
p7zip Version 4.57 (locale=C,Utf16=off,HugeFiles=on,4 CPUs)
Scanning
Creating archive 2e2l2.7z
Compressing dspamNOW.sql [EMAIL PROTECTED] ]#
It just hangs up at about 5%.
I also note that my mysql process is taking up about 70% of
the processor which seems really high to me.
Can anyone help suggest a path I may follow to see what the problem is?
I am running the latest version of dspam on CentOS 4.
John
Never miss a thing. Make Yahoo your homepage.
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
