sysbench-developers team mailing list archive

Thread
Date

[Question #449473]: How to provide path to sysbench to create mysql database other than '/var/lib/mysql/ 'path ??

To: sysbench-developers@xxxxxxxxxxxxxxxxxxx
From: Amar Bharamshetti <question449473@xxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 01 Feb 2017 09:34:11 -0000
Reply-to: question449473@xxxxxxxxxxxxxxxxxxxxx
Sender: bounces@xxxxxxxxxxxxx

New question #449473 on sysbench:
https://answers.launchpad.net/sysbench/+question/449473

I am running mysql  sysbench for kvm tesing.  On kvm guest I have created database and created user.  From  the client side I am invoking this command to add entries in  database  created on  kvm guest:

 ./sysbench --oltp-table-size=100000 --test=tests/db/oltp.lua  --mysql-user=client1 --mysql-password=password1 --mysql-host=90.0.0.1 --mysql-db=sbtest1 prepare

By default database is getting created in '/var/lib/mysql/' path. In my case problem is the space allocated for '/' file system is only 5G. So client/s can't add more record or can't do write operations as  there is not much space. So is there any option for sysbench which can be used to specify the path while creating/adding entries/modifying the database, So I can attach  hard drive to kvm guest, create database and run sysbench ?? Thanks in advance ..!!


-- 
You received this question notification because your team sysbench-
developers is an answer contact for sysbench.