Mysql tables crashing... over and over

[TheHiveMind]

So we have tables, that are always changing, and never backed up..

Yes it sucks, but thats life.

If these tables crash, like they have been doing recently, then it makes my life near impossible to put things right again. They have crashed 3 times since yesterday.

People seem to think its one of my report programs I implemented a few days ago. The program accesses the tables via lots of selects, but it doesn't modify them at all. The program is very intensive, and takes about 30 - 45 mins to run at a time. It runs 3 times a day. We have turned it off temporarily, but I'm just not convinced that its the problem..

Everytime the tables crash I ISAMcheck the tables and repair them.

We also had a few black outs yesterday, but the server is on UPS.

Could large amounts of selects and activity cause corruption? I mean.. thats what a db is for lol, so Im very sceptical

 

[.Froot.]

I doubt it. The only way to really crash a database in such a manner is to overload the computer. But I'm assuming that your pc is still fine, so it can't be overloaded. I reckon you should try reinstalling mysql and only install the bare minimum that you need for functionality.

 

[koffiejunkie]

how long does the query take to execute? Does it use joins? Does it lock the tables? PM me if you want help without posting sensetive stuff

 

[Murmaider]

Try putting some indexes on your tables, it will probably reduce the amount of time the queries take to run and the overhead.

 

[icyrus]

If the server is staying up and not quitting abruptly and you are still having tables crashing then you may well have hardware problems.