Q: How to set autocommit in my.cnf and etc

Hi, everybody, I have a couple of quesitons 1. From the mysql manual, if I want to use 'autocommit=0', it says that I type 'set autocommit=0' and this only applies to a session. So, when I want to back up data using 'shellmysql datablse data.sql', do I need to add 'set autocommit=0' at the

Q: How to set autocommit=0 while shellmysql datablse data.sql

Hi, everybody, I have a couple of quesitons 1. From the mysql manual, if I want to use 'autocommit=0', it says that I type 'set autocommit=0' and this only applies to a session. So, when I want to back up data using 'shellmysql datablse data.sql', do I need to add 'set autocommit=0' at the

linux innobase benchmarking and BSD problem

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.