[B! mysql][git] slay-tã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

slay-t id:slay-t

mysqlã¨gitã«é–¢ã™ã‚‹slay-tã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

å®Ÿä¾‹ã§å¦ã¶ MySQL/MariaDB ãƒ‡ãƒãƒƒã‚° - nayuta-yanagisawa's blog
ã“ã®è¨˜äº‹ã§ã¯ã€MySQL/MariaDB ã®ãƒã‚°ã‚’ä¿®æ£ã™ã‚‹ãŸã‚ã®å…¸åž‹çš„ãªæ‰‹é †ã‚’ã€å…·ä½“ä¾‹ã‚’é€šã—ã¦è§£èª¬ã™ã‚‹ã€‚æ¬¡ã® MariaDB ã®ãƒã‚°ã‚’ä¾‹ã¨ã—ã¦å–ã‚Šä¸Šã’ã‚‹ãŒã€åŸºæœ¬çš„ãªãƒ‡ãƒãƒƒã‚°ã®æ‰‹é †ã¯ MySQL ã§ã‚‚ã¾ã£ãŸãåŒæ§˜ã§ã‚ã‚‹ã€‚ MDEV-24868: Server crashes in optimize_schema_tables_memory_usage after select from information_schema.innodb_sys_columns ãªãŠã€MySQL/MariaDB ã®ãƒ‡ãƒãƒƒã‚°æ–¹æ³•ã«ã¤ã„ã¦ã®åŒ…æ‹¬çš„ãªè§£èª¬ã‚’ä¸Žãˆã‚‹ã®ã¯ã€ã“ã®è¨˜äº‹ã®ã‚¹ã‚³ãƒ¼ãƒ—å¤–ã§ã‚ã‚‹ã€‚ãƒ‡ãƒãƒƒã‚°æ‰‹æ³•ã®è©³ç´°ã‚’çŸ¥ã‚ŠãŸã„å ´åˆã¯ã€ä»¥ä¸‹ã®ä¸€é€£ã®è¨˜äº‹ã‚’å‚ç…§ã—ã¦ã»ã—ã„ã€‚ Debugging MySQL/MariaDB (1): Build and Test Debugging MySQL/MariaDB (2): DBU
slay-t 2021/05/20
mysql

sql

innodb

server

blog

git

vagrant

test

debug

postgresql
ãƒªãƒ³ã‚¯
Re: çµå±€ã€Goè¨€èªžã‚’ã‚„ã‚ã‚‹ç†ç”±ã¯ãªã‹ã£ãŸä»¶ - Hateburo: kazeburo hatenablog
ã™ã¿ã¾ã›ã‚“ã€ISUCONã®ã‚¢ãƒ¬ã«ç«ãŒã¤ã„ã¦ã—ã¾ã£ãŸã®ã§..ã€‚ Advent Calendarã¨ã¯ã¨ãã«é–¢ä¿‚ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ qiita.com qiita.com ã“ã¡ã‚‰ã®è¨˜äº‹ã‚’ã¿ã¦ã€æ°—ã«ãªã£ã¦ã—ã¾ã£ãŸã®ã§ interpolateParams ã®è¿½åŠ ã¨MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å›žã—ã¦ã¿ã¾ã—ãŸã€‚ ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã®ç’°å¢ƒãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã®ã¯ç´ æ™´ã‚‰ã—ã„ã§ã™ãã€‚ github.com 8vCPU/16GB Memã®c5a.2xlargeãªEC2ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’èµ·å‹•ã—ã¦ã€ä»¥ä¸‹ã®æ‰‹é †ã«ã—ãŸãŒã£ã¦dockerã¨docker-composeã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã—ãŸã€‚OSã¯Ubuntu 20.04ã‚’ä½¿ã„ã¾ã—ãŸã€‚ docs.docker.com docs.docker.com ä¸Šè¨˜ã®benchmarkã®repositoryã‚’git cloneã—ã€compose build && compose upã—
slay-t 2020/12/18
è¨€èªž

go

git

mysql

docker
ãƒªãƒ³ã‚¯
GitLabä»¤å’Œæœ€åˆã®ãƒªãƒ—ãƒ¬ã‚¤ã‚¹ã€‚ãƒ•ãƒ«ã‚³ãƒ³ãƒ†ãƒŠåŒ–ãƒã‚¹ã‚°ãƒ¬ç§»è¡Œ - pixiv inside
ã“ã‚“ã«ã¡ã¯ã€sue445ã§ã™ã€‚ å…ˆæ—¥ç¤¾å†…ã§ä½¿ã£ã¦ã‚‹GitLabã®ãƒªãƒ—ãƒ¬ã‚¤ã‚¹ã‚’ã—ãŸã®ã§ãã®è¾ºã®è©±ã‚’ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ãƒªãƒ—ãƒ¬ã‚¤ã‚¹ã®å†…å®¹ ä»Šå›žã®GitLabãƒªãƒ—ãƒ¬ã‚¤ã‚¹ã§ã¯ä¸»ã«ä¸‹è¨˜ã‚’è¡Œã„ã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒç§»è¨ã«ä¼´ã„URLä»¥å¤–å…¨éƒ¨å¤‰ãˆãŸ ãƒ¬ã‚¬ã‚·ãƒ¼ãªç’°å¢ƒã§é‹ç”¨ã•ã‚Œã¦ã„ãŸGitLabã‚’å…¨ã¦Dockerã‚³ãƒ³ãƒ†ãƒŠã«è¼‰ã›ãŸ MySQLã‹ã‚‰PostgreSQLã«ç§»è¡Œ ä»¥ä¸Šã‚’1æ™‚é–“å¼±ã®ãƒ¡ãƒ³ãƒ†ã§ã‚„ã‚Šãã£ãŸ æ§‹æˆ ã–ã£ãã‚Šæ›¸ãã¨ã€SSLçµ‚ç«¯ã®ãƒ•ãƒãƒ³ãƒˆã‚µãƒ¼ãƒã®ã¿åŒã˜ã§ã€ãã‚Œä»¥å¤–ã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚’å…¨éƒ¨å¤‰ãˆã¾ã—ãŸã€‚ æ—§ APã‚µãƒ¼ãƒ Debian Wheezy CPU: Intel Xeon E5-2640v2 * 2 Memory: 40GB Disk: 64G + 512G MySQLå…¼Redisã‚µãƒ¼ãƒ Debian Wheezy CPU: Intel Xeon X3430 Memory: 8GB Disk: 256G M
slay-t 2019/09/20
ã‚µãƒ¼ãƒ

deploy

ã‚³ãƒ³ãƒ†ãƒŠ

git

mysql
ãƒªãƒ³ã‚¯
Kandanã§ç¤¾å†…ã«ãƒãƒ£ãƒƒãƒˆã‚µãƒ¼ãƒç«‹ã¦ã¦ã¿ãŸ - Make Local Happiness
ãƒãƒ¼ãƒ ã§é–‹ç™ºã‚’ã™ã‚‹ã¨ãªã‚‹ã¨ã€ å¿…è¦ãªã‚‚ã®ã€‚ ãƒãƒ£ãƒƒãƒˆã‚µãƒ¼ãƒã§ã™ãã€‚ ãƒ¡ãƒ¼ãƒ«ã§ã‚„ã‚Šã¨ã‚Šã£ã¦æ„å¤–ã¨ã‚ã‚“ã©ãã•ã„ã€‚ ========== â—‹â—‹ã•ã‚“ ãŠç–²ã‚Œæ§˜ã§ã™ã€‚ Ã—Ã—ã§ã™ã€‚ ~~ã«ã¤ã„ã¦ã§ã™ãŒã€ ========== ã“ã‚“ãªæ„Ÿã˜ã§å½¢å¼ã°ã£ã¡ã‚ƒã†ã§ã™ã‚ˆãã€‚ ã§ã‚‚ã€ä¼šç¤¾ã ã¨HipChatã‚‚slackã‚‚ä½¿ãˆãªã„ã€‚ æœ¬æ¥ã ã£ãŸã‚‰HipChatä½¿ã„ãŸã‹ã£ãŸã€‚ã€‚ atlassianã‚‚HipChatã®ç¤¾å†…ç”¨ã¯æä¾›ã—ã¦ã„ãªã„ã€‚ã€‚ã€‚ ãªã‚“ã‹ã„ã„ãƒãƒ£ãƒƒãƒˆã‚µãƒ¼ãƒãªã„ã‹ãªã€œ ã¨ã„ã†ã“ã¨ã§èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ MOONGIFTã•ã‚“ã§è‰²ã€…ãƒãƒ£ãƒƒãƒˆã‚µãƒ¼ãƒã‚’ç´¹ä»‹ã—ã¦ã„ãŸä¸ã‹ã‚‰ã€ ã‚°ãƒ«ãƒ¼ãƒ—ã§ã®ã‚¯ãƒªã‚¨ã‚¤ãƒ†ã‚£ãƒ–æ´»å‹•ã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹Â·echoplexus MOONGIFT ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ãƒ™ãƒ¼ã‚¹ã®ãƒãƒ£ãƒƒãƒˆã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆÂ·Profanity MOONGIFT è¤‡æ•°ãƒ«ãƒ¼ãƒ ã«ã‚‚å¯¾å¿œã—ãŸRailsè£½Webãƒãƒ£ãƒƒãƒˆÂ·Kandan MOONGIFT Kand
slay-t 2014/07/08
MySQL

github

git

Ruby

dev

db

MySQL

install

ad
ãƒªãƒ³ã‚¯
gitãƒªãƒã‚¸ãƒˆãƒªã‚’å…¬é–‹ã™ã‚‹ãŸã‚ã®â˜†éŽåŽ»æ›¸ãæ›ãˆâ˜†ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ | æœˆã¨ç‡ƒç´ ã¨ã€ã²ã¨åŒ™ã®ç ‚ç³–
ï¼¿ï¼¿ï¼¿_ ï¼ã€€ã€€ ã€€ ã€€ï¼¼ ï¼ã€€ _ãƒŽ ã€€ãƒ½ï½¤_ã€€ ï¼¼ ï¼ oï¾Ÿ(ï¼ˆâ—ï¼‰) (ï¼ˆâ—ï¼‰)ï¾Ÿo ï¼¼ ã€€ã»ã‚“ã¨ã¯githubã§å…¬é–‹ã—ãŸã„ã‚“ã ãŠâ€¦ |ã€€ã€€ã€€ã€€ ï¼ˆ__äºº__ï¼‰ã€€ã€€ã€€ã€€| ï¼¼ã€€ã€€ ã€€ ï½€ âŒ’Â´ ã€€ ã€€ ï¼ ï¼¿ï¼¿ï¼¿_ ï¼ã€€ã€€ ã€€ ã€€ï¼¼ ï¼ã€€ _ãƒŽ ã€€ãƒ½ï½¤_ã€€ ï¼¼ ï¼ ã€€oï¾ŸâŒ’ã€€ã€€ã€€âŒ’ï¾Ÿoã€€ ï¼¼ ã€€ã§ã‚‚MySQLã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¨ã‹ |ã€€ã€€ã€€ã€€ ï¼ˆ__äºº__ï¼‰ã€€ã€€ã€€ã€€|ã€€ã€€ å…¬é–‹ã§ããªã„æƒ…å ±ãŒå…¥ã£ã¦ã‚‹ã‚“ã ãŠâ€¦ ï¼¼ã€€ã€€ ã€€ ï½€ âŒ’Â´ ã€€ ã€€ ï¼ ï¼¿ï¼¿ï¼¿_ ï¼âŒ’ã€€ã€€âŒ’ï¼¼ ï¼ï¼ˆ â—ï¼‰ ã€€ï¼ˆâ—ï¼‰ï¼¼ ï¼::::::âŒ’ï¼ˆ__äºº__ï¼‰âŒ’::::: ï¼¼ ã€€ã€€ã ã‹ã‚‰éŽåŽ»ã‚’æ›¸ãæ›ãˆã‚‹ãŠï¼ |ã€€ã€€ã€€ã€€ã€€|râ”¬-|ã€€ã€€ã€€ã€€ã€€| ï¼¼ ã€€ã€€ ã€€ `ãƒ¼'Â´ ã€€ ã€€ ï¼ ã¨ã€ã„ã†ã‚ã‘ã§ã€æ›¸ãæ›ãˆã§ã™ã€‚ githubã«ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’ç½®ããŸã„â€¦ã§ã‚‚å…¬é–‹ã§ããªã„æƒ…å ±ãŒâ€¦ã€‚ã‚ã‚Šãã†ãªã®ã¯ã“ã‚“ãªã‚±ãƒ¼ã‚¹ï¼Ÿ MySQLã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒæ›¸ã„
slay-t 2014/01/23
db

github

MySQL

git
ãƒªãƒ³ã‚¯
1