downtime today

[Uncle Jesse]

Sorry folks, had some corruption in one of our mysql databases.

Thanks to everyone who called and emailed me... I fixed it as soon as I could.

Dave

[Husker]

I think I am going to get a few cron jobs running (cron is unix's program that runs tasks at scheduled times). I know of a few things in the DB which are 'fragile'. The sessions table is one of them. I think I will simply get a cron task going that simply does a repair of this table, and then run it every 30 minutes. Are there any other sysadmin's or DBadmins that would know if this is something that would cause other 'bad' side effects. We use MYSQL, and I would simply be doing a REPAIR phpbb3_sessions from the command line mysql. There may also be a few other things that I do, as we get ready for the onslaught of Tim/Tickle, but that sessions DB getting corrupted is one problem I know happens often.

The sessions table gets hit for EVERY site access. It is how phpbb tracks 'YOUR' connections, so it knows how to build pages. Your browser keeps a cookie, which is a key into the session DB, and then that DB is used in almost all querys against the database, to build pages, ties in that sessions DB.

I would have fixed this easily when tater voice called me, but I was having to leave, to take the new dogs to obedience school. But once (if) we can get this to be repaired on a schedule, then it should not need any interaction. It can still get corrupted, but will be 'fixed' within a very short time.

H.