Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/include/

View File Name : index_merge_multi_col_setup.inc

#
# Creating table with multi column index setup
#

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

CREATE TABLE t1
(
  key1 INT NOT NULL,
  key2 INT NOT NULL,
  key3 INT NOT NULL,
  key4 INT NOT NULL,
  key5 INT,
  key6 INT,
  key7 INT NOT NULL,
  key8 INT NOT NULL,
  INDEX i1(key1,key2),
  INDEX i2(key2,key1),
  INDEX i3(key3,key4),
  INDEX i4(key4,key3),
  INDEX i5(key5,key6),
  INDEX i6(key6,key5),
  INDEX i7(key7,key8),
  INDEX i8(key8,key7)
);

--disable_query_log


# inserting values

INSERT INTO t1 VALUES ( 1,1,1,1,1,1,1,1),(2,2,2,2,2,2,2,2);

let $i=10;
set @d=2;
while($i)
{
  INSERT INTO t1 SELECT key1+@d, key2+@d, key3+@d, key4+@d,
                            key5+@d, key6+@d, key7+@d, key8+@d FROM t1;
  set @d=@d*2;
  dec $i;
}


# Inserting null values.

let $i=5;
set @d=5;
while($i)
{
  INSERT INTO t1 VALUES (key1+@d, key2+@d, key3+@d, key4+@d,
                                        key5+@d, NULL, key7+@d, key8+@d);
  set @d=@d*2;
  dec $i;
}

let $i=4;
set @d=6;
while($i)
{
  INSERT INTO t1 VALUES (key1+@d, key2+@d, key3+@d, key4+@d,
                                       NULL, key6+@d, key7+@d, key8+@d);
  set @d=@d*2;
  dec $i;
}

--enable_query_log

# To analyze and store the key distribution of the table.

ANALYZE TABLE t1;