I was trying to insert 1,000,000 records of data into 1,000 tables in sysbench. But after installing about 278, sybench just crashed with the following error:

FATAL: failed to execute function `prepare': /usr/share/doc/sysbench/tests/db/common.lua:84: db_bulk_insert_next() failed

The sysbench command I used for preparing the data is given below:

sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-table-engine=innodb --oltp-tables-count=1000 --oltp-table-size=100000 --mysql-user=superuser --mysql-password=superpass --mysql-socket=/var/lib/mysql/mysql.sock prepare

I do not want to start preparing the data from scratch again. Is there a way I can declare a range on which to insert data e.g. oltp-tables-count=279-1000. I know this does not work because I tried already, but you get the idea what I am trying to achieve here. Any ideas how to accomplish this in sysbench?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.