article Errors when trying to delete performance data

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

Related Articles


Limited Performance Data Available

RatingViews
article

By: uptime Support | Date Created: 6-15-2006 | Last Modified: 1-16-2013 | Index: 082

  9599

SQL Server DataStore historical data purge script

RatingViews
article

This script will purge old data from your SQL Server DataStore

By: uptime Support | Date Created: 8-12-2010 | Last Modified: 6-8-2011 | Index: 476

  4568

Performance Monitor error: limited performance data available

RatingViews
article

This error is normally a result of the CPU time interval within the performance monitor being shorter than the data collection rate of the associated agents performance data collector. More...

By: uptime Support | Date Created: 12-31-1969 | Last Modified: 8-31-2011 | Index: 289

  4653

Windows Agent Perflib Errors

RatingViews
article

By: uptime Support | Date Created: 10-17-2005 | Last Modified: 7-11-2011 | Index: 014

  13051

What happens to performance data and monitoring if up.time is off...

RatingViews
article

If the up.time data collector (core) or the up.time data store is stopped all service monitoring and data collection will stop. up.time works on a polling architecture, the agents never store data...

By: uptime Support | Date Created: 10-8-2009 | Last Modified: 8-10-2011 | Index: 400

  1776

User Comments



No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement