Can I limit ram usage in mySQL? Host says "no".

[digita1bob]

I just had my server shut down because my hosting company said I was using 350 to 450 megs of ram. This seems nuts to me as I'm only running a shopping cart with about 1000 items with only about 50 visitors per day.

Since they installed mysql on the server, I asked them why they hadn't configured it to work with the parameters of their system.

Their response: "Unfortunately, there is no way to limit the RAM usage for mySQL. I apologize for the inconvenience this may cause however there is no way to do this."

Do they know what they are talking about???

Thanks in advance for any help,

Bob

 

[digita1bob]

Sorry, I probably should have mentioned that it's a Linux server running Apache.

Bob