michael.monnerie at is
Sep 27, 2009, 9:49 AM
Post #2 of 2
(185 views)
Permalink
|
On Sonntag 27 September 2009 Casper Langemeijer wrote:
> dbmysql.c,db_query(+290): [.The total number of locks exceeds the lock
> table size] [.DELETE FROM dbmail_physmessage WHERE id NOT IN (SELECT
> physmessage_id FROM dbmail_messages)]
> Warning: could not delete orphaned physmessages. Check log.
>
> I'm using dbmail 2.2.10
>
> I think this happens because dbmail-util tries to remove all 156629
> physmessages in a single statement, therefore all other threads have
> to wait until this query is finished. Also I'm guessing that this
> http://www.mail-archive.com/dbmail[at]dbmail.org/msg15575.html bug
> report by Michael Monnerie led to the current situation.
>
> Because I needed to fix this I built my own php script. It basically
> works like this:
>
> SELECT id FROM dbmail_physmessage WHERE id NOT IN (SELECT
> physmessage_id FROM dbmail_messages)
>
> per 100 id's (per id would be way too slow. I found 100 to be a good
> number of records):
That was the behaviour from earlier releases (or was it a single delete
per ID?). The change was done because a single transaction normally is
much faster in the db server.
But I think you're going the wrong way: It should not happen that you
get this message:
The total number of locks exceeds the lock table size
I've googled, and found this:
http://bugs.mysql.com/bug.php?id=15667
Recommendation by Valeriy Kravchuk
Please, increase your innodb_buffer_pool_size ten times at least if you
have a default size.
and later:
So, this is not a bug. You should just set server variables properly.
mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
|
