Help with MySQL crashing every couple days

[cjolly3053]

So I have something that is causing MySQL to max out and crash either MySQL or the machine it's on. I have been having to either reboot the machine every couple days or reboot and restore a backup of the cacti database.

I would like to just find out a way that I could find out exactly what was causing the issue. I have tried watching the machine but really can't catch what is causing the issue. Guess it could be a loop of some kind. I have included a screen shot of my graphs showing the rampup and crash of the MySQL server.

Anybody have any ideas? I guess I could just start killing graphs and/or data sources but would like to troubleshoot this to know more what is going on.


General Information
Date Tue, 10 Apr 2012 13:24:49 -0500
Cacti Version 0.8.7i
Cacti OS win32
SNMP Version NET-SNMP version: 5.6.1.1
RRDTool Version RRDTool 1.2.x
Hosts 31
Graphs 58
Data Sources Script/Command: 41
SNMP: 2
SNMP Query: 9
Total: 52

Poller Information
Interval 300
Type cmd.php
Items Action[0]: 20
Action[1]: 41
Total: 61
Concurrent Processes 2
Max Threads 2
PHP Servers 1
Script Timeout 25
Max OID 10
Last Run Statistics Time:11.0338 Method:cmd.php Processes:2 Threads:N/A Hosts:32 HostsPerProcess:16 DataSources:61 RRDsProcessed:51

PHP Information
PHP Version 5.2.14
PHP OS WINNT
PHP uname Windows NT 6.1 build 7601
PHP SNMP Installed
max_execution_time 300
memory_limit 128M

[BSOD2600]

Shall I guess your MySQL version?

Tried the latest mysql version? Cacti 0.8.7i does with with the latest php 5.3.x and MySQL 5.5.x.

[cjolly3053]

Yup running MySQL 5.5, Win 7, IIS7.

Attempted updating PHP but had an issue so had to roll it back till I can try again.

[BSOD2600]

Have you reported the MySQL crash to the mysql bug tracker? Running the latest 5.5.x release?

with php 5.3.x, you no longer need the old-password setting in my.ini. In fact, you must remove it along with re-setting the mysql cactiuser password (just follow the cacti install docs again for those command lines).