MySQLTalk.org

Rod Heyd · Guest

I'm hoping to be able to use super smack to generate some test data and I
seem to be running into a strange limit:

If I create a table with 17 columns, irrespective of the column type. Super
smack generates the data, loads up the table and
runs the benchmark queries without a hitch. If I add an 18th column to this
table, the data is generated a loaded up just fine,
but super smack hangs after loading the data. The benchmark queries aren't
run at all. It just sits there. Is anyone aware
of any limitations that might be cause this strange behavior?

Super smack is running on SuSe 9.1 (x86-64).

The benchmarks I ultimately want to run are a little more complex than this
and may require my generating the data externally
anyway, however, it seems like this should work without a problem.

Here's the portion of my smack file that generates the table:

table "People"
{
client "admin"; // connect with this client
// if the table is not found or does not pass the checks, create it
// with the following, dropping the old one if needed
create "create table People
(ID INT(10) unsigned auto_increment not null primary key,
USERNAME varchar(15) not null unique,
VERSION varchar(255),
GIVEN_NAME varchar(20),
FAMILY_NAME varchar(20),
ADDITIONAL_NAMES varchar(20),
NAME_SUFFIX varchar(20),
EMAIL_ADDRESS varchar(60),
GROUP_NAME
SET('TEAM_MEMBER','VALIDATOR','TAG','EPO','PUB','STAFF',
'STUDENT'),
POSTAL_CODE varchar(10),
COUNTRY varchar(20),
OCCUPATION varchar(20),
HIGHEST_GRADE_COMPLETED tinyint(2),
PASSWORD varchar(40),
AFFILIATION varchar(80),
PUBLIC_KEY varchar(255),
NOTE varchar(200)
) engine=innodb";
min_rows "90000"; // the table must have at least that many rows
data_file "People.dat"; // if the table is empty, load the data from
//this file
gen_data_file "gen-data -n 90000 -f
%n,%10-10s%n,'',%3-20s,%3-20s,%3-20s,%3-20s,%10-60s,'PUB',%10-10d,%10-20s,%5-20s,%1d,%40-40s,%10-80s,'',%1-200s";
// if the file above does not exist, generate it with the above shell
command
// you can replace this command with anything that prints comma-delimited
// data to stdout, just make sure you have the right number of columns
}

Has anyone run into this problem before?

Cheers,

Rod