Page tree

Versions Compared


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

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

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

  • Stop the up.time the Uptime Infrastructure Monitor core before running the queries.
  • Increase the innodb_buffer_pool_size variable in the /<uptime dir>/mysql/my.ini file.