Story from my host is SQL queries are killing services for memory

[SeanShepardWI]

So at least once a day when i do something like login to admin or do a test order my web server goes down. Often several services go with it. If I'm lucky, SSH is still up and I can restart these services otherwise it requires a manual reboot.

 

I'm on a VPS

 

I'm host a total of 2 websites, both with 0 traffic outside of me (we arent yet live)

 

I'm using like .1% of CPU

 

Is it realistic that my host is telling me that its normal that my SQL queries are killign services because of the huge memory spike? I have like a tiny database, only 2 clients.

[simplybe]

Your db should not be causing that unless you have very little memory to start with.

 

Login to ssh and view top while you are loading the admin page see what happens to the memory & cpu.

 

Tweak /etc/my.cnf to suit your setup

install mytop to see what is happening with mysql.

 

http://jeremy.zawodny.com/mysql/mytop/

 

Really hard to help without seeing the server or knowing the specs.

[tweaked]

There is allot you can do to tweak apache and mysql on server and VPS with little memory. Being a VPS, you should have access to root to take care of the configs. If no one has optimized your VPS then it is not surprising to hear of your predicament.

 

OpenVS, for example, has no drive cache, so once you run out of memory, that's it.

 

Well I assume you have apache and mysql but the same goes for any webserver and database server.

 

How much Ram is allotted to your VPS?

[bear]

Something more has to be wrong here. I'm running mine on a bog standard mysql configuration (with loads more than 2 accounts in WHMCS) on a VPS and it has no problem keeping up. I do have a lot of alloted RAM, but that shouldn't matter all that much.

 

This is interesting: "I'm using like .1% of CPU"

If this was your VPS and mysql crashing services, it seems to me loads would be high because of iowait issues. What are the specs, and can you list the top output including the top section?

[othellotech]

Is it realistic that my host is telling me that its normal that my SQL queries are killign services because of the huge memory spike?

 

Sounds like bull to me - we have loads of clients running WHMCS from our VPS services, and whilsta *few* have had to upgrade RAM due to the size of their DB's its not that common if the VS is setup right.

 

Sounds more like a combination of your host overselling and the VPS technology you're using being inappropriate.