sysbench压测tdsql分布式实例 注意事项

wget https://github.com/akopytov/sysbench/archive/master.zip
unzip sysbench-master.zip
cd sysbench-master
./autogen.sh
./configure
make && make install

----省略
      range_selects =
      {"Enable/disable all range SELECT queries", true},
--   auto_inc =
--   {"Use AUTO_INCREMENT column as Primary Key (for MySQL), " ..
--       "or its alternatives in other DBMS. When disabled, use " ..
--       "client-generated IDs", true},
   create_table_options =
      {"Extra CREATE TABLE options", ""},
      
----省略

   query = string.format([[
CREATE TABLE sbtest%d(
  id %s,
  k INTEGER DEFAULT '0' NOT NULL,
  c CHAR(120) DEFAULT '' NOT NULL,
  pad CHAR(60) DEFAULT '' NOT NULL,
  %s (id)
) %s %s shardkey=id]],
      table_num, id_def, id_index_def, engine_def,
      sysbench.opt.create_table_options)
----省略