ȸ¿ø°¡ÀԡžÆÀ̵ð/ºñ¹øã±â
ȨÀ¸·Î

4±â°¡ ÀÌ»óÀÇ Å×À̺íÀ» ¸¸µé°í ½Í´Ù¸é(Å×À̺íÀÇ AVG ROW LENGTH, MAX ROWS)
7³â Àü
¸ÕÀú, ÇØ´çTable¿¡ ´ëÇÑ Á¤º¸¸¦ Á¶È¸ÇÕ´Ï´Ù.

mysql>ȯ°æ¿¡¼­ ÀÔ·ÂÇØ¾ß ÇÕ´Ï´Ù.



[Syntax]

show table status from DataBase¸í like 'Table¸í';

[¿¹Á¦]

DataBase¸í- korea, table¸í-seoulÀÏ °æ¿ì

show table status from korea like 'seoul';



Á¶È¸µÈ °á°ú¿¡¼­

max_rows Column°ú avg_row_length Column°ªÀ» º¯°æÇÏ¸é µË´Ï´Ù.

[Syntax]

alter table table¸í max_rows=·¹ÄÚµå¼ö avg_row_length=¿øÇÏ´ÂÅ×À̺í¿ë·®

[¿¹Á¦]

·¹ÄÚµå¼ö-1¾ï°Ç, ¿øÇÏ´ÂÅ×À̺í¿ë·®-60GBÀÏ °æ¿ì

alter table seoul max_rows=100000000 avg_row_length=60240000000;



[µµ¿òÀÌ µÈ ½ÎÀÌÆ®]

http://www.mysql.com/doc/en/Full_table.html


ÃßõÃßõ : 285 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
2,855
HTML <Audio> »ç¿ë¹ý
2,854
À©µµ¿ì10 ½Ã½ºÅÛÆÄÀÏ ¼Õ»ó (ÃÊ°£´Ü ¿À·ù º¹±¸¹æ¹ý!!)
2,853
PHP ÆÄÀÏ Á¸Àç ¿©ºÎ ÆľÇÇϱâ(·ÎÄà ÆÄÀÏ Á¸Àç ¹× ¿ø°ÝÁö ÆÄÀÏ Á¸Àç)
2,852
[CSS] ¹Ú½º ¼¼·Î °¡¿îµ¥ Áß¾Ó Á¤·Ä 6°¡Áö
2,851
CSS Layout ¼öÆò & ¼öÁ÷ Á¤·Ä
2,850
¿©·¯ µµ¸ÞÀÎµé °£ ÄíÅ° °øÀ¯Çϱâ
2,849
ÅÂ±× »çÀÌ¿¡ ÀÖ´Â ÅؽºÆ®¸¦ ÃßÃâ
2,848
[JQuery] textbox focus on offÀ϶§ ¼ýÀÚ ÄÞ¸¶ º¸¿©ÁÖ±â
2,847
ÄíÅ° »ý¼º,°¡Á®¿À±â,»èÁ¦
2,846
»ç¿ëÀÚ ÇÔ¼ö ¸ðÀ½
2,845
¸¶¿ì½º,Å°º¸µå Á¦ÇÑ ( ¿À¸¥ÂÊŬ¸¯,µå·¡±×,¿µ¿ª¼±Åõî..)
2,844
[HTML5] <video> - DOMÀ¸·Î Á¦¾îÇϱâ
2,843
HTML5 video ű׿¡¼­ ¿µ»ó Á¿ì¹ÝÀü
2,842
PHP - ƯÁ¤ ÅÂ±× ¹× ¹®ÀÚ¿­ ÃßÃâ, Á¦°Å
2,841
[PHP] define°ú definedÀÇ Â÷ÀÌ
2,840
¿ìŬ¸¯ ¿Ïº®Â÷´Ü ½ºÅ©¸³Æ®
2,839
iframe ³ôÀÌ 100% ¸ÂÃß±â
2,838
curl ÇÔ¼ö¸¦ ÀÌ¿ëÇÑ HTTP REFERER º¯°æ
2,837
À©µµ¿ì10 ½Ã½ºÅÛ ÆÄÀÏ ¹× Dism °Ë»ç
2,836
ÅؽºÆ® ÁٹٲÞ, ±ÛÀÚÀÚ¸£±â CSS
2,835
jQuery Mobile¿¡¼­ À¯¿ëÇÑ ÄÚµå 10°¡Áö.
2,834
[PHP] dirname()ÇÔ¼ö¿Í $_SERVER °ü·Ã »ó¼öµé
2,833
[PHP] ÆÄÀÏ Å©±â, »çÀÌÁî ºÒ·¯¿À´Â ÇÔ¼ö, filesize()
2,832
[jQuery] jQuery Quick API
2,831
[ transition ] ¸µÅ© hover »ö»ó º¯È­ ¼Óµµ Á¶Àý
2,830
PHP 5.3.0 ¿¡¼­ »ç¶óÁø ÇÔ¼öµé ´ëü
2,829
¾î¶² ÆÄÀϵéÀÌ include ³ª require µÇ¾ú´ÂÁö È®ÀÎÇÏ´Â ÇÔ¼ö(get_included_files)
2,828
PHP ³¯Â¥ Çü½Ä ¹× °è»êÇϱâ(³¯Â¥ ´õÇÏ°í »©±â)
2,827
jQuery Mobile¿¡¼­ À¯¿ëÇÑ ÄÚµå 10°¡Áö.
2,826
°ªÀÌ ¹è¿­ ¾È¿¡ Á¸ÀçÇÏ´ÂÁö È®ÀÎÇÏ´Â in_arrayÇÔ¼ö
¸ñ·Ï
¹ÂÁ÷Æ®·ÎÆ® ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ °¡¾ßµ¿ ¤Ó °³ÀÎÁ¤º¸Ãë±Þ¹æħ
Copyright ¨Ï musictrot All rights reserved.