From my hosting company:
The interesting thing is, it's the only database table this is happening to, none of your other ones have shown the same problem in the logs.
However there are times when I run mysqlcheck I get Failed to Connect. And I have a daily script
for db in "show databases (returns 10)" (pseudo code)
do
mysqlcheck db
done
I get several lines on different DBs: "warning 3 clients are using or haven't closed the table properly"
even on a db/table that is not in use. It makes me wonder if another user/hacker is over connecting. My problem with checking for that is all users are "jailed" so I can't do top,ps,who,etc. Which doesn't mean some 14 yo russian kid isn't scanning my DB's for data or that another user has a webpage w DB that's hammering the L out of things. Also when I pull up a given webpage, uses mysql, and get "Woops. Can't connect". So I reload the page and it works.
Anything/argument/direction I can give my hosting company?
Thanks
cal
Bookmarks