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

tksmd id:tksmd

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

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

ã€Žã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã«ãŠã‘ã‚‹DBæ§‹æˆ&å¯¾å¿œè¨˜ã€
2ãƒ¶æœˆå‰ã«ã‚¤ãƒ³ãƒ•ãƒ«ã‚¨ãƒ³ã‚¶ã¨ã‚¦ã‚£ãƒ«ã‚¹æ€§èƒƒè…¸ç‚Žã§ã²ã©ããƒ€ãƒ¡ãƒ¼ã‚¸ã‚’å—ã‘ãŸå¢—ç”°(@masudaK)ã§ã™ã€‚ã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã¯2009å¹´2æœˆã«å§‹ã¾ã£ãŸã‚µãƒ¼ãƒ“ã‚¹ã§ã€FLASHãƒ»Javaã§ä½œã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ãã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã«MySQLã‚’ç”¨ã„ã¦ã¾ã™ã€‚æœ¬è¨˜äº‹ã§ã¯ã€ã‚ãŸãã—ãŒ2å¹´ã»ã©è¦‹ç¶šã‘ã¦ã„ã‚‹ã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã®DBç’°å¢ƒã«ã¤ã„ã¦æ§‹æˆã‚„ã€æ—¥ã€…ã©ã®ã‚ˆã†ã«ã—ã¦å•é¡Œã¨å‘ãåˆã£ã¦ã„ã‚‹ã‹ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ã‚¤ãƒ³ãƒ•ãƒ©å¯„ã‚Šã®å†…å®¹ãŒå¤šã„ãŸã‚ã€ã‚¢ãƒ—ãƒªå¯„ã‚Šã®è©±ã¯å¼Šç¤¾ç”Ÿæ²¼ã®è³‡æ–™ã‚’å¾¡è¦§ãã ã•ã„ã€‚ 1. æ§‹æˆã¨è¦æ¨¡ 1.1. æ§‹æˆ ã¾ãšæ§‹æˆã§ã™ãŒã€èªã¿æ›¸ãã¯ã™ã¹ã¦ãƒžã‚¹ã‚¿ãƒ¼ã¸è¡Œã†ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã¯å‚ç…§ã‚’å‘ã‘ãšã€ãƒ›ãƒƒãƒˆã‚¹ã‚¿ãƒ³ãƒã‚¤ã¨ã—ã¦ä½¿ã£ã¦ã„ã¾ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«é–¢ã—ã¦ã¯2012å¹´ä¸æ—¬ã¾ã§ã¯5.0ã‚’ä½¿ã£ã¦ã¾ã—ãŸãŒã€DCç§»è»¢ã«ã‚ã‚ã›ã¦5.5ã«ã‚ã’ã¾ã—ãŸã€‚ãƒãƒƒã‚¯æ©Ÿèƒ½ã‚’ç”¨ã„ãŸã‚·ãƒ£ãƒ¼ãƒ‰æ§‹æˆã‚’ã—ã¦ã¾ã—ã¦ã€2014å¹´3æœˆç¾åœ¨6ã‚·ãƒ£ãƒ¼ãƒ‰ã«ãª
tksmd 2014/05/23
pt-query-digest

MySQL
ãƒªãƒ³ã‚¯
YappoLogs: ãªãœ SQL_CALC_FOUND_ROWS ã‚„ LIMIT OFFSET ã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ãŒè‰¯ãç„¡ã„ã®ã‹
ãªãœ SQL_CALC_FOUND_ROWS ã‚„ LIMIT OFFSET ã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ãŒè‰¯ãç„¡ã„ã®ã‹ ã“ã“æœ€è¿‘ã®å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹é–¢é€£ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒšãƒ¼ã‚¸ãƒ³ã‚°è€ƒã§ã™ã€‚ mysql 5.5.34 ã§è©¦ã—ã¦è¨˜äº‹æ›¸ã„ã¦ã¾ã™ã€‚ bigdata ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ãªã‚«ãƒ©ãƒ ãŒã‚ã‚‹å‰æã§ã™ã€‚ã‚‚ã¡ã‚ã‚“ InnoDB ã§ã™ã€‚ 2014å¹´ãªã‚“ã ã‹ã‚‰COUNT(*)ã¨ã‹SQL_CALC_FOUND_ROWSã¨ã‹LIMIT OFFSETã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ã¯ã‚„ã‚ã‚ˆã†ãœ - Togetterã¾ã¨ã‚ãŒç™ºç«¯ã«ã¿ãˆã‚‹ã‘ã©ã€ã‚ã‚Šã¨æ˜”ã‹ã‚‰è©±ã•ã‚Œã¦ã‚‹äº‹ãªã‚“ã ã‘ã©ã€ã€Œnippondanji SQL_CALC_FOUND_ROWSã€ã§ã‚°ã‚°ã£ã¦ã‚‚æœ‰ç”¨ãªæƒ…å ±ãªã„ã—æ–‡æ›¸åŒ–ã•ã‚Œã¦ãªã„ã‹ã‚‰ã—ã¨ãã€‚ ãƒšãƒ¼ã‚¸ãƒ³ã‚°å‡¦ç†ã§ä½¿ã‚ã‚ŒãŒã¡ãªæ©Ÿèƒ½ã§ã™ã€‚ S
tksmd 2014/03/14
MySQL
ãƒªãƒ³ã‚¯
MySQL ä»Šæ›´ãªãŒã‚‰online-schema-changeã«ã¤ã„ã¦ | Ore no homepage
ãã†ã„ãˆã°å…ˆæ—¥ã¯ãƒãƒã‚¦ã‚£ãƒ³ã ã£ãŸãã€‚ã‚“ã§ã€ä»Šæ—¥ã‚¹ã‚¿ãƒã«è¡Œã£ã¦ã¿ãŸã‚‰æ—©ãã‚‚ã‚¯ãƒªã‚¹ãƒžã‚¹ä»•æ§˜ã€‚æ®‹å¿µãªãŒã‚‰å¹´æœ«ã®äºˆå®šã¯ç„¡ãˆã€‚ ãã‚“ãªã“ã‚“ãªã§ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ã‚ãƒ¼ãƒžãƒã‚§ãƒ³ã‚¸ã‚’æœ¬ç•ªã®ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã§ä½¿ã„å§‹ã‚ãŸã®ã§ãã®ãƒ¡ãƒ¢ã€‚ 0. online-schema-change ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ã‚ãƒ¼ãƒžãƒã‚§ãƒ³ã‚¸ã¯ã€perconaç¤¾ãŒå‡ºã—ã¦ã„ã‚‹percona-toolkitã«æ¢±åŒ…ã•ã‚Œã¦ã„ã‚‹ã€‚ãã®ä»–æœ‰ç”¨ãªãƒ„ãƒ¼ãƒ«ã‚‚å…¥ã£ã¦ã„ã‚‹ã®ã§ãŠä¸–è©±ã«ãªã£ã¦ã„ã‚‹äººã‚‚å¤šã„ã ã‚ã†ã€‚ã§ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ã‚ãƒ¼ãƒžãƒã‚§ãƒ³ã‚¸ã¯ãã®åã®ã¨ãŠã‚Šã€ã‚¹ã‚ãƒ¼ãƒžã®å¤‰æ›´ã€alteræ–‡ã‚’ãƒ–ãƒãƒƒã‚¯ãªã—ã§å®Ÿè¡Œã—ã¦ãã‚Œã‚‹ã¨ã„ã†ä»£ç‰©ã€‚ ç§äº‹ãªã‚“ã ã‘ã©ã€ä»Šã¾ã§ã¯ã€Œã¡ã‚‡ã£ã¨æ›´æ–°ã‚’ãƒ–ãƒãƒƒã‚¯ã—ã¡ã‚ƒã†ã‘ã©ã‚¢ã‚¯ã‚»ã‚¹ã®å°‘ãªã„æ™‚é–“å¸¯ã«ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§alterã‚’æµã™ã€ã¿ãŸã„ãªé‹ç”¨ã‚’ã—ã¦ãŸã€‚å®Ÿè¡Œå†…å®¹ã«ã‚‚ã‚ˆã‚‹ã‘ã©alter tableã¯æ„å¤–ã¨æ—©ã„ã®ã§ã€ã€Œæ›´æ–°ã‚’ãƒ–ãƒãƒƒã‚¯ã•ã‚Œã‚‹æ™‚é–“ãŒSLAçš„ã«è¨±å¯ã§ãã‚‹ãªã‚‰O
tksmd 2013/11/07
online-schema-change ã«ã¤ã„ã¦

MySQL
ãƒªãƒ³ã‚¯
Schema changes - what's new in MySQL 5.6?
All of Perconaâ€™s open-source software products, in one place, to download as much or as little as you need.
tksmd 2013/11/07
MySQL 5.6 ã® schema change ã«ã¤ã„ã¦

MySQL
ãƒªãƒ³ã‚¯
The Innotop Manual
NAME innotop - MySQL and InnoDB transaction/status monitor. SYNOPSIS To monitor servers normally: innotop To monitor InnoDB status information from a file: innotop /var/log/mysql/mysqld.err To run innotop non-interactively in a pipe-and-filter configuration: innotop --count 5 -d 1 -n To monitor a database on another system using a particular username and password: innotop -u <username> -p <passwor
tksmd 2012/06/05
innotop ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«

MySQL
ãƒªãƒ³ã‚¯
MySQLãŒãŠã‹ã—ã„ï¼ã‚ãªãŸãªã‚‰ã©ã†ã—ã¾ã™ã‹ï¼Ÿ â€“ MySQL Casual Advent Calendar 2011 - As a Futurist...
ã—ã‚ã£ã™ï¼DBA å…¼ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å…¼ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚„ã£ã¦ã‚‹ riywo ã§ã™ã€‚ä½•ã®ãƒã‚¿ã‚’æ›¸ã“ã†ã‹ãªãã¨è€ƒãˆãŸã®ã§ã™ãŒã€æ£ç›´ãƒã‚¿ã‚’ä»•è¾¼ã‚€æ™‚é–“ã‚‚ãªã‹ã£ãŸã®ã§åƒ•ãŒã„ã¤ã‚‚ã‚„ã£ã¦ã‚‹ã“ã¨ã‚’ã•ã‚‰ã£ã¨ç´¹ä»‹ã™ã‚‹ã¨ã„ã†ã“ã¨ã§å‹˜å¼ã—ã¦ä¸‹ã•ã„ï¼žï¼œ MySQL ãŒãŠã‹ã—ã„ï¼ 03:14 hidek: ãªã‚“ã‹ã‚¨ãƒ©ãƒ¼å‡ºã¾ãã£ã¦ã‚‹ã‚“ã ã‘ã©ï¼ 03:14 zigorou: MySQL ã¨é€šä¿¡ã—ã¦ã‚‹ã¨ã“ã£ã½ã„ 03:15 riywo: è¦‹ã¾ã™ ã“ã‚“ãªã‚„ã‚Šã¨ã‚Šã¯çš†ã•ã‚“æ—¥å¸¸èŒ¶é£¯äº‹ã§ã™ã‚ˆãï¼Ÿãï¼Ÿãï¼Ÿã“ã‚“ãªæ™‚ã«ã€DB ã«è²¬ä»»ã‚’æŒã¤ã‚‚ã®ã¨ã—ã¦çœŸã£å…ˆã«å¯¾å¿œã™ã‚‹ã®ãŒåƒ•ã‚‰ã®ä»•äº‹ã§ã™ã€‚ã§ã‚‚ã€ã˜ã‚ƒã‚å…·ä½“çš„ã«ã“ã®ã‚ã¨ä½•ã‚’ã—ã¾ã—ã‚‡ã†ï¼Ÿæ—¢ã«ã‚µãƒ¼ãƒ“ã‚¹ã¯ã‚¨ãƒ©ãƒ¼ã ã‚‰ã‘ã§ä¸€åˆ»ã‚’äº‰ã†çŠ¶æ…‹ã§ã™ã€‚ (å¯¾å¿œé–‹å§‹) ã¾ãšã¯ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ ä»Šå›žã®æ§˜ãªå ´åˆã¯ã‚¢ãƒ—ãƒªã®ã‚¨ãƒ©ãƒ¼ãƒã‚°ã«ã©ã°ã£ã¨ MySQL ã«é–¢ã™ã‚‹ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ã¾ãšã¯ãã‚Œã‚’è¦‹ã‚‹ã“ã¨ãŒå§‹ã¾
tksmd 2011/12/05
MySQL ã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°

MySQL
ãƒªãƒ³ã‚¯
MySQL :: MySQL 5.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« (ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ˜ãƒ«ãƒ—) :: 6.3.1.1 TIMESTAMP ã®ç‰¹æ€§
TIMESTAMP ã‚«ãƒ©ãƒ ã¯ DATETIME ã‚«ãƒ©ãƒ ã¨åŒã˜ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã§è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚è¨€ã„æ›ãˆã‚‹ã¨ã€è¡¨ç¤ºå¹…ã¯ 19 æ–‡å—ã«æ±ºã‚ã‚‰ã‚Œã¦ã„ã¦ã€å½¢å¼ã¯ 'YYYY-MM-DD HH:MM:SS' ã§ã™ã€‚ TIMESTAMP åž‹ã®å€¤ã¯ã€æ ¼ç´ã™ã‚‹ã¨ãã«ç¾åœ¨ã®ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ã‹ã‚‰ UTC ã«å¤‰æ›ã•ã‚Œã€å–ã‚Šå‡ºã™ã¨ãã« UTC ã‹ã‚‰ç¾åœ¨ã®ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ã«å¤‰æ›ã•ã‚Œã¾ã™ã€‚(ã“ã®å¤‰æ›ãŒè¡Œã‚ã‚Œã‚‹ã®ã¯ã€TIMESTAMP ãƒ‡ãƒ¼ã‚¿åž‹ã®å ´åˆã ã‘ã§ã€DATETIME ãªã©ã®ã»ã‹ã®ãƒ‡ãƒ¼ã‚¿åž‹ã§ã¯è¡Œã‚ã‚Œã¾ã›ã‚“ã€‚)ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ã€æŽ¥ç¶šã”ã¨ã®ç¾åœ¨ã®ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ã¯ã‚µãƒ¼ãƒãƒ¼ã®æ™‚åˆ»ã§ã™ã€‚ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ã®è¨å®šã¯ã€MySQL Server Time Zone Supportã«èª¬æ˜Žã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã«ã€æŽ¥ç¶šã”ã¨ã«è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³è¨å®šãŒä¸€å®šã§ã‚ã‚‹ã‹ãŽã‚Šã€æ ¼ç´ã—ãŸå€¤ã¨åŒã˜å€¤ã‚’å¾©å¸°ã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚TIMESTAMP å€¤ã‚’æ ¼ç´ã—ãŸã‚ã¨ã§ã€
tksmd 2011/11/28
Timestamp ã‚«ãƒ©ãƒ ã®ç‰¹æ€§

MySQL
ãƒªãƒ³ã‚¯
MySQL :: MySQL 5.1 Reference Manual :: 21.4.4.1 Driver/Datasource Class Names, URL Syntax and Configuration Properties for Connector/J
Section Navigation Â Â Â Â Â [Toggle] 21.4.4 Connector/J (JDBC) Reference21.4.4.1 Driver/Datasource Class Names, URL Syntax and Configuration Properties for Connector/J 21.4.4.2 JDBC API Implementation Notes 21.4.4.3 Java, JDBC and MySQL Types 21.4.4.4 Using Character Sets and Unicode 21.4.4.5 Connecting Securely Using SSL 21.4.4.6 Using Master/Slave Replication with ReplicationConnection 21.4.4.7 Mapp
tksmd 2011/11/28
MySQL 5.1 ã® JDBC ãƒ‰ãƒ©ã‚¤ãƒã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹

MySQL

Java
ãƒªãƒ³ã‚¯
MySQL DATETIME vs TIMESTAMP
TIMESTAMP : Very importan it stores the number of milliseconds that have been elapsed Since 1st January 1970 GMT. 1)When you are inserting a DATE value into the MYSQL TIMESTAMP TIMESTAMP values are converted from the current time zone to UTC for storage,(i.e it will store the number of milliseconds elapsed from 1st January 1970) and converted back from UTC to the current time zone for retrieval. (
tksmd 2011/11/25
datetime ã¨ timestamp ã®é•ã„

MySQL
ãƒªãƒ³ã‚¯
DeNAãŒç¤¾å†…åˆ©ç”¨ã—ã¦ã„ã‚‹MySQLã®è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ãƒ„ãƒ¼ãƒ«ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹é–‹å§‹
MySQLãŒãƒ€ã‚¦ãƒ³ã—ãŸã¨ãã«è‡ªå‹•çš„ã«åˆ¥ã®MySQLã¸å‡¦ç†ã‚’å¼•ãç¶™ãã“ã¨ã§ã€é«˜å¯ç”¨æ€§ã‚’å®Ÿç¾ã™ã‚‹ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ãƒ„ãƒ¼ãƒ«ã€ŒMySQL-MHA: MySQL Master High Availability manager and toolsã€ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦å…¬é–‹ã•ã‚ŒãŸã“ã¨ã‚’ã€ä½œè€…ã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ãŒãƒ–ãƒã‚°ã§ä¼ãˆã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Announcing MySQL-MHA: "MySQL Master High Availability manager and tools" æ¾ä¿¡æ°ã¯ãƒ¢ãƒã‚²ãƒ¼ãªã©ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã«å‹¤å‹™ã—ã¦ãŠã‚Šã€MySQL-MHAã«ã‚ˆã‚‹è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼æ©Ÿèƒ½ã¯DeNAã®ã‚¤ãƒ³ãƒ•ãƒ©é‹ç”¨ã‚’æ”¯ãˆã¦ã„ã‚‹ã¨ã®ã“ã¨ã€‚åŒæ°ã®ãƒ–ãƒã‚°ã‹ã‚‰å¼•ç”¨ã—ã¾ã™ã€‚ Difficulties of master failover is one of
tksmd 2011/08/04
DeNA ã§å®Ÿé‹ç”¨ã•ã‚Œã¦ã„ã‚‹ MySQL ã®è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ãƒ„ãƒ¼ãƒ«

MySQL

Availability
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
tksmd 2011/06/29
PostgreSQL ã¨ MySQL ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ¯”è¼ƒ

PostgreSQL

MySQL
ãƒªãƒ³ã‚¯
mysqlã‚³ãƒžãƒ³ãƒ‰ã‚’ã‚ˆã‚Šä¾¿åˆ©ã«å®‰å…¨ã«ã™ã‚‹ãŸã‚ã®å°ç²’ãªTIPSé›†ï½œã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆ å…¬å¼ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
åˆã‚ã¾ã—ã¦ã€‚2010å¹´ã®3æœˆã«å…¥ç¤¾ã—ãŸ oinume ã§ã™ã€‚æ–°å¹´1æœˆã‹ã‚‰ã‚¦ã‚£ãƒ«ã‚¹æ€§èƒƒè…¸ç‚Žã«ç½¹ã‚ŠãªãŒã‚‰ã‚‚ãªã‚“ã¨ã‹ã“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’æ›¸ã„ã¦ã„ã¾ã™ã€‚ä»Šå›žã¯ã€mysqlã‚³ãƒžãƒ³ãƒ‰ã«é–¢ã™ã‚‹è‡ªåˆ†ãŒä»Šã¾ã§å¦ã‚“ã ï¼†æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸç´°ã‹ã„å®Ÿè·µçš„ãªTIPSã‚’ç´¹ä»‹ã—ã¾ã™ã€‚å°ç²’ã§ã™ãŒä½•ã‹ã®å½¹ã«ç«‹ã¦ã°å¹¸ã„ã§ã™ã€‚ edit (Â¥e)ã‚³ãƒžãƒ³ãƒ‰ mysqlãƒ—ãƒãƒ³ãƒ—ãƒˆã«ã„ãªãŒã‚‰ä»»æ„ã®ã‚¨ãƒ‡ã‚£ã‚¿ã§SQLãŒç·¨é›†ã§ãã¡ã‚ƒã„ã¾ã™ã€‚å…·ä½“çš„ã«ã¯ã€mysqlã‚³ãƒžãƒ³ãƒ‰ã§ãƒ—ãƒãƒ³ãƒ—ãƒˆå¾…ã¡ã®çŠ¶æ…‹ã§ mysql> edit ã®ã‚ˆã†ã« edit ã¾ãŸã¯ Â¥e ã¨å…¥åŠ›ã™ã‚‹ã¨ã€ç’°å¢ƒå¤‰æ•°EDITORã§è¨å®šã—ã¦ã‚ã‚‹ã‚¨ãƒ‡ã‚£ã‚¿ãŒç«‹ã¡ä¸ŠãŒã‚ŠSQLãŒç·¨é›†å¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ç·¨é›†ãŒçµ‚ã‚ã£ãŸã‚‰ã‚¨ãƒ‡ã‚£ã‚¿ã‚’çµ‚äº†ã—ã¦ ; ã¨ã‚„ã‚Œã°SQLãŒå®Ÿè¡Œã•ã‚Œã¾ã™ã€‚viãªã©ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã§å‹•ãã‚¨ãƒ‡ã‚£ã‚¿ã«æ…£ã‚Œã¦ã„ã‚‹äººã¯é•·ã„SQLã‚’ç·¨é›†ã™ã‚‹æ™‚ã«é‡å®ã™ã‚‹æ©Ÿèƒ½ã§ã—ã‚‡ã†ã€‚ã“ã®æŠ€ã¯å‰è·ã®åŒåƒšã«æ•™ãˆã¦ã‚‚ã‚‰ã£ã¦ã€ä»¥é™ä¾¿
tksmd 2011/01/20
DB

MySQL
ãƒªãƒ³ã‚¯
NoSQLã¨ã—ã¦MySQLã‚’ä½¿ã†DeNAãŒã€memcachedã‚ˆã‚Šã‚‚é«˜é€Ÿãª75ä¸‡ã‚¯ã‚¨ãƒªï¼ç§’ã‚’å®Ÿç¾
ãƒ¢ãƒã‚²ãƒ¼ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã¯ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«NoSQLã‚’ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ãªãœã‹ï¼Ÿ ãã‚Œã¯MySQL/InnoDB 5.1ã®ç’°å¢ƒã§ç§’é–“75ä¸‡ã‚¯ã‚¨ãƒªã¨ã„ã†ã€å¤šãã®NoSQLã§ã‚‚å®Ÿç¾ã§ããªã„ã‚ˆã†ãªé«˜æ€§èƒ½ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã‹ã‚‰ã€‚DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ã¯ã€è‡ªèº«ã®ãƒ–ãƒã‚°ã«ã“ã‚“ãªå†…å®¹ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒUsing MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity serverã€ï¼ˆè‹±èªžï¼‰ã‚’ãƒœã‚¹ãƒˆã—ã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server æ¾ä¿¡æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€å¤§è¦æ¨¡ãªãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ä¼æ¥ã®å¤šãã¯åˆ†æ•£ç’°å¢ƒã§
tksmd 2010/10/27
MySQL ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã€memcached ã‚ˆã‚Šã‚‚é«˜é€Ÿãªã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆã‚’ DeNA ãŒå®Ÿç¾ã—ã¦ã„ã‚‹è©±ã®ã¾ã¨ã‚

MySQL

Archetecture

NoSQL
ãƒªãƒ³ã‚¯
MySQLã®å°†æ¥ãŒå¿ƒé…ãªã®ã§ã€ï¼ˆãŸã¶ã‚“ï¼‰æ—¥æœ¬ä¸€ã®MySQLã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã€Œæ—¥æœ¬ç”·å…ã€ã«èžã„ã¦ã¿ãŸ
ã‚ªãƒ©ã‚¯ãƒ«ã¯ã€ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã‚’è²·åŽå¾Œã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦æä¾›ã•ã‚Œã¦ã„ãŸOpenSolarisã‚’äº‹å®Ÿä¸Šçµ‚äº†ã—ã€ã¾ãŸã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦Androidã‚’æä¾›ã—ã¦ã„ã‚‹ã‚°ãƒ¼ã‚°ãƒ«ã«å¯¾ã—ã¦ã€ŒJavaã¨ç«¶åˆã™ã‚‹ã€ã¨ã„ã†ç†ç”±ã§è¨´è¨Ÿã‚’èµ·ã“ã™ãªã©ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«å¯¾ã—ã¦éžå”åŠ›çš„ã¨è¦‹ãˆã‚‹è¡Œå‹•ãŒç¶šã„ã¦ã„ã¾ã™ã€‚ ã“ã†ãªã‚‹ã¨ã€åŒç¤¾ãŒä¿æœ‰ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®MySQLã®ä»Šå¾Œã¯å¤§ä¸ˆå¤«ãªã®ã‹æ‡¸å¿µã•ã‚Œã¾ã™ã€‚ã™ã§ã«MySQLã®ã‚³ã‚¢ãªé–‹ç™ºè€…ã®ä½•äººã‹ã¯åŒç¤¾ã‚’åŽ»ã‚Šã€MariaDBã‚„Drizzleã¨ã„ã£ãŸã»ã‹ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å–ã‚Šçµ„ã‚“ã§ã‚‚ã„ã¾ã™ã€‚ä»Šå¾Œã€MySQLã®é–‹ç™ºãŒå¼±ä½“åŒ–ã—ãŸã‚Šã€æ–¹å‘è»¢æ›ã—ã¦Solarisã®ã‚ˆã†ã«ã‚¯ãƒãƒ¼ã‚ºãƒ‰ã«ãªã£ãŸã‚Šã™ã‚‹ã“ã¨ã¯ãªã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã“ã§MySQLã®ã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã¨ã—ã¦ãƒ–ãƒã‚°ã€Œæ¼¢ï¼ˆã‚ªãƒˆã‚³ï¼‰ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“ã€ã‚’åŸ·ç†ã™ã‚‹ãƒ–ãƒã‚¬ãƒ¼ã€Œ@nippondanjiã€ã§ã‚ã‚Šã€ã‹ã¤æ—¥æœ¬ã‚ª
tksmd 2010/09/18
MySQL ã®å°†æ¥ã«ã¤ã„ã¦ã€‚ãƒˆãƒ©ã‚·ãƒ¥ãƒ¼ã®æ›¸ç±ãŒæ°—ã«ãªã‚‹ã€‚

DB

MySQL
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: blockdiff ã‚’ä½¿ã£ãŸãŠæ‰‹è»½ãƒ›ãƒƒãƒˆãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ç’°å¢ƒã®æ§‹ç¯‰ (Linux, MySQL, etc.)
ä¸€æ˜¨æ—¥ã«é–‹å‚¬ã•ã‚ŒãŸ hbstudy #7 ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®è©±ã‚’èžãã«è¡Œã£ã¦ãã¾ã—ãŸã€‚Amanda ã‚’ä¸å¿ƒã«ã—ãŸè©±ã§ã€ã¨ã¦ã‚‚å‹‰å¼·ã«ãªã‚Šã¾ã—ãŸã€‚ãŒã€è¨å®šãŒã‚ã‚“ã©ãã•ãã†ã ãªãã€ã¨ã‚‚ã€‚è‡ªåˆ†ã®éœ€è¦ã«ã¯ã‚ã‚ãªã„æ„Ÿã˜ã§ã—ãŸã€‚ å‹‰å¼·ä¼šãŒçµ‚ã‚ã£ãŸã‚ã¨ã§ã€è‡ªä½œã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚¹ã‚¯ãƒªãƒ—ãƒˆ blockdiff ã«é–¢ã™ã‚‹è©±ã‚’ä½•äººã‹ã®æ–¹ã¨ã•ã›ã¦ã„ãŸã ã„ãŸã®ã§ã™ãŒã€æ€ã„ã®ã»ã‹åå¿œãŒè‰¯ã‹ã£ãŸã®ã§ã€ã‚ã‚‰ãŸã‚ã¦ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ blockdiff ã¯ã€ä¸€è¨€ã§ã„ã†ã¨ã€ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚rsnapshot ã«ä¼¼ã¦ã„ã¾ã™ãŒã€rsnapshot ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ›ãƒƒãƒˆãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ä¸å¯èƒ½ã§ã™ã€‚é€†ã« blockdiff ã¯ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªå˜ä½ã§ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã«ã¯å¯¾å¿œã—ã¦ã„ãªã„ã‹ã‚ã‚Šã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã€ä¸€è²«æ€§ã‚’ä¿ã¡ã¤ã¤å®Ÿè³ªç„¡åœæ¢ã§å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™
tksmd 2010/01/19
blockdiff ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«

MySQL

DB
ãƒªãƒ³ã‚¯
å®ŸéŒ²ã€ã»ã¼ç„¡åœæ¢ãªMySQLã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒ (å‹•ç”»ã‚‚ã‚ã‚‹ã‚ˆ) - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ ã§ã‚‚æŽ²ã’ãŸã‚´ãƒ¼ãƒ«ã§ã‚ã‚‹ã€ã€Œãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ã€ãŒã»ã¼ã§ããŸã®ã§ã€ã»ã¨ã‚“ã©ã‚µãƒ¼ãƒ“ã‚¹ãŒåœæ¢ã™ã‚‹ã“ã¨ãªãã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã™ã‚‹æ§˜ã‚’ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚ãƒ£ã‚¹ãƒˆã«åŽã‚ã¾ã—ãŸã€‚ åŸ‹ã‚è¾¼ã¿ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã ã¨ã€å°ã•ãã¦ã‚ã‹ã‚‰ãªã„ã¨æ€ã†ã®ã§ã€ãƒªãƒ³ã‚¯ç›´æŽ¥ã§ã¿ã¦ãã ã•ã„ã€‚ http://www.irori.org/pub/mysql-mm.mov ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆ ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆã¯2å°ã€db 901ã¨db902ã§ã™ã€‚ æœ€åˆã¯ã€db 901ãŒæ›´æ–°ç³»ã‚¯ã‚¨ãƒªã‚’å—ã‘ã‚‹ãƒ—ãƒ©ã‚¤ãƒžãƒªã§db900ã®æµ®å‹•IPã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ç”»é¢åˆ†å‰² ç”»é¢ã¯5åˆ†å‰²ã—ã¦ã„ã¾ã™ã€‚ å·¦ä¸Š = ã€Œselect sysdate(),@@server_idã€ã‚’db900ã«å¯¾ã—ã¦(sleep 1ã—ãªãŒã‚‰)å»¶ã€…ã¨å®Ÿè¡Œã—ã¾ãã‚Šã‚“ã å³ä¸Š = ping -n
tksmd 2009/11/15
MySQL å¾Œã§ã‚ˆã‚€

MySQL

DB

Clustering
ãƒªãƒ³ã‚¯
Sun Microsystemsã€PostgreSQLã‚³ãƒŸãƒƒãƒˆãƒ¡ãƒ³ãƒˆå¼·åŒ–ã¸ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
tksmd 2008/01/23
Solaris

DB

Postgres

MySQL
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬1å›žï¼šPostgreSQL ã¨ MySQL ã®ç´¹ä»‹ (1/4)
å…±ã«æœ¬é€£è¼‰åŸ·ç†é–‹å§‹æ™‚ç‚¹ã§ã®æœ€æ–°å®‰å®šãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã™ãŒã€ã‚ã‚‹ç‰¹å®šã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ç‰¹åŒ–ã—ãŸå†…å®¹ã‚’è¨˜è¿°ã™ã‚‹äºˆå®šã¯ãªã„ãŸã‚ã€åŸºæœ¬çš„ã«ã¯PostgreSQLã¯ãƒãƒ¼ã‚¸ãƒ§ãƒ³8.1ç³»ã€MySQLã¯ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.0ç³»ã®å†…å®¹ã¨ã—ã¦ã”ç†è§£ãã ã•ã„ã€‚ ã¾ãŸã€PostgreSQLï¼MySQLã¨ã‚‚ã«æ§˜ã€…ãªOSä¸Šã§å‹•ä½œå¯èƒ½ã§ã™ãŒã€ç‰¹ã«æ–ã‚Šã®ãªã„å ´åˆã¯Linuxç‰ˆã¨ãªã‚Šã¾ã™ã€‚ PostgreSQLã¯ã€1980å¹´é ƒã«UCBï¼ˆã‚«ãƒªãƒ•ã‚©ãƒ«ãƒ‹ã‚¢å¤§å¦ãƒãƒ¼ã‚¯ãƒ¬ã‚¤æ ¡ï¼‰ã®ç ”ç©¶ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ã¦é–‹ç™ºã•ã‚ŒãŸPOSTGRESã¨ã„ã†RDBMSãŒå‰èº«ã§ã™ã€‚ãã®å¾Œã€1995å¹´ã«åŒæ ¡ã®å¤§å¦é™¢ç”Ÿã«ã‚ˆã‚ŠPostgres95ã¨ã—ã¦ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã€ç¾åœ¨ã®é–‹ç™ºãƒãƒ¼ãƒ ã§ã‚ã‚‹The PostgreSQL Global Development GroupãŒã“ã®é–‹ç™ºã‚’å¼•ãç¶™ã„ã ã®ã¯1996å¹´ã§ã™ã€‚ãã®éš›ã«ã€åç§°ãŒPostgreSQLã«æ”¹åã•ã‚Œã€ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’å…¬é–‹ã—ã€ç¾åœ¨ã‚‚ã‚³ãƒŸ
tksmd 2007/11/13
æ¯”è¼ƒ

DB

Postgres

MySQL
ãƒªãƒ³ã‚¯
1