[B! MySQL] michael-unltdã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

michael-unltd id:michael-unltd

MySQLã«é–¢ã™ã‚‹michael-unltdã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (78)

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

ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã«UUID v7/ULIDã‚’ä½¿ã†ã‹å•é¡Œã«ã¤ã„ã¦
MySQLã§UUID(v4)ã‚’ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã«ã—ã¦ã¯ã„ã‘ãªã„ç†ç”±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆã§ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã‚’ã©ã†ã™ã‚‹ã‹ã¯ã€æœ€åˆã«æ‚©ã‚€ã¨ã“ã‚ã§ã¯ãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚ç‰¹ã«ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžãƒ¼å‘ã‘ã®Webã‚µãƒ¼ãƒ“ã‚¹ã‚„ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã®B2Bã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹ç™ºã™ã‚‹ã¨ããªã©ã¯ç‰¹ã«æ°—ã‚’ã¤ã‹ã„ã¾ã™ã‚ˆãã€‚ ä½•ã‚‚è€ƒãˆãšã«Auto incrementï¼ˆè‡ªå‹•æŽ¡ç•ªï¼‰åž‹ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã‚’ä»˜ã‘ã¦ã€ã€Œ/users/1ã€ã€Œ/users/2ã€ã€Œ/users/3ã€ã¿ãŸã„ãªIDä»˜ãã®URLã§ã‚¢ã‚¯ã‚»ã‚¹ã•ã›ã¦ã—ã¾ã†ã¨ã€æ¬¡ã®ã‚ˆã†ãªå•é¡ŒãŒç”Ÿã˜ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ URLã«ä½¿ã‚ã‚Œã¦ã„ã‚‹IDã®å¤§ãã•ã‚„å¢—åŠ æ•°ã‹ã‚‰ã€ã‚·ã‚¹ãƒ†ãƒ ã®è¦æ¨¡æ„Ÿã‚„åˆ©ç”¨çŠ¶æ³ãŒåˆ†ã‹ã£ã¦ã—ã¾ã†ã€‚IDã‚’æ©Ÿæ¢°çš„ã«å¤‰ãˆã¦ç·å½“ãŸã‚Šçš„ã«æƒ…å ±ã‚’å–å¾—ã§ãã¦ã—ã¾ã†ã€‚ã¾ãŸã€åˆ†æ•£ã—ãŸã‚·ã‚¹ãƒ†ãƒ ã§ã‚µãƒ–ã‚·ã‚¹ãƒ†ãƒ ã”ã¨ã«è¡çªã—ãªã„IDã‚’å‰²ã‚Šå½“ã¦ãŸã„ã“ã¨ãŒã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ãã‚“ãªã¨ãã«UUIDã‚’ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã«ã—ã¡ã‚ƒãˆã°ã„ã„ã‚“ã˜ã‚ƒã
michael-unltd 2025/01/04
*data

mysql

è¨è¨ˆ
ãƒªãƒ³ã‚¯
PlanetScaleã¨ã„ã†ã‚µãƒ¼ãƒãƒ¬ã‚¹DBãŒå‡„ãå‹¢ã„ã®ã‚ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã‚‰ã—ã„ã®ã§Quick Startã‚„ã£ã¦ã¿ãŸ - Qiita
PlanetScaleã¨ã„ã†ã‚µãƒ¼ãƒãƒ¬ã‚¹DBãŒå‡„ãå‹¢ã„ã®ã‚ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã¨èžã„ã¦ã€å…¬å¼ã«ã‚¯ã‚¤ãƒƒã‚¯ã‚¹ã‚¿ãƒ¼ãƒˆãŒã‚ã£ãŸã®ã§ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ ç’°å¢ƒ PC: MacBook Pro (Intel Core 2016) OS: macOS Montery12.2.1 ã§ã¯æ¦‚è¦ã‹ã‚‰ç¢ºèªã—ã¦ã„ãã¾ã™ã€‚ ã‚µãƒ¼ãƒãƒ¼ãƒ¬ã‚¹DBã¨ã¯ ã‚µãƒ¼ãƒãŒãªã„ã€ã®ã§ã¯ãªãã€ã‚µãƒ¼ãƒç®¡ç†ã‚„æ¤œè¨ŽãŒä¸è¦ AWS Lambda(NoSQL)ãªã© PlanetScaleã¨ã¯ PlanetScaleå¹´è¡¨ 2010å¹´é ƒ YouTubeãŒæ€¥æ¿€ã«æˆé•·ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒçˆ†ç™ºã—ãã†ã«ãªã£ã¦ã„ãŸã®ã§ã€Suguæ°ã¨ã‚‚ã†ä¸€äººã®YouTubeã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã€ŒVitess.ioã€ï¼ˆãƒ´ã‚£ãƒ†ã‚¹ï¼‰ã‚’ç«‹ã¡ä¸Šã’ã‚‹ 2016å¹´é ƒ MySQLã§ãƒã‚¤ãƒŠãƒªãƒ—ãƒãƒˆã‚³ãƒ«ã‚’æ‰±ãˆã‚‹ã‚ˆã†ã«ã—ãŸã“ã¨ã§ã€Vitessã¯YouTubeä»¥å¤–ã®ä¼æ¥ã«ã¨ã£ã¦ã‚‚é…åŠ›çš„ãªã‚·ã‚¹ãƒ†ãƒ ã«ãªã‚Š
michael-unltd 2022/08/07
â€œMySQL8ã‚’é€Ÿãã¦ç°¡å˜ã«ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ã«åˆ©ç”¨ã§ãã‚‹ã‚µãƒ¼ãƒ“ã‚¹ YouTubeã‚„Slackãªã©ã§ã‚‚åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹Vitessï¼ˆãƒ´ã‚£ãƒ†ã‚¹ï¼‰ã¨ã„ã†MySQLã®æ°´å¹³ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚°ã‚·ã‚¹ãƒ†ãƒ ã‚’åˆ©ç”¨ã—ã¦ãŠã‚Šã€ãƒŽãƒ³ãƒ–ãƒãƒƒã‚ãƒ³ã‚°ã§ã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã§ãã‚‹ ãƒ–ãƒ©ãƒ³ãƒæ©Ÿ

*database

serverless

mysql
ãƒªãƒ³ã‚¯
MySQL: Show processlist every second
michael-unltd 2019/12/03
å®šç‚¹ç›£è¦–

mysql
ãƒªãƒ³ã‚¯
MySQLã¨PostgreSQLã‚³ãƒžãƒ³ãƒ‰æ¯”è¼ƒè¡¨ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
michael-unltd 2019/11/27
mysql

postgresql

sql

*ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
Lightsailã§æ§‹ç¯‰ã—ãŸWordPressã®MySQLã«ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹å¤–ã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ | DevelopersIO
Lightsail ã®ãƒ–ãƒ«ãƒ¼ãƒ—ãƒªãƒ³ãƒˆã‹ã‚‰ Bitnami ã® WordPress ã‚’èµ·å‹•ã™ã‚‹ã¨ã€åŒã˜ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹å†…ã«ã€WordPress ã¨ MySQL ãŒå‹•ä½œã—ã¾ã™ã€‚ ã“ã® MySQL ã« VPC ãƒ”ã‚¢ãƒªãƒ³ã‚°ã—ãŸåˆ¥ VPC å†…ã® EC2 ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆ ã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ MySQL ã®å¤‰æ›´ Bitnami å¤–æä¾›ã™ã‚‹ãƒ–ãƒ«ãƒ¼ãƒ—ãƒªãƒ³ãƒˆã§ã¯ã€MySQL ã¯ãƒãƒ¼ã‚«ãƒ«ãƒ›ã‚¹ãƒˆã‹ã‚‰ã®æŽ¥ç¶šé£²ã¿å—ã‘ä»˜ã‘ã¦ã„ã¾ã™ã€‚ ã¾ãšã€ãƒãƒ¼ã‚«ãƒ«ãƒ›ã‚¹ãƒˆå¤–ã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã‚ˆã†ã«è¨å®šå¤‰æ›´ã—ã¾ã™ã€‚ MySQL ã®æŽ¥ç¶šãƒ¦ãƒ¼ã‚¶ãƒ¼ Bitnami ã®æä¾›ã™ã‚‹ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã§ã¯ã€root ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ MySQL ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¾ã™ã€‚ ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¯ bitnami ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒ›ãƒ¼ãƒ ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªç›´ä¸‹ã®ãƒ•ã‚¡ã‚¤ãƒ« $HOME/bitnami_application_password ã«ã‚ã‚Šã¾ã™ã€‚
michael-unltd 2019/10/15
Lightsailæ–¹å¼

wordpress

mysql
ãƒªãƒ³ã‚¯
ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ MySQL Memcachedãƒ—ãƒ©ã‚°ã‚¤ãƒ³ vs Memcached vs Redis | ã‚¹ãƒžãƒ¼ãƒˆã‚¹ã‚¿ã‚¤ãƒ« TECH BLOG
MySQL ã§ã¯ ã€ŒInnoDB Memcachedã€ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’ä½¿ã†ã“ã¨ã§ã€Memcached ãƒ—ãƒãƒˆã‚³ãƒ«ã‚’ä½¿ã£ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ã«ç›´æŽ¥ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ å‚è€ƒï¼šMySQL :: MySQL 5.7 Reference Manual :: 14.20 InnoDB memcached Plugin ä»Šå›žã¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚¹ãƒˆã‚¢ã¨ã—ã¦ã‚ˆãä½¿ã‚ã‚Œã‚‹ Redis ã¨ Memcached ã€ãã—ã¦MySQLã® InnoDB Memcached ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ã¨ã£ã¦æ¯”è¼ƒã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚
michael-unltd 2018/04/30
â€œMySQLã® InnoDB Memcached ãƒ—ãƒ©ã‚°ã‚¤ãƒ³â€

MySQL

Redis
ãƒªãƒ³ã‚¯
MySQL Community Server 5.7.19 - Installing on Windows 10 - Qiita
æ¦‚è¦ Windows10ã«é–‹ç™ºãƒ»æ¤œè¨¼ç”¨ã«MySQL Community Server 5.7.19ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã€åˆæ©çš„ãªè¨å®šã‚’è¡Œã†ã¾ã§ã®ä½œæ¥ãƒ¡ãƒ¢ã§ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ãƒ¼ç‰ˆã¯ä½¿ã‚ãšZIP Archiveç‰ˆã§æ‰‹å‹•ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ ç’°å¢ƒ Windows 10 Professional MySQL Community Server 5.7.19 (zip archive) å‚è€ƒ [MySQL 5.7 Reference Manual / 2.3.5 Installing MySQL on Microsoft Windows Using a noinstall Zip Archive] (https://dev.mysql.com/doc/refman/5.7/en/windows-install-archive.html) [MySQL 5.7 Reference Manual / 5.1.
michael-unltd 2018/04/30
install tips

Windows

MySQL
ãƒªãƒ³ã‚¯
Sequelize
SequelizeSequelize is a modern TypeScript and Node.js ORM for Oracle, Postgres, MySQL, MariaDB, SQLite and SQL Server, and more. Featuring solid transaction support, relations, eager and lazy loading, read replication and more.
michael-unltd 2018/04/28
node.js

orm

mysql

postgresql

sqlite
ãƒªãƒ³ã‚¯
MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ‰‹æ³•ã®é•ã„ | Yakst
ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒãƒ¼ãƒ ã«æ‰€å±žã™ã‚‹ç†è€…ãŒã€ä»Šã§ã¯æ§˜ã€…ãªæ‰‹æ³•ãŒå˜åœ¨ã™ã‚‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã«ã¤ã„ã¦ã€æ”¹ã‚ã¦ç‰¹å¾´ã‚„æ³¨æ„ç‚¹ã‚’è§£èª¬ã—ã¤ã¤ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚ˆãã‚ã‚‹ã€Œèª¤è§£ã€ã«å¯¾ã—ã¦ã‚‚ãŠç”ãˆã—ã¦ã„ã¾ã™ã€‚ ã“ã®ãƒ–ãƒã‚°è¨˜äº‹ã§ã¯ã€MySQLï¼ˆãŠã‚ˆã³ Percona Serverï¼‰ç’°å¢ƒã«ãŠã‘ã‚‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ‰‹æ³•ã«é–¢ã—ã¦æ”¹ã‚ã¦è€ƒå¯Ÿã‚’è¡Œã„ãŸã„ã¨æ€ã„ã¾ã™ã€‚ã‚ã‚ã›ã¦ã€æ™‚æŠ˜è¦‹å—ã‘ã‚‰ã‚Œã‚‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–“é•ã£ãŸè€ƒãˆæ–¹ã«ã¤ã„ã¦ã‚‚è€ƒãˆã¦ã¿ã¾ã™ã€‚ ç§ãŒã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦åƒãå§‹ã‚ã¦ã‹ã‚‰ã¨ã„ã†ã‚‚ã®ã€æ²¢å±±ã®æƒ…å ±ãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã«ã‚‚é–¢ã‚ã‚‰ãšã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å¯¾ã™ã‚‹ã€Œèª¤è§£ã€ã‚„ã€Œä¸å®Œå…¨ãªç†è§£ã€ãŒç„¡ããªã‚‰ãªã„ã“ã¨ã‚’æ—¥ã€…æ„Ÿã˜ã¦ã„ã¾ã—ãŸã€‚ ãã‚‚ãã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯ä½•ã‹ï¼Ÿ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€1ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ‡ãƒ¼ã‚¿ã‚’è“„ç©ã™ã‚‹ã ã‘ã§ãªãã€åˆ¥ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ‡ãƒ¼ã‚¿ã‚’è¤‡è£½ã—ã€è»¢é€ã™ã‚‹ã“ã¨ã‚’ä¿è¨¼ã—ã¦ãã‚Œã‚‹æ©Ÿèƒ½ã§ã™ ï¼ˆè¤‡è£½
michael-unltd 2017/03/20
mysql
ãƒªãƒ³ã‚¯
MySQLã®ãƒ¡ãƒ¢ãƒªè¨å®šã®å‹˜æ‰€ â€“ sawara.me
MySQLã‚µãƒ¼ãƒãƒ¼ã‚’ãƒ€ã‚¦ãƒ³ã•ã›ãŸå¤œã¯æ•°çŸ¥ã‚Œãšã€‚ ãã®åº¦ã«my.cnfã®è¨å®šã‚’è¦‹ãªãŠã—ã¦ã¿ã¦ã¯ãƒˆãƒ©ã‚¤ã—ã€æ²»ã£ãŸã¨æ€ã„ãã‚„çªç„¶ã®ãƒ€ã‚¦ãƒ³ã€‚ ã‚µãƒ¼ãƒãƒ¼ãŒãƒ€ã‚¦ãƒ³ã—ã¦ã—ã¾ã†åŽŸå› ã¯ä½•ã‹ã¨èžã‹ã‚Œã‚Œã°ã€ã€Œãƒ¡ãƒ¢ãƒªã§ã™ã€ã¨æ–è¨€ã—ã¾ã—ã‚‡ã†ã€‚ ãƒ¡ãƒ¢ãƒªè¨å®šã¯è«¸åˆƒã®å‰£ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æœ€å¤§ã«å¼•ãå‡ºã™ã“ã¨ã‚‚ã§ãã‚Œã°ãã‚Œã¨å¼•ãæ›ãˆã«ã‚µãƒ¼ãƒãƒ¼ã‚’ãƒ€ã‚¦ãƒ³ã•ã›ã¦ã—ã¾ã†ã“ã¨ã‚‚ã§ãã‚‹ã‚“ã§ã™ã€‚ ä»Šå›žã¯MySQLã®ãƒ¡ãƒ¢ãƒªã®è¨å®šã®å‹˜æ‰€ã¨ã„ã†ã‹ãŸã¡ã§ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã¨ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ãƒ¡ãƒ¢ãƒªã®è¨å®šã«ã¤ã„ã¦ã¾ãšã€Œã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã€ã¨ã€Œã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã€ã«ã¤ã„ã¦ç†è§£ã—ã¦ãŠãã“ã¨ãŒå¤§äº‹ã§ã™ã€‚ãƒãƒƒãƒ•ã‚¡ã¨ã¯ä¸€æ™‚çš„ãªè¨˜æ†¶é ˜åŸŸãƒ»ã¤ã¾ã‚Šã¯ãƒ¡ãƒ¢ãƒªã®é ˜åŸŸã®ã“ã¨ãªã®ã§ã™ãŒã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ MySQLã§ä½¿ç”¨ã™ã‚‹å…¨ä½“çš„ãªãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ã‚’è¨ˆç®—ã™ã‚‹ã«ã¯ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ + (ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ Ã— ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³æ•°) = ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ ã¨
michael-unltd 2017/03/19
mysql

performance
ãƒªãƒ³ã‚¯
MySQLã‚„SSDã¨ã‹ã®è©±ã€€å‰ç·¨
MySQLã‚„SSDã¨ã‹ã®è©±ã§ã™ å¾Œç·¨ã¯ã“ã¡ã‚‰ http://www.slideshare.net/takanorisejima/mysql ssd-56045479 å¾Œæ—¥è«‡ã¯ã“ã¡ã‚‰ http://www.slideshare.net/takanorisejima/mysql ssd-70162609
michael-unltd 2016/12/22
MySQL

performance

hardware
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.4 Reference Manual :: 17.17.3 InnoDB Standard Monitor and Lock Monitor Output
michael-unltd 2016/12/16
â€œSHOW ENGINE INNODB STATUSâ€ for lock trace

MySQL

performance
ãƒªãƒ³ã‚¯
ãŸã£ãŸ3ç§’ã§InnoDBã®ãƒ‡ãƒ¼ã‚¿ãƒãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãŒå¿«é©ã«ãªã‚‹ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯
MySQLã«é™ã£ãŸè©±ã§ã¯ãªã„ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã«å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’æŠ•å…¥ã™ã‚‹ã®ã¯æ™‚é–“ãŒæŽ›ã‹ã‚Šå¤§å¤‰è‹¦ç—›ã‚’ä¼´ã†ä½œæ¥ã§ã‚ã‚‹ã€‚åŠ‡çš„ã«åŠ¹èƒ½ãŒã‚ã‚‹ã‚ã‘ã§ã¯ãªã„ãŒã€MySQLã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã¨ãã€ç‰¹ã«InnoDBã‚’ä½¿ã£ã¦ã„ã‚‹å ´åˆã«ã¯ãƒ‡ãƒ¼ã‚¿ã®æŠ•å…¥ã‚’é«˜é€ŸåŒ–ã™ã‚‹ãŸã‚ã«ã„ãã¤ã‹ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ãŒã‚ã‚‹ã®ã§ç´¹ä»‹ã—ã‚ˆã†ã€‚çš†ã•ã‚“ã®ä½œæ¥æ™‚é–“ãŒçŸç¸®ã•ã‚Œã€å°‘ã—ã§ã‚‚æ—©ãå¸°è·¯ã«ç€ã„ãŸã‚Šã‚µãƒ¼ãƒ“ã‚¹ã‚¤ãƒ³ã•ã›ãŸã‚Šã¨ã„ã†å½¢ã§ãŠå½¹ã«ç«‹ã¦ã‚Œã°å¹¸ã„ã§ã‚ã‚‹ã€‚ã¡ãªã¿ã«ã€ã‚¿ã‚¤ãƒˆãƒ«ã¯ãƒã‚¿ã§ã‚ã‚‹ã®ã ãŒã€ã‚‚ã—æœ¬å½“ã«3ç§’ã§ä»¥ä¸‹ã®å…¨ã¦ã®è¨å®šã‚’è¡ŒãˆãŸäººãŒå±…ãŸã‚‰æ•™ãˆã¦é ‚ããŸã„ï¼ ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºã®èª¿æ•´ãƒ‡ãƒ¼ã‚¿æŠ•å…¥æ™‚ã«é™ã£ãŸè©±ã§ã¯ãªã„ãŒã€ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºã‚’èª¿æ•´ã™ã‚‹ã®ã¯æ›´æ–°æ€§èƒ½ã«ã¨ã£ã¦éžå¸¸ã«é‡è¦ãªãƒ•ã‚¡ã‚¯ã‚¿ãƒ¼ã§ã‚ã‚‹ã€‚ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã®ã‚µã‚¤ã‚ºãŒé‡è¦ãªã“ã¨ã«ä»£ã‚ã‚Šã¯ãªã„ãŒã€åŒã˜ãã‚‰ã„ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã‚‚é‡è¦ã§ã‚ã‚‹ã€‚InnoDBã¯ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã„åˆ‡ã£ã¦ã—ã¾ã†ã¨ã€ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«
michael-unltd 2016/12/15
'ãƒã‚°ãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã¯innodb_log_buffer_sizeã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§èª¿æ•´'

mysql

performance
ãƒªãƒ³ã‚¯
MySQL: INSERT...ON DUPLICATE KEY UPDATEã¾ã¨ã‚ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
michael-unltd 2016/11/06
MySQL
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 9.4 ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©å¤‰æ•°
ã‚ã‚‹ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã®ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©å¤‰æ•°ã«å€¤ã‚’æ ¼ç´ã—ã€å¾Œã§åˆ¥ã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã§å‚ç…§ã§ãã¾ã™ã€‚ ã“ã‚Œã«ã‚ˆã‚Šã€ã‚ã‚‹ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‹ã‚‰åˆ¥ã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã«å€¤ã‚’æ¸¡ã™ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼å¤‰æ•°ã¯@var_name ã¨ã—ã¦è¨˜è¿°ã•ã‚Œã€å¤‰æ•°å var_name ã¯è‹±æ•°å—ã€.ã€_ãŠã‚ˆã³ $ ã§æ§‹æˆã•ã‚Œã¾ã™ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼å¤‰æ•°åã‚’æ–‡å—åˆ—ã‚„è˜åˆ¥åã¨ã—ã¦å¼•ç”¨ç¬¦ã§å›²ã‚ã°ã€ã»ã‹ã®æ–‡å—ã‚‚å«ã‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ (@'my-var'ã€@"my-var"ã€@`my-var` ãªã©)ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©å¤‰æ•°ã¯ã‚»ãƒƒã‚·ãƒ§ãƒ³å›ºæœ‰ã§ã™ã€‚ ã‚ã‚‹ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§å®šç¾©ã•ã‚ŒãŸãƒ¦ãƒ¼ã‚¶ãƒ¼å¤‰æ•°ã¯ã€ä»–ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§ã¯è¡¨ç¤ºã¾ãŸã¯ä½¿ç”¨ã§ãã¾ã›ã‚“ã€‚ (ä¾‹å¤–: ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¹ã‚ãƒ¼ãƒž user_variables_by_thread ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹æ¨©ã‚’æŒã¤ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ã€ã™ã¹ã¦ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ã™ã¹ã¦ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼å¤‰æ•°ã‚’è¡¨ç¤ºã§ãã¾ã™ã€‚) æ‰€å®šã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ã™ã¹
michael-unltd 2016/11/05
MySQL

sql
ãƒªãƒ³ã‚¯
Ansibleã§RPMã®MySQL5.7ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ»åˆæœŸè¨å®šã‚’è‡ªå‹•åŒ–ã—ã¦ã¿ãŸ Â· DQNEOæ—¥è¨˜
MySQL v5.7ã§ã¯rootã®åˆæœŸè¨å®šã¾ã‚ã‚ŠãŒã„ã‚ã„ã‚å¤‰ã‚ã£ã¦ãŠã‚Šã€ v5.6ã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸè¨˜äº‹ã‚’è¦‹ã¦ã‚‚ãã®ã¾ã¾ã§ã¯ä½¿ãˆãªã‹ã£ãŸã‚Šã—ã¾ã™ã€‚ Ansibleã‚’ä½¿ã£ã¦MySQL 5.7ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ»åˆæœŸè¨å®šã™ã‚‹ã¨ã“ã‚ã¾ã§ã§ããŸã®ã§ã‚„ã‚Šæ–¹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ æ³¨æ„ ã“ã‚Œã¯ã‚ãã¾ã§ç°¡æ˜“ç‰ˆã§ã€Vagrantã®ã‚ˆã†ãªé–‹ç™ºç’°å¢ƒæ§‹ç¯‰ã‚’æƒ³å®šã—ã¦ã„ã¾ã™ã€‚ æœ¬ç•ªã‚µãƒ¼ãƒã«é©ç”¨ã™ã‚‹å ´åˆã¯ã‚‚ã£ã¨ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’é‡è¦–ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã§ã—ã‚‡ã†ã€‚ è‡ªåˆ†ã¯MySQLã«é–¢ã—ã¦ã¯åˆç´šè€…ãªã®ã§ã€ãƒ„ãƒƒã‚³ãƒŸæ“è¿Žã§ã™ã€‚ã‚‚ã£ã¨ã„ã„ã‚„ã‚Šæ–¹ãŒã‚ã‚Œã°æ•™ãˆã¦ãã ã•ã„ã€‚ æ‰‹é † RPMã‚’ä½¿ã£ã¦MySQL5.7ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’è§£æžã—ã¦rootã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¾—ã‚‹ rootã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ /root/.tmp.my.cnf ã«è¨˜è¿°ã™ã‚‹ /root/.tmp.my.cnf ã‚’ä½¿ã£ã¦rootãƒã‚°ã‚¤ãƒ³ã—ã€rootã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã™ã‚‹ ã¨åŒæ™‚ã«æ–°ãƒ‘
michael-unltd 2016/10/17
5.7Â ã¯root initial password ã‚’provisioning ã«çµ„ã¿è¾¼ã‚€å¿…è¦ã‚ã‚Š

MySQL
ãƒªãƒ³ã‚¯
GitHub - usualoma/chef-mysql-apt: Installs mysql server from the MySQL APT repository and configures initial root password.
michael-unltd 2016/10/16
chef

MySQL
ãƒªãƒ³ã‚¯
til/[mysql itamae] mysql-57-root-password.md at master Â· shimoju/til
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
michael-unltd 2016/10/16
init password

itamae

MySQL
ãƒªãƒ³ã‚¯
MySQL ã‚’å…¬å¼ APT ãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ Chef ã® cookbook ã‚’æ›¸ãã¾ã—ãŸ
MySQL ã‚’å…¬å¼ APT ãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ Chef ã® cookbook ã‚’æ›¸ãã¾ã—ãŸ TL;DR chef-mysql-apt ã‚’æ›¸ãã¾ã—ãŸã€‚ å…¬å¼ deb ã§ mysql-server ã® 5.7 ã‚’ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ç„¡ã—ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ã€mysql.user.plugin ãŒ auth_socket ã«ãªã‚‹ã®ã§ã€ALTER USER ã§æ˜Žç¤ºçš„ã« plugin ã‚’å¤‰æ›´ã—ãªã„ã¨ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã§ããªã„ã®ã§æ°—ã‚’ã¤ã‘ãŸæ–¹ãŒã‚ˆã„ã€‚ chef ã® remote_file ã§ã® checksum ã®æŒ‡å®šã¯ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã® checksum ã‚’ç¢ºèªã™ã‚‹ã‚‚ã®ã§ã¯ãªã„ã®ã§æ°—ã‚’ã¤ã‘ãŸæ–¹ãŒã‚ˆã„ã€‚ (é•ã†ã¨ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«æ›¸ã„ã¦ã‚ã‚‹ã‘ã‚Œã©) MySQL ã‚’å…¬å¼ APT ãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ Chef ã® cookbookã€chef-mysql-apt ã‚’æ›¸ã„ãŸã®ã§ã™ãŒã€éžå¯¾è©±
michael-unltd 2016/10/14
5.7

MySQL

chef
ãƒªãƒ³ã‚¯
MySQLã§1ãƒ¶æœˆä»¥å†…ã®æƒ…å ±ã‚’SELECTã™ã‚‹ ï½œ Notebook â€“
MySQLã§1ãƒ¶æœˆä»¥å†…ã®æƒ…å ±ã‚’SELECTã™ã‚‹ MySQLã§1ãƒ¶æœˆä»¥å†…ã®æƒ…å ±ã‚’SELECTã™ã‚‹ ã¯ã‚³ãƒ¡ãƒ³ãƒˆã‚’å—ã‘ä»˜ã‘ã¦ã„ã¾ã›ã‚“ã€‚ 2012å¹´1æœˆ17æ—¥ ys MySQL MySQLã§ã€1ãƒ¶æœˆå¾Œã‚„1ãƒ¶æœˆå‰ã€3æ—¥å¾Œãªã©ã®æ—¥ä»˜ã‚’å–å¾—ã™ã‚‹ã€‚ DATE_ADD(NOW(), [æŒ‡å®šã—ãŸã„æœŸé–“]) æŒ‡å®šã—ãŸã„æœŸé–“ã‚’ä»¥ä¸‹ã®ã‚ˆã†ã«è¨˜è¿°ã™ã‚‹ã€‚ 1ãƒ¶æœˆå‰ã‚’æŒ‡å®šã™ã‚‹ SELECT * FROM test_member WHERE created >= DATE_ADD(NOW(), INTERVAL -1 MONTH); 1ãƒ¶æœˆå¾Œ DATE_ADD(NOW(), INTERVAL 1 MONTH) 3æ—¥å‰ DATE_ADD(NOW(), INTERVAL -3 DAY) 3æ—¥å¾Œ DATE_ADD(NOW(), INTERVAL 3 DAY) 2é€±é–“å¾Œ DATE_ADD(NOW(), INTERVAL 2 WEE
michael-unltd 2016/09/27
â€œDATE_ADD(NOW(), [æŒ‡å®šã—ãŸã„æœŸé–“])â€

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