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

nori0620 id:nori0620

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

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

ç¬¬79å›žã€€MySQLã®ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰ã‚¹ãƒ¬ãƒ¼ãƒ–ï¼šMySQLé“æ™®è«‹ä¾¿ã‚Šï½œgihyo.jp â€¦ æŠ€è¡“è©•è«–ç¤¾
MySQLã®å¾“æ¥ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯ã€ãƒžã‚¹ã‚¿ãƒ¼ã‹ã‚‰ã®æ›´æ–°ãŒã‚ã£ãŸå ´åˆã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã§ã¯ã‚·ãƒ³ã‚°ãƒ«ã‚¹ãƒ¬ãƒƒãƒ‰ã§å‡¦ç†ã•ã‚Œã¾ã™ã€‚ã‚ˆã£ã¦ã€ãƒžã‚¹ã‚¿ãƒ¼ã®ä¸¦åˆ—ã§ã®æ›´æ–°ãŒå¤šã„ã¨ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã§é…å»¶ãŒç™ºç”Ÿã™ã‚‹ã“ã¨ãŒã‚ˆãã‚ã‚Šã¾ã™ã€‚æœ€è¿‘ã®MySQLã§ã¯ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã§ã®å®Ÿè¡Œã‚’é€Ÿãã™ã‚‹ãŸã‚ã«ã€Œãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰ã‚¹ãƒ¬ãƒ¼ãƒ–ã€ã¨ã„ã†æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã€ä¸¦åˆ—å®Ÿè¡ŒãŒå¯èƒ½ã«ãªã£ã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯ã€MySQL5.6ã‹ã‚‰è¿½åŠ ã•ã‚ŒãŸãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰ã‚¹ãƒ¬ãƒ¼ãƒ–ï¼ˆMTSï¼‰ã«ã¤ã„ã¦ã€MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã‚‹é€²åŒ–ã¨å…±ã«ç´¹ä»‹ã—ã¾ã™ã€‚ MTSã«ã¤ã„ã¦ å‰æã¨ã—ã¦ã€MTSã‚’æœ‰åŠ¹åŒ–ã™ã‚‹ã«ã¯ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã§slave_parallel_workersã‚ªãƒ—ã‚·ãƒ§ãƒ³ã«0ã‚ˆã‚Šå¤§ãã„æ•°å€¤ã‚’è¨å®šã—ã¾ã™ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯0ï¼ˆç„¡åŠ¹ï¼‰ã§ã™ã€‚ ã“ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¯ã€ä¸¦åˆ—ã§å®Ÿè¡Œã™ã‚‹ãŸã‚ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ãƒ¯ãƒ¼ã‚«ãƒ¼ã‚¹ãƒ¬ãƒƒãƒ‰ã®æ•°ã‚’æŒ‡å®šã—ã¾ã™ã€‚SQLã‚¹ãƒ¬ãƒƒãƒ‰ã¯å¾“æ¥ã§ã‚ã‚Œã°ã‚¹ãƒ¬ãƒ¼ãƒ–ã«SQLã‚’å®Ÿè¡Œã—ã¦ã„ã¾ã—ãŸãŒã€MTSã®å ´
nori0620 2021/05/17
MySQL
ãƒªãƒ³ã‚¯
Ansibleã®mysql_userãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦rootã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã™ã‚‹ - chulip.org
http://docs.ansible.com/ansible/mysql_user_module.html MySQL dbãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« mysel_userãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã™ã‚‹ãŸã‚ã«ã¯ä¸‹è¨˜è¨˜è¼‰ã®ã‚ˆã†ã«Pythonã®MySQL dbãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒå¿…è¦ã€‚ Requirements (on host that executes module) MySQL db http://docs.ansible.com/ansible/mysql_user_module.html#requirements-on-host-that-executes-module Amazon Linuxç’°å¢ƒã ã£ãŸã®ã§Yumãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒã§ããŸã€‚ ãŸã ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’æŒ‡å®šã™ã‚‹å¿…è¦ãŒã‚ã£ãŸã€‚æŒ‡å®šãŒãªã„çŠ¶æ…‹ã ã¨2.6ç”¨ã®ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹ã€‚ # yum install -y MySQL-python
nori0620 2020/02/11
ansible

mysql
ãƒªãƒ³ã‚¯
Fluentdã‚’ä½¿ã£ã¦NginxLogã‚’Mysqlã«ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã§æ ¼ç´ã™ã‚‹ - Y's note
ã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã®ãŸã‚ã®MySQL[é‹ç”¨+ç®¡ç†]ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã‚¬ã‚¤ãƒ‰ ä½œè€…: å¥¥é‡Žå¹¹ä¹Ÿå‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: æŠ€è¡“è©•è«–ç¤¾ç™ºå£²æ—¥: 2010/06/12ãƒ¡ãƒ‡ã‚£ã‚¢: å¤§åž‹æœ¬è³¼å…¥: 16äºº ã‚¯ãƒªãƒƒã‚¯: 204å›žã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (31ä»¶) ã‚’è¦‹ã‚‹ é‡è¦ãªãƒ‡ãƒ¼ã‚¿ã¯Mysqlã¸ CentOSã§Nginxã®ãƒã‚°ã‚’Fluentdã‚’ä½¿ã£ã¦Mongo dbã«ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã§æ ¼ç´ã™ã‚‹ - Yuta.Kikuchiã®æ—¥è¨˜ Mongo DBã®é›†è¨ˆæ©Ÿèƒ½ãŒä¾¿åˆ©éŽãŽã¦æ³£ã‘ã¦ãã‚‹ãŠè©±ã— - Yuta.Kikuchiã®æ—¥è¨˜ æœ€è¿‘ã¯å¤§å¦ç”Ÿã«è‰¯ãé–“é•ã‚ã‚Œã‚‹ç¾åœ¨30æ³ã®@yutakikucã§ã™ã€‚ä»Šæ—¥ã¯Nginx Logã®å¿…è¦ãªé …ç›®ã‚’Mysqlã«ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã§æ ¼ç´ã™ã‚‹ã“ã¨ã‚’è©¦ã—ã¦ã¿ã¾ã™ã€‚é‡è¦ãªãƒ‡ãƒ¼ã‚¿ã¯ã©ã“ã«æ ¼ç´ã™ã‚‹ã®..ï¼Ÿ Mysqlã§ã—ã‚‡ï¼ã¨ã„ã†äººå‘ã‘ã«æ›¸ã„ã¦ã¿ã¾ã™ã€‚éŽåŽ»ã«Mongo dbã«æ ¼ç´ã—ã¦é›†è¨ˆã™ã‚‹ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’æ›¸ã„ãŸã®ã§ãã¡ã‚‰
nori0620 2016/01/16
mysql
ãƒªãƒ³ã‚¯
MySQL åˆã‚ã¦ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
2. è‡ªå·±ç´¹ä»‹ â€¢ id:Craftworks â€¢ Twitter: @Craftworks â€¢ github: https://github.com/Craftworks â€¢ Blog: http://d.hatena.ne.jp/Craftworks â€¢ æœ€è¿‘ã¯ EC2 ã§ Perl æ›¸ã„ã¦ã¾ã™ â€¢ ãšã£ã¨ PostgreSQL ã‚’ä½¿ã£ã¦ã„ãŸ MySQL åˆå¿ƒè€…ã§ã™
nori0620 2015/03/13
mysql
ãƒªãƒ³ã‚¯
MySQL 5.1ã®mysqldumpslowã§å¿«é€Ÿãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - SH2ã®æ—¥è¨˜
MySQL 5.1ã®mysqldumpslowã‚’ä½¿ã†ã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãŒæ¥½ã«ãªã‚‹ï¼ã¨ã„ã†è©±é¡Œã§ã™ã€‚ mysqldumpslowã¯ã‚‚ã¨ã‚‚ã¨MySQLã«ä»˜å±žã—ã¦ã„ã‚‹ãƒ„ãƒ¼ãƒ«ã§ã€ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã‚’é›†è¨ˆã—ã¦ãã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ã“ã‚Œè‡ªä½“ã¯MySQL 5.1ã§ç‰¹ã«å¤‰ã‚ã£ãŸã¨ã“ã‚ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°æœ¬ä½“ã®æ–¹ãŒæ©Ÿèƒ½å¼·åŒ–ã•ã‚Œã¦ã„ã‚‹ãŸã‚ã€çµ„ã¿åˆã‚ã›ã‚‹ã¨ãªã‹ãªã‹ä¾¿åˆ©ã«ãªã£ã¦ã„ã¾ã™ã€‚MySQL 5.1ã«ãŠã‘ã‚‹ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã®ä¸»ãªæ©Ÿèƒ½å¼·åŒ–ã¯ä»¥ä¸‹ã®ä¸‰ç‚¹ã§ã™ã€‚ long_query_timeã«1ç§’æœªæº€ã®å€¤ã‚’è¨å®šã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ å‡ºåŠ›å…ˆã‚’è¨å®šã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ ã“ã‚Œã‚‰ã®è¨å®šã‚’ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§å¤‰æ›´ã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ ã“ã‚Œã§ã©ã†ãªã‚‹ã‹ã¨ã„ã†ã¨ã€MySQLã®æ€§èƒ½åˆ†æžã‚’ã—ãŸã„ã¨æ€ã£ãŸã¨ãã«ã€ã‚µãƒ¼ãƒã‚’æ¢ã‚ãšã«ãã®å ´ã§ mysql> set global slow_query_log = 1; mysql> set glob
nori0620 2013/10/07
mysql
ãƒªãƒ³ã‚¯
Mysql casial01
5. backup tool â€¢ mysqldump â€¢ ibbackup & innobackup â€¢ xtrabackup & innobackupex â€¢ Mydumper â€¢ LVMã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆ 6. mysqldump â€¢ MySQL æœ¬ä½“ã«æ¨™æº–ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã¾ã™ã€‚ â€¢ è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼ˆSQLåˆ†ã®dumpï¼‰ã§ã™ã€‚ â€¢ InnoDBã®HotbackupãŒå¯èƒ½ã§ã™ã€‚ â€¢ ãƒ‡ãƒ¼ã‚¿é‡ã«ã¤ã‚‰ã‚Œã¦ãƒãƒƒã‚¢ãƒƒãƒ—ã®æ™‚é–“ãŒé•·ã ãªã‚Šã¾ã™ã€‚ï¼ˆãƒªã‚¹ãƒˆã‚¢ã‚‚å¤§å¤‰ï¼‰ 7. mysqldumpä½¿ã„æ–¹ ï¼ˆMyISAMã®å ´åˆï¼‰ # time mysqldump -uroot -p$password --lock-all-tables --master-data=2 hoge 2>./error.log |gzip > hoge_YYYYmmdd_HHMMSS.sql.gz â€¢ --lock-all-tabl
nori0620 2012/06/28
mysql
ãƒªãƒ³ã‚¯
DSASé–‹ç™ºè€…ã®éƒ¨å±‹:5åˆ†ã§ã§ãã‚‹ã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢ä¿‚ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦éžå¸¸ã«é‡è¦ã¨ãªã‚‹ãƒ¡ãƒ¢ãƒª(ãƒãƒƒãƒ•ã‚¡)é–¢é€£ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã€ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆ DSASã®ã¨ã‚ã‚‹DBã‚µãƒ¼ãƒ(å®Ÿãƒ¡ãƒ¢ãƒª4GB)ã®å®Ÿéš›ã®è¨å®šå€¤ ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã¾ãŸã€å¿…è¦ãƒ¡ãƒ¢ãƒªã®ç·é‡ã®è¨ˆç®—ã‚„é™ç•Œå€¤ã‚’è¶Šãˆã¦ãªã„ã‹ãƒã‚§ãƒƒã‚¯ã—ã¦ãã‚Œã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚‚ç´¹ä»‹ã—ã¾ã™ã€‚ æ˜¯éžã€å‚è€ƒã«ã—ã¦ã¿ã¦ãã ã•ã„ï¼ ã¾ãšæœ€åˆã«æ³¨æ„ç‚¹ã‚’ã€‚ ãƒãƒƒãƒ•ã‚¡ã«ã¯2ã¤ã®ã‚¿ã‚¤ãƒ—ãŒã‚ã‚Šã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã¯mysqldå…¨ä½“ã§ãã®ãƒãƒƒãƒ•ã‚¡ãŒ1ã¤ã ã‘ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã€ ã“ã‚Œã«å¯¾ã—ã€ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã¯ã‚¹ãƒ¬ãƒƒãƒ‰(ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³)ã”ã¨ã«ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®éš›ã«ã¯ã‚°ãƒãƒ¼ãƒãƒ«/ã‚¹ãƒ¬ãƒƒãƒ‰ã®é•ã„ã‚’æ„è˜ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€‚ ãªãœãªã‚‰ã€ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã«å¤šãã®ãƒ¡ãƒ¢ãƒªã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå¢—ãˆãŸã¨ãŸã‚“ã«ã‚¢ãƒƒã¨ã„ã†é–“ã«ãƒ¡ãƒ¢ãƒªä¸è¶³ã«ãªã£ã¦ã—ã¾ã†ã‹ã‚‰ã§ã™ã€‚ in
nori0620 2012/05/03
tips

mysql
ãƒªãƒ³ã‚¯
https://jp.techcrunch.com/2011/07/13/20110712y-combinator-alum-memsql-raises-2-1-million-from-ashton-kutcher-sv-angel-and-more/
nori0620 2011/07/13
MySQL
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ é–‹ç™ºè€…ãªã‚‰çŸ¥ã£ã¦ãŠããŸã„ MySQL INDEX + EXPLAINå…¥é–€ï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ é–‹ç™ºè€…ãªã‚‰çŸ¥ã£ã¦ãŠããŸã„ MySQL INDEX + EXPLAINå…¥é–€ åºƒãæµ…ãã‚’æ‹…å½“ã—ã¦ã¾ã™ã€ota ã§ã™ã€‚ æŠ€è¡“ãƒ–ãƒã‚°ç¬¬ä¸€å›žã‹ã‚‰æ—©é€Ÿæµç”¨ã‚¹ãƒ©ã‚¤ãƒ‰ã§ç”³ã—è¨³ã‚ã‚Šã¾ã›ã‚“ãŒã€ç¤¾å†…å‹‰å¼·ä¼šè³‡æ–™ã¨ã—ã¦ä½œæˆã—ãŸã€ŒMySQL INDEX + EXPLAINå…¥é–€ã€ã§ã™ã€‚ å½“ç¤¾ã§ã‚‚ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®é–‹ç™ºã‚’è¡Œã£ã¦ã„ã¾ã™ãŒã€ã“ã®ã‚ˆã†ãªå¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ç”¨ã™ã‚‹ãƒ»ã‚¯ã‚¨ãƒªã®é€Ÿåº¦ãŒæ±‚ã‚ã‚‰ã‚Œã‚‹å ´åˆã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å¤§å¤‰é‡è¦ã§ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æœ‰åŠ¹ãªåˆ©ç”¨ã«ã¯DBè¨è¨ˆè€…ã ã‘ã§ã¯ãªããƒ—ãƒã‚°ãƒ©ãƒžã«ã‚‚ã‚ã‚‹ç¨‹åº¦ã®çŸ¥è˜ãŒæœ€ä½Žé™å¿…è¦ã¨ãªã‚Šã¾ã™ãŒã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã®åˆå¿ƒè€…å‘ã‘è³‡æ–™ãŒã‚ã¾ã‚Šãªã„ã‚ˆã†ã§ã™ã€‚ ã“ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§ã¯ãƒ—ãƒã‚°ãƒ©ãƒžã«çŸ¥ã£ã¦ãŠã„ã¦æ¬²ã—ã„ä»¥ä¸‹ã®åŸºæœ¬çš„ãªç‚¹ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ INDEXã‚’ä½¿ç”¨ã™ã‚‹æ™‚ã«æ°—ã‚’ã¤ã‘ã‚‹ã“ã¨ WHEREå¥ !=ã€<>ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ç”¨ã§ããªã„ WHEREå¥ã®å…¨ã¦ã®ANDã«ã‹ã‹ã£ã¦ã„ãªã„ã‚¤ãƒ³
nori0620 2011/03/30
mysql

db
ãƒªãƒ³ã‚¯
Amazon.co.jp: å®Ÿè·µãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQL ç¬¬2ç‰ˆ: Baron Schwartz (è‘—), Peter Zaitsev (è‘—), Vadim Tkachenko (è‘—), Jeremy D. Zawodny (è‘—), Arjen Lentz (è‘—), Derek J. Balling (è‘—), ä¼Šè—¤ç›´ä¹Ÿ(ç›£è¨³) (ç¿»è¨³), ç”°ä¸æ…Žå¸(ç›£è¨³) (ç¿»è¨³), å‰å·è‹±èˆˆ(ç›£è¨³) (ç¿»è¨³), æ ªå¼ä¼šç¤¾ã‚¯ã‚¤ãƒ¼ãƒ— (ç¿»è¨³): æœ¬
nori0620 2011/02/08
mysql

book
ãƒªãƒ³ã‚¯
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
nori0620 2010/12/09
mysql

tips
ãƒªãƒ³ã‚¯
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ (OSS iPedia) ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã«ã¤ã„ã¦
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ (OSS iPedia) ã¯ã€2013å¹´5æœˆ17æ—¥(é‡‘) ã‚’ã‚‚ã¡ã¾ã—ã¦é‹ç”¨ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ é•·ã„é–“ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ã¦ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ OSS iPediaã§æä¾›ã—ã¦ãŠã‚Šã¾ã—ãŸã€IPA ãƒ•ã‚©ãƒ³ãƒˆã€æ–‡å—æƒ…å ±åŸºç›¤ã€ãã®ä»–å ±å‘Šæ›¸ç‰ã«ã¤ã„ã¦ã¯ã€ä¸‹è¨˜ãƒªãƒ³ã‚¯ã‚’ã”å‚ç…§ãã ã•ã„ã€‚ çš†æ§˜ã«ã¯å¤§å¤‰ã”ä¸ä¾¿ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ä½•å’ã”ç†è§£ã®ç¨‹ã‚’ã‚ˆã‚ã—ããŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚
nori0620 2010/10/12
mysql

db
ãƒªãƒ³ã‚¯
Announcement: ELB stickiness updates to support Feb 2020 Chromium CORs changes
You have been redirected here because the page you are trying to access has been archived. AWS re:Post is a cloud knowledge service launched at re:Invent 2021. We've migrated selected questions and answers from Forums to AWS re:Post. The thread you are trying to access has outdated guidance, hence we have archived it. If you would like up-to-date guidance, then share your question via AWS re:Post.
nori0620 2010/02/26
ec2

mysql
ãƒªãƒ³ã‚¯
mysqlã®int(11)ã®11
MySQL Manual | 6.2.1 æ•°å€¤åž‹ MySQL ã«ã¯ã€INT(4) ã®ã‚ˆã†ã«ã€åž‹ã®åŸºæœ¬ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã«ç¶šã„ã¦æ•´æ•°å€¤ã®è¡¨ç¤ºå¹…ã‚’ã‹ã£ã“å†…ã«æŒ‡å®šã§ãã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã®è¡¨ç¤ºå¹…ã®æŒ‡å®šã¯ã€ã‚«ãƒ©ãƒ ã«æŒ‡å®šã•ã‚ŒãŸå¹…ã‚ˆã‚Šå°ã•ã„å¹…ã‚’æŒã¤å€¤ã§è¡¨ç¤ºã®å·¦å´ã‚’åŸ‹ã‚ã‚‹ç›®çš„ã§ä½¿ç”¨ã•ã‚Œã¾ã™ãŒã€ãã®ã‚«ãƒ©ãƒ ã«æ ¼ç´ã§ãã‚‹å€¤ã®ç¯„å›²ãŒåˆ¶é™ã•ã‚ŒãŸã‚Šã€ãã®ã‚«ãƒ©ãƒ ã«æŒ‡å®šã•ã‚ŒãŸå¹…ã‚’è¶…ãˆã‚‹å¹…ã‚’æŒã¤å€¤ã®æ¡æ•°ãŒåˆ¶é™ã•ã‚ŒãŸã‚Šã™ã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã®æ‹¡å¼µå±žæ€§ ZEROFILL ã¨çµ„ã¿åˆã›ã¦ä½¿ç”¨ã—ãŸå ´åˆã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ã‚¹ãƒšãƒ¼ã‚¹ã«ä»£ã‚ã£ã¦ã‚¼ãƒãŒåŸ‹ã‚è¾¼ã¾ã‚Œã¾ã™ã€‚ã‘ã£ã“ã†å‹˜é•ã„ã—ã¦ã„ã‚‹äººãŒã„ãã†ãªã®ã§ã™ãŒã€mysqlã®åž‹ã§int(?)ã¨ã‹ã€?ã«æ•°å—ã‚’å…¥ã‚Œã¾ã™ãŒã€ã“ã®æ•°å—ã¯ä¸Šè¨˜ã®é€šã‚ŠZEROFILLã‚’ã—ãŸéš›ã«ã‚¹ãƒšãƒ¼ã‚¹ã«ä»£ã‚ã£ã¦ã‚¼ãƒãŒåŸ‹ã‚è¾¼ã¾ã‚Œã‚‹éš›ã®å¹…ãªã®ã§ã™ã€‚è‡ªåˆ†ã¯å‹˜é•ã„ã¨ã„ã†ã‹ã‚ã¾ã‚Šã‚ˆãã‚ã‹ã£ã¦ã„ã¾ã›ã‚“ã§ã—ãŸâ€¦ã€‚ ã¤ã¾ã‚Š
nori0620 2009/12/04
å‹˜é•ã„ã—ã¦ãŸã€‚ã€‚

mysql
ãƒªãƒ³ã‚¯
kndb.jp
This domain may be for sale!
nori0620 2009/11/25
MySQL

tuning
ãƒªãƒ³ã‚¯
ç¾å ´æŒ‡å‘ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è©³èª¬
ã“ã®æ–‡æ›¸ã¯ã€æŠ€è¡“è©•è«–ç¤¾åˆŠã€ŽWEB+DB PRESS Vol.22ã€ã«åŸ·ç†ã—ãŸè¨˜äº‹ã‚’æŠ€è¡“è©•è«–ç¤¾ã® è¨±å¯ã‚’å¾—ã¦WWWã§å…¬é–‹ã—ã¦ã„ã‚‹ã‚‚ã®ã§ã™ã€‚ ã“ã®WWWç‰ˆã¯æ ¡æ£å‰ã®åŽŸç¨¿ã‚’å…ƒã«ã—ã¦ã„ã‚‹ç‚¹ã€WWWå…¬é–‹å¾Œã«å¿…è¦ãŒã‚ã‚Œã°ä¿®æ£ã™ã‚‹ç‚¹ã§ã€é›‘èªŒç‰ˆã®æ–‡ç« ã¨ã¯ç•°ãªã‚‹éƒ¨åˆ†ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å›³è¡¨ã‚‚é›‘èªŒç‰ˆã¨ã¯ç•°ãªã‚Šã¾ã™ã€‚ äºˆã‚ã”äº†æ‰¿ãã ã•ã„ã€‚ ã¾ãŸã€ã“ã®æ–‡ç« ãŒå¯¾è±¡ã—ã¦ã„ã‚‹ã®ã¯MySQL 4.0ç³»ãªã®ã§ã€æœ€æ–°ã®ãƒªãƒªãƒ¼ã‚¹ç‰ˆã¨æ¯”ã¹ã‚‹ã¨èª¬æ˜Žä¸è¶³ãªç‚¹ãªã©ãŒå¤šã€…ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®åŸºæœ¬ã‚’ãŠã•ãˆã‚‹ã«ã¯ã€ã“ã®æ–‡æ›¸ã¯ã¾ã æœ‰ç›Šã ã¨æ€ã„ã¾ã™ãŒã€è¨å®šãƒ¬ãƒ™ãƒ«ã®èª¬æ˜Žã¯æœ€æ–°ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’å‚ç…§ã™ã‚‹ã‚ˆã†ã«ã—ã¦ãã ã•ã„ã€‚
nori0620 2009/11/21
mysql
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: RDBã§éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ã«ã¯ï¼Ÿ
yukiã§ã™ã€‚ãƒ€ã‚¤ã‚¨ãƒƒãƒˆã‚’å§‹ã‚ã¦3kgæ¸›ã£ãŸã¨æ€ã£ãŸã‚‰ã€é¢¨é‚ªã‚’å¼•ã„ã¦è¦‹äº‹ã«1kgå¢—é‡ã€‚ é‹å‹•ã—ãªã„ã¨é§„ç›®ã§ã™ãã€‚ã‚ã¨æ®‹ã‚Š20kgã€é“ã®ã‚Šã¯é ã„ã§ã™ã€‚ ã•ã¦ä»Šå›žã¯ã€ã€ŒRDBã§éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ã«ã¯ï¼Ÿã€ã§ã™ã€‚ ã‚ã‚‹ã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰ä¸ã«éšŽå±¤æ§‹é€ ã‚’ã‚‚ã£ãŸã‚«ãƒ†ã‚´ãƒªæ§‹é€ ã«ã™ã‚‹ã“ã¨ã«ãªã‚Šã€ã©ã®ã‚ˆã†ã«DBã§æ‰±ã†ã‹æ‚©ã¿ã¾ã—ãŸã€‚ DBã¯MySQLã‚’æŽ¡ç”¨ã—ã¦ã„ãŸã®ã§ã€ã“ã®æ™‚ç‚¹ã§ã±ã£ã¨é ã«æµ®ã‹ã‚“ã é¸æŠžè‚¢ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã§ã—ãŸã€‚ XML-DBã‚’åˆ©ç”¨ã™ã‚‹ è¦ªã‚«ãƒ†ã‚´ãƒªãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªIDã‚’åã‚«ãƒ†ã‚´ãƒªãƒ¬ã‚³ãƒ¼ãƒ‰ã«æŒãŸã›ã‚‹ è¦ªã‚’å«ã‚ãŸã€Žçµ¶å¯¾ãƒ‘ã‚¹ã€ã‚’åç§°ã¨ã—ã¦æ‰±ã„ã€å–ã‚Šå‡ºã—ãŸå¾Œã«ãƒ‘ãƒ¼ã‚¹ ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã«åŒæ§˜ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã‚’ä½œã‚Šã€æ¯Žå›žãƒ‘ãƒ¼ã‚¹ã™ã‚‹ (1)ã®XMLDBã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®eXistã‚„Xindiceã€Yggdrasillãªã©æ§˜ã€…ãªé¸æŠžè‚¢ãŒã‚ã‚Šã¾ã—ãŸãŒã€ã‚«ãƒ†ã‚´ãƒªã®ã¿ã®åˆ©ç”¨ãªå‰²ã«ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚³ã‚¹ãƒˆãŒé«˜ã™ãŽã‚‹ã®ã§è¦‹é€ã‚Šã¾
nori0620 2009/06/25
algorithm

database

mysql

programming
ãƒªãƒ³ã‚¯
mysqlã§ã„ã¡ã„ã¡show databasesã¨ã‹æ‰“ã¤ã®ãŒã‚ã‚“ã©ã„â†’readlineã®ãƒžã‚¯ãƒã§è§£æ±º - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQLã§ã„ã¡ã„ã¡show tables;ã¨ã‹æ‰“ã¤ã®ãŒã ã‚‹ã„ã€‚\tã¿ãŸã„ãªaliasè¨å®šã§ããªã„ã®ã‹ãªã http://twitter.com/weboo/status/1658300902 ãŠã‰ã€readlineã®ãƒžã‚¯ãƒã‚’ä½¿ãˆã°ã„ã„ã®ã‹ãƒ¼ http://twitter.com/weboo/status/1658314333 ãªã‚‹ã»ï¼ã£ã¦ã“ã¨ã§ã¡ã‚‡ã£ã¨è¨å®šã—ã¦ã¿ã¾ã—ãŸã€‚ # ~/.inputrc $if mysql "\C-xd": "show databases;" "\C-xt": "show tables;" "\C-xu": "select user,host,password from mysql.user order by user,host;" "\C-xb": "select user,host,db from mysql.db order by user,host;"
nori0620 2009/06/01
linux

mysql

tips
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨ã„ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã«ã¤ã„ã¦ - LukeSilviaâ€™s diary
Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Œãªã„ã‚»ãƒƒã‚·ãƒ§ãƒ³æ©Ÿæ§‹ã€‚DB ãƒ™ãƒ¼ã‚¹ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã‚’è¡Œãªã£ã¦å¾—ã‚‰ã‚ŒãŸçŸ¥è¦‹ã¨ã€ãã‚Œã‚’å…ƒã«è€ƒå¯Ÿã—ãŸçµæžœã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã®ç‰¹æ€§ DB ã§ç®¡ç†ã•ã‚Œã‚‹ä»–ã®ãƒ‡ãƒ¼ã‚¿ã«æ¯”ã¹ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã¯ã‹ãªã‚Šç‰¹æ®Šã§ã™ã€‚ä¸»ãªç‰¹å¾´ã¯æ¬¡ã®ã‚ˆã†ãªæ„Ÿã˜ã€‚ ãƒ‡ãƒ¼ã‚¿ãŒå¢—åŠ ã™ã‚‹ã®ãŒé€Ÿã„ å®šæœŸçš„ãªå‰Šé™¤ãŒå¿…è¦ é »ç¹ã«æ›´æ–°ã•ã‚Œã‚‹ ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ¯Žã«èªã¿ã«è¡Œãå¿…è¦ãŒã‚ã‚‹ ã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã‚ãªã„ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å…¨ä½“ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„ ã‚¢ã‚¯ã‚»ã‚¹é »åº¦ãŒé«˜ã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã‚ã¨ã€1ã¤ç›®ã®ç‰¹å¾´ã‹ã‚‰ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã¯æ„è˜çš„ã«ç®¡ç†ã—ã¦ã‚„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ç¾åœ¨ã®ç’°å¢ƒ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é ˜åŸŸãŒå°‘ã—ç‰¹æ®Šã§ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ãŒã‚„ãŸã‚‰ãŸã¾ã‚Šã¾ã™(ãƒ¦ãƒ¼ã‚¶æ•°ä½•ç™¾ä¸‡ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ãã†ã„ã†ã®ã§ã¯ãªã„ã§ã™)ã€‚ RDBMS MySQL 4.0.22 ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ InnoDB ãƒ¬ã‚³ãƒ¼ãƒ‰æ•° 6åƒä¸‡ ãƒ†ãƒ¼ã‚¿ã‚µ
nori0620 2009/05/25
database

mysql

performance
ãƒªãƒ³ã‚¯
http://labs.cybozu.co.jp/blog/kazuho/archives/2008/06/friends_timeline.php
nori0620 2008/06/10
algorithm

database

mysql

programming

sql

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