Datafile is almost full (Post table)
Posted in: zjnq.com Date: March 13th, 2010
mysql> show table status like 'post';
+------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
+------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
post MyISAM 9 Dynamic 5855639 691 4107417272 4294967295 168821760 58291428 6253042 2007-01-19 01:58:43 2008-06-20 06:19:52 2008-06-20 03:03:23 latin1_swedish_ci NULL
+------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
1 row in set (0.01 sec)
After reading around I found that I can alter the post table to increase the max_data_lenght with this command:
alter table post max_rows = 1000000000 avg_row_length = 691;
Do I just issue that command and that's it? I am concerned about the filesize limit of the system, is it 4GB size limit? How do I find out the max limit size of the file system.
Uname -a gave me this:
uname -a
Linux control.host 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:54:53 EST 2006 i686 i686 i386 GNU/Linux
Please help.
Then, run this:
USE YourvBulletinDatabaseName;
ALTER TABLE post max_rows = 200000000000 avg_row_length = 100;
However, even if you have a table with rows that are 10 times as large, you're still limited to roughly 4.2 billion rows. That is a 32bits hardware limitation, there is nothing you can do about it.
You MUST upgrade your OS, PHP and MySQL to 64bits.
Then you will not have those issues anymore. Just to give you an example, in PHP the max INT value is 2147483647 for 32bits and 9223372036854775807 for 64bits. You figure which one will accommodate you better. :)
Thanks for the reply. I will go ahead and issue the command.
However, even if you have a table with rows that are 10 times as large, you're still limited to roughly 4.2 billion rows. That is a 32bits hardware limitation, there is nothing you can do about it.
I am not close to that number of rows yet. When it comes I will worry about it then.
You MUST upgrade your OS, PHP and MySQL to 64bits.
Then you will not have those issues anymore. Just to give you an example, in PHP the max INT value is 2147483647 for 32bits and 9223372036854775807 for 64bits. You figure which one will accommodate you better. :)
9223372036854775807 <-- :eek: I cann't even read the number.
#If you have any other info about this subject , Please add it free.# |
