³óÇù 777-12-025631
(¿¹±ÝÁÖ: Àü´ëȯ)
|
|
|
|
ÀÌ°÷ÀÇ ±ÛµéÀº ´ë°³ Àü´ëȯÀÇ ÀúÀÛ¹°µéÀÔ´Ï´Ù.
±ÛÀ» »ç¿ëÇϽ÷Á°í ÇÏ´Â °æ¿ì ¹Ýµå½Ã ÀúÀÛÀÚÀÇ Çã¶ôÀ» ¹Þ¾Æ¾ß ÇÕ´Ï´Ù.
mysql DB »ç¿ë·® ¾Ë¾Æº¸±â
¸¶À»Áö±â [2006-06-01 04:52]
|
|
show table status;
A quick script to show you how much disk space all your tables in a database are using:
<?
mysql_connect("db.modwest.com", "username", "password");
mysql_select_db("yourdb");
$result = mysql_query("show table status");
$size = 0;
$out = "";
while($row = mysql_fetch_array($result)) {
$size += $row["Data_length"];
$out .= $row["Name"] .": ". round(($row["Data_length"]/1024)/1024, 2) ."<br>\n";
}
$size = round(($size/1024)/1024, 1);
echo $out ."<br>\n";
echo "Total MySQL db size: $size";
?>
Ãâó: http://www.modwest.com/help/kb6-199.html
|
|
47 |
[Linux] ¿ø°Ý Å͹̳ο¡¼ ÇѱÛÀ̳ª ¼±ÀÌ ±úÁú ¶§ |
¸¶À»Áö±â |
2006-05-26 |
8,864 |
|
46 |
[Excel] ¿¢¼¿ »ç¿ë ÆÁ |
¸¶À»Áö±â |
2006-04-10 |
8,863 |
|
45 |
[MySql] DB ¹®ÀÚ¿ ÀÏ°ýº¯°æ |
¸¶À»Áö±â |
2012-01-13 |
8,862 |
|
44 |
[JavaScript] Á÷Àü ¹æ¹®ÇÑ URLÀ» Ç¥½ÃÇØ ÁÖ´Â ½ºÅ©¸³Æ® |
¸¶À»Áö±â |
2006-04-20 |
8,859 |
|
43 |
[Php] ¹è¿ °Ë»ö |
¸¶À»Áö±â |
2012-03-06 |
8,858 |
|
42 |
[MySql] ÇÊ¿äÇÑ ÀÚ¸®±îÁö µ¥ÀÌÅÍ ÃßÃâ |
¸¶À»Áö±â |
2011-12-12 |
8,855 |
|
41 |
[Hwp] À¯¿ëÇÑ ´ÜÃàÅ° ¸î °¡Áö |
¸¶À»Áö±â |
2006-03-29 |
8,854 |
|
40 |
[MySql] UNION ALL |
¸¶À»Áö±â |
2009-10-10 |
8,851 |
|
39 |
[JavaScript] ¶óµð¿À¹öÆ° üũ¿©ºÎ È®ÀÎ |
¸¶À»Áö±â |
2011-08-20 |
8,850 |
|
38 |
[Linux] Áö¿öÁöÁö ¾Ê´Â ÆÄÀÏÀ» ¾î¶»°Ô? |
¸¶À»Áö±â |
2008-08-10 |
8,847 |
|
37 |
[MySql] mysql DB »ç¿ë·® ¾Ë¾Æº¸±â |
¸¶À»Áö±â |
2006-06-01 |
8,847 |
|
36 |
[Php] Áø¼öº¯È¯ - ÀÚÀ¯·Î¿î º¯È¯ |
¸¶À»Áö±â |
2006-03-29 |
8,847 |
|
35 |
[MySql] µ¥ÀÌÅͺ£À̽º ¸ñ·Ï º¸±â |
¸¶À»Áö±â |
2006-03-29 |
8,846 |
|
34 |
[MySql] ¿ø°Ý Á¢¼Ó ¿¡·¯°¡ ³¯ ¶§ |
¸¶À»Áö±â |
2006-05-25 |
8,845 |
|
33 |
[Php] ¹®ÀÚ¿ ã±â - ¾Õ¿¡¼ºÎÅÍ |
¸¶À»Áö±â |
2006-03-29 |
8,845 |
|
32 |
[JavaScript] ½ºÆиӵé·ÎºÎÅÍ À̸ÞÀÏ ÁÖ¼Ò¸¦ º¸È£Çϱâ |
¸¶À»Áö±â |
2006-07-11 |
8,842 |
|
31 |
[Html] CSS Àû¿ë¹æ¹ý |
¸¶À»Áö±â |
2012-02-22 |
8,841 |
|
30 |
[Php] ÅؽºÆ®ÆÄÀÏ¿¡¼ µðºñ ÀÔ·ÂÇϱâ |
¸¶À»Áö±â |
2011-09-07 |
8,840 |
|
29 |
[MySql] MySQL Root Æнº¿öµå¸¦ Àؾî¹ö·ÈÀ» ¶§ |
¸¶À»Áö±â |
2006-05-09 |
8,840 |
|
28 |
[Windows] ½ÃÀÛ ÇÁ·Î±×·¥ Á¦°Å |
¸¶À»Áö±â |
2006-04-19 |
8,840 |
|
|
|