用户名: 密码: 忘记密码? 注册

mediawki 数据库表分析之page

作者:  时间: 2010-10-14
mysql> desc page;
+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| page_id           | int(8) unsigned     | NO   | PRI | NULL    | auto_increment |
| page_namespace    | int(11)             | NO   | MUL | NULL    |                |
| page_title        | varchar(255)        | NO   |     | NULL    |                |
| page_restrictions | tinyblob            | NO   |     | NULL    |                |
| page_counter      | bigint(20) unsigned | NO   |     | 0       |                |
| page_is_redirect  | tinyint(1) unsigned | NO   |     | 0       |                |
| page_is_new       | tinyint(1) unsigned | NO   |     | 0       |                |
| page_random       | double unsigned     | NO   | MUL | NULL    |                |
| page_touched      | char(14)            | NO   |     |         |                |
| page_latest       | int(8) unsigned     | NO   |     | NULL    |                |
| page_len          | int(8) unsigned     | NO   | MUL | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+
11 rows in set (0.18 sec)

mysql> select * from page where page_title like '一个查找引起%';
+---------+----------------+---------------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
| page_id | page_namespace | page_title                            | page_restrictions | page_counter | page_is_redirect | page_is_new | page_random    | page_touched   | page_latest | page_len |
+---------+----------------+---------------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
|    9968 |              0 | 一个查找引起latch_free的脚本          |                   |           16 |                0 |           1 | 0.909641285984 | 20090409164502 |       17533 |      726 |
+---------+----------------+---------------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
1 row in set (0.12 sec)