Problem: The clew that “The Table Is Full” appears when the reply is published in forum, the meaning with data full already list is on literal meaning. Because rarely developer encounters onefold watch surpasses the case of 4G, because the discussion between this friend can provide the information of a few periphery only. To solve this problem, I browsed a lot of data, article general with me the settlement of this problem process, introduce the reason of problem happening and countermeasure.
According to experience, clew of The Table Is Full often appears in the following two kinds of circumstances:
1.MAX_ROWS value was set in the watch, say simply, if MAX_ROWS is installed for 100, and the program tries to keep the 101st record, can appear this mistake.
2.The list is full. This kind of circumstance is the key of article discussion
We think MySQL is in when accessing a watch, put in rule of a kind of fixed position allocation. This rule falls in acquiescent circumstance, can find the data of location 4G less than. Exceed this size, database will cannot locate to data, also cannot undertake reading writing consequently. Through the experiment, this limitation can be broken through completely.
In this exemple, the systematic environment of the user is memory of 72G of hard disk of double Athlon processor, SCSI, 2G, the dimension of card watch data of the user is 4294963640, the actual byte number that is close to 4G(4G is 4294967296) .
Above all after SSH logins, examine the systematic information of the user:
# Uname -a
Linux Zichen.com 2.4.20-8smp #1 SMP Thu Mar 13 16:43:01 EST 2003 I686 Athlon I386 GNU/Linux
The proof is Linux system, according to kernel version 2.4.20-8smp, add the common system that home uses, estimation should be luggage of Redhat 9 hair.
# Cat /etc/*release*
Red Hat Linux Release 9 (Shrike)
This also proved we are right of systematic version guess.
What look to use next is what file system. Because this user is not ace, when estimation is installing a system, be all the way carriage return comes down, redhat 9 is acquiescent should be EXT3, do not cross us or look:
# Parted
GNU Parted 1.6.3
Copyright (C) 1998, 1999, 2000, 2001, 2002 Free Software Foundation, inc.
This Program Is Free Software, covered By The GNU General Public License.
This Program Is Distributed In The Hope That It Will Be Useful, but WITHOUT ANY WARRANTY; Without Even The Implied Warranty Of
MERCHANTABILITY Or FITNESS FOR A PARTICULAR PURPOSE. See The GNU General Public License For More Details.
Using /dev/sda
Information: The Operating System Thinks The Geometry On /dev/sda Is 8942/255/63. Therefore, cylinder 1024 Ends At 8032.499M.
(Parted) Print
Disk Geometry For /dev/sda: 0.000-70149.507 Megabytes
Disk Label Type: Msdos
Previous12 3 Next
Hot Tags: