[B! mysql][ãŠå½¹ç«‹ã¡] harumaki_netã®ãƒ

harumaki_net id:harumaki_net

mysqlã¨ãŠå½¹ç«‹ã¡ã«é–¢ã™ã‚‹harumaki_netã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (18)

${{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 ã‚¯ãƒ©ã‚¦ãƒ‰å‘ã‘ InnoDB ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®æ–°å¸¸è˜ã¯ã“ã‚Œã ï¼ã€ŒMySQL ã‚¯ãƒ©ã‚¦ãƒ‰å‘ã‘ InnoDB ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ ã“ã‚“ã«ã¡ã¯ã€‚ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã® nobuh ã§ã™ã€‚ æ ªå¼ä¼šç¤¾ã‚¤ãƒ³ã‚µã‚¤ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼æ§˜ä¸»å‚¬ã®Â db tech showcase sapporo 2015 Â ãŒ 9æœˆ10æ—¥ã€11æ—¥ã®2æ—¥é–“ã«ã‚ãŸã£ã¦é–‹å‚¬ã•ã‚Œã¾ã—ãŸ ã€‚ ä»Šå›žã€å¼Šç¤¾ã‚‚ç™ºè¡¨ã™ã‚‹æ©Ÿä¼šã‚’é ‚ãã¾ã—ãŸã®ã§ã€ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦æ—¥ã€… MySQL ã¨æ ¼é—˜ã—ã¦åŸ¹ã£ãŸãƒŽã‚¦ãƒã‚¦ã«ã¤ã„ã¦ãŠè©±ã•ã›ã¦é ‚ãã¾ã—ãŸã€‚ãã®ç™ºè¡¨ã§ä½¿ã£ãŸã‚¹ãƒ©ã‚¤ãƒ‰ãŒã“ã¡ã‚‰ã§ã™ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã®ä»®æƒ³ã‚µãƒ¼ãƒãƒ¼ã‚’ä½¿ã£ã¦ MySQL ã®ç®¡ç†ã‚„ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«æ—¥ã€…é‚é€²ã•ã‚Œã¦ã„ã‚‹æ–¹ã€…ã«ã”è¦§ã„ãŸã ã‘ã‚‹ã¨å¹¸ã„ã§ã™ã€‚ ä»Šã¾ã§ã«ã‚‚ MySQL ã«é–¢ã—ã¦ã„ãã¤ã‹è¨˜äº‹ã‚’æŽ²è¼‰ã—ã¦ã„ã¾ã™ã®ã§ã€ã“ã®æ©Ÿä¼šã«æ˜¯éžã”è¦§ãã ã•ã„ï¼ â†’ OSC2015åŒ—æµ·é“ã§ã€Œã“ã‚Œã ã‘ã¿ã‚Œã°å¤§ä¸ˆå¤«ãƒ¼Cactiã«ã‚ˆã‚‹MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœã€
harumaki_net 2015/09/12
MySQL

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

ãŠå½¹ç«‹ã¡

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
å¿«é©mysqlã‚³ãƒžãƒ³ãƒ‰â˜…ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã®æ±ºå®šç‰ˆ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
ã“ã®è¨˜äº‹ã¯ MySQL Casual Advent Calendar 2013 ã®25æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ è‡ªåˆ†ã®éŽåŽ»ã®ãƒ–ãƒã‚°ã‚‚å«ã‚ã¦ã€mysqlã‚³ãƒžãƒ³ãƒ‰ã®ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã«ã¤ã„ã¦ã„ã‚ã„ã‚ãªæƒ…å ±ãŒã‚ã‚Šã¾ã™ãŒã€ã‚ãŸã—ãŒã‚ªã‚¹ã‚¹ãƒ¡ã®ç§˜ä¼ã®ã‚¿ãƒ¬ã‚’ã¾ã¨ã‚ãŸã„ã¨æ€ã„ã¾ã™ã€‚æ˜¯éžã€ã”å‚è€ƒã«ã€‚ å®šåž‹æ–‡(SQL)ã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆå…¥åŠ› ã€Œshow create table TABLENAME\Gã€ã¨ã‹ã€Œselect user,host,password from mysql.user order by user,host;ã€ã¨ã‹ã€ã‚ˆãå®Ÿè¡Œã™ã‚‹ã‘ã©é•·ãã¦å…¥åŠ›ã™ã‚‹ã®ãŒã‚ã‚“ã©ã†ãªã®ãŒã‚ã‚Šã¾ã™ã‚ˆãã€‚ãã‚Œã‚’ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã§å…¥åŠ›ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹æ–¹æ³•ã§ã™ã€‚ mysqlã‚³ãƒžãƒ³ãƒ‰ã§è¡Œç·¨é›†ãŒã§ãã‚‹ã®ã¯ã€readlineã‚„libeditã‚’ãƒªãƒ³ã‚¯ã—ã¦ã„ã‚‹ãŠã‹ã’ã§ã™ã€‚ å¾“æ¥ã®å…¬å¼ãƒã‚¤ãƒŠãƒªé…å¸ƒç‰©ã«å«ã¾ã‚Œã‚‹mysqlã‚³ãƒžãƒ³ãƒ‰ã¯readlineã§ã—ãŸ
harumaki_net 2013/12/25
MySQL

ã‚³ãƒžãƒ³ãƒ‰

ã¾ã¨ã‚

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
http://blog.inouetakuya.info/entry/20130320/1363776504
harumaki_net 2013/03/21
MySQL

è¨å®š

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
MySQLTunerã§MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¨ºæ–ã™ã‚‹æ–¹æ³•
https://github.com/rackerhacker/MySQLTuner-perl MySQLTunerã¯MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¨ºæ–ã—ã¦ãã‚Œã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã™ã€‚ åŸºæœ¬çš„ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒ’ãƒ³ãƒˆã‚’ã‚ã‹ã‚Šã‚„ã™ãè¡¨ç¤ºã—ã¦ãã‚Œã¾ã™ã€‚ MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°è¨å®šã«ä¸å®‰ãªæ–¹ã‚„ã€ã¯ã˜ã‚ã¦MySQLã‚’ã•ã‚ã‚‹æ–¹ã¯è©¦ã—ã¦ã¿ã‚‹ã¨è‰¯ã„ã§ã—ã‚‡ã†ã€‚ ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯GNU GPLã§ç„¡æ–™ã§ä½¿ãˆã¾ã™ã€‚ æ¤œè¨¼ç’°å¢ƒ CentOS 6.3(64bit) MySQL 5.5.28 MySQL 5.5ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« MySQL 5.5ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ # wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm # wget http://ftp.jaist.ac.jp/pub/Linux/Fedora/epel/6/x86
harumaki_net 2012/12/20
MySQL

ãŠå½¹ç«‹ã¡

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ« my.cnf ã‚’githubã«ã¦å…¬é–‹ã—ã¾ã—ãŸ & ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒã‚¤ãƒ³ãƒˆã®ç´¹ä»‹ - blog.nomadscafe.jp
YAPC::Asiaã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§äºˆå‘Šã—ã¦ã„ãŸé€šã‚Šã€å®Ÿéš›ã«å¼Šç¤¾ã®ã„ãã¤ã‹ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã£ã¦ã„ã‚‹ my.cnf ã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ github: https://github.com/kazeburo/mysetup/tree/master/mysql ä»Šå›žã€å…¬é–‹ã—ãŸç†ç”±ã¯MySQl Beginners Talksã®ç™ºè¡¨ã®ä¸ã§ã‚‚è§¦ã‚Œã¦ã„ã‚‹é€šã‚Šã§ã™ã€‚MySQLã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ä¸ã«å«ã¾ã‚Œã‚‹ã‚µãƒ³ãƒ—ãƒ«ã®my.cnfãŒæœ€è¿‘ã®ã‚µãƒ¼ãƒãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚„é‹ç”¨ã«åˆã‚ãªããªã£ã¦æ¥ã¦ã„ã‚‹ã¨ã„ã†çŠ¶æ³ã§ã€è‡ªåˆ†ã®è¨å®šã«ã‚¤ãƒžã‚¤ãƒè‡ªä¿¡ãŒæŒã¦ã¦ã„ãªã„äººã¯å°‘ãªããªã„ã¯ãšã€‚ãã“ã§å„ç¤¾ç§˜ä¼ã®ã‚¿ãƒ¬çš„ãª my.cnf ã‚’Open & Shareã™ã‚‹ã“ã¨ã§ã€ãƒ¢ãƒ€ãƒ³ãªmy.cnfã‚’ä½œã‚Šä¸Šã’ã‚‹äº‹ãŒã§ãã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ã¨ã„ã†è€ƒãˆã®ä¸‹ã€ä»Šå›ž github ã«ã¦å…¬é–‹ã—ã¾ã—ãŸã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã¯4ã¤ã‚ã‚Šã€ãã‚Œãžã‚Œ MySQL 4.0ã€5.1ã€5.5ã€ãã—ã¦ãƒ†ã‚¹ãƒˆä¸
harumaki_net 2012/10/05
MySQL

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
1å°ã‹ã‚‰500å°ã¾ã§ã®MySQLé‹ç”¨(YAPC::Asiaç·¨)
6. Recent CPAN modules â€¢ Apache::BumpyLife â€¢ Twiggy::Prefork â€¢ Module::Install::ShareFile â€¢ App::LoadWatcher â€¢ File::RotateLogs â€¢ Plack::Middleware::AxsLog â€¢ Proclet â€¢ DBIx::DSN::Resolver [new!] 7. Proclet minimalistic supervisor use Proclet::Declare; env( PLACK_ENV => 'development', LM_COLOR => 1, ); service('web', 'plackup -p 9413 app.psgi'); service('memcached', qw!/usr/bin/memcached -p 11211!)
harumaki_net 2012/09/29
MySQL

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
ç¬¬2å›ž ioDrive+MySQLå‹‰å¼·ä¼š ç™ºè¡¨è³‡æ–™ | å¤–é“çˆ¶ã®åŒ
GMOã•ã‚“ã®ã¨ã“ã‚ã§ã€ioDriveï¼‹MySQLã®ç™ºè¡¨ã‚’ã—ã¦ã¾ã„ã‚Šã¾ã—ãŸã€‚ å‰å›žã®Fluentdã‹ã‚‰ä¸4æ—¥ã§ç™»å£‡ã¨ã„ã†æãƒã‚·ã‚¢ãªã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«ã«çœŸã£ç™½ãªç°ã¨ãªã£ã¦ãŠã‚Šã¾ã™ã€‚ ï¼‘ç•ªæ‰‹ã ã£ãŸã®ã§åŸºæœ¬ã‚’æŠ‘ãˆã¤ã¤å°–ã‚Šæ°—å‘³ã®ã¨ã“ã‚ã¾ã§å…¥ã‚Œã¦ã—ã¾ã£ãŸã›ã„ã§ã€40åˆ†ã®ã¨ã“ã‚ã‚’53åˆ†ä½¿ã„ã€ã•ã‚‰ã«è³ªç–‘å¿œç”ã§1æ™‚é–“ä»¥ä¸Šã«ãªã‚Šã€ä»–ã®ç™ºè¡¨è€…ã‚„å‚åŠ è€…ã«ã”è¿·æƒ‘ã‚’ã€ãã—ã¦ãƒ”ã‚¶ã‚’å†·ãˆã•ã›ã¦ç”³ã—è¨³ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ãŒã€è³‡æ–™è‡ªä½“ã¯ã¼ã¡ã¼ã¡ãªå‡ºæ¥ã«ãªã£ãŸã¨æ€ã„ã¾ã™ã®ã§ã‚µã‚¯ãƒƒã¨å…¬é–‹ã—ã¦ãŠãã¾ã™ã€‚ äº‹å‰ã«ãƒšãƒ¼ã‚¸ã‚’å‰Šã‚Šã¨ã£ã¦ã—ã¾ã£ãŸã‚Šã€æ—©é€ã‚Šã§èª¬æ˜Žã—ã¦ã—ã¾ã£ãŸéƒ¨åˆ†ãŒã‚ã‚‹ã®ã§è£œè¶³ã—ãŸã„ã¨ã“ã‚ãªã®ã§ã™ãŒã€ç‡ƒãˆå°½ãç—‡å€™ç¾¤ä¸ãªã®ã§MySQLé–¢é€£ã¯å¾Œã§å°‘ã—ãšã¤æ›¸ã„ã¦ã„ã‘ãŸã‚‰ã¨æ€ã„ã¾ã™ã€‚ æˆ¦åˆ©å“ Fusion-IOç¤¾ã®ã‚µãƒ³ã‚¿ã‚¯ãƒãƒ¼ã‚¹ã¨è¨€ã‚ã‚Œã‚‹ä¾‹ã®æ–¹ãŒã€ç™»å£‡è€…ã«ãƒ—ãƒ¬ã‚¼ãƒ³ãƒˆã‚’ã—ã¦ãã‚Œã¾ã—ãŸã€‚ ã‚´ãƒ«ãƒ•ã‚·ãƒ£ãƒ„ã§ã™ãŒ Mã‚µã‚¤ã‚º Womanç”¨ã§ã€å¾®å¦™ã«å½¢ãŒå¥³
harumaki_net 2012/08/28
â€ã‚¯ã‚¨ãƒªãŒæ¢ã¾ã£ã¦è¦‹ãˆã‚‹ãœâ€æ„Ÿå‹•ã€‚

MySQL

ãŠå½¹ç«‹ã¡

ã“ã‚Œã¯ã™ã”ã„
ãƒªãƒ³ã‚¯
è§£æžã¾ã§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ãƒžã‚·ãƒ³ã«ã€æ™®é€šã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ„Ÿè¦šã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå¯èƒ½ã§ã™ã€‚ ã‚¤ãƒ³
harumaki_net 2012/08/25
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãªã‚‹ã»ã©

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨"FLUSH TABLES WITH READ LOCK"ã«ã¤ã„ã¦ - jitsu102's blog
MySQLã§æ•´åˆæ€§ã®ã‚ã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–å¾—ã™ã‚‹ã®ã«ã€ "FLUSH TABLES WITH READ LOCK"ã§ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å‡¦ç†(mysqldumpã‚„ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆ) "UNLOCK TABLES"ã§ãƒãƒƒã‚¯è§£é™¤ ã¿ãŸã„ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’å®Ÿè¡Œã—ã¦ã„ãŸãŒã€"FLUSH TABLES WITH READ LOCK"ã£ã¦å¿…ãšæ•°ãƒŸãƒªç§’ã¿ãŸã„ãªãƒ¬ãƒ™ãƒ«ã§ãƒãƒƒã‚¯ã§ãã‚‹ã®ã‹ãªã¨ç–‘å•ã«æ€ã£ãŸã€‚ çµæ§‹æ™‚é–“ã®ã‹ã‹ã‚‹ã‚¯ã‚¨ãƒªãŒå‡¦ç†ã•ã‚Œã¦ã„ãŸã‚Šã™ã‚‹ã¨ã€ã™ãã«ãƒãƒƒã‚¯ã§ããªã„ã‚“ã§ã¯ãªã„ã‹ã¨æ€ã£ãŸã€‚ ã¡ã‚‡ã£ã¨èª¿ã¹ã¦ã¿ã‚‹ã¨ã€ã‚„ã¯ã‚Šã™ãã«ãƒãƒƒã‚¯ã•ã‚Œãªã„å¯èƒ½æ€§ã‚‚ã‚ã‚‹ã‚ˆã†ã ã€‚*1 FLUSH TABLES WITH READ LOCKã®é€Ÿåº¦ã«ã¤ã„ã¦ ã¨ã„ã†ã“ã¨ã§ã€"FLUSH TABLES WITH READ LOCK"å¾Œã«ã€ä»¥ä¸‹ã®ã‚ˆã†ãªç¢ºèªå‡¦ç†ã‚’è¿½åŠ ã—ãŸã€‚ "SHOW PROCESSLIST"ã‚’å®Ÿè¡Œã—ã¦ã€"FLUS
harumaki_net 2012/08/24
mysql

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
SQLã§å¤§é‡ãƒ‡ãƒ¼ã‚¿ã‚’ä¸€æ°—ã«ä½œã‚‹ã§ã”ã–ã‚‹(MySQLç·¨) @ t100ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è„±å‡ºä½œæˆ¦
è‡ªåˆ†ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è„³ã‚’ãƒ—ãƒã‚°ãƒ©ãƒ ã«ã—ã¦ã€ã„ã¤ã‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‹ã‚‰è„±å‡ºã—ã¦ã‚„ã‚‹ãžã£ï¼ã¨ã‹å¤¢è¦‹ãªãŒã‚‰ã€æ—¥ã€…ãƒ—ãƒã‚°ãƒ©ãƒ ä½œã£ã¦ã„ã ç™¾é‡Ž è²´åš ã®æ—¥è¨˜ã§ã™ï¼ä»Šã¯ã€å±‹å·ã€Žç™¾è”µã€‚ã€ã¨ã—ã¦ã€Silverlightãƒ»WPFã‚’è¿½è·¡ä¸ã§ã™ï¼ (2007/09/30) é–‹ç™ºã‚’ã—ã¦ã„ã¦ã€å¤§é‡ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ãŒæ¬²ã—ã„ãªãƒ¼ã¨ã„ã†ã“ã¨ãŒæ™‚ã€…ã‚ã‚Šã¾ã™ã€‚ å…ˆæ—¥ã®ã€ã€ŒMySQLã® using temporary; using filesort ãŒä½•æ•…é…ã„ã®ã‹ã€ã®å†…å®¹ã‚‚ã€å®Ÿéš›ã«æ¤œè¨¼ã—ã¦ã¿ã‚‹ã«ã¯ã€sort_buffer_size ã‚’è¶…ãˆã‚‹é‡ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ ã—ã‹ã—ã€ã“ã‚ŒãŒæ„å¤–ã¨é¢å€’ãã•ã„ã£ ä½¿ã„æ…£ã‚ŒãŸã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã§ã€ãƒãƒ§ãƒãƒ§ã‚¤ã¨ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãã®ã‚‚OKãªã®ã§ã™ãŒã€ã§ã‚‚ã‚„ã£ã±ã‚Šé¢å€’ãã•ã„ã£ ï¼ˆã§ã™ã‚ˆãï¼Ÿï¼‰ ã¨ã„ã†ã“ã¨ã§ã€ä»Šå›žã¯SQLã ã‘ã§å¤§é‡ãƒ‡ãƒ¼ã‚¿ã‚’ä½œã‚‹æ–¹æ³•ã‚’è€ƒãˆã¦è¦‹ã¾ã™ã€‚ ã¨ã„ã£ã¦ã‚‚ã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã§ãƒ«ãƒ¼ãƒ—ã¨
harumaki_net 2012/08/03
MySQL

ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
ã‚¯ãƒªã‚¢ãƒã‚ªã®å£ã‚³ãƒŸã£ã¦ä¿¡ã˜ã¦ã„ã„ï¼ŸåŠ¹æžœã¯ç¢ºå®Ÿãªã®ï¼Ÿ | æ„›ã¨å°ç”º
ã‚¯ãƒªã‚¢ãƒã‚ªã®ç‰¹å¾´ ç„¡æ·»åŠ ãƒ»ç„¡ç€è‰²ã ã‹ã‚‰è‚ŒãŒå¼±ã„äººã§ã‚‚å®‰å¿ƒ ãƒ¯ã‚ã‚¬ã‚„å«Œãªè‡ã„ã®åŽŸå› ã¨ãªã‚‹èŒã‚’æ®ºèŒãƒ»æ¶ˆæ¯’ ãŠå¾—ãªå®šæœŸã‚³ãƒ¼ã‚¹ã¯ã€è³¼å…¥ç¸›ã‚Šãªã—ï¼ã„ã¤ã§ã‚‚è§£ç´„å¯èƒ½ ä½“è‡ã®æ‚©ã¿ã¯è€è‹¥ç”·å¥³å•ã‚ãšå…±é€šã®æ‚©ã¿ã§ã™ãŒã€ä»–äººã«ã¯ç›¸è«‡ã—ã«ãã„ã®ã§1äººã§æ‚©ã‚“ã§ã„ã‚‹äººãŒå¤šã„ã‚“ã§ã™ã€‚ ä½“è‡ã£ã¦ã€è‡ªåˆ†ã§ãƒ‹ã‚ªã‚¤ãŒæ°—ã«ãªã£ãŸæ™‚ã¯ã€ä»–ã®äººã¯ã‚‚ã£ã¨ã‚¯ã‚µã‚¤ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ã‚‚ã—ã‚ãªãŸãŒã€è‡ªåˆ†ã§ãƒ¯ã‚ã‚¬ã‹ã‚‚â€¦ã¨æ€ã†ã®ã§ã‚ã‚Œã°ã€å‘¨ã‚Šã®äººã¯ã‚ãªãŸã®ãƒ‹ã‚ªã‚¤ã«æ°—ã¥ã„ã¦ã„ã‚‹ã‹ã‚‚â€¦ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã€ãã‚“ãªãƒ¯ã‚ã‚¬è‡ã‚„è¶³ã®ãƒ‹ã‚ªã‚¤ãªã©ã€ã‚¤ãƒ¤ãƒ¼ãªä½“è‡å…¨èˆ¬ã‚’10ç§’ã§ã‚«ãƒƒãƒˆã—ã¦ãã‚Œã‚‹ã‚“ã§ã™ã€‚ ã‚¯ãƒªã‚¢ãƒã‚ªã®åŠ¹æžœã‚„å£ã‚³ãƒŸã‚’èª¿æŸ»ã—ã¾ã—ãŸã®ã§å¾¹åº•è§£èª¬ã—ã¾ã™ã€‚ è³¼å…¥æ™‚ã«ç‰¹å…¸ãŒä»˜ã„ã¦ãã‚‹ã®ã§ãŠå¾— å…¬å¼ã‚µã‚¤ãƒˆã¯ã‚³ãƒãƒ© â€»ç‰¹å…¸ã¯æ¯Žæœˆå¤‰ã‚ã‚‹ã®ã§å…¬å¼ã‚µã‚¤ãƒˆã§ã”ç¢ºèªãã ã•ã„ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã©ã‚“ãªäººã«ãŠã™ã™ã‚ï¼Ÿ ã‚¯ãƒªã‚¢ãƒã‚ªã®æ®ºèŒçŽ‡ã¯ã€ãªã‚“ã¨99.999%ï¼ä½“è‡ã®æ‚©ã¿ã‚’è§£æ¶ˆã—ã¦ãã‚Œã‚‹ã‚¯ãƒª
harumaki_net 2012/07/24
ãªã‚“ã¨ã„ã†ã‹ã€ã¾ã¨ã‚ã®æ®¿å ‚ã«ã—ãŸã„ã€‚

MySQL

ã¾ã¨ã‚

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
harumaki_net 2012/06/21
MySQL

é«˜é€ŸåŒ–

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
JdbcRunner - æ±Žç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«
https://dbstudy.info/jdbcrunner/ ã«ç§»è»¢ã—ã¾ã—ãŸã€‚ ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ã«æˆ»ã‚‹ Overview JdbcRunnerã¯å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¯¾è±¡ã¨ã—ãŸè² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å®šç¾©ã—ã¦å¤šé‡å®Ÿè¡Œã—ã€ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆã¨ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚¿ã‚¤ãƒ ã‚’æ¸¬å®šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã¾ãŸã€JdbcRunnerã«ã¯Oracleã€MySQLã€PostgreSQLã‚’å¯¾è±¡ã¨ã—ãŸä»¥ä¸‹ã®ãƒ†ã‚¹ãƒˆã‚ãƒƒãƒˆãŒä»˜å±žã—ã¦ãŠã‚Šã€ ãƒ¦ãƒ¼ã‚¶ãŒç‹¬è‡ªã«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œæˆã™ã‚‹ä»¥å¤–ã«ã€ã“ã‚Œã‚‰ã‚’ç”¨ã„ãŸè² è·ãƒ†ã‚¹ãƒˆã‚’è¡Œã†ã“ã¨ã‚‚å¯èƒ½ã¨ãªã£ã¦ã„ã¾ã™ã€‚ Tiny SysBench - SysBench OLTPãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã®ç§»æ¤ç‰ˆ Tiny TPC-B - TPC-Bã®ç°¡æ˜“å®Ÿè£… Tiny TPC-C - TPC-Cã®ç°¡æ˜“å®Ÿè£… Download JdbcRunnerã¯ã€Vectorã‚½ãƒ•ãƒˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚
harumaki_net 2012/06/19
MySQL

ã‚ã¨ã§èªã‚€

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
ã‚¯ã‚¨ãƒªã®æ”¹å–„ã«ã€‚MySQLã®Slow Query Logã‚’å¯è¦–åŒ–ã™ã‚‹Â·MySQL slow-query-log Visualizer MOONGIFT
MySQL slow-query-log Visualizerã¯MySQLã®æ™‚é–“ã®ã‹ã‹ã‚‹ã‚¯ã‚¨ãƒªã‚’Webä¸Šã§é–²è¦§ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ MySQLã«ã¯å®Ÿè¡Œæ™‚é–“ã®é…ã„ã‚¯ã‚¨ãƒªã‚’ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãå‡ºã™æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚å˜ç´”ã«ãƒ†ã‚ã‚¹ãƒˆã«åã‹ã‚Œã‚‹ã ã‘ãªã®ã§åˆ†æžã«æ™‚é–“ãŒã‹ã‹ã£ã¦ã—ã¾ã†ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãã“ã§ä½¿ã£ã¦ã¿ãŸã„ã®ãŒWebãƒ–ãƒ©ã‚¦ã‚¶ãƒ™ãƒ¼ã‚¹ã®è§£æžã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢MySQL slow-query-log Visualizerã§ã™ã€‚ ã‚µãƒ³ãƒ—ãƒ«ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿é‡ãŒå¤šããªã„ã¨ã‚ã¾ã‚Šé¢ç™½ããªã„ã§ã™ãã€‚ å…¬å¼ã‚µã‚¤ãƒˆã‚ˆã‚Šã€‚æ›œæ—¥ã”ã¨ã«ç™ºç”Ÿå›žæ•°ã‚’ã‚°ãƒ©ãƒ•åŒ–ã—ã¦ã„ã¾ã™ã€‚ ã‚¯ã‚¨ãƒªãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’Webãƒ–ãƒ©ã‚¦ã‚¶ã®ç”»é¢ã«ãƒ‰ãƒãƒƒãƒ—ã™ã‚‹ã ã‘ã§è§£æžå‡¦ç†ãŒè¡Œã‚ã‚Œã¾ã™ã€‚ãã®çµæžœã¯ã‚°ãƒ©ãƒ•ã«æã‹ã‚Œã‚‹ä»•çµ„ã¿ã§ã™ã€‚ã¾ãŸã€ã‚¯ã‚¨ãƒªã¯ä¸€è¦§ã§è¡¨ç¤ºã•ã‚Œã€ä»»æ„ã®æ–‡å—ã§ãƒ•ã‚£ãƒ«ã‚¿ãƒªãƒ³ã‚°ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚æ›œæ—¥ã¨æ™‚é–“ã«ã‚ˆã£ã¦åˆ†æžã•ã‚Œã‚‹ã®ã§å¯¾å¿œã™ã¹ããƒã‚¤ãƒ³ãƒˆãŒåˆ†ã‹ã‚Šã‚„ã™ããª
harumaki_net 2012/06/19
MySQL

ã‚ã¨ã§èªã‚€

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
MySQLãƒã‚¤ãƒŠãƒªãƒã‚°ã®ä»•æ§˜ â€“ OpenGroove
MySQLã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã«ã¤ã„ã¦ã€ã†ã£ã™ã‚‰ã¾ã¨ã‚ã¦ã¿ã‚ˆã†ã‹ã¨ã€‚ RDBMSã§æ›´æ–°ãƒã‚°ã¾ãŸã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒã‚°ã¨å‘¼ã°ã‚Œã¦ã„ã‚‹ãƒã‚°ã®æ©Ÿèƒ½ã¯ã€ MySQLã§ã¯ã€Œãƒã‚¤ãƒŠãƒªãƒã‚°ã€ãŒæ‹…ã£ã¦ã„ã‚‹ã€‚ ã“ã‚Œã‚‰ã®å†…å®¹ã¯ã€ã€ŒCREATE TABLEæ–‡ã‚„INSERTæ–‡ã¨ã„ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸èº«ã‚’ å¤‰æ›´ã™ã‚‹æ“ä½œã‚’è¡Œã£ãŸéš›ã®æ“ä½œå±¥æ´ã‚’è¿½è·¡ã§ãã‚‹å½¢ã§è¨˜éŒ²ã—ãŸæƒ…å ±ã€ã§ã‚ã‚Šã€ ã‚³ãƒŸãƒƒãƒˆã•ã‚ŒãŸãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®æƒ…å ±ãŒä¿å˜ã•ã‚Œã‚‹ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒã‚°ã®ä¸èº«ã¯RDBMSã«ã‚ˆã£ã¦ç•°ãªã‚Šã€ã€Œè«–ç†ãƒã‚®ãƒ³ã‚°ã€ã¨ ã€Œç‰©ç†ãƒã‚®ãƒ³ã‚°ã€ãŒã‚ã‚‹ã€‚ã€Œè«–ç†ãƒã‚®ãƒ³ã‚°ã€ã¯SQLæ–‡ãƒ¬ãƒ™ãƒ«ã§å¤‰æ›´å±¥æ´ã‚’ç®¡ç†ã—ã€ ã€Œç‰©ç†ãƒã‚®ãƒ³ã‚°ã€ã¯å¤‰æ›´ãŒã‚ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ–ãƒãƒƒã‚¯ã‚’ãƒã‚¤ãƒŠãƒªã‚¤ãƒ¡ãƒ¼ã‚¸ã¨ã—ã¦ç®¡ç†ã™ã‚‹ã€‚ MySQLã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã¯è«–ç†ãƒã‚®ãƒ³ã‚°ã ãŒã€Oracleã®REDOãƒã‚°ã‚„InnoDBãƒã‚°ã¯ ç‰©ç†ãƒã‚®ãƒ³ã‚°ã§ã‚ã‚‹ã€‚ ãƒã‚¤ãƒŠãƒªãƒã‚°ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ä½œæˆã•ã‚Œãªã„ã®ã§ã€my.c
harumaki_net 2012/06/14
MySQL

ãŠå½¹ç«‹ã¡

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
MySQLã®å°†æ¥ãŒå¿ƒé…ãªã®ã§ã€ï¼ˆãŸã¶ã‚“ï¼‰æ—¥æœ¬ä¸€ã®MySQLã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã€Œæ—¥æœ¬ç”·å…ã€ã«èžã„ã¦ã¿ãŸ
ã‚ªãƒ©ã‚¯ãƒ«ã¯ã€ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã‚’è²·åŽå¾Œã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦æä¾›ã•ã‚Œã¦ã„ãŸOpenSolarisã‚’äº‹å®Ÿä¸Šçµ‚äº†ã—ã€ã¾ãŸã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦Androidã‚’æä¾›ã—ã¦ã„ã‚‹ã‚°ãƒ¼ã‚°ãƒ«ã«å¯¾ã—ã¦ã€ŒJavaã¨ç«¶åˆã™ã‚‹ã€ã¨ã„ã†ç†ç”±ã§è¨´è¨Ÿã‚’èµ·ã“ã™ãªã©ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«å¯¾ã—ã¦éžå”åŠ›çš„ã¨è¦‹ãˆã‚‹è¡Œå‹•ãŒç¶šã„ã¦ã„ã¾ã™ã€‚ ã“ã†ãªã‚‹ã¨ã€åŒç¤¾ãŒä¿æœ‰ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®MySQLã®ä»Šå¾Œã¯å¤§ä¸ˆå¤«ãªã®ã‹æ‡¸å¿µã•ã‚Œã¾ã™ã€‚ã™ã§ã«MySQLã®ã‚³ã‚¢ãªé–‹ç™ºè€…ã®ä½•äººã‹ã¯åŒç¤¾ã‚’åŽ»ã‚Šã€MariaDBã‚„Drizzleã¨ã„ã£ãŸã»ã‹ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å–ã‚Šçµ„ã‚“ã§ã‚‚ã„ã¾ã™ã€‚ä»Šå¾Œã€MySQLã®é–‹ç™ºãŒå¼±ä½“åŒ–ã—ãŸã‚Šã€æ–¹å‘è»¢æ›ã—ã¦Solarisã®ã‚ˆã†ã«ã‚¯ãƒãƒ¼ã‚ºãƒ‰ã«ãªã£ãŸã‚Šã™ã‚‹ã“ã¨ã¯ãªã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã“ã§MySQLã®ã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã¨ã—ã¦ãƒ–ãƒã‚°ã€Œæ¼¢ï¼ˆã‚ªãƒˆã‚³ï¼‰ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“ã€ã‚’åŸ·ç†ã™ã‚‹ãƒ–ãƒã‚¬ãƒ¼ã€Œ@nippondanjiã€ã§ã‚ã‚Šã€ã‹ã¤æ—¥æœ¬ã‚ª
harumaki_net 2012/05/31
MySQL

ã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
MySQLãŒãŠã‹ã—ã„ï¼ã‚ãªãŸãªã‚‰ã©ã†ã—ã¾ã™ã‹ï¼Ÿ â€“ MySQL Casual Advent Calendar 2011 - As a Futurist...
ã—ã‚ã£ã™ï¼DBA å…¼ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å…¼ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚„ã£ã¦ã‚‹ riywo ã§ã™ã€‚ä½•ã®ãƒã‚¿ã‚’æ›¸ã“ã†ã‹ãªãã¨è€ƒãˆãŸã®ã§ã™ãŒã€æ£ç›´ãƒã‚¿ã‚’ä»•è¾¼ã‚€æ™‚é–“ã‚‚ãªã‹ã£ãŸã®ã§åƒ•ãŒã„ã¤ã‚‚ã‚„ã£ã¦ã‚‹ã“ã¨ã‚’ã•ã‚‰ã£ã¨ç´¹ä»‹ã™ã‚‹ã¨ã„ã†ã“ã¨ã§å‹˜å¼ã—ã¦ä¸‹ã•ã„ï¼žï¼œ MySQL ãŒãŠã‹ã—ã„ï¼ 03:14 hidek: ãªã‚“ã‹ã‚¨ãƒ©ãƒ¼å‡ºã¾ãã£ã¦ã‚‹ã‚“ã ã‘ã©ï¼ 03:14 zigorou: MySQL ã¨é€šä¿¡ã—ã¦ã‚‹ã¨ã“ã£ã½ã„ 03:15 riywo: è¦‹ã¾ã™ ã“ã‚“ãªã‚„ã‚Šã¨ã‚Šã¯çš†ã•ã‚“æ—¥å¸¸èŒ¶é£¯äº‹ã§ã™ã‚ˆãï¼Ÿãï¼Ÿãï¼Ÿã“ã‚“ãªæ™‚ã«ã€DB ã«è²¬ä»»ã‚’æŒã¤ã‚‚ã®ã¨ã—ã¦çœŸã£å…ˆã«å¯¾å¿œã™ã‚‹ã®ãŒåƒ•ã‚‰ã®ä»•äº‹ã§ã™ã€‚ã§ã‚‚ã€ã˜ã‚ƒã‚å…·ä½“çš„ã«ã“ã®ã‚ã¨ä½•ã‚’ã—ã¾ã—ã‚‡ã†ï¼Ÿæ—¢ã«ã‚µãƒ¼ãƒ“ã‚¹ã¯ã‚¨ãƒ©ãƒ¼ã ã‚‰ã‘ã§ä¸€åˆ»ã‚’äº‰ã†çŠ¶æ…‹ã§ã™ã€‚ (å¯¾å¿œé–‹å§‹) ã¾ãšã¯ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ ä»Šå›žã®æ§˜ãªå ´åˆã¯ã‚¢ãƒ—ãƒªã®ã‚¨ãƒ©ãƒ¼ãƒã‚°ã«ã©ã°ã£ã¨ MySQL ã«é–¢ã™ã‚‹ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ã¾ãšã¯ãã‚Œã‚’è¦‹ã‚‹ã“ã¨ãŒå§‹ã¾
harumaki_net 2011/12/02
MySQL

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
MySQLç®¡ç†è€…æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼
å··ã§ã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã®æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼ãŒæµè¡Œã£ã¦ã‚‹ã®ã§ã€MySQLã‚‚å‚æˆ¦ã€‚ãŸã ã—ç®¡ç†è€…å‘ã‘ã€‚ ã¾ãšã¯ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚µã‚¤ãƒˆ http://dev.mysql.com/downloads/ ãƒã‚¤ãƒŠãƒªã«ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ï¼ˆWindows=MSIã€Mac=DMGã€Linux=RPMã¨ã‹ï¼‰ã¨ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ï¼ˆ*NIX=tar.gz/Windows=zipï¼‰ãŒã‚ã‚‹ã‘ã©ã€åˆå¿ƒè€…ã¯é»™ã£ã¦ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ãƒãƒ§ã‚¤ã‚¹ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ã‚¦ã‚£ã‚¶ãƒ¼ãƒ‰ã«å¾“ã†ã ã‘ã€‚è‹±èªžã ã‘ã©ãã“ã¯ã‚¬ãƒžãƒ³ï¼ ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒªãƒã‚¸ãƒˆãƒªãŒã‚ã‚‹OSã‚’ä½¿ã£ã¦ã‚‹ãªã‚‰ã€ãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã®ã‚‚ã‚ã‚Šã ã€‚ä¾‹ãˆã°ã€ shell> sudo yum install mysqlã¨ã‹ shell$gt; sudo apt-get install mysqlã¨ã‹ã€‚ã“ã‚Œã¯æ¥½ãƒãƒ³ã ã‘ã©MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒã¡ã‚‡ã£ã¨å¤ããªã‚‹ã®ã§æ³¨æ„ã€‚ ã‚‚ã¡ã‚ã‚“
harumaki_net 2011/09/28
MySQL

è¨å®š

ã¾ã¨ã‚

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
1