[B! mysql] hirose31ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hirose31 id:hirose31

mysqlã«é–¢ã™ã‚‹hirose31ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (356)

${{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 ã‚’ RDS for MySQL 8.0 ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã—ãŸè©± - Hatena Developer Blog
ã“ã®è¨˜äº‹ã¯ã€ã¯ã¦ãª ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ Advent Calendar 2023ã®2024å¹´1æœˆ17æ—¥ã®è¨˜äº‹ã§ã™ã€‚ ã¯ã¦ãª ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ Advent Calendar 2023 - Hatena Developer Blog id:hagihala ã§ã™ã€‚å…ˆæ—¥ã€ã¯ã¦ãªãƒ–ãƒã‚°ã® DB ã‚’ RDS for MySQL 5.7 ã‹ã‚‰ 8.0 ã¸ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã—ãŸã®ã§ã€å·¥å¤«ã—ãŸç‚¹ãªã©ã‚’å…±æœ‰ã—ã¾ã™ã€‚ Aurora MySQL 3.x ã«ã—ãªã‹ã£ãŸç†ç”± MySQL 5.7 -> 8.0 ã§å¯¾å¿œã—ãŸå¤‰æ›´ç‚¹ character set ã‚„ collation ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒå¤‰æ›´ã•ã‚Œã‚‹ explicit_defaults_for_timestamp ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æœ‰åŠ¹ã«ãªã‚‹ SQL mode ã®å¤‰æ›´ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®èªè¨¼ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ãŒ caching_sha2_password ã«ãªã‚Šã€ mysql_native_passw
hirose31 2024/01/22
mysql

mysql 8.0
ãƒªãƒ³ã‚¯
MySQLã®FLOATåž‹ã‚’ä½¿ã†ç†ç”±ãŒè¦‹ã¤ã‹ã‚‰ãªã„ä»¶ - hnwã®æ—¥è¨˜
MySQLã®ãƒ‡ãƒ¼ã‚¿åž‹ã¨ã—ã¦FLOATåž‹ã¨ã„ã†åž‹ãŒã‚ã‚‹ã®ã§ã™ãŒã€ã“ã‚Œã‚’æŽ¡ç”¨ã™ã‚‹ã®ã¯æ··ä¹±ã®å…ƒã§ã¯ãªã„ã‹ï¼Ÿã¨æ„Ÿã˜ãŸã®ã§ã€ãã®è©³ç´°ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãã‚‚ãã‚‚ã“ã®è©±ã®ãã£ã‹ã‘ã¯ã€ŒMySQLã§6æ¡ã¾ã§ã®å°æ•°ç‚¹ã‚’ä¸¸ã‚ãšã«æ‰±ã†ãªã‚‰FLOATåž‹ã‚’ä½¿ã†ã¹ãç†ç”±ã€ã¨ã„ã†è¨˜äº‹ãŒç›®ã«æ¢ã¾ã£ãŸã“ã¨ã§ã™ã€‚ãã‚Œãªã‚Šã«äººæ°—ã‚’é›†ã‚ã¦ã„ã‚‹è¨˜äº‹ã®ã‚ˆã†ã§ã™ãŒã€ç§ã®èªã‚“ã é™ã‚Šã§ã¯FLOATåž‹ã‚’ä½¿ã†ã ã‘ã®æ ¹æ‹ ãŒæ–‡ä¸ã‹ã‚‰èªã¿å–ã‚Œãšã€ã•ã‚‰ã«é¡žä¼¼ã™ã‚‹ä¸€æ¬¡æƒ…å ±ã‚„è‹±èªžè¨˜äº‹ãŒå…¨ãè¦‹ã¤ã‹ã‚‰ãªã‹ã£ãŸã®ã§ã€çœŸå½ãŒæ€ªã—ã„æƒ…å ±ã ã¨æ„Ÿã˜ã¾ã—ãŸã€‚ ãã®å¾Œã€MySQLä¸Šã§å®Ÿé¨“ã—ãŸã‚ŠCã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã¿ãŸã‚Šã—ãŸçµæžœã€ç§ã®å¾—ãŸçµè«–ã¯çœŸé€†ã®ã‚‚ã®ã«ãªã‚Šã¾ã—ãŸã€‚MySQLè¦å¯Ÿã®æ–¹ã‚„æµ®å‹•å°æ•°ç‚¹æ•°è¦å¯Ÿã®æ–¹ã€è¿½è©¦ã‚„åè«–ãªã©é ‚ã‘ã‚‹ã¨åŠ©ã‹ã‚Šã¾ã™ã€‚ MySQLã®FLOATåž‹ã¨ã¯ MySQLã®FLOATåž‹ã¯åŽŸå‰‡ã¨ã—ã¦IEEE754æµ®å‹•å°æ•°ç‚¹æ•°å˜ç²¾åº¦åž‹ï¼ˆ32bitï¼‰ã§å®Ÿç¾ã•ã‚Œã¾ã™*1ã€‚
hirose31 2023/10/25
mysql

float

double
ãƒªãƒ³ã‚¯
How to drop a 1000+ databases with innodb_file_per_table=1 without hanging the MySQL process?
hirose31 2020/11/06
mysql
ãƒªãƒ³ã‚¯
yoku0825 on Twitter: "@songmu InnoDBã®å ´åˆã€ŒDROPå¯¾è±¡ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ç´ã¥ããƒšãƒ¼ã‚¸ã‚’å…¨ã¦ã€ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã‹ã‚‰è¿½ã„å‡ºã™å‡¦ç†ãŒç™ºç”Ÿã™ã‚‹ã®ã§çµæ§‹é‡ã„å‡¦ç†ã§ã™ï¼ ï¼ˆãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã®ã‚µã‚¤ã‚ºã‚„ãƒšãƒ¼ã‚¸ãŒã©ã‚Œãã‚‰ã„è¼‰ã£ã¦ã‚‹ã‹ã«ã‚‚ã‚ˆã‚Šã¾ã™"
@songmu InnoDBã®å ´åˆã€ŒDROPå¯¾è±¡ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ç´ã¥ããƒšãƒ¼ã‚¸ã‚’å…¨ã¦ã€ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã‹ã‚‰è¿½ã„å‡ºã™å‡¦ç†ãŒç™ºç”Ÿã™ã‚‹ã®ã§çµæ§‹é‡ã„å‡¦ç†ã§ã™ï¼ ï¼ˆãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã®ã‚µã‚¤ã‚ºã‚„ãƒšãƒ¼ã‚¸ãŒã©ã‚Œãã‚‰ã„è¼‰ã£ã¦ã‚‹ã‹ã«ã‚‚ã‚ˆã‚Šã¾ã™
hirose31 2020/11/06
mysql
ãƒªãƒ³ã‚¯
MySQLã®æ—¥æœ¬èªžã‚³ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ - tmtms ã®ãƒ¡ãƒ¢
4æœˆã«MySQLã®æ—¥æœ¬èªžã‚³ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦èªžã‚Šåˆã†å ´ã«å‘¼ã°ã‚Œã¦ã„ã‚ã„ã‚è©±ã‚’èžã„ã¦ãã¾ã—ãŸã€‚ã™ãã«ãƒ–ãƒã‚°ã‚’æ›¸ã“ã†ã¨æ€ã£ãŸã‚“ã§ã™ãŒã€ã¯ã‚„2ãƒ¶æœˆçµŒéŽâ€¦ã€‚ ã¨ãã©ãã€è‡ªåˆ†ãŒMySQLã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã«é–¢ã—ã¦ç™ºè¡¨ã™ã‚‹éš›ã«ã€æ¬¡ã®ã‚ˆã†ãªã‚¹ãƒ©ã‚¤ãƒ‰ã‚’ã„ã‚Œã¦ã‚‹ã‚“ã§ã™ãŒã€ MySQL 8.0 ã§ã¨ã†ã¨ã†æ—¥æœ¬èªžã‚³ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒå…¥ã‚‹ã“ã¨ã«ãªã£ãŸã®ã«ã€ãªã‚“ã‹æœŸå¾…ã—ã¦ãŸã®ã¨é•ã„ã¾ã—ãŸã€‚ ã§ã€ãã®è¾ºã®è©±ã‚’èžãã¾ã—ãŸï¼ˆ2ãƒ¶æœˆã‚‚çµŒã£ã¦ã‚‹ã®ã§ã†ã‚è¦šãˆï¼‰ã€‚ Q. ã‚ã–ã‚ã–æ—¥æœ¬èªžãƒã‚±ãƒ¼ãƒ«ä½œã‚‹ã‚“ã ã£ãŸã‚‰æ—¥æœ¬äººãŒæ‰±ã„ã‚„ã™ã„ãƒã‚±ãƒ¼ãƒ«ã«ã—ã¦ã»ã—ã„ utf8mb4_ja_0900_as_csã¯MySQLãŒç‹¬è‡ªã«è€ƒãˆãŸã‚‚ã®ã§ã¯ãªã„ã€‚Unicodeè¦æ ¼ã«å¾“ã£ã¦ã„ã‚‹ã€‚éŽåŽ»ã«ã„ã‚ã„ã‚ç‹¬è‡ªã«ã‚„ã£ã¦å¤±æ•—ã—ã¦ãã¦ã‚‹ã®ã§ã€ã‚‚ã†ç‹¬è‡ªã«ã‚„ã‚‹ã®ã¯é¿ã‘ãŸã„ã€‚ ai(accent insensitive)ã§ã€Œãƒã€=ã€Œãƒ‘ã€=ã€Œãƒã€ã«ãªã‚‹ã®ã‚‚ã€ci(case insensi
hirose31 2019/12/03
collation

mysql

mysql 5.7
ãƒªãƒ³ã‚¯
MySQLã®æ–‡å—ã‚³ãƒ¼ãƒ‰äº‹æƒ… 2017æ˜¥ç‰ˆ
15. MySQLã®CharsetMySQLã®Charset mysql> SHOW CHARACTER SET; +----------+---------------------------------+---------------------+------- | Charset | Description | Default collation | Maxlen +----------+---------------------------------+---------------------+------- | big5 | Big5 Traditional Chinese | big5_chinese_ci | 2 | dec8 | DEC West European | dec8_swedish_ci | 1 | cp850 | DOS West European | cp
hirose31 2019/12/03
collation

mysql

mysql 5.7
ãƒªãƒ³ã‚¯
Storage options Â |Â Compute Engine Documentation Â |Â Google Cloud
Send feedback Storage options Stay organized with collections Save and categorize content based on your preferences. To add disks to your VMs, choose one of the block storage options Compute Engine offers. Each of the following storage options has unique price and performance characteristics: Google Cloud Hyperdisk volumes are network storage for Compute Engine, with configurable performance and v
hirose31 2019/08/22
mysql

gcp
ãƒªãƒ³ã‚¯
MySQL :: MySQL Documentation Archive
MySQL Reference Manual Archive Language Title Version PDF HTML Download
hirose31 2016/07/12
old reference manual

mysql
ãƒªãƒ³ã‚¯
MySQL Bug #79977 "utf8mb4_unicode_520_ci don't make sense for Japanese FTS" ã§è¨€ã„ãŸã„ã“ã¨
MySQL Bug #79977 "utf8mb4_unicode_520_ci don't make sense for Japanese FTS" ã§è¨€ã„ãŸã„ã“ã¨ è‹±èªžã§æ›¸ã„ã¦ãŸã‚‰è‡ªåˆ†ã§ã‚‚ã‚ˆãã‚ã‹ã‚‰ãªããªã£ã¦ããŸã®ã§ã€‚ MySQL Bugs: #79977: utf8mb4_unicode_520_ci don't make sense for Japanese FTS * æœ¬è³ªçš„ã«ã¯Â MySQL Bugs: #76553: Sushi-Beer issue of MySQL with utf8mb4Â ã®é–¢é€£ã€‚ * Unicodeå®Ÿè£…ãŒä¸å®Œå…¨ã ã‹ã‚‰èµ·ã“ã£ã¦ã„ã‚‹å•é¡Œã€‚ * ä¸¸ã‚å•é¡Œ * motherã‚’æ„å‘³ã™ã‚‹æ›¸ãæ–¹ã«ã€ã¯ã¯ï¼ˆã²ã‚‰ãŒãªï¼‰ã¨ãƒãƒï¼ˆã‚«ã‚¿ã‚«ãƒŠï¼‰ã¨ï¾Šï¾Šï¼ˆåŠè§’ã‚«ã‚¿ã‚«ãƒŠï¼‰ãŒã‚ã£ã¦ã€ * ã“ã‚Œã‚‰ã¯ï¼ˆæ–‡å—ã®å½¢ã¯é•ã†ã‘ã©ï¼‰åŒã˜éŸ³ã§åŒã˜æ„å‘³ã ã‹ã‚‰ã€å¤§æ¦‚ã®å ´åˆåŒã˜æ–‡å—ã¨ã—ã¦æ‰±ã£ã¦ãã‚Œã‚‹ã¨å¬‰ã—ã„ã€‚
hirose31 2016/01/18
mysql

mysql 5.7
ãƒªãƒ³ã‚¯
MySQL 5.7ã®ã€Œç½ ã€ã«ç‹™ã‚ã‚Œã¦ã‚‚ã‚„ã‚‰ã‚Œãªã„ãŸã‚ã® - Qiita Advent Calendar 2015 - Qiita
ã€Œ ç½ ã€ã§ãŠãªã˜ã¿MySQL 5.7ãŒ2015å¹´10æœˆã«æ™´ã‚Œã¦GAã¨ãªã‚Šã¾ã—ãŸ 25æ—¥é–“ã€Œç½ ã€ã«ã¤ã„ã¦ä¸€äººå¯‚ã—ãã¤ã¥ã‚‹Advent Calendarã§ã™ã€‚ å¤§åŠãŒ @yoku0825 ã® ãƒ–ãƒã‚° ã¸ã®ãƒªãƒ³ã‚¯ã«ãªã‚‹ã®ã¯æƒ³å®šã•ã‚ŒãŸäº‹æ…‹ã§ã™ã€‚ 1æ—¥1ã¤ãšã¤ã€Advent Calendarã®ã‚³ãƒ¡ãƒ³ãƒˆæ¬„(æœ€å¤§127æ–‡å—ã‚‰ã—ã„)ã«ç½ ã‚’ã¤ã¥ã£ã¦ã„ãã¾ã™ã€‚(c) @yoku0825 ãŸã¶ã‚“127æ–‡å—ã¯è¶…ãˆã¾ã›ã‚“ã€‚
hirose31 2015/12/25
mysql

mysql 5.7
ãƒªãƒ³ã‚¯
doc/innodb.md at master Â· ichirin2501/doc
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
hirose31 2015/12/08
lock

mysql

innodb
ãƒªãƒ³ã‚¯
5.6 ä»¥å‰ã® InnoDB Flushing
Bind Peek ã‚’ã‚‚ã£ã¨ä½¿ãŠã†ãœï¼(æŸ´ç”° æ©) - JPOUG Advent Calendar 2014(Day 5) -æ© æŸ´ç”°
hirose31 2015/12/03
mysql

mysql 5.6

mysql 5.7

innodb
ãƒªãƒ³ã‚¯
æŒ¿å…¥ã¨å‚ç…§ãƒãƒƒã‚¯ã«ç–²ã‚Œæžœã¦ãŸä¿ºãŸã¡ã¯ - ichirin2501's diary
ãªã‹ã£ãŸã‚‰INSERTã—ãŸã„ã—ã€ã‚ã‚‹ãªã‚‰ãƒãƒƒã‚¯å–ã‚ŠãŸã„ã‚„ã‚“? from ichirin2501 www.slideshare.net å‡ºæ¥äº‹ @ichirin2501 ã¨ã‚Šã‚ãˆãšä½•ã‚‚è€ƒãˆãšã“ã®å‰ã®ãƒãƒƒã‚¯ã®è©±ã‚’Slideshareã«ã‚ã’ã¦ãã‚Œï¼ï¼â€” æŸ´å´Žå„ªå£ (@shiba_yu36) 2015, 8æœˆ 22 ã¯ã˜ã‚ã« ã“ã‚Œã¯å…ˆæ—¥ã®ç¤¾å†…å‹‰å¼·ä¼šã§ç™ºè¡¨ã—ãŸã‚‚ã®ã§ã€MySQLã§ç‰¹å®šã®å•é¡Œã‚’è§£æ±ºã—ãŸã„ã¨ãã®ãƒŽã‚¦ãƒã‚¦è©±ã§ã™ã€‚ç‰¹å®šã®å•é¡Œã¨ã¯ã€ã‚¢ãƒ—ãƒªã‚’æ›¸ã„ã¦ã‚‹ã¨ã€Œãƒ‡ãƒ¼ã‚¿ãŒãªã‹ã£ãŸINSERTã—ãŸã„ã€ã‚ã‚‹ãªã‚‰æŽ’ä»–ãƒãƒƒã‚¯ã—ã¤ã¤å–å¾—ã—ãŸã„ã€ã¨ã„ã†è¦æœ›ãŒã‚ã£ãŸã‚Šã—ã¾ã™ã€‚ä¾‹ãˆã°ã€ã‚ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã§åˆæœŸå€¤ã‚‚ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã§æ¸¡ã•ã‚Œã‚‹ã‚±ãƒ¼ã‚¹ã§ã€ãƒ‡ãƒ¼ã‚¿ãŒãªã„ãªã‚‰ãã®ã¾ã¾INSERTã€æ—¢ã«ãƒ‡ãƒ¼ã‚¿ãŒã‚ã‚‹ãªã‚‰å–å¾—ã—ã¦çŠ¶æ…‹ã«ä¾å˜ã—ã¦æ›´æ–°å‡¦ç†ã‚’è¡Œã„ãŸã„å ´åˆãªã©ã§ã™ã€‚è¦‹ã‹ã‘ã®ãƒã‚¸ãƒƒã‚¯ã¯å˜ç´”ã«è¦‹ãˆã¾ã™ãŒã€MySQLã§ã“ã‚Œã‚’å®Ÿç¾ã—ã‚ˆã†
hirose31 2015/08/24
gap lock

mysql
ãƒªãƒ³ã‚¯
GitHub - dbcli/mycli: A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.
$ mycli --help Usage: mycli [OPTIONS] [DATABASE] A MySQL terminal client with auto-completion and syntax highlighting. Examples: - mycli my_database - mycli -u my_user -h my_host.com my_database - mycli mysql://my_user@my_host.com:3306/my_database Options: -h, --host TEXT Host address of the database. -P, --port INTEGER Port number to use for connection. Honors $MYSQL_TCP_PORT. -u, --user TEXT Use
hirose31 2015/07/31
mysql
ãƒªãƒ³ã‚¯
MySQLã®æ—¥æœ¬èªžã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã€5.6 ã¨ãã®ä¸ã®ã„ãã¤ã‹ã®é‡è¦ãªãƒªãƒ³ã‚¯ : logicalã€€error
ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã¯æœ€æ–°ãŒ 5.7 ã§ã€è‹±æ–‡ã®ã¿ã§ã™ãŒã€5.6 ã¯æ—¥æœ¬èªžç‰ˆãŒã‚ã‚Šã¾ã™ ã‚¢ãƒ¼ã‚«ã‚¤ãƒ– æ—¥æœ¬èªžã® 5.1 ã¨ 4.1 ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’ PDF ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰(è¡¨ç¤º)ã§ãã‚‹ã‚ˆã†ã§ã™ â–¼ ã‚ˆãä½¿ã†ã‚»ã‚¯ã‚·ãƒ§ãƒ³ ç¬¬13ç« SQL ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã®æ§‹æ–‡ â€» ã“ã¡ã‚‰ã‚‚é‡è¦ãªã®ã§ 4.5.1. mysql ï¼ MySQL ã‚³ãƒžãƒ³ãƒ‰è¡Œãƒ„ãƒ¼ãƒ« 4.5.4 mysqldump ï¼ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ—ãƒã‚°ãƒ©ãƒ â–¼ Windows ã® 5.6 ã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§ã™ http://winofsql.jp/mysqlhelp.txt â–¼ Windows ã® ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã§ã€SHIFT_JIS(cp932) ã«è¨å®šã•ã‚Œã¦ã„ã‚‹äº‹ã‚’ç¢ºèªã—ãŸå‡¦ç†ã§ã™ é–¢é€£ã™ã‚‹è¨˜äº‹ MySQL ã®ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã‹ã‚‰ã®å‡¦ç†ç”¨ãƒãƒƒãƒãƒ•ã‚¡ã‚¤ãƒ« ã©ã†ã—ã¦ã‚‚å½“æ™‚ã®ã‚ªãƒªã‚¸ãƒŠãƒ«ã‚’ç¢ºèªã—ãŸã„å ´åˆ WEB ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã‚ˆã‚Š http
hirose31 2015/04/20
mysql
ãƒªãƒ³ã‚¯
ã‚³ãƒ¼ãƒ‰ã§è¡Œã†MySQLã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆç®¡ç† - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã‚¤ãƒ³ãƒ•ãƒ©ã‚¹ãƒˆãƒ©ã‚¯ãƒãƒ£ãƒ¼éƒ¨ã®è…åŽŸï¼ˆ@sgwr_dts)ã§ã™ã€‚ ã‚¤ãƒ³ãƒ•ãƒ©ã‚¹ãƒˆãƒ©ã‚¯ãƒãƒ£ãƒ¼éƒ¨ã®ãƒ¡ãƒ³ãƒãƒ¼ã¯ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã®ãŸã‚å¼·åŠ›ãªæ¨©é™ã®MySQLã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ãŒã€ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºã‚’ã™ã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚‚æ¥å‹™ã®ãŸã‚ã«ã‚µãƒ¼ãƒ“ã‚¹ã®DBã®å‚ç…§ãƒ»æ›´æ–°æ¨©é™ã‚’æŒã£ãŸã‚¢ã‚«ã‚¦ãƒ³ãƒˆãŒå¿…è¦ã«ãªã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚„ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒŸã‚¹ã®ã“ã¨ã‚’è€ƒãˆã‚‹ã¨ã€ã™ã¹ã¦ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ã‚¹ãƒ¼ãƒ‘ãƒ¼ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã™ã‚‹ã‚ã‘ã«ã¯ã„ã‹ãªã„ãŸã‚ã€éƒ½åº¦é©åˆ‡ãªæ¨©é™ã‚’ä»˜ä¸Žã—ã¦ã„ã¾ã™ãŒã€æ‰‹å‹•ã§ã®ä½œæ¥ã¯åœ°å‘³ã«æ‰‹é–“ãŒã‹ã‹ã‚Šã¾ã™ã€‚ ãã“ã§ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã¯MySQLã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆæƒ…å ±ã‚’ã‚³ãƒ¼ãƒ‰åŒ–ã—ã€ãƒªãƒã‚¸ãƒˆãƒªã§ç®¡ç†ã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ gratanã«ã‚ˆã‚‹ã‚³ãƒ¼ãƒ‰åŒ– MySQLã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆç®¡ç†ã¯gratanã¨ã„ã†è‡ªä½œã®ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦è¡Œã£ã¦ã„ã¾ã™ã€‚ gratanã‚’ä½¿ã†ã¨MySQLã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’Rubyã®DSLã§è¨˜è¿°ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚
hirose31 2015/04/10
mysql
ãƒªãƒ³ã‚¯
MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é‹ç”¨ãŒåŠ‡çš„å¤‰åŒ–ï¼ï¼GTIDã«ã¤ã„ã¦ä»•çµ„ã¿ã‹ã‚‰ç†è§£ã™ã‚‹
ãƒ¡ãƒªãƒ¼ã‚¯ãƒªã‚¹ãƒžã‚¹ï¼ï¼ã‚„ã‚ã€è‰¯ã„åã®ã¿ã‚“ãªï¼ï¼ã‚µãƒ³ã‚¿ã‚¯ãƒãƒ¼ã‚¹ãƒ»ãƒ»ãƒ»ã§ã¯ãªãã€ãƒ’ã‚²ãƒ¢ã‚¸ãƒ£ã‚®ãƒ¼ã‚¯ã‹ã‚‰ã®ã‚¯ãƒªã‚¹ãƒžã‚¹ãƒ—ãƒ¬ã‚¼ãƒ³ãƒˆã ã‚ˆï¼ï¼ ã¨ã„ã†ã‚ã‘ã§ã€MySQL Casual Advent Calendarã®25æ—¥ç›®ã§ã‚ã‚‹ã€‚ä»ŠæœAdvent Calendarã‚’è¦—ã„ã¦ã¿ã‚‹ã¨ã€æœ¬æ—¥åˆ†ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ãŒç„¡ã‹ã£ãŸã®ã§ã€æ€¥é½æ›¸ãã“ã¨ã«ã—ãŸã€‚Advent Calendaræœ€å¾Œã®æ—¥ã€ã‚¯ãƒªã‚¹ãƒžã‚¹ã‚’é£¾ã‚‹è¨˜äº‹ã®ãƒ†ãƒ¼ãƒžã¯GTIDã ã€‚ å‰å›žã®æŠ•ç¨¿ã§ã¯ã€MySQL 5.6ã®ç›®çŽ‰æ©Ÿèƒ½ã¨ã—ã¦ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã«ãªã£ãŸã“ã¨ã‚’æŒ™ã’ãŸã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¾ã‚ã‚Šã§è¨€ãˆã°ã€ã‚‚ã†ã²ã¨ã¤å¤–ã›ãªã„ç›®çŽ‰æ©Ÿèƒ½ãŒã‚ã‚‹ã€‚ãã‚ŒãŒGTIDï¼ˆGlobal Transaction IDï¼‰ã§ã‚ã‚‹ã€‚ GTIDã¯è‰¯ãã‚‚æ‚ªãã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é‹ç”¨ã‚’å¤‰åŒ–ã•ã›ã‚‹ã€‚GTIDã‚’ä½¿ã†ã“ã¨ã«ã‚ˆã£ã¦å¾—ã‚‰ã‚Œã‚‹æœ€å¤§ã®ãƒ¡ãƒªãƒƒãƒˆã¯ã€CHANGE MASTER TOã§ãƒã‚¤ãƒŠãƒªãƒ
hirose31 2014/12/26
mysql

mysql 5.6
ãƒªãƒ³ã‚¯
ã¾ã MySQL 5.5ã§æ¶ˆè€—ã—ã¦ã‚‹ã®ï¼ŸMySQL 5.6ã§ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ´»ç”¨ã—ã¦æž•ã‚’é«˜ãã—ã¦çœ ã‚Œã‚‹æ—¥ã€…ã‚’æº€å–«ã™ã‚‹æ–¹æ³•
MySQL 5.6ãŒç™»å ´ã—ã¦ã‹ã‚‰ã‹ãªã‚Šã®æœˆæ—¥ãŒéŽãŽãŸãŒã€ä»–ã®ã“ã¨ã§å¤šå¿™ã ã£ãŸã›ã„ã‹ã€MySQL 5.6ã«ã¤ã„ã¦ã¯ã‚ã¾ã‚Šãƒ–ãƒã‚°ã§æƒ…å ±ã‚’ç™ºä¿¡ã—ã¦ã„ãªã„ã“ã¨ã«æ°—ãŒã¤ã„ãŸã€‚ã“ã‚Œã¯ã‚¤ã‚«ãƒ³ï¼ï¼ã¨æ€ã„ã€MySQL Casual Advent Calendar 2014ã«åˆã‚ã›ã¦ã€MySQL 5.6ã‚’ä½¿ç”¨ã™ã‚‹ä¸Šã§æœ€ã‚‚ã‚ªã‚¹ã‚¹ãƒ¡ã—ãŸã„æ©Ÿèƒ½ã§ã‚ã‚‹ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦è§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€‚ã“ã®è¨˜äº‹ã¯16æ—¥ç›®ã®è¨˜äº‹ã§ã‚ã‚‹ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã¨ã¯ã©ã†ã„ã†ã“ã¨ã‹ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã¨ã¯ã€ä½•ã‚‰ã‹ã®äº‹æƒ…ã«ã‚ˆã‚Šã€ãƒ—ãƒã‚»ã‚¹ãŒãƒ€ã‚¦ãƒ³ã—ãŸã‚Šãƒžã‚·ãƒ³ãŒé›»æºã”ã¨è½ã¡ãŸã‚Šï¼ˆã¤ã¾ã‚Šã‚¯ãƒ©ãƒƒã‚·ãƒ¥ï¼‰ã—ã¦ã‚‚ã€å†èµ·å‹•å¾Œã«ä»¥å‰ã®çŠ¶æ…‹ã«æˆ»ã£ã¦å‡¦ç†ã‚’å†é–‹ã§ãã‚‹ã¨ã„ã†ã“ã¨ã ã€‚ãƒ‡ãƒ¼ã‚¿ã®ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒªã§ã‚ã‚Œã°ã¿ãªã•ã‚“æ—¢ã«ã‚ˆãã”å˜çŸ¥ã§ã‚ã‚ã†ã€‚ï¼ˆREDOã‚„UNDOã™ã‚‹ã‚¢ãƒ¬ã®ã“ã¨ã ã€‚æœ¬ç¨¿ã§ã¯é¢å€’è‡ã„ãƒ»ãƒ»ãƒ»ã§ã¯ãªã‹ã£ãŸã€æœ¬é¡Œã§ã¯ãªã„ãŸ
hirose31 2014/12/16
mysql

mysql 5.6
ãƒªãƒ³ã‚¯
MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚Perconaã®ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã‚ˆã‚‹ã€MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®æ§˜ã€…ãªãƒ‘ã‚¿ãƒ¼ãƒ³ã¨ã€ãã®åˆ©ç‚¹ãƒ»æ¬ ç‚¹ã€æ‰‹é †ã®è§£èª¬ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—å®Ÿæ–½å‰ã®ã€äº‹å‰èª¿æŸ»ã¨ãƒ†ã‚¹ãƒˆãŒé‡è¦ã§ã‚ã‚‹ã¨ã®æŒ‡æ‘˜ã‚‚ã€‚ MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—(è¨³æ³¨ : åŽŸæ–‡ã§ã¯upgradeã€ä»¥ä¸‹åŒã˜)ã¯ã©ã“ã‹ã§å¿…è¦ã«ãªã‚‹ã‚¿ã‚¹ã‚¯ã ã—ã€æˆ‘ã€…Percona Supportã§ã‚‚MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã«ã¤ã„ã¦ã®è‰²ã€…ãªè³ªå•ã‚’å—ã‘ä»˜ã‘ã¦ã„ã‚‹ã€‚ã“ã®è¨˜äº‹ã§ã¯ã€è‰²ã€…ãªã‚·ãƒŠãƒªã‚ªã«ãŠã‘ã‚‹MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®æŽ¨å¥¨ã§ãã‚‹æ–¹æ³•ã«ç„¦ç‚¹ã‚’å½“ã¦ã¦ã¿ãŸã„ã€‚ MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã¯ãªãœå¿…è¦ã«ãªã£ã¦ã—ã¾ã†ã®ã‹ï¼Ÿãã®ç†ç”±ã¯è‰²ã€…ã ãŒã€æ–°æ©Ÿèƒ½ãŒå¿…è¦ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®æ”¹å–„ã€ãƒã‚°ä¿®æ£ãªã©ãŒã‚ã‚‹ã ã‚ã†ã€‚ã—ã‹ã—ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨çµ„ã¿åˆã‚ã›ãŸä¸Šã§äº‹å‰ã«åºƒç¯„å›²ãªãƒ†ã‚¹ãƒˆã‚’ã—ã¦ãŠã‹ãªã„ã¨ã€ãƒªã‚¹ã‚¯ã®å¤§ãã„
hirose31 2014/10/20
mysql
ãƒªãƒ³ã‚¯
å¤§è¦æ¨¡ç’°å¢ƒã§MySQLã®GTIDã‚’é©ç”¨ã—ã¦å¾—ã‚‰ã‚ŒãŸæ•™è¨“ | Yakst
MySQL 5.6ã‹ã‚‰ã®æ©Ÿèƒ½ã§ã‚ã‚‹GTIDã‚’ã€Facebookã®ç’°å¢ƒã«é©ç”¨ã—ãŸéš›ã®æµã‚Œã¨ä¸»ãªä¸å…·åˆã€ãã—ã¦ãã‚Œã‚‰ã®ä¿®æ£ç‚¹ã«ã¤ã„ã¦ã€Facebookã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã‚ˆã‚‹ã¾ã¨ã‚ã€‚ by Evan Elias and Santosh Praneeth Banda Global Transaction ID (GTID)ã¯ã€MySQL 5.6ã®æ–°æ©Ÿèƒ½ã®ä¸ã§ã‚‚æœ€ã‚‚ä½¿ã‚ãšã«ã¯ã„ã‚‰ã‚Œãªã„æ©Ÿèƒ½ã®ä¸€ã¤ã ã€‚ã“ã®ãŠã‹ã’ã§ã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã‚„ãƒã‚¤ãƒ³ãƒˆã‚¤ãƒ³ã‚¿ã‚¤ãƒ ãƒªã‚«ãƒãƒªã€éšŽå±¤ã‚’æŒã£ãŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãªã©ã«éžå¸¸ã«æœ‰ç›Šã ã—ã€ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ãªãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¿…é ˆæ¡ä»¶ã«ã‚‚ãªã£ã¦ã„ã‚‹ã€‚ã“ã®æ•°ãƒ¶æœˆã§ã€æˆ‘ã€…ã¯Facebookã®å…¨ã¦ã®æœ¬ç•ªç”¨MySQLã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã§ã€GTIDã‚’æœ‰åŠ¹ã«ã—ãŸã€‚ãã®ä¸ã§ã€ã“ã®æ©Ÿèƒ½ã®é©ç”¨æ–¹æ³•ã‚„æ“ä½œã«ã¤ã„ã¦ã€ãŸãã•ã‚“ã®çŸ¥è¦‹ãŒå¾—ã‚‰ã‚ŒãŸã€‚ãŸãã•ã‚“ã®ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã®ä¿®æ£äº‹é …ã«ã¤ã„ã¦ã¯ã€WebScaleS
hirose31 2014/09/24
mysql 5.6

mysql
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 10 æ¬¡ã®ãƒšãƒ¼ã‚¸