| Server IP : 172.67.216.182 / Your IP : 162.158.170.163 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/suite/ndb/r/ |
Upload File : |
drop table if exists t1; set GLOBAL query_cache_type=on; Warnings: Warning 1287 '@@query_cache_type' is deprecated and will be removed in a future release. set GLOBAL query_cache_size=1355776; Warnings: Warning 1287 '@@query_cache_size' is deprecated and will be removed in a future release. reset query cache; Warnings: Warning 1681 'RESET QUERY CACHE' is deprecated and will be removed in a future release. flush status; CREATE TABLE t1 ( pk int not null primary key, a int, b int not null, c varchar(20)) ENGINE=ndbcluster; insert into t1 value (1, 2, 3, 'First row'); select * from t1; pk a b c 1 2 3 First row show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 1 show status like "Qcache_hits"; Variable_name Value Qcache_hits 0 select * from t1; pk a b c 1 2 3 First row show status like "Qcache_hits"; Variable_name Value Qcache_hits 1 update t1 set a=3 where pk=1; select * from t1; pk a b c 1 3 3 First row show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 2 show status like "Qcache_hits"; Variable_name Value Qcache_hits 1 insert into t1 value (2, 7, 8, 'Second row'); insert into t1 value (4, 5, 6, 'Fourth row'); select * from t1 order by pk; pk a b c 1 3 3 First row 2 7 8 Second row 4 5 6 Fourth row show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 3 show status like "Qcache_hits"; Variable_name Value Qcache_hits 1 select * from t1 order by pk; pk a b c 1 3 3 First row 2 7 8 Second row 4 5 6 Fourth row show status like "Qcache_hits"; Variable_name Value Qcache_hits 2 select * from t1 where b=3; pk a b c 1 3 3 First row show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 2 show status like "Qcache_hits"; Variable_name Value Qcache_hits 2 select * from t1 where b=3; pk a b c 1 3 3 First row show status like "Qcache_hits"; Variable_name Value Qcache_hits 3 delete from t1 where c='Fourth row'; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 select * from t1 where b=3; pk a b c 1 3 3 First row show status like "Qcache_hits"; Variable_name Value Qcache_hits 3 use test; select * from t1 order by pk; pk a b c 1 3 3 First row 2 7 8 Second row select * from t1 where b=3; pk a b c 1 3 3 First row show status like "Qcache_hits"; Variable_name Value Qcache_hits 4 update t1 set a=4 where b=3; use test; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 7 show status like "Qcache_hits"; Variable_name Value Qcache_hits 5 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 7 show status like "Qcache_hits"; Variable_name Value Qcache_hits 7 begin; update t1 set a=5 where pk=1; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 7 show status like "Qcache_hits"; Variable_name Value Qcache_hits 7 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 8 show status like "Qcache_hits"; Variable_name Value Qcache_hits 7 commit; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 8 show status like "Qcache_hits"; Variable_name Value Qcache_hits 7 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 5 3 First row show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 9 show status like "Qcache_hits"; Variable_name Value Qcache_hits 7 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 5 3 First row show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 9 show status like "Qcache_hits"; Variable_name Value Qcache_hits 8 drop table t1; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 reset query cache; Warnings: Warning 1681 'RESET QUERY CACHE' is deprecated and will be removed in a future release. flush status; create table t1 (a int primary key, b text, c int, key(c)) engine=ndb; insert into t1 values (1,'Alexandra', 1), (2,'Palace', 2); show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 0 show status like "Qcache_hits"; Variable_name Value Qcache_hits 0 show status like "Qcache_not_cached"; Variable_name Value Qcache_not_cached 0 select * from t1 order by a; a b c 1 Alexandra 1 2 Palace 2 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 1 show status like "Qcache_hits"; Variable_name Value Qcache_hits 0 show status like "Qcache_not_cached"; Variable_name Value Qcache_not_cached 0 select * from t1 order by a; a b c 1 Alexandra 1 2 Palace 2 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 1 show status like "Qcache_hits"; Variable_name Value Qcache_hits 1 show status like "Qcache_not_cached"; Variable_name Value Qcache_not_cached 0 select * from t1 force index(c) where c < 2 order by c; a b c 1 Alexandra 1 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 2 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 2 show status like "Qcache_hits"; Variable_name Value Qcache_hits 1 show status like "Qcache_not_cached"; Variable_name Value Qcache_not_cached 0 select * from t1 force index(c) where c < 2 order by c; a b c 1 Alexandra 1 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 2 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 2 show status like "Qcache_hits"; Variable_name Value Qcache_hits 2 show status like "Qcache_not_cached"; Variable_name Value Qcache_not_cached 0 drop table t1; CREATE LOGFILE GROUP lfg ADD UNDOFILE 'myundo.log' INITIAL_SIZE 16M UNDO_BUFFER_SIZE = 1M ENGINE=NDB; CREATE TABLESPACE tbsp ADD DATAFILE 'mydatafile.fil' USE LOGFILE GROUP lfg INITIAL_SIZE 12M ENGINE=NDB; create table t1 (a int primary key, b text, c int, key(c)) storage disk tablespace tbsp engine ndb; insert into t1 values (1,'Alexandra', 1), (2,'Palace', 2); reset query cache; Warnings: Warning 1681 'RESET QUERY CACHE' is deprecated and will be removed in a future release. flush status; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 0 show status like "Qcache_hits"; Variable_name Value Qcache_hits 0 show status like "Qcache_not_cached"; Variable_name Value Qcache_not_cached 0 select * from t1 order by a; a b c 1 Alexandra 1 2 Palace 2 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 1 show status like "Qcache_hits"; Variable_name Value Qcache_hits 0 show status like "Qcache_not_cached"; Variable_name Value Qcache_not_cached 0 select * from t1 order by a; a b c 1 Alexandra 1 2 Palace 2 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 1 show status like "Qcache_hits"; Variable_name Value Qcache_hits 1 show status like "Qcache_not_cached"; Variable_name Value Qcache_not_cached 0 select * from t1 force index (c) where c < 2 order by c; a b c 1 Alexandra 1 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 2 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 2 show status like "Qcache_hits"; Variable_name Value Qcache_hits 1 show status like "Qcache_not_cached"; Variable_name Value Qcache_not_cached 0 select * from t1 force index (c) where c < 2 order by c; a b c 1 Alexandra 1 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 2 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 2 show status like "Qcache_hits"; Variable_name Value Qcache_hits 2 show status like "Qcache_not_cached"; Variable_name Value Qcache_not_cached 0 drop table t1; alter tablespace tbsp drop datafile 'mydatafile.fil' engine ndb; drop tablespace tbsp engine ndb; drop logfile group lfg engine ndb; reset query cache; Warnings: Warning 1681 'RESET QUERY CACHE' is deprecated and will be removed in a future release. flush status; pk a b c 1 2 3 First row pk a b c 1 2 3 First row pk a b c 1 2 3 First row show status like "Qcache_hits"; Variable_name Value Qcache_hits 1 SET GLOBAL query_cache_size=0; Warnings: Warning 1287 '@@query_cache_size' is deprecated and will be removed in a future release.