--- Caffeinate The World <mochaexpress@yahoo.com> wrote:
> I didn't explicitly define --with-innodb so I've not tested that
> portion.

I recompiled MySQL-4.0.12 with --with-innodb and it seems to work fine
with the exception of "mysqladmin shutdown" not shutting down the
server.

> > This PR seems to have problems with termination.  I also have had
> > difficulty connecting via mysqladmin.  This was with version
> 3.23.53
> > (not 4.xx).

Connecting with mysqladmin seems to work fine. Below is my verification
that it was compiled with native pthread and some mysqladmin tests.

# ldd libexec/mysqld
libexec/mysqld:
         -lwrap.0 => /usr/lib/libwrap.so.0
         -lpthread.0 => /usr/lib/libpthread.so.0
         -lz.0 => /usr/lib/libz.so.0
         -lcrypt.0 => /usr/lib/libcrypt.so.0
         -lstdc++.4 => /usr/lib/libstdc++.so.4
         -lm.0 => /usr/lib/libm.so.0
         -lc.12 => /usr/lib/libc.so.12

# ./mysqld_safe&
# Starting mysqld daemon with databases from /var/mysql

# ps axj | grep mysql
mysql   16923 22200 22200 269380    1 Sa   p1   0:00.56
/usr/local_install/mysql-4.0.12/libexec/mysqld --basedir=/usr/local_
root    18800 20911  2071 269380    2 R+   p1   0:00.01 grep mysql
root    22200 20911 22200 269380    1 S    p1   0:00.02 /bin/sh
./mysqld_safe

# ps axj | grep mysql
mysql   16923 22200 22200 269380    1 Sa   p1   0:00.56
/usr/local_install/mysql-4.0.12/libexec/mysqld --basedir=/usr/local_
root    18800 20911  2071 269380    2 R+   p1   0:00.01 grep mysql
root    22200 20911 22200 269380    1 S    p1   0:00.02 /bin/sh
./mysqld_safe
# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.12-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select version();
+------------+
| version()  |
+------------+
| 4.0.12-log |
+------------+
1 row in set (0.01 sec)

mysql> show databases;
+------------+
| Database   |
+------------+
| mysql      |
| randtest   |
| realestate |
| test       |
| testdb     |
| transition |
+------------+
6 rows in set (0.01 sec)

# ./mysqladmin -p ping
Enter password:
mysqld is alive

# ./mysqladmin -p refresh
Enter password:

# ./mysqladmin -p shutdown
Enter password:
>>>DOESN'T WORK!!! HANGS
CTRL-C to break out
Warning;  Aborted waiting on pid file: '/var/mysql/ns01.pid' after 49
seconds




__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com