I did a search but couldn't find anything on this.
Is there a way to tell mySQL not to go above a certain amount of RAM? Our host doesn't set a hard limit and will charge if we go over. I'd like to prevent that from happening if possible. We have external applications connecting to our database which creates persistant connections (they need to stay connected for constant data transfer). At any given time we can have over 100! But they're just sitting there inbetween updates (roughly 15 seconds). So they eat up over 3GB of ram.
Any help would be appreciated, thanks. 🙂