Hi everybody, I have run a few test for innobase tables on linux and BSD
1. It seems that 'innobase' table was slower than 'bdb' table for 'insert' command,
which is surprising(or not? o_O)
2. It may be due to that fact that I dont' know much about optimazing the 'innobase'
table. Anybody know how to boost the performance of 'bdb' or 'innobase table'?
Please let me know...:(
3. I mainly tested the innobase table with linux, but I actually want to run mysql
with 'bdb' or 'innobase' tables on FreeBSD.
4. However, mysql just hung when I tried to insert the 10000 rows of data, the same
data used for linux test, using 'mysql < data.sql'. I used 'my-large.cnf' and changed
the setting as follwing. Anybody knows what the problems are?
innobase_buffer_pool_size=400M
innobase_additional_mem_pool_size=20M
FreeBSD setting
4.2 release #1
pentium 550, 512 RAM, mysql-3.23.35
complied with ./configure --
--prefix=/usr/local/mysql
--with-charset=euc_kr
--with-low-memory
--without-debug
--without-readline
--with-mysqld-ldflags=-all-static
--with-mit-threads=no
--with-client-ldflags=-all-static
----------------------------------------------------------------------------
Linux setting
Redhat 6.2, kernal 2.2.14-5.0, pentium550, 128 RAM, mysql-3.23.35
complied with ./configure --with-charset=euc_kr --with-berkeley-db --with-innobase
Other setting
1. The data used had three columns, 'no', 'name', 'grade' with 'no' as the primary
index and auto_increament and grade as a key. There were 10000 rows, and I inserted
the data using 'shell>mysql < data.sql'.
2. Whenever I inserted the data, I simply did 'delete from table where no > 0' instead
of dropping the table.
2. I used 'my-medium' as 'my.cnf'
'mysql insert' benchmarking result( all times are in seconds).
1. with key, autocommit=1, flush_log_at_trx=1, all on, basic setting
myisam
real 5.61
real 5.10
real 5.08
innobase
real 68.57
real 69.27
real 83.26
real 100.87
real 99.99
real 102.31
real 108.82
real 114.23
real 124.23
real 94.42
real 98.20
bdb
real 56.83
real 43.49
real 39.76
real 54.77
real 48.75
2. with key, autocommit=1, flush_log_at_trx=1, bdb off, basic setting
myisam
real 4.48
real 3.01
real 3.08
real 3.08
real 3.04
innobase
real 70.04
real 99.04
with
innobase_buffer_pool_size=100M
innobase_additional_mem_pool_size=10M
real 76.60
real 80.97
real 81.52
real 107.47
3. with key, autocommit=1, flush_log_at_trx=1, bdb on
bdb
real 53.14
real 54.29
