How to limit usage of mysql server's memory/cpu for each databases ?

#1 (**permalink**) 02-28-2008, 06:20 AM

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 )
?

#2 (**permalink**) 02-28-2008, 06:20 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode