MySQL on Mandrake 9 with EXT3 File system... Max Size?

2003-02-19 Thread Shannon Wynter
Hi, this is my first post here, I hope it's easily answered I've got Mandrake Linux 9, with the ext3 file system What is the absolute maximum table size I can have? And what do I need to change to achive that? I've spent half the night googling, and couldn't find a real answer so now I

Re: MySQL on Mandrake 9 with EXT3 File system... Max Size?

2003-02-19 Thread Veysel Harun Sahin
You can see your max table size at the row Max datafile length: 4294967294. This means that your UsedData table's max size is 4G. If you want to change it you have to use alter table command with the option max_rows. For example ALTER TABLE UsedData MAX_ROWS = 100. [EMAIL PROTECTED]