vagrantã®VMãã¡ã¤ã«ãµã¤ãºã縮å°ãã
ä»ã©ãHDDã®å®¹éä¸è¶³ã«è¦ãããã¨ã¯ãã¾ããªãã¨æãã¾ãããSSDã ãã®ãã·ã³ã§å¤æ°ã®VMãåããã¦ããå ´åãªããã ã¨ã容éä¸è¶³ã§ãããããVMãç«ã¦ãããªã⦠ã¨ããæ²ããç¶æ³ã«é¥ããã¨ãããã¨æãã¾ãã
éçºç¨VM群ã®ä¸ã§ä¸å°ã®VMãçªåºãã¦å®¹éãé£ã£ã¦ããã調ã¹ã¦ã¿ãã¨ãããã®VMã§ä½¿ã£ã¦ãMySQLä¸ã«ã¢ã¯ã»ã¹ãã°ã®ãããªæ¶ãã¦ãè¯ãã大éã®ãã¼ã¿ãè¼ã£ã¦ããããããæ¶ãã°ä½10Gãæ¸ããããã¨ããããã¾ããã
ããããå®éã«VMã®ãã¡ã¤ã«ãµã¤ãºã縮å°ãããã¾ã§ã«ã¯çµæ§ãªææ°ã¨æéãããã£ãã®ã§ãã®æé ãã¾ã¨ãã¾ããã
ãã®ä¾ã§ã¯VMã®ååãUUIDï¼ä»®æ³ãµã¼ããä»®æ³ãã£ã¹ã¯ãæå®ããããã®ã¦ãã¼ã¯IDï¼ãä¸è¨ã®ããã«ãªã£ã¦ããã¨ãã¾ãã
- vagrantã®ä»®æ³ãµã¼ãåãexampleã
- ãexampleãã®VirtualBoxã®ãã£ã¬ã¯ããªåãexample_default_12345ã
- ãexampleãã®ãµã¼ãUUIDåã5612d588-c7f6-48c0-8ac1-0c20a541d030ã
- ãexampleãã®å ã®ä»®æ³ãã£ã¹ã¯UUIDåã1759a61c-7445-4c58-af32-540c348c4ff6ã
- 夿å¾ã®ä»®æ³ãã£ã¹ã¯UUIDåãfcccb41b-2ed1-46c1-bb37-308610cc1229ã
MySQLã®ãã¼ã¿ãã¼ã¹ãã¡ã¤ã«ãµã¤ãºãå°ãããã
VMå ã®ä¸è¦ãªãã¡ã¤ã«ãããã¼ã¿ãã¼ã¹å ã®ä¸è¦ãªãã¼ã¿ãåé¤ãã¾ãã
truncateã§ãã¼ãã«ãæ¶ãã¦ãã¾ãã°ããã ãã§ãã¡ã¤ã«ãµã¤ãºãå°ãããªãããã§ãã
ããããdeleteã§ãã¼ãã«èªä½ãæ®ãã¦ãã¼ã¿ã ããæ¶ããå ´åããã¼ã¿ãã¼ã¹ãã¡ã¤ã«ã®ãµã¤ãºã¯ãã®ã¾ã¾ã§ãå°ãããªãã¾ããã
ãã®å ´åãMySQLã®OPTIMIZEã³ãã³ãã§åé¤ããããã¼ã¿ã®åãè©°ãã¦å°ãããã¾ãã
VirtualBoxã¯ã©ã¤ã¢ã³ãä¸ã®ãMySQLã®rootã§
mysql> OPTIMIZE TABLE example_table;
ãã®å¦çã¯çµæ§ãªæéããããã¾ãã
ï¼åèï¼
第35åãOPTIMIZE TABLEã§ãã¼ãã«ãæé©åããï¼MySQLéæ®è«ä¾¿ãï½gihyo.jp ⦠æè¡è©è«ç¤¾
http://gihyo.jp/dev/serial/01/mysql-road-construction-news/0035
使ãããªããªã£ãé åã0ã§åãã
ä»®æ³ãã£ã¹ã¯ã縮å°ããéã«ã使ããã¦ããªãé¨åã®å¤ãã0ãã§ããå¿ è¦ãããã¾ãã
åã«ãã¡ã¤ã«ãåé¤ããã ãã§ã¯ãã®ç¶æ³ã«ãªããªãããããã£ã¹ã¯ç©ºã容éå ¨ä½ãã0ãã§åãã¦ããã®ãã¡ã¤ã«ãæ¶ããã¨ã§ã空ã容éå ¨ä½ã®ä¸èº«ã空ã«ãã¾ãã
VirtualBoxã¯ã©ã¤ã¢ã³ãä¸ã®rootã§
# dd if=/dev/zero of=zero bs=4k; \rm zero
ãã®å¦çã¯çµæ§ãªæéããããã¾ãã
ï¼åèï¼
ä»®æ³ãã£ã¹ã¯ã®å§ç¸® | VirtualBox Mania
http://vboxmania.net/content/%E4%BB%AE%E6%83%B3%E3%83%87%E3%82%A3%E3%82%B9%E3%82%AF%E3%81%AE%E5%9C%A7%E7%B8%AE
縮å°å¯è½ãªä»®æ³ãã£ã¹ã¯å½¢å¼ã«å¤æãã
vagrantã§ãã·ã³ãçæããã¨VMDKå½¢å¼ã®ä»®æ³ãã£ã¹ã¯ã«ãªãã¾ããããã®VMDKå½¢å¼ã ã¨ãã£ã¹ã¯ãµã¤ãºã縮å°ãããã¨ãåºæ¥ã¾ããã
ããã§ç¸®å°ãå¯è½ãªVDIå½¢å¼ã®ä»®æ³ãã£ã¹ã¯ã¸å¤æãã¦ããå¿ è¦ãããã¾ãã
VirtualBoxãã¹ãä¸ã§ã該å½ã®ãã£ã¹ã¯ã®æ å ±ãåå¾ããVDIå½¢å¼ã«å¤æããä»®æ³ãã£ã¹ã¯ãæ°ãã«ä½æ
$ vboxmanage list hdds ..ç¥ UUID: 1759a61c-7445-4c58-af32-540c348c4ff6 Location: /home/example/VirtualBox VMs/example_default_12345/_centos-6.6-x86_64-disk1.vmdk Storage format: VMDK ..ç¥ $ vboxmanage clonehd 1759a61c-7445-4c58-af32-540c348c4ff6 \ "/home/example/VirtualBox VMs/example_default_12345/example-2.vdi" --format vdi
ãã®å¦çã¯çµæ§ãªæéããããã¾ãã
ã¾ãã䏿çã«åãµã¤ãºã®ä»®æ³ãã£ã¹ã¯ãä½ãããããããã®ãã¡ã¤ã«ãä½ããã ãã®ç©ºã容éãå¿
è¦ã§ãã
䏿çã«ä»ã®VMã¤ã¡ã¼ã¸ãä»ã®ã¹ãã¬ã¼ã¸ã«ç§»ããªã©ãã¦å®¹éã空ãã¾ãã
ï¼åèï¼
VirtualBox ã®ä»®æ³ãã£ã¹ã¯ã®ãµã¤ãºã夿´ãã - Qiita
http://qiita.com/niwashun/items/f71b0b805a6f97b514ec
VMã®ä»®æ³ãã£ã¹ã¯ã縮å°ãã
VDIå½¢å¼ã®ä»®æ³ãã£ã¹ã¯ã ã¨modifyhdã§ãcompactãã¨ãã使ããã¦ããªãé¨åã®ä»®æ³ãã£ã¹ã¯ãµã¤ãºã縮å°ãããã¨ãåºæ¥ã¾ãã
VirtualBoxãã¹ãä¸ã§ãæ°ãã«ä½ãããVDIå½¢å¼ã®ä»®æ³ãã£ã¹ã¯ã®æ å ±ãåå¾ãããã£ã¨æ¬æ¥ã®ç®çã§ããä»®æ³ãã£ã¹ã¯ã®ç¸®å°ããã
$ vboxmanage list hdds ..ç¥ UUID: fcccb41b-2ed1-46c1-bb37-308610cc1229 Location: /home/example/VirtualBox VMs/example_default_12345/example-2.vdi Storage format: vdi ..ç¥ $ vboxmanage modifyhd fcccb41b-2ed1-46c1-bb37-308610cc1229 --compact
ãã®å¦çã¯çµæ§ãªæéããããã¾ãã
ï¼åèï¼
ä»®æ³ãã£ã¹ã¯ã®å§ç¸® | VirtualBox Mania
http://vboxmania.net/content/%E4%BB%AE%E6%83%B3%E3%83%87%E3%82%A3%E3%82%B9%E3%82%AF%E3%81%AE%E5%9C%A7%E7%B8%AE
å°ãããªã£ãä»®æ³ãã£ã¹ã¯ã«ä»ããªãã
æ°ããä½ãããä»®æ³ãã£ã¹ã¯ã¯ã¾ã VMã¨ç´ä»ãã¦ããªããããå ã ã®ãã£ã¹ã¯ã¤ã¡ã¼ã¸ã¨ã®ä»ãæ¿ããè¡ãã¾ãã
VirtualBoxãã¹ãä¸ã§VMã«ç´ä»ãã¦ãããã£ã¹ã¯ãä»ãæ¿ãã¾ãã
ãã®ã¨ããstorageattachãã§ãstoragectlããportããdeviceãã§æå®ããå¤ã¯ãshowvminfoãã§ä»®æ³ãã£ã¹ã¯ãçµã³ä»ãããã¦ããè¡ã®å¤ã«ãªãã¾ãã
ãstorageattachãã®èª¬æããã¦ããã¨ã³ããªã§ã¯ãã®å¤ãããéã£ã¦ããããããã¶ããã¼ã¸ã§ã³ã«ããå¤ãããã¨ãå¤ããããªã®ã§ãå®éã«ãshowvminfoãã§ç¢ºèªãã¦ãã®å¤ã使ã£ãã»ããè¯ãã§ãã
$ vboxmanage list vms
..ç¥
"example_default_12345" {5612d588-c7f6-48c0-8ac1-0c20a541d030}
..ç¥
$ vboxmanage showvminfo 5612d588-c7f6-48c0-8ac1-0c20a541d030
..ç¥
IDE Controller (0, 0): /home/example/VirtualBox VMs/example_default_12345/_centos-6.6-x86_64-disk1.vmdk
(UUID: 1759a61c-7445-4c58-af32-540c348c4ff6)
..ç¥
$ vboxmanage storageattach 5612d588-c7f6-48c0-8ac1-0c20a541d030 --storagectl "IDE Controller" \
--port 0 --device 0 --type hdd --medium fcccb41b-2ed1-46c1-bb37-308610cc1229
$ vboxmanage showvminfo 5612d588-c7f6-48c0-8ac1-0c20a541d030
..ç¥
IDE Controller (0, 0): /home/example/VirtualBox VMs/example_default_12345/example-2.vdi
(UUID: fcccb41b-2ed1-46c1-bb37-308610cc1229)
..ç¥
ï¼åèï¼
VirtualBoxã®ä»®æ³ãã£ã¹ã¯ãã³ãã¼ãã¦ã¿ãã
http://takaq1.plala.jp/freebsd/9_0r/kasou_copy.html
åä½ã確èªãä¸è¦ãªãã£ã¹ã¯ã¤ã¡ã¼ã¸ãåé¤ãã
vagrant upãã¦åé¡ãªãèµ·åããã確èªããåé¡ãªããã°ä¸è¦ã¨ãªã£ã大ããªãã£ã¹ã¯ã¤ã¡ã¼ã¸ãåé¤ãã¾ãã
VirtualBoxãã¹ãä¸ã§
$ vboxmanage closemedium disk 1759a61c-7445-4c58-af32-540c348c4ff6 --delete
ããã ããã£ã¦ãã£ã¨ãå ´æã空ãã¾ãããåå¦çãã ãã¶æéããããã¨æã£ã¦ãã£ã¦ã¿ã¦ãã ããã
èªåã§ãã®è¾ºã®åºã«è¡ã£ã¦å¤ä»ããã£ã¹ã¯è²·ã£ã¦ãã¦ç¹ãã§ããï¼ã¨ããæ°åã«ãªãã¾ãâ¦