Hello list
I've just installed mysql-3.23.33 with db-3.2.9a (linux on a ppc) and
still have dog slow bdb tables with data errors.
How fast are bdb tables really, for those where they work? Doing 3
queries/sec is not a real option for me.
Note that I had to change the makefile in db-3.2.9a/build_unix or it
would not have installed: from
install: all # modified by MySQL configure
install_include install_lib install_utilities install_docs
to
install: install_include install_lib install_utilities install_docs
Christian.
Tests:
-----
mysql> create table bdbtest4 (a int not null primary key, b text) type=bdb;
Query OK, 0 rows affected (4.03 sec)
mysql> insert into bdbtest4 values(0,"Miau");
Query OK, 1 row affected (1.61 sec)
mysql> insert into bdbtest4 values(1,"Cat");
Query OK, 1 row affected (0.33 sec)
mysql> select * from bdbtest4;
+---+------+
| a | b |
+---+------+
| 0 | Miau |
| 1 | Cat |
+---+------+
2 rows in set (0.33 sec)
mysql> select * from bdbtest4 where a=1;
+---+------+
| a | b |
+---+------+
| 1 | à |
+---+------+
1 row in set (0.14 sec)
mysql> select * from bdbtest4 where a=0;
+---+------+
| a | b |
+---+------+
| 0 | à |
+---+------+
1 row in set (0.14 sec)
mysql> status
--------------
mysql Ver 11.12 Distrib 3.23.33, for unknown-linux-gnu (powerpc)
Connection id: 1
Current database: test
Current user: chris@localhost
Current pager: stdout
Using outfile: ''
Server version: 3.23.33
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: german1
Server characterset: german1
UNIX socket: /tmp/mysql.sock
Uptime: 8 min 20 sec
Threads: 1 Questions: 33 Slow queries: 0 Opens: 26 Flush tables:
1 Open tables: 18 Queries per second avg: 0.066
--------------
mysql>
System:
------
linuxppc (powermac 9600/300mhz), kernel 2.2.17 , glibc 2.1.3, gcc-2.95.3
Configure:
---------
./configure --with-charset=german1 --with-extra-charsets=latin1
--with-berkeley-db --localstatedir=/home/mysql
--
Web Office
Christian Jaeger
Corporate Communications, ETH Zentrum
CH-8092 Zurich
office: HG J43 e-mail: [EMAIL PROTECTED]
phone: +41 (0)1 63 2 5780 [EMAIL PROTECTED]
home: +41 (0)1 273 65 46 fax: +41 (0)1 63 2 3525
---------------------------------------------------------------------
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
