As it looks like no one else has replied. The default table size is 4GB - effectively if you do not modify the table create statement this is the size you get.
To alter the table size you need to change the value of the MAX_ROWS parameter. The table size is governed by MAX_ROWS multiplied by average row length. SHOW TABLE STATUS will get you the average row length or 'properties' in mysqlcc. My advice is to rename you existing table and then do a create table <definition> MAX_ROWS=nnnnnnnnn as select <columns) from renamed table. Alternatively use mysqldump to dump the table, drop the version on the database, edit the .txt to add the MAX_ROWS parameter to the create statement and then re-import. Changing the table using the ALTER TABLE command will take forever. Full details of the MAX_ROWS parameter can be found in the manual under the CREATE TABLE command. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] > -----Original Message----- > From: V. Agarwal [mailto:[EMAIL PROTECTED] > Sent: 30 April 2005 14:46 > To: mysql@lists.mysql.com > Subject: Mysql 4.1.1 on Linux table size limit of 4GB and grant priv for > Load > > Hi, > I am using Mysql built-in defaults for starting the > server. It chokes when the table size grows to 4GB in > data directory. > What parameter needs to be tweaked for allowing larger > size tables ? > =========== > -rw-rw---- 1 vagarwal dev 4294967284 Apr 29 > 22:33 crec.MYD > -rw-rw---- 1 vagarwal dev 950261760 Apr 29 > 23:22 crec.MYI > ============ > > I created a user and granted all priviledges on a > given database but it still does not allow 'load data > infile ...' command to that user. Any clues ? > ========= > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] ************************************************************************************** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000 Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ************************************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
