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.