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 Uptime Infrastructure Monitor core before running the queries.
  • Increase the innodb_buffer_pool_size variable in the /<uptime dir>/mysql/my.ini file.