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

tkmkg8m id:tkmkg8m

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

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

Whereç‹™ã„ã®ã‚ãƒ¼ã€order byç‹™ã„ã®ã‚ãƒ¼
11. I'm yoku0825 â— ã¨ã‚ã‚‹ä¼æ¥ã®DBA â— ã‚ªãƒ©ã‚¯ã‚Œãªã„ â— ãƒã‚¹ã‚°ã‚Œãªã„ â— ãƒžã‚¤ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ã‚‹ â— å®¶ã«å¸°ã‚‹ã¨ â— å«ã®å¤« â— ã›ãŒã‚Œã®çˆ¶ â— é¦¬é¹¿ã ã‹ã‚‰ã‹ã‚ã„ã„ã‚ã‘ã˜ã‚ƒãªãã¦ã€ã‹ã‚ã„ã„ ã‚¤ãƒ«ã‚«ãŒãŸã¾ãŸã¾ãƒã‚«ã ã£ãŸ 12. ã¯ã˜ã‚ã« â— ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ã¯ MySQLã®ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ ãƒ™ãƒ¼ã‚¹(worldãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹)ã‹ã‚‰ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ ã‚¹ã‚’å…¨ã¦å–ã£æ‰•ã£ãŸã‚‚ã®ã§ã™ â— http://dev.mysql.com/doc/index-other.html â— ã‚³ãƒ¼ãƒ‰ã¯githubã«ä¸Šã’ã¦ã‚ã‚Šã¾ã™ â— https://github.com/yoku0825/yapc_2014 â— ã™ã”ãâ€¦ã‚¦ãƒ³ã‚³ãƒ¼ãƒ‰ã§ã™â€¦ 13. ã¯ã˜ã‚ã« â— åŽŸå‰‡ã€MySQLã¯1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ãåŒæ™‚ã«1 ã¤ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã—ã‹ä½¿ã„ã¾ã›ã‚“ â— Index mergeã¨ã‹ã‚ã‚‹ã‘ã©ã‚¢ãƒ¬ã¯ä¾‹å¤–ã ã—ç‹™ã£ã¦ ã‚„ã£ã¦ã‚‚é€Ÿããªã‚‹
tkmkg8m 2019/03/19
MySQL

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
Looking at MySQL 8 with PostgreSQL goggles on
By Kaarel Moppel - Compare MySQL and PostgreSQL - First off - I'm not trying to kindle any flame wars here, just trying to broaden my (your) horizons a bit, gather some ideas (maybe I'm missing out on something cool, it's the most used Open Source RDBMS after all) and to somewhat compare the two despite being a difficult thing to do correctly / objectively. Also, I'm leaving aside performance comp
tkmkg8m 2019/03/09
MySQL

PostgreSQL
ãƒªãƒ³ã‚¯
MySQL with InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã‚ã‚ŠãŒã¡ãªé–“é•ã„ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºéƒ¨ã®è’å¼• (@a_bicky) ã§ã™ã€‚ çªç„¶ã§ã™ãŒã€RDBMS ã®æ—¢å˜ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¦‹ã¦ã¿ãŸã‚‰ã€Œä½•ã§ã“ã‚“ãªã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã ã‚‰ã‘ãªã®ï¼Ÿã€ã¿ãŸã„ãªçµŒé¨“ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿä¸è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å®¹é‡ã‚’åœ§è¿«ã—ãŸã‚Šã€æŒ¿å…¥ãŒé…ããªã£ãŸã‚Šã¨è‰¯ã„ã“ã¨ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ ãã‚“ãªã‚ã‘ã§ã€ä»Šå›žã¯ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ¤œç´¢ã™ã‚‹ãŸã‚ã«å¿…è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã€ã‚ˆãè¦‹ã‹ã‘ã‚‹ä¸é©åˆ‡ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã¯ Rails ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä¸»ã« MySQL 5.6ã€MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ä¸»ã« InnoDB ã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã§ã€MySQL 5.6 ã® InnoDB ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«é–¢ã™ã‚‹åŸºç¤ŽçŸ¥è˜ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ§‹é€ (B+ æœ¨) InnoDB ã§ã¯ B+ æœ¨ãŒä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚B+ æœ¨ã¯æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ã‚’æŒã£ãŸæœ¨æ§‹é€ ã§ã™ã€‚ æ¬¡æ•°ã‚’ b ã¨ã™ã‚‹ã¨ã€
tkmkg8m 2019/02/06
ã‚ã¨ã§èªã‚€

MySQL

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

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
https://developer.hatenastaff.com/entry/2019/01/15/120431
tkmkg8m 2019/01/17
MySQL

ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆ
ãƒªãƒ³ã‚¯
Use utf8mb4 character set by default for MySQL database (#33608) Â· rails/rails@d54d0c9
* Use utf8mb4 character set by default `utf8mb4` character set supports supplementary characters including emoji. `utf8` character set with 3-Byte encoding is not enough to support them. There was a downside of 4-Byte length character set with MySQL 5.5 and 5.6: "ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes" for Rails string data type which is mapped to varchar(255)
tkmkg8m 2018/09/14
ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§utf8mb4ã«ãªã£ãŸã®ã‹ã€‚ã¾ãæœ€è¿‘ã ã¨çµµæ–‡å—æ ¼ç´ã§ãã¦å½“ãŸã‚Šå‰ãªä¸–ã®ä¸ã ã‚‚ã‚“ãã€‚

Rails

MySQL
ãƒªãƒ³ã‚¯
MySQLã®ã‚¯ã‚¨ãƒªã®è‰¯ã—æ‚ªã—ã¯rows_examinedã§åˆ¤æ–ã™ã‚‹ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
ä»•äº‹ã‚„ã‚‰ãªã‚“ã‚„ã‚‰ã§MySQLã®ã‚¯ã‚¨ãƒªã®è‰¯ã—æ‚ªã—ã‚’åˆ¤æ–ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã¨ãã€EXPLAINã®å†…å®¹ã ã‘ã ã¨ã©ã®ãã‚‰ã„è‰¯ããªã£ãŸã‚Šæ‚ªããªã£ãŸã®ã‹åˆ†ã‹ã‚‰ãªã„ã®ã§ SET long_query_time = 0; ã—ã¦rows_examined (ãã®ã‚¯ã‚¨ãƒªã§rows_sentè¡Œã®çµæžœã‚’è¿”ã™ãŸã‚ã«ä½•è¡Œã«è§¦ã£ãŸã®ã‹)ã‚‚ä¸€ç·’ã«æç¤ºã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã‚‹(å°‘ãªãã¨ã‚‚MySQL 5.7æ™‚ç‚¹ã§ã¯rows_examinedã¯slow_query_logã§ã—ã‹ç¢ºèªã§ããªã„ã¯ãšperformance_schemaãŒæœ‰åŠ¹ãªã‚‰events_statements_historyã‚„ãã®ä»²é–“ãŸã¡ã§ç¢ºèªã§ãã‚‹ã¨ã®ã“ã¨*1 MySQL :: MySQL 5.6 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 22.9.6 ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¹ã‚ãƒ¼ãƒžã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚¤ãƒ™ãƒ³ãƒˆãƒ†ãƒ¼ãƒ–ãƒ«)ã€‚ ä¾‹: ä¸Šã®ä¾‹ã®Beforeã¯ã€ã‚‚ã¨ã‚‚ã¨DBAãŒæ›¸ã„ãŸæ¸©ã‹ã¿ã®ã‚ã‚‹SQLã§O
tkmkg8m 2018/03/22
â€œSET long_query_time = 0; ã—ã¦rows_examinedâ€ã‚’è¦‹ã‚‹ã€‚æ¸©ã‹ã¿ã®ã‚ã‚‹ã‚³ãƒ¼ãƒ‰ãŒæ·±é ãªç†ç”±ã§æ›¸ãæ›ãˆã‚‰ã‚Œã‚‹ã®ã‚ã‚‹ã‚ã‚‹ã€‚

MySQL

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

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
1