묻고답하기
db 용량 문제 ... 줄일 방법 없나요??
2010.08.18 17:06
| Name | Rows | Create time | Data length | Index length | Sum |
|---|---|---|---|---|---|
| xe_action_forward | 4 | 2010-01-25 18:59:17 | 108 | 3,072 | 3,180 |
| xe_addons | 12 | 2010-01-25 18:59:22 | 436 | 6,144 | 6,580 |
| xe_addons_site | 0 | 2010-01-25 18:59:22 | 0 | 1,024 | 1,024 |
| xe_ai_installed_packages | 0 | 2010-01-25 18:59:18 | 0 | 1,024 | 1,024 |
| xe_ai_remote_categories | 0 | 2010-01-25 18:59:18 | 0 | 1,024 | 1,024 |
| xe_autoinstall_packages | 0 | 2010-01-25 18:59:18 | 0 | 1,024 | 1,024 |
| xe_comment_declared | 0 | 2010-01-25 18:59:20 | 0 | 1,024 | 1,024 |
| xe_comment_declared_log | 0 | 2010-01-25 18:59:19 | 0 | 1,024 | 1,024 |
| xe_comment_voted_log | 0 | 2010-01-25 18:59:19 | 0 | 1,024 | 1,024 |
| xe_comments | 0 | 2010-01-25 18:59:20 | 280 | 13,312 | 13,592 |
| xe_comments_list | 0 | 2010-01-25 18:59:19 | 60 | 4,096 | 4,156 |
| xe_counter_log | 387 | 2010-01-25 18:59:22 | 58,652 | 12,288 | 70,940 |
| xe_counter_site_status | 0 | 2010-01-25 18:59:22 | 0 | 1,024 | 1,024 |
| xe_counter_status | 184 | 2010-01-25 18:59:22 | 4,600 | 5,120 | 9,720 |
| xe_document_aliases | 0 | 2010-01-25 18:59:19 | 0 | 1,024 | 1,024 |
| xe_document_categories | 0 | 2010-01-25 18:59:19 | 96 | 4,096 | 4,192 |
| xe_document_declared | 0 | 2010-01-25 18:59:18 | 0 | 1,024 | 1,024 |
| xe_document_declared_log | 0 | 2010-01-25 18:59:18 | 0 | 1,024 | 1,024 |
| xe_document_extra_keys | 0 | 2010-01-25 18:59:18 | 0 | 1,024 | 1,024 |
| xe_document_extra_vars | 0 | 2010-01-25 18:59:18 | 0 | 1,024 | 1,024 |
| xe_document_histories | 295 | 2010-01-25 18:59:18 | 111,000,856 | 28,672 | 111,029,528 |
| xe_document_readed_log | 0 | 2010-01-25 18:59:18 | 0 | 1,024 | 1,024 |
| xe_document_trash | 8 | 2010-01-25 18:59:18 | 704 | 8,192 | 8,896 |
| xe_document_voted_log | 0 | 2010-01-25 18:59:19 | 0 | 1,024 | 1,024 |
| xe_documents | 43 | 2010-06-22 16:02:56 | 14,748,852 | 41,984 | 14,790,836 |
| xe_editor_autosave | 1 | 2010-01-25 18:59:21 | 197,584 | 6,144 | 203,728 |
| xe_editor_components | 10 | 2010-01-25 18:59:21 | 300 | 6,144 | 6,444 |
| xe_editor_components_site | 0 | 2010-01-25 18:59:21 | 0 | 1,024 | 1,024 |
| xe_files | 0 | 2010-01-25 18:59:19 | 4,952 | 12,288 | 17,240 |
| xe_files_downloaded_log | 0 | 2010-04-19 17:44:33 | 0 | 1,024 | 1,024 |
| xe_lang | 0 | 2010-01-25 18:59:17 | 0 | 1,024 | 1,024 |
| xe_layouts | 1 | 2010-01-25 18:59:22 | 272 | 5,120 | 5,392 |
| xe_member | 3 | 2010-01-25 18:59:20 | 896 | 16,384 | 17,280 |
| xe_member_auth_mail | 0 | 2010-01-25 18:59:21 | 0 | 1,024 | 1,024 |
| xe_member_autologin | 1 | 2010-01-25 18:59:20 | 48 | 3,072 | 3,120 |
| xe_member_denied_user_id | 34 | 2010-01-25 18:59:20 | 1,256 | 4,096 | 5,352 |
| xe_member_friend | 1 | 2010-01-25 18:59:20 | 60 | 6,144 | 6,204 |
| xe_member_friend_group | 1 | 2010-01-25 18:59:20 | 44 | 3,072 | 3,116 |
| xe_member_group | 3 | 2010-01-25 18:59:21 | 136 | 4,096 | 4,232 |
| xe_member_group_member | 5 | 2010-01-25 18:59:21 | 216 | 3,072 | 3,288 |
| xe_member_join_form | 0 | 2010-01-25 18:59:20 | 0 | 1,024 | 1,024 |
| xe_member_message | 3 | 2010-01-25 18:59:20 | 800 | 6,144 | 6,944 |
| xe_member_openid | 0 | 2010-01-25 18:59:20 | 0 | 1,024 | 1,024 |
| xe_member_openid_association | 0 | 2010-01-25 18:59:20 | 0 | 1,024 | 1,024 |
| xe_member_openid_nonce | 0 | 2010-01-25 18:59:20 | 0 | 1,024 | 1,024 |
| xe_member_scrap | 2 | 2010-01-25 18:59:21 | 160 | 4,096 | 4,256 |
| xe_menu | 1 | 2010-01-25 18:59:22 | 44 | 5,120 | 5,164 |
| xe_menu_item | 4 | 2010-01-25 18:59:22 | 572 | 5,120 | 5,692 |
| xe_menu_layout | 0 | 2010-01-25 18:59:22 | 0 | 1,024 | 1,024 |
| xe_module_admins | 0 | 2010-01-25 18:59:17 | 0 | 1,024 | 1,024 |
| xe_module_categories | 0 | 2010-01-25 18:59:17 | 0 | 1,024 | 1,024 |
| xe_module_config | 9 | 2010-01-25 18:59:17 | 2,272 | 5,120 | 7,392 |
| xe_module_extra_vars | 53 | 2010-01-25 18:59:17 | 6,384 | 7,168 | 13,552 |
| xe_module_filebox | 0 | 2010-01-25 18:59:17 | 0 | 1,024 | 1,024 |
| xe_module_grants | 26 | 2010-01-25 18:59:17 | 1,876 | 2,048 | 3,924 |
| xe_module_locks | 0 | 2010-01-25 18:59:17 | 0 | 1,024 | 1,024 |
| xe_module_part_config | 25 | 2010-01-25 18:59:18 | 8,164 | 5,120 | 13,284 |
| xe_module_skins | 33 | 2010-01-25 18:59:17 | 5,696 | 9,216 | 14,912 |
| xe_module_trigger | 67 | 2010-01-25 18:59:17 | 4,904 | 5,120 | 10,024 |
| xe_modules | 4 | 2010-01-25 18:59:17 | 1,380 | 6,144 | 7,524 |
| xe_point | 4 | 2010-01-25 18:59:21 | 68 | 3,072 | 3,140 |
| xe_poll | 0 | 2010-01-25 18:59:18 | 0 | 1,024 | 1,024 |
| xe_poll_item | 0 | 2010-01-25 18:59:18 | 0 | 1,024 | 1,024 |
| xe_poll_log | 0 | 2010-01-25 18:59:18 | 0 | 1,024 | 1,024 |
| xe_poll_title | 0 | 2010-01-25 18:59:18 | 0 | 1,024 | 1,024 |
| xe_sequence | 1607 | 2010-01-25 18:59:18 | 14,463 | 25,600 | 40,063 |
| xe_session | 1 | 2010-08-18 17:14:03 | 1,912 | 10,240 | 12,152 |
| xe_site_admin | 0 | 2010-01-25 18:59:17 | 0 | 1,024 | 1,024 |
| xe_sites | 1 | 2010-01-25 18:59:17 | 72 | 6,144 | 6,216 |
| xe_spamfilter_denied_ip | 0 | 2010-01-25 18:59:22 | 0 | 1,024 | 1,024 |
| xe_spamfilter_denied_word | 0 | 2010-01-25 18:59:22 | 0 | 1,024 | 1,024 |
| xe_spamfilter_log | 0 | 2010-01-25 18:59:22 | 0 | 1,024 | 1,024 |
| xe_tags | 0 | 2010-01-25 18:59:19 | 0 | 1,024 | 1,024 |
| xe_trackbacks | 0 | 2010-01-25 18:59:19 | 0 | 1,024 | 1,024 |
| 할당량 | 100 MByte | ||||
| 총사용량 | 120.6 MByte | ||||
웹호스팅 회사서 db가 다 차버렸다고 계속 강조 하네요 ..
2명이서 그냥 관련 자료 글로만 적는 게시판 사용하는 중인데 ... 이건 뭘했다고 이렇게 차버린건지
다른분은 15000명 관리하는데도 500M 면 충분하다던데
지식이 짧은 저로서는 이것 저것 지워도 용량에는 전혀 변화가 없네요 어찌 하면 좋을까요?
그냥 보기에는 xe_document_histories 이거가 많이 잡아 먹는거 같은데
지울 방법이 없는지요????
document_histories 정리하세요.
phpmyadmin에 접속하셔서 지우시면 됩니다.