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

ayakohiroe id:ayakohiroe

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

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

Webãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°80é¸ - Qiita
ã“ã‚“ã«ã¡ã¯ã€ã¬ã“ã™ã‘ã§ã™ã€‚ è¿‘å¹´ã€Webãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã§ã¯ã‚µã‚¤ãƒˆã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®é‡è¦æ€§ãŒé«˜ã¾ã£ã¦ã„ã¾ã™ã€‚ ä¾‹ãˆã°ã€Googleã¯Core Web Vitalã¨ã„ã†ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«æŒ‡æ¨™ã‚’æ¤œç´¢çµæžœã®ãƒ©ãƒ³ã‚ãƒ³ã‚°è¦å› ã«çµ„ã¿è¾¼ã¿ã¾ã—ãŸã€‚ ã¾ãŸã€è¿‘å¹´ã®æŸä¼æ¥ãŒã€Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®æ”¹å–„ã«å–ã‚Šçµ„ã‚“ã çµæžœã€ã‚»ãƒƒã‚·ãƒ§ãƒ³æ•°ã€‡ï¼…ã‚¢ãƒƒãƒ—ã€CVRã€‡ï¼…ã‚¢ãƒƒãƒ—...ã€ãªã©ã®äº‹ä¾‹ã¯æžšæŒ™ã«ã„ã¨ã¾ãŒãªã„ã§ã—ã‚‡ã†ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ãŸã‚ã«ã¯ã€å®šé‡çš„ã«è¨ˆæ¸¬ã—ã¦ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’æŽ¢ã™ã‚ˆã†ãªãƒˆãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãªã‚¢ãƒ—ãƒãƒ¼ãƒã‚‚ã‚ã‚Šã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€æ™‚ã«ã¯åƒæœ¬ãƒŽãƒƒã‚¯çš„ã«ãƒã‚¦ãƒ„ãƒ¼ã‚’ç‰‡ã£ç«¯ã‹ã‚‰è©¦ã—ã¦ã„ããƒœãƒˆãƒ ã‚¢ãƒƒãƒ—ãªã‚¢ãƒ—ãƒãƒ¼ãƒã‚‚æœ‰åŠ¹ã«ãªã‚‹ã“ã¨ã‚‚ã‚ã£ãŸã‚Šã€æ—¥ã€…ã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ„è˜ã—ãŸã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãã“ã¨ã¯å¤§åˆ‡ã§ã—ã‚‡ã†ã€‚ ã“ã®è¨˜äº‹ã§ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æœ€é©åŒ–ã®ãƒã‚¦ãƒ„ãƒ¼ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ”¹å–„ã®æ–½ç–ãŒæ€ã„æµ®ã‹ã°ãªã„æ™‚ã‚„ãƒ•ãƒãƒ³
ayakohiroe 2022/02/16
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

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

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

web

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

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

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

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

SQL

database
ãƒªãƒ³ã‚¯
KOSHIGOEå¦ç¿’å¸³ - [MySQL] ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹é–¢é€£ãƒ¡ãƒ¢
{{toc_here}} InnoDB ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° MySQL :: MySQL 5.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 13.5.11 InnoDB ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ãƒ’ãƒ³ãƒˆ MySQL :: MySQL 5.1 Reference Manual :: 13.6.13.1 InnoDB Performance Tuning Tips é•·éŽãŽã‚‹ PRIMARY KEY ã‚’é¿ã‘ã¦ãƒ‡ã‚£ã‚¹ã‚¯é ˜åŸŸã®ç„¡é§„é£ã„ã‚’é¿ã‘ã‚‹ ã‚»ã‚«ãƒ³ãƒ€ãƒªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ç”¨ã«ä½™è¨ˆãªé ˜åŸŸã‚’ä½¿ã‚ãªã„ã‚ˆã†ã€é•·ã„ä¸»ã‚ãƒ¼ã‚’é¿ã‘ã‚‹ ä¸»ã‚ãƒ¼ãŒé•·ã„å ´åˆã€ä»£ã‚ã‚Šã« AUTO_INCREMENT ãªã‚«ãƒ©ãƒ ã‚’ä¸»ã‚ãƒ¼ã¨ã—ã¦ä½œæˆã™ã‚‹ã¨ã‚ˆã„ è£œè¶³ MySQL :: MySQL 5.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 13.5.13 InnoDB ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ§‹é€ MySQL :: MySQL 5.1 Reference Ma
ayakohiroe 2016/02/08
mysql

linux

tips

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

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

DB
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 13.7.7.29 SHOW PROCESSLIST ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ
SAVEPOINTã€ROLLBACK TO SAVEPOINT ãŠã‚ˆã³ RELEASE SAVEPOINT ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ
ayakohiroe 2013/08/08
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQL innodb_flush_method = O_DIRECTã®æ¤œè¨Ž - SH2ã®æ—¥è¨˜
MySQL InnoDBã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã§innodb_flush_methodã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¯UNIX/Linuxã«ãŠã„ã¦ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã€ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®èªã¿æ›¸ãæ–¹å¼ã‚’æŒ‡å®šã™ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã€ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã®13.6.3. InnoDB Startup Options and System Variablesã«ã‚ˆã‚‹ã¨ä»¥ä¸‹ã®3ç¨®é¡žã®è¨å®šãŒå¯èƒ½ã¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ ç„¡æŒ‡å®š(fdatasync)ï¼šãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®è¨å®šã§ã™ã€‚ç‰¹åˆ¥ãªãƒ•ãƒ©ã‚°ãªã—ã§ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã—ã€æ›¸ãè¾¼ã¿æ™‚ã«fsync()ã‚’è¡Œã„ã¾ã™ã€‚ O_DSYNCï¼šãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦ã¯fdatasyncã¨åŒã˜ã§ã™ã€‚ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦O_SYNCãƒ•ãƒ©ã‚°ã‚’ã¤ã‘ã¦ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã—ã¾ã™ã€‚ O_DIRECTï¼šãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦O_DIRECTãƒ•ãƒ©ã‚°ã‚’ã¤ã‘ã¦ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã—ã¾ã™ã€‚ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦ã¯fdatasyncã¨åŒã˜ã§ã™ã€‚ ä»Šå›žã¯ã“ã®ãƒ‘
ayakohiroe 2013/08/01
mysql

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