[B! ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°] kopugã®ãƒ

kopug id:kopug

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢ã™ã‚‹kopugã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

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

ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç–ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç– ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã®æ¾æµ¦éš¼äººã•ã‚“ã«ã€8ã¤ã®ã€ŒSQLãŒé‡ãŸããªã‚‹åŽŸå› ã¨ãã®å¯¾ç–ã€ã‚’èžãã¾ã—ãŸã€‚ã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚‹ã‚ˆã†ãªã€Œå•é¡Œã®ã‚ã‚‹SQLã€ã‚’å›žé¿ã™ã‚‹ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã³ã¾ã—ã‚‡ã†ã€‚ ãƒ‡ãƒ¼ã‚¿ã®æ“ä½œã‚„å®šç¾©ã‚’ã™ã‚‹è¨€èªžã€ŒSQLã€ã¯ã€ã©ã®ã‚ˆã†ãªé ˜åŸŸã‚’æ‹…ã†ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦ã‚‚å¿…ä¿®ç§‘ç›®ã§ã™ã€‚ã—ã‹ã—ã€ãã®ä»•æ§˜ã‚’ãã¡ã‚“ã¨ç†è§£ã—ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å„ªã‚ŒãŸSQLã‚’æ›¸ã‘ã‚‹æ–¹ã¯ãã‚Œã»ã©å¤šãã‚ã‚Šã¾ã›ã‚“ã€‚å•é¡Œã®ã‚ã‚‹SQLã‚’æ›¸ã„ã¦ã—ã¾ã„ã€çŸ¥ã‚‰ã¬é–“ã«ãã‚ŒãŒã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã—ã¾ã†äº‹æ…‹ã¯ã‚ˆãç™ºç”Ÿã—ã¾ã™ã€‚ ã§ã¯ã€ã©ã†ã™ã‚Œã°ãã†ã—ãŸäº‹æ…‹ã‚’å›žé¿ã§ãã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã®ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã¶ãŸã‚ã€ä»Šå›žã¯ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã§ã‚ã‚Šã€è‡ªèº«ã‚‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚ã‚ã‚‹æ¾æµ¦éš¼äººï¼ˆã¾ã¤ã†ã‚‰ãƒ»ã¯ã‚„ã¨ï¼@dblmktï¼‰ã•ã‚“ã«8ã¤
kopug 2017/06/27
sql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
æœ€é©ãªãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã‚µã‚¤ã‚ºã‚’è¨ˆç®—ã™ã‚‹SQL - R42æ—¥è¨˜
StackOverflowã§ãƒŠã‚¤ã‚¹ãªå›žç”ã‚’è¦‹ã¤ã‘ãŸã€‚ ä»¥ä¸‹ã€è‡ªåˆ†ç”¨ãƒ¡ãƒ¢ã¨ã—ã¦è¦ç‚¹ã‚’ãƒ”ãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€‚ http://dba.stackexchange.com/questions/27328/how-large-should-be-mysql-innodb-buffer-pool-size InnoDBã®æœ€é©ãªãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã‚µã‚¤ã‚ºã‚’äºˆæƒ³ã™ã‚‹ã«ã¯ã€ã¾ãšã“ã®SQLã‚’å®Ÿè¡Œã™ã‚‹ã€‚ SELECT Ceiling(total_innodb_bytes * 1.6 / Power(1024, 3)) RIBPS FROM (SELECT Sum(data_length + index_length) Total_InnoDB_Bytes FROM information_schema.tables WHERE engine = 'InnoDB') A; ã“ã‚Œã¯ã€ç¾æ™‚ç‚¹ã§InnoDBãŒä½¿ã£ã¦ã„ã‚‹ãƒ¡ãƒ¢ãƒªã®ç·é‡ã‚’
kopug 2016/02/17
innodb

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

performance

mysql
ãƒªãƒ³ã‚¯
MySQL 5.6ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã¹ãé …ç›® | Yakst
MySQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒžãƒãƒ¼ã‚¸ãƒ£ã®Morgan Tockeræ°ã«ã‚ˆã‚‹ã€MySQL 5.6ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸå¾Œã«ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã‹ã‚‰å¤‰æ›´ã—ãŸæ–¹ãŒã‚ˆã„ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®è§£èª¬ã€‚ æ•°ã€…ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã®æ”¹å–„ã«ã‚ˆã£ã¦ã€éŽåŽ»ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨æ¯”ã¹ã¦MySQL 5.6ã§ã¯è¨å®šã—ãªãã¦ã¯ãªã‚‰ãªã„å€¤ãŒã‹ãªã‚Šæ¸›ã£ãŸã€‚ã¨ã¯è¨€ãˆã€å¤‰æ›´ã™ã¹ãã‚‚ã®ã«ã¤ã„ã¦ã“ã“ã§æ›¸ã„ã¦ãŠããŸã„ã€‚ InnoDBã®è¨å®š innodb_buffer_pool_size - ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯128Mã€‚ã“ã‚Œã¯ã€ãƒ¡ãƒ¢ãƒªã«ãƒãƒ¼ãƒ‰ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãŸã‚ã«InnoDBãŒã©ã®ãã‚‰ã„ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã‹ã‚’æŒ‡å®šã™ã‚‹ã‚‚ã®ãªã®ã§ã€è¨å®šã™ã¹ãé‡è¦ãªå€¤ã ã€‚MySQLã®å°‚ç”¨ã‚µãƒ¼ãƒãªã‚‰ã€æè¼‰ã•ã‚Œã¦ã„ã‚‹ãƒ¡ãƒ¢ãƒªã®50%ã‹ã‚‰80%ãŒæŽ¨å¥¨ã•ã‚Œã‚‹è¨å®šå€¤ã ã€‚ä¾‹ãˆã°ã€64GBã®RAMã‚’æè¼‰ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒãªã‚‰ã€ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã¯50GBç¨‹åº¦ã«ã™ã¹ãã ã‚ã†ã€‚ innodb_log_file_size -
kopug 2015/09/20
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
nginxæœ€å¤§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‡ºã™ãŸã‚ã®åŸºæœ¬è¨å®š-ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚µãƒ¼ãƒ»æ—¥æœ¬
Nginxãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° nginxæœ€å¤§é™ã«ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’å‡ºã™ãŸã‚ã«ã€è¨å®šãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã‚’ãƒãƒ¥ãƒ‹ãƒ³ã‚°ã—ã¾ã—ãŸã€‚ nginxè¨å®šä¾‹ user www-data; pid /var/run/nginx.pid; worker_processes auto; worker_rlimit_nofile 100000; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; events { worker_connections 2048; multi_accept on; use epoll; } http { server_tokens off; sendfile on; tcp_nopush on; tcp_nodelay on; access_log o
kopug 2014/08/03
nginx

performance

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° (ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã®æ¤œå‡º) : Figure out!! -ãƒ‰ãƒªã‚³ãƒ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ï¼ onk ã§ã™ã€‚ SAPã•ã‚“ãŒå„ç¤¾ã¨ã‚‚ã€Œã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—ãƒªã¯è² è·å¯¾ç–ãŒå¤§äº‹ã€ã£ã¦è¨€ã£ã¦ã„ã¾ã™ãã€‚å¼Šç¤¾ã§ã‚‚ mixi ã‚¢ãƒ—ãƒª(PC)ï¼Œmixi ã‚¢ãƒ—ãƒªãƒ¢ãƒã‚¤ãƒ«ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ãŸã¨ãã¯ãŠç¥ã‚ŠçŠ¶æ…‹ã ã£ãŸã®ã§ï¼Œãµã‚Šã‹ãˆã‚Šã‚‚å…¼ãã¦ MySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’èª¿ã¹ã‚‹æ–¹æ³•ã‚’æ›¸ã„ã¦ã¿ã¾ã—ãŸã€‚(å¹¸ã„ï¼Œãƒ¢ãƒã‚²ãƒ¼ã‚ªãƒ¼ãƒ—ãƒ³ã‚²ãƒ¼ãƒ ã®ãƒªãƒªãƒ¼ã‚¹æ™‚ã¯ã“ã‚Œã‚‰ã®çµŒé¨“ãŒå½¹ã«ç«‹ã£ãŸã®ã§ä½•ã¨ã‚‚ãªã‹ã£ãŸã§ã™) ã¨ã„ã£ã¦ã‚‚ 9 å‰²æ–¹ ãã‚‚ãã‚‚ã‚µãƒ¼ãƒã®è¨å®šãŒãŠã‹ã—ã„ æ›´æ–°ãŒå¤šã„ãƒ†ãƒ¼ãƒ–ãƒ«ãªã®ã« MyISAM ã‚¨ãƒ³ã‚¸ãƒ³ for æ–‡ã®ä¸ã§ã‚¯ã‚¨ãƒªã‚’ç™ºè¡Œ INDEX å¼µã£ã¦ãªã„ ãƒ‡ãƒ¼ã‚¿é‡ãŒãˆã‚‰ã„ã“ã¨ã«ãªã£ã¦ã‚‹ è¾ºã‚Šãªã‚“ã§ã™ã‘ã©ããƒ¼ã€‚ åŸºæœ¬ã¯ä¸‹ã‹ã‚‰ ã¾ãšï¼Œãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’èª¿ã¹ã‚‹ã¨ãã¯ä¸‹ã®å±¤ã‹ã‚‰ä¸ŠãŒã£ã¦ã„ãã®ãŒåŸºæœ¬ã§ã™ã€‚ãŸã¶ã‚“ã€‚ ãªã®ã§ ssh ã§ã‚µãƒ¼ãƒã«å…¥ã£ã¦ (LoadAverage 300 ãã‚‰ã„ã¾ã§ãªã‚‰ãªã‚“ã¨ã‹å…¥ã‚Œã¾ã™ã) ä»¥ä¸‹ã®ã‚³ãƒžãƒ³
kopug 2013/09/18
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
http://linux.mini13i.com/?kernel%2F%A5%B7%A5%B9%A5%C6%A5%E0%A5%D1%A5%E9%A5%E1%A5%BF
kopug 2012/01/17
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

linux

ã‚«ãƒ¼ãƒãƒ«

sysctl
ãƒªãƒ³ã‚¯
ALTER TABLEã‚’ä¸Šæ‰‹ã«ä½¿ã„ã“ãªãã†ã€‚
ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’å¤‰æ›´ã—ãŸã„ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒå£Šã‚Œã¦ã—ã¾ã£ãŸã®ã§å†ä½œæˆã—ãŸã„ã€‚ãã‚“ãªå ´åˆã¯ALTER TABLEã‚’ä½¿ã†ã€‚ALTER TABLEã¯ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’å¤‰æ›´ã™ã‚‹ãŠé¦´æŸ“ã¿ã®ã‚³ãƒžãƒ³ãƒ‰ã§ã‚ã‚‹ãŒã€ãã®æŒ™å‹•ã¯æ„å¤–ã¨çŸ¥ã‚‰ã‚Œã¦ã„ãªã„ã€‚ï¼ˆã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã¨ãŠã¼ã—ãæ–¹ã€…ã‹ã‚‰ã‚‚åº¦ã€…è³ªå•ã‚’å—ã‘ã‚‹ã€‚ï¼‰ãã‚“ãªã‚ã‘ã§ã€ä»Šæ—¥ã¯ALTER TABLEã«ã¤ã„ã¦è§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€‚ ã¾ãšçµè«–ã‹ã‚‰è¨€ã†ã¨ã€ãªã‚“ã¨MySQLã®ALTER TABLEã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’å…¨ã¦ã‚³ãƒ”ãƒ¼ã—ç›´ã™ã®ã§ã‚ã‚‹ã€‚ãªã‚“ã¦ç„¡é§„ãªã“ã¨ã‚’ï¼ï¼Ÿã¨æ€ã†ã‹ã‚‚çŸ¥ã‚Œãªã„ãŒã€ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ï¼ˆã‚¹ã‚ãƒ¼ãƒžï¼‰ã®å¤‰æ›´ã‚’å‹•çš„ã«è¡Œã†ã«ã¯ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã‚ˆã‚‹ã‚µãƒãƒ¼ãƒˆãŒå¿…è¦ã§ã‚ã‚Šã€å‹•çš„ãªã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯ã¾ã å°‘ãªã„ã®ã§ã‚ã‚‹ã€‚ï¼ˆå‹•çš„ã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã®ã¯MySQL Clusterãã‚‰ã„ã ã€‚ã—ã‹ã‚‚è¿½åŠ ã ã‘ã€‚ï¼‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§åˆ©ç”¨å‡ºæ¥ã‚‹MyISAMã¯Inn
kopug 2011/10/19
mysql

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

é‹ç”¨
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒä¸Šã§å‹•ã„ã¦ã‚‹ã©ã®phpãŒé‡ã„ã‹ï¼Ÿã‚’èª¿ã¹ã‚‰ã‚Œã‚‹ã€Œphptopã€:phpspoté–‹ç™ºæ—¥èªŒ
ã‚µãƒ¼ãƒä¸Šã§å‹•ã„ã¦ã‚‹ã©ã®phpãŒé‡ã„ã‹ï¼Ÿã‚’èª¿ã¹ã‚‰ã‚Œã‚‹ã€ŒPhp Topã€ã€‚ ã€Œã‚µãƒ¼ãƒç›£è¦–ã«è¶…ä½¿ãˆã‚‹ã€œtopã‚³ãƒžãƒ³ãƒ‰ã®ã¾ã¨ã‚ã€ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã§æ§˜ã€…ãªtopã‚³ãƒžãƒ³ãƒ‰ã‚’ç´¹ä»‹ã—ãŸã®ã§ã™ãŒã€php topãªã‚‹ã‚‚ã®ã‚’æ–°ãŸã«ç™ºè¦‹ã—ãŸã®ã§ã”ç´¹ä»‹ã€‚ å…·ä½“çš„ã«å‡ºæ¥ã‚‹ã“ã¨ã¯ã€ä»Šã‚µãƒ¼ãƒã§å‹•ã„ã¦ã„ã‚‹ã‚‚ã®ã‚’æŒ‡å®šã—ãŸæœŸé–“ã§ã€ã‚‚ã£ã¨ã‚‚ã‚¢ã‚¯ã‚»ã‚¹ãŒå¤šã„phpã€CPUã‚’å¤šãæ¶ˆè²»ã—ã¦ã„ã‚‹phpã€ãƒ¡ãƒ¢ãƒªã‚’å¤šãä½¿ã£ã¦ã„ã‚‹phpã¨ã„ã£ãŸã‚‚ã®ã‚’é™é †ã«ã‚½ãƒ¼ãƒˆã§ãã‚‹ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚ ã‚µãƒ¼ãƒä¸Šã§å¤šãã®phpãŒå‹•ã„ã¦ãŠã‚Šã€ã©ã†ã‚‚è² è·ãŒé«˜ã„ã‘ã©ã©ã‚ŒãŒé‡ã„ã®ã‹ã‚ˆãã‚ã‹ã‚‰ãªã„ã¨ã„ã†å ´åˆã«ä½¿ãˆã¾ã™ã€‚ top ã‚³ãƒžãƒ³ãƒ‰ã§ã¯ httpd ãŒå‹•ã„ã¦ã‚‹ãã‚‰ã„ã—ã‹åˆ†ã‹ã‚‰ãªã„ã®ã§ phper ãªæ–¹ã§è² è·ã«ãŠæ‚©ã¿ã®æ–¹ã¯ä½¿ã£ã¦ã¿ã‚‹ã®ã‚‚ã‚ˆã„ã‹ã‚‚ã€‚ ãŸã¨ãˆã°ã€ $ php top -t 15 -s mem ã®ã‚ˆã†ã«å®Ÿè¡Œã™ã‚‹ã¨ã€15åˆ†ä»¥å†…ã§ã€ãƒ¡ãƒ¢ãƒªã‚’å¤šãä½¿ã£ã¦ã„ã‚‹é †ã«ã‚½ãƒ¼ãƒˆãŒå¯èƒ½ã€‚
kopug 2010/12/16
PHP

ç›£è¦–

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: PHPã§æš—å·åŒ–ãƒ»å¾©å·åŒ–ã‚ã‚Œã“ã‚Œ
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
kopug 2010/03/13
linux

ssh

tips
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: InnoDBã§COUNT()ã‚’æ‰±ã†éš›ã®æ³¨æ„äº‹é …ã‚ã‚Œã“ã‚Œã€‚
InnoDBã‚’ä½¿ã†ã¨ãã€MyISAMã¨æ¯”è¼ƒã—ã¦åº¦ã€…ã‚„ã‚ŠçŽ‰ã«æŒ™ã’ã‚‰ã‚Œã‚‹ãƒã‚¤ãƒ³ãƒˆã¨ã—ã¦ã€ŒCOUNT()ãŒé…ã„ã€ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚ç¢ºã‹ã«InnoDBã«ãŠã„ã¦è¡Œæ•°ã‚’å¼¾ãå‡ºã™ã®ã«ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ£ãƒ³ãŒå¿…è¦ãªã®ã ãŒã€ãã‚‚ãã‚‚MyISAMã®COUNT()ãŒé€Ÿã„ï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ã®è¡Œæ•°ã‚’ä¿æŒã—ã¦ã‚‹ï¼‰ã®ãŒç‰¹æ®Šãªã®ã§ã‚ã£ã¦ã€InnoDBãŒé…ã„ã‚ã‘ã§ã¯ãªã„ã®ã§ã‚ã‚‹ã€‚ã¨ã¯ã„ãˆã€é«˜é€ŸãªCOUNT()ã«ã¤ã„ã¦ã¯éœ€è¦ãŒå¤šãã€ã“ã®å•é¡Œã«ã¯å¤šãã®äººå–ã‚Šçµ„ã‚“ã§ãŠã‚‰ã‚Œã‚‹ã‚ˆã†ã ã€‚ã—ã‹ã—ãªãŒã‚‰ã€COUNT()ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã¯æœªã èªžã‚‰ã‚Œã¦ã„ãªã„ç‚¹ãŒã‚ã‚‹ã‚ˆã†ã«è¦‹å—ã‘ã‚‰ã‚Œã‚‹ã®ã§ã€ä»Šæ—¥ã¯COUNT()ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦è§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€‚ COUNT(*)ã€COUNT(col)ã€COUNT(1)ã®é•ã„åŸºæœ¬çš„ãªã“ã¨ã§ã¯ã‚ã‚‹ãŒã€COUNT(*)ã¨COUNT(col)ã§ã¯æ„å‘³ãŒç•°ãªã‚‹ãŸã‚ã€ç•°ãªã‚‹çµæžœãŒè¿”ã•ã‚Œã‚‹å ´åˆãŒã‚ã‚‹ã€‚COUNT(*)ã¯ãƒ•ã‚§ãƒƒ
kopug 2010/03/10
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLã®EXPLAINã‚’å¾¹åº•è§£èª¬!!
ä»¥å‰ã€MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•ã¨ã„ã†æŠ•ç¨¿ã§ã€ŒEXPLAINã®è¦‹æ–¹ã«ã¤ã„ã¦ã¯ã„ãšã‚Œè§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€ã¨æ›¸ã„ã¦ã—ã¾ã£ãŸã®ã§ã€ä»Šæ—¥ã¯ãã®å…¬ç´„ï¼Ÿã‚’æžœãŸãã†ã¨æ€ã†ã€‚ MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§æœ€ã‚‚å¤§åˆ‡ãªã®ã¯ã€ã‚¯ã‚¨ãƒªã¨ã‚¹ã‚ãƒ¼ãƒžã®æœ€é©åŒ–ã§ã‚ã‚‹ã€‚ã‚¹ã‚ãƒ¼ãƒžã®è¨è¨ˆã¯ä¸€åº¦æ±ºã‚ã¦ã—ã¾ã†ã¨ãã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹å…¨ã¦ã®ã‚¯ã‚¨ãƒªã«å½±éŸ¿ã—ã¦ã—ã¾ã†ãŸã‚ãªã‹ãªã‹å¤‰æ›´ã™ã‚‹ã“ã¨ã¯å‡ºæ¥ãªã„ãŒã€ã‚¯ã‚¨ãƒªã¯ãã®ã‚¯ã‚¨ãƒªã ã‘ã‚’æ›¸ãç›´ã›ã°è‰¯ã„ã®ã§å¤‰æ›´ã®æ•·å±…ã¯ä½Žã„ã€‚ãã—ã¦é…ã„ã‚¯ã‚¨ãƒªã‚’ãªãã™ã“ã¨ã¯ã€æ€§èƒ½ã‚’å¤§å¹…ã«å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®æœ€ã‚‚æœ‰åŠ¹ãªæ‰‹æ®µã§ã‚ã‚‹ã€‚å¾“ã£ã¦ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ€§èƒ½ã‚’å‘ä¸Šã•ã›ãŸã„ãªã‚‰ã€ã¾ãšæœ€åˆã«ã‚¯ã‚¨ãƒªã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’æ¤œè¨Žã™ã‚‹ã¹ããªã®ã§ã‚ã‚‹ã€‚ æœ€é©åŒ–ã™ã‚‹ã¹ãã‚¯ã‚¨ãƒªã¯ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã‚„ã‚¯ã‚¨ãƒªã‚¢ãƒŠãƒ©ã‚¤ã‚¶ã§è¦‹ä»˜ã‘ã‚‰ã‚Œã‚‹ãŒã€ã§ã¯ãã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªãŒè¦‹ã¤ã‹ã£ãŸå ´åˆã«ã¯ã©ã®ã‚ˆã†ã«æœ€é©åŒ–ã™ã‚Œã°ã„ã„ã®ã‹ï¼Ÿãã®ãŸã‚ã«ã¯ã¾ãšç¾åœ¨ã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªãŒå®Ÿè¡Œã•
kopug 2009/08/30
MySQL

howto

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
1