Max connections on Freebsd

2001-04-29 Thread Patric de Waha Lists 

Hi,
Is there someone who incremented the max_connection
value to something above 100 (200) (300) on Freebsd 4.2?

I had problems with mysql on freebsd 4.0, hooked up
after some days without any good reason :). 
Some people told me thread libraries on freebsd 4.0
suck a bit. So I wonder if 4.2's thread libraries 
are stable enough to handle 200 concurrent threads?!.

Thanks in advance

Regards,
Patric de Waha


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Strange connect (socket) problem

2001-04-26 Thread Patric de Waha Lists 

HI,
Try this

  ?
$host = localhost:/var/mysql/mysql.sock; // focus here
$user = webrings;
$password = XXX;
$link = MYSQL_CONNECT($host,$user,$password);
if ($link == 0) {
  echo Can't connect to MySQL.;
  exit;
} else {
  echo Connection established.;
  exit;
}
  ?

regs, pdw


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL CRASHED after some days with this message in errlog:

2001-04-23 Thread Patric de Waha Lists 

Hi,
Mysql ran for 6 days.. It is a website
with heavy traffic.

/usr/libexec/ld-elf.so.1: /usr/local/libexec/mysqld: Undefined symbol
strtoull
010423 23:18:08  mysqld restarted
/usr/local/libexec/mysqld: ready for connections

What is this function about?

What feature shouldn't I use to avoid this problem?

Thanks in advance

Regards,
Patric de Waha


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Mysql makes connection to mysql.com WASSUP?

2001-03-27 Thread Patric de waha 

Hi,
I entered netstat and saw among other conections
this one:

tcp4 0 0 deepthroat.3179 web.mysql.com.auth TIME_WAIT

Deepthroat is my bsd machine. it's a pure webserver.
Why is my machine making a connection to mysql.com?(and why auth)

Mysql is not bound to a tcp socket.. (skip-networking).

Thanks in advance, pdw

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Mysql makes connection to mysql.com WASSUP?

2001-03-26 Thread Patric de waha 

Hi,
I entered netstat and saw among other conections
this one:

tcp4 0 0 deepthroat.3179 web.mysql.com.auth TIME_WAIT

Deepthroat is my bsd machine. it's a pure webserver.
Why is my machine making a connection to mysql.com?(and why auth)

Mysql is not bound to a tcp socket.. (skip-networking).

Thanks in advance, pdw

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php