Project

General

Profile

Defect #5683 ยป table_status.txt

table status - Kazuki Kudo, 2010-06-22 03:01

 
1
+-------------------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+-----------------------+
2
| Name                                | Engine | Version | Row_format | Rows    | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time | Check_time | Collation       | Checksum | Create_options | Comment               |
3
+-------------------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+-----------------------+
4
| attachments                         | InnoDB |      10 | Compact    |    3388 |            469 |     1589248 |               0 |       344064 |         0 |           3814 | 2010-06-10 10:08:37 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 4096 kB  | 
5
| auth_sources                        | InnoDB |      10 | Compact    |       1 |          16384 |       16384 |               0 |        16384 |         0 |              2 | 2010-06-10 10:07:50 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
6
| boards                              | InnoDB |      10 | Compact    |       7 |           2340 |       16384 |               0 |        32768 |         0 |              8 | 2010-06-10 10:07:56 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
7
| changes                             | InnoDB |      10 | Compact    | 3450672 |            140 |   485425152 |               0 |     47792128 |         0 |      305864965 | 2010-06-10 10:03:35 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 13312 kB | 
8
| changesets                          | InnoDB |      10 | Compact    |   36785 |            699 |    25739264 |               0 |      8994816 |         0 |         793873 | 2010-06-10 10:08:42 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 7168 kB  | 
9
| changesets_issues                   | InnoDB |      10 | Compact    |     167 |             98 |       16384 |               0 |            0 |         0 |           NULL | 2010-06-10 10:05:42 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
10
| comments                            | InnoDB |      10 | Compact    |       0 |              0 |       16384 |               0 |        32768 |         0 |              1 | 2010-06-10 10:07:47 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
11
| custom_fields                       | InnoDB |      10 | Compact    |      79 |            622 |       49152 |               0 |        16384 |         0 |             74 | 2010-06-10 10:08:11 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
12
| custom_fields_projects              | InnoDB |      10 | Compact    |    1631 |             50 |       81920 |               0 |        49152 |         0 |           NULL | 2010-06-10 10:07:47 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
13
| custom_fields_trackers              | InnoDB |      10 | Compact    |     145 |            112 |       16384 |               0 |        16384 |         0 |           NULL | 2010-06-10 10:08:26 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
14
| custom_values                       | InnoDB |      10 | Compact    |  260983 |             54 |    14172160 |               0 |     14712832 |         0 |         311302 | 2010-06-10 10:08:18 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 5120 kB  | 
15
| documents                           | InnoDB |      10 | Compact    |     131 |           1250 |      163840 |               0 |        49152 |         0 |            147 | 2010-06-10 10:08:37 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
16
| enabled_modules                     | InnoDB |      10 | Compact    |     919 |             89 |       81920 |               0 |        16384 |         0 |           1515 | 2010-06-10 10:05:47 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
17
| enumerations                        | InnoDB |      10 | Compact    |      23 |            712 |       16384 |               0 |        32768 |         0 |             26 | 2010-06-10 10:08:38 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
18
| groups_users                        | InnoDB |      10 | Compact    |       0 |              0 |       16384 |               0 |            0 |         0 |           NULL | 2010-06-10 10:07:46 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
19
| issue_categories                    | InnoDB |      10 | Compact    |     571 |            114 |       65536 |               0 |        32768 |         0 |            653 | 2010-06-10 10:07:56 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
20
| issue_relations                     | InnoDB |      10 | Compact    |    2607 |             62 |      163840 |               0 |       212992 |         0 |           3176 | 2010-06-10 10:08:25 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
21
| issue_statuses                      | InnoDB |      10 | Compact    |      27 |            606 |       16384 |               0 |        49152 |         0 |             30 | 2010-06-10 10:08:38 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
22
| issues                              | InnoDB |      10 | Compact    |   17502 |           1528 |    26755072 |               0 |      2916352 |         0 |          15914 | 2010-06-10 10:08:36 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 4096 kB  | 
23
| journal_details                     | InnoDB |      10 | Compact    |   90849 |             63 |     5783552 |               0 |      1589248 |         0 |          93034 | 2010-06-10 10:05:50 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 4096 kB  | 
24
| journals                            | InnoDB |      10 | Compact    |   64865 |            510 |    33095680 |               0 |      8454144 |         0 |          65896 | 2010-06-10 10:08:30 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 5120 kB  | 
25
| member_roles                        | InnoDB |      10 | Compact    |    2899 |             39 |      114688 |               0 |       131072 |         0 |           2314 | 2010-06-10 10:07:56 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
26
| members                             | InnoDB |      10 | Compact    |    2353 |             55 |      131072 |               0 |       147456 |         0 |           2475 | 2010-06-10 10:08:11 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
27
| messages                            | InnoDB |      10 | Compact    |       6 |           2730 |       16384 |               0 |        81920 |         0 |             10 | 2010-06-10 10:08:34 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
28
| news                                | InnoDB |      10 | Compact    |      94 |            697 |       65536 |               0 |        49152 |         0 |             85 | 2010-06-10 10:08:36 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
29
| open_id_authentication_associations | InnoDB |      10 | Compact    |       0 |              0 |       16384 |               0 |            0 |         0 |              1 | 2010-06-10 10:07:35 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
30
| open_id_authentication_nonces       | InnoDB |      10 | Compact    |       0 |              0 |       16384 |               0 |            0 |         0 |              1 | 2010-06-10 10:07:35 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
31
| plugin_schema_info                  | InnoDB |      10 | Compact    |       0 |              0 |       16384 |               0 |            0 |         0 |           NULL | 2010-06-10 10:05:56 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
32
| projects                            | InnoDB |      10 | Compact    |     171 |            287 |       49152 |               0 |        32768 |         0 |            144 | 2010-06-10 10:08:38 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
33
| projects_trackers                   | InnoDB |      10 | Compact    |    1043 |             47 |       49152 |               0 |        16384 |         0 |           NULL | 2010-06-10 10:07:37 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
34
| queries                             | InnoDB |      10 | Compact    |    1277 |            295 |      376832 |               0 |        98304 |         0 |           1514 | 2010-06-10 10:08:11 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
35
| repositories                        | InnoDB |      10 | Compact    |      32 |            512 |       16384 |               0 |        16384 |         0 |             93 | 2010-06-10 10:07:47 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
36
| roles                               | InnoDB |      10 | Compact    |       6 |           2730 |       16384 |               0 |            0 |         0 |              7 | 2010-06-10 10:05:57 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
37
| schema_migrations                   | InnoDB |      10 | Compact    |     167 |             98 |       16384 |               0 |            0 |         0 |           NULL | 2010-06-10 10:05:57 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
38
| settings                            | InnoDB |      10 | Compact    |      43 |            381 |       16384 |               0 |        16384 |         0 |             44 | 2010-06-10 10:08:38 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
39
| time_entries                        | InnoDB |      10 | Compact    |    5170 |             91 |      475136 |               0 |       655360 |         0 |           5077 | 2010-06-10 10:08:37 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 4096 kB  | 
40
| tokens                              | InnoDB |      10 | Compact    |    1090 |            105 |      114688 |               0 |        16384 |         0 |           1017 | 2010-06-10 10:07:50 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
41
| trackers                            | InnoDB |      10 | Compact    |       8 |           2048 |       16384 |               0 |            0 |         0 |             19 | 2010-06-10 10:05:57 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
42
| user_preferences                    | InnoDB |      10 | Compact    |     469 |            174 |       81920 |               0 |        16384 |         0 |            514 | 2010-06-10 10:07:56 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
43
| users                               | InnoDB |      10 | Compact    |     506 |            259 |      131072 |               0 |        32768 |         0 |            531 | 2010-06-10 10:08:12 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
44
| versions                            | InnoDB |      10 | Compact    |    1279 |            140 |      180224 |               0 |        98304 |         0 |           1283 | 2010-06-10 10:08:38 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
45
| watchers                            | InnoDB |      10 | Compact    |   37760 |             42 |     1589248 |               0 |      4767744 |         0 |          39372 | 2010-06-10 10:07:50 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 4096 kB  | 
46
| wiki_content_versions               | InnoDB |      10 | Compact    |    3570 |           1032 |     3686400 |               0 |       196608 |         0 |           3708 | 2010-06-10 10:08:39 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 4096 kB  | 
47
| wiki_contents                       | InnoDB |      10 | Compact    |    1026 |           1548 |     1589248 |               0 |        32768 |         0 |            725 | 2010-06-10 10:08:38 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 4096 kB  | 
48
| wiki_pages                          | InnoDB |      10 | Compact    |     679 |            120 |       81920 |               0 |        98304 |         0 |            725 | 2010-06-10 10:07:48 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
49
| wiki_redirects                      | InnoDB |      10 | Compact    |      32 |            512 |       16384 |               0 |        32768 |         0 |             36 | 2010-06-10 10:08:25 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
50
| wikis                               | InnoDB |      10 | Compact    |      65 |            252 |       16384 |               0 |        16384 |         0 |             72 | 2010-06-10 10:05:59 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 0 kB     | 
51
| workflows                           | InnoDB |      10 | Compact    |    6386 |             46 |      294912 |               0 |       802816 |         0 |          29661 | 2010-06-10 10:07:47 | NULL        | NULL       | utf8_general_ci |     NULL |                | InnoDB free: 4096 kB  | 
52
+-------------------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+-----------------------+
    (1-1/1)