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

2007-05-06 Thread B. Keith Murphy
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

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

2007-05-05 Thread Halid Faith
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

LIMIT usage

2001-02-26 Thread Joseph Bueno
Hi, I currently use a SELECT that looks like: SELECT field FROM some_table WHERE some_condition ORDER BY some_date DESC LIMIT 2000 in order to get the most recent records from some_table. Since it is not possible (yet) to optimise an ORDER BY ... DESC by using an index; is it

Re: LIMIT usage

2001-02-26 Thread Jeremy D. Zawodny
On Mon, Feb 26, 2001 at 06:19:46PM +0100, Joseph Bueno wrote: Hi, I currently use a SELECT that looks like: SELECT field FROM some_table WHERE some_condition ORDER BY some_date DESC LIMIT 2000 in order to get the most recent records from some_table. Since it is not