[B! MySQL] uokadaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

uokada id:uokada

MySQLã«é–¢ã™ã‚‹uokadaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (73)

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

å°ã•ãªãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ALTER TABLEä¸€æ’ƒã§ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ã€‚ãã“ã‹ã‚‰å¦ã‚“ã æƒ¨äº‹ã‚’ç¹°ã‚Šè¿”ã•ãªã„ãŸã‚ã®ãƒ«ãƒ¼ãƒ«ä½œã‚Š - Qiita
ã“ã¡ã‚‰ã¯ NewsPicksã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã®9æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€‚NewsPicks ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®é¶´æˆ¿ã§ã™ã€‚ ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã®åˆ·æ–°ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ãŠã„ã¦ã€ä¸»ã«ã‚¤ãƒ³ãƒ•ãƒ©ã¨ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚’æ‹…å½“ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯ç§ãŒä»¥å‰èµ·ã“ã—ã¦ã—ã¾ã£ãŸã‚µãƒ¼ãƒ“ã‚¹å…¨åœæ¢ã®éšœå®³ã®åŽŸå› ã¨ã€ãã®å†ç™ºé˜²æ¢ç–ã«é–¢ã—ã¦è¨˜è¼‰ã—ã¾ã™ã€‚ å°šã€å¼Šç¤¾ã§ã¯RDBMSã¨ã—ã¦MySQLã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã®ã§ã€ã“ã®è¨˜äº‹ã¯MySQLã«é–¢ã™ã‚‹å†…å®¹ã«ãªã‚Šã¾ã™ã€‚ éšœå®³äº‹è±¡ ä»Šå¹´ã®å¤é ƒã€ç´„30åˆ†ã®é–“ã€NewsPicksã®ã»ã¼å…¨ã¦ã®ã‚µãƒ¼ãƒ“ã‚¹ãŒåœæ¢ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ã€ãã®é–“ã€ãƒã‚°ã‚¤ãƒ³ã‚‚ã€è¨˜äº‹ã‚’èªã‚€ã“ã¨ã‚‚ã€è¨˜äº‹ã«ã‚³ãƒ¡ãƒ³ãƒˆã™ã‚‹ã“ã¨ã‚‚ã§ããªã„çŠ¶æ…‹ã§ã—ãŸã€‚ ã‚¢ãƒ—ãƒªã‚’é–‹ãã¨ã€ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã ã‘ã®çŠ¶æ…‹ã§ã€éšœå®³ã®è§£æ¶ˆã¾ã§ãšã£ã¨ãã®çŠ¶æ…‹ãŒç¶šã„ã¦ã„ã¾ã—ãŸã€‚ éšœå®³ã®ç›´æŽ¥åŽŸå› éšœå®³ã®ç›´æŽ¥ã®å¼•ãé‡‘ã«ãªã£ãŸã®ã¯ã€ã‚¿ã‚¤ãƒˆãƒ«ã«ã‚ã‚‹é€šã‚ŠALTE
uokada 2024/12/11
mysql
ãƒªãƒ³ã‚¯
MySQL: Welcome
Welcome to the MySQL source code documentation.This documentation covers primarily the MySQL server, for the mysqld process. Other programs, like the MySQL Router, are also documented, see the Server tools section. The order chosen to present the content is to start with low level components, and build upon previous sections, so that code is presented in a logical order. For some sections, a full
uokada 2024/04/22
mysql
ãƒªãƒ³ã‚¯
Postgres ã¨ MySQL ã«ãŠã‘ã‚‹ id, created_at, updated_at ã«é–¢ã™ã‚‹ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹
èªè€…å¯¾è±¡ ã‚ã‚‹ç¨‹åº¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹çŸ¥è˜ã‚’æŒã£ã¦ã„ã‚‹ï¼ŒçµŒé¨“å¹´æ•° 1 å¹´ä»¥ä¸Šã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ ç‰¹å®šã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã«ä¾å˜ã™ã‚‹éƒ¨åˆ†ã¯å«ã‚ãªã„ãŸã‚ï¼Œã™ã¹ã¦ã® SQL ä½¿ç”¨è€…ã‚’å¯¾è±¡ã¨ã™ã‚‹ ã¾ãŸï¼Œã‚¼ãƒã‹ã‚‰ã®ä¸å¯§ãªèª¬æ˜Žã¨ã„ã†ã‚ˆã‚Šã¯ï¼Œãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹æ„Ÿè¦šã§ä½¿ãˆã‚‹è¨˜äº‹ã¨ã„ã†å½¢ã«ã¾ã¨ã‚ã‚‹ã€‚ RDBMS ã®å¯¾è±¡ãƒãƒ¼ã‚¸ãƒ§ãƒ³ PostgreSQL: 9.4 ä»¥é™ MySQL: 8.0.28 ä»¥é™ id ï¼ˆãƒ‡ãƒ¼ã‚¿åž‹ã¨ INSERT æ™‚ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆåŸ‹ã‚ï¼‰ å°Žå…¥ ä¸€èˆ¬çš„ã«æŽ¡ç”¨ã•ã‚Œã‚„ã™ã„ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ç”¨ã®å€¤ã¨ã—ã¦ï¼Œä»¥ä¸‹ã‚’è€ƒãˆã‚‹ã€‚ é€£ç•ªæ•´æ•° MySQL ã§ã¯ AUTO_INCREMENTï¼Œ Postgres ã§ã¯ IDENTITY ã‚„ SERIAL ã¨å‘¼ã°ã‚Œã‚‹ã‚‚ã® UUID v1: ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã”ã¨ã«ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªå˜èª¿å¢—åŠ å€¤ UUID v4: ãƒ©ãƒ³ãƒ€ãƒ å€¤ UUID v7ï¼ˆãƒ‰ãƒ©ãƒ•ãƒˆï¼‰: å˜èª¿å¢—åŠ ã§ã‚ã‚‹ã‚¿ã‚¤ãƒ ã‚¹ã‚¿ãƒ³ãƒ—ã¨ãƒ©
uokada 2023/12/26
mysql

postgresql

db

database
ãƒªãƒ³ã‚¯
MySQLã§TPC-Hãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å®Ÿè¡Œã™ã‚‹ - éƒ¨å±‹ã®ä¸ã«ã‚‚ä¸€å¹´
DSS (Decision Support System) ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã§ã‚ã‚‹TPC-Hã‚’MySQLã§å®Ÿè¡Œã—ã¦ã¿ã¾ã™ã€‚ HammerDB ã¨ã„ã†TPC-Hã‚’å®Ÿè¡Œã§ãã‚‹ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ„ãƒ¼ãƒ«ã‚‚å˜åœ¨ã™ã‚‹ã®ã§ã™ãŒã€ä»Šå›žã¯å…¬å¼ã«é…å¸ƒã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ãƒãƒ¼ãƒ‰ãƒ—ãƒã‚°ãƒ©ãƒ ã®DBGENã¨ã‚¯ã‚¨ãƒªä½œæˆãƒ—ãƒã‚°ãƒ©ãƒ ã®QGENã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ç’°å¢ƒ TPC-H 2.17.0 MySQL 5.6.19 å‰æ MySQLãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã“ã¨ mysqldãŒå‹•ã„ã¦ã‚‹ã“ã¨ æ‰‹é † TPC-Hç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ¦ãƒ¼ã‚¶ã®ä½œæˆ TPC-Hç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹tpchã¨ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼tpchã‚’ä½œæˆã—ã¾ã™ã€‚ ã‚ã‹ã‚Šã‚„ã™ã•ã®ãŸã‚tpchã¨ã—ã¦ã„ã¾ã™ãŒã€åˆ¥ã«ä½•ã§ã‚‚ã„ã„ã¨æ€ã„ã¾ã™ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼tpchã«ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹tpchã®æ¨©é™ã‚’ä¸Žãˆã¦ãŠãã¾ã™ã€‚ $ mysql -u root -p mysql> CREATE DATABASE tpc
uokada 2023/06/01
mysql

tpch
ãƒªãƒ³ã‚¯
MySQLã‹ã‚‰PostgreSQLã«ç§»è¡Œã™ã‚‹éš›ã®Tips - ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³
ã“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã¯ Classi developers Advent Calendar 2022ã®18æ—¥ç›®ã€‚ ãƒã‚¿ã¯ãªã‚“ã§ã‚‚ã„ã„ã‚ˆï¼ã¨ã®ã“ã¨ãªã®ã§ã€Claasiã«å…¨ãé–¢ä¿‚ãªãã€Mysqlã‹ã‚‰PostgreSQLã«ç§»è¡Œã™ã‚‹éš›ã®æ³¨æ„ç‚¹ã‚’æ›¸ãã€‚ ãªãŠã€ã¾ã RDSã«PostgreSQLãŒãªã‹ã£ãŸé ƒã®ã‚ˆã†ãªæ˜”ã®è¨˜äº‹ã ãŒã“ã¡ã‚‰ã«ç„¡ã„ã“ã¨ã‚’æ›¸ã„ã¦ã„ãã€‚ soudai1025.blogspot.com soudai1025.blogspot.com MySQL ã‹ã‚‰ PostgreSQLã«ãƒ‡ãƒ¼ã‚¿ç§»è¡Œã™ã‚‹éš›ã®æ³¨æ„ç‚¹ MySQLã¨PostgreSQLã¯äº’æ›æ€§ãŒã‚‚ã¡ã‚ã‚“ã‚ã‚Šã¾ã›ã‚“ã®ã§ã€ç´°ã‹ã„ã¨ã“ã‚ã§é•ã„ãŒç™ºç”Ÿã—ã¾ã™ã€‚ ã‚ˆãè¸ã‚€ãƒ‡ãƒ¼ã‚¿ç§»è¡Œã®æ³¨æ„ç‚¹ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ timestampã‚„datetimeã‚’ç§»è¡Œã™ã‚‹å…ˆã¯timestampåž‹ã«ãªã‚‹ãŒã€timestampåž‹ã¯ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ä»˜ãã¨ç„¡ã—ãŒã‚ã‚‹ timestamp wi
uokada 2022/12/19
postgresql

mysql

rds
ãƒªãƒ³ã‚¯
ä¸»è¦RDBMSè£½å“ã®æ¯”è¼ƒ â€“ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£, ã‚¹ã‚ãƒ¼ãƒž, ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹, ãƒ¡ãƒ¢ãƒª | ã‚³ãƒ¼ã‚½ãƒ«Databaseã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®Blog
Microsoft SQL ServerMySQL Oracle DatabasePostgreSQLSolarWinds DPAãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é‹ç”¨ä¸»è¦RDBMSè£½å“ã®æ¯”è¼ƒ 2022.09.01 æ¸¡éƒ¨ äº®å¤ª ä¸»è¦RDBMSè£½å“ã®æ¯”è¼ƒ â€“ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£, ã‚¹ã‚ãƒ¼ãƒž, ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹, ãƒ¡ãƒ¢ãƒª Oracle ACE Proã®æ¸¡éƒ¨ã§ã™ã€‚ ä¸»è¦ãªRDBMSè£½å“ã«ã¤ã„ã¦ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’æ¯”è¼ƒã—ã¾ã™ã€‚ å¤§æž ã‚’æ•´ç†ã™ã‚‹ã“ã¨ãŒæœ€å¤§ã®ç›®çš„ã§ã™ã€‚ç´°ã‹ã„ä¾‹å¤–äº‹é …ã‚„æ‹¡å¼µæ©Ÿèƒ½ã¯é©å®œè¨˜è¼‰ã‚’å‰²æ„›ã—ã¦ã„ã¾ã™ã€‚ 2022å¹´9æœˆæ™‚ç‚¹ã®æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ãƒ™ãƒ¼ã‚¹ã«è¨˜è¼‰ã—ã¦ã„ã¾ã™ãŒã€è¨˜è¼‰å†…å®¹ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ä¾å˜ã¯å°‘ãªã„ã¯ãšã§ã™ã€‚ æ™‚é–“ãŒã§ããŸæ™‚ã«éšæ™‚è¿½è¨˜äºˆå®šã§ã™ã€‚ ã‚‚ã—èª¤ã‚Šã‚’è¦‹ã¤ã‘ãŸå ´åˆã¯ã€å„ªã—ãæ•™ãˆã¦ã„ãŸã ã‘ã‚‹ã¨å¬‰ã—ã„ã§ã™ã€‚â†’ https://twitter.com/wrcsus4 or ryota.watabe at cosol dot
uokada 2022/09/02
database

db

postgresql

mysql
ãƒªãƒ³ã‚¯
Start from scratch with Prisma ORM using TypeScript and MySQL (15 min) | Prisma Documentation
uokada 2021/06/13
mysql

graphql

prisma
ãƒªãƒ³ã‚¯
ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ä¸è¦ã§GraphQLã‚µãƒ¼ãƒãŒä½œã‚Œã‚‹Prismaã‚’è§¦ã£ã¦ã¿ã¦å¯èƒ½æ€§ã‚’æ„Ÿã˜ãŸ - SMARTCAMP Engineer Blog
ã‚¹ãƒžãƒ¼ãƒˆã‚ãƒ£ãƒ³ãƒ—ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ç€§å·ã§ã™ã€‚ å¼Šç¤¾ã§ã¯æ˜¨å¹´ã‹ã‚‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢åˆå®¿ã‚’ä¼ç”»ã—ã¦ã„ã¾ã—ã¦ã€ä»Šå¹´ã¯10æœˆ15æ—¥ã‹ã‚‰17æ—¥ã¾ã§ã®2æ³Š3æ—¥ã§å®Ÿæ–½ã—ã¾ã—ãŸï¼ åˆå®¿ã®ãƒ†ãƒ¼ãƒžã‚„å…¨ä½“æ„Ÿã¯åˆ¥è¨˜äº‹ã§ã¾ã¨ã‚ã‚‹ã‹ãªã¨æ€ã„ã¾ã™ãŒã€3æ—¥ã®é™ã‚‰ã‚ŒãŸæ™‚é–“ã§1ãƒãƒ¼ãƒ (4äºº)1ã¤ã®ãƒ—ãƒãƒ€ã‚¯ãƒˆã‚’ä½œã‚Šã€æˆæžœã¨ã—ã¦ç™ºè¡¨ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã—ãŸã€‚ ã“ã®æ¡ä»¶ã ã¨ã‚ã¾ã‚ŠæŠ€è¡“çš„ãªãƒãƒ£ãƒ¬ãƒ³ã‚¸ã‚‚ã§ããªã„ãª...ã¨æ„Ÿã˜ã¦ã¯ã„ãŸã®ã§ã™ãŒã€ã©ã†ã—ã¦ã‚‚ãƒãƒ¼ãƒ å†…ã§GraphQLè§¦ã‚ŠãŸã„æ¬²æ±‚ãŒé«˜ã¾ã£ã¦ã—ã¾ã£ãŸã®ã§ã€ãªã‚“ã¨ã‹è² è·ãŒã‚ã¾ã‚Šã‹ã‹ã‚‰ãªã„å½¢ã§å°Žå…¥ã§ããªã„ã‹èª¿ã¹ã¦è¦‹ã¤ã‹ã£ãŸã®ãŒPrismaã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã§ã—ãŸï¼ æœ¬è¨˜äº‹ã§ã¯Prismaã‚’è©¦ã—ãŸéš›ã®ãƒ¡ãƒ¢ã€Tipsã€æ‰€æ„Ÿã‚’æ›¸ã„ã¦ã„ãã¾ã™ï¼ (å…¬å¼ã§Prisma2ãŒã‚¢ãƒŠã‚¦ãƒ³ã‚¹ã•ã‚Œã¦ã¾ã™ãŒã€ã»ã¼åˆ¥ç‰©ãªã®ã§ä»Šå›žã¯Prisma1ã«ã¤ã„ã¦æ›¸ã„ã¦ã„ã¾ã™) (å¤šåˆ†æœ€çµ‚çš„ãªæˆæžœç‰©ã®é€²æ—ã¯ã€æ…£ã‚Œè¦ªã—ã‚“ã ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ãŸå ´åˆã¨ã»ã¼
uokada 2021/06/13
mysql

graphql

prisma
ãƒªãƒ³ã‚¯
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?
uokada 2021/05/13
mysql

postgresql
ãƒªãƒ³ã‚¯
MySQLã®ALTER TABLEã«ã¤ã„ã¦å°‘ã€…
2020/05/11 GMO Techno logy Bootcamp 2020
uokada 2020/05/12
MySQLä»Šã¯ã“ã‚“ãªã“ã¨å‡ºæ¥ã‚‹ã®ã‹ã€‚

mysql
ãƒªãƒ³ã‚¯
MySQL ã®ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‹ã‚‰ã®å¾©æ—§ã‚’ã¡ã‚‡ã£ã¨ã ã‘é€Ÿãã™ã‚‹è£æŠ€ - Speaker Deck
MySQL ã®ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‹ã‚‰ã®å¾©æ—§ã‚’ ã¡ã‚‡ã£ã¨ã ã‘é€Ÿãã™ã‚‹è£æŠ€/Techniques to make mysql crash recovery a bitÂ faster
uokada 2020/04/22
mysql
ãƒªãƒ³ã‚¯
RDBMS in Action
RDBMS ç†è§£åº¦ã®å£: ãƒ—ãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ã‚„é‹ç”¨ä¿å®ˆã§å›°ã‚‰ãªã„ã‚·ã‚¹ãƒ†ãƒ ã‚’ä½œã‚Œã‚‹çŸ¥è˜ ï¼œï¼œï¼œãã‚Œã£ã½ãå‹•ãã‚‚ã®ã‚’ä½œã‚Œã‚‹çŸ¥è˜ å®Ÿéš›ã®ã‚·ã‚¹ãƒ†ãƒ ã§éé‡ãƒ»è¦‹èžãã—ãŸäº‹è±¡ã‚’ã‚‚ã¨ã«ã€ä¸Šè¨˜ã®ã‚¹ã‚ãƒžã«ã‚ã‚‹å„ç¨® RDBMS çŸ¥è˜ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ RDBMS æœ¬ä½“ã®é‹ç”¨ã‚ˆã‚Šã‚‚ã€ç¾å®Ÿã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã‘ã‚‹è¨è¨ˆâ€¦
uokada 2019/10/02
db

database

postgresql

mysql
ãƒªãƒ³ã‚¯
Oracle MySQL Operator æ¤œè¨¼ã—ã¦ã¿ãŸ
ãƒ»æã‚‹ã‚‹ã“ã¨ãªã‹ã‚Œ! Cloud Nativeãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«DBç‰¹é›†!! - cndjpç¬¬12å›ž ãƒ»MySQL & PostgreSQL Casual Talks in Fukuoka vol.1 ä¸Šè¨˜Meetupã®ç™»å£‡è³‡æ–™ã§ã™ã€‚ Oracle MySQL Operatorã®è§£èª¬ã¨æ¤œè¨¼çµæžœã‚’å…±æœ‰ã—ã¾ã™ã€‚
uokada 2019/07/13
mysql

kubernetes

vitess
ãƒªãƒ³ã‚¯
ç¬¬90å›žã€€ãƒ‡ãƒ¥ã‚¢ãƒ«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰æ©Ÿèƒ½ã§ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ä¾¿åˆ©ã«å¤‰æ›´ã™ã‚‹ | gihyo.jp
éƒ¨ç½²å¤‰æ›´ã‚„è»¢è·ã€é€€è·ã¨ã„ã£ãŸã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§æ¨©é™ã®ä»˜ä¸Žã‚„å‰Šé™¤ãŒè¡Œã‚ã‚ŒãŸéš›ã‚„ã€ç‰¹ã«æ¨©é™ãŒå‰Šé™¤ã¨ãªã£ãŸå ´åˆã«ã€ä»Šã¾ã§åˆ©ç”¨ã—ã¦ã„ãŸãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã™ã‚‹ã“ã¨ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ã—ã‹ã—ã€ç‰¹ã«ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒã„ã‚‹ã‚ˆã†ãªå°‘ã—è¤‡é›‘ãªæ§‹æˆã®MySQLã§ã€ãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ ç„¡ã—ã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã™ã‚‹ã®ã¯ã‹ãªã‚Šå¤§å¤‰ã ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¯MySQL 8.0.14ã‹ã‚‰è¿½åŠ ã•ã‚ŒãŸãƒ‡ãƒ¥ã‚¢ãƒ«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®æ©Ÿèƒ½ã‚’ã€8.0.15ã‚’ä½¿ã£ã¦ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ ãƒ‡ãƒ¥ã‚¢ãƒ«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¨ã¯ï¼Ÿ ã“ã¡ã‚‰ã¯MySQL 8.0.14ã‹ã‚‰è¿½åŠ ã•ã‚ŒãŸæ©Ÿèƒ½ã§ã€åå‰ã®é€šã‚Šã€2ã¤ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒè¨å®šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œã€ãƒ—ãƒ©ã‚¤ãƒžãƒªãƒ¼ã¨ã‚»ã‚«ãƒ³ãƒ€ãƒªãƒ¼ã¨å‘¼ã³ã¾ã™ã€‚2ã¤ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹æ™‚ã«ã¯ã€ãƒ—ãƒ©ã‚¤ãƒžãƒªãƒ¼ã§ã‚‚ã‚»ã‚«ãƒ³ãƒ€ãƒªãƒ¼ã§ã‚‚ã©ã¡ã‚‰ã§ã‚‚ãƒã‚°ã‚¤ãƒ³ãŒå¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ãªã®ã§ã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å¤‰æ›´ã‚’è¡Œã†éš›ã«ã¯ä»¥ä¸‹ã®é †ã§ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã—ã¦ã„ãã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ãƒ—ãƒ©ã‚¤ãƒžãƒªãƒ¼ãƒ‘ã‚¹
uokada 2019/02/13
"éƒ¨ç½²å¤‰æ›´ã‚„è»¢è·ï¼Œé€€è·ã¨ã„ã£ãŸã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§æ¨©é™ã®ä»˜ä¸Žã‚„å‰Šé™¤ãŒè¡Œã‚ã‚ŒãŸéš›ã‚„ï¼Œç‰¹ã«æ¨©é™ãŒå‰Šé™¤ã¨ãªã£ãŸå ´åˆã«ï¼Œä»Šã¾ã§åˆ©ç”¨ã—ã¦ã„ãŸãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã™ã‚‹" ã“ã‚Œã§å®‰å…¨ã«é‹ç”¨å‡ºæ¥ã‚‹ãã€‚

mysql

password
ãƒªãƒ³ã‚¯
Githubã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ãŒMySQLé«˜å¯ç”¨æ€§ã®ãŸã‚ã«æ–°ã—ã„ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’æŽ¡ç”¨
ã‚ãªãŸã«ã¨ã£ã¦é‡è¦ãªãƒˆãƒ”ãƒƒã‚¯ã‚„åŒåƒšã®æœ€æ–°æƒ…å ±ã‚’å…¥æ‰‹ã—ã¾ã—ã‚‡ã†æœ€æ–°ã®æ´žå¯Ÿã¨ãƒˆãƒ¬ãƒ³ãƒ‰ã«é–¢ã™ã‚‹æœ€æ–°æƒ…å ±ã‚’å³åº§ã«å—ã‘å–ã‚Šã¾ã—ã‚‡ã†ã€‚ ç¶™ç¶šçš„ãªå¦ç¿’ã®ãŸã‚ã«ã€ç„¡æ–™ã®ãƒªã‚½ãƒ¼ã‚¹ã«æ‰‹è»½ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¾ã—ã‚‡ã†ãƒŸãƒ‹ãƒ–ãƒƒã‚¯ã€ãƒˆãƒ©ãƒ³ã‚¹ã‚¯ãƒªãƒ—ãƒˆä»˜ãå‹•ç”»ã€ãŠã‚ˆã³ãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚°æ•™æã€‚ è¨˜äº‹ã‚’ä¿å˜ã—ã¦ã€ã„ã¤ã§ã‚‚èªã‚€ã“ã¨ãŒã§ãã¾ã™è¨˜äº‹ã‚’ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã—ã¦ã€æº–å‚™ãŒã§ããŸã‚‰ã„ã¤ã§ã‚‚èªã‚ã¾ã™ã€‚
uokada 2018/07/24
mysql

GitHub
ãƒªãƒ³ã‚¯
å¤§é‡ãƒ‡ãƒ¼ã‚¿ã®è»¢é€ã«Embulkã‚’ä½¿ã£ã¦ã¿ãŸã‚‰æœ¬å½“ã«æ¥½ã ã£ãŸ - CARTA TECH BLOG
ã¯ã˜ã‚ã¾ã—ã¦ã€‚Zucks Affiliateã§ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ã—ã¦ã„ã‚‹å®—å²¡ã§ã™ã€‚ ä»Šå›žã¯ã€ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ æ€§ã¯æ±‚ã‚ãªã„ã‘ã©ã€ç°¡å˜ã«å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã©ã“ã‹åˆ¥ã®å ´æ‰€ã«è»¢é€ã—ãŸã„ã€‚ ã¨ã„ã†è¦æœ›ã«ç”ãˆã¦ãã‚Œã‚‹Embulkã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ å®Ÿéš›ã«å°Žå…¥ã«è‡³ã£ãŸãã£ã‹ã‘ã‚„ã€é‹ç”¨ä¸Šã‚ˆãã‚ã‚‹èª²é¡Œãªã©ã‚‚è§¦ã‚Œã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ åŒã˜å¢ƒé‡ã®äººãŒã€Œç°¡å˜ãã†ã ã—Embulkä½¿ã£ã¦ã¿ã‚ˆã†ã‹ãªã€ã¨ãªã£ã¦ã„ãŸã ã‘ã‚Œã°å¹¸ã„ã§ã™ã€‚ ç›®æ¬¡ ç›®æ¬¡ èƒŒæ™¯ Embulkä»¥å¤–ã«ã‚‚å‡ºã¦ããŸæ¡ˆ å®Ÿéš›ã®Embulkã®å°Žå…¥ã¨ä½¿ã„æ–¹ 1. Embulkã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ— 2. å¿…è¦ãªãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« 3. è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ›¸ã å®Ÿå‹™ã§codecommitã‚’ä½¿ã£ãŸä¾‹ è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã®æ›¸ãæ–¹ 4. ã¾ãšã¯previewã§å•é¡Œãªã•ãã†ã‹ç¢ºèª 5. å•é¡Œãªã•ãã†ãªã®ã§runã—ã¦å®Ÿè¡Œ Embulkã®é‹ç”¨ä¸Šã€ã‚ˆãã¶ã¤ã‹ã‚‹èª²é¡Œ 1. é‡è¤‡ã«æ°—ä»˜
uokada 2017/08/01
embulk

BigQuery

MySQL
ãƒªãƒ³ã‚¯
Facebookã«ãŠã‘ã‚‹MySQLã‚’ç”¨ã„ãŸå¤§è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®ç¾å®Ÿï½žMySQL Connect 2013
ç±³ã‚ªãƒ©ã‚¯ãƒ«ãŒä¸»å‚¬ã™ã‚‹MySQLã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒMySQL Connectã€ãŒ9æœˆ21æ—¥ã‹ã‚‰23æ—¥ã¾ã§ã€ã‚µãƒ³ãƒ•ãƒ©ãƒ³ã‚·ã‚¹ã‚³ã§é–‹å‚¬ã•ã‚Œã¾ã—ãŸã€‚Oracle OpenWorldã€JavaOneã¨ã®åŒæ™‚é–‹å‚¬ã§ã—ãŸã€‚ åŸºèª¿è¬›æ¼”ã®1ã¤ã«ã¯ã€MySQLã®ãƒ˜ãƒ“ãƒ¼ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ã‚ã‚‹Facebookã®Harrison Fiskæ°ãŒç™»å£‡ã€‚Facebookã«ãŠã‘ã‚‹MySQLã®å½¹å‰²ã€å¤§è¦æ¨¡é‹ç”¨ã®èƒŒæ™¯ãªã©ã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ãã®å†…å®¹ã‚’ãƒ€ã‚¤ã‚¸ã‚§ã‚¹ãƒˆã§ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ MySQL@Facebook Lots and lots of small data Harrison Fiskæ°ã€‚ Facebookã§ãƒ‡ãƒ¼ã‚¿ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¼ãƒ ã®ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚’ã—ã¦ã„ã‚‹ã€‚ç¤¾å†…ã§ã¯MySQLã¯ã‚‚ã¡ã‚ã‚“ã€HBase Hadoopãªã©ã«ã‚‚é–¢ã‚ã£ã¦ã„ã‚‹ã€‚ ã¾ãšã¯ã€ã©ã‚“ãªç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã£ã¦ã„ã‚‹ã®ã‹ã«ã¤ã„ã¦ã€‚ Facebookã¨ã¯åŸºæœ¬çš„ã«ã‚°ãƒ©ãƒ•ã ã€‚ã‚°
uokada 2013/09/27
MySQL

facebook

database
ãƒªãƒ³ã‚¯
MySQLã®ãƒ—ãƒãƒˆã‚³ãƒ«è§£èª¬ - ã¨ã¿ãŸã¾ã•ã²ã‚ - Rabbit Slide Show
Page: 1 MySQLã®ãƒ—ãƒãƒˆã‚³ãƒ«è§£èª¬ ã¨ã¿ãŸã¾ã•ã²ã‚ æ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ä¼š MyNAä¼š 2013/07/29 MySQLã®ãƒ—ãƒãƒˆã‚³ãƒ«è§£èª¬ Powered by Rabbit 2.1.1 Page: 2 è‡ªå·±ç´¹ä»‹ ã¨ã¿ãŸ ã¾ã•ã²ã‚ MySQLãƒ¦ãƒ¼ã‚¶ä¼š(åã°ã‹ã‚Šä»£è¡¨) é•·é‡ŽçœŒåŒ—éƒ¨åœ¨ä½ ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ (Ruby & C) http://tmtms.hatena blog.com http://twitter.com/tmtms https://github.com/tmtm/ruby-mysql MySQLã®ãƒ—ãƒãƒˆã‚³ãƒ«è§£èª¬ Powered by Rabbit 2.1.1 Page: 3 è¶£å‘³ èª°ã‚‚ä½¿ã‚ãªã„Rubyãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½œã£ãŸã‚Š MySQL ã® yacc ãƒ•ã‚¡ã‚¤ãƒ«èªã‚“ã ã‚Š ãƒžãƒ³ã‚¬èªã‚“ã ã‚Š è–æ‚ ç´€ / ä½ã€…æœ¨æ·³å / å²¡å´ŽäºŒéƒŽ / æ˜Ÿé‡Žä¹‹å®£ / é•·è°·å·è£•ä¸€ / å³¶æœ¬å’Œå½¦ / æ¡‘ç”°ä¹ƒæ¢¨å
uokada 2013/07/30
MySQL

protocol
ãƒªãƒ³ã‚¯
Pinterestã¯ã„ã‹ã«ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨æ ¼é—˜ã—ã¦ããŸã®ã‹ï¼ˆå‰ç·¨ï¼‰ã€‚QCon Tokyo 2013
4æœˆ23æ—¥ã«éƒ½å†…ã§é–‹å‚¬ã•ã‚ŒãŸã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒQCon Tokyo 2013ã€ã€‚æ€¥é€Ÿã«äººæ°—ã‚µã‚¤ãƒˆã¸ã¨æˆé•·ã—ãŸPinterestãŒã€ãã®è£ã§ã„ã‹ã«ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨æ ¼é—˜ã—ã¦ããŸã®ã‹ã‚’Pinterestã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢è‡ªèº«ãŒç´¹ä»‹ã™ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒScaling Pinterestã€ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€ãã®å†…å®¹ã‚’ãƒ€ã‚¤ã‚¸ã‚§ã‚¹ãƒˆã§ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ ã¤ãã«ã‚·ã‚¹ãƒ†ãƒ ã®ã©ã“ã‹ãŒå£Šã‚Œã¦ã„ã‚‹ Pinterestã€Marty Weineræ°ã€‚ Pinterestã¯ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã®ãƒ”ãƒ³ãƒœãƒ¼ãƒ‰ã§ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒã€Œãƒœãƒ¼ãƒ‰ã€ã‚’ä½œæˆã—ã¦ã€ãã“ã«ç”»åƒãªã©å¥½ããªã‚‚ã®ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦ã‚·ã‚§ã‚¢ã§ãã‚‹ã¨ã„ã†ã‚‚ã®ã€‚ã€Œãƒ”ãƒ³ã€ã²ã¨ã¤ã²ã¨ã¤ãŒç”»åƒã‚„ãƒªãƒ³ã‚¯ã«ãªã£ã¦ã„ã‚‹ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚„ãƒœãƒ¼ãƒ‰ã‚’ãƒ•ã‚©ãƒãƒ¼ã™ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã—ã€å†ãƒ”ãƒ³ã—ãŸã‚Šã‚¤ã‚¤ãƒã—ãŸã‚Šã€ã‚³ãƒ¡ãƒ³ãƒˆã®å…¥åŠ›ã‚‚ã§ãã‚‹ã€‚
uokada 2013/05/14
pinterest

mysql

scalability

webservice
ãƒªãƒ³ã‚¯
MySQL ã® "Illegal mix of collations" ã‚¨ãƒ©ãƒ¼ã«ã¤ã„ã¦ - tmtms ã®ãƒ¡ãƒ¢
MySQL ã§ã€ŒIllegal mix of collationsã€ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãŒå‡ºã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã® charset ã¨æŽ¥ç¶šã® charset ç‰ã€ã™ã¹ã¦ã‚’ utf8 ãªã©ã§çµ±ä¸€ã—ã¦ã‚Œã°å‡ºãªã„ã®ã§ã€ã‚ã¾ã‚Šè¦‹ã‚‹ã“ã¨ã¯ãªã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ç§ã¯ã‚«ãƒ©ãƒ æ¯Žã« charset ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ãŒã‚ã‚‹ã®ã§ã€æ™‚ã€…ã“ã®ã‚¨ãƒ©ãƒ¼ã«ãƒãƒžã‚Šã¾ã™ã€‚ ãŸã¨ãˆã°ã€æ¬¡ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã£ãŸã‚Šã—ã¾ã™ã€‚ CREATE TABLE users ( id INT PRIMARY KEY AUTO_INCREMENT, em ail VARCHAR(320) CHARSET ascii UNIQUE, name VARCHAR(30) CHARSET utf8 ); ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ã®è¦ç´„ã¯ã€ãƒãƒ¼ã‚«ãƒ«éƒ¨ãŒæœ€å¤§64ãƒã‚¤ãƒˆã€ãƒ‰ãƒ¡ã‚¤ãƒ³éƒ¨ãŒæœ€å¤§255ãƒã‚¤ãƒˆã€ãã‚Œã¨ @ ã®1ãƒã‚¤ãƒˆã§åˆè¨ˆæœ€å¤§320ãƒã‚¤ãƒˆãªã®ã§ã€ VARCHAR(32
uokada 2013/04/11
charset

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