> Can you check with mysqladmin proc in which state were connections
> after shutdown ??
mark@localhost:/usr/local/mysql/bin > mysqladmin -uroot -psql proc
+----+------+-----------+----------+---------+------+-------+---------------
---+
| Id | User | Host | db | Command | Time | State | Info
|
+----+------+-----------+----------+---------+------+-------+---------------
---+
| 1 | root | localhost | database | Sleep | 4638 | |
|
| 2 | root | localhost | database | Sleep | 4632 | |
|
| 3 | root | localhost | database | Sleep | 4630 | |
|
| 12 | root | localhost | | Query | 0 | | show
processlist |
+----+------+-----------+----------+---------+------+-------+---------------
---+
mark@localhost:/usr/local/mysql/bin > mysqladmin -uroot -psql shutdown
mark@localhost:/usr/local/mysql/bin > mysqladmin -uroot -psql proc
+----+------+-----------+----------+---------+------+-------+---------------
---+
| Id | User | Host | db | Command | Time | State | Info
|
+----+------+-----------+----------+---------+------+-------+---------------
---+
| 1 | root | localhost | database | Sleep | 4650 | |
|
| 2 | root | localhost | database | Sleep | 4644 | |
|
| 3 | root | localhost | database | Sleep | 4642 | |
|
| 14 | root | localhost | | Query | 0 | | show
processlist |
+----+------+-----------+----------+---------+------+-------+---------------
---+
I tried waiting for a couple of minutes and did it again, still no joy, the
only difference was the time columns had increased and the id for the query
was different.
> I know that older Darwin versions did not require any thread libs, but
> may be this one does ??
>
> Can you check it out with http://www.prnet.de/RegEx/mysql.html ??
That page reports it compiles fine without any threads libs. I've seen a
couple of tutorials about making mySQL under Mac OS X and they've all said
pthreads for Mac OS X Server only (OS X Server is a bit different from Mac
OS X, eventually they'll merge).
I've asked the author of the page you mentioned for confirmation and will
let you know what he says.
Mark
---------------------------------------------------------------------
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
