diff options
Diffstat (limited to 'mysql-test/main')
-rw-r--r-- | mysql-test/main/profile.opt | 2 | ||||
-rw-r--r-- | mysql-test/main/profile.test | 34 |
2 files changed, 2 insertions, 34 deletions
diff --git a/mysql-test/main/profile.opt b/mysql-test/main/profile.opt index da84f76d539..8fbae672382 100644 --- a/mysql-test/main/profile.opt +++ b/mysql-test/main/profile.opt @@ -1,2 +1,2 @@ ---innodb_buffer_pool_size=8M +--innodb_buffer_pool_size=1G diff --git a/mysql-test/main/profile.test b/mysql-test/main/profile.test index dcff6e480ae..b1c7bc21d9a 100644 --- a/mysql-test/main/profile.test +++ b/mysql-test/main/profile.test @@ -50,7 +50,7 @@ create or replace temporary table counters ( ) engine=myisam; ---let $i= 500 +--let $i= 5 --echo i=$i --let $method=bernoulli --let percent=1 @@ -67,36 +67,4 @@ create or replace temporary table counters ( --enable_result_log select pk_value div 10000, sum(counter) from counters group by pk_value div 10000; -create or replace temporary table counters ( - pk_value int, - counter int, - primary key (pk_value) -) engine=myisam; - - ---echo ================================================================== ---echo ================================================================== ---echo ================================================================== ---echo ================================================================== ---echo ================================================================== ---echo ================================================================== ---echo ================================================================== ---echo ================================================================== - ---let $i= 500 ---echo i=$i ---let $method=system ---let percent=1 ---echo method=$method $percent% ---while($i) - eval -INSERT INTO counters - SELECT _id, 0 FROM vehicle_reg tablesample $method($percent) -ON DUPLICATE KEY UPDATE counter = counter + 1 -; ---dec $i ---} ---enable_query_log ---enable_result_log -select pk_value div 10000, sum(counter) from counters group by pk_value div 10000; --} |