From: Ciro I. <cy...@gm...> - 2007-01-26 02:21:31
|
2007/1/22, Florian Gleixner <fl...@bi...>: > Hi, > > the --no_transactions switch was made for people that have no innodb > table type. You can try. If you disable inserts, transactions are not > needed. If you did not cleanup your tables for a long time (or never) i > would set the deletion policies only for one host, run a purge, add > another host, run purge ... > If you cannot clean a host at once try to make your delete policy longer > (100 days or more) first. I had these problems first too, but since i > clean every hour, problems are gone. > > Flo Ok, got it running with --no_transactions, but it has been running for 3 days!!, this can't be right.... The DB runs on Xeon servers (HP Proliant), maybe there's a place to tweak the process?, maybe mysql?, it's going, and going, and going, and going..... |