John, The statistical filter is not terribly sensitive to individual counts so you can just ignore them. Welcome to the world of non-MVCC databases.
Cheers, Ken On Wed, Jun 11, 2008 at 04:01:04PM -0700, john espiro wrote: > One more thing... should I do anything with the errors in sql.errors, i.e. > re-run them? What happens if I don't? > > Thanks, > John > > > ----- Original Message ---- > From: john espiro <[EMAIL PROTECTED]> > To: [email protected] > Sent: Wednesday, June 11, 2008 3:58:29 PM > Subject: Lock wait timeout exceeded > > > Hello - > > I am running the following: > > CentOS 4.5 > MySQL 5.0.45 14.12 > dspam > > I get the following error randonmly throughout the day, but especially around > the time my cron daily job wraps up... Cron job is posted way below, and the > error is pasted here, snipped off due to the length of the data. > > Can anyone let me know what I should try to do to troubleshoot this? Is > there any other data I can provide? > > > Error: > > [06/11/2008 07:32:29] 18017: Lock wait timeout exceeded; try restarting > transaction: update dspam_token_data set last_hit = current_date(), spam_hits > = greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0) > where uid = 3 and token > in('4301950420733384838','8470769528426426573','4702753284075552768','9262019483354755276','15868778196753871051','9363122826218903147','11330574739319517388','5732484895227843917','17447635076284224467','7025702031337165437','55761 > > Cron.daily: > > # Optimize the table structure nightly > mysqlcheck -u$DBUSER -p$DBPASSWD -h$DBHOST -oA > > DBS=`mysql -u$DBUSER -p$DBPASSWD -h$DBHOST -e"show databases"` > > for DATABASE in $DBS > do > if [ $DATABASE != "Database" ]; then > echo "Dumping $DATABASE now..." > mysqldump -u$DBUSER -p$DBPASSWD -h$DBHOST --add-drop-table -e > $DATABASE > ${DATE}_${DATABASE}.sql > > > > > !DSPAM:1011,48511858150921766113094!
