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 fo
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 dat
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
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 possib
