What is the maximum number of rows and columns in MYSQL table database.

[Peter910]

Brothers in the house.

I plan developing an online database application with PHP and MYSQL. In my database design structure, I plan to have maximum of 50 columns and maximum of 20,000 rows in a certain table.

But then I will to like have the experience of the members in the house. What exactly is the maximum number of rows and columns in a MYSQL database table. I will be glad to receive if there is any other restriction(s)/limit(s) attached to number of rows and columns in a database.

Thank you for your contributions.

Peter.

[JKing]

Both of these will depend on which storage engine you choose to use and what kind of data you are storing.

For the columns you can go here: Column Count Limit

If you are just storing mostly text and integers you really have nothing to worry about. 50 Columns and 200,000 rows really isn't all that much and shouldn't be a problem.

For example the MyISAM engine(default engine) can store by default 2^32 rows. That's 4,294,967,296 rows. That's a lot of rows! That can be extended to 2^64 by setting some options during the build.

[kovik]

I'd imagine you could extend your database to hold as much data as you want. On the lowest level, your data is stored in files. If you have space on your file system for it, then you should be able to extend your limits as far as you have space for.

[Peter910]

Dear JKing and kovik, Thank you for the tutor and the reference. I got a good material on the reference

http://dev.mysql.com/doc/refman/5.0/...unt-limit.html.

I appreciate u brothers.

[wizardry]

i would split those columns out no more then 30 if at all possible. just think of your model as a giant 3d jig saw puzzle.

split = ( if the data is relevant and can be used/access more then once ( more redundant designs ) )

here is an article on redundancy:

http://www.databasedev.co.uk/data-redundancy.html

best of luck!