ÉèΪÊ×Ò³ ¼ÓÈëÊÕ²Ø

TOP

MySQLÊý¾Ý¿âµ¥Ò»±íÍ»ÆÆ4GÏÞÖÆµÄʵÏÖ·½·¨(Ò»)
2014-11-24 07:25:11 À´Ô´: ×÷Õß: ¡¾´ó ÖРС¡¿ ä¯ÀÀ:0´Î
Tags£ºMySQL Êý¾Ý¿âµ¥Ò» Í»ÆÆ ÏÞÖÆ ʵÏÖ ·½·¨

ÎÊÌ⣺ÔÚÂÛ̳·¢±í»Ø¸´Ê±³öÏÖ¡°The table is full¡±µÄÌáʾ£¬×ÖÃæÒâÒåÉÏÊÇÊý¾Ý±íÒÑÂúµÄÒâ˼¡£ÒòΪºÜÉÙÓпª·¢ÕßÔâÓöµ¥Ò»±í³¬¹ý4GµÄÇé¿ö£¬Òò´ËÅóÓѼäµÄÌÖÂÛÖ»ÄÜÌṩһЩÍâΧµÄÐÅÏ¢¡£Îª½â¾ö´ËÎÊÌ⣬ÎÒ·­ÔÄÁ˺ܶà×ÊÁÏ£¬±¾ÎĽ«ÒÔÎÒ´Ë´ÎÎÊÌâµÄ½â¾ö¹ý³Ì£¬½éÉÜÎÊÌâ·¢ÉúµÄÔ­Òò¼°¶Ô²ß¡£

¸ù¾Ý¾­Ñ飬The table is fullÌáʾÍùÍù³öÏÖÔÚÒÔÏÂÁ½ÖÖÇé¿ö£º

1. ±íÖÐÉèÖÃÁËMAX_ROWSÖµ£¬¼òµ¥µÄ˵£¬ÈôMAX_ROWSÉèÖÃΪ100£¬¶ø³ÌÐòÊÔͼдÈëµÚ101Ìõ¼Ç¼£¬»á³öÏÖ´Ë´íÎó¡£

2. ±íÂú¡£ÕâÖÖÇé¿öÊDZ¾ÎÄÌÖÂÛµÄÖØµã


ÎÒÃÇÈÏΪMySQLÔÚ´æÈ¡±íµÄʱºò£¬´æÔÚÒ»ÖÖ¶¨Î»·ÖÅ乿ÂÉ¡£Õâ¸ö¹æÂÉÔÚĬÈϵÄÇé¿öÏ£¬¿ÉÒÔѰַ4GÒÔÄÚµÄÊý¾Ý¡£³¬¹ýÕâ¸ö´óС£¬Êý¾Ý¿â½«²»ÄܶÔÊý¾Ý¶¨Î»£¬Òò¶øÒ²ÎÞ·¨½øÐжÁд¡£¾­¹ýʵÑ飬Õâ¸öÏÞÖÆÊÇÍêÈ«¿ÉÒÔ±»Í»ÆÆµÄ¡£

±¾ÀýÖУ¬Óû§µÄϵͳ»·¾³ÎªË«Athlon´¦ÀíÆ÷¡¢SCSIÓ²ÅÌ72G¡¢2GÄڴ棬Óû§µÄÌû×Ó±íÊý¾Ý³ß´çΪ4294963640£¬½Ó½ü4G(4GµÄʵ¼Ê×Ö½ÚÊýΪ4294967296)¡£


Ê×ÏÈSSHµÇ¼ºó£¬²é¿´Óû§µÄϵͳÐÅÏ¢£º


# uname -a

Linux zichen.com 2.4.20-8smp #1 SMP Thu Mar 13 16:43:01 EST 2003 i686 athlon i386 GNU/Linux


Ö¤Ã÷ÊÇLinuxϵͳ£¬¸ù¾ÝÄں˰汾2.4.20-8smp£¬¼ÓÉϹúÄÚʹÓõij£¼ûϵͳ£¬¹À¼ÆÓ¦¸ÃÊÇredhat 9·¢Ðаü¡£


# cat /etc/*release*

Red Hat Linux release 9 (Shrike)


ÕâÒ²Ö¤Ã÷ÁËÎÒÃǶÔϵͳ°æ±¾µÄ²ÂÏë¡£


È»ºó¿´Ò»ÏÂÓõÄÊÇʲôÎļþϵͳ¡£ÒòΪ¸ÃÓû§²¢·Ç¸ßÊÖ£¬¹À¼ÆÔÚװϵͳµÄʱºò¾ÍÊÇһ·»Ø³µÏÂÀ´£¬redhat 9ĬÈϵÄÓ¦¸ÃÊÇEXT3£¬²»¹ýÎÒÃÇ»¹ÊÇ¿´Ò»Ï£º


# 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

Minor Start End Type Filesystem Flags

1 0.031 101.975 primary ext3 boot

2 101.975 10103.378 primary linux-swap


Ö¤Ã÷ȷʵÊÇÕâÑù×Ó¡£ËæºóÎÒÃÇ·­ÔÄÁËEXT3ÎļþϵͳµÄÏà¹Ø¼¼Êõ²ÎÊý£¬EXT3ÊÇÔÚEXT2»ù´¡ÉÏÑÝ±ä¶øÀ´¡£EXT2ËùÖ§³Ö×î´óµ¥Ò»Îļþ³¤¶ÈÊÇ2G£¬Õâ¸öÊǺÜõ¿½ÅµÄÒ»¸öÏÞÖÆ¡£EXT3×öµÄºÜ´óÒ»¸ö¸ÄÉÆ¾ÍÊǽ«Õâ¸öÏÞÖÆ·Å´óµ½ÁË2TB£¬ÓÉ´ËÉÔËÉÒ»¿ÚÆø£¬ÆðÂë²»ÊDzÙ×÷ϵͳÉϵÄÏÞÖÆ¡£


¾­¹ýÅóÓѵĿªµ¼£¬Á˽⵽µ¥Ò»Îļþ´óСÓÐÈçϼ¸¸öÒòËØ£º

1. ÎļþϵͳµÄÏÞÖÆ(Èç¸Õ´æËù˵EXT3µÄ2TBÏÞÖÆ)

2. ijһ³ÌÐò½ø³ÌËùÄÜ´æÈ¡µÄµÚÒ»Îļþ×î´ó³ß´ç(ÀýÈçapacheÔÚLinux EXT3ÏÂÄÜ´æÈ¡µÄ×î´ó³ß´çΪ2G£¬ÖîÈçÈÕÖ¾)


³õ²½ÅÐ¶ÏÆ¿¾±¾ÍÔÚÉÏÊöÆäÖеڶþÏî¡£ËæºóÕÒµ½myisamchkÀ´ÏÔʾһϱíÐÅÏ¢£¬Ö¤Ã÷ÁËÆ¿¾±¾ÍÔÚMySQL±¾ÉíµÄ´æÈ¡ÉÏ¡£


# myisamchk -dv cdb_posts


½á¹û¾Í²»ÌùÁË£¬ÆäÖÐÓÐÒ»ÏîMax datafile lengthµÄֵǡºÃ¾ÍÊÇ4G¡£Óɴ˲úÉúÁËÆ¿¾±¡£

ºóÀ´·­ÔÄÁËN¶à×ÊÁÏ£¬½øÐÐÁËN¶à³¢ÊÔ£¬Ò²×ßÁ˲»ÉÙÍä·£¬×îÖÕ¾õµÃ»¹Êǹٷ½Îĵµ±È½Ï¿É¿¿¡£±È½ÏÀϵÄÎĵµÀïдµÀÕâÊÇÓÉÓÚtmp_table_sizeµÄÖµÔì³ÉµÄ£¬Ò²ÓÐÌáµ½ÓÃBIG-TABLESÕâ¸ö²ÎÊý¡£ÊÂʵ֤Ã÷ÕâЩ¶¼ÊÇÆç;¡£´óÍíÉϵÄȷʵºÜÀÛ£¬ÕâÀïÖ»¸ø³ö×îÖյĽâ¾ö·½°¸°É£¬ÖмäµÄ¾Í²»ÂÞàÂÁË¡£


½øµ½mysql¿Í»§¶Ë¡£

# mysql -uroot -p

Enter password: ******

Welcome to the MySQL monitor. Commands end with ; or g.

Your MySQL connection id is 59411 to server version: 4.0.18-standard


Type help; or h for help. Type c to clear the buffer.


mysql> use ******

Database changed

mysql> ALTER TABLE cdb_posts MAX_ROWS=1000000000 AVG_ROW_LENGTH=15000;


ÒòΪÕâ¸ö±í·Ç³£´ó£¬Ö´ÐÐʱ¼äÔÚË«AthlonµÄרҵ·þÎñÆ÷ÉϾ¹È»»¨ÁË30·ÖÖÓ£¡

Ö®ºóÔÙͨ¹ýmyisamchk²é¿´¸Ã±íµÄÐÅÏ¢£º

# myisamchk -dv cdb_posts

MyISAM file: cdb_posts

Record format: Packed

Character set: latin1 (8)

File-version: 1

Creation time: 2004-08-30 22:19:48

Recover time: 2004-08-30 22:42:47

Status: open,changed

Auto increment key: 1 Last value: 1063143

Data records: 619904 Deleted blocks: 5

Datafile parts: 619909 Deleted data: 323872

Datafile pointer (bytes): 6 Keyfile pointer (bytes): 4

Datafile length: 4295287332 Keyfile length: 40421376

Max datafile length: 281474976710654 Max keyfile length: 4398046510079

Recordlength: 149


table description:

Key Start Len Index Type Rec/key Root Blocksize

1 1 4 unique unsigned long 1 4535296 1024

2 5 2 multip. unsigned short 13776 12540928 1024

3 111 4 multip. unsigned long 1 18854912 1024

4 28 3 multip. uint24 18 24546304 1024

5 7 3 multip. uint24 7 32827392 1024

111 4 unsigned long 1

6 7 3 multip. uint24 7 40418304 1024

28 3 uint24


ÁîÈËÕñ·ÜµÄÊÂÇé·¢ÉúÁË£¬¸Ã±íµÄ Max datafile length: 281474976710654 Max keyfile

Ê×Ò³ ÉÏÒ»Ò³ 1 2 ÏÂÒ»Ò³ βҳ 1/2/2
¡¾´ó ÖРС¡¿¡¾´òÓ¡¡¿ ¡¾·±Ìå¡¿¡¾Í¶¸å¡¿¡¾Êղء¿ ¡¾ÍƼö¡¿¡¾¾Ù±¨¡¿¡¾ÆÀÂÛ¡¿ ¡¾¹Ø±Õ¡¿ ¡¾·µ»Ø¶¥²¿¡¿
·ÖÏíµ½: 
ÉÏһƪ£º¼ìË÷Êý¾Ý¿âÖбíµÄ½á¹¹¼°×Ö¶Î˵Ã÷ ÏÂһƪ£ºÐÞ¸ÄMySQLµÄĬÈÏÃÜÂëµÄ·½·¨

ÆÀÂÛ

ÕÊ¡¡¡¡ºÅ: ÃÜÂë: (ÐÂÓû§×¢²á)
Ñé Ö¤ Âë:
±í¡¡¡¡Çé:
ÄÚ¡¡¡¡ÈÝ:

¡¤Linuxϵͳ¼ò½é (2025-12-25 21:55:25)
¡¤Linux°²×°MySQL¹ý³Ì (2025-12-25 21:55:22)
¡¤Linuxϵͳ°²×°½Ì³Ì£¨ (2025-12-25 21:55:20)
¡¤HTTP Åc HTTPS µÄ²î„ (2025-12-25 21:19:45)
¡¤ÍøÕ¾°²È«±ØÐ޿ΣºÍ¼ (2025-12-25 21:19:42)