Interspire Product Knowledge Base

Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Add to favorites Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Export to PDF

User Opinions (4 votes)

100% thumbs up 0% thumbs down

How would you rate this answer?



Thank you for rating this answer.

Email Marketer tells me my contact list has been deleted successfully, but it is still there. What's going on?

This is happening because during the DELETE query, your MySQL server fails with the following error: "The total number of locks exceeds the lock table size".

With this error, MySQL is trying to tell you that it doesn't have enough memory to store all of the row locks that it would need in order to execute the DELETE query. This is usually affecting databases storing a larger amount of contacts and is caused by an improper database configuration and more specifically - an insufficient innodb_buffer_pool_size value.

The innodb_buffer_pool_size value tells MySQL how much memory it should use to cache data on your InnoDB tables (InnoDB is the database engine that Email Marketer uses for all of its tables). By default, this is set to only 8MB, which is too small for any regular database usage.

For optimal performance, it is recommended that this value is set to 10% larger than the size of your database, assuming that your server has enough physical memory available.

To be able to delete your contact lists again, increase your innodb_buffer_pool_size from your MySQL configuration file (my.cnf) and restart the MySQL service.

Related Articles

No related articles were found.

Attachments

No attachments were found.

Powered by Interspire Knowledge Manager - World's #1 Best Selling FAQ and Knowledge Base Software