MySQL number of rows in a column

[flairview]

Hi,

I have small problem with mysql, i have a large database and one table suppose to have 70 000 rows unfortunately it fits only 65535, i can't add more its seems to be a limit. Is this a hosting setting or is this just a MySQL (or any database) limit?

Thanks,

fv

[slade7]

Hmm - that happens to be the maximum number of rows that will fit into an Excel spreadsheet.

[rlkanter]

Is the index on table an unsigned smallint by chance?

I can't think of a setting that has to be changed to raise the number of entries in a table above that number.

I have a few tables that have 100k+ entries.

[bakedjake]

I'm staring at a mySQL table with 3.2 million rows in front of me.

Sure you're not seeing an Excel problem? I'm inclined to agree with the second poster.

[coopster]

Welcome to WebmasterWorld, flairview.

The folks here have already given you a couple things to look into (and answer). bakedjake is correct, that amount of rows is nothing for MySQL to handle, but perhaps you have built yourself into some form of limitation inadvertently as suggested by rlkanter.

For the record...

MySQL Server was originally designed to work with medium size databases (10-100 million rows, or about 100MB per table) on small computer systems. Today MySQL Server handles terabyte-size databases, but the code can also be compiled in a reduced version suitable for hand-held and embedded devices. The compact design of the MySQL server makes development in both directions possible without any conflicts in the source tree.

Resource:
[dev.mysql.com...]

[flairview]

Thanks guys, yep the index is an UNSIGNED smallint.

fv