View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 07:20 AM
B. Keith Murphy
 
Posts: n/a
Default Re: How to limit usage of mysql server's memory/cpu for each databases?

Halid Faith wrote:
> I use mysql4.1.22, php4.4.6 and apache2.0.59.
> I want to put an quota for each databases and mysql users. How can I
> do that
> mysql will limit each database's memory usage? Because some mysql users
> sometimes use much memory while doing a sql query.
> Also How can I put an quota for each databases as data size ( like 1
> Mbyte )
> ?
>
>
>
>

Halid,

I don't think there is any way to do this from within MySQL. If you
were ambitious you could implement the datasize quota with some type of
script.

Hope that helps.

Keith
Reply With Quote