Pada 23 Jul 2002 15:40:17 +0200
Andrea Carpani <[EMAIL PROTECTED]> menulis :
> error: 'Can't create a new thread (errno 11). If you are not out of
> available memory, you can consult the manual for a possible OS-dependent
> bug'
well, if this the case
try to run : mysqladmin -p processlist
On Tue, 2002-07-23 at 12:28, Dicky Wahyu Purnomo wrote:
> I think the proper word for your case is "mysql busy" not "hang".
> you should check from your system (OS) side the cpu usage of mysql
> where the query is running
When the problem arises both cpu's (client and server) are 2% busy and
th
On Tue, 2002-07-23 at 15:27, Gerald Clark wrote:
> 20 simultaneous cartesian products on large tables would be expected to make
> any sql server busy, not to mention use a lot of temporary disk space.
> Are you sure you are not running out of disk space?
No, there's enough disk space and memory
20 simultaneous cartesian products on large tables would be expected to make
any sql server busy, not to mention use a lot of temporary disk space.
Are you sure you are not running out of disk space?
Andrea Carpani wrote:
>Here's my problem:
>
>I've just installed mysql version 3.23.51 (before
Pada 23 Jul 2002 12:11:18 +0200
Andrea Carpani <[EMAIL PROTECTED]> menulis :
> "select * FROM $table1 s,$table2 t"
>
> where the two tables are choosen randomly (some of the tables are quite
> big), then repeats this with another (not cached) connection. The script
> runs on another machine. If
