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

koemu id:koemu

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

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

Aurora MySQLã‚’MySQL8.0ã¸ç§»è¡Œã—ãŸè©± - inSmartBank
ã“ã‚“ã«ã¡ã¯ï¼SREã‚’æ‹…å½“ã—ã¦ã¾ã™ä¸Šå¹³ã¨ç”³ã—ã¾ã™ã€‚ ã“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã¯Aurora MySQL5.7äº’æ›ã‹ã‚‰MySQL8.0äº’æ›ã¸ã®ç§»è¡Œã‚’å®Ÿæ–½ã—ãŸéš›ã®æµã‚Œã‚„å¦ã³ã«é–¢ã—ã¦ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ï¼ B/43 ã§ã¯ Aurora MySQL5.7ç³»ã‚’ã‚µãƒ¼ãƒ“ã‚¹ãƒªãƒªãƒ¼ã‚¹ã‹ã‚‰ä½¿ã£ã¦ãŠã‚Šã€Aurora MySQL ãƒãƒ¼ã‚¸ãƒ§ãƒ³2ã®ã‚µãƒãƒ¼ãƒˆçµ‚äº†æ—¥ï¼ˆ2024/10/31ï¼‰ãŒè¿‘ã¥ã„ã¦ã„ã‚‹ã®ã‚‚ã‚ã£ãŸã®ã§ã€ç§»è¡Œã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ Amazon Aurora ãƒãƒ¼ã‚¸ãƒ§ãƒ³ - Amazon Aurora ã“ã‚Œã‹ã‚‰Aurora MySQL8.0ã¸ç§»è¡Œã‚’æ¤œè¨Žã•ã‚Œã¦ã„ã‚‹æ–¹ã®å‚è€ƒã«ãªã‚Œã°å¹¸ã„ã§ã™ã€‚ æƒ³å®šã•ã‚Œã‚‹èªè€… Aurora MySQL 5.7ç³»ã‚’ä½¿ã£ã¦ã„ã¦ã€ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚’æ¤œè¨Žã—ã¦ã„ã‚‹æ–¹ å®Ÿéš›ã® Aurora MySQL 8.0 ã¸ã®ç§»è¡Œæ‰‹é †ã‚’çŸ¥ã‚ŠãŸã„æ–¹ AWS ã‚¤ãƒ³ãƒ•ãƒ©ã«èˆˆå‘³ãŒã‚ã‚‹æ–¹ å‰æ Aurora MySQL5.7äº’
koemu 2023/07/04
AWS

MySQL
ãƒªãƒ³ã‚¯
MySQLã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒãƒ³ãƒ‰ãƒªãƒ³ã‚°ã¨ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚° | Yakst
MySQLã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒãƒ³ãƒ‰ãƒªãƒ³ã‚°ã®å†…éƒ¨æ§‹é€ ã€ã‚¹ã‚±ãƒ¼ãƒ«é™ç•Œã€ãã—ã¦æœ€å¤§ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³æ•°ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãªã©ã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ å…è²¬äº‹é … ã“ã®è¨˜äº‹ã¯Geir Hoydalsvikæ°ã«ã‚ˆã‚‹MySQL Server Blogã®æŠ•ç¨¿ã€ŒMySQL Connection Handling and Scalingã€(2019/3/19)ã‚’ãƒ¦ãƒ¼ã‚¶ãŒç¿»è¨³ã—ãŸã‚‚ã®ã§ã‚ã‚Šã€Oracleå…¬å¼ã®æ–‡æ›¸ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã“ã®æŠ•ç¨¿ã§ã¯ã€MySQLã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¹ãƒ¬ãƒƒãƒ‰ãŠã‚ˆã³ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚°ã«ã¤ã„ã¦å–ã‚Šæ‰±ã„ã¾ã™ã€‚MySQLãŒã©ã®ã‚ˆã†ã«å‹•ä½œã™ã‚‹ã‹ã‚’ã‚ˆã‚Šã‚ˆãç†è§£ã™ã‚‹ã“ã¨ã§ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºè€…ã‚„ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†è€…ãŒã€ãƒˆãƒ¬ãƒ¼ãƒ‰ã‚ªãƒ•ã‚’è¸ã¾ãˆãŸè‰¯ã„é¸æŠžã‚’ã§ãã‚‹ã“ã¨ã§ã—ã‚‡ã†ã€‚æœ¬è¨˜äº‹ã§ã¯ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ç‰ˆã§ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒã©ã®ã‚ˆã†ã«å‹•ä½œã™ã‚‹ã‹ã«ã¤ã„ã¦è¿°ã¹ã¾ã™ãŒã€ä¸€æ–¹ã§ã‚¹ãƒ¬ãƒƒãƒ‰ãƒ—ãƒ¼ãƒ«ã€ãƒªã‚½ãƒ¼ã‚¹ã‚°ãƒ«ãƒ¼ãƒ—ã€ã‚ã‚‹ã„ã¯ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³å¤šé‡åŒ–ã¨ã„ã£ãŸé–¢
koemu 2019/05/21
MySQL
ãƒªãƒ³ã‚¯
MySQLã‚’å‰²ã¨ä¸€äººã§300å°ç®¡ç†ã™ã‚‹æŠ€è¡“
14. MySQLã®â¾¯å€’ã‚’â¾’ã‚‹ #ã¨ã¯ DBã«ç‰¹åŒ–ã—ãŸï¼ˆåºƒç¾©ã®ï¼‰ã‚¤ãƒ³ãƒ•ãƒ©ãƒ‡ã‚¶ã‚¤ãƒ³ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®é »åº¦, ä¿ç®¡å…ˆ, ..etc. + ãã®å®Ÿè£…- ç›£è¦–, ãƒªã‚½ãƒ¼ã‚¹ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°, ..etc. + ãã®å®Ÿè£…- mikasafabric for MySQL + MySQL Router- ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®æ¤œè¨¼ã¨ã‹ã€Percona Serverã¨ã‹ MariaDBã¨ã‹ - DBã«ç‰¹åŒ–ã—ãŸã‚·ãƒ§ãƒƒãƒˆä½œæ¥ åŠã‚‹ã—ã® ALTER TABLE ä»¥å¤–ã‚’ä½¿ã£ãŸãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã®æ›´æ–° < 5.6 ã ã£ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ãŒâ¼¤ãã™ãŽã¦ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒè©°ã¾ã£ãŸã‚Šã™ã‚‹ã‚±ãƒ¼ã‚¹ - ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒ¼ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°- ãƒžã‚¤ãƒŠãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—- 13/63
koemu 2017/09/06
æœ€é«˜ã®MySQLç›£è¦–ãƒŽã‚¦ãƒã‚¦ã ã£ãŸ

MySQL

é‹ç”¨

äº‹ä¾‹

ç›£è¦–
ãƒªãƒ³ã‚¯
MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ‰‹æ³•ã®é•ã„ | Yakst
ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒãƒ¼ãƒ ã«æ‰€å±žã™ã‚‹ç†è€…ãŒã€ä»Šã§ã¯æ§˜ã€…ãªæ‰‹æ³•ãŒå˜åœ¨ã™ã‚‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã«ã¤ã„ã¦ã€æ”¹ã‚ã¦ç‰¹å¾´ã‚„æ³¨æ„ç‚¹ã‚’è§£èª¬ã—ã¤ã¤ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚ˆãã‚ã‚‹ã€Œèª¤è§£ã€ã«å¯¾ã—ã¦ã‚‚ãŠç”ãˆã—ã¦ã„ã¾ã™ã€‚ ã“ã®ãƒ–ãƒã‚°è¨˜äº‹ã§ã¯ã€MySQLï¼ˆãŠã‚ˆã³ Percona Serverï¼‰ç’°å¢ƒã«ãŠã‘ã‚‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ‰‹æ³•ã«é–¢ã—ã¦æ”¹ã‚ã¦è€ƒå¯Ÿã‚’è¡Œã„ãŸã„ã¨æ€ã„ã¾ã™ã€‚ã‚ã‚ã›ã¦ã€æ™‚æŠ˜è¦‹å—ã‘ã‚‰ã‚Œã‚‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–“é•ã£ãŸè€ƒãˆæ–¹ã«ã¤ã„ã¦ã‚‚è€ƒãˆã¦ã¿ã¾ã™ã€‚ ç§ãŒã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦åƒãå§‹ã‚ã¦ã‹ã‚‰ã¨ã„ã†ã‚‚ã®ã€æ²¢å±±ã®æƒ…å ±ãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã«ã‚‚é–¢ã‚ã‚‰ãšã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å¯¾ã™ã‚‹ã€Œèª¤è§£ã€ã‚„ã€Œä¸å®Œå…¨ãªç†è§£ã€ãŒç„¡ããªã‚‰ãªã„ã“ã¨ã‚’æ—¥ã€…æ„Ÿã˜ã¦ã„ã¾ã—ãŸã€‚ ãã‚‚ãã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯ä½•ã‹ï¼Ÿ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€1ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ‡ãƒ¼ã‚¿ã‚’è“„ç©ã™ã‚‹ã ã‘ã§ãªãã€åˆ¥ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ‡ãƒ¼ã‚¿ã‚’è¤‡è£½ã—ã€è»¢é€ã™ã‚‹ã“ã¨ã‚’ä¿è¨¼ã—ã¦ãã‚Œã‚‹æ©Ÿèƒ½ã§ã™ ï¼ˆè¤‡è£½
koemu 2017/03/09
MySQL
ãƒªãƒ³ã‚¯
Nç§’é–“ã ã‘ã‚¯ã‚¨ãƒªå®Ÿè¡Œãƒã‚°ã‚’å–ã‚ŠãŸã„ - Hateburo: kazeburo hatenablog
pt-query-digestã ã£ãŸã‚Šèª¿æŸ»ã®ãŸã‚ã«ã€Nç§’é–“ã ã‘mysqlã®å…¨ã‚¯ã‚¨ãƒªã®ãƒã‚°ã‚’å–å¾—ã—ãŸã„ã¨ã„ã†ã“ã¨ã¯ã‚ˆãã‚ã‚Šã¾ã™ã‚ˆã ãã‚“ãªæ™‚ã¯ã“ã‚“ãªã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã†ã¨ç°¡å˜ã«æŒ‡å®šã®ç§’æ•°slowlogã‚’åˆ‡ã‚Šæ›¿ãˆã¦ä¿å˜ã€å–å¾—å¾Œã«å…ƒã«æˆ»ã—ã¦ãã‚Œã¾ã™ã€‚ $ slowlog.pl --duration 10 -- --default-extra-file=/hoge/my.cnf -uuser -- ã®ã‚ã¨ã¯mysqlã‚³ãƒžãƒ³ãƒ‰ã«æ¸¡ã™ã‚ªãƒ—ã‚·ãƒ§ãƒ³ ã‚½ãƒ¼ã‚¹ #!/usr/bin/perl use strict; use warnings; use IO::Handle; use Getopt::Long; use File::Spec; sub find_path { my $pg = shift; my $path; for ( split /:/, $ENV{PATH} ) { if ( -x "$_/$p
koemu 2017/02/08
MySQL

è² è·å¯¾ç–
ãƒªãƒ³ã‚¯
MySQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³
9. Reference, SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ å€‹â¼ˆçš„ã«ã¯å®Ÿå‹™çµŒé¨“ç©ã‚“ã§ã‹ã‚‰ã€ã€Œã‚„ã£ã±ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ãª ã®ã‹ã‚ˆï¸•ã€ã£ã¦â½…ãŒæ—ã‚‹ã¨æ€ã† è‹¥ã„ã†ã¡ã¯ã€Œã‚ã£ã“ã‚Œ é€²ç ”ã‚¼ãƒŸ SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã§â¾’ãŸ ã‚„ã¤ã ï¸•ã€ã£ã¦ãªã£ã¦ã‚‚ç†è§£ãŒå¾—ã‚‰ã‚Œãšã«â¼¼ãŒæ»ã¬ã“ã¨ãŒå¤š ã„ ä»Šé ƒãŸã¶ã‚“Twitterã§ã€Œã‚¦ãƒã¯ãã‚“ãªã“ã¨ã—ãªã„ãžã€ã£ã¦æŠ€è¡“çš„ãƒ›ãƒ¯ ã‚¤ãƒˆä¼æ¥ã®æˆ¦â¼ ãŸã¡ãŒ #mysqlcasual ã¤ã‘ã¦å‘Ÿã„ã¦ã‚‹ ã‹ã‚‰ã¿ã‚“ãªå‚ è€ƒã«ã—ã‚ˆã† - 8/42
koemu 2017/02/03
ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã¯ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒä¸ŠãŒã‚‹ã«ã¤ã‚Œã¦ã©ã‚“ã©ã‚“è‰¯ããªã£ã¦ã„ã‚‹ã‹ã‚‰ä»¥å‰ã®å¸¸è˜ãŒé€šç”¨ã—ãªã„å ´åˆãŒã‚ã‚‹

MySQL
ãƒªãƒ³ã‚¯
MySQLã®æ–‡å—ã‚³ãƒ¼ãƒ‰äº‹æƒ… 2017ç‰ˆ
10. æ–‡å—é›†åˆæ–‡å—é›†åˆ US-ASCII æ•°å—ã€è‹±å—ã€32å€‹ã®è¨˜å· JIS X 0201 US-ASCII(ã€Œã€â†’ã€ŒÂ¥ã€/ã€Œ~ã€â†’ã€Œâ€¾ã€)+ã‚«ã‚¿ã‚« ãƒŠ JIS X 0208 æ•°å—ã€ã²ã‚‰ãŒãªã€ã‚«ã‚¿ã‚«ãƒŠã€æ¼¢å—ã€ãƒ©ãƒ†ãƒ³æ–‡å—ã€ ã‚®ãƒªã‚·ãƒ£æ–‡å—ã€è¨˜å·ç‰ã€… JIS X 0213 JIS X 0208 + ç¬¬ä¸‰æ°´æº–/ç¬¬å››æ°´æº–ã€ãƒãƒ¼ãƒžæ•°å—ã€ é¼»æ¿éŸ³æ–‡å—ç‰ã€… 11. æ–‡å—é›†åˆæ–‡å—é›†åˆ Windows-31J JIS X 0201 + JIS X 0208 + NECç‰¹æ®Šæ–‡å— + IBM æ‹¡å¼µæ–‡å—(ã€Œâ‘§ã€ã€Œâ…§ã€ã€Œãˆ±ã€ã€Œé«™ã€ã€Œï¨‘ã€ã€Œå½…ã€ ç‰) Unicode ä¸–ç•Œä¸ã®æ–‡å—ã€‚çµµæ–‡å—(ã€Œï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ã€ã€Œï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ã€ç‰)ã‚‚å«ã‚€ã€‚
koemu 2017/02/02
MySQL

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
MySQLã§INSERTã®ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã«åµŒã‚‹äººã‚’1äººã§ã‚‚æ¸›ã‚‰ã™ãŸã‚ã« - ichirin2501's diary
ã“ã®è¨˜äº‹ã¯ã¯ã¦ãªãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼2015ã®12æœˆ24æ—¥ã®è¨˜äº‹ã§ã™ã€‚ æ˜¨æ—¥ã¯ id:stefafafan ã•ã‚“ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨è‹±èªžã§ã—ãŸã€‚ ã“ã‚“ã«ã¡ã¯ã€ã“ã‚“ã°ã‚“ã¯ã€‚ ã‚¯ãƒªã‚¹ãƒžã‚¹ãƒ»ã‚¤ãƒ´ã§ã™ãã€çš†ã•ã‚“ã¯ã©ã®ã‚ˆã†ãªä¸€æ—¥ã‚’éŽã”ã•ã‚Œã‚‹(ãŸ)ã®ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯ä¸€äººã§ã™ã€‚ æ”¹ã‚ã¾ã—ã¦ã€å…ˆæ—¥åˆã‚ã¦ã®åˆã‚³ãƒ³ã‚’çµŒé¨“/å¤±æ•—ã—ã¦äºŒåº¦ã¨è¡Œã‹ãªã„ã¨èª“ã£ãŸ ã¯ã¦ãªã® id:ichirin2501 ã§ã™ã€‚ä»Šå›žã¯å°ãƒã‚¿ã¨ã—ã¦MySQL(InnoDB)ã®BULK INSERTã«ãŠã‘ã‚‹ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã®è©±ã‚’ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ãŸã ã€å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ãŒçµ¡ã‚€ã¨è¤‡é›‘ã«ãªã‚‹ã®ã§ä»Šå›žã¯è§¦ã‚Œã¾ã›ã‚“ã€‚ãã‚Œã«ã¤ã„ã¦ã¯ã“ã¡ã‚‰ã‚’å‚ç…§ãã ã•ã„ã€‚ ã‚ã€ã‚¿ã‚¤ãƒˆãƒ«ã¯ã‚ªãƒžãƒ¼ã‚¸ãƒ¥ã§ã™*1ã€‚ Topic æ¤œè¨¼ç’°å¢ƒ INSERTã®ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ é¿ã‘ã‚‰ã‚Œãªã„ã‚±ãƒ¼ã‚¹ ã‚‚ã—ãã¯ãƒãƒƒã‚¯ã™ã‚‹ ãƒªãƒˆãƒ©ã‚¤å‡¦ç†ã«æ³¨æ„ åˆæœŸãƒ‡ãƒ¼ã‚¿ Duplicateã®å ´åˆ Deadlockã®
koemu 2017/01/24
MySQL

ã‚³ãƒ„
ãƒªãƒ³ã‚¯
Advent Calendar 14æ—¥ç›® MySQL ã¨ PHP ã®é–“ã‚’è©³ã—ãè¦‹ã¦ã¿ã‚‹ - do_aki's log
ã‹ã˜ã‚…ã‚ã‚‹ï¼ (æŒ¨æ‹¶ï¼‰ æœ¬è¨˜äº‹ã¯ã€ MySQL Casual Advent Calendar 2011 (http://mysql-casual.org/2011/11/mysql-casual-advent-calendar-2011.html) 14æ—¥ç›®ã§ã™ã€‚ ãã—ã¦åŒæ™‚ã« do_aki Advent Calendar 2011 (http://atnd.org/events/22834) ã® 14æ—¥ç›®ã§ã‚‚ã‚ã‚Šã¾ã™ ;-p PHP ã¨èžã„ãŸã ã‘ã§é€ƒã’å‡ºã™æ–¹ã‚‚å±…ã‚‰ã‚Œã¾ã™ã§ã—ã‚‡ã†ãŒã€ ã‚„ã¯ã‚Šç§ã€PHP ã‚’ä½¿ã£ã¦ãŠã‚Šã¾ã—ã¦ã€ãã‚Œä»¥å¤–ã®ãƒã‚¿ãŒãªã‹ãªã‹è¦‹ã¤ã‹ã‚‰ãªã„ã®ã§ã€ ã‹ã˜ã‚…ã‚ã‚‹ã« PHP ãƒã‚¿ã‚’æŠ•å…¥ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ MySQL ã‚’åˆ©ç”¨ã™ã‚‹æ‰‹æ®µ PHP ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ MySQL ã‚’åˆ©ç”¨ã™ã‚‹æ–¹æ³•ã¯çµæ§‹æ§˜ã€…ã§ã™ã€‚ Doctrine (http://www.doctrine-projec
koemu 2016/12/05
PHP

MySQL
ãƒªãƒ³ã‚¯
PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2014 ã§ã€Œmysqlnd å¾¹åº•è§£èª¬ã€ã‚’è©±ã—ã¦ããŸã“ã¨ #phpcon2014 - do_aki's log
åŽ»ã‚‹ 2014/10/11ã€‚å¤§ç”°åŒºç”£æ¥ãƒ—ãƒ©ã‚¶PiOã«ã¦ PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2014ãŒé–‹å‚¬ã•ã‚Œã¾ã—ãŸã€‚ ãã®ä¸ã§ã€ã€Œmysqlnd å¾¹åº•è§£èª¬ã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§ãƒˆãƒ¼ã‚¯ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ 20141011 mastering mysqlnd from do_aki é›‘æ„Ÿ æ€ã„è¿”ã›ã° PHP ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§åˆLT ã‚’ã—ãŸã®ãŒ 2011å¹´ã€‚ ã„ã¤ã‹LTã§ã¯ãªãæœ¬ç·¨ã§è©±ãã†ã¨æ€ã„ã¤ã¤ã€æ°—ã¥ã‘ã°3å¹´çµŒã£ã¦ã„ã¾ã—ãŸã€‚ ç›¸å¤‰ã‚ã‚‰ãšè¡Œå‹•åŠ›ã«æ¬ ã‘ã‚‹ã‚ˆã†ã§ã€‚ å¿œå‹Ÿã—ãŸã®ã¯å®Œå…¨ã«ãƒŽãƒªã€‚ ã‘ã©ã€æŽ¡æŠžã•ã‚Œã¦ã‹ã‚‰ãŒå¤§å¤‰ã ã£ãŸã€‚ æŽ¡æŠžã•ã‚ŒãŸã®ãŒ9æœˆ25æ—¥ã€2é€±é–“ã¡ã‚‡ã„ã—ã‹ãªã„ã€‚è³‡æ–™ã©ã“ã‚ã‹ã€mysqlnd ã«ã¤ã„ã¦ã¾ã å…¨ç„¶åˆ†ã‹ã£ã¦ãªã„ã€‚ã¨ã„ã†çŠ¶æ³ã€‚ å¿œå‹Ÿã—ãŸã¨ãã¯ã¡ã‚‡ã†ã©ä»•äº‹ã§ mysqlnd ã®æŒ™å‹•ã«ã¤ã„ã¦è»½ãè¿½ã£ã¦ã„ãŸé ƒã ã£ãŸã®ã§ã€Œã“ã‚Œãã£ã‹ã‘ã«è©³ç´°ã«ã‚³ãƒ¼ãƒ‰è¿½ã£ã¦ã¿ã‚ˆã†ã€ã¨ã„ã†è»½ã„æ°—æŒã¡ã ã£ãŸã®ã§ã™ãŒã€è¿½ãˆã°è¿½
koemu 2016/12/05
PHP

MySQL
ãƒªãƒ³ã‚¯
gh-ost: GitHub's online schema migration tool for MySQL
AI & MLLearn about artificial intelligence and machine learning across the GitHub ecosystem and the wider industry. Generative AILearn how to build with generative AI. GitHub CopilotChange how you work with GitHub Copilot. LLMsEverything developers need to know about LLMs. Machine learningMachine learning tips, tricks, and best practices. How AI code generation worksExplore the capabilities and be
koemu 2016/08/02
ä¾¿åˆ©ãã† ãƒˆãƒªã‚¬ãƒ¼ãƒ¬ã‚¹ã§ãƒ†ã‚¹ã‚¿ãƒ–ãƒ«

MySQL
ãƒªãƒ³ã‚¯
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨éšœå®³å¾©æ—§ã‹ã‚‰è€ƒãˆã‚‹Oracle Database, MySQL, PostgreSQLã®é•ã„
2. 2 è‡ªå·±ç´¹ä»‹+æ‰€å±žä¼šç¤¾ç´¹ä»‹ â€¢ æ¸¡éƒ¨ äº®å¤ªï¼ˆã‚ãŸã¹ ã‚Šã‚‡ã†ãŸï¼‰ â€“ JPOUG å…±åŒå‰µè¨è€…ã€ãƒœãƒ¼ãƒ‰ãƒ¡ãƒ³ãƒãƒ¼ â€“ Oracle ACE â€“ è‘—æ›¸ã€Œãƒ—ãƒã¨ã—ã¦ã®Oracleã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£å…¥é–€ [ç¬¬2ç‰ˆ]ã€ ã€Œãƒ—ãƒã¨ã—ã¦ã®Oracleé‹ç”¨ç®¡ç†å…¥é–€ã€ â€“ ãƒ–ãƒã‚°ã€Œã‚³ãƒ¼ã‚½ãƒ«Database ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®Blogã€ http://cosol.jp/tech db/ â€¢ æ ªå¼ä¼šç¤¾ã‚³ãƒ¼ã‚½ãƒ« â€“ ã€ŒCO-Solutionsï¼å…±ã«è§£æ±ºã™ã‚‹ã€ã®ç†å¿µã®ã‚‚ã¨ã€Oracle æŠ€è¡“ã«ç‰¹ åŒ–ã—ãŸäº‹æ¥ã‚’å±•é–‹ä¸ã€‚å¿ƒã‚ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã®æä¾›ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ ã‚¸ãƒ‹ã‚¢ã®è‚²æˆã«æ³¨åŠ›ã—ã¦ã„ã‚‹ â€“ ç¤¾å“¡æ•°: 131å (2016å¹´7æœˆæ™‚ç‚¹) â€“ ORACLE MASTER Platinum 11g å–å¾—è€…æ•° 45å ORACLE MASTER Platinum 12c å–å¾—è€…æ•° 28å ï¼ˆç¾æ™‚ç‚¹ã§ãŠãã‚‰ãï¼‰å–å¾—è€…æ•° æ—¥æœ¬ No.1
koemu 2016/07/19
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

postgreSQL

MySQL

Oracle
ãƒªãƒ³ã‚¯
DB Tech Showcase Tokyo 2016 ã§ç™ºè¡¨ã—ã¾ã—ãŸã€‚MySQL 5.7ã®æ–°æ©Ÿèƒ½ ã€œInnoDBç·¨ã€œ
è¡¨é¡Œã®é€šã‚Šã€db tech showcase Tokyo 2016ã«ã¦ã€MySQL 5.7ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ã®è§£èª¬ã‚’è¡Œã£ãŸã€‚ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ãŸã®ã§ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ã«æ¥ã¦ãã‚ŒãŸæ–¹ã‚‚ã€è¦‹é€ƒã—ãŸã¨ã„ã†æ–¹ã‚‚ãœã²è¦‹ã¦é ‚ããŸã„ã€‚ What's New in MySQL 5.7 InnoDB from Mikiya Okuno æ€ãˆã°ã€4å¹´å‰ã®db tech showcaseã§MySQL 5.6ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦è§£èª¬ã—ãŸã¨ãã¯ã€1å›žã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã™ã¹ã¦ã®æ©Ÿèƒ½ã‚’è©³è§£ã™ã‚‹ã“ã¨ãŒã§ããŸã€‚ã¨ã“ã‚ãŒã€MySQL 5.7ã«è‡³ã£ã¦ã¯ã€æ˜¨å¹´MyNAä¼šã§ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶é–¢é€£ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ã®è§£èª¬ã‚’è¡Œã£ãŸã®ã«ç¶šãã€ä»Šå›žã¯InnoDBã®æ–°æ©Ÿèƒ½ã ã‘ã«çš„ã‚’çµžã£ãŸè§£èª¬ã¨ãªã£ãŸã€‚ã“ã®ã‚ˆã†ã«å°å‡ºã—ã«ã—ã¦ã„ã‚‹ã®ã«ã¯ãƒ¯ã‚±ãŒã‚ã‚‹ã€‚ã„ã‚„ã€ãã‚‚ãã‚‚å°å‡ºã—ã«ã—ã¦ã„ã‚‹ã¨ã„ã†ã¤ã‚‚ã‚Šã¯ãªã„ã€‚å˜ã«MySQL 5.7ã®æ–°æ©Ÿèƒ½ãŒå¤šã™ãŽã¦
koemu 2016/07/14
MySQL
ãƒªãƒ³ã‚¯
mycli
mycli BlackLivesMatter We value the diversity of our community. We strive to amplify the voices of the oppressed to eradicate racism and xenophobia. We ask our community to stand together in support of the Black community. MyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting. Source: https://github.com/dbcli/mycli Bug tracker: https://githu
koemu 2016/05/11
è³¢ã„MySQLç”¨CLIã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ

MySQL
ãƒªãƒ³ã‚¯
ãƒã‚°ã‚¤ãƒ³ - ã¯ã¦ãª
ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¿˜ã‚ŒãŸæ–¹ã¯ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å†è¨å®šã‚’è¡Œã£ã¦ãã ã•ã„ã€‚ åˆã‚ã¦ã®æ–¹ã¯ã¯ã¦ãªIDç™»éŒ² (ç„¡æ–™) ã—ã¦ãã ã•ã„ã€‚ ã†ã¾ããƒã‚°ã‚¤ãƒ³ã§ããªã„æ–¹ã¯ãŠå•ã„åˆã‚ã›ã‚’ã”è¦§ã„ãŸã ãã€Cookieã®è¨å®šã‚’ã”ç¢ºèªãã ã•ã„ã€‚
koemu 2016/04/28
AWS

MySQL
ãƒªãƒ³ã‚¯
Monitoring MySQL performance metrics
Product { this.openCategory = category; const productMenu = document.querySelector('.product-menu'); window.DD_RUM.onReady(function() { if (productMenu.classList.contains('show')) { window.DD_RUM.addAction(`Product Category ${category} Hover`) } }) }, 160); }, clearCategory() { clearTimeout(this.timeoutID); } }" x-init=" const menu = document.querySelector('.product-menu'); var observer = new Muta
koemu 2016/04/26
MySQL

ç›£è¦–
ãƒªãƒ³ã‚¯
GitHub - kazeburo/ourdump: simplified mysql40dump
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
koemu 2016/03/01
ã€Œbackupæ™‚ã«show master statusã¨slave statusã®æƒ…å ±ã‚’mysqldumpã®çµæžœã®ä¸ã«åŸ‹ã‚è¾¼ã‚“ã§ãã‚Œã¾ã™ã€‚ã€

MySQL

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
ãƒªãƒ³ã‚¯
ãƒ¤ãƒ•ãƒ¼ç¤¾å†…ã§ã‚„ã£ã¦ã‚‹MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚»ãƒŸãƒŠãƒ¼å¤§å…¬é–‹
3. Yahoo! JAPANã®RDBç’°å¢ƒ â€¢ 11g RAC Enterprise Edition â€¢ ç´„200DB â€¢ ã‚µãƒ¼ãƒ 200å°, Exadata ã‚‚ã‚ã‚‹ã‚ˆ â€¢ MySQL 5.1 (RR,Mixed) Percona 5.5 (RR,Mixed) Percona 5.6 (RC,RBR,GTID) â€¢ ç´„500DB â€¢ ã‚µãƒ¼ãƒ 300å° Oracle Database MySQL Percona
koemu 2016/02/23
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®æ–°å¸¸è˜ã¯ã“ã‚Œã ï¼ã€ŒMySQL ã‚¯ãƒ©ã‚¦ãƒ‰å‘ã‘ InnoDB ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®æ–°å¸¸è˜ã¯ã“ã‚Œã ï¼ã€ŒMySQL ã‚¯ãƒ©ã‚¦ãƒ‰å‘ã‘ InnoDB ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ ã“ã‚“ã«ã¡ã¯ã€‚ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã® nobuh ã§ã™ã€‚ æ ªå¼ä¼šç¤¾ã‚¤ãƒ³ã‚µã‚¤ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼æ§˜ä¸»å‚¬ã®Â db tech showcase sapporo 2015 Â ãŒ 9æœˆ10æ—¥ã€11æ—¥ã®2æ—¥é–“ã«ã‚ãŸã£ã¦é–‹å‚¬ã•ã‚Œã¾ã—ãŸ ã€‚ ä»Šå›žã€å¼Šç¤¾ã‚‚ç™ºè¡¨ã™ã‚‹æ©Ÿä¼šã‚’é ‚ãã¾ã—ãŸã®ã§ã€ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦æ—¥ã€… MySQL ã¨æ ¼é—˜ã—ã¦åŸ¹ã£ãŸãƒŽã‚¦ãƒã‚¦ã«ã¤ã„ã¦ãŠè©±ã•ã›ã¦é ‚ãã¾ã—ãŸã€‚ãã®ç™ºè¡¨ã§ä½¿ã£ãŸã‚¹ãƒ©ã‚¤ãƒ‰ãŒã“ã¡ã‚‰ã§ã™ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã®ä»®æƒ³ã‚µãƒ¼ãƒãƒ¼ã‚’ä½¿ã£ã¦ MySQL ã®ç®¡ç†ã‚„ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«æ—¥ã€…é‚é€²ã•ã‚Œã¦ã„ã‚‹æ–¹ã€…ã«ã”è¦§ã„ãŸã ã‘ã‚‹ã¨å¹¸ã„ã§ã™ã€‚ ä»Šã¾ã§ã«ã‚‚ MySQL ã«é–¢ã—ã¦ã„ãã¤ã‹è¨˜äº‹ã‚’æŽ²è¼‰ã—ã¦ã„ã¾ã™ã®ã§ã€ã“ã®æ©Ÿä¼šã«æ˜¯éžã”è¦§ãã ã•ã„ï¼ â†’ OSC2015åŒ—æµ·é“ã§ã€Œã“ã‚Œã ã‘ã¿ã‚Œã°å¤§ä¸ˆå¤«ãƒ¼Cactiã«ã‚ˆã‚‹MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœã€
koemu 2015/09/16
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
Percona Toolkit Documentation
pt-query-digestÂ¶ NAMEÂ¶ pt-query-digest - Analyze MySQL queries from logs, processlist, and tcpdump. SYNOPSISÂ¶ UsageÂ¶ pt-query-digest analyzes MySQL queries from slow, general, and binary log files. It can also analyze queries from SHOW PROCESSLIST and MySQL protocol data from tcpdump. By default, queries are grouped by fingerprint and reported in descending order of query time (i.e. the slowest qu
koemu 2015/08/22
slowlogè§£æžã«ä½¿ãŠã†

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

MySQL

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