sql bench problems

[Yonah Russ]

I've been trying to compile a mysql server optimized for a zeon 
processor and a specific application- I'm compiling with icc.

the problem is with the sql benchmarks- the perl regexp for making the 
detailed report of the benchmark doesn't match the output from the 
benchmarks so it doesn't create the report but instead says that 
everything failed-

Has anyone had this problem? I could futz around with the regexp but if 
there is a more correct solution, I'd rather do that.

here is a sample output line:

Time for alter_table_drop (91): 19 wallclock secs ( 0.02 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.02 CPU)

here is the regexp:

/^(estimated |)time (to|for) ([^\s:]*)\s*\((\d*)(:\d*)*\)[^:]*:\s*([\d.]+) .*secs \(\s*([^\s]*) usr\s*\+*\s*([^\s]*) sys.*=\s+([\d.]*)\s+cpu/i

thanks
yonah
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: sql bench problems

[Brad Eacker]

Yonah Russ writes:
here is a sample output line:

Time for alter_table_drop (91): 19 wallclock secs ( 0.02 usr  0.00 sys +  
0.00 cusr  0.00 csys =  0.02 CPU)


here is the regexp:

/^(estimated |)time (to|for) ([^\s:]*)\s*\((\d*)(:\d*)*\)[^:]*:\s*([\d.]+) 
.*secs \(\s*([^\s]*) usr\s*\+*\s*([^\s]*) sys.*=\s+([\d.]*)\s+cpu/i

Yonah,
 It appears that the source has been modified from the original regexp.
Primary changes are:
time - Time
cpu - CPU

You may want to run the output thru
tr '[A-Z]' '[a-z]'
to change upper case to lower case to allow the regexp to work properly.

Brad Eacker ([EMAIL PROTECTED])



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]