> -----Origineel Bericht-----
> Van: John Guin <[EMAIL PROTECTED]>
> Verstuur: Thursday, 17. January 2008 01:02
> Naar: [email protected]
> Onderwerp: [dspam-users] Possible MySQL corruption
>
> 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
>
Try adding indexes as explained:
http://www.howtoforge.com/optimizing_dspam_mysql4.1
Additionally, try cleaning your database occassionally to get rid of stale
data. If that doesn't help either, try converting to InnoDB (in our case, this
helped a lot).
Also, p7zip is an archiver which treats all files like binary. It does not know
anything about SQL: if mysqldump succeeds, there's nothing wrong with your
database. Moreover, p7zip is known to hang on large files, especially with
"Ultra settings". It is not a reference for bad data.
Cheers,
--
Jelle Hillen
Cats & Dogs bvba
Industrieweg 1506
B-3540 HERK-DE-STAD
Tel: +32 13 539110
Fax: +32 13 539111
Email: [EMAIL PROTECTED]
Website: http://www.catsanddogs.com/
** Visit our new webshop http://www.electromarket.be/, with more than 10000
products in stock !! **
