Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version Current

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Problem

When trimming performance data from your MySQL DataStore, you may experience the following error:

mysql> delete from performance_psinfo where sample_id<14307634; ERROR 1206 (HY000): The total number of locks exceeds the lock table size

Solution

This error can generally be resolved with one of the following methods: Image Removed

  • Stop the Uptime Infrastructure Monitor core before running the queries.

...

  • Increase the innodb_buffer_pool_size variable in the /<uptime dir>/mysql/my.ini file.