[B! tuning] larkerã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

larker id:larker

tuningã«é–¢ã™ã‚‹larkerã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

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

1æ–‡å—ã§SQLã‚’200å€é…ãã™ã‚‹æ–¹æ³•
ã“ã‚“ã«ã¡ã¯ã€19ã®SysAdçã®ç¿ (sappi_red)ã§ã™ã€‚æ™®æ®µã¯traQã®ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã®ä¿å®ˆã‚’è¡Œã£ãŸã‚Šã—ã¦ã„ã¾ã™ã€‚ ã“ã‚“ã°ã‚“ã¯ã€19ã®SysAdçã®temmaã§ã™ã€‚æ™®æ®µã¯æ™®æ®µã©ãŠã‚Šã®ã“ã¨ã‚’ã—ã¦ã„ã¾ã™ã€‚ã“ã®è¨˜äº‹ã®é¢ç™½ã„éƒ¨åˆ†ã¯ã™ã¹ã¦åƒ•ãŒæ›¸ã„ã¦ã„ã¾ã™ã€‚é¢ç™½ããªã„ã¨ã“ã‚ã¯ç¿ å›ãŒæ›¸ã„ã¦ã„ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€æ—¥ã€…ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é ã‚’æ‚©ã¾ã›ã‚‹é–‹ç™ºè€…ã®æ–¹ã®ãŸã‚ã«ã€ãƒ¯ãƒ³ã‚¿ãƒƒãƒã§åŠ‡é…SQLã‚’200å€é«˜é€Ÿã§ã‚ãƒ¥ãƒ¼ãƒˆãªSQLã«åŠ‡çš„ãƒ“ãƒ•ã‚©ãƒ¼ã‚¢ãƒ•ã‚¿ãƒ¼ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã€ŒãŠã„ãŠã„ãŠã„ã€é…ãã—ãŸãã¦è¨˜äº‹ã‚’èªã¿å§‹ã‚ãŸã®ã«è©±ãŒé•ã†ã˜ã‚ƒãªã„ã‹ðŸ’¢ã€ã¨æ€ã£ã¦ã‚‹ãã“ã®ã‚ãªãŸðŸ‘ˆ æ—©ãã§ãã‚‹ã¨ã„ã†ã“ã¨ã¯é…ãã‚‚ã§ãã‚‹ã‚“ã§ã™ãã€‚ TL;DR ã“ã“ã«ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚Šã¾ã™ã€‚ CREATE TABLE messages ( id CHAR(36) NOT NULLã€€PRIMARY KEY, text TEXT COLLATE ut
larker 2022/05/17
db

SQL

MariaDB

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

SQL

tuning
ãƒªãƒ³ã‚¯
èµ·å‹•ãŒé…ã„åŽŸå› ã¯ï¼Ÿãã‚“ãªæ™‚ã¯systemd-analyzeã§ãƒã‚§ãƒƒã‚¯
# systemd-analyze Startup finished in 666ms (kernel) + 2.171s (initrd) + 4.705s (userspace) = 7.542s kernel, initrd, userspace ãã‚Œãžã‚Œã®åˆè¨ˆæ™‚é–“ã‚’ã ã—ã¦ãã‚Œã‚‹ã€‚ ã‚ˆã‚Šè©³ç´°ã‚’çŸ¥ã‚ŠãŸã„å ´åˆã¯ã€blame ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä½¿ã†ã€‚systemd-analyze blame ã®å®Ÿè¡Œçµæžœ # systemd-analyze blame 1.120s firewalld.service 1.032s network.service 987ms boot.mount 712ms tuned.service 574ms vboxadd.service 458ms vboxadd-x11.service 320ms systemd-vconsole-setup.service 293ms
larker 2016/04/06
Linux

systemd

tuning
ãƒªãƒ³ã‚¯
MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãŸã‚ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ - ä¹…ä¿æ¸…éš†ã®ãƒ–ãƒã‚°
ä»•äº‹ã§MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ã„ã¦ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åˆ†ã‹ã£ã¦ã„ãªã„ã“ã¨ãŒå¤šã‹ã£ãŸã®ã§èª¿ã¹ãŸã“ã¨ã‚’ãƒ¡ãƒ¢ã€‚åŸºæœ¬çš„ãªã¨ã“ã‚ã‹ã‚‰å¦ç¿’ã—ãªãŠã—ãŸã€‚ MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã€ã‚«ãƒ©ãƒ ãŒç‰¹å®šã®å€¤ã‚’ã‚‚ã¤ãƒ¬ã‚³ãƒ¼ãƒ‰ã®è¿…é€Ÿãªæ¤œç´¢ã«ä½¿ç”¨ã•ã‚Œã‚‹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã™ã‚Œã°ã€æ•°ç™¾ã¨ã‹æ•°å„„ã‚‚ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå…¥ã£ã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ã€ä¸€çµ„ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿…é€Ÿã«è¦‹ã¤ã‘ã¦å–ã‚Šå‡ºã™ã“ã¨ãŒå¯èƒ½ã«ãªã‚‹ã€‚ ã—ã‹ã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯é€Ÿåº¦ã‚’æ”¹å–„ã™ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ãŒã€æŒ¿å…¥ã®é‚ªé”ã«ãªã£ã¦é…ããªã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é©åˆ‡ã«ä½¿ã†ãŸã‚ã«ã€ã¾ãšã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºæœ¬æ¦‚å¿µã‚’ãŠã•ãˆã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ¦‚å¿µ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä»•çµ„ã¿ã‚’ç†è§£ã™ã‚‹ã«ã¯ã€ã¾ãšMySQLãŒã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªã«å¿œç”ã™ã‚‹ã‹ã‚’çŸ¥ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ä¾‹ãˆã°ã€ SELECT * FROM phone_book WHERE last_name = 'Hoge'
larker 2015/06/10
MySQL

tuning
ãƒªãƒ³ã‚¯
Linux OS Tuningé–¢é€£ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
2008/03/14 2019/12/23 ã‚¿ã‚°: Kernel, Linux, Performance, Tuning Linux OS Tuning ãƒãƒƒãƒ—ã‚¹(è¨˜äº‹ãŒå¤ã„ã®ã§ç¾çŠ¶ã®Linuxã‚«ãƒ¼ãƒãƒ«ã¨å·®ç•°ãŒã‚ã‚Šã¾ã™) å·¨å¤§ãªã‚·ã‚¹ãƒ†ãƒ ã€ã‚ã‚‹ã„ã¯äººæ°—ã®ã‚ã‚‹ã‚µã‚¤ãƒˆã‚’é‹å–¶ã™ã‚‹ã‚µãƒ¼ãƒç®¡ç†è€…ã®å¤šãã¯ã€Linuxä¸Šã§ç¨¼å‹•ã™ã‚‹æ§˜ã€…ãªã‚µãƒ¼ãƒã‚’é«˜é€Ÿã«ã‹ã¤ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’æ‹¡å¼µã™ã‚‹ãŸã‚ã«ã€ã‚µãƒ¼ãƒã®è¨å®šãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã‚ã‚‹ã€Œæœ€å¤§åŒæ™‚æŽ¥ç¶šæ•°ã€ã¨ã„ã†é¡žã®æ„å‘³ã«è¿‘ã„ã€Œã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã€ã‚’æŽ¢ã™ã“ã¨ã§ã—ã‚‡ã†ã€‚ ã—ã‹ã—ã€å®Ÿã¯ã“ã®è¨å®šå€¤ã‚’è¦‹ã¤ã‘ã¦ã€å€¤ã‚’å¤§ããã—ãŸæ‰€ã§å¿…ãšã—ã‚‚ã‚µãƒ¼ãƒã®å‡¦ç†èƒ½åŠ›ã¯å‘ä¸Šã—ã¾ã›ã‚“ã€‚ã•ã¦ã€ã“ã‚Œã¯ä½•æ•…ã§ã—ã‚‡ã†ã‹ï¼Ÿã€‚ã‚µãƒ¼ãƒã¯ã‚ãã¾ã§ã‚‚Linuxã®OSä¸Šã§å‹•ã„ã¦ã„ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã®ã²ã¨ã¤ã«éŽãŽã¾ã›ã‚“ã€‚ç”ãˆã¯ãƒ—ãƒã‚°ãƒ©ãƒ ã®ãƒªã‚½ãƒ¼ã‚¹åˆ¶é™ã‚’åˆ¶å¾¡ã™ã‚‹ã®ã¯ã‚„ã¯ã‚ŠOSã®ãƒªã‚½ãƒ¼ã‚¹ã«é–¢ã‚ã‚‹ã‚«ãƒ¼ãƒãƒ«è¨å®šã«é–¢ä¿‚ã—ã¦ãã¾ã™ã€‚ ãŸã¨ãˆã°é€ä¿¡å¯èƒ½ãª
larker 2014/03/13
Linux

OS

tuning
ãƒªãƒ³ã‚¯
MySQL 5.6 ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿æ¤œè¨Žä¼š - SH2ã®æ—¥è¨˜
7æœˆ29æ—¥ã«MyNA(æ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ä¼š)ä¼š 2013å¹´7æœˆãŒè¡Œã‚ã‚Œã€Oracle ACE Directorã®@sheeriã•ã‚“ã€MyNAä¼šé•·ã®@tmtmsã•ã‚“ã«æ··ã–ã£ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚é‹å–¶ã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã„ã¤ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ Performance Schema - Sheeri Cabral (PDF) MyNAä¼š2013å¹´7æœˆ ã«è¡Œã£ã¦æ¥ã¾ã—ãŸ - MySQLã®ãƒ—ãƒãƒˆã‚³ãƒ«è§£èª¬ - @tmtms ã®ãƒ¡ãƒ¢ ä»Šå›žã¯@yoku0825ã•ã‚“ã€@yyamasaki1ã•ã‚“ãŒãƒ©ã‚¤ãƒˆãƒ‹ãƒ³ã‚°ãƒˆãƒ¼ã‚¯ã‚’ã•ã‚Œã¾ã—ãŸã€‚@yoku0825ã•ã‚“ã‚¢ã‚¤ã‚¹ã”ã¡ãã†ã•ã¾ã§ã—ãŸã€‚ æ—¥ã€…ã®è¦šæ›¸: MyNAä¼š2013å¹´7æœˆã«è¡Œã£ã¦ãã¾ã—ãŸ 5åˆ†ã§ä½œã‚‹MySQL Clusterç’°å¢ƒ ç§ã¯ç™ºè¡¨å†…å®¹ã«ã¤ã„ã¦æ‡‡è¦ªä¼šã§ã„ã‚ã„ã‚å®¿é¡Œã‚’ã‚‚ã‚‰ã£ã¦ã—ã¾ã„ã€ã—ã°ã‚‰ãå¾©ç¿’ã‚’ã—ã¦ã„ã¾ã—ãŸã€‚ã‚ˆã†ã‚„ãä¿®æ£ãŒçµ‚ã‚ã‚Šã¾
larker 2013/08/06
ã‚³ãƒ³ãƒ•ã‚£ã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã®èª¬æ˜Ž

MySQL

tuning

è§£èª¬
ãƒªãƒ³ã‚¯
å¤§ãã‚ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚«ãƒ©ãƒ ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è¿½åŠ ã™ã‚‹éš›ã®æ³¨æ„ - LukeSilviaâ€™s diary
å…ˆæ—¥å¤§ãã‚(ã¨ã„ã£ã¦ã‚‚500ä¸‡è¡Œãã‚‰ã„)ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ä»˜ãã®ã‚«ãƒ©ãƒ ã‚’è¿½åŠ ã—ã‚ˆã†ã¨ã—ã¦ç—›ã„ç›®ã«ã‚ã£ãŸã®ã§èª¿æŸ»ã€‚ å¤§ãã‚ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚«ãƒ©ãƒ ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è¿½åŠ ã™ã‚‹ã¨ã©ã†ãªã‚‹ã‹ ä»Šå›žã¯å˜ç´”ã«ã€ã€ŒALTER TABLE ã€œ ã€ã§è¿½åŠ ã—ã‚ˆã†ã¨ã—ã¾ã—ãŸã€‚è¿½åŠ ã™ã‚‹ã‚«ãƒ©ãƒ ã¯3ã¤ã§ã€ varchar(255) ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã— varchar(255) â†“ã®date åž‹ã‚«ãƒ©ãƒ ã¨ãƒžãƒ«ãƒã‚«ãƒ©ãƒ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å½¢å¼ã®ãƒ¦ãƒ‹ãƒ¼ã‚¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚ã‚Š date ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚ã‚Š SQL ã‚’å®Ÿè¡Œã—ã€çŠ¶æ³ã‚’ã€ŒSHOW PROCESSLISTã€ã§ç›£è¦–ã—ã¦ã„ãŸã‚‰ã€1ã¤ç›®ã®ã‚«ãƒ©ãƒ è¿½åŠ ã§æ¬¡ã®ã‚ˆã†ãªçŠ¶æ…‹ã«â€¦ æœ€åˆã«State ãŒã€Œcopy to tmp tableã€çŠ¶æ…‹ã«ãªã‚Šã€æ¬¡ã®çŠ¶æ…‹ã«é·ç§»ã™ã‚‹ã¾ã§1æ™‚é–“ã‹ã‹ã‚‹ æ¬¡ã«State ãŒã€ŒRepair with keycacheã€çŠ¶æ…‹ã«ãªã‚Šã€å®Œäº†ã¾ã§ã«1æ™‚é–“ã‹ã‹ã‚‹ æ¬¡ã®ã‚«ãƒ©ãƒ è¿½åŠ ã«å¯¾ã™
larker 2010/09/29
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ç”¨ã‚ãƒ¼ãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã®èª¿æ•´ã«ã¤ã„ã¦

MySQL

tuning

æ¤œç´¢

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
mysqlsnifferã§MySQLã®ãƒ—ãƒãƒˆã‚³ãƒ«ã‚’ã‚ãƒ£ãƒ—ãƒãƒ£ãƒªãƒ³ã‚°
MySQLã§æŽ¥ç¶šé–¢ä¿‚ã®å•é¡Œã€å…·ä½“çš„ã«è¨€ã†ã¨Aborted_clientsã‚„Aborted_connectionsã¨ã„ã†ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹å¤‰æ•°ãŒå¢—ãˆç¶šã‘ã¦ã—ã¾ã†ã‚ˆã†ãªç¾è±¡ã«éé‡ã™ã‚‹ã“ã¨ãŒã‚ã‚‹ã€‚MySQLã¯ã€ãã†ã„ã£ãŸãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯é–¢ä¿‚ã®å•é¡Œã‚’ã‚ã¾ã‚ŠãŸãã•ã‚“ãƒã‚°ã«è¨˜éŒ²ã—ãªã„ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã€‚DoSæ”»æ’ƒãªã©ã§ãƒã‚°ãŒæº¢ã‚Œã‹ãˆã£ã¦ã—ã¾ã‚ãªã„ã‚ˆã†ã«ã™ã‚‹ãŸã‚ã ã€‚ãã‚“ãªã¨ãã€è©¦ã—ã¦é ‚ããŸã„ã®ãŒmysqlsnifferã€‚ mysqlsnifferã¨ã¯ã€‚http://hackmysql.com/mysqlsniffer mysqlsnifferã¯ã€tcpdumpã®ã‚ˆã†ã«ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã‹ã‚‰ãƒ‘ã‚±ãƒƒãƒˆã‚’ã‚ãƒ£ãƒ—ãƒãƒ£ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã ãŒã€tcpdumpã¨ã¯MySQLã®ãƒ—ãƒãƒˆã‚³ãƒ«ã‚’ç†è§£ã™ã‚‹ã¨ã„ã†ç‚¹ã§ç•°ãªã‚‹ã€‚ã¨ã„ã†ã‹MySQLã®ãƒ—ãƒãƒˆã‚³ãƒ«å°‚é–€ã®ã‚ãƒ£ãƒ—ãƒãƒ£ãƒ—ãƒã‚°ãƒ©ãƒ ã ã€‚OSã®rootæ¨©é™ã•ãˆã‚ã‚Œã°ã€MySQLã‚µãƒ¼ãƒãƒ¼ã«å¯¾ã—
larker 2010/04/23
MySQL

è§£æž

tuning

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

tuning

tips
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
larker 2009/09/04
apache

Linux

tuning
ãƒªãƒ³ã‚¯
1