PDA

View Full Version : Orion MySQL Down?


GaleForce
3-27-03, 01:38 PM
My forums just suddenly stopped working;

http://www.kotorpa.com/forum

Any ideas if the DB is down?

Starr
3-27-03, 03:03 PM
MySQL on Orion is not down:

orion# mysqladmin -p status
Enter password:
Uptime: 3987 Threads: 1 Questions: 64214 Slow queries: 0 Opens: 1188 Flush tables: 3 Open tables: 45 Queries per second avg: 16.106

HalfaBee
3-27-03, 05:28 PM
Thanks for restarting Mysql on orion.

It had been up for over 17 days, not bad at all.

HalfaBee

Server version: 4.0.12-log
Protocol version: 10
Connection: orion.powweb.com via TCP/IP
Client characterset: latin1
Server characterset: latin1
TCP port: 3306
Uptime: 3 hours 29 min 53 sec

GaleForce
3-27-03, 07:03 PM
So any idea why my forums just suddenly stopped working?

HalfaBee
3-27-03, 07:06 PM
I assume when mysql didn't crash that one of your tables was not closed properly.

You will have to do "REPAIR TABLE tablename" using phpmyadmin or if you have mysql_front use the tools->Table diagnostics functions.

HalfaBee