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
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
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