| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -277,9 +277,9 @@ |
| 278 | 278 | INDEX user_timestamp (rev_user,rev_timestamp), |
| 279 | 279 | INDEX usertext_timestamp (rev_user_text,rev_timestamp) |
| 280 | 280 | |
| 281 | | -) TYPE=InnoDB; |
| | 281 | +) TYPE=InnoDB MAX_ROWS=10000000 AVG_ROW_LENGTH=1024; |
| | 282 | +-- In case tables are created as MyISAM, use row hints for MySQL <5.0 to avoid 4GB limit |
| 282 | 283 | |
| 283 | | - |
| 284 | 284 | -- |
| 285 | 285 | -- Holds text of individual page revisions. |
| 286 | 286 | -- |
| — | — | @@ -313,7 +313,8 @@ |
| 314 | 314 | |
| 315 | 315 | PRIMARY KEY old_id (old_id) |
| 316 | 316 | |
| 317 | | -) TYPE=InnoDB; |
| | 317 | +) TYPE=InnoDB MAX_ROWS=10000000 AVG_ROW_LENGTH=10240; |
| | 318 | +-- In case tables are created as MyISAM, use row hints for MySQL <5.0 to avoid 4GB limit |
| 318 | 319 | |
| 319 | 320 | -- |
| 320 | 321 | -- Holding area for deleted articles, which may be viewed |