[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Lots of users!
From:       Mark Matthews <mark () mysql ! com>
Date:       2003-04-30 19:36:12
[Download RAW message or body]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Fagyal, Csongor wrote:

[snip]
>> Hmm...have you looked at http://www.mysql.com/doc/en/User_resources.html
>> as well as the option 'MAX_JOIN_SIZE' (see
>> http://www.mysql.com/doc/en/SET_OPTION.html) which will get you at least
>> #1 and #2.
>>
>>
[snip]
> - MAX_JOIN_SIZE is not per user - also not only a join can be
> problematic, but a BIIIG query as well

How do you mean, per-user? Do you want different settings per user?
If so, then no, MAX_JOIN_SIZE is not per-user.

Actually, MAX_JOIN_SIZE is perhaps a bit mis-named...It will limit
SELECTS that examine a lot of rows as well, not just the number of
tables joined.

	-Mark

- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma

    __  ___     ___ ____  __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <mark@mysql.com>
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
        <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+sCWstvXNTca6JD8RAlu7AJ4w2sbpieKAfGU5oCOsn7J6G/c5UgCgkOaM
Bmk+dvSqJ2oauGPJtH465MM=
=FKS0
-----END PGP SIGNATURE-----


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]