Redirecting⦠Click here if you are not redirected.
Redirecting⦠Click here if you are not redirected.
æ¥åã§GitHubã使ã£ã¦ãã¦ãdevelopãã©ã³ãã«ãã¼ã¸ããããã¹ãã¼ã¸ã³ã°ç°å¢ã¨ãã¦ä½¿ã£ã¦ããAWSä¸ã®ãµã¼ãã«ãããã¤ãããããã«ãã¦ãã¾ãããã®æç¹ã§å²ã¨ä¾¿å©ãªãã§ããããã¼ã¸åã«ãã¶ã¤ã³ãæåã確èªãããã¨ããã±ã¼ã¹ãå¤ãã®ã§ãã®é¨åä½ã¨ãããããªãã¨æã£ã¦ãã¾ããã Review Appsã¨ã¯ æè¿ãHerokuã¯GitHubã¨ã®é£æºãå¼·åãã¦ãã¾ãã以åã ã£ãã GitHubã®ç¹å®ã®ãã©ã³ãã«PushãããããHerokuã«ãããã¤ãã ã¨ãããã¨ãå®ç¾ãããã¨ããã¨ãCircleCIãªã©ã®CIãã¼ã«ã使ã£ã¦ããã®ãä¸è¬çã§ããã ãããæè¿å¤ããã¾ãããHerokuå´ããGitHubã¨ç´æ¥é£æºãã¦ããGitHubã®å¤æ´ãåãã¦Herokuã«ãããã¤ããHerokuå´ã®ç»é¢ã§ããããããã ãã§ç°¡åã«å®ç¾ã§ããããã«ãªã£ã¦ãã¾ãã ãã®æç¹ã§ããªã便å©ãªã®ã§ãããããã«ãP
ãã®è¨äºã¯ã¯ã¦ãªãããããã¼ã¢ããã³ãã«ã¬ã³ãã¼2015ã®12æ24æ¥ã®è¨äºã§ãã æ¨æ¥ã¯ id:stefafafan ããã®ã¨ã³ã¸ãã¢ã¨è±èªã§ããã ããã«ã¡ã¯ãããã°ãã¯ã ã¯ãªã¹ãã¹ã»ã¤ã´ã§ãããçããã¯ã©ã®ãããªä¸æ¥ãéãããã(ã)ã®ã§ããããã åã¯ä¸äººã§ãã æ¹ãã¾ãã¦ãå æ¥åãã¦ã®åã³ã³ãçµé¨/失æãã¦äºåº¦ã¨è¡ããªãã¨èªã£ã ã¯ã¦ãªã® id:ichirin2501 ã§ããä»åã¯å°ãã¿ã¨ãã¦MySQL(InnoDB)ã®BULK INSERTã«ããããããããã¯ã®è©±ããããã¨æãã¾ãããã ãå¤é¨ãã¼å¶ç´ã絡ãã¨è¤éã«ãªãã®ã§ä»åã¯è§¦ãã¾ãããããã«ã¤ãã¦ã¯ãã¡ããåç §ãã ããã ããã¿ã¤ãã«ã¯ãªãã¼ã¸ã¥ã§ã*1ã Topic æ¤è¨¼ç°å¢ INSERTã®ããããã㯠é¿ããããªãã±ã¼ã¹ ãããã¯ããã¯ãã ãªãã©ã¤å¦çã«æ³¨æ åæãã¼ã¿ Duplicateã®å ´å Deadlockã®
â ãã¼ã ãï¼ å代ALF (@soudai1025) 2015, 8æ 24 ã¨ãã¼ã¡ã©ã³æãã¦è¦äºã«åºãã£ã¦ãã®ã§ä»ããè¨äºæ¸ãã 両ãµã¤ãã«ã¯ããªãå³ãã話ããããä¿ºã®æ¬é³ãè´ãã¦ããï¼é¢ç½å®£è¨ï¼ ã¾ãæ´å²ã®é·ãRDBãªã®ã§ãäºãã®æ¯è¼è¨äºã¯æ²¢å±±ããã ãªã®ã§ãã«ãã¹ã¬ãã(MySQL)ã¨ãã«ãããã»ã¹(PostgreSQL)ã ã¨ãVACUUMã ã£ã¦è©±ã¯ããªãã ãããå®éã«ä½¿ã£ã¦ã¿ãéã®éããã«ãã©ã¼ã«ã¹ããã 1. SQLã®éã åºæ¬çã«MySQLã§ãã£ã¦ãããã¨ã¯PostgreSQLåºæ¥ãã ããã颿°ã®æåã®éãã¯å¹¾ã¤ãããã ä¾ãã°æéããææ¥ã«è©²å½ããæ°åã«å¤æããå ´åã« MySQLãâãdate_format(time,"%w")ã0ããå§ã¾ããæ¥ææ¥ã«è©²å½ãã PostgreSQLãâãto_char(time,'D')ã1ããå§ã¾ããæ¥ææ¥ã«è©²å½ãã ãªã©æåã«äºææ§
ç¾å®çãªWebãµã¼ãã¹ç°å¢ã«ããã¦ãDockeråã«ããããã©ã¼ãã³ã¹ä½ä¸ãã©ã®ç¨åº¦ã®ãã®ã調æ»ããããã«ã ISUCON4 ã®äºé¸åé¡ã®ãã¡ãNginx 㨠MySQL é¨åã Docker åãã¦ãã³ããã¼ã¯ãã¨ã£ã¦ã¿ãã å ¸åçãªWebãµã¼ãã¹ã·ã¹ãã ã®3層æ§é ï¼Proxy, App, DBï¼ãæ§ç¯ãããã³ããã¼ã«ã¼ã«ããé«ã¯ã¼ã¯ãã¼ããå®ç¾ã§ããã®ã§ãISUCON ã®äºé¸åé¡ã¯é©å½ãªé¡æã¨ãããã Docker ã®ããã©ã¼ãã³ã¹ã«ã¤ãã¦çæãããã¨ã¯å æ¥æ¸ããã¨ã³ããªã«å ¨ã¦æ¸ãã¦ãã ä¸è¨ã®ã¨ã³ããªãè¦ç´ããã¨ãDocker ã®ããã©ã¼ãã³ã¹ã«ã¤ãã¦éè¦ãªãã¨ã¨ã¯ storage-driver ã®é¸æ (AUFS or Device mapper or ...) Volume ã® ON / OFF AUFS ãªã©ã®å·®åãã¡ã¤ã«ã·ã¹ãã ããã¤ãã¹ãããããªãã Host networ
Railsè¤æ°DB Casual Talks - connpass ãç²ããã¾ã§ããã 彿¥ã¯æºåä¸è¶³ã§è³æããã ã®ãªã³ã¯éã ã£ãã®ãå ¬éç¨ã«å½ç¤¾æ¯800%ãããå çããã®ã§ã彿¥åå ã§ããªãã£ã人ãè¦ã¦ãå 容ããããããã«ãªã£ã¦ãã¨æãã¾ãã MySQLã¨ActiveRecord @ryopekoããã®ãã¤ã¼ããµãã¼ã£ã¦ããã¿ããªãè¤æ°DBã®è©±ãããªãã§ã²ã¨ãã ãMySQLã®è©±ããã¨ãå ¬éå¦åãªã®ã§ã¯ï¼ï¼ã¨æã£ããã©ãã¡ããã©ã¿ããªestablish_connectionã®è©±ã§ããªããã£ã±ãã§ããããããæ¥½ããã§ããããããã§ããã£ãã§ãã @kamipo fav ãããã¨ãããã¨ã¯ã¬ã¼ã«ãºã§ DB å¨ãã®ã¤ãã話ãä½ã話ãã¦ãããã¨æã£ã¦å¤§ä¸å¤«ã§ããï¼â è¤æ°DB (@ryopeko) October 3, 2014 YAPC ã®ã¨ãã« kamipo ãã㨠HUB ã§è©±ããæã«ãã¬ã¼
MySQL Performance Blogã®ç¿»è¨³ãPerconaã®ãµãã¼ãã¨ã³ã¸ãã¢ã«ãããMySQLãã¼ã¸ã§ã³ã¢ããã®æ§ã ãªãã¿ã¼ã³ã¨ããã®å©ç¹ã»æ¬ ç¹ãæé ã®è§£èª¬ããã¼ã¸ã§ã³ã¢ãã宿½åã®ãäºå調æ»ã¨ãã¹ããéè¦ã§ããã¨ã®ææãã MySQLã®ãã¼ã¸ã§ã³ã¢ãã(訳注 : åæã§ã¯upgradeã以ä¸åã)ã¯ã©ããã§å¿ è¦ã«ãªãã¿ã¹ã¯ã ããæã Percona Supportã§ãMySQLãã¼ã¸ã§ã³ã¢ããã®ãã¹ããã©ã¯ãã£ã¹ã«ã¤ãã¦ã®è²ã ãªè³ªåãåãä»ãã¦ããããã®è¨äºã§ã¯ãè²ã ãªã·ããªãªã«ãããMySQLãã¼ã¸ã§ã³ã¢ããã®æ¨å¥¨ã§ããæ¹æ³ã«ç¦ç¹ãå½ã¦ã¦ã¿ããã MySQLã®ãã¼ã¸ã§ã³ã¢ããã¯ãªãå¿ è¦ã«ãªã£ã¦ãã¾ãã®ãï¼ãã®çç±ã¯è²ã ã ããæ°æ©è½ãå¿ è¦ãããã©ã¼ãã³ã¹ã®æ¹åããã°ä¿®æ£ãªã©ãããã ãããããããã¢ããªã±ã¼ã·ã§ã³ã¨çµã¿åãããä¸ã§äºåã«åºç¯å²ãªãã¹ãããã¦ãããªãã¨ããªã¹ã¯ã®å¤§ãã
ã¢ã¯ã»ã¹ã©ã³ãã³ã°ãä½ã£ã¦ã¿ããï¼ ä»ãRails4 ã使ã£ã¦ã¢ã¯ã»ã¹ãã°ããã©ã³ãã³ã°ä½ã£ã¦ã¿ãããªãã¼ã¨æã£ã¦ããã§ãããã¿ããªã©ããã£ã¦ãã ããã£ã¦èãã¦ã¿ãã¨ããã Fluentd ã£ã¦ã®ãçµã¿è¾¼ãã ãã§ç°¡åã«éè¨ã¨ãã§ãããã¼ã£ã¦è©±ã ã£ãã®ã§ã使ã£ã¦ã¿ã¾ããã Fluentd ã¨ã¯ ã¾ãèªã¿æ¹ã¯ã ããµãã¼ããã¨ã§ãã¼ãã§ãã£ã¦ãããµãã¼ããã©ãã¨ããããªãã£ã½ãã§ããd ã¯ãã¶ããã¼ã¢ã³ã® d ã è²ã 説æé¢åãªãã§çç¥ãã¾ããããã°åéå ã¨ãåºåå ãç°¡åã«è¨å®ã§ãã¦ãèªåã®æ¬²ããå½¢ã§ãã°ä¿æã§ãã¾ããã¼ã£ã¦æãã£ã½ãããªã®ã§ã ãã·ã§ã«ã¹ã¯ãªããã§å¦çãã tail ã®å¦ççµæããã¡ã¤ã«ã«ããnginx ããåºåãããã¢ã¯ã»ã¹ãã°ã mongoDB ã«ãã¨ãããããå¦çãèªåã§æ¸ãå¿ è¦ãªããç°¡åãªè¨å®ã ãã§ããã¡ããã 詳ããã¯ â æè»ãªãã°åéãå¯è½ã«ãããfluentd
ã©ã®æé©åãå¹ãããâ¦ã¨ã°ã°ã£ãã 以åã調ã¹ãæ°ããããæãã ãããã²ãããã°ã°ãç¾½ç®ã«ãªã£ãã®ã§ã åçãã¦ããã°ã«æ®ãããµã¤ã¼ã«mysqlã®documentã«æ¸ãã¦ãã£ãã http://dev.mysql.com/doc/refman/5.7/en/limit-optimization.html If you use LIMIT row_count with ORDER BY, MySQL ends the sorting as soon as it has found the first row_count rows of the sorted result, rather than sorting the entire result. If ordering is done by using an index, this is very fast. ãã¼ã¸ã§ã³å¤ããã©æ¥æ¬èªã®ã»
Rails 3 ç³»+MySQL ãå©ç¨ãã¦ãããµã¼ãã¹åãã« 1. ã©ã®ããã«ããã«ããã¯ãæ¢ãã®ã 2. ã©ã®ãããªè¨è¨ãè¡ãã°ããã®ã 3. Railsä¸ã§ã©ã®ãããªã³ã¼ããæ¸ãã°ããã®ã ã®3ç¹ã«çµã£ã¦ãã®ãã¬ã¼ã³ãã¿ã¦ãã¥ã¼ãã³ã°ãè¡ããããã«è³æä½æãè¡ãã¾ãã
MySQL Performance Blogã®ç¿»è¨³ãã¤ã³ã¹ãã¼ã«å¾ã«å¿ ãè¨å®ã確èªããªããã°ãªããªãè¨å®ãã©ã¡ã¼ã¿10ã¤ãæãããã®æå³ã解説ãããMySQLã®è¨å®å¤æ´æã®ãä¸è¬çãªæ³¨æç¹ãåããã¦ã January 28, 2014 By Stephane Combaudon æã ãããã©ã¼ãã³ã¹ç£æ»ã®ä»äºãããæã«ã¯ãMySQLã®è¨å®ã®ã¬ãã¥ã¼ã¨æ¹åææ¡ãæ±ããããã大æµã®å ´åãããããã®ãªãã·ã§ã³ãããä¸ã§ã»ãã®ããã¤ãã®è¨å®ãã夿´ããããã«ææ¡ããªããã¨ã«ãå¤ãã®é¡§å®¢ã¯é©ãããã®è¨äºã®ã´ã¼ã«ã¯ããã£ã¨ãéè¦ãªè¨å®ãããã¤ãæãã¦ã¿ããã¨ã«ããã æ¢ã«ãããã£ãææ¡ã¯éå»ã«ããã¦ãããæ°å¹´åã®ãã®ã§ããã以æ¥MySQLã®ä¸çã§ã¯ããããã®å¤åããã£ãã®ã ã 話ã®åã« çç·´ãã人ã§ããé大ãªãã©ãã«ãå¼ãèµ·ãããã¹ããã§ãããã¨ããããå¾ã£ã¦ãããã«æãããã®ãç²ç®çã«é©ç¨ããåã«ã
ããå¯ã®å ¥ããéãã¾ããããDBAã®ããªãã§ãã GAãããããã1å¹´ã社å ã§ã¯ããç¸å½ã«ã¸ã¥ã¢ã«ã«MySQL 5.6ãã¤ã³ã¹ãã¼ã«ãã¦ãã¾ããä»ã¾ã§ã¯æ°è¦ãµã¼ãã¹(ããæ°è¦æ©è½)ã§ã®å°å ¥ãã»ã¨ãã©ã ã£ã5.6ãããã®ãã³ãã©ãã£ãã¯ã¬ã³ã¬ã³ã®ãµã¼ãã¹ã«ã¢ããã°ã¬ã¼ãã§å°å ¥ãã¾ããï¼ã¨ãåããã«è¨ã£ã¦ãã¾ããç§ã§ãªãå¥ã®DBAæ°ã主æ å½ã®ãµã¼ãã¹ã§ãï¼ ä¸»ãªçç±ã¯InnoDB Compressedã使ã£ã¦ããã®ã§ãã®æ§è½ã¢ããã«æå¾ â¦ã¨ããã¨ããã ã£ããã§ãããå¼ç¤¾DBAãç¥ä»£ã®æä»£ãã試è¡é¯èª¤ãéããã©ãçãã究極ã®my.cnf(?)ãããããç§ä¼ã®ã¿ã¬ã æ®ã念ããªãããããè ãã£ãã¦ãããã å¤ãå¾¹ãã¦ã¢ããã°ã¬ã¼ã使¥ããã¦ããæ å½DBAæ°ãéãé¡(æ¨å®ããã£ããã ã£ã)ã§ ã¹ãããã¼ãã¯ãã¨ããªãã¼ããã1ã0ãåãããããããã«ããªãã£ãããããã ãããã©ã⦠ã¨è¨´ããå½¼ã¯ãã®
ããããä¸çã§ãã£ã¨ãå¤§è¦æ¨¡ã«MySQLã®ã¯ã©ã¹ã¿ãå±éããéç¨ãã¦ããã®ãFacebookã§ããããè¤æ°ã®ãã¼ã¿ã»ã³ã¿ã¼ã«ã¾ãããä½åå°ãã®MySQLãµã¼ããéç¨ããããã«ãèªååã®ä»çµã¿ã¯æ¬ ããã¾ããã ãã®èªååãã©ã®ãããªä»çµã¿ã«ãªã£ã¦ããã®ããFacebookã®ãã¼ã¿ãã¼ã¹ã¨ã³ã¸ãã¢ã§ããShlomo Priymakæ°ããUnder the hood: MySQL Pool Scanner (MPS)ã¨ããè¨äºãFacebookã§å ¬éãã¦ãã¾ãã ããªãé·ãè¨äºãªã®ã§ãããã§ã¯ãã®ãã¤ã³ããã¾ã¨ãã¦è§£èª¬ãã¦ã¿ã¾ããã詳細ã¯ãã²åæãããã£ã¦ã¿ã¦ãã ããã MPSã®ãããª3ã¤ã®æ©è½ Facebookã§ç¨¼åãã¦ããMySQLã¯ãã¤ãã«1ã¤ã®ãã¹ã¿ã¼ã¨ããããã¬ããªã±ã¼ã·ã§ã³ãããè¤æ°ã®ã¹ã¬ã¼ãã«ããã¬ããªã«ã»ãããæ§æãã¦ãã¾ãããã®ã¬ããªã«ã»ããã®æ§é ãç¶æãç¶ãããã¨ã§ãå¯ç¨æ§ã¨
Googleãå é¨ã§å©ç¨ãã¦ãããã¼ã¿ãã¼ã¹ãMySQLããMariaDBã«ä¹ãæããã®ã§ã¯ãªãããã¨ããè¨äºãå é±ããããã¤ãå ¬éããã¦ãã¾ãã Google swaps out MySQL, moves to MariaDB ⢠The Register Google Waves Goodbye To MySQL In Favor Of MariaDB â ReadWrite Google quietly dumps Oracle MySQL for MariaDB | ZDNet ä¸çªæåã®è¨äºã¨ãªã£ãThe Registgerã§ã¯ã次ã®ããã«æ¸ãã¦ãã¾ãã Google is migrating its MySQL systems over to MariaDB, allowing the search company to get away from the Oracle-bac
ããã ãè¦ãã°å¤§ä¸å¤«ï¼ã¼MySQLããã©ã¼ãã³ã¹ç£è¦ã®ããï¼ã·ã¹ãã ç·¨ï¼ ããã«ã¡ã¯ nob ã§ãã åç·¨ãããã ãè¦ãã°å¤§ä¸å¤«ï¼ã¼MySQLããã©ã¼ãã³ã¹ç£è¦ã®ããï¼ã¯ã¨ãªç·¨ï¼ãã®è¨äºããï¼å¹´åãçµéãã¦ãã¾ãã¾ãããã¡ãã£ã¨é·ããä¼ã¿ã§ãããããã®éã«èãã MySQL ããã©ã¼ãã³ã¹ç£è¦ã®å®æ¦çµé¨ãï¼ã·ã¹ãã ç·¨ï¼ã¨ãã¦ãå±ããããã¾ãï¼ ä»åã®ï¼ã·ã¹ãã ç·¨ï¼ã§ç´¹ä»ãããã㯠4 ã¤ã§ããï¼ã¯ã¨ãªç·¨ï¼ã®ããã«å ãã¦ããã®4ã¤ã«æ³¨ç®ãã¦é ããã° MySQL ã®ããã©ã¼ãã³ã¹ç£è¦ãããããªã§ãã ï¼ããï¼ï¼Load Average < (1 + (cpuæ°-1)/3) ï¼ããï¼ï¼Checkpoint Age ãæ°´å¹³ç·ã«ãªã£ããè¦æ³¨æ ï¼ããï¼ï¼MyISAM ã¯ç¡ãããç£è¦ ï¼ããï¼ï¼ä¸è½é¸æã¹ãã¼ãã° ãªãåç·¨ã¨åæ§ãã®è¨äºã§ã¯ç£è¦ãã¼ã«ã¨ãã¦Â Cacti 㨠Percona MySQL
ã©ã³ãã³ã°
ã¡ã³ããã³ã¹
ã©ã³ãã³ã°
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}