mysql的使用24
来源:互联网 发布:php mysql 预编译 编辑:程序博客网 时间:2024/04/30 04:41
mysql> #自适应哈希索引
mysql> #自适应哈西索引采用之前讨论的三列表的方式实现
mysql> #查看当前自适应哈西索引的使用情况
mysql> show engine innodb status;
+--------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Type | Name | Status |
+--------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| InnoDB | |
=====================================
140819 19:20:37 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 53 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1 1_second, 1 sleeps, 0 10_second, 1 background, 1 flush
srv_master_thread log flush and writes: 2
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2, signal count 2
Mutex spin waits 1, rounds 9, OS waits 0
RW-shared spins 2, rounds 60, OS waits 2
RW-excl spins 0, rounds 0, OS waits 0
Spin rounds per wait: 9.00 mutex, 30.00 RW-shared, 0.00 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 3E00
Purge done for trx's n:o < 3C13 undo n:o < 0
History list length 309
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 37, OS thread handle 0x7f45cfcc6700, query id 110 localhost root
show engine innodb status
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
575 OS file reads, 3 OS file writes, 3 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276707, node heap has 0 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 31842628
Log flushed up to 31842628
Last checkpoint at 31842628
0 pending log writes, 0 pending chkp writes
8 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 137363456; in additional pool allocated 0
Dictionary memory allocated 486546
Buffer pool size 8192
Free buffers 7628
Database pages 564
Old database pages 228
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 564, created 0, written 0
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 564, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 1103, id 139937775945472, state: waiting for server activity
Number of rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
|
+--------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> #分区
mysql> #分区是一种表的设计模式,正确的分区可以极大的提升数据库的查询效率,完成高质量的编程
mysql> #MySQL数据的分区是局部分区索引,一个分区中既存放数据又存放索引,全局分区是指数据存放在各个分区中,但是所有数据的索引放在一个对象中,目前,mysql不支持全局分区
mysql>
mysql> show variables like '%partition';
Empty set (0.00 sec)
mysql> show plugins;
+--------------------------+----------+--------------------+---------+---------+
| Name | Status | Type | Library | License |
+--------------------------+----------+--------------------+---------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| mysql_old_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL |
| BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
+--------------------------+----------+--------------------+---------+---------+
23 rows in set (0.00 sec)
mysql> #partition is active now
mysql> #mysql数据库支持以下几种类型的数据库
mysql> #range分区: 行数据基于属于一个给定连接连续区间的列值放入分区
mysql> #list分区和range分区一样,只是list分区面向的离散的值
mysql> #hash分区:根据用户自定义表达式的返回值来进行分区,返回值不能为负数
mysql> #key分区,根据mysql数据库提供的三列函数来进行分区
mysql> create table partion(
-> col1 int null,
-> col2 date null,
-> col3 int null,
-> col4 int null,
-> unique key (col1,col2,col3,col4))partition by hash(col3)
-> partitions 4;
ERROR 1046 (3D000): No database selected
mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> create table partion( col1 int null, col2 date null, col3 int null, col4 int null, unique key (col1,col2,col3,col4))partition by hash(col3) partitions 4;
Query OK, 0 rows affected (0.21 sec)
mysql> #唯一索引可以是null,并且只要求分区列是唯一索引的一个组成部分,不需要整个唯一索引都是分区列
mysql>
mysql> #现在介绍一个range分区
mysql> create table part1 (
-> id int)engine=innodb
-> partition by range(id)(
-> partition p0 values less then(10),
-> partition p1 values less then(20));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'then(10),
partition p1 values less then(20))' at line 4
mysql> create table part1 ( id int)engine=innodb partition by range(id)( partition p0 values less than(10), partition p1 values less than(20));
Query OK, 0 rows affected (0.12 sec)
mysql> #上面创建了一个分区,当id小于10时,将数据插入p0分区,当id小于20时,将数据插入p1分区。。。
mysql> insert into part1 select 9;
Query OK, 1 row affected (0.03 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> insert into part1 select 10;
Query OK, 1 row affected (0.03 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> insert into part1 select 15;
Query OK, 1 row affected (0.04 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> select * from information_schema.PARTITIONS;
+---------------+--------------------+----------------------------------------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+--------------------+--------------+-----------+---------------------+---------------------+---------------------+----------+-------------------+-----------+-----------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION | SUBPARTITION_EXPRESSION | PARTITION_DESCRIPTION | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME |
+---------------+--------------------+----------------------------------------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+--------------------+--------------+-----------+---------------------+---------------------+---------------------+----------+-------------------+-----------+-----------------+
| def | information_schema | CHARACTER_SETS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 384 | 0 | 16434816 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | COLLATIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 231 | 0 | 16704765 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 195 | 0 | 16357770 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | COLUMNS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | COLUMN_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2565 | 0 | 16757145 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | ENGINES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 490 | 0 | 16574250 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | EVENTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | FILES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2677 | 0 | 16758020 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | GLOBAL_STATUS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3268 | 0 | 16755036 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | GLOBAL_VARIABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3268 | 0 | 16755036 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | KEY_COLUMN_USAGE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 4637 | 0 | 16762755 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | PARAMETERS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | PARTITIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | PLUGINS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | PROCESSLIST | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | PROFILING | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 308 | 0 | 16562084 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | REFERENTIAL_CONSTRAINTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 4814 | 0 | 16767162 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | ROUTINES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | SCHEMATA | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3464 | 0 | 16738048 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | SCHEMA_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2179 | 0 | 16736899 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | SESSION_STATUS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3268 | 0 | 16755036 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | SESSION_VARIABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3268 | 0 | 16755036 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | STATISTICS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 5753 | 0 | 16752736 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | TABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 9450 | 0 | 16764300 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | TABLESPACES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 6951 | 0 | 16772763 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | TABLE_CONSTRAINTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2504 | 0 | 16721712 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | TABLE_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2372 | 0 | 16748692 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | TRIGGERS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | USER_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 1986 | 0 | 16726092 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | VIEWS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | INNODB_BUFFER_PAGE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 6852 | 0 | 16766844 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_TRX | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 4534 | 0 | 16766732 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_BUFFER_POOL_STATS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 257 | 0 | 16332350 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_LOCK_WAITS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 599 | 0 | 16749238 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_CMPMEM | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 29 | 0 | 15204352 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_CMP | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 25 | 0 | 13107200 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_LOCKS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 31244 | 0 | 16746784 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_CMPMEM_RESET | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 29 | 0 | 15204352 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_CMP_RESET | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 25 | 0 | 13107200 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_BUFFER_PAGE_LRU | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 6669 | 0 | 16765866 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | csvt | auth_group | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-08 21:25:16 | NULL | NULL | NULL | | | NULL |
| def | csvt | auth_group_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-08 21:26:18 | NULL | NULL | NULL | | | NULL |
| def | csvt | auth_permission | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 21 | 780 | 16384 | NULL | 32768 | 0 | 2014-08-08 21:26:17 | NULL | NULL | NULL | | | NULL |
| def | csvt | auth_user | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-08 21:25:17 | NULL | NULL | NULL | | | NULL |
| def | csvt | auth_user_groups | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-08 21:26:18 | NULL | NULL | NULL | | | NULL |
| def | csvt | auth_user_user_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-08 21:26:18 | NULL | NULL | NULL | | | NULL |
| def | csvt | blog_employee | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | NULL | 0 | 0 | 2014-08-08 21:25:18 | NULL | NULL | NULL | | | NULL |
| def | csvt | django_content_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 7 | 2340 | 16384 | NULL | 16384 | 0 | 2014-08-08 21:25:17 | NULL | NULL | NULL | | | NULL |
| def | csvt | django_session | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-08 21:26:19 | NULL | NULL | NULL | | | NULL |
| def | csvt | django_site | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-08 21:25:18 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | auth_group | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-09 15:41:31 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | auth_group_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-09 15:42:09 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | auth_permission | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 24 | 682 | 16384 | NULL | 32768 | 0 | 2014-08-09 15:42:09 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | auth_user | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-09 15:41:32 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | auth_user_groups | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-09 15:42:10 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | auth_user_user_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-09 15:42:10 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | blog_blog | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | NULL | 16384 | 0 | 2014-08-09 15:53:11 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | blog_entry | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-09 15:53:10 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | django_content_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8 | 2048 | 16384 | NULL | 16384 | 0 | 2014-08-09 15:41:32 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | django_session | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-09 15:42:10 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | django_site | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-09 15:41:32 | NULL | NULL | NULL | | | NULL |
| def | mysql | columns_priv | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 227994731135631359 | 4096 | 0 | 2014-07-28 16:04:05 | 2014-07-28 16:04:05 | NULL | NULL | | | NULL |
| def | mysql | db | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 123848989752688639 | 2048 | 0 | 2014-07-28 16:04:12 | 2014-07-28 16:04:12 | 2014-07-28 16:04:12 | NULL | | | NULL |
| def | mysql | event | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 2048 | 0 | 2014-07-28 16:04:11 | 2014-07-28 16:04:11 | NULL | NULL | | | NULL |
| def | mysql | func | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 162974011515469823 | 1024 | 0 | 2014-07-28 16:04:07 | 2014-07-28 16:04:07 | NULL | NULL | | | NULL |
| def | mysql | general_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | mysql | help_category | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 40 | 28 | 1120 | 281474976710655 | 3072 | 0 | 2014-07-17 15:23:26 | 2014-07-28 16:03:54 | NULL | NULL | | | NULL |
| def | mysql | help_keyword | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 467 | 197 | 91999 | 55450570411999231 | 17408 | 0 | 2014-07-17 15:23:26 | 2014-07-28 16:03:54 | NULL | NULL | | | NULL |
| def | mysql | help_relation | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1047 | 9 | 9423 | 2533274790395903 | 18432 | 0 | 2014-07-17 15:23:26 | 2014-07-28 16:03:54 | NULL | NULL | | | NULL |
| def | mysql | help_topic | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 511 | 927 | 474004 | 281474976710655 | 21504 | 0 | 2014-07-17 15:23:26 | 2014-07-28 16:03:54 | NULL | NULL | | | NULL |
| def | mysql | host | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 110056715893866495 | 2048 | 0 | 2014-07-28 16:04:12 | 2014-07-28 16:04:12 | NULL | NULL | | | NULL |
| def | mysql | ndb_binlog_index | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-07-17 15:23:27 | 2014-07-17 15:23:27 | NULL | NULL | | | NULL |
| def | mysql | plugin | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-07-28 16:04:07 | 2014-07-28 16:04:07 | NULL | NULL | | | NULL |
| def | mysql | proc | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 863 | 4316 | 281474976710655 | 4096 | 0 | 2014-07-28 16:04:10 | 2014-08-17 11:13:34 | NULL | NULL | | | NULL |
| def | mysql | procs_priv | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 239253730204057599 | 4096 | 0 | 2014-07-28 16:04:09 | 2014-07-28 16:04:09 | 2014-07-28 16:04:09 | NULL | | | NULL |
| def | mysql | proxies_priv | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 693 | 1386 | 195062158860484607 | 5120 | 0 | 2014-07-17 15:23:28 | 2014-07-17 15:23:28 | 2014-07-17 15:23:28 | NULL | | | NULL |
| def | mysql | servers | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 433752939111120895 | 1024 | 0 | 2014-07-17 15:23:26 | 2014-07-17 15:23:26 | NULL | NULL | | | NULL |
| def | mysql | slow_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | mysql | tables_priv | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 239535205180768255 | 4096 | 0 | 2014-07-28 16:04:05 | 2014-07-28 16:04:05 | 2014-07-28 16:04:05 | NULL | | | NULL |
| def | mysql | time_zone | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 1970324836974591 | 1024 | 0 | 2014-07-17 15:23:27 | 2014-07-17 15:23:27 | NULL | NULL | | | NULL |
| def | mysql | time_zone_leap_second | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 3659174697238527 | 1024 | 0 | 2014-07-17 15:23:27 | 2014-07-17 15:23:27 | NULL | NULL | | | NULL |
| def | mysql | time_zone_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 55450570411999231 | 1024 | 0 | 2014-07-17 15:23:26 | 2014-07-17 15:23:26 | NULL | NULL | | | NULL |
| def | mysql | time_zone_transition | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 4785074604081151 | 1024 | 0 | 2014-07-17 15:23:27 | 2014-07-17 15:23:27 | NULL | NULL | | | NULL |
| def | mysql | time_zone_transition_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 10696049115004927 | 1024 | 0 | 2014-07-17 15:23:27 | 2014-07-17 15:23:27 | NULL | NULL | | | NULL |
| def | mysql | user | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 97 | 488 | 281474976710655 | 2048 | 0 | 2014-07-28 16:04:12 | 2014-07-28 16:04:12 | NULL | NULL | | | NULL |
| def | performance_schema | cond_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | events_waits_current | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | events_waits_history | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | events_waits_history_long | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | events_waits_summary_by_instance | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | events_waits_summary_by_thread_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | events_waits_summary_global_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | file_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | file_summary_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | file_summary_by_instance | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | mutex_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | performance_timers | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | rwlock_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | setup_consumers | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | setup_instruments | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | setup_timers | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | threads | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | photo | auth_group | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-18 16:40:47 | NULL | NULL | NULL | | | NULL |
| def | photo | auth_group_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-18 16:41:08 | NULL | NULL | NULL | | | NULL |
| def | photo | auth_permission | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 27 | 606 | 16384 | NULL | 32768 | 0 | 2014-08-18 16:41:08 | NULL | NULL | NULL | | | NULL |
| def | photo | auth_user | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 16384 | 0 | 2014-08-18 16:40:48 | NULL | NULL | NULL | | | NULL |
| def | photo | auth_user_groups | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-18 16:41:09 | NULL | NULL | NULL | | | NULL |
| def | photo | auth_user_user_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-18 16:41:09 | NULL | NULL | NULL | | | NULL |
| def | photo | blog_item | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-18 16:40:49 | NULL | NULL | NULL | | | NULL |
| def | photo | blog_photo | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 16384 | 0 | 2014-08-18 16:41:10 | NULL | NULL | NULL | | | NULL |
| def | photo | django_admin_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 32768 | 0 | 2014-08-18 16:41:10 | NULL | NULL | NULL | | | NULL |
| def | photo | django_content_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 9 | 1820 | 16384 | NULL | 16384 | 0 | 2014-08-18 16:40:48 | NULL | NULL | NULL | | | NULL |
| def | photo | django_session | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 16384 | 0 | 2014-08-18 16:41:10 | NULL | NULL | NULL | | | NULL |
| def | photo | django_site | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-18 16:40:49 | NULL | NULL | NULL | | | NULL |
| def | test | MonthlyOrders | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 23 | 712 | 16384 | NULL | 0 | 0 | 2014-08-16 10:30:21 | NULL | NULL | NULL | | | NULL |
| def | test | Nums | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 512 | 32 | 16384 | NULL | 0 | 0 | 2014-08-11 20:43:15 | NULL | NULL | NULL | | | NULL |
| def | test | a | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | NULL | 0 | 0 | 2014-08-09 12:08:49 | NULL | NULL | NULL | | | NULL |
| def | test | aa | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-18 08:04:49 | NULL | NULL | NULL | | | NULL |
| def | test | animals | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | NULL | 16384 | 0 | 2014-08-13 10:15:46 | NULL | NULL | NULL | | | NULL |
| def | test | back | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | NULL | 0 | 0 | 2014-08-17 20:31:14 | NULL | NULL | NULL | | | NULL |
| def | test | buy_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 7 | 2340 | 16384 | NULL | 32768 | 0 | 2014-08-19 12:05:50 | NULL | NULL | NULL | | | NULL |
| def | test | charTest | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 0 | 0 | 2014-08-12 10:38:45 | NULL | NULL | NULL | | | NULL |
| def | test | customers | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-12 16:23:15 | NULL | NULL | NULL | | | NULL |
| def | test | dept_manager | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 24 | 682 | 16384 | NULL | 0 | 0 | 2014-08-14 11:31:58 | NULL | NULL | NULL | | | NULL |
| def | test | emp | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 7 | 2340 | 16384 | NULL | 0 | 0 | 2014-08-15 10:23:20 | NULL | NULL | NULL | | | NULL |
| def | test | employees | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 300380 | 50 | 15220736 | NULL | 0 | 0 | 2014-08-10 10:42:02 | NULL | NULL | NULL | | | NULL |
| def | test | g | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 9 | 1820 | 16384 | NULL | 0 | 0 | 2014-08-14 18:36:24 | NULL | NULL | NULL | | | NULL |
| def | test | indext | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 6 | 2730 | 16384 | NULL | 16384 | 0 | 2014-08-19 11:59:03 | NULL | NULL | NULL | | | NULL |
| def | test | mintable | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 7 | 2340 | 16384 | NULL | 0 | 0 | 2014-08-15 10:08:10 | NULL | NULL | NULL | | | NULL |
| def | test | new_emp | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 266 | 246 | 65536 | NULL | 0 | 0 | 2014-08-13 11:10:57 | NULL | NULL | NULL | | | NULL |
| def | test | orders | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 7 | 2340 | 16384 | NULL | 0 | 0 | 2014-08-12 16:26:24 | NULL | NULL | NULL | | | NULL |
| def | test | part1 | p0 | NULL | 1 | NULL | RANGE | NULL | id | NULL | 10 | 1 | 16384 | 16384 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | part1 | p1 | NULL | 2 | NULL | RANGE | NULL | id | NULL | 20 | 2 | 8192 | 16384 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | partion | p0 | NULL | 1 | NULL | HASH | NULL | col3 | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | partion | p1 | NULL | 2 | NULL | HASH | NULL | col3 | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | partion | p2 | NULL | 3 | NULL | HASH | NULL | col3 | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | partion | p3 | NULL | 4 | NULL | HASH | NULL | col3 | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | point | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 0 | 0 | 2014-08-17 20:40:19 | NULL | NULL | NULL | | | NULL |
| def | test | pp | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-17 09:53:09 | NULL | NULL | NULL | | | NULL |
| def | test | sales | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 11 | 1489 | 16384 | NULL | 0 | 0 | 2014-08-14 11:03:36 | NULL | NULL | NULL | | | NULL |
| def | test | sessions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16 | 1024 | 16384 | NULL | 32768 | 0 | 2014-08-11 12:32:59 | NULL | NULL | NULL | | | NULL |
| def | test | t | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10 | 1638 | 16384 | NULL | 0 | 0 | 2014-08-17 09:28:33 | NULL | NULL | NULL | | | NULL |
| def | test | test01 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-07-17 15:26:58 | 2014-08-10 10:25:53 | NULL | NULL | | | NULL |
| def | test | timetest | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-09 12:32:16 | NULL | NULL | NULL | | | NULL |
| def | test | tt | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-12 16:12:13 | NULL | NULL | NULL | | | NULL |
| def | test | ttt | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | NULL | 0 | 0 | 2014-08-12 16:48:17 | NULL | NULL | NULL | | | NULL |
| def | test | tttt | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 9 | 1820 | 16384 | NULL | 0 | 0 | 2014-08-17 09:36:46 | NULL | NULL | NULL | | | NULL |
| def | test | updatetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-09 12:34:16 | NULL | NULL | NULL | | | NULL |
| def | test | x | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | NULL | 0 | 0 | 2014-08-16 11:07:05 | NULL | NULL | NULL | | | NULL |
| def | test | xx | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8 | 2048 | 16384 | NULL | 0 | 0 | 2014-08-16 21:21:05 | NULL | NULL | NULL | | | NULL |
| def | test | y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-16 11:07:01 | NULL | NULL | NULL | | | NULL |
| def | test | yeartest | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-10 12:24:04 | NULL | NULL | NULL | | | NULL |
| def | test | yy | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-16 21:21:11 | NULL | NULL | NULL | | | NULL |
| def | test | z | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 6 | 2730 | 16384 | NULL | 0 | 0 | 2014-08-16 22:16:46 | NULL | NULL | NULL | | | NULL |
| def | test01 | auth_group | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-12 23:35:38 | NULL | NULL | NULL | | | NULL |
| def | test01 | auth_group_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-12 23:36:05 | NULL | NULL | NULL | | | NULL |
| def | test01 | auth_permission | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 24 | 682 | 16384 | NULL | 32768 | 0 | 2014-08-12 23:36:05 | NULL | NULL | NULL | | | NULL |
| def | test01 | auth_user | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 16384 | 0 | 2014-08-12 23:35:39 | NULL | NULL | NULL | | | NULL |
| def | test01 | auth_user_groups | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-12 23:36:06 | NULL | NULL | NULL | | | NULL |
| def | test01 | auth_user_user_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-12 23:36:06 | NULL | NULL | NULL | | | NULL |
| def | test01 | blog_blogpost | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-12 23:35:40 | NULL | NULL | NULL | | | NULL |
| def | test01 | django_admin_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8 | 2048 | 16384 | NULL | 32768 | 0 | 2014-08-12 23:40:03 | NULL | NULL | NULL | | | NULL |
| def | test01 | django_content_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8 | 2048 | 16384 | NULL | 16384 | 0 | 2014-08-12 23:35:40 | NULL | NULL | NULL | | | NULL |
| def | test01 | django_session | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 16384 | 0 | 2014-08-12 23:36:06 | NULL | NULL | NULL | | | NULL |
| def | test01 | django_site | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-12 23:35:40 | NULL | NULL | NULL | | | NULL |
+---------------+--------------------+----------------------------------------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+--------------------+--------------+-----------+---------------------+---------------------+---------------------+----------+-------------------+-----------+-----------------+
165 rows in set (0.11 sec)
mysql> select * from information_schema.PARTITIONS where table_schema=datebase() and table_name='part1';
ERROR 1305 (42000): FUNCTION test.datebase does not exist
mysql> select * from information_schema.PARTITIONS where table_schema=test() and table_name='part1';
ERROR 1305 (42000): FUNCTION test.test does not exist
mysql> select * from information_schema.PARTITIONS where table_schema=database() and table_name='part1';
+---------------+--------------+------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+-----------------+--------------+-----------+-------------+-------------+------------+----------+-------------------+-----------+-----------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION | SUBPARTITION_EXPRESSION | PARTITION_DESCRIPTION | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME |
+---------------+--------------+------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+-----------------+--------------+-----------+-------------+-------------+------------+----------+-------------------+-----------+-----------------+
| def | test | part1 | p0 | NULL | 1 | NULL | RANGE | NULL | id | NULL | 10 | 1 | 16384 | 16384 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | part1 | p1 | NULL | 2 | NULL | RANGE | NULL | id | NULL | 20 | 2 | 8192 | 16384 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
+---------------+--------------+------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+-----------------+--------------+-----------+-------------+-------------+------------+----------+-------------------+-----------+-----------------+
2 rows in set (0.01 sec)
mysql> select * from part1;
+------+
| id |
+------+
| 9 |
| 10 |
| 15 |
+------+
3 rows in set (0.00 sec)
mysql> #分别显示了一条和两条记录
mysql>
mysql> exit
mysql> #自适应哈西索引采用之前讨论的三列表的方式实现
mysql> #查看当前自适应哈西索引的使用情况
mysql> show engine innodb status;
+--------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Type | Name | Status |
+--------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| InnoDB | |
=====================================
140819 19:20:37 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 53 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1 1_second, 1 sleeps, 0 10_second, 1 background, 1 flush
srv_master_thread log flush and writes: 2
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2, signal count 2
Mutex spin waits 1, rounds 9, OS waits 0
RW-shared spins 2, rounds 60, OS waits 2
RW-excl spins 0, rounds 0, OS waits 0
Spin rounds per wait: 9.00 mutex, 30.00 RW-shared, 0.00 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 3E00
Purge done for trx's n:o < 3C13 undo n:o < 0
History list length 309
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 37, OS thread handle 0x7f45cfcc6700, query id 110 localhost root
show engine innodb status
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
575 OS file reads, 3 OS file writes, 3 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276707, node heap has 0 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 31842628
Log flushed up to 31842628
Last checkpoint at 31842628
0 pending log writes, 0 pending chkp writes
8 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 137363456; in additional pool allocated 0
Dictionary memory allocated 486546
Buffer pool size 8192
Free buffers 7628
Database pages 564
Old database pages 228
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 564, created 0, written 0
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 564, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 1103, id 139937775945472, state: waiting for server activity
Number of rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
|
+--------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> #分区
mysql> #分区是一种表的设计模式,正确的分区可以极大的提升数据库的查询效率,完成高质量的编程
mysql> #MySQL数据的分区是局部分区索引,一个分区中既存放数据又存放索引,全局分区是指数据存放在各个分区中,但是所有数据的索引放在一个对象中,目前,mysql不支持全局分区
mysql>
mysql> show variables like '%partition';
Empty set (0.00 sec)
mysql> show plugins;
+--------------------------+----------+--------------------+---------+---------+
| Name | Status | Type | Library | License |
+--------------------------+----------+--------------------+---------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| mysql_old_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL |
| BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
+--------------------------+----------+--------------------+---------+---------+
23 rows in set (0.00 sec)
mysql> #partition is active now
mysql> #mysql数据库支持以下几种类型的数据库
mysql> #range分区: 行数据基于属于一个给定连接连续区间的列值放入分区
mysql> #list分区和range分区一样,只是list分区面向的离散的值
mysql> #hash分区:根据用户自定义表达式的返回值来进行分区,返回值不能为负数
mysql> #key分区,根据mysql数据库提供的三列函数来进行分区
mysql> create table partion(
-> col1 int null,
-> col2 date null,
-> col3 int null,
-> col4 int null,
-> unique key (col1,col2,col3,col4))partition by hash(col3)
-> partitions 4;
ERROR 1046 (3D000): No database selected
mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> create table partion( col1 int null, col2 date null, col3 int null, col4 int null, unique key (col1,col2,col3,col4))partition by hash(col3) partitions 4;
Query OK, 0 rows affected (0.21 sec)
mysql> #唯一索引可以是null,并且只要求分区列是唯一索引的一个组成部分,不需要整个唯一索引都是分区列
mysql>
mysql> #现在介绍一个range分区
mysql> create table part1 (
-> id int)engine=innodb
-> partition by range(id)(
-> partition p0 values less then(10),
-> partition p1 values less then(20));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'then(10),
partition p1 values less then(20))' at line 4
mysql> create table part1 ( id int)engine=innodb partition by range(id)( partition p0 values less than(10), partition p1 values less than(20));
Query OK, 0 rows affected (0.12 sec)
mysql> #上面创建了一个分区,当id小于10时,将数据插入p0分区,当id小于20时,将数据插入p1分区。。。
mysql> insert into part1 select 9;
Query OK, 1 row affected (0.03 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> insert into part1 select 10;
Query OK, 1 row affected (0.03 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> insert into part1 select 15;
Query OK, 1 row affected (0.04 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> select * from information_schema.PARTITIONS;
+---------------+--------------------+----------------------------------------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+--------------------+--------------+-----------+---------------------+---------------------+---------------------+----------+-------------------+-----------+-----------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION | SUBPARTITION_EXPRESSION | PARTITION_DESCRIPTION | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME |
+---------------+--------------------+----------------------------------------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+--------------------+--------------+-----------+---------------------+---------------------+---------------------+----------+-------------------+-----------+-----------------+
| def | information_schema | CHARACTER_SETS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 384 | 0 | 16434816 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | COLLATIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 231 | 0 | 16704765 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 195 | 0 | 16357770 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | COLUMNS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | COLUMN_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2565 | 0 | 16757145 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | ENGINES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 490 | 0 | 16574250 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | EVENTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | FILES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2677 | 0 | 16758020 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | GLOBAL_STATUS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3268 | 0 | 16755036 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | GLOBAL_VARIABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3268 | 0 | 16755036 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | KEY_COLUMN_USAGE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 4637 | 0 | 16762755 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | PARAMETERS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | PARTITIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | PLUGINS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | PROCESSLIST | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | PROFILING | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 308 | 0 | 16562084 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | REFERENTIAL_CONSTRAINTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 4814 | 0 | 16767162 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | ROUTINES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | SCHEMATA | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3464 | 0 | 16738048 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | SCHEMA_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2179 | 0 | 16736899 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | SESSION_STATUS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3268 | 0 | 16755036 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | SESSION_VARIABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3268 | 0 | 16755036 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | STATISTICS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 5753 | 0 | 16752736 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | TABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 9450 | 0 | 16764300 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | TABLESPACES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 6951 | 0 | 16772763 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | TABLE_CONSTRAINTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2504 | 0 | 16721712 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | TABLE_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2372 | 0 | 16748692 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | TRIGGERS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | USER_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 1986 | 0 | 16726092 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | VIEWS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-08-19 19:59:42 | 2014-08-19 19:59:42 | NULL | NULL | | | NULL |
| def | information_schema | INNODB_BUFFER_PAGE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 6852 | 0 | 16766844 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_TRX | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 4534 | 0 | 16766732 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_BUFFER_POOL_STATS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 257 | 0 | 16332350 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_LOCK_WAITS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 599 | 0 | 16749238 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_CMPMEM | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 29 | 0 | 15204352 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_CMP | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 25 | 0 | 13107200 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_LOCKS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 31244 | 0 | 16746784 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_CMPMEM_RESET | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 29 | 0 | 15204352 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_CMP_RESET | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 25 | 0 | 13107200 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | information_schema | INNODB_BUFFER_PAGE_LRU | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 6669 | 0 | 16765866 | 0 | 0 | 2014-08-19 19:59:42 | NULL | NULL | NULL | | | NULL |
| def | csvt | auth_group | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-08 21:25:16 | NULL | NULL | NULL | | | NULL |
| def | csvt | auth_group_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-08 21:26:18 | NULL | NULL | NULL | | | NULL |
| def | csvt | auth_permission | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 21 | 780 | 16384 | NULL | 32768 | 0 | 2014-08-08 21:26:17 | NULL | NULL | NULL | | | NULL |
| def | csvt | auth_user | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-08 21:25:17 | NULL | NULL | NULL | | | NULL |
| def | csvt | auth_user_groups | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-08 21:26:18 | NULL | NULL | NULL | | | NULL |
| def | csvt | auth_user_user_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-08 21:26:18 | NULL | NULL | NULL | | | NULL |
| def | csvt | blog_employee | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | NULL | 0 | 0 | 2014-08-08 21:25:18 | NULL | NULL | NULL | | | NULL |
| def | csvt | django_content_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 7 | 2340 | 16384 | NULL | 16384 | 0 | 2014-08-08 21:25:17 | NULL | NULL | NULL | | | NULL |
| def | csvt | django_session | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-08 21:26:19 | NULL | NULL | NULL | | | NULL |
| def | csvt | django_site | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-08 21:25:18 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | auth_group | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-09 15:41:31 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | auth_group_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-09 15:42:09 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | auth_permission | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 24 | 682 | 16384 | NULL | 32768 | 0 | 2014-08-09 15:42:09 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | auth_user | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-09 15:41:32 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | auth_user_groups | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-09 15:42:10 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | auth_user_user_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-09 15:42:10 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | blog_blog | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | NULL | 16384 | 0 | 2014-08-09 15:53:11 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | blog_entry | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-09 15:53:10 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | django_content_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8 | 2048 | 16384 | NULL | 16384 | 0 | 2014-08-09 15:41:32 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | django_session | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-09 15:42:10 | NULL | NULL | NULL | | | NULL |
| def | csvt08 | django_site | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-09 15:41:32 | NULL | NULL | NULL | | | NULL |
| def | mysql | columns_priv | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 227994731135631359 | 4096 | 0 | 2014-07-28 16:04:05 | 2014-07-28 16:04:05 | NULL | NULL | | | NULL |
| def | mysql | db | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 123848989752688639 | 2048 | 0 | 2014-07-28 16:04:12 | 2014-07-28 16:04:12 | 2014-07-28 16:04:12 | NULL | | | NULL |
| def | mysql | event | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 2048 | 0 | 2014-07-28 16:04:11 | 2014-07-28 16:04:11 | NULL | NULL | | | NULL |
| def | mysql | func | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 162974011515469823 | 1024 | 0 | 2014-07-28 16:04:07 | 2014-07-28 16:04:07 | NULL | NULL | | | NULL |
| def | mysql | general_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | mysql | help_category | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 40 | 28 | 1120 | 281474976710655 | 3072 | 0 | 2014-07-17 15:23:26 | 2014-07-28 16:03:54 | NULL | NULL | | | NULL |
| def | mysql | help_keyword | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 467 | 197 | 91999 | 55450570411999231 | 17408 | 0 | 2014-07-17 15:23:26 | 2014-07-28 16:03:54 | NULL | NULL | | | NULL |
| def | mysql | help_relation | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1047 | 9 | 9423 | 2533274790395903 | 18432 | 0 | 2014-07-17 15:23:26 | 2014-07-28 16:03:54 | NULL | NULL | | | NULL |
| def | mysql | help_topic | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 511 | 927 | 474004 | 281474976710655 | 21504 | 0 | 2014-07-17 15:23:26 | 2014-07-28 16:03:54 | NULL | NULL | | | NULL |
| def | mysql | host | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 110056715893866495 | 2048 | 0 | 2014-07-28 16:04:12 | 2014-07-28 16:04:12 | NULL | NULL | | | NULL |
| def | mysql | ndb_binlog_index | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-07-17 15:23:27 | 2014-07-17 15:23:27 | NULL | NULL | | | NULL |
| def | mysql | plugin | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-07-28 16:04:07 | 2014-07-28 16:04:07 | NULL | NULL | | | NULL |
| def | mysql | proc | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 863 | 4316 | 281474976710655 | 4096 | 0 | 2014-07-28 16:04:10 | 2014-08-17 11:13:34 | NULL | NULL | | | NULL |
| def | mysql | procs_priv | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 239253730204057599 | 4096 | 0 | 2014-07-28 16:04:09 | 2014-07-28 16:04:09 | 2014-07-28 16:04:09 | NULL | | | NULL |
| def | mysql | proxies_priv | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 693 | 1386 | 195062158860484607 | 5120 | 0 | 2014-07-17 15:23:28 | 2014-07-17 15:23:28 | 2014-07-17 15:23:28 | NULL | | | NULL |
| def | mysql | servers | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 433752939111120895 | 1024 | 0 | 2014-07-17 15:23:26 | 2014-07-17 15:23:26 | NULL | NULL | | | NULL |
| def | mysql | slow_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | mysql | tables_priv | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 239535205180768255 | 4096 | 0 | 2014-07-28 16:04:05 | 2014-07-28 16:04:05 | 2014-07-28 16:04:05 | NULL | | | NULL |
| def | mysql | time_zone | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 1970324836974591 | 1024 | 0 | 2014-07-17 15:23:27 | 2014-07-17 15:23:27 | NULL | NULL | | | NULL |
| def | mysql | time_zone_leap_second | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 3659174697238527 | 1024 | 0 | 2014-07-17 15:23:27 | 2014-07-17 15:23:27 | NULL | NULL | | | NULL |
| def | mysql | time_zone_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 55450570411999231 | 1024 | 0 | 2014-07-17 15:23:26 | 2014-07-17 15:23:26 | NULL | NULL | | | NULL |
| def | mysql | time_zone_transition | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 4785074604081151 | 1024 | 0 | 2014-07-17 15:23:27 | 2014-07-17 15:23:27 | NULL | NULL | | | NULL |
| def | mysql | time_zone_transition_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 10696049115004927 | 1024 | 0 | 2014-07-17 15:23:27 | 2014-07-17 15:23:27 | NULL | NULL | | | NULL |
| def | mysql | user | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 97 | 488 | 281474976710655 | 2048 | 0 | 2014-07-28 16:04:12 | 2014-07-28 16:04:12 | NULL | NULL | | | NULL |
| def | performance_schema | cond_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | events_waits_current | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | events_waits_history | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | events_waits_history_long | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | events_waits_summary_by_instance | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | events_waits_summary_by_thread_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | events_waits_summary_global_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | file_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | file_summary_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | file_summary_by_instance | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | mutex_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | performance_timers | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | rwlock_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | setup_consumers | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | setup_instruments | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | setup_timers | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | performance_schema | threads | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | | NULL |
| def | photo | auth_group | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-18 16:40:47 | NULL | NULL | NULL | | | NULL |
| def | photo | auth_group_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-18 16:41:08 | NULL | NULL | NULL | | | NULL |
| def | photo | auth_permission | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 27 | 606 | 16384 | NULL | 32768 | 0 | 2014-08-18 16:41:08 | NULL | NULL | NULL | | | NULL |
| def | photo | auth_user | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 16384 | 0 | 2014-08-18 16:40:48 | NULL | NULL | NULL | | | NULL |
| def | photo | auth_user_groups | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-18 16:41:09 | NULL | NULL | NULL | | | NULL |
| def | photo | auth_user_user_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-18 16:41:09 | NULL | NULL | NULL | | | NULL |
| def | photo | blog_item | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-18 16:40:49 | NULL | NULL | NULL | | | NULL |
| def | photo | blog_photo | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 16384 | 0 | 2014-08-18 16:41:10 | NULL | NULL | NULL | | | NULL |
| def | photo | django_admin_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 32768 | 0 | 2014-08-18 16:41:10 | NULL | NULL | NULL | | | NULL |
| def | photo | django_content_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 9 | 1820 | 16384 | NULL | 16384 | 0 | 2014-08-18 16:40:48 | NULL | NULL | NULL | | | NULL |
| def | photo | django_session | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 16384 | 0 | 2014-08-18 16:41:10 | NULL | NULL | NULL | | | NULL |
| def | photo | django_site | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-18 16:40:49 | NULL | NULL | NULL | | | NULL |
| def | test | MonthlyOrders | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 23 | 712 | 16384 | NULL | 0 | 0 | 2014-08-16 10:30:21 | NULL | NULL | NULL | | | NULL |
| def | test | Nums | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 512 | 32 | 16384 | NULL | 0 | 0 | 2014-08-11 20:43:15 | NULL | NULL | NULL | | | NULL |
| def | test | a | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | NULL | 0 | 0 | 2014-08-09 12:08:49 | NULL | NULL | NULL | | | NULL |
| def | test | aa | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-18 08:04:49 | NULL | NULL | NULL | | | NULL |
| def | test | animals | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | NULL | 16384 | 0 | 2014-08-13 10:15:46 | NULL | NULL | NULL | | | NULL |
| def | test | back | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | NULL | 0 | 0 | 2014-08-17 20:31:14 | NULL | NULL | NULL | | | NULL |
| def | test | buy_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 7 | 2340 | 16384 | NULL | 32768 | 0 | 2014-08-19 12:05:50 | NULL | NULL | NULL | | | NULL |
| def | test | charTest | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 0 | 0 | 2014-08-12 10:38:45 | NULL | NULL | NULL | | | NULL |
| def | test | customers | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-12 16:23:15 | NULL | NULL | NULL | | | NULL |
| def | test | dept_manager | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 24 | 682 | 16384 | NULL | 0 | 0 | 2014-08-14 11:31:58 | NULL | NULL | NULL | | | NULL |
| def | test | emp | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 7 | 2340 | 16384 | NULL | 0 | 0 | 2014-08-15 10:23:20 | NULL | NULL | NULL | | | NULL |
| def | test | employees | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 300380 | 50 | 15220736 | NULL | 0 | 0 | 2014-08-10 10:42:02 | NULL | NULL | NULL | | | NULL |
| def | test | g | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 9 | 1820 | 16384 | NULL | 0 | 0 | 2014-08-14 18:36:24 | NULL | NULL | NULL | | | NULL |
| def | test | indext | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 6 | 2730 | 16384 | NULL | 16384 | 0 | 2014-08-19 11:59:03 | NULL | NULL | NULL | | | NULL |
| def | test | mintable | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 7 | 2340 | 16384 | NULL | 0 | 0 | 2014-08-15 10:08:10 | NULL | NULL | NULL | | | NULL |
| def | test | new_emp | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 266 | 246 | 65536 | NULL | 0 | 0 | 2014-08-13 11:10:57 | NULL | NULL | NULL | | | NULL |
| def | test | orders | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 7 | 2340 | 16384 | NULL | 0 | 0 | 2014-08-12 16:26:24 | NULL | NULL | NULL | | | NULL |
| def | test | part1 | p0 | NULL | 1 | NULL | RANGE | NULL | id | NULL | 10 | 1 | 16384 | 16384 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | part1 | p1 | NULL | 2 | NULL | RANGE | NULL | id | NULL | 20 | 2 | 8192 | 16384 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | partion | p0 | NULL | 1 | NULL | HASH | NULL | col3 | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | partion | p1 | NULL | 2 | NULL | HASH | NULL | col3 | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | partion | p2 | NULL | 3 | NULL | HASH | NULL | col3 | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | partion | p3 | NULL | 4 | NULL | HASH | NULL | col3 | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | point | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 0 | 0 | 2014-08-17 20:40:19 | NULL | NULL | NULL | | | NULL |
| def | test | pp | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-17 09:53:09 | NULL | NULL | NULL | | | NULL |
| def | test | sales | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 11 | 1489 | 16384 | NULL | 0 | 0 | 2014-08-14 11:03:36 | NULL | NULL | NULL | | | NULL |
| def | test | sessions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16 | 1024 | 16384 | NULL | 32768 | 0 | 2014-08-11 12:32:59 | NULL | NULL | NULL | | | NULL |
| def | test | t | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10 | 1638 | 16384 | NULL | 0 | 0 | 2014-08-17 09:28:33 | NULL | NULL | NULL | | | NULL |
| def | test | test01 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2014-07-17 15:26:58 | 2014-08-10 10:25:53 | NULL | NULL | | | NULL |
| def | test | timetest | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-09 12:32:16 | NULL | NULL | NULL | | | NULL |
| def | test | tt | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-12 16:12:13 | NULL | NULL | NULL | | | NULL |
| def | test | ttt | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | NULL | 0 | 0 | 2014-08-12 16:48:17 | NULL | NULL | NULL | | | NULL |
| def | test | tttt | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 9 | 1820 | 16384 | NULL | 0 | 0 | 2014-08-17 09:36:46 | NULL | NULL | NULL | | | NULL |
| def | test | updatetime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-09 12:34:16 | NULL | NULL | NULL | | | NULL |
| def | test | x | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | NULL | 0 | 0 | 2014-08-16 11:07:05 | NULL | NULL | NULL | | | NULL |
| def | test | xx | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8 | 2048 | 16384 | NULL | 0 | 0 | 2014-08-16 21:21:05 | NULL | NULL | NULL | | | NULL |
| def | test | y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-16 11:07:01 | NULL | NULL | NULL | | | NULL |
| def | test | yeartest | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-10 12:24:04 | NULL | NULL | NULL | | | NULL |
| def | test | yy | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-16 21:21:11 | NULL | NULL | NULL | | | NULL |
| def | test | z | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 6 | 2730 | 16384 | NULL | 0 | 0 | 2014-08-16 22:16:46 | NULL | NULL | NULL | | | NULL |
| def | test01 | auth_group | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 16384 | 0 | 2014-08-12 23:35:38 | NULL | NULL | NULL | | | NULL |
| def | test01 | auth_group_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-12 23:36:05 | NULL | NULL | NULL | | | NULL |
| def | test01 | auth_permission | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 24 | 682 | 16384 | NULL | 32768 | 0 | 2014-08-12 23:36:05 | NULL | NULL | NULL | | | NULL |
| def | test01 | auth_user | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 16384 | 0 | 2014-08-12 23:35:39 | NULL | NULL | NULL | | | NULL |
| def | test01 | auth_user_groups | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-12 23:36:06 | NULL | NULL | NULL | | | NULL |
| def | test01 | auth_user_user_permissions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | NULL | 49152 | 0 | 2014-08-12 23:36:06 | NULL | NULL | NULL | | | NULL |
| def | test01 | blog_blogpost | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | NULL | 0 | 0 | 2014-08-12 23:35:40 | NULL | NULL | NULL | | | NULL |
| def | test01 | django_admin_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8 | 2048 | 16384 | NULL | 32768 | 0 | 2014-08-12 23:40:03 | NULL | NULL | NULL | | | NULL |
| def | test01 | django_content_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8 | 2048 | 16384 | NULL | 16384 | 0 | 2014-08-12 23:35:40 | NULL | NULL | NULL | | | NULL |
| def | test01 | django_session | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 16384 | 0 | 2014-08-12 23:36:06 | NULL | NULL | NULL | | | NULL |
| def | test01 | django_site | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 16384 | 16384 | NULL | 0 | 0 | 2014-08-12 23:35:40 | NULL | NULL | NULL | | | NULL |
+---------------+--------------------+----------------------------------------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+--------------------+--------------+-----------+---------------------+---------------------+---------------------+----------+-------------------+-----------+-----------------+
165 rows in set (0.11 sec)
mysql> select * from information_schema.PARTITIONS where table_schema=datebase() and table_name='part1';
ERROR 1305 (42000): FUNCTION test.datebase does not exist
mysql> select * from information_schema.PARTITIONS where table_schema=test() and table_name='part1';
ERROR 1305 (42000): FUNCTION test.test does not exist
mysql> select * from information_schema.PARTITIONS where table_schema=database() and table_name='part1';
+---------------+--------------+------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+-----------------+--------------+-----------+-------------+-------------+------------+----------+-------------------+-----------+-----------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION | SUBPARTITION_EXPRESSION | PARTITION_DESCRIPTION | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME |
+---------------+--------------+------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+-----------------+--------------+-----------+-------------+-------------+------------+----------+-------------------+-----------+-----------------+
| def | test | part1 | p0 | NULL | 1 | NULL | RANGE | NULL | id | NULL | 10 | 1 | 16384 | 16384 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
| def | test | part1 | p1 | NULL | 2 | NULL | RANGE | NULL | id | NULL | 20 | 2 | 8192 | 16384 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | | default | NULL |
+---------------+--------------+------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+-----------------+--------------+-----------+-------------+-------------+------------+----------+-------------------+-----------+-----------------+
2 rows in set (0.01 sec)
mysql> select * from part1;
+------+
| id |
+------+
| 9 |
| 10 |
| 15 |
+------+
3 rows in set (0.00 sec)
mysql> #分别显示了一条和两条记录
mysql>
mysql> exit
0 0
- mysql的使用24
- MYSQL的基础使用
- mysql的SQL_CALC_FOUND_ROWS 使用
- MySQL触发器的使用
- MySQL的使用
- MySQL触发器的使用
- mysql的SQL_CALC_FOUND_ROWS 使用
- MYSQL的初级使用
- mysql 游标的使用
- mysql的使用问题
- mysql 游标的使用
- 使用MySQL的LAST_INSERT_ID
- MySQL触发器的使用
- 使用MySQL的LAST_INSERT_ID
- Mysql 触发器的使用
- MySQL触发器的使用
- MYSQL索引的使用
- 使用MySQL的LAST_INSERT_ID
- mysql的使用23
- 结合使用 MongoDB 和 Django
- 浏览器端cookie的取值和设值
- 数据类型
- 傅利叶级数
- mysql的使用24
- Linux负载均衡软件LVS
- 关于win7下修改hosts文件提示无法保存的问题
- LinearLayout中组件右对齐
- Linux网络编程(1):TCP客户服务程序设计
- 通过excel向数据库(ORACLE)里插入数据
- mysql的使用25
- spring与mybatis整合的事务问题记录
- 九度_题目1514:数值的整数次方