Hi,
Whilst you may have space on the box, you may have reached a file size limit
on whatever OS you're using (on some linux versions, the max size of a file
in 4GB and similar on some windows versions)
It may also be a mysql limit on data length. Check the status of your table
like this:
mysql> show table status like 'users'\G
*************************** 1. row ***************************
Name: users
Type: MyISAM
Row_format: Dynamic
Rows: 42
Avg_row_length: 95
Data_length: 4140
Max_data_length: 4294967295
Index_length: 2048
Data_free: 128
Auto_increment: NULL
Create_time: 2003-09-02 13:31:53
Update_time: 2004-01-22 14:29:28
Check_time: NULL
Create_options:
Comment:
1 row in set (0.01 sec)
Look at the Data_length and Max_data_length and see if you've reached that
limit.
If you don't specify MAX_ROWS to CREATE TABLE MySQL will only allocate
pointers to hold 4G of data.
Hope this helps,
Cheers,
Andrew
-----Original Message-----
From: Mike Mapsnac [mailto:[EMAIL PROTECTED]
Sent: Saturday 31 January 2004 12:04
To: [EMAIL PROTECTED]
Subject: Slave crashed: error 'The table 'users' is full' on query..
I have more than enough space on the box.
At the beginnig I check table status and got no error messages. Any ideas
what can cause such error.
I use mysql 4-0.13.
The documentation http://www.mysql.com/doc/en/Full_table.html refer to older
version of mysql.
Any ideas how to fix the problem?
_________________________________________________________________
Let the new MSN Premium Internet Software make the most of your high-speed
experience. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1
--
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]