Re: DB error in prewikka when deleting records
Yoann Vandoorselaere <[email protected]>
| Newsgroups | gmane.comp.security.ids.prelude.user |
|---|---|
| Message-ID | <[email protected]> |
Hi, Le mercredi 15 octobre 2008 à 22:39 -0500, adjete wilson a écrit : > Whenever I tried to delete recors as low as 50, I get the error. According > to my research, It has to do with a mysql variable size. Any ideas how I can > fix this, or determine where the bottleneck is? Thanks in advance. > Prewikka internal error > *The total number of locks exceeds the lock table size* Increasing the innodb_buffer_pool_size setting in my.cnf should fixes this problem. For good performance, and on a dedicated database server, make sure that the value for this setting amount to 80% of your system memory. Regards, -- Yoann Vandoorselaere | Responsable R&D / CTO | PreludeIDS Technologies Tel: +33 (0)9 50 70 21 58 Fax: +33(0)9 57 25 21 58 http://www.prelude-ids.com _______________________________________________ Prelude-user site list [email protected] http://lists.prelude-ids.org/mailman/listinfo/prelude-user