diff options
author | unknown <monty@donna.mysql.com> | 2000-11-18 02:15:06 +0200 |
---|---|---|
committer | unknown <monty@donna.mysql.com> | 2000-11-18 02:15:06 +0200 |
commit | 0ffa94682eb3ec86bd3c45fdee68f5ecda5e6ab7 (patch) | |
tree | e47c14103d1588f6a27c229783e07d73438c96d0 /sql-bench/test-insert.sh | |
parent | 19fc413aa25290016069efbc9e25e2e79b3ea7c9 (diff) | |
download | mariadb-git-0ffa94682eb3ec86bd3c45fdee68f5ecda5e6ab7.tar.gz |
Portability fixes
Docs/manual.texi:
Updated links and added more examples
client/mysql.cc:
Added --timeout + merge of Jani:s changes
isam/_dynrec.c:
Fixed bug when making big rows 1 byte smaller
scripts/mysqlhotcopy.sh:
Added regexp handling of filenames
sql-bench/test-insert.sh:
More order by tests
sql/mf_iocache.cc:
Cleanup
sql/mysqld.cc:
Moved my_delete() to before master thread died
sql/sql_parse.cc:
Fixed wrong comparison
Diffstat (limited to 'sql-bench/test-insert.sh')
-rwxr-xr-x | sql-bench/test-insert.sh | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql-bench/test-insert.sh b/sql-bench/test-insert.sh index 8545f449fa6..a9a95cf6710 100755 --- a/sql-bench/test-insert.sh +++ b/sql-bench/test-insert.sh @@ -371,6 +371,25 @@ for ($i=1 ; $i <= $range_loop_count ; $i++) { $start=$opt_loop_count/$range_loop_count*$i; $end=$start+$i; + $rows+=fetch_all_rows($dbh,"select dummy1 from bench1 where id>=$start and id <= $end order by id3",1); + $end_time=new Benchmark; + last if ($estimated=predict_query_time($loop_time,$end_time,\$i,$i, + $range_loop_count)); +} +if ($estimated) +{ print "Estimated time"; } +else +{ print "Time"; } +print " for order_by_range ($range_loop_count:$rows): " . + timestr(timediff($end_time, $loop_time),"all") . "\n"; + + +$loop_time=new Benchmark; +$estimated=$rows=0; +for ($i=1 ; $i <= $range_loop_count ; $i++) +{ + $start=$opt_loop_count/$range_loop_count*$i; + $end=$start+$i; $rows+=fetch_all_rows($dbh,"select dummy1 from bench1 where id>=$start and id <= $end order by id",1); $end_time=new Benchmark; last if ($estimated=predict_query_time($loop_time,$end_time,\$i,$i, |