I'm having issues with my host over my MySQL database, in particular a table that records my site members which has over 85000 records.
These are the two queries that my host had problems with:
select count(id) from table where status != 'pending'
select name, points from table order by points desc limit 7
id - autoincrement field, int 7
name - varchar 32
points - int 5
Apparently, each of these query manage to crash the MySQL server at some point and the tech guy resorted to renaming the table so that the queries failed, resulting in massive MySQL errors on my site.
Can someone advise me if there's any way I can prevent these two queries from crashing the servers and for future queries as well? I can't seem to simplify the queries any further.