[B! mysql] puchibanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

puchiban id:puchiban

mysqlã«é–¢ã™ã‚‹puchibanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (26)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ç°¡å˜ã€è‡ªå‹•! MySQL ã‚’ AutoMySQLBackup + cron ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— - Qiita
è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã®é¸æŠžè‚¢ AutoMySQLBackup mysqlmybackup.sh Percona MySQL ã ã‹ã‚‰ã€XtraBackup ã§ã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆãªãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ã‹ã—ãŸã„ã®ã ãŒã€ã„ã„ã®è¦‹ã¤ã‹ã‚‰ãªã„â€¦èª°ã‹æ•™ãˆã¦ä¸‹ã•ã„ã€‚ automysqlbackup ã¨ã„ã†ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’cronã§ä½¿ã£ã¦ã„ãŸ AutoMySQLBackup | Free software downloads at SourceForge.net http://sourceforge.net/projects/automysqlbackup/ AutoMySQLBackup ã®è‰¯ã„ã¨ã“ã‚ æ©Ÿèƒ½ãŒä¸€æ¯ã‚ã‚‹ã‚ˆ æ—¥ã€é€±ã€æœˆã”ã¨ç‰ã§è¨å®šã§ãã‚‹ ä½•æ—¥ã§å‰Šé™¤ã™ã‚‹ã‹(ãƒãƒ¼ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³)ã®è¨å®šã§ãã‚‹ é™¤å¤–ã™ã‚‹DBã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¨å®šã§ãã‚‹ ãƒ¡ãƒ¼ãƒ«ã§ãŠçŸ¥ã‚‰ã›ã‚‚ã§ãã‚‹ sslã§æš—å·åŒ–ã§ãã‚‹ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å‰ã€å¾Œã«ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿ
puchiban 2013/08/19
mysql

backup
ãƒªãƒ³ã‚¯
è§£æžã¾ã§10åˆ†ï¼æœ€å¼·ã®MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã€ŒJet Profilerã€ - Lancersé–‹ç™ºãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€keiã§ã™ã€‚ ä»Šå›žã¯ã€MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«å¤§æ´»èºãªã€ŒJet Profilerã€ã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ Jet Profilerã¨ã¯ Jet Profilerã¯ã€MySQLå‘ã‘ã®ã‚¯ã‚¨ãƒªã‚¢ãƒŠãƒ©ã‚¤ã‚¶ã§ã™ã€‚ ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯ã€DBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä¸ã§ã‚‚é‡è¦ãªä½œæ¥ã®1ã¤ã§ã™ãŒã€ Jet Profilerã‚’ä½¿ãˆã°ã€ãã®ä½œæ¥ã‚’GUIã§ç›´æ„Ÿçš„ã«è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ•ãƒªãƒ¼ã‚¦ã‚§ã‚¢ã®å½¢æ…‹ã§æä¾›ã•ã‚Œã¦ãŠã‚Šã€æ©Ÿèƒ½é™å®šç‰ˆã§ã‚ã‚Œã°ç„¡æ–™ã§åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ è³¼å…¥ã™ã‚‹å ´åˆã¯ã€$499ã¨ãªã‚Šã¾ã™ã€‚ è©³ç´°æƒ…å ±ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯å…¬å¼ãƒšãƒ¼ã‚¸ã‹ã‚‰ã©ã†ãžã€‚ http://www.jetprofiler.com/ja/ Jet Profilerã®é…åŠ› ãã®1ã€€å°Žå…¥ã®ã—ã‚„ã™ã• é€šå¸¸ã®Windowãƒžã‚·ãƒ³ã«ã€æ™®é€šã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ„Ÿè¦šã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå¯èƒ½ã§ã™ã€‚ ã‚¤ãƒ³
puchiban 2012/08/25
profiler

mysql
ãƒªãƒ³ã‚¯
MySQL&Fusion I/Oã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ‚©ã¿ â€“ Yorozuyah.com
MySQLã‹ã‚‰Fusion I/Oã‚’ä½¿ã†ã¨ãã«ã€ã©ã®è¾ºã‚ãŸã‚Šã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚Œã°è‰¯ã„ã‹ã‚’æ‚©ã¿ä¸ã€‚ å‚è€ƒã«ãªã£ãŸã‚µã‚¤ãƒˆã‚’ãƒ¡ãƒ¢ã€‚ http://d.hatena.ne.jp/rx7/20101015/p1 DeNAã®æ¾ä¿¡ã•ã‚“ã®ã‚»ãƒŸãƒŠãƒ¼å†…å®¹ã®ã¾ã¨ã‚ã‚µã‚¤ãƒˆã€‚ åŠ©ã‹ã‚Šã¾ã—ãŸã€‚ http://www.percona.com/files/presentations/percona-live/london-2011/PLUK2011-tuning-for-speed-percona-server-and-fusion-io.pdf http://www.percona.com/files/presentations/percona-live/nyc-2011/PerconaLiveNYC2011-Tuning-For-Speed-Percona-Server-and-Fusion-io.pdf Fusio
puchiban 2012/05/31
fusionio

mysql
ãƒªãƒ³ã‚¯
MySQLã®ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å°‘ã—ã§ã‚‚ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«ã™ã‚‹æ–¹æ³• - ã‚«ã‚¤ãƒ¯ãƒ¬ã®å¤§å†’é™º Third
MySQL Casual Advent Calendar 2011ã®è£œæ¬ è¨˜äº‹ã§ã”ã–ã„ã¾ã™ã€‚æŠ˜è§’ç”³ã—è¾¼ã‚“ã ã®ã§ã€æ›¸ã„ãŸæ¬¡ç¬¬ã§ã”ã–ã„ã¾ã™ã€‚ CASEæ–‡ã¨ã¯ã€ã¨ã„ã†è©±ã—ã‚’æ›¸ã“ã†ã¨æ€ã„ã¾ã—ãŸãŒã€ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«ã‚„ã‚ã¾ã—ãŸã‚ˆï¼ ãã‚“ãªè©±ã¯ã•ã¦ãŠãã€ã‚¿ã‚¤ãƒˆãƒ«ã‹ã‚‰è¦‹ã‚‹é™ã‚Šã€æ—¥æœ¬èªžã§ãŠï½‹ã¨è¨€ã‚ã‚Œãã†ã§ã™ãŒã€å˜ã«æ¯Žæ—¥è§¦ã‚Œã¦ã„ã‚‹ä½œæ¥ã‚’å°‘ã—ã§ã‚‚è»½æ¸›ã§ããŸã‚‰ã„ã„ã§ã™ã‚ˆãã€ã¨ã„ã†ã“ã¨ã§ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ï¼ˆæ°—è»½ï¼‰ã«MySQLã¨æˆ¯ã‚Œã‚‹æ–¹æ³•ã‚’æ›¸ã„ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ æƒ…å ±è¶³ã‚Šããƒ¼ã‚ˆã£ã¦å ´åˆ ã¾ãšã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒ—ãƒãƒ³ãƒ—ãƒˆã§ã™ãã€‚ ã“ã‚“ãªæ„Ÿã˜ã€‚è‰²æ°—ãŒãªã„ã§ã™ãªã€‚ ãªã®ã§ã€å‘³ã‚’ã¤ã‘ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ sugyanã•ã‚“ã‚‚6æ—¥ç›®ã®è¨˜äº‹ã§è§¦ã‚Œã¦ã„ã¾ã—ãŸãŒã€MySQLã§ã¯ã€ŒMYSQL_PS1ã€ã¨ã„ã†ç’°å¢ƒå¤‰æ•°ã‚’åˆ©ç”¨ã§ãã¾ã™ã€‚ãªã®ã§ã€.bashrcã¨ã‹ã«ä»¥ä¸‹ã®ã‚ˆã†ã«æ›¸ã„ã¦ãŠãã¨ã€MySQLã®ãƒ—ãƒãƒ³ãƒ—ãƒˆã«ãŠå¥½ã¿ã®æƒ…å ±ã‚’åŠ ãˆã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã“ã§ä½¿ãˆã‚‹ã‚ª
puchiban 2012/05/29
mysql
ãƒªãƒ³ã‚¯
ã€ŒMySQL Casual Talks vol.2ã€ã«å‚åŠ ã—ã¦ããŸã‚ˆã€ã®ãƒ¡ãƒ¢ - å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€…
ç¬¬1å›žã«å¼•ãç¶šãã€"ã‚ã¾ã‚Šã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã§ã¯ãªã„ï¼Ÿ"ãŒå®šèª¬ã¨ãªã‚Šã¤ã¤ã‚ã‚‹ï½—ã€ŒMySQL Casual Talksã€ã®ç¬¬2å›žãŒé–‹å‚¬ã•ã‚ŒãŸã®ã§ã€è¡Œã£ã¦ãã¾ã—ãŸã€‚å‰å›žã«å¼•ãç¶šãé¢ç™½ã‹ã£ãŸã®ã§ã€è‡ªåˆ†ã®ãƒ¡ãƒ¢æ›¸ãã‚’è²¼ã‚Šä»˜ã‘ã¦ãŠãã¾ã™ã€‚ (å…¨ç„¶è¿½ã„ã¤ã„ã¦ãªã„ãƒ¡ãƒ¢ã‚‚å¤šã„ã—ã€ã‚¹ãƒ”ãƒ¼ãƒ‰æ„ŸãŸã£ã·ã‚Šã ã£ãŸã®ã§é–“é•ã£ãŸè¨˜è¼‰ã‚‚ã‚ã‚‹ã‹ã‚‚ã§ã™ãŒã€ãã“ã¯ã”äº†æ‰¿ã‚’...) # ä¾‹ã«ã‚ˆã£ã¦ã€ç™ºè¡¨è³‡æ–™ãŒå‡ºæƒã£ãŸã‚‰ãã¡ã‚‰ã‚’è¦‹ã¦ã„ãŸã ã„ãŸæ–¹ãŒè‰¯ã„ã§ã™ã€‚ ã¡ãªã¿ã«ã€ç¬¬1å›žã®ãƒ¡ãƒ¢ã‚¨ãƒ³ãƒˆãƒªã¯ã€ã€ ã€ŒMySQL Casual Talks vol.1ã€ã«å‚åŠ ã—ã¦ããŸã‚ˆã€ã®ãƒ¡ãƒ¢ - å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€… è¿½è¨˜ ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã‚‚ã¾ã¨ã‚çš„ã«ã€å…¬é–‹ã•ã‚ŒãŸè³‡æ–™ã‚‚ç´¹ä»‹ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ï½— MySQLã§NoSQL (@oinume) View more presentations from Kazuhiro Oinuma ç”Ÿæ²¼ã•ã‚“ã€å®Ÿã¯MySQLã¯
puchiban 2011/08/12
mysql
ãƒªãƒ³ã‚¯
layer8.sh
This domain may be for sale!
puchiban 2011/01/25
formance]

MySQL

performance
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã€€ã¾ã¨ã‚ - ãŠç¬‘ã„ãƒ—ãƒã‚°ãƒ©ãƒžã®æŠ€è¡“ãƒ¡ãƒ¢
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚’ä½œã‚‹æ™‚ã«å‚è€ƒã«ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„KVSã®é¸å®šã€è¨è¨ˆãªã©ã®è¨˜äº‹ã‚„ã‚¹ãƒ©ã‚¤ãƒ‰ã®ã¾ã¨ã‚ 2013-02-03è¿½è¨˜ ã‚¹ãƒ©ã‚¤ãƒ‰ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ http://www.slideshare.net/matsunobu/ss-6584540 ã¨ã‚ã‚‹ã‚¢ãƒ—ãƒªã®é–‹ç™ºé‹ç”¨(ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒˆ) http://www.slideshare.net/takafumionaka/ss-5852561 PHPã§å¤§è¦æ¨¡ãƒ–ãƒ©ã‚¦ã‚¶ã‚²ãƒ¼ãƒ ã‚’é–‹ç™ºã—ã¦ã‚ã‹ã£ãŸã“ã¨ http://www.slideshare.net/ketaiorg/php-4638298 Lampã§ä½œã‚‹ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—ãƒªã®è² è·å¯¾ç–ã€œã‚¢ãƒ—ãƒªã¨ã‚¤ãƒ³ãƒ•ãƒ©ã®èª¿å’Œã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã€œ (Klabã•ã‚“) http://www.slideshare.net/klab/4-d6963726f736f667420506f776572506f696e
puchiban 2011/01/25
mysql

ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ

DB
ãƒªãƒ³ã‚¯
MySQLã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã¨ãƒ•ãƒªãƒ¼ã®ãƒ„ãƒ¼ãƒ« - ãŠç¬‘ã„ãƒ—ãƒã‚°ãƒ©ãƒžã®æŠ€è¡“ãƒ¡ãƒ¢
MySQLã‚’ä½¿ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆã‚’ã—ãªãã¦ã¯ã„ã‘ãªãã¦ã€è‰¯ã„ãƒ„ãƒ¼ãƒ«ã¯ãªã„ã‹ãª?ã¨æŽ¢ã—ãŸã¨ã“ã‚ã€çµå±€è¡Œãç€ã„ãŸã®ã¯ MySQLãŒä½œã£ã¦ã„ã‚‹ãƒ•ãƒªãƒ¼ã®ãƒ„ãƒ¼ãƒ« MySQL Workbenchã§ã™ã€‚ ç¾æ™‚ç‚¹ã§ã®æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ã€MySQL Workbench 5.2.31 CE, Revision 71155 å…¬å¼ã‚µã‚¤ãƒˆ & ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã®éš›ã€ä¼šå“¡ç™»éŒ²ãŒå¿…è¦ã§ã™ã€‚ MySQL :: MySQL Workbench 5.2 http://www-jp.mysql.com/products/workbench/ ä½¿ç”¨æ„Ÿ ãƒ•ãƒªãƒ¼ã§ã‚³ã‚³ã¾ã§ã§ãã‚‹ãªã‚“ã¦ç´ æ•µ ã¡ã‚‡ã£ã¨é…ã„(é‡ã„)ã‹ã‚‚ ã¡ã‚‡ã£ã¨ã‚ã‹ã‚Šã¥ã‚‰ã„ã‹ã‚‚(ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œã‚Šæ–¹ã¨ã‹) ã©ã‚“ãªã“ã¨ãŒã§ãã‚‹? ãƒ»ãƒªãƒ¢ãƒ¼ãƒˆã®ã‚µãƒ¼ãƒã«æŽ¥ç¶šã—ã€ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ãŸã‚Šã€ã„ã˜ã£ãŸã‚Š(phpMyadminçš„ãª) ãƒ»ä»Šå‹•ã„ã¦ã„ã‚‹ãƒªãƒ¢ãƒ¼ãƒˆã®MySQLã‚µãƒ¼ãƒã«ã¤ãªã„ã§
puchiban 2011/01/22
MySQL
ãƒªãƒ³ã‚¯
Top 84 MySQL Performance Tips | Debian Admin
MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries. You can check the same tips from here.Here is very useful tips for all mysql DBAâ€™s,Developers these tips are noted from MySQL Camp 2006 suggested by mysql community experts. Kaj (Most Excellent Obvious Facilitator) Index s
puchiban 2010/11/26
mysql
ãƒªãƒ³ã‚¯
gihyo.jp
NVIDIAã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢â â ã€NVIDIA vGPUã®Linuxç”¨ãƒ‰ãƒ©ã‚¤ãƒã‚³ãƒ¼ãƒ‰ã‚’å…¬é–‹ OSãƒ»ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ— éšŽæˆ¸ã‚¢ã‚ãƒ© 72 2024-09-27 Ubuntu 24.10ï¼ˆoracularï¼‰ã®é–‹ç™º / ãƒ™ãƒ¼ã‚¿ãƒªãƒªãƒ¼ã‚¹â â ã€Xeon 6ã‚·ãƒªãƒ¼ã‚ºï¼ˆSierra Forestâ â ã€Granite Rapidsï¼‰ã¸ã®å¯¾å¿œ OSãƒ»ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ— å‰ç”°å² 40 2024-09-27
puchiban 2010/11/24
mysql

nosql
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–éƒ¨çš„ã«ã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ çš„ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æä¾›ã‚‚è¡Œã£ã¦ã„ã¾ã™ã€‚æ€ªç›—ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’è¦‹ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10ã‚¿ã‚¤ãƒˆãƒ«è¿‘ãã¯ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚æ›¸ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ä¸€è¦§ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ - Techno logy of DeNA ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€2 - Techno logy of DeNA ã€ŒMySQL
puchiban 2010/11/15
mysql
ãƒªãƒ³ã‚¯
Amazon Web Services Developer Community : Running MySQL on Amazon EC2 with Elastic Block Store
This is just a heads up to newcomers that there are currently unresolved issues with running xfs file systems on ebs volumes. The causes seem to be unknown and not all distribution/kernel combinations trigger the issues, but if you are getting started with this it might be worth considering the implications and either carefully testing your specific configuration or if your requrements don't manda
puchiban 2010/08/09
ec2

MySQL

Amazon
ãƒªãƒ³ã‚¯
MySQL Workbenchã§ãƒªãƒ¢ãƒ¼ãƒˆDBã®ERå›³ã‚’å‡ºã™ | èŠ¸äººç¤¾é•·ã®ãƒ–ãƒã‚°
ãƒ•ãƒªãƒ¼(GPL)ãªMySQL Workbenchã‚’ä½¿ã£ã¦ã€MySQLã®ERå›³ã‚’å‡ºã—ã¦ã¿ãŸã€‚ ä»¥ä¸‹ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰æ–¹æ³•ã¨ã€ä½œã‚Šæ–¹ã€‚ MySQLãƒ•ãƒªãƒ¼(GPL)ãªMySQL Workbenchã‚’ä½¿ã£ã¦ã€MySQLã®ERå›³ã‚’å‡ºã—ã¦ã¿ãŸã€‚ ä»¥ä¸‹ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰æ–¹æ³•ã¨ã€ä½œã‚Šæ–¹ã€‚ MySQL Workbenchã£ã¦ä½•? ä»¥ä¸‹ã‚’è¦‹ã‚‹ã¨æ¦‚è¦ãŒã‚ã‹ã‚‹ã€‚ MySQL :: MySQL Workbench 5.1ã€€ â–¡ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ä»¥ä¸‹ã‚ˆã‚Šã€MySQL Workbench (GUI Tool)ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã€‚ (è¦ãƒ¦ãƒ¼ã‚¶ç™»éŒ²ã€‚ç¾æ™‚ç‚¹2010å¹´7æœˆã§ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ã€ 5.2.25) MySQL :: MySQL Downloads (Generally Available) â–¡ERå›³ã®å–ã‚Šæ–¹ 1. ä¸Šè¨˜ã‚¿ãƒ–ã® DataBase -> Reverse Engineer ã‹ã‚‰ã‚’é¸æŠžã€‚ 2. Reverse E
puchiban 2010/07/01
ERå›³ã‚’ãƒªãƒ¢ãƒ¼ãƒˆã®DBã‹ã‚‰ä½œã‚‹æ–¹æ³•ã€‚

MySQL

database
ãƒªãƒ³ã‚¯
å®ŸéŒ²MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° æ˜¥ã®é™£ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
long_query_time = 0.5 ã¨ã‹é–¾å€¤ã‚’å°ã•ã‚ã«ã—ã¦ã‚‚ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãŒå‡ºãªããªã£ãŸã‘ã©ã€CPU(user)ä½¿ç”¨çŽ‡é«˜ã„ã¨ã‹ã€ãªã‚“ã‹è¶³å¼•ã£å¼µã£ã¦ã‚‹ã‚¯ã‚¨ãƒªãŒã‚ã‚‹ã£ã½ã„ãªãã¨ã„ã†å ´åˆã®ãŠè©±ã§ã™ã€‚ ã€Œå®ŸéŒ²ã€ã®é€šã‚Šã€ç¾åœ¨çµ¶è³›é€²è¡Œä¸ã§ã™ã®ã§ã€é€æ¬¡å‹•ããŒã‚ã£ãŸã‚‰æ›¸ãè¶³ã—ã¦ã„ãã¤ã‚‚ã‚Šã§ã™ã€‚ ã€Œã‚ã‚Œã‚’è¦‹ãŸæ–¹ãŒã„ã„ã€ã¨ã‹ã€Œã“ã‚Œã‚’ã‚ãƒ¼ã—ãŸæ–¹ãŒã„ã„ã€ã¨ã‹ã‚ã‚Œã°ã€ã‚³ãƒ¡ãƒ³ãƒˆã‹Twitterã§ @hirose31 ã¾ã§ãŠçŸ¥ã‚‰ã›ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ï¼ ä½¿ç”¨ã—ã¦ã„ã‚‹ã®ã¯ã€MySQL 5.1.41 ã§ã™ã€‚ å‰æ: ã‚µãƒ¼ãƒãƒ¼ãƒªã‚½ãƒ¼ã‚¹ã®ã‚°ãƒ©ãƒ• Gangliaã§ã‚‚Cactiã§ã‚‚Muninã§ã‚‚ãªã‚“ã§ã‚‚ã„ã„ã‚“ã§ã™ãŒã€ã‚µãƒ¼ãƒãƒªã‚½ãƒ¼ã‚¹ã®ã‚°ãƒ©ãƒ•åŒ–ã¯å¿…é ˆã§ã™ã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ãŸéš›ã®åŠ¹æžœæ¸¬å®šã‚„ã€ãã‚ãã‚ãƒªã‚½ãƒ¼ã‚¹é£Ÿã„æ½°ã—ã¦ã‚„ã°ã„ã¨ã‹ã®äºˆæ¸¬ã«ã‚‚ä½¿ãˆã¾ã™ã€‚ è‡ªåˆ†ã¯DBã‚µãƒ¼ãƒã®å ´åˆã“ã®ã‚ãŸã‚Šã‚’ã‚°ãƒ©ãƒ•åŒ–ã—ã¦ã¾ã™ã€‚ CPUä½¿ç”¨çŽ‡ (user,
puchiban 2010/05/23
mysql

performance

tuning
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
puchiban 2010/04/02
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯? ã©ã†ã‚¹ã‚±ãƒ¼ãƒ«ã™ã‚‹ã®? æ¤œç´¢ã¯?ã€€ã‚ãŸã‚ŠãŒæ°—ã«ãªã‚‹ã€‚

DB

mysql
ãƒªãƒ³ã‚¯
GitHub - google/mysql-tools
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
puchiban 2010/01/11
Google

mysql
ãƒªãƒ³ã‚¯
Google Code Archive - Long-term storage for Google Code Project Hosting.
puchiban 2010/01/11
mysql

Google
ãƒªãƒ³ã‚¯
MySQLTunerã‚’ä½¿ã£ã¦MySQLã‚’é€Ÿãã™ã‚‹ | ï¾Œï¾žï½°ãƒã‚°
MySQLTunerã¯MySQLã‚’è¨ºæ–ã—ã¦ã€ã„ã‚ã„ã‚ã‚¢ãƒ‰ãƒã‚¤ã‚¹ã—ã¦ãã‚Œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã€‚perlã‚¹ã‚¯ãƒªãƒ—ãƒˆã§æä¾›ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç°¡å˜ã«å®Ÿè¡Œã§ãã‚‹ã€‚ãªãŠWindowsã§ã¯å‹•ã‹ãªã„ã‚‰ã—ã„ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦å®Ÿè¡Œã™ã‚‹ã€‚ $ wget http://mysqltuner.com/mysqltuner.pl $ chmod +x mysqltuner.pl $ ./mysqltuner.pl ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸã€‚ >> MySQLTuner 0.9.9 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering Please enter y
puchiban 2009/12/14
mysql

tuning

performance
ãƒªãƒ³ã‚¯
ã•ãã‚‰ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒ
ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãªã‚‰ã€Œã•ãã‚‰ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã€ï¼ æœˆé¡æ›ç®—ã§ã‚ãšã‹129å††ã€ç¼¶ã‚¸ãƒ¥ãƒ¼ã‚¹1æœ¬åˆ†ã®ãŠå€¤æ®µã§ä½¿ãˆã‚‹æ ¼å®‰ãƒ—ãƒ©ãƒ³ã‹ã‚‰ã€ãƒ“ã‚¸ãƒã‚¹ã«ã‚‚ä½¿ãˆã‚‹å¤šæ©Ÿèƒ½ï¼†å¤§å®¹é‡ãƒ—ãƒ©ãƒ³ã¾ã§ã€ ç”¨é€”ã¨äºˆç®—ã«åˆã‚ã›ã¦ãƒ—ãƒ©ãƒ³ã‚’é¸ã¹ã¾ã™ã€‚ ã•ã‚‰ã«ãƒžãƒ«ãƒãƒ‰ãƒ¡ã‚¤ãƒ³å¯¾å¿œã§ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ã‚‚ç„¡åˆ¶é™ã€‚ç„¡æ–™ã‚¦ã‚¤ãƒ«ã‚¹ã‚¹ã‚ãƒ£ãƒ³ã‚„ç„¡æ–™é›»è©±ã‚µãƒãƒ¼ãƒˆã‚‚ã‚ã‚‹ã®ã§å®‰å¿ƒã—ã¦ ã”åˆ©ç”¨ã„ãŸã ã‘ã‚‹å…±ç”¨ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚
puchiban 2009/12/10
processlist

mysql
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: MySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•
MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã¨è¨€ã£ãŸå ´åˆã«ã¯ã€ã‚µãƒ¼ãƒãƒ¼ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®èª¿æ•´ã‚„ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã—ãŸã‚¯ã‚¨ãƒªå®Ÿè¡Œè¨ˆç”»ã®æœ€é©åŒ–ãŒè©±é¡Œã«ä¸Šã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ã—ã‹ã—ã€ç™ºè¡Œã™ã‚‹å…¨ã¦ã® SQL ã«ã¤ã„ã¦ã€ã„ã¡ã„ã¡ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ã¦ç¢ºèªã—ã¦ã„ã¦ã¯ã€ã„ãã‚‰æ™‚é–“ãŒã‚ã£ã¦ã‚‚ãŸã‚Šã¾ã›ã‚“ã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’åŠ¹çŽ‡çš„ã«é€²ã‚ã‚‹ã«ã¯ã€ã¾ãšã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã£ã¦ã„ã‚‹ SQL ã‚¯ã‚¨ãƒªã‚’ç‰¹å®šã—ã€æ¬¡ã«ãã®æœ€é©åŒ–ã‚’è¡Œã†ã¹ãã§ã™ã€‚ ã§ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’ç‰¹å®šã™ã‚‹ã®ã‹ã€‚MySQL Conference & Expo 2009 ã®ã‚ãƒ¼ãƒŽãƒ¼ãƒˆã«ãŠã„ã¦ Mark Callaghan æ°ã¯ã€Google ã§ã¯ SHOW PROCESSLIST ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ãŸçµ±è¨ˆçš„ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’ä½¿ã£ã¦ã„ã‚‹ã¨è¿°ã¹ã¦ã„ã‚‰ã£ã—ã‚ƒã„ã¾ã™ (å‚ç…§: MySQLConf 09: Mark Callaghan, "This is Not a
puchiban 2009/09/29
MySQL

è² è·åˆ†æ•£
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸