摘要：
14.2.5.4 Physical Structure of an InnoDB Index InnoDB Index 的物理结构所有的InnoDB indexes 是B-trees ,index records 是存储在tree的leaf pages,默认的index page 大小是16K... 阅读全文
摘要：
14.2.5.4 Physical Structure of an InnoDB Index InnoDB Index 的物理结构所有的InnoDB indexes 是B-trees ,index records 是存储在tree的leaf pages,默认的index page 大小是16K... 阅读全文
摘要：
mysql> explain select t1.* from t2 ,t1 where t2.id=t1.id and t2.id select count(*) from t2;+----------+| count(*) |+----------+| 134 |+-------... 阅读全文
摘要：
mysql> explain select t1.* from t2 ,t1 where t2.id=t1.id and t2.id select count(*) from t2;+----------+| count(*) |+----------+| 134 |+-------... 阅读全文
摘要：
alter session set statistics_level=all; select t1.* from t1,t2 where t1.id=t2.id and t1.id select * from table(dbms_xplan.display_cursor(null,null,'... 阅读全文
摘要：
alter session set statistics_level=all; select t1.* from t1,t2 where t1.id=t2.id and t1.id select * from table(dbms_xplan.display_cursor(null,null,'... 阅读全文
摘要：
SQL> alter session set statistics_level=all;Session altered.SQL> select e.ename,e.job,d.dname from emp e,dept d where e.deptno=d.deptno and e.sal s... 阅读全文
摘要：
SQL> alter session set statistics_level=all;Session altered.SQL> select e.ename,e.job,d.dname from emp e,dept d where e.deptno=d.deptno and e.sal s... 阅读全文
摘要：
mysql> explain select * from (select * from ( select * from test where id=1) a) b;+----+-------------+------------+------+---------------+------+--... 阅读全文
摘要：
[root@wx03 binlog]# ls -ltrtotal 72-rw-rw---- 1 mysql mysql 15872 May 11 09:33 mysql-bin.000001-rw-rw---- 1 mysql mysql 2592 Jun 1 12:56 mysql-bin... 阅读全文