Hello I've just compiled mysql-3.23.32 (tar.gz) with with the bdb tgz (from mysql.com) on my linuxppc machine (powermac 9600/300mhz, kernel 2.2.17 , glibc 2.1.3, gcc-2.95.3). configure --with-charset=german1 --with-extra-charsets=latin1 --with-berkeley-db I find the following problems: (1. I didn't find out how to correctly set up mysql.server to run mysql as 'mysql' user instead of root, where has the mysql_user setting gone?) 2. long delay on startup of mysql server (there must be some dns lookup or the like) 3. BDB tables are extremely slow in the first simple tests (0.2 to 2.5 seconds per query). MyIsam tables are fast as usual (0.01 secs) 4. BDB table contents show up corrupted when selected with a 'where' clause. At least, BEGIN/COMMIT/ROLLBACK work. Here's what happens in my test: mysql> create table bdbtest (a int not null primary key, b text) type=bdb; Query OK, 0 rows affected (4.04 sec) mysql> insert into bdbtest values(0,"Miau"); Query OK, 1 row affected (1.58 sec) mysql> insert into bdbtest values(1,"Cat"); Query OK, 1 row affected (0.37 sec) mysql> select * from bdbtest; +---+------+ | a | b | +---+------+ | 0 | Miau | | 1 | Cat | +---+------+ 2 rows in set (0.32 sec) mysql> select * from bdbtest where a=1; +---+------+ | a | b | +---+------+ | 1 | à | +---+------+ 1 row in set (0.18 sec) mysql> select * from bdbtest where a=0; +---+------+ | a | b | +---+------+ | 0 | À | +---+------+ 1 row in set (0.18 sec) mysql> Thanks for any insights Christian Jaeger --------------------------------------------------------------------- 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
