/usr/lib/mysql-testsuite/r/percona_bug45702.result is in percona-server-test-5.6 5.6.22-rel71.0-0ubuntu4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | CREATE TABLE t1 (a BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY) ENGINE=MyISAM;
INSERT INTO t1 VALUES (), (), (), (), (), (), (), ();
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
SET @old_myisam_sort_buffer_size = @@myisam_sort_buffer_size;
SET @@myisam_sort_buffer_size = 4 * 1024 * 1024 * 1024;
REPAIR TABLE t1;
Table Op Msg_type Msg_text
test.t1 repair status OK
- recovering (with sort) MyISAM-table 'MYSQLD_DATADIR/test/t1'
Data records: 4096
- Fixing index 1
SET @@myisam_sort_buffer_size = @old_myisam_sort_buffer_size;
DROP TABLE t1;
|