~ubuntu-branches/ubuntu/wily/mysql-5.6/wily

« back to all changes in this revision

Viewing changes to mysql-test/suite/innodb_stress/t/innodb_bigstress_blob.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2015-07-21 07:09:29 UTC
  • mto: This revision was merged to the branch mainline in revision 14.
  • Revision ID: package-import@ubuntu.com-20150721070929-mg4dpqkgg3it1ajf
Tags: upstream-5.6.25
ImportĀ upstreamĀ versionĀ 5.6.25

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
# stress tests: blobs=yes, crash=no, compress=yes
 
2
 
 
3
# Don't test this under valgrind, memory leaks will occur
 
4
--source include/not_valgrind.inc
 
5
--source include/have_innodb.inc
 
6
--source include/master-slave.inc
 
7
--source include/big_test.inc
 
8
 
 
9
SET GLOBAL innodb_file_format=Barracuda;
 
10
 
 
11
let $MYSQL_BASEDIR = `SELECT @@BASEDIR`;
 
12
 
 
13
--disable_warnings
 
14
DROP TABLE IF EXISTS t1;
 
15
--enable_warnings
 
16
 
 
17
# create the actual table
 
18
CREATE TABLE t1(id INT AUTO_INCREMENT PRIMARY KEY,
 
19
                msg_prefix VARCHAR(255),
 
20
                msg longtext,
 
21
                msg_length int,
 
22
                msg_checksum varchar(128),
 
23
                KEY msg_i(msg_prefix))
 
24
ENGINE=INNODB
 
25
ROW_FORMAT=COMPRESSED
 
26
KEY_BLOCK_SIZE=1;
 
27
 
 
28
let $use_blob=1;
 
29
let $do_compress=1;
 
30
let $do_crash=0;
 
31
 
 
32
--let $num_crashes = 1
 
33
--let $num_workers = 10
 
34
--let $num_transactions = 2000
 
35
--let $kill_db_after = 0
 
36
--let $num_records = 1000
 
37
--let $max_rows = 4096
 
38
 
 
39
--source suite/innodb_stress/include/innodb_stress.inc
 
40
 
 
41
SET GLOBAL innodb_file_format=Default;