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

ori53 id:ori53

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

${{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ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒãƒƒã‚¯ã®é–¢ä¿‚ï¼‹ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã«ã¤ã„ã¦ - interdbâ€™s diary
ã‚ˆã„æ©Ÿä¼šãªã®ã§ã¾ã¨ã‚ã¦ãŠãã€‚å¯¾è±¡ã¯MySQL5.6ä»¥ä¸‹ã¨MariaDB10.0ä»¥ä¸‹ã€‚ (2014.12.3è¿½è¨˜ï¼šä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚è¨˜è¿°ã—ãŸã€‚) è¦æ—¨ MySQL/MariaDBã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã«ã¤ã„ã¦ã€ç›¸å¤‰ã‚ã‚‰ãšã€ŒInnoDBã•ãˆä½¿ã£ã¦ã„ã‚Œã°ã€FLUSH TABLES WITH READ LOCKã¯ä¸è¦ã€‚ã‚ˆã£ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ä¸ã«æ›´æ–°ä¸å¯ã«ãªã‚‹ã“ã¨ã¯ãªã„ï¼ã€ã¨ã®ä¸»å¼µãŒç¹°ã‚Šè¿”ã•ã‚Œã¦ã„ã‚‹ãŒã€å°‘ãªãã¨ã‚‚5.6/10.0ã¾ã§ã¯ãã‚“ãªã“ã¨ã¯ãªã„ã€‚ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã«é–¢ã™ã‚‹ãƒãƒƒã‚¯ã®æ£ç¢ºãªè¨˜è¿° ã‚ˆã‚Šæ£ç¢ºã«è¨€ãˆã°ã€Œå…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é ˜åŸŸã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹å ´åˆã«ã¯ã€FLUSH TABLES WITH READ LOCKã¯å¿…é ˆã€‚ç‰¹å®šã®InnoDBã ã‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹éš›ã¯ã€ã“ã®é™ã‚Šã§ã¯ãªã„ã€ã€‚ ãªã®ã ãŒã€å…¨é ˜åŸŸã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã—ãŸã„äººã«å¯¾ã—ã¦ãƒãƒƒã‚¯ä¸è¦èª¬ã‚’å¹ãè¾¼ã‚€äººãŒæœªã ã«ã„ã‚‹ã€‚ ãƒãƒƒã‚¯ã®å¿…è¦
ori53 2016/06/24
mysql
ãƒªãƒ³ã‚¯
MySQL 5.6ã¨5.7ã«ãŠã‘ã‚‹é«˜åº¦ãªã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®Q&A(The Percona Performance Blogã‚ˆã‚Š) | Yakst
ç´„9å¹´å‰æŠ•ç¨¿ ä¿®æ£ã‚ã‚ŠMySQL 5.6ã¨5.7ã«ãŠã‘ã‚‹é«˜åº¦ãªã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®Q&A(The Percona Performance Blogã‚ˆã‚Š) å‡ºå…¸ã«ã¤ã„ã¦ ã“ã®è¨˜äº‹ã¯The Percona Performance Blogå†…ã®Alexander Rubinæ°ã«ã‚ˆã‚‹ã€ŒAdvanced Query Tuning in MySQL 5.6 and MySQL 5.7 Webinar: Q&Aã€(2015/8/24)ã‚’ç¿»è¨³ã—ãŸã‚‚ã®ã§ã‚ã‚‹ã€‚ 8æœˆ22æ—¥ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚»ãƒŸãƒŠãƒ¼ã€ŒMySQL 5.6ãŠã‚ˆã³5.7ã«ãŠã‘ã‚‹é«˜åº¦ãªã‚¯ã‚¨ãƒªãƒ¼ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã«å‚åŠ ã—ã¦ã„ãŸã ã„ã¦ã‚ã‚ŠãŒã¨ã†(ç§ã®ã‚¹ãƒ©ã‚¤ãƒ‰ãŠã‚ˆã³å‹•ç”»ã¯ã“ã“ã§ç¢ºèªã§ãã‚‹)ã€‚ã“ã“ã§ã¯è³ªå•ã¨ãã®å›žç”ã®ä¸€è¦§ã‚’ç´¹ä»‹ã™ã‚‹(ã„ã„è³ªå•ã‚’ã‚ã‚ŠãŒã¨ã†) ã€‚ Q: ã“ã“ã«explainã®ä¾‹ãŒã‚ã‚‹ mysql> explain extended select id, s
ori53 2015/09/14
mysql

performance
ãƒªãƒ³ã‚¯
DBT-2 ã§ MySQL ã¨ä»–ã®RDBMSã®æ€§èƒ½æ¯”è¼ƒã‚’ã—ã¦ã„ã‚‹äººã«é¨™ã•ã‚Œãªã„ã‚ˆã†ã«æ³¨æ„
ä¸€å¿œã€ç«‹å ´çš„ã«ã¯ç¬¬ä¸‰è€…ã«æˆ»ã£ãŸ(MySQL/InnoDBã®æ€§èƒ½è¿½æ±‚ãŒä»•äº‹ã§ã¯ãªã„)ã®ã§ã€å¿˜ã‚Œã‚‰ã‚Œãªã„æš—ã„éŽåŽ»ã«ã‚‚è§¦ã‚Œã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ æœªã ã«é¨™ã•ã‚Œã¦ã„ã‚‹äººãŒå¤šã„ã¿ãŸã„ãªã®ã§ã€MySQL/InnoDBã®åèª‰ã®ãŸã‚ã«æ›¸ãæ®‹ã•ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä½•åº¦ã§ã‚‚è¨€ã„ã¾ã™ãŒã€æ€§èƒ½æ¯”è¼ƒã¯è‡ªåˆ†ã®ç›®çš„ã¨ã™ã‚‹å‡¦ç†ã‚’ã¡ã‚ƒã‚“ã¨æ¯”è¼ƒã—ãªã„ã¨ã ã‚ã§ã™ã€‚ãã†ã§ãªãã¦ã¯ã€é¨™ã•ã‚Œã¦æœ¬å½“ã¯æ‚ªã„æ€§èƒ½ã®ã‚‚ã®ã‚’æŽ´ã¾ã•ã‚Œã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ DBT-2ã¨è¨€ã†(TPC-Cã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸ)ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãŒã‚ã‚Šã¾ã™ãŒã€æ•°å¤šã®RDBMS(å•†ç”¨/OSSåŒæ–¹)ã«å¯¾ã—ã¦ç‹¬è‡ªã«TPC-Cãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å®Ÿè£…ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦æ¯”è¼ƒã—ãŸçµŒé¨“ã®ã‚ã‚‹ç§ã‹ã‚‰è¦‹ã¦ã€æ€ªã—ã„çµæžœã—ã‹å‡ºãªã„ã®ã§ã€é•·å¹´ã€åŸºæœ¬ç„¡è¦–ã®ã‚¹ã‚¿ãƒ³ã‚¹ã‚’å–ã£ã¦ã„ã¾ã™ã€‚ ãŒã€ï¼“å¹´å‰ã«ã‚ã‚ã†ã“ã¨ã‹MySQLã®æ€§èƒ½QAãŒDBT-2(nonsp:mysql)ã‚’åˆ©ç”¨ã—ã¦ã„ã¦ã€ã¨ã‚ã‚‹æ€§èƒ½FIXã«å¯¾ã—ã¦å•é¡Œã‚’æŒ‡æ‘˜ã—ã¦
ori53 2015/07/06
mysql

benchmark

ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯
ãƒªãƒ³ã‚¯
YouTubeãŒMySQLã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã™ã‚‹ã€ŒVitessã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã€‚Kubernetesã«å¯¾å¿œ
YouTubeãŒMySQLã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã™ã‚‹ã€ŒVitessã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã€‚Kubernetesã«å¯¾å¿œ Google Cloud Platformã®ãƒ–ãƒã‚°ã«æŠ•ç¨¿ã•ã‚ŒãŸè¨˜äº‹ã€ŒScaling MySQL in the cloud with Vitess and Kubernetesã€ã§ã€Vitessã¯æ¬¡ã®ã‚ˆã†ã«èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ At YouTube, we went on that journey as we scaled our MySQL deployment, which today handles the metadata for billions of daily video views and 300 hours of new video uploads per minute. To do this, we developed the Vitess platform,
ori53 2015/03/23
mysql

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

innodb
ãƒªãƒ³ã‚¯
utf8_unicode_ci ã«å¯¾ã™ã‚‹æ—¥æœ¬ã®é–‹ç™ºè€…ã®è¦‹è§£ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
RailsãŒMySQLã®collationã‚’ã‚µãƒ¼ãƒãƒ¼å´ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®utf8_general_ciã‹ã‚‰utf8_unicode_ciã«ã‚ã–ã‚ã–å¤‰ãˆã¦ã‚‹ã®ã©ã†ã›å¤§ã—ãŸç†ç”±ã˜ã‚ƒãªã„ã ã‚ã¨æ€ã£ã¦æŽ˜ã£ã¦ã¿ãŸã‚‰ã‚„ã£ã±ã‚Šå¤§ã—ãŸç†ç”±ã˜ã‚ƒãªã‹ã£ãŸâ€¦ https://t.co/6NeetGhTF0â€” Ryuta Kamizono (@kamipo) April 18, 2014 Railsã§collationã¨ã—ã¦utf8_unicode_ci(Railsã®DEFAULT_COLLATION)ãŒæŽ¡ç”¨ã•ã‚Œã‚‹ã®ã¯charsetãŒæœªæŒ‡å®šã‚‚ã—ãã¯utf8(Railsã®DEFAULT_CHARSET)ã®ã¨ãã ã‘ã§ã€utf8mb4ã«ã™ã‚‹ã“ã¨ã¨ã‹ã¯å…¨ãè€ƒæ…®ã•ã‚Œã¦ãªã„ã€‚â€” Ryuta Kamizono (@kamipo) April 19, 2014 @frsyuki MySQLã®charset utf8ã®ã¨ãã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ
ori53 2015/03/09
MySQL

Rails
ãƒªãƒ³ã‚¯
GitHub - jeremycole/innodb_ruby: A parser for InnoDB file formats, in Ruby
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
ori53 2015/03/07
mysql

innodb
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é‹ç”¨ã«ã¤ã„ã¦è‰²ã€…
12. ã‚¹ãƒ†ãƒƒãƒ—çš„ãªã‚‚ã® ã‚µã‚¤ã‚º ä½¿ã„ã©ã“ã‚ ã‚³ãƒžãƒ³ãƒ‰ä¾‹ ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã§ã‹ã„ å¿…ãšå¿…è¦ tar, rsync, mysqldump, XtraBackup å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— â¼©ã•ã„ ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã® é–“éš”ãŒçŸã‘ã‚Œã°è¦ã‚‰ ãªã„ mysqldump(ã‚¹ã‚ãƒ¼ ãƒžã«åˆ¶ç´„) XtraBackup å¢—åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— æ›´æ–°é‡ã«ä¾å˜ ã»ã¼é–“é•ã„ãªãå¿…è¦ cp, rsync, mysqlbinlog 11/58 14. ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®é¸æŠžè‚¢ ã‚³ãƒžãƒ³ãƒ‰ ã‚¨ãƒ³ã‚¸ãƒ³ ã‚¢ãƒ—ãƒªå½±éŸ¿ â½…å¼ ã‚µã‚¤ã‚º tar, rsync MyISAM Ã— åœâ½Œã¾ãŸã¯ãƒãƒƒ ã‚¯ ç‰©ç† â¼¤ãã‚ tar, rsync InnoDB Ã— mysqldåœâ½Œ ç‰©ç† â¼¤ãã‚ LVMã‚¹ãƒŠãƒƒãƒ— ã‚·ãƒ§ãƒƒãƒˆ MyISAM InnoDB â–³ æ€§èƒ½åŠ£åŒ–ãŒã²ã© ã„ ç‰©ç† â¼¤ãã‚ mysqldump MyISAM Ã— ãƒãƒƒã‚¯ è«–ç† â¼©ã•ã‚ mysqldum
ori53 2015/03/02
mysql
ãƒªãƒ³ã‚¯
Galera replication â€“ how to recover a PXC cluster
Galera replication for MySQL brings not only the new, great features to our ecosystem, but also introduces completely new maintenance techniques. Are you concerned about adding such new complexity to your MySQL environment? Perhaps that concern is unnecessarily. I am going to present here some simple tips that hopefully will let fresh Galera users prevent headaches when there is the need to recove
ori53 2015/02/26
mysql

cluster
ãƒªãƒ³ã‚¯
How to check MySQL Config files
ori53 2015/02/26
my.cnfã®syntax check

mysql
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/MySQL/entry/oracle_s_mysql_image_coming
ori53 2015/02/11
å…¬å¼ã®ã¯ã©ã†ãªã£ã¡ã‚ƒã†ã‚“ã ã‚

Docker

mysql
ãƒªãƒ³ã‚¯
Z.com Cloud for App/æ©Ÿèƒ½ãƒ»æ–™é‡‘ | IaaSåž‹ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã®Z.com Cloud
Z.com Cloud for Appã¯ã€ã‚²ãƒ¼ãƒ ã«å¿…è¦ãªæ©Ÿèƒ½ã‚’è±Šå¯Œã«å–ã‚Šæƒãˆã¦ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ã®ã”åˆ©ç”¨ç”¨é€”ã«å¿œã˜ã¦ã€ãƒ—ãƒ©ãƒ³ãƒ»æ©Ÿèƒ½ã‚’ãŠé¸ã³ãã ã•ã„ã€‚ ã‚µãƒ¼ãƒãƒ¼/ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ ä»®æƒ³ã‚µãƒ¼ãƒãƒ¼ å°‚ç”¨ã‚µãƒ¼ãƒãƒ¼ ãƒ–ãƒãƒƒã‚¯ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ ã‚¤ãƒ¡ãƒ¼ã‚¸ä¿å˜ ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ ãƒ‡ãƒ¼ã‚¿è»¢é€é‡ ä»®æƒ³ã‚µãƒ¼ãƒãƒ¼ç”¨ã‚°ãƒãƒ¼ãƒãƒ«IPã‚¢ãƒ‰ãƒ¬ã‚¹ å°‚ç”¨ã‚°ãƒãƒ¼ãƒãƒ«IPã‚¢ãƒ‰ãƒ¬ã‚¹ ã‚¢ãƒ—ãƒ©ã‚¤ã‚¢ãƒ³ã‚¹åž‹ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µãƒ¼ ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ï¼ˆVLANï¼‰ CDN ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ SSLè¨¼æ˜Žæ›¸ ãã®ä»– é›»è©±ãƒ»ãƒ¡ãƒ¼ãƒ«ã‚µãƒãƒ¼ãƒˆ ãƒ‰ãƒ¡ã‚¤ãƒ³å–å¾—ãƒ»ç®¡ç† è¡¨ç¤ºä¾¡æ ¼ã¯ç¨Žè¾¼ã¿ã§ã™ã€‚ ã”è«‹æ±‚æ™‚ã«æ¶ˆè²»ç¨Žã®ç«¯æ•°ã‚’å‡¦ç†ã™ã‚‹ãŸã‚ã€å®Ÿéš›ã®è«‹æ±‚é¡ã¨è¡¨ç¤ºé¡ã¨ãŒç•°ãªã‚‹å ´åˆãŒã”ã–ã„ã¾ã™ã€‚ åˆ¥é€”ã€ã‚µãƒ¼ãƒ“ã‚¹ç¶æŒèª¿æ•´è²»ã‚’ã”è«‹æ±‚ã•ã›ã¦ã„ãŸã ãã‚µãƒ¼ãƒ“ã‚¹ãŒã”ã–ã„ã¾ã™ã€‚è©³ç´°ã¯ã“ã¡ã‚‰ã‚’ã”ç¢ºèªãã ã•ã„ã€‚
ori53 2014/10/30
ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¯ãƒ‡ãƒ¼ã‚¿ãŒè‡ªå‹•çš„ã«è¤‡æ•°ã®ã‚µãƒ¼ãƒã«ä¿å˜ã•ã‚Œã‚‹ã®ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ä¿å˜å…ˆã¨ã—ã¦ã‚‚å®‰å¿ƒã§ãã¾ã™ãã€‚å®‰ã„ã—ã€‚

GMOã‚¢ãƒ—ãƒªã‚¯ãƒ©ã‚¦ãƒ‰

swift

mysql
ãƒªãƒ³ã‚¯
[Q&A]MySQLé–‹ç™ºã§ã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãªè‡´å‘½çš„ãƒŸã‚¹ | Yakst
Percona MySQL Webinarsã®ç™ºè¡¨(MYSQLé–‹ç™ºã§ã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãªè‡´å‘½çš„ãªãƒŸã‚¹ã«ã¤ã„ã¦)ã®QAã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ æœ¬ç™ºè¡¨ã¯SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³è‘—è€…ã®Bill Karwinã•ã‚“ã®ç™ºè¡¨ã§ã™ã€‚ ã‚ªãƒªã‚¸ãƒŠãƒ«: http://www.percona.com/resources/mysql-webinars/how-avoid-even-more-common-deadly-mysql-development-mistakes July 17, 2014 by Bill Karwin æ°´æ›œæ—¥ã«ã€ŒMySQLã‚’é–‹ç™ºã™ã‚‹ä¸Šã§ã‚ˆãèµ·ã“ã‚‹(ãã—ã¦è‡´å‘½çš„ãª)ãƒŸã‚¹ã‚’ã©ã®ã‚ˆã†ã«å›žé¿ã™ã‚‹ã‹ã€ã‚’Percona MySQL webinarsã§ç™ºè¡¨ã—ãŸã€‚ãŠè¦‹é€ƒã®éš›ã¯ã€ãƒ“ãƒ‡ã‚ªã¨ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’è¦‹ã‚‹ç‚ºã«ç™»éŒ²ã™ã‚Œã°ã¾ã ã”è¦§ã«ã„ãŸã ã‘ã‚‹ã€‚ å‚åŠ ã„ãŸã ã„ãŸçš†æ§˜ã€ãã—ã¦ã¨ã‚Šã‚ã‘ã™ã°ã‚‰ã—ã„è³ªå•ã‚’ã—ã¦ã„ãŸã ãã‚ã‚ŠãŒãŸãæ€ã£ã¦ã„ã‚‹
ori53 2014/08/11
mysql
ãƒªãƒ³ã‚¯
GitHub - bennojoy/mysql: ansible role for mysql
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
ori53 2014/06/11
ansible

mysql
ãƒªãƒ³ã‚¯
ã¨ã‚ã‚‹è¨ºæ–å“¡ã¨SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³
7. é€šå¸¸ã®Webã‚µãƒ¼ãƒã¨ã®é€šä¿¡ <html> <body> <form action=â€œregisterâ€ method=â€œPOSTâ€> æ°å:vultest<BR> ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹:vulte [email protected]<BR> æ€§åˆ¥:ç”·<BR> ï¼ˆä»¥ä¸‹ç•¥ï¼‰ </html> POST /confirm.php HTTP/1.1 Host: example.jp ï¼ˆä»¥ä¸‹ç•¥ï¼‰ Cookie: PHP SESSID=xxxxxxxxxx name=vultest&mail=vultest%40example.jp&gender=1 HTTP Response HTTP Request 8. è‰²ã€…ã„ã˜ã£ã¦ã¿ã¦ã©ã†ã„ã†å¿œç”ãŒã‚ã‚‹ã‹ç¢ºèª POST /confirm.php HTTP/1.1 Host: example.jp ï¼ˆä»¥ä¸‹ç•¥ï¼‰ Cookie: PHP SESSID=xxxxxxxxxx name
ori53 2014/05/26
security

mysql
ãƒªãƒ³ã‚¯
Upgrading to MariaDB From MySQL 5.0 or Older
ori53 2014/05/17
mariadb

mysql
ãƒªãƒ³ã‚¯
MariaDB versus MySQL - Compatibility
Replacement for MySQL Until MariaDB 5.5, MariaDB versions functioned as a "drop-in replacement" for the equivalent MySQL version, with some limitations. From MariaDB 10.0, it is usually still very easy to upgrade from MySQL. MariaDB's data files are generally binary compatible with those from the equivalent MySQL version. All filenames and paths are generally the same. Data and table definition fi
ori53 2014/05/16
mariadb

mysql
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQLã¨MariaDBã®é•ã„ä¸€è¦§ - æŠ€è¡“ãƒ¡ãƒ¢ç½®ãå ´
(2014.12.3è¿½è¨˜ï¼šã“ã®blogã®å†…å®¹ã¯ã€ä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚åæ˜ ã•ã›ãŸã€‚) SQLãƒ¬ãƒ™ãƒ«ã®å·®ç•° MariaDB5.5ã¨MySQL5.5ã§ã¯SQLãƒ¬ãƒ™ãƒ«ã§ã®é•ã„ã¯ã»ã¨ã‚“ã©ãªã‹ã£ãŸã€‚autoincrementã®æœ€å¤§å€¤ã®æ‰±ã„ãã‚‰ã„ã€‚ ãŸã ã—ã€MariaDB10.0ã§REGEXPãŒãƒžãƒ«ãƒãƒã‚¤ãƒˆå¯¾å¿œã«ãªã£ãŸã®ã§ã€ã‚¢ãƒ—ãƒªå´ã¯æ³¨æ„ã€‚ é …ç›® MySQL MariaDB Autoincrement æœ€å¤§å€¤ã«é”ã™ã‚‹ã¨ã€ä»¥é™ã¯æœ€å¤§å€¤ã‚’ç¹°ã‚Šè¿”ã™ã€‚Warningã®ã¿ã€‚ã‚¨ãƒ©ãƒ¼ã«ãªã‚‰ãªã„ã€‚tinyintãªã‚‰â€¦,125,126,127,127,127â€¦ æœ€å¤§å€¤-1ã¾ã§ã€‚ä»¥é™ã¯ã‚¨ãƒ©ãƒ¼ã‚’è¿”ã™ã€‚tinyintãªã‚‰â€¦,125,126,ERROR,ERROR,â€¦ EXPLAINæ–‡ JSONå½¢å¼ ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œ Optimizer Trace ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œï¼ˆãŸã ã—ã€MariaDBã®ã»ã†ãŒã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶
ori53 2014/05/16
mariadb

mysql
ãƒªãƒ³ã‚¯
OOM relation to vm.swappiness=0 in new kernel
I have recently been involved in diagnosing the reasons behind OOM invocation that would kill the MySQL server process. Of course these servers were primarily running MySQL. As such the MySQL server process was the one with the largest amount of memory allocated. But the strange thing was that in all the cases, there was no swapping activity seen and there were enough pages in the page cache. Iron
ori53 2014/04/30
mysql

kernel
ãƒªãƒ³ã‚¯
MySQL :: MySQL Community Downloads
Skip to Main Content MySQL Community Downloads MySQL Yum Repository MySQL APT Repository MySQL SUSE Repository MySQL Community Server MySQL NDB Cluster MySQL Router MySQL Shell MySQL Operator MySQL NDB Operator MySQL Workbench MySQL Installer for Windows C API (libmysqlclient) Connector/C++ Connector/J Connector/NET Connector/Node.js Connector/ODBC Connector/Python MySQL Native Driver for PHP MySQ
ori53 2014/02/21
MySQLã®yumãƒ¬ãƒã‚¸ãƒˆãƒª

mysql

repository
ãƒªãƒ³ã‚¯
1 2 3 4 5 æ¬¡ã®ãƒšãƒ¼ã‚¸