MYSQL INNODB limits

Golith · #1 (**permalink**) 12-21-11, 10:07 PM

hi ppl,
Merry Xmas!

A quick Q .. I have a DB that holds the daily data for the Dow jones .. the table seems to throw an error at around row 25,000 .. it goes from having the correct data inserted to this

Quote:

5/06/1987 984.590 993.780 979.790 986.660
8/06/1987 986.660 999.999 979.150 999.999
9/06/1987 999.999 999.999 996.760 999.999
10/06/1987 999.999 999.999 999.999 999.999

each cell for numbers is set as
float(6,3)

i can only think i am hitting some kind of limit.

Any ideas?

TY

alxkls · #2 (**permalink**) 12-22-11, 04:08 AM

there could be a limit. look at the my.ini/my.cnf configuration

Golith · #3 (**permalink**) 12-23-11, 10:34 AM

TY,
Found my issue .. the data type i was using was a float 6,6 but the data was of type double to allow for big floats.

Have a merry Xmas
P.S I see ppl report they have 100's of tables with over 3 billion rows with indexing.