Archive for 2013

DBT2: ImportError: libR.so: cannot open shared object file

Yet another error I encounter whilst running DBT2 tests. This time it was a problem with generating the final reports. They are generated using a Python library which uses R under the hood. This is the error. Traceback (most recent call last): File “/usr/local/bin/dbt2-post-process”, line 14, in import rpy2.robjects as robjects File “/usr/local/lib64/python2.7/site-packages/rpy2/robjects/__init__.py”, line 15, […]

DBT2: stmt ERROR: 1406 Data too long for column ‘out_w_city’ at row 1

Another issue with the DBT2 benchmarking suite. mysql reports SQL STMT: stmt ERROR: 1406 Data too long for column ‘out_w_city’ at row 1 Just edit the payment stored procedure and change; ?View Code MYSQLDECLARE out_w_city VARCHAR(10); To; ?View Code MYSQLDECLARE out_w_city VARCHAR(20);

Get a list of all your database files

I needed a list of all the database files on a SQL Server instance. Here’s how to get this easily. First create a temp table to hold the data like so.. ?View Code TSQLSELECT * INTO #db_files FROM sys.database_files; Truncate it so we don’t duplicate nay data. ?View Code TSQLTRUNCATE TABLE #db_files; Next we use […]

Troubleshooting the sh mysql_load_db.sh script for dbt2

I’ve been working with dbt2 benchmarking tool recently and had a few issues I thought I’d detail here for anyone else having the same issues. I was attempting to load the dbt2 database with test data; ?View Code BASHsh mysql_load_db.sh –database dbt2 –path /tmp/dbt2-w3 –mysql-path /usr/bin/mysql –user root –password secret The script threw the following error; […]

Installing the DBT2 Benchmark Tool on Linux

Just recording the process I used to install the DBT2 bench-marking tool. I used OpenSuSE 12.1 for this but should work on many distributions. ?View Code BASHcd /opt/src wget http://downloads.mysql.com/source/dbt2-0.37.50.3.tar.gz tar xvf dbt2-0.37.50.3.tar.gz cd dbt2-0.37.50.3/ ./configure –with-mysql make make install Don’t forget to read the documentaiton to start running MySQL benchmarks… cat README-MYSQL