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

ablabo id:ablabo

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

${{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}}

Chefã§ã®MySQLãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®æ‰±ã„ - matetsuã ã‚‚ã‚“ã§
opscodeã®ãƒªãƒã‚¸ãƒˆãƒªã«ã‚ã‚‹MySQLã®cookbookã§ã¯ã€rootãƒ¦ãƒ¼ã‚¶ã‚„ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ã®ãƒ¦ãƒ¼ã‚¶ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ãƒ©ãƒ³ãƒ€ãƒ ã«ç”Ÿæˆã—ã¦è¨å®šã—ã¦ã„ã‚‹ã€‚ opscode ã® recipe ã®ç‰¹å¾´ ã“ã®ãƒ©ãƒ³ãƒ€ãƒ ã¨ã„ã†ç‚¹ã‚’ã‚«ãƒãƒ¼ã™ã‚‹ã¹ãã€ã†ã¾ã„ä»•çµ„ã¿ãŒçµ„ã¿è¾¼ã¾ã‚Œã¦ã„ã‚‹ã€‚ ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¨å®šã™ã‚‹ã¨ã“ã‚ã¯ node.set_unless['mysql']['server_root_password'] = secure_password ã¨ã„ã£ãŸå½¢ã§ã€attributeã«è¨å®šã•ã‚Œã¦ã„ãªã„å ´åˆã¯ãƒ©ãƒ³ãƒ€ãƒ ã«ç”Ÿæˆã™ã‚‹ã¨ã„ã†äº‹ã‚’ã—ã¦ã€2åº¦ç›®ä»¥é™ã‚‚åŒã˜ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¨ãªã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã€‚ 2å›žç›®ä»¥é™ã‚‚åŒã˜ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ä¿è¨¼ã™ã‚‹ãŸã‚ã«ã€ã‚‚ã†ã²ã¨ã¤ã®æŠ€ãŒ unless Chef::Config[:solo] ruby_block "save node data" do block do node.save end
ablabo 2013/07/20
chef

mysql
ãƒªãƒ³ã‚¯
MySQLå‘ã‘ã«æ›¸ã‹ã‚ŒãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’Oracle Databaseã«æŽ¥ç¶šã•ã›ã‚‹ - SH2ã®æ—¥è¨˜
å…ˆæ—¥Oracle Database 12c Release 1ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ã¦ã€æ–°æ©Ÿèƒ½ã‚¬ã‚¤ãƒ‰ã‚’çœºã‚ã¦ã„ãŸã¨ã“ã‚æ°—ã«ãªã‚‹æ–°æ©Ÿèƒ½ã‚’è¦‹ã¤ã‘ã¾ã—ãŸã€‚ MySQL Client Library Driver for Oracle Oracle Database 12c Release 1ã«ã¯liboramysql12ã¨ã„ã†å…±æœ‰ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒåŒæ¢±ã•ã‚Œã¦ã„ã¦ã€ã“ã‚Œã‚’libmysqlclientã¨å·®ã—æ›¿ãˆã‚‹ã¨MySQLå‘ã‘ã«æ›¸ã‹ã‚ŒãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒãã®ã¾ã¾Oracle Databaseã«å¯¾ã—ã¦å‹•ä½œã™ã‚‹ã®ã ãã†ã§ã™ã€‚ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‹ã‚‰å›³ã‚’å¼•ç”¨ã—ã¾ã™ã€‚ è©¦ã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚MySQLã«ãƒ†ã‚¹ãƒˆç”¨ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚Šã¾ã™ã€‚ mysql> CREATE TABLE myora ( -> id INT PRIMARY KEY, -> data VARCHAR(100) -> ) ENGINE = InnoDB DEFAU
ablabo 2013/07/15
oracle

mysql
ãƒªãƒ³ã‚¯
innotop 1.9.1 released
All of Perconaâ€™s open-source software products, in one place, to download as much or as little as you need.
ablabo 2013/07/15
mysql

performance
ãƒªãƒ³ã‚¯
ãŠãã‚‰ãã¯ãã‚Œã•ãˆã‚‚å¹³å‡¡ãªæ—¥ã€…: Test::mysqldã®copy_data_fromã§ãƒ†ã‚¹ãƒˆãŒæ›´ã«æ—ã‚‹è©±
å°‘ã—å‰ã§ã™ãŒTest::mysqld 0.17ã‹ã‚‰ã¯ copy_data_fromã¨ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒåŠ ã‚ã£ã¦ã„ã¾ã™ã€‚ ã“ã‚Œã¯ã€Test::mysqldèµ·å‹•æ™‚ã«ã‚³ãƒ”ãƒ¼å…ƒã®dataãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’æŒ‡å®šã§ãã‚‹ã‚‚ã®ã§ MySQLã®èµ·å‹•æ™‚é–“ã‚’ç¯€ç´„ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ãƒ†ã‚¹ãƒˆé–‹å§‹æ™‚ã«DBã«å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ å…¥ã‚Œã¦ãŠããŸã„å ´åˆã«ç‰¹ã«æœ‰åŠ¹ã§ã™ã€‚ ç‰¹ã«ã‚²ãƒ¼ãƒ ãªã©ã®å ´åˆã¯ã€å¤§é‡ã®ãƒžã‚¹ã‚¿ãƒ‡ãƒ¼ã‚¿ã‚‚ã‚³ãƒ¼ãƒ‰ã®ä¸€éƒ¨ã¨è¨€ãˆã‚‹ã®ã§ã€ã¡ã‚ƒã‚“ã¨ å…¨éƒ¨æµã—è¾¼ã‚“ã§ã‹ã‚‰ãƒ†ã‚¹ãƒˆã‚’å®Ÿæ–½ã—ãŸã„ã¨ã„ã†è¦ä»¶ãŒã‚ã‚‹ã®ã§é‡å®ã—ã¾ã™ã€‚ ã•ã¦ã€ãã®dataãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ã©ã†ã‚„ã£ã¦ä½œã‚Œã°ã‚ˆã„ã‹ã¨ã„ã†è©±ã«ãªã‚‹ã®ã§ã™ãŒã€ ãã‚Œã‚‚ã€Test::mysqldã«äº‹å‰ã«ä½œã‚‰ã›ã¦ã©ã“ã‹ã«é…ç½®ã—ã¦ãŠã‘ã°è‰¯ã„ã§ã—ã‚‡ã†ã€‚ æ‰‹é †ã¨ã—ã¦ã¯ä¾‹ãˆã°ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ â€˜tmp/test_mysqld_dataâ€™ ã‚’datadirã«ã—ã¦Test::mysqldã‚’èµ·å‹• DDLã¨ãƒžã‚¹ã‚¿ãƒ‡
ablabo 2013/06/30
perl

db

mysql

testing
ãƒªãƒ³ã‚¯
ã‚¢ã‚¸ã‚¢ãƒ»ãƒ‘ã‚·ãƒ•ã‚£ãƒƒã‚¯ã‚’æ¨ªæ–ã™ã‚‹MySQLã®ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆï¼ â€•ã‚ªãƒ©ã‚¯ãƒ«ã€€æ¢¶å±±éš†è¼”ã•ã‚“
EnterpriseZineï¼ˆã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¸ãƒ³ï¼‰ç·¨é›†éƒ¨ã§ã¯ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ æ‹…å½“ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ‹…å½“ã®æ–¹ã€…å‘ã‘ã«ã€EnterpriseZine Dayã€Security Online Dayã€DataTechã¨ã„ã†ã€3ã¤ã®ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¦ãŠã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œç·¨é›†éƒ¨ç‹¬è‡ªã®åˆ‡ã‚Šå£ã§ã€æ¥ç•Œãƒˆãƒ¬ãƒ³ãƒ‰ã‚„æœ€æ–°äº‹ä¾‹ã‚’ç¶²ç¾…ã€‚æœ€æ–°ã®å‹•å‘ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹å ´ã¨ã—ã¦ã€å¥½è©•ã‚’å¾—ã¦ã„ã¾ã™ã€‚
ablabo 2013/06/07
oracle

mysql

engineer
ãƒªãƒ³ã‚¯
ã€Œå†™çµŒã€ã‹ã‚‰å§‹ã‚ã‚‹Chefã‚¯ãƒƒã‚¯ãƒ–ãƒƒã‚¯ã®ä½œæˆ
æ–Žè—¤ã§ã™ã€‚ã“ã‚“ã«ã¡ã¯ã€‚ Chef ã®è©±é¡ŒãŒã‚¢ãƒ„ããªã£ã¦ã„ã‚‹ä»Šæ—¥ã“ã®é ƒã€ã¿ãªã•ã¾ã„ã‹ãŒãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ï¼ŸChefã®è§£èª¬æœ¬ã‚‚å‡ºã¤ã¤ã‚ã‚‹ä»Šæ—¥ã“ã®é ƒã§ã¯ã‚ã‚Šã¾ã™ãŒã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãã®ã‚‚ã®ã«æ…£ã‚Œãªã„ã†ã¡ã¯ãã‚Œã•ãˆèªã‚€ã®ã‚‚ã¡ã‚‡ã£ã¨å¤§å¤‰ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ãã“ã§ä»Šå›žã¯ã€ Chef ã®ãƒ¬ã‚·ãƒ”ï¼‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ç”¨ã„ã¦ã€MySQLã®è¨å®šã®è‡ªå‹•åŒ–ã‚’è©¦ã—ã¾ã™ã€‚ã„ã‚ã‚†ã‚‹ã€Œå†™çµŒã€ã‹ã‚‰å§‹ã‚ã¦ã¿ã¦ã€å°‘ã—ãšã¤ã€Œæ‰‹å‹•ã€ã‹ã‚‰ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’é€šã˜ãŸã€Œè‡ªå‹•åŒ–ã€ã«ãƒãƒ£ãƒ¬ãƒ³ã‚¸ã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ â€»Chef 11.04.0, knife-solo 0.2.0, Ruby 1.9.3p327, CentOS 6.3 ã§æ¤œè¨¼ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã®ãŠé¡Œ MySQLã‚µãƒ¼ãƒã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ã¾ã™ã€‚ITã‚¤ãƒ³ãƒ•ãƒ©ã‚’æ§‹ç¯‰ãƒ»é‹ç”¨ã—ã¦ã„ã‚‹æ–¹ãªã‚‰ã”å˜çŸ¥ã‹ã¨æ€ã„ã¾ã™ãŒã€MySQLã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã ã‘ã§ãªãmy.cnfã®è¨å®šã¾ã§ãŒä½œæ¥ã§ã™ã€‚ãã®éš›ã«innodb_buffer_
ablabo 2013/05/27
mysql

chef
ãƒªãƒ³ã‚¯
Percona Playback 0.6 for MySQL now available
Percona is glad to announce the release of Percona Playback 0.6 for MySQL on April 9, 2013. Downloads are available from our download site and Percona Software Repositories. Percona Playback for MySQL is a tool for replaying the load of one database server to another. Currently it can read queries from MySQL query-log and MySQL tcpdump files and run them on other MySQL server. With Percona Playbac
ablabo 2013/04/20
mysqlã«ãŠã‘ã‚‹oracleã®database replayçš„ãªã‚‚ã®

db

mysql
ãƒªãƒ³ã‚¯
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³5ã®å¾©ç¿’ MySQL 5.5 ãƒãƒ¼ãƒˆç·¨ï¼†å‹‰å¼·ä¼šã®ãŠçŸ¥ã‚‰ã› - SH2ã®æ—¥è¨˜
ã‚¼ãƒã‚¹ã‚¿ãƒ¼ãƒˆã®@zakiã•ã‚“ã‚’ä¸å¿ƒã«ä¼ç”»ã€é‹å–¶ã•ã‚Œã¦ã„ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆãŒã‚ã‚Šã¾ã™ã€‚æŒ‡å®šã•ã‚ŒãŸç’°å¢ƒã‚’ç”¨ã„ã¦OSã‚„ã‚µãƒ¼ãƒå‘¨ã‚Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã„ã€æ€§èƒ½ã‚’ç«¶ã†ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚2013å¹´1æœˆã«è¡Œã‚ã‚ŒãŸç¬¬5å›žã§ã¯MySQLãŒãƒ†ãƒ¼ãƒžã ã£ãŸã¨ã„ã†ã“ã¨ã§ã€æœ¬æ—¥ã¯ã“ã‚Œã®å¾©ç¿’ã‚’ã—ã¦ã„ã“ã†ã¨æ€ã„ã¾ã™ã€‚ ã€ãƒ¬ãƒãƒ¼ãƒˆã€‘ã„ã‚ã„ã‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ç«¶ã†ãƒãƒˆãƒ«ã‚¤ãƒ™ãƒ³ãƒˆï¼ã€ŒTuningathonã€ç¬¬5å¼¾ï¼ #tuningathon : ã‚¼ãƒã‚¹ã‚¿ãƒ¼ãƒˆã®åºƒå ±ãƒ–ãƒã‚° 2013å¹´æœ€åˆã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã¯MySQLï¼â€•â€•ç¬¬5å¼¾ï¼ ã„ã‚ã„ã‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ç«¶ã†ãƒãƒˆãƒ«ã‚¤ãƒ™ãƒ³ãƒˆã€Œãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã€ãƒ¬ãƒãƒ¼ãƒˆï¼šãƒ¬ãƒãƒ¼ãƒˆï½œgihyo.jp â€¦ æŠ€è¡“è©•è«–ç¤¾ Tuningathon#5 - Togetter ã—ã°ã‚‰ãçœŸé¢ç›®ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ãŸã®ã§ã™ãŒæ€ã„ã®ã»ã‹é›£ã—ã‹ã£ãŸã®ã§ã€ä»Šå›žã¯ã¡ã‚‡ã£ã¨ã‚ºãƒ«ã‚’ã—ã¦å„ª
ablabo 2013/03/06
db

mysql
ãƒªãƒ³ã‚¯
Percona Toolkit pt-online-schema-change ã§ã‚µãƒ¼ãƒ“ã‚¹ç„¡åœæ¢ã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ | å¤–é“çˆ¶ã®åŒ
ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚«ãƒ©ãƒ ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è¿½åŠ ã™ã‚‹ã¨ã„ã£ãŸã€ã„ã‚ã‚†ã‚‹ã‚¹ã‚ãƒ¼ãƒžã®å¤‰æ›´ã‚’è¡Œã†ã¨ãã¯ã€é€šå¸¸ã€ã‚µãƒ¼ãƒ“ã‚¹ã‚’ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã«å…¥ã‚Œã¦ã‹ã‚‰ä½œæ¥ã‚’ã—ãªãã¦ã¯ã„ã‘ã¾ã›ã‚“ã€‚ç†ç”±ã¯ã€ALTER TABLEå®Ÿè¡Œä¸ã¯å…±æœ‰ãƒãƒƒã‚¯ãŒã‹ã‹ã£ã¦ã—ã¾ã†ãŸã‚ã€æ›´æ–°ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã¦ã‚‚å³åº§ã«å®Œäº†ã—ãªããªã‚‹ã‹ã‚‰ã§ã™ã€‚ãã†ã™ã‚‹ã¨ã€ã‚¢ãƒ—ãƒªã‹ã‚‰ã¿ã‚Œã°ãŠãã‚‰ãæ›´æ–°ã‚¯ã‚¨ãƒªã‚’ç™ºè¡Œã™ã‚‹ãƒšãƒ¼ã‚¸ã§ã¯HTTPã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆã«ãªã‚Šã¾ã™ã—ã€å‚ç…§ã ã‘ã®ãƒšãƒ¼ã‚¸ã§ã‚‚ã‹ãªã‚Šé…ããªã‚‹ã“ã¨ã§ã—ã‚‡ã†ã€‚ ã‚µãƒ¼ãƒ“ã‚¹ã®æ”¹è‰¯ã‚’ã™ã‚‹ã¨å¿…ãšã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ãŒå¿…è¦ã«ãªã‚Šã¾ã™ãŒã€ã—ã‹ã—ã‚µãƒ¼ãƒ“ã‚¹ã¯å¯èƒ½ãªé™ã‚Š24æ™‚é–“365æ—¥æä¾›ã—ãŸã„ã‚‚ã®ã€‚Percona Toolkitã® pt-online-schema-change ã¯ãã‚“ãªæ‚©ã¿ã‚’æ‰•æ‹ã—ã€ã‚µãƒ¼ãƒ“ã‚¹ã‚’åœæ¢ã™ã‚‹ã“ã¨ç„¡ãã‚¹ã‚ãƒ¼ãƒžã®å¤‰æ›´ã‚’å¯èƒ½ã«ã—ã¦ãã‚Œã¾ã™ã€‚ æ¦‚è¦ã¨ä»•çµ„ã¿ Percona Toolkitã¯å…¨ã¦Perlã‚¹ã‚¯ãƒªãƒ—ãƒˆãªã®ã§ã€/usr/bi
ablabo 2012/10/07
mysql

db
ãƒªãƒ³ã‚¯
é–‹ç™ºã‚¹ãƒ”ãƒ¼ãƒ‰ã‚¢ã‚¯ã‚»ãƒ«å…¨é–‹ã¶ã£ã¡ãŽã‚Šï¼æ—¥æœ¬ã‚ˆã€ã“ã‚ŒãŒMySQL 5.6ã ãƒƒï¼ï¼
ç±³å›½ã§è¡Œã‚ã‚Œã¦ã„ã‚‹MySQL Connectã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã§ã€ã¤ã„ã«MySQL 5.6 RCï¼ˆãƒªãƒªãƒ¼ã‚¹å€™è£œç‰ˆï¼‰ãŒç™ºè¡¨ã•ã‚ŒãŸã€‚ãƒªãƒªãƒ¼ã‚¹å€™è£œç‰ˆã¨ã„ã†ã“ã¨ã¯ã€ã“ã‚ŒãŒæ¬¡ã®æ£å¼ç‰ˆã«ãªã‚‹ã¨ã„ã†ã“ã¨ã ã€‚MySQL 5.5ã¯5.1ã‹ã‚‰å‡„ã¾ã˜ã„é€²åŒ–ã‚’é‚ã’ãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã£ãŸã€‚ã ãŒã€MySQL 5.6ã¯ã•ã‚‰ã«ãã‚Œã‚’ä¸Šå›žã‚‹é€²åŒ–ã‚’é‚ã’ã¦ã„ã‚‹ï¼æ£ç›´ã“ã“ã¾ã§ã®é€²åŒ–ã‚’èª°ãŒäºˆæƒ³ã—ãŸã ã‚ã†ã‹ã€ã„ã‚„èª°ã‚‚å‡ºæ¥ãªã‹ã£ãŸã§ã‚ã‚ã†ã€‚ã“ã‚Œã¾ã§ã€Î±ç‰ˆãŒå‡ºãŸã¨ãã‹ã‚‰ä½•åº¦ã‹æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ããŸãŒã€ä»Šå›žæ”¹ã‚ã¦MySQL 5.6ã®æ–°æ©Ÿèƒ½ã‚’æŒ¯ã‚Šè¿”ã£ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ã™ã¹ã¦ã¾ã¨ã‚ã‚‹ã¨ã‚‚ã®å‡„ã„å†…å®¹ã ã€‚èˆˆå¥®ã—ã¦å¤œã‚‚çœ ã‚Œãªããªã‚‹ã“ã¨è«‹ã‘åˆã„ã ã€‚MySQLã®é€²åŒ–ãŒæ¢ã¾ã‚‹ã®ã§ã¯ï¼Ÿãªã©ã¨ã„ã†å¿ƒé…ã¯å¹ãé£›ã³ã€ã‚‚ã¯ã‚„ã‚‚ã†ã¡ã‚‡ã£ã¨å°å‡ºã—ã«ã—ãªãã¦è‰¯ã‹ã£ãŸã®ã‹ï¼Ÿã¨å¿ƒé…ã—ã¦ã—ã¾ã†ãƒ¬ãƒ™ãƒ«ã§ã‚ã‚‹ã€‚ ãã‚Œã§ã¯MySQL 5.6ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ã„ã“ã†ã€‚ InnoDB
ablabo 2012/10/05
mysql

db
ãƒªãƒ³ã‚¯
MySQL Migration Wizardç™»å ´ - rkajiyamaã®æ—¥è¨˜
ã“ã‚Œã€æœ¬å½“ã«MySQL Workbenchã®ãƒžã‚¤ãƒŠãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®ä¸€éƒ¨ã§ã„ã„ã®ï¼Ÿ ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚’å«ã‚ã¦é–‹ç™ºçµ‚äº†ã¨ãªã£ã¦ã„ãŸMySQL Migration Toolkitã®å¾Œç¶™ã«ã‚ãŸã‚‹ã€æ–°ã—ã„ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ„ãƒ¼ãƒ«ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚åç§°ã¯Migration Wizardã§ã€ç‹¬ç«‹ã—ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã¯ç„¡ãMySQL Workbenchã®ä¸€éƒ¨æ©Ÿèƒ½ã¨ãªã£ã¦ã„ã¾ã™ã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯ã€Œã‚‚ã¡ã‚ã‚“ã€GPLã§ã™ã€‚ã“ã‚Œã§ä»¥å‰ã®MySQL GUI Toolsã®å…¨ã¦ã®æ©Ÿèƒ½ãŒæˆ»ã£ã¦ããŸã“ã¨ã«ãªã‚Šã¾ã™ã€‚ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯ã“ã¡ã‚‰ã‹ã‚‰ã€‚ Migration Wizardã®å…·ä½“çš„ãªãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³å…ƒã®ç¬¬ä¸€å¼¾ã¨ã—ã¦ã¯ã€Microsoft SQL ServerãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã¾ã™ã€‚ã¾ãŸODBCã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ãŸã‚ã€ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚‚å¯èƒ½ã§ã™ã€‚å‹•ä½œç’°å¢ƒã¯Windows, Mac OS X ãŠã‚ˆã³ Linu
ablabo 2012/08/26
mysql

tips
ãƒªãƒ³ã‚¯
ä¾¿åˆ©ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆé›† MySQL Utilities - rkajiyamaâ€™s diary
å®Ÿã¯1.0.0ãŒ2010å¹´12æœˆã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ãŸã®ã«å…¨ãçŸ¥ååº¦ã®ç„¡ã„"MySQL Utilities"ã€‚å®Ÿã¯ä¾¿åˆ©ãªæ©Ÿèƒ½ãŒè¤‡æ•°ç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ‰‹ä½œã‚Šã—ãªãã¦ã‚‚æ¸ˆã‚€å¯èƒ½æ€§å¤§ã§ã™ã€‚ã¾ãŸãƒªãƒªãƒ¼ã‚¹ã«å‘ã‘ã¦æ–°ãŸãªãƒžã‚¤ãƒ«ã‚¹ãƒˆãƒ¼ãƒ³ãƒªãƒªãƒ¼ã‚¹ãŒå‡ºã¦ããŸMySQL 5.6ã§ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¿½åŠ æ©Ÿèƒ½ã¨çµ„ã¿åˆã‚ã›ã‚‹ä¾¿åˆ©æ©Ÿèƒ½ã‚‚ã‚ã‚Šã¾ã™ã€‚ MySQL Utilitiesã¯Pythonã§æ›¸ã‹ã‚ŒãŸã‚¹ã‚¯ãƒªãƒ—ãƒˆé›†ã§ã€MySQL Workbenchã«åŒæ¢±ã•ã‚Œã¦é…å¸ƒã•ã‚Œã¦ã„ã¾ã™ã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯ã€Œã‚‚ã¡ã‚ã‚“ã€GPLã§ã™ã€‚2012å¹´7æœˆä¸Šæ—¬æ™‚ç‚¹ã§ã®æœ€æ–°ç‰ˆã¯1.0.5ã§ã™ã€‚ã¾ãŸå®Ÿè¡Œå¯èƒ½ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã®ä»–ã«ã€ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¨ã—ã¦ç´°ã‹ãªæ©Ÿèƒ½ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ãŸã‚ã€ç‹¬è‡ªã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆä½œæˆã«ã‚‚å½¹ç«‹ã¡ã¾ã™ã€‚ èµ·å‹•ã«ã¯MySQL Workbenchã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã®ã€Pluginsã€‘ã‹ã‚‰ã€Start Shell for MySQL Utilit
ablabo 2012/08/01
mysql

db
ãƒªãƒ³ã‚¯
CoolUtils File Converters
Our File Converters support over 1,400+ formats Let's find the file converter for your case. Find your converter We've been developing file converters since 2003 Our powerful engines convert extra large and complicated files We focus on batch processing with smart auto-settings Windows 2000/2003/Vista/7/8/10/11. GUI and command line. Get them all in 1 bundle! Coolutils Gold Bundle 30 apps for $99
ablabo 2012/07/15
mysql
ãƒªãƒ³ã‚¯
MySQLã®ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚’å¤‰æ›´ã™ã‚‹ã€‚
MySQLã®CLIï¼ˆã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ï¼‰ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã¨ãŠãªã˜ã¿ã® mysql> ã¨ã„ã†ãƒ—ãƒãƒ³ãƒ—ãƒˆãŒã‚ã‚‹ãŒã€å®Ÿã¯ã“ã‚Œã¯å¤‰æ›´ãŒå¯èƒ½ã§ã‚ã‚‹ã€‚MySQL CLIã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹æœ€ä¸ãªã‚‰ã€promptã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚Œã°è‰¯ã„ã€‚ä¾‹ãˆã°æ¬¡ã®ã‚ˆã†ã«ã€‚ mysql> prompt \U [\d] >\_ PROMPT set to '\U [\d] >\_' mikiya@localhost [test] > \Uã‚„\dã¯ãã‚Œãžã‚Œæ„å‘³ãŒæ±ºã¾ã£ã¦ã„ã¦ã€ãã‚Œã‚‰ã‚’çµ„ã¿åˆã‚ã›ã‚‹ã“ã¨ã§ä»»æ„ã®æƒ…å ±ã‚’ãƒ—ãƒãƒ³ãƒ—ãƒˆã«è¡¨ç¤ºã§ãã‚‹ã‚ã‘ã§ã‚ã‚‹ã€‚è¦‹æ˜“ã„ã‚ˆã†ã« > ã‚„ã‚¹ãƒšãƒ¼ã‚¹ã€æ‹¬å¼§ãªã©ã‚’çµ„ã¿åˆã‚ã›ã‚‹ã¨ã„ã„ã ã‚ã†ã€‚ä¾‹ãˆã°ä½•ã‹ã®ä½œæ¥ã‚’ã™ã‚‹ã¨ãã«ã¯ mysql> prompt ä½œæ¥1 [\D]>\_ PROMPT set to 'ä½œæ¥1 [\D]>\_' ä½œæ¥1 [Tue Mar 17 07:39:28 2009]> ãªã©ã¨ã™ã‚‹
ablabo 2012/07/07
mysql

tips
ãƒªãƒ³ã‚¯
Maatkitã®ç´¹ä»‹
2. ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ ï® è‡ªå·±ç´¹ä»‹ ï® Maatkit ã¨ã¯ï¼Ÿ ï® Maatkitã®ç‰¹å¾´ ï® Maatkitã®ãƒ„ãƒ¼ãƒ«ç¾¤ã‚’ã„ãã¤ã‹ç´¹ä»‹ ï® ã¾ã¨ã‚ 3. è‡ªå·±ç´¹ä»‹ ã¯ã¦ãªã§ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ -è‡ªä½œã‚µãƒ¼ãƒ/ãƒ™ãƒ³ãƒ€ã‚µãƒ¼ãƒ -ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ -ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚·ã‚¹ãƒ†ãƒ -ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã¯id:maoe/id:halfrack ãƒ–ãƒã‚° http://d.hatena.ne.jp/marqs twitter http://twitter.com/marqs 4. è¶£å‘³ ï® è‡ªè»¢è»Š ï® MTB -> Road -> MTB? ï® ã‚·ãƒžãƒŽãƒã‚¤ã‚«ãƒ¼ã‚ºãƒ•ã‚§ã‚¹ãƒ†ã‚£ãƒãƒ«æ¯Žå¹´å‡ºã¦ã¾ã™ ï® éŸ³æ¥½ ï® I am robot and proud ï® æ˜ ç”» ï® ãƒ•ã‚¡ãƒ³ãƒœãƒ¼ã‚¤ã‚º ï® ã¯ãŸã‚‰ããã‚‹ã¾ ï® åœ§é›ªè»ŠãŒç‰¹ã«å¥½ã
ablabo 2012/06/23
db

mysql

maatkit

hatena
ãƒªãƒ³ã‚¯
XAMPP for Windows
å«ã‚€: Apache 2.4.58, MariaDB 10.4.32, PHP 8.0.30, phpMyAdmin 5.2.1, OpenSSL 3.1.3, XAMPP Control Panel 3.2.4, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 8.5.96 (with mod_proxy_ajp as connector), Strawberry Perl 5.32.1.1 Porta ble å«ã‚€: Apache 2.4.58, MariaDB 10.4.32, PHP 8.1.25, phpMyAdmin 5.2.1, OpenSSL 3.1.3, XAMPP Control Panel 3.2.4, Webalizer 2.23-04
ablabo 2012/05/03
linux

mysql

apache
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯NoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸã€‚NewSQLã®ç™»å ´ã¨NoSQLã®çµ‚ã‚ã‚Šã€ã¨ã„ã†äºˆæƒ³
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯NoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸã€‚NewSQLã®ç™»å ´ã¨NoSQLã®çµ‚ã‚ã‚Šã€ã¨ã„ã†äºˆæƒ³ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨PostgreSQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã©ã®ã‚ˆã†ãªæ–°æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã‚‹ã®ã‹ã€æ˜¨æ—¥ã€ä¸€æ˜¨æ—¥ã®2æœ¬ã®è¨˜äº‹ã§ç´¹ä»‹ã—ã¾ã—ãŸã€‚ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯Memcached APIã‚’å‚™ãˆã‚‹ï¼ MySQL Conference & Expo 2011åŸºèª¿è¬›æ¼” PostgreSQLã®ç¾çŠ¶ã¨æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³9.1ã®æ–°æ©Ÿèƒ½ã€‚MySQL Conference & Expo 2011 ã“ã®2ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«å…±é€šã—ã¦ã„ã‚‹ã®ãŒã€NoSQLã®æ©Ÿèƒ½ã‚’å–ã‚Šè¾¼ã‚“ã§ã„ã‚‹ã“ã¨ã§ã™ã€‚NoSQLã«å¯¾ã™ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã‚‹åæ’ƒãŒå§‹ã¾ã£ã¦ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒNoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹MySQL 5.6ã«æè¼‰äºˆå®šã®æ–°æ©Ÿèƒ½ã®1
ablabo 2011/04/20
db

mysql

nosql
ãƒªãƒ³ã‚¯
å–å¾—ãƒ‡ãƒ¼ã‚¿ã®è¡Œæ•°ã‚’åˆ¶é™(LIMITå¥) - ãƒ‡ãƒ¼ã‚¿ã®å–å¾— - MySQLã®ä½¿ã„æ–¹
LIMIT å¥ã‚’è¨å®šã™ã‚‹ã¨ SELECT æ–‡ã‚’å®Ÿè¡Œã—ãŸæ™‚ã«å–å¾—ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®è¡Œæ•°ã®ä¸Šé™ã‚’è¨å®šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã“ã“ã§ã¯ MySQL ã§ LIMIT å¥ã‚’ä½¿ã£ã¦å–å¾—ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®è¡Œæ•°ã®ä¸Šé™ã‚’è¨å®šã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚
ablabo 2011/03/10
mysql

db

tips
ãƒªãƒ³ã‚¯
NoSQLã¨ã—ã¦MySQLã‚’ä½¿ã†DeNAãŒã€memcachedã‚ˆã‚Šã‚‚é«˜é€Ÿãª75ä¸‡ã‚¯ã‚¨ãƒªï¼ç§’ã‚’å®Ÿç¾
ãƒ¢ãƒã‚²ãƒ¼ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã¯ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«NoSQLã‚’ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ãªãœã‹ï¼Ÿ ãã‚Œã¯MySQL/InnoDB 5.1ã®ç’°å¢ƒã§ç§’é–“75ä¸‡ã‚¯ã‚¨ãƒªã¨ã„ã†ã€å¤šãã®NoSQLã§ã‚‚å®Ÿç¾ã§ããªã„ã‚ˆã†ãªé«˜æ€§èƒ½ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã‹ã‚‰ã€‚DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ã¯ã€è‡ªèº«ã®ãƒ–ãƒã‚°ã«ã“ã‚“ãªå†…å®¹ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒUsing MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity serverã€ï¼ˆè‹±èªžï¼‰ã‚’ãƒœã‚¹ãƒˆã—ã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server æ¾ä¿¡æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€å¤§è¦æ¨¡ãªãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ä¼æ¥ã®å¤šãã¯åˆ†æ•£ç’°å¢ƒã§
ablabo 2010/10/27
mysql

nosql

db
ãƒªãƒ³ã‚¯
å¤§äººã®ãŸã‚ã®InnoDBãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã®æ£ã—ã„ä»˜ãåˆã„æ–¹ã€‚
InnoDBé–¢é€£ã§ã‚ˆãã‚ã‚‹è³ªå•ã®ã²ã¨ã¤ã«ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã¯ä½•ã‚’ã™ã‚Œã°ã„ã„ã‚“ã§ã™ã‹ï¼Ÿã€ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚InnoDBã¯MySQL 5.5ã§ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ãªã‚‹ãŸã‚ã€InnoDBã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹è¨ˆç”»ã‚’ç«‹ã‚ˆã†ã¨æ€ã†æ©Ÿä¼šã‚‚å¢—ãˆã‚‹ã“ã¨ã ã‚ã†ã€‚ãã“ã§ã€ä»Šæ—¥ã¯InnoDBã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã®å„ç¨®æ–¹æ³•ã¨ãªãœãã†ã—ãªã‘ã‚Œã°ã„ã‘ãªã„ã‹ã¨ã„ã†ç†ç”±ã‚’è§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€‚ ANALYZE TABLEãƒ†ãƒ¼ãƒ–ãƒ«ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã®ä»£åè©žã¨ã„ãˆã°ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹çµ±è¨ˆæƒ…å ±ã®æ›´æ–°ã§ã¯ãªã‹ã‚ã†ã‹ã€‚é‹ç”¨ã‚’ç¶šã‘ã‚‹ã†ã¡ã«ã€çŸ¥ã‚‰ãšçŸ¥ã‚‰ãšã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹çµ±è¨ˆæƒ…å ±ãŒç‹‚ã£ã¦ã—ã¾ã„ã€æ€ã†ã‚ˆã†ãªæ€§èƒ½ãŒå‡ºãªã„ã€‚RDBMSã«ã¯ãã®ã‚ˆã†ãªå•é¡ŒãŒã¤ãã‚‚ã®ã§ã‚ã‚‹ãŒã€InnoDBã®å ´åˆã€ANALYZE TABLEã¯ä¸è¦ã§ã‚ã‚‹ã€‚ãªãœãªã‚‰ã€InnoDBãŒè‡ªç™ºçš„ã«çµ±è¨ˆæƒ…å ±ã‚’æ›´æ–°ã™ã‚‹ã‹ã‚‰ã ã€‚InnoDBã¯ä»¥ä¸‹ã®æ¡ä»¶ã«é©åˆã™ã‚‹ã¨ã€ANALYZE T
ablabo 2010/09/27
mysql

db
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸