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 |