sheeri kritzer wrote:
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
Sheeri,
I think you've missed the point. The 4Gb limit is in mysql, not the filesystem.
Mysql effectively doesn't limit tablesize, but the *default* pointer size
limits you to a max of about 4Gb in a MyISAM table. To have a larger table, you
need to tell mysql that it needs to use a larger pointer for that table, either
at table creation, or with an ALTER TABLE such as the one Simon is proposing to
run. See the last half of
<http://dev.mysql.com/doc/refman/5.0/en/table-size.html> for more.
Michael
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]
