| Server IP : 172.67.216.182 / Your IP : 162.158.170.218 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/include/ |
Upload File : |
#
# Creating table with single 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),
INDEX i2(key2),
INDEX i3(key3),
INDEX i4(key4),
INDEX i5(key5),
INDEX i6(key6)
);
--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
# The following statement analyzes and
# stores the key distribution for a table.
ANALYZE TABLE t1;