Limitation exists on MySQL information storage.

There have few limitations exist on MySQL. As the database storage engine cannot have more than 64 indexes per MyISAM table. In this project, the limitation on index is not affects on application development. Cause less than 5 indexes has been created in each tale, so it doesn’t breach the limitation. In term of the key length limitation, in this project the key length under 50 bytes, this length doesn’t breach the MySQL limitation on “Maximum 1000 bytes on key length”. Even the combination key index length also under the MySQL limitation on “Maximum 16 columns pre index”, in this project the combination key index created by less than 3 columns that also not deal on that limitation.

For the table relationship, MySQL have few limitations on create table relationship. The limitations on InnoDB storage engine have this limitation:

• Maximum 1000 columns per table
• Maximum 64 TB table space per table
• Total of row length is 4GB

In this project, there are less than 50 columns in all the tables. No deal with the first limitation. In term of table space limitation, table space increasing will not over 64 TB per table at next 3 years because of data type majority used “tinyint”, “bit”, “datetime” and “char” on 8 letters fixed size or “varchar” on 100 letters, few in “double”. Roughly, the lengths will less than 3 Kbytes information space per record. The amount space requires on table will not over 64 TB at next three years. Therefore, there is no deal with the second limitation. At the last limitation, the total of row length in this project less than 3 Kbytes. I believe this length also no deal with the third limitation on InnoDB storage engine’s limitation.