Help: MySQL Shuts Down

2001-03-29 Thread Jim Bayers
Thanks in advance. I've been having problems with the mysql server shutting down. It shows no, or few, processes with 'mysqladmin -p processlist'. Once it has shut down, I can't restart it. Sometimes it does this at the slowest time of the night. I'm using it for the backend of a website. T

MySQL Server Crash. Where to Start?

2001-03-10 Thread Jim Bayers
I have a busy website that uses mysql. It crashed this morning. I don't know where to begin to fix it. I did notice in my httpd-error.log that I've been getting a bunch of errors: DBI::db=HASH(0x8101d68)->disconnect invalidates 1 active statement handle (either destroy statement handles or cal

Optimizing Queries

2001-02-19 Thread Jim Bayers
I have a non-profit site that uses mysql. I need to optimize two queries so they won't put such a load on the mysql server. If I don't lighten the load, they've treatened to kick us off. What columns are best to index? SELECT messages.ID as ID, title, text, user_id, username, email FRO