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

marukoro3150 id:marukoro3150

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

${{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 with InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã‚ã‚ŠãŒã¡ãªé–“é•ã„ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºéƒ¨ã®è’å¼• (@a_bicky) ã§ã™ã€‚ çªç„¶ã§ã™ãŒã€RDBMS ã®æ—¢å˜ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¦‹ã¦ã¿ãŸã‚‰ã€Œä½•ã§ã“ã‚“ãªã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã ã‚‰ã‘ãªã®ï¼Ÿã€ã¿ãŸã„ãªçµŒé¨“ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿä¸è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å®¹é‡ã‚’åœ§è¿«ã—ãŸã‚Šã€æŒ¿å…¥ãŒé…ããªã£ãŸã‚Šã¨è‰¯ã„ã“ã¨ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ ãã‚“ãªã‚ã‘ã§ã€ä»Šå›žã¯ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ¤œç´¢ã™ã‚‹ãŸã‚ã«å¿…è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã€ã‚ˆãè¦‹ã‹ã‘ã‚‹ä¸é©åˆ‡ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã¯ Rails ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä¸»ã« MySQL 5.6ã€MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ä¸»ã« InnoDB ã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã§ã€MySQL 5.6 ã® InnoDB ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«é–¢ã™ã‚‹åŸºç¤ŽçŸ¥è˜ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ§‹é€ (B+ æœ¨) InnoDB ã§ã¯ B+ æœ¨ãŒä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚B+ æœ¨ã¯æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ã‚’æŒã£ãŸæœ¨æ§‹é€ ã§ã™ã€‚ æ¬¡æ•°ã‚’ b ã¨ã™ã‚‹ã¨ã€
marukoro3150 2017/04/19
mysql

innodb
ãƒªãƒ³ã‚¯
MySQLã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãŠæ‰‹å…¥ã‚Œã®åŸºæœ¬ | Yakst
Percona Database Performance Blogã®ç¿»è¨³ã€‚æ—¢ã«é‹ç”¨ã‚’å§‹ã‚ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒæ£ã—ãä½¿ã‚ã‚Œã¦ã„ã‚‹ã‹ã€ç„¡é§„ã‚„ä¸è¶³ãŒãªã„ã‹ã‚’ç¢ºèªã™ã‚‹æ–¹æ³•ã®ã¾ã¨ã‚è¨˜äº‹ã€‚ã‚¯ã‚¨ãƒªã‚’ã²ã¨ã¤ã²ã¨ã¤ç¢ºèªã™ã‚‹ã®ã§ã¯ãªãã€çµ±è¨ˆæƒ…å ±ã‚’å…ƒã«åˆ¤æ–ã™ã‚‹åˆ†ã‹ã‚Šã‚„ã™ã„æ–¹æ³•ã€‚ ã“ã®ãƒ–ãƒã‚°è¨˜äº‹ã§ã¯ã€MySQLã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«æ‰‹å…¥ã‚Œã™ã‚‹åŸºæœ¬çš„ãªã‚¹ãƒ†ãƒƒãƒ—ã«ã¤ã„ã¦è¦‹ã¦ã„ã“ã†ã¨æ€ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ¬¡ç¬¬ã§ãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã‚‚ã€å½¹ç«‹ãŸãšã§é…ãã¦å¤§å¤‰ã«ã‚‚ãªã‚Šã†ã‚‹ã“ã¨ã¯ã”å˜çŸ¥ã§ã—ã‚‡ã†ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã€æ™‚ã€…æ‰‹å…¥ã‚Œã‚’ã™ã‚‹ä¾¡å€¤ãŒã‚ã‚‹éžå¸¸ã«é‡è¦ãªã‚‚ã®ã§ã™ã€‚ãã‚Œã§ã¯ã€ä½•ã‚’ãƒã‚§ãƒƒã‚¯ã™ã‚Œã°ã‚ˆã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿé †ä¸åŒã§ã™ãŒã€ç¢ºèªã™ã¹ãç‚¹ã‚’æŒ™ã’ã¦ã¿ã¾ã™ã€‚ 1. ä½¿ã‚ã‚Œã¦ã„ãªã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ sysã‚¹ã‚ãƒ¼ãƒžã§ã€ä½¿ã‚ã‚Œã¦ã„ãªã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¨ã¦ã‚‚ç°¡å˜ã«è¦‹ã¤ã‘ã‚‰ã‚Œã¾ã™ã€‚ schema_unused_indexes ãƒ“ãƒ¥ãƒ¼ã‚’
marukoro3150 2016/10/03
mysql
ãƒªãƒ³ã‚¯
MySQLãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆå…¥é–€
2015/04/30 schoo WEB-campus https://schoo.jp/class/2218 Read less
marukoro3150 2015/05/01
MySQL
ãƒªãƒ³ã‚¯
Dockerã‚³ãƒ³ãƒ†ãƒŠå†…ã«mysqlã‚µãƒ¼ãƒã‚’ç«‹ã¦ã‚‹ - Qiita
æ¦‚è¦ Dockerã‚³ãƒ³ãƒ†ãƒŠå†…ã«mysqlã‚µãƒ¼ãƒã‚’ç«‹ã¦ã¾ã™ã€‚ mysqlã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½œæˆã—ãŸã‚Šã€mysqlã‚µãƒ¼ãƒã‚’å¤–éƒ¨ã«å…¬é–‹ã™ã‚‹ã“ã¨ã‚‚è¡Œã„ã¾ã™ã€‚ å‹•ä½œç¢ºèªã‚’è¡Œã£ãŸç’°å¢ƒã¯ã€ãƒ›ã‚¹ãƒˆOS, ã‚³ãƒ³ãƒ†ãƒŠOSã¨ã‚‚ã«CentOSã§ã™ã€‚ ãã‚‚ãã‚‚Dockerã¨ã¯ ä»®æƒ³ç’°å¢ƒæ§‹ç¯‰ã« docker ã‚’ä½¿ã† - apatheia.info ã‚’èªã‚“ã§ãã ã•ã„ï¼ Dockerfile ã•ã£ããã§ã™ãŒã€ä»¥ä¸‹ãŒ Dockerfile ã§ã™ã€‚ ã‚³ãƒ³ãƒ†ãƒŠã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’ä½œæˆã™ã‚‹ãŸã‚ã«å¿…è¦ãªãƒ•ã‚¡ã‚¤ãƒ«ã§ã™ã€‚ # DOCKER-VERSION 0.3.4 FROM centos:6.4 # ã“ã“ã¯è‡ªç”±ã«å¤‰ãˆã¦ãã ã•ã„ MAINTAINER Taro Tanaka # ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« RUN yum install -y mysql mysql-server # mysqlã‚µãƒ¼ãƒã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ— RUN echo "NETWORKIN
marukoro3150 2014/08/08
docker

mysql
ãƒªãƒ³ã‚¯
WebScaleSQL | "We're Gonna Need A Bigger Database"
What is WebScaleSQL? WebScaleSQL is a collaboration among engineers from several companies that face similar challenges in running MySQL at scale, and seek greater performance from a database techno logy tailored for their needs. Our goal in launching WebScaleSQL is to enable the scale-oriented members of the MySQL community to work more closely together in order to prioritize the aspects that are
marukoro3150 2014/05/21
DB

mysql
ãƒªãƒ³ã‚¯
MySQLã®ã‚¯ã‚¨ãƒªé›†è¨ˆæ‰‹æ³•ã„ã‚ã„ã‚ | Ore no homepage
Webã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹ç™º/é‹ç”¨ã—ã¦ã‚‹ãƒ¢ãƒ³ã¨ã—ã¦ã¯ã€ã„ã‚ã‚“ãªWebã‚µãƒ¼ãƒ“ã‚¹ã‚’è§¦ã£ã¦ã¿ãªãã‚ƒã‚¢ã‚«ãƒ³ã£ã¦ã“ã¨ã§ã€ã‚¢ãƒ¡ãƒªã‚«ã®è‹¥ãƒ¢ãƒ³ã«å¤§äººæ°—ã£ã¦ãµã‚Œã“ã¿ã®snapchatã«ç™»éŒ²ã—ã¦ã¿ãŸã€‚ã“ã‚Œã§ãƒªã‚¢å……ã®ä»²é–“å…¥ã‚Šã‚„ã¨æ€ã£ãŸãŒã€snapchatå‹é”ãŒåŒåƒšäºŒäººã—ã‹ã„ãªã„ã†ãˆã«ã€åˆ©ç”¨ã‚·ãƒ¼ãƒ³ãŒã‚ã¾ã‚Šæ€ã„æµ®ã‹ã°ãªã„ww ã‚ªã‚¸ã‚µãƒ³å›°ã£ã¡ã‚ƒã„ã¾ã—ãŸã€‚ç”»åƒã¨ã‹é€ä¿¡ã§ãã‚‹ã‚“ã ã‘ã©ã€æ•°ç§’ã§æ¶ˆãˆã‚‹ã®ã€‚ã‚€ã—ã‚ãã“ãŒã‚¦ãƒªã£ã¦ã„ã†ãã€‚ã©ã†ã‚„ã£ã¦éŠã¼ã†ã‹â€¦ã€‚ 2æœˆã¯ãƒ–ãƒã‚°æ›¸ã‹ãªã‹ã£ãŸãªãƒ¼ã¨æ€ã£ãŸã®ã§MySQLå°ãƒã‚¿ã€‚ä¸–é–“çš„ã«ã‚‚è‡ªåˆ†çš„ã«ã‚‚çœŸæ–°ã—ãã‚‚ãªã‚“ã¨ã‚‚ãªã„Tipsã§ã™ã€‚ innotopã§é›†è¨ˆ å®Ÿã¯ä»¥å‰ã€Qiitaã«æ›¸ã„ãŸã®ã§â†“ã‚’ã°ã€‚ã€‚ã€‚ http://qiita.com/la_luna_azul/it ems/505ca441b8c8e6a87aaa æµã‚Œã‚‹ã‚¯ã‚¨ãƒªã€ãƒãƒƒã‚¯ã®çŠ¶æ³ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³(show engine innodb s
marukoro3150 2014/03/04
mysql
ãƒªãƒ³ã‚¯
Ruby on Rails on MySQL ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°å…¥é–€
Rails 3 ç³»+MySQL ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒ“ã‚¹å‘ã‘ã« 1. ã©ã®ã‚ˆã†ã«ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’æŽ¢ã™ã®ã‹ 2. ã©ã®ã‚ˆã†ãªè¨è¨ˆã‚’è¡Œãˆã°ã„ã„ã®ã‹ 3. Railsä¸Šã§ã©ã®ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã‘ã°ã„ã„ã®ã‹ ã®3ç‚¹ã«çµžã£ã¦ã“ã®ãƒ—ãƒ¬ã‚¼ãƒ³ã‚’ã¿ã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œãˆã‚‹ã‚ˆã†ã«è³‡æ–™ä½œæˆã‚’è¡Œã„ã¾ã—ãŸRead less
marukoro3150 2014/02/27
rails

ruby

mysql

DB
ãƒªãƒ³ã‚¯
SQLZoo
Tutorials: Learn SQL step by step 0 SELECT basics Some simple queries to get you started 1 SELECT name Some pattern matching queries 2 SELECT from World In which we query the World country profile table. 3 SELECT from Nobel Additional practice of the basic features using a table of Nobel Prize winners. 4 SELECT within SELECT In which we form queries using other queries. 5 SUM and COUNT In which we
marukoro3150 2014/02/26
MySQL

DB
ãƒªãƒ³ã‚¯
ç¬¬3å›žã€€ã™ã¹ã¦ã®MySQLãƒ¦ãƒ¼ã‚¶ã«é«˜é€Ÿãªå…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ã‚’ï¼ - mroongaã®ç´¹ä»‹ | gihyo.jp
å‰å›žã®åœ°ä¾¡ãƒžãƒƒãƒ—ã§ã®äº‹ä¾‹ç´¹ä»‹ã§ã¯ã€Ruby on Railsã‹ã‚‰groongaã¨mroongaã‚’ä½¿ã£ã¦ä½ç½®æƒ…å ±æ¤œç´¢ã‚’ã—ãŸäº‹ä¾‹ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚Active Recordã‚’æ‹¡å¼µã—ã¦ä½ç½®æƒ…å ±æ¤œç´¢ã‚’ã™ã‚‹ãŸã‚ã®gemã¨ãã®ä½¿ã„æ–¹ã‚‚ç´¹ä»‹ã—ã¦ã„ãŸã®ã§ã€Ruby on Railsãƒ¦ãƒ¼ã‚¶ã«ã¨ã£ã¦å®Ÿç”¨çš„ãªå†…å®¹ã ã£ãŸã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ä»Šå›žã¯ã€å‰å›žä½¿ã„æ–¹ã‚’ç´¹ä»‹ã—ãŸmroongaã«ã¤ã„ã¦ã€ã•ã‚‰ã«ç´¹ä»‹ã—ã¾ã™ã€‚å‰å›žã¯mroongaã®ä½¿ã„æ–¹ãŒã§ã¦ãã¾ã—ãŸãŒã€ä»Šå›žã¯ä½¿ã„æ–¹ã®ç´¹ä»‹ã¯ã—ã¾ã›ã‚“ã€‚ãã®ä»£ã‚ã‚Šã€mroongaè‡ªèº«ã®ã“ã¨ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚mroongaã®æ´å²ã€å¤§äº‹ã«ã—ã¦ã„ã‚‹ã“ã¨ã€ã•ã‚‰ã«ã©ã®ã‚ˆã†ãªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã«ãªã£ã¦ã„ã‚‹ã‹ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ è‡ªåˆ†ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§åˆ©ç”¨ã™ã‚‹ãƒ—ãƒãƒ€ã‚¯ãƒˆã‚’æ¤œè¨Žã™ã‚‹ã¨ãã«ã€ãƒ—ãƒãƒ€ã‚¯ãƒˆãŒã©ã®ã‚ˆã†ãªæ–¹å‘ã§ä½œã‚‰ã‚Œã¦ã„ã‚‹ã‹ã‚’è€ƒæ…®ã—ã¦ã„ã¾ã™ã‹ï¼Ÿ è‡ªåˆ†ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒå¤§äº‹ã«ã—ãŸã„ã“ã¨ã‚’ãã®
marukoro3150 2013/05/07
mroonga

mysql

å…¨æ–‡æ¤œç´¢
ãƒªãƒ³ã‚¯
Homebrewã§MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ™‚ã«çŸ¥ã£ã¦ãŠããŸã„ã“ã¨ | Macã¨ã‹ã®é›‘è¨˜å¸³
Homebrewã§MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹éš›ã®æ³¨æ„ç‚¹ãªã©ã«ã¤ã„ã¦ã§ã™ã€‚MySQLè‡ªä½“ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«è¡¨ç¤ºã•ã‚Œã‚‹æ³¨æ„æ›¸ãã©ãŠã‚Šã«è¨å®šã™ã‚Œã°å•é¡Œãªã‹ã£ãŸã®ã§ã™ãŒã€èµ·å‹•ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§å°‘ã—ãƒˆãƒ©ãƒ–ã£ãŸã®ã§å‚™å¿˜éŒ²ã§ã™ã€‚ ãã®ä»–ã«ã‚‚ãƒ¡ãƒ¢ã£ã¦ãŠããŸã„ã“ã¨ãŒã‚ã£ãŸã®ã§è¨˜äº‹ã«ã—ã¾ã—ãŸã€‚Homebrewã§MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸæ–¹ã®å‚è€ƒã«ãªã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨åˆæœŸè¨å®š ã¾ãšã¯MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒçµ‚äº†ã™ã‚‹ã¨ã€ä¸‹ã®ã‚ˆã†ã«è‰²ã€…ã¨è¡¨ç¤ºã•ã‚Œã‚‹ã®ã§ã€ãã®é€šã‚Šã«é€²ã‚ã¦ã„ã‘ã°ã¨ã‚Šã‚ãˆãšä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ã¡ãªã¿ã«ã€ã“ã‚Œã‚‰ã®æ³¨æ„æ›¸ãã¯$ brew info mysqlã‚’å®Ÿè¡Œã™ã‚Œã°ã„ã¤ã§ã‚‚è¦‹ã‚Œã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®è¨å®š ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒæ¸ˆã‚“ã ã‚‰ã€è¡¨ç¤ºã•ã‚ŒãŸå†…å®¹ã«å¾“ã£ã¦é †ã«è¨å®šã—ã¦ã„ãã¾ã™ã€‚æœ€åˆã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹å ´æ‰€ã®è¨å®šã‚’ã—ã¾ã™ã€‚ $ u
marukoro3150 2013/04/17
mysql

mac
ãƒªãƒ³ã‚¯
MySQLã®å†—é•·åŒ– 2013-01-24
2. Â© MATSUZAKI Yoshihiko 2013.1.24 è‡ªå·±ç´¹ä»‹ â€¢ æ¾å´Ž æ…¶å½¦ (MATSUZAKI Yoshihiko) â€¢ æ ªå¼ä¼šç¤¾ãƒãƒ¼ãƒˆãƒ“ãƒ¼ãƒ„ é‹ç”¨ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ â–« MSP(ã‚µãƒ¼ãƒé‹ç”¨ãƒ»ç›£è¦–)ã®ä¼šç¤¾ â–« 24æ™‚é–“æœ‰äººç›£è¦–ã‚’æä¾›ã—ã¦ã„ã‚‹ â–« ãƒ™ãƒ³ãƒ€éžä¾å˜ãªã‚µãƒ¼ãƒé‹ç”¨(ã©ã“ã§ã‚‚ã‚„ã‚‹) â€¢ æ™®æ®µã‚„ã£ã¦ã„ã‚‹æ¥å‹™ â–« ã‚µãƒ¼ãƒ“ã‚¹ç‰¹æ€§ã«åˆã£ãŸã‚¤ãƒ³ãƒ•ãƒ©ã®è¨è¨ˆãƒ»æ§‹ç¯‰ â–« ã‚µãƒ¼ãƒ“ã‚¹ç‰¹æ€§ã«åˆã£ãŸé‹ç”¨ã®è¨è¨ˆ â–« ã™ã§ã«å‹•ã„ã¦ã„ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã®ç§»è¨
marukoro3150 2013/01/29
mysql

é‹ç”¨

å†—é•·åŒ–
ãƒªãƒ³ã‚¯
é–‹ç™ºã‚¹ãƒ”ãƒ¼ãƒ‰ã‚¢ã‚¯ã‚»ãƒ«å…¨é–‹ã¶ã£ã¡ãŽã‚Šï¼æ—¥æœ¬ã‚ˆã€ã“ã‚ŒãŒMySQL 5.6ã ãƒƒï¼ï¼
ç±³å›½ã§è¡Œã‚ã‚Œã¦ã„ã‚‹MySQL Connectã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã§ã€ã¤ã„ã«MySQL 5.6 RCï¼ˆãƒªãƒªãƒ¼ã‚¹å€™è£œç‰ˆï¼‰ãŒç™ºè¡¨ã•ã‚ŒãŸã€‚ãƒªãƒªãƒ¼ã‚¹å€™è£œç‰ˆã¨ã„ã†ã“ã¨ã¯ã€ã“ã‚ŒãŒæ¬¡ã®æ£å¼ç‰ˆã«ãªã‚‹ã¨ã„ã†ã“ã¨ã ã€‚MySQL 5.5ã¯5.1ã‹ã‚‰å‡„ã¾ã˜ã„é€²åŒ–ã‚’é‚ã’ãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã£ãŸã€‚ã ãŒã€MySQL 5.6ã¯ã•ã‚‰ã«ãã‚Œã‚’ä¸Šå›žã‚‹é€²åŒ–ã‚’é‚ã’ã¦ã„ã‚‹ï¼æ£ç›´ã“ã“ã¾ã§ã®é€²åŒ–ã‚’èª°ãŒäºˆæƒ³ã—ãŸã ã‚ã†ã‹ã€ã„ã‚„èª°ã‚‚å‡ºæ¥ãªã‹ã£ãŸã§ã‚ã‚ã†ã€‚ã“ã‚Œã¾ã§ã€Î±ç‰ˆãŒå‡ºãŸã¨ãã‹ã‚‰ä½•åº¦ã‹æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ããŸãŒã€ä»Šå›žæ”¹ã‚ã¦MySQL 5.6ã®æ–°æ©Ÿèƒ½ã‚’æŒ¯ã‚Šè¿”ã£ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ã™ã¹ã¦ã¾ã¨ã‚ã‚‹ã¨ã‚‚ã®å‡„ã„å†…å®¹ã ã€‚èˆˆå¥®ã—ã¦å¤œã‚‚çœ ã‚Œãªããªã‚‹ã“ã¨è«‹ã‘åˆã„ã ã€‚MySQLã®é€²åŒ–ãŒæ¢ã¾ã‚‹ã®ã§ã¯ï¼Ÿãªã©ã¨ã„ã†å¿ƒé…ã¯å¹ãé£›ã³ã€ã‚‚ã¯ã‚„ã‚‚ã†ã¡ã‚‡ã£ã¨å°å‡ºã—ã«ã—ãªãã¦è‰¯ã‹ã£ãŸã®ã‹ï¼Ÿã¨å¿ƒé…ã—ã¦ã—ã¾ã†ãƒ¬ãƒ™ãƒ«ã§ã‚ã‚‹ã€‚ ãã‚Œã§ã¯MySQL 5.6ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ã„ã“ã†ã€‚ InnoDB
marukoro3150 2012/10/01
mysql

innodb
ãƒªãƒ³ã‚¯
Androidã®NFCæ©Ÿèƒ½ã§FeliCaã®èªã¿æ›¸ãã‚’ã™ã‚‹ | âˆ’ã‚†ã‚ãƒã‚°âˆ’ | ã‚†ã‚ã¿ã‚¹ã‚¿ãƒƒãƒ•ãƒ–ãƒã‚°
marukoro3150 2012/09/26
innodb

mysql
ãƒªãƒ³ã‚¯
MySQL: æ—¢å˜ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ§‹é€ ã®å¤‰æ›´ â€“ ALTER TABLEæ–‡ã€CHANGE COLUMNå¥
å‰å›žã¾ã§ã«CREATE TABLEæ–‡ã‚’ç”¨ã„ã¦ä»¥ä¸‹ã®ã‚ˆã†ãªbook2ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¾ã—ãŸã€‚ mysql> DESC book2; +-------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | title | varchar(64) | YES | | NULL | | | author_name | varchar(32) | YES | | NULL | | | detai
marukoro3150 2012/09/13
mysql
ãƒªãƒ³ã‚¯
MySQLã§å…¨æ–‡æ¤œç´¢ - FULLTEXTã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
marukoro3150 2012/08/22
mysql

å…¨æ–‡æ¤œç´¢
ãƒªãƒ³ã‚¯
å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³mroongaå°Žå…¥ã®è©¦è¡ŒéŒ¯èª¤
yumã®remiãƒ¬ãƒã‚¸ãƒˆãƒªã‚’ä½¿ã£ã¦æ§‹ç¯‰ã—ã¦ã‚ã‚‹ç’°å¢ƒã«mroongaã‚’å°Žå…¥ã—ã¾ã—ãŸ mroongaã¯MySQLã§å…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ã™ã‚‹ç‚ºã®ã‚¨ãƒ³ã‚¸ãƒ³ã§ã€MySQLã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¨ã—ã¦å‹•ä½œã—ã¾ã™ ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’è¦‹ã¦ã‚‹ã¨ç°¡å˜ã«å…¥ã‚Šãã†ãªã®ã§ã™ãŒã€æ—¢ã«å‹•ã„ã¦ã‚‹ç’°å¢ƒã«å…¥ã‚ŒãŸã®ã§ã¨ã¦ã‚‚è‹¦åŠ´ã—ã¾ã—ãŸ å¤±æ•—ã—ãŸéƒ¨åˆ†ã‚’å…¨éƒ¨æ›¸ã„ã¦ã‚‹ã®ã§éžå¸¸ã«é•·ã„ã§ã™ãŒã€ã”å®¹èµ¦ãã ã•ã„ ã¾ãšç¾åœ¨ã®ç’°å¢ƒã‹ã‚‰ PHP remi-testã‚’ä½¿ã£ã¦PHP5.4ã‚’å…¥ã‚Œã¦ã„ã¾ã™ ~~~ $ yum list installed | grep php* php-cli.x86_64 5.4.0-1.el5.remi installed php-common.x86_64 5.4.0-1.el5.remi installed php-fpm.x86_64 5.4.0-1.el5.remi installed php-gd.x86_64 5.4.0-1.e
marukoro3150 2012/08/03
mysql

mroonga
ãƒªãƒ³ã‚¯
ã‚¯ãƒªã‚¢ãƒã‚ªã®å£ã‚³ãƒŸã£ã¦ä¿¡ã˜ã¦ã„ã„ï¼ŸåŠ¹æžœã¯ç¢ºå®Ÿãªã®ï¼Ÿ | æ„›ã¨å°ç”º
ã‚¯ãƒªã‚¢ãƒã‚ªã®ç‰¹å¾´ ç„¡æ·»åŠ ãƒ»ç„¡ç€è‰²ã ã‹ã‚‰è‚ŒãŒå¼±ã„äººã§ã‚‚å®‰å¿ƒ ãƒ¯ã‚ã‚¬ã‚„å«Œãªè‡ã„ã®åŽŸå› ã¨ãªã‚‹èŒã‚’æ®ºèŒãƒ»æ¶ˆæ¯’ ãŠå¾—ãªå®šæœŸã‚³ãƒ¼ã‚¹ã¯ã€è³¼å…¥ç¸›ã‚Šãªã—ï¼ã„ã¤ã§ã‚‚è§£ç´„å¯èƒ½ ä½“è‡ã®æ‚©ã¿ã¯è€è‹¥ç”·å¥³å•ã‚ãšå…±é€šã®æ‚©ã¿ã§ã™ãŒã€ä»–äººã«ã¯ç›¸è«‡ã—ã«ãã„ã®ã§1äººã§æ‚©ã‚“ã§ã„ã‚‹äººãŒå¤šã„ã‚“ã§ã™ã€‚ ä½“è‡ã£ã¦ã€è‡ªåˆ†ã§ãƒ‹ã‚ªã‚¤ãŒæ°—ã«ãªã£ãŸæ™‚ã¯ã€ä»–ã®äººã¯ã‚‚ã£ã¨ã‚¯ã‚µã‚¤ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ã‚‚ã—ã‚ãªãŸãŒã€è‡ªåˆ†ã§ãƒ¯ã‚ã‚¬ã‹ã‚‚â€¦ã¨æ€ã†ã®ã§ã‚ã‚Œã°ã€å‘¨ã‚Šã®äººã¯ã‚ãªãŸã®ãƒ‹ã‚ªã‚¤ã«æ°—ã¥ã„ã¦ã„ã‚‹ã‹ã‚‚â€¦ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã€ãã‚“ãªãƒ¯ã‚ã‚¬è‡ã‚„è¶³ã®ãƒ‹ã‚ªã‚¤ãªã©ã€ã‚¤ãƒ¤ãƒ¼ãªä½“è‡å…¨èˆ¬ã‚’10ç§’ã§ã‚«ãƒƒãƒˆã—ã¦ãã‚Œã‚‹ã‚“ã§ã™ã€‚ ã‚¯ãƒªã‚¢ãƒã‚ªã®åŠ¹æžœã‚„å£ã‚³ãƒŸã‚’èª¿æŸ»ã—ã¾ã—ãŸã®ã§å¾¹åº•è§£èª¬ã—ã¾ã™ã€‚ è³¼å…¥æ™‚ã«ç‰¹å…¸ãŒä»˜ã„ã¦ãã‚‹ã®ã§ãŠå¾— å…¬å¼ã‚µã‚¤ãƒˆã¯ã‚³ãƒãƒ© â€»ç‰¹å…¸ã¯æ¯Žæœˆå¤‰ã‚ã‚‹ã®ã§å…¬å¼ã‚µã‚¤ãƒˆã§ã”ç¢ºèªãã ã•ã„ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã©ã‚“ãªäººã«ãŠã™ã™ã‚ï¼Ÿ ã‚¯ãƒªã‚¢ãƒã‚ªã®æ®ºèŒçŽ‡ã¯ã€ãªã‚“ã¨99.999%ï¼ä½“è‡ã®æ‚©ã¿ã‚’è§£æ¶ˆã—ã¦ãã‚Œã‚‹ã‚¯ãƒª
marukoro3150 2012/07/25
mysql
ãƒªãƒ³ã‚¯
http://www.2ch-search.net/blog/3
marukoro3150 2012/06/27
mysql
ãƒªãƒ³ã‚¯
SQLã§å¤§é‡ãƒ‡ãƒ¼ã‚¿ã‚’ä¸€æ°—ã«ä½œã‚‹ã§ã”ã–ã‚‹(MySQLç·¨) @ t100ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è„±å‡ºä½œæˆ¦
è‡ªåˆ†ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è„³ã‚’ãƒ—ãƒã‚°ãƒ©ãƒ ã«ã—ã¦ã€ã„ã¤ã‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‹ã‚‰è„±å‡ºã—ã¦ã‚„ã‚‹ãžã£ï¼ã¨ã‹å¤¢è¦‹ãªãŒã‚‰ã€æ—¥ã€…ãƒ—ãƒã‚°ãƒ©ãƒ ä½œã£ã¦ã„ã ç™¾é‡Ž è²´åš ã®æ—¥è¨˜ã§ã™ï¼ä»Šã¯ã€å±‹å·ã€Žç™¾è”µã€‚ã€ã¨ã—ã¦ã€Silverlightãƒ»WPFã‚’è¿½è·¡ä¸ã§ã™ï¼ (2007/09/30) é–‹ç™ºã‚’ã—ã¦ã„ã¦ã€å¤§é‡ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ãŒæ¬²ã—ã„ãªãƒ¼ã¨ã„ã†ã“ã¨ãŒæ™‚ã€…ã‚ã‚Šã¾ã™ã€‚ å…ˆæ—¥ã®ã€ã€ŒMySQLã® using temporary; using filesort ãŒä½•æ•…é…ã„ã®ã‹ã€ã®å†…å®¹ã‚‚ã€å®Ÿéš›ã«æ¤œè¨¼ã—ã¦ã¿ã‚‹ã«ã¯ã€sort_buffer_size ã‚’è¶…ãˆã‚‹é‡ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ ã—ã‹ã—ã€ã“ã‚ŒãŒæ„å¤–ã¨é¢å€’ãã•ã„ã£ ä½¿ã„æ…£ã‚ŒãŸã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã§ã€ãƒãƒ§ãƒãƒ§ã‚¤ã¨ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãã®ã‚‚OKãªã®ã§ã™ãŒã€ã§ã‚‚ã‚„ã£ã±ã‚Šé¢å€’ãã•ã„ã£ ï¼ˆã§ã™ã‚ˆãï¼Ÿï¼‰ ã¨ã„ã†ã“ã¨ã§ã€ä»Šå›žã¯SQLã ã‘ã§å¤§é‡ãƒ‡ãƒ¼ã‚¿ã‚’ä½œã‚‹æ–¹æ³•ã‚’è€ƒãˆã¦è¦‹ã¾ã™ã€‚ ã¨ã„ã£ã¦ã‚‚ã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã§ãƒ«ãƒ¼ãƒ—ã¨
marukoro3150 2012/05/16
mysql

ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®æ´å²
1. ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®æ´å² gussan@Drecom Co., Ltd. Copyright Â© Drecom Co., Ltd. 12å¹´2æœˆ20æ—¥æœˆæ›œæ—¥
marukoro3150 2012/02/22
mysql

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

é‹ç”¨
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸