Products
Webtrends Analytics 8.1x
Webtrends Analytics 8.0x
Webtrends Enterprise 7.x
Webtrends Professional 7.x
Webtrends Small Business 7.x
Issue
The MySQL database consumes an unexpectedly large amount of the CPU utilization.
Resolution
This issue is likely due to corruption in the database or excessively large table sizes.
Due to the frequency of updates and the potential for large status and monitoring tables, MySQL may be using considerable resources to make these updates, from which delays may occur that exceed the time allotted to this process prior to the next insertion. This situation will create multiple MySQL process threads which can consume high volumes of the CPU’s resources and may cause errors during analysis or deplete the remaining available resources used for analysis.
To determine if the size of the MySQL database tables is the cause navigate to the following location:
Webtrends\common\databases\mysql\data\
Look in the wt_sched and wtmaster database directories for tables which are near or larger than 10MB. If the tables exceeding this size can be safely truncated, do so. Always remember to back up a database prior to making any destructive changes.