mysqld got signal 11; (CRASH max-3.23.51) What do I need to do to clean up?

2003-03-21 Thread Joe Smith
Had my first mysqld crash today after a solid 4 month uptime.The details are below. The DB restarted, and I haven't been able to detect any corruption. Is there anything I should be running to ensure the integrity of the Innodb databases? Running: mysql-max-3.23.51, Innodb databases, Dual I

Innodb querry optimizer suddenly making TERRIBLE choices? Urgent, Please help!

2002-12-22 Thread Joe Smith
I'm in a bit of a tough spot -- My innodb table of WebActionLogs (which has 1 million rows spread out over the last year and a half) has suddenly stopped using 'TimeInitiated' to select only the last 24 hours of data (usually less than 7,500 rows), and now wants to copy all 1 million rows to a te