summaryrefslogtreecommitdiff
path: root/mysql-test/main
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main')
-rw-r--r--mysql-test/main/profile.opt2
-rw-r--r--mysql-test/main/profile.test34
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;
--}