Simon, If your tables are too big, you want to archive/delete some information. I certainly cannot guide you on what to delete.
What you describe below isn't going to do anything. From the documentation (http://dev.mysql.com/doc/refman/5.0/en/create-table.html): ---------------------------------------------------- MAX_ROWS The maximum number of rows you plan to store in the table. This is not a hard limit, but rather an indicator that the table must be able to store at least this many rows. ---------------------------------------------------- So you'll still hit up on your 4GB limit. What you need to do is delete data from your large table(s), or, if you need all the data accessible, split your larger table out into smaller tables. Seeing as I have no idea what kind of data you have, I can't really suggest anything other than that. -Sheeri On 11/17/05, Simon <[EMAIL PROTECTED]> wrote: > Hi There, > > We are reaching 4GB with one of our tables (v4.1 on debian sarge) and > are needing to run: > > ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; > > as per the documentation.. I would be greatful for any input on best > practices to do this, as the database needs to be offline for the > absolute minimal amount of time.... so the fastest process that i can > think of would be: > > 1). Backup everything! :) > 2). mysqldump the table to a file > 3). drop the table > 4). recreate the table structure > 5). do the alter > 6). import the data back in > > Other questions are... can the alter be done to live data? how does this > work? > > Simon > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
