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

mattarin id:mattarin

mysqlã¨MySQLã«é–¢ã™ã‚‹mattarinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (135)

${{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 8.0.11 (GA)ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸ - sakaikã®æ—¥ã€…é›‘æ„Ÿï½ž(T)ç·¨
æ…£ä¾‹(?)ã¨ã—ã¦4æœˆä¸‹æ—¬ã«ã¯å‡ºã‚‹ã®ã§ã¯ãªã„ã‹ã€ã¨å‹æ‰‹ã«äºˆæ¸¬ã—ã¦ã„ãŸ MySQL 8.0 ãŒã€ç§ã®äºˆæƒ³ã‚ˆã‚Šã‚‚ã»ã‚“ã®å°‘ã—æ—©ããƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸ*1ã€‚ã¤ã„ã«å¾…æœ›ã® GA ã§ã™ã€‚ MySQL 5.7 ã§ã€ãã‚Œä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨æ¯”ã¹ã¦éžå¸¸ã«å¤§ããªé€²åŒ–ã‚’ã—ãŸMySQLã§ã™ãŒã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚’å¤§ããé£›ã°ã—ãŸä»Šå›žã® MySQL 8.0 ã§ã‚‚ä¸€å±¤ã®é€²åŒ–ã‚’ã—ã¦ã„ã¾ã™ã€‚é€²åŒ–ã®å†…å®¹ã¯ MySQL Server Blog ã®è¨˜äº‹ã§è©³ã—ãèª¬æ˜Žã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç§ã‚‚ã“ã‚Œã‹ã‚‰å°‘ã—ãšã¤èªã‚‚ã†ã¨æ€ã„ã¾ã™ã€‚ mysqlserverteam.com ã“ã® Server Blog ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã€ã¨ã£ã¦ã‚‚ã¨ã£ã¦ã‚‚é•·ã„åŠ›ä½œã§ã€ã“ã‚Œã‚’èªã‚€ã ã‘ã§MySQL8.0ã®é€²åŒ–ã®æ¦‚è¦ã¯ã–ã£ã¨ç†è§£ã§ããã†ãªãã‚‰ã„ã§ã™ã€‚ãŒã€é•·ã„ã¨(æ›´ã«è‹±èªžã ã—)ã ã‚“ã ã‚“ä½•ã‚’èªã‚“ã§ã„ã‚‹ã®ã‹åˆ†ã‹ã‚‰ãªããªã£ã¦ã—ã¾ã†ã®ã§ã€ç§ã¯ã“ã†ã„ã†ã¨ãã«ã€Œåœ°å›³ã€ã‚’ä½œã‚Šã¾ã™ã€‚è‡ªåˆ†ç”¨ã«ã€ã–ã£ãã‚Š
mattarin 2018/04/21
mysql
ãƒªãƒ³ã‚¯
http://unskilled.site/%E3%81%AA%E3%82%93%E3%81%A7php%E3%81%AFmysql%E3%81%8B%E3%82%89%E3%81%AE%E3%83%AA%E3%82%B6%E3%83%AB%E3%83%88%E3%81%8Cint%E5%9E%8B%E3%81%AE%E3%81%AF%E3%81%9A%E3%81%AA%E3%81%AE%E3%81%ABstring%E5%9E%8B/
mattarin 2017/02/22
php

mysql
ãƒªãƒ³ã‚¯
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ã®æ–°æ©Ÿèƒ½ãŒå¤šã™ãŽã¦
mattarin 2016/07/16
mysql
ãƒªãƒ³ã‚¯
Joomla!ã®ã€Œã‚¼ãƒãƒ‡ã‚¤ã‚³ãƒ¼ãƒ‰å®Ÿè¡Œè„†å¼±æ€§ã€ã¯PHPã®æ—¢çŸ¥ã®è„†å¼±æ€§ãŒåŽŸå›
Joomla!ã«ã‚³ãƒ¼ãƒ‰å®Ÿè¡Œè„†å¼±æ€§(CVE-2015-8562)ãŒã‚ã‚Šã€ãƒ‘ãƒƒãƒå…¬é–‹å‰ã‹ã‚‰æ”»æ’ƒãŒè¦³æ¸¬ã•ã‚Œã¦ã„ãŸã¨è©±é¡Œã«ãªã£ã¦ã„ã¾ã™ã€‚ Joomlaã«æ·±åˆ»ãªè„†å¼±æ€§ã€ãƒ‘ãƒƒãƒå…¬é–‹2æ—¥å‰ã‹ã‚‰æ”»æ’ƒæ¨ªè¡Œ ã€ŒJoomla!ã€ã«å†ã³æ·±åˆ»ãªè„†å¼±æ€§ã€3.4.6ã¸ã®é€Ÿã‚„ã‹ãªã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã‚’æŽ¨å¥¨ ãƒ‘ãƒƒãƒå…¬é–‹ã®å‰ã«æ”»æ’ƒãŒå§‹ã¾ã‚‹çŠ¶æ…‹ã‚’ã€Œã‚¼ãƒãƒ‡ã‚¤è„†å¼±æ€§ã€ã¨è¨€ã„ã¾ã™ãŒã€ãã‚Œã§ã¯ã€ã“ã®è„†å¼±æ€§ã®ãƒ¡ã‚«ãƒ‹ã‚ºãƒ ã¯ã©ã‚“ãªã‚‚ã®ã ã‚ã†ã‹ã¨æ€ã„ã€èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ çµè«–ã‹ã‚‰è¨€ãˆã°ã€ã“ã®å•é¡Œã¯Joomla!å´ã«é‡å¤§ãªè„†å¼±æ€§ã¯ãªãã€PHPã®æ—¢çŸ¥ã®è„†å¼±æ€§(CVE-2015-6835)ãŒåŽŸå› ã§ã—ãŸã®ã§å ±å‘Šã—ã¾ã™ã€‚ exploitã‚’èª¿ã¹ã¦ã¿ã‚‹ æ—¢ã«ã“ã®å•é¡Œã®exploitã¯å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ãŒã€æ‚ªã„åãŒçœŸä¼¼ã™ã‚‹ã¨ã„ã‘ãªã„ã®ã§URLç‰ã¯å‰²æ„›ã—ã¾ã™ã€‚ä»¥ä¸‹ã®ãƒšãƒ¼ã‚¸ã§ã¯æ”»æ’ƒã®åŽŸç†ãŒèª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ Vulnerability Details: Joomla! Re
mattarin 2015/12/20
php

mysql

security
ãƒªãƒ³ã‚¯
MySQL User Conference Tokyo 2015ã§ç™ºè¡¨ã—ã¾ã—ãŸï¼šMySQL 5.7ã«ãŠã‘ã‚‹ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã®æ”¹è‰¯ç‚¹
æ˜¨æ—¥ã€å‘ŠçŸ¥ã•ã›ã¦ã„ãŸã ã„ãŸMySQL User Conference Tokyo 2015ã§ç™»å£‡ã—ãŸã®ã§ã€ãã®æ™‚ã®è³‡æ–™ã‚’å…¬é–‹ã—ãŸã€‚MySQL 5.7ã®æ©Ÿèƒ½ã¯å…¨éƒ¨ã²ã¨ã¤ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§ç´¹ä»‹ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã€å¤šã™ãŽã¦ç§ã«ã¯ã‚³ãƒ³ãƒ‘ã‚¯ãƒˆã«ã¾ã¨ã‚ã‚‹ã ã‘ã®æŠ€é‡ã¯ç„¡ã„ãŸã‚ã€ä»Šå›žã¯ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã ã‘ã®ç´¹ä»‹ã«ã—ãŸã€‚èˆˆå‘³ã®ã‚ã‚‹æ–¹ã¯ã”è¦§é ‚ããŸã„ã€‚ ãã†ã„ãˆã°ã™ã£ã‹ã‚Šå¿˜ã‚Œã¦ã—ã¾ã£ã¦ã„ãŸã®ã ãŒã€MySQL 5.7ãŒç™»å ´ã—ãŸï¼ï¼ã¨ã„ã†ãƒ–ãƒã‚°ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ãã®ã‚’å¿˜ã‚Œã¦ã„ãŸã€‚ã‚‚ã—ã‹ã™ã‚‹ã¨èªè€…ã®çš†ã•ã‚“ã®ä¸ã«ã¯ã€MySQL 5.7ãŒæ£å¼ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã“ã¨ã‚’ã”å˜ã˜ãªã„æ–¹ã‚‚ã„ã‚‰ã£ã—ã‚ƒã‚‹ã‹ã‚‚çŸ¥ã‚Œãªã„ã€‚é…ããªã£ã¦ç”³ã—è¨³ãªã„ãŒã€MySQL 5.7ã¯ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.7.9ã‚’ã‚‚ã£ã¦æ£å¼ç‰ˆã¨ãªã£ã¦ã„ã‚‹ã€‚5.7.9ã¯ç´„2ãƒ¶æœˆå‰ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã€‚ã¤ã„ã§ã«è¨€ã†ã¨ã€ãƒã‚°ä¿®æ£ã‚’å«ã‚“ã 5.7.10ãŒæ—¢ã«å‡ºã¦ã„ã‚‹ã€‚ MySQL 5.7ã¯ã¾ã•ã«ãƒ¢ãƒ³ã‚¹ã‚¿ãƒ¼ã ï¼ï¼ï¼ã¨
mattarin 2015/12/17
mysql
ãƒªãƒ³ã‚¯
ã€ Zabbix 2.0 ã€‘zabbix 2.0ã«ã‚ˆã‚‹ç°¡å˜ MySQL ç›£è¦– #Zabbix
8. userparameter_mysql.confã®å…ˆé ã«ã¯æ¬¡ã®ã‚ˆã†ã« æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ # For all the following commands HOME should be set to the directory that has .my.cnf file with password information. HOMEãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã€[.my.cnf ]ã‚’é…ç½®ã—ã€ãã“ ã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰æƒ…å ±ã‚’è¨˜è¼‰ã™ã‚‹ã‚ˆã†ã«æŒ‡ç¤ºã•ã‚Œã¦ã„ ã¾ã™ã€‚ ãã—ã¦ã€å„UserParameterã®ã‚³ãƒžãƒ³ãƒ‰ã®ä¸ã§ã¯ [HOME=/var/lib/zabbix]ã¨ã—ã¦ HOMEãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«/var/lib/zabbix ãŒè¨å®šã•ã‚Œ ã¦ã„ã¾ã™ã€‚ userparameter_mysql.confã®ä½¿ã„ æ–¹ 2013/09/298
mattarin 2015/08/30
zabbix

mysql
ãƒªãƒ³ã‚¯
MySQL 5.7ã®ç½ ãŒã‚ãªãŸã‚’ç‹™ã£ã¦ã„ã‚‹
31. ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚¹ãƒ¬ãƒ¼ãƒ–ã«æ³¨æ„ (FIXED by 5.7.9) REPLICATION SLAVEæ¨©é™ã® *ä»–ã«* SELECT ON performanceÌ²schema.* ãŒå¿…è¦ mysql> show slave statusG *************************** 1. row *************************** .. Last_IO_Errno: 1142 Last_IO_Error: The slave I/O thread stops becaus e a fatal error is encountered when it try to get the value of SE RVER_ID variable from master. Error: SELECT command denied to use r 'replic
mattarin 2015/08/24
mysql
ãƒªãƒ³ã‚¯
MySQLã®slow query logã‚’å¯è¦–åŒ–ã™ã‚‹nata2ãŒå¤§å¤‰ä¾¿åˆ©ãã† - oranie's blog
MySQL Casual #6ã§@studio3104ã•ã‚“ãŒç™ºè¡¨ã—ã¦ã„ãŸnata2ã‚’è§¦ã£ãŸã€‚ My sql casual talks vol.6 from studio3104_com ã§ã€ã¨ã‚Šã‚ãˆãšãƒãƒ¼ã‚«ãƒ«ã«nata2ã‚’èµ·å‹•ã—td-agentã‚’å…¥ã‚Œã¦ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’å…¥ã‚Œã¦mysqlslapã‚’å®Ÿè¡Œã—ã¦ã¿ãŸã€‚ å‹•ä½œç’°å¢ƒã¯Ruby2.1.2ã§ã€‚1.9ç³»ã¯å‹•ã‹ãªã‹ã£ãŸã€‚ æ‰‹é †ã¯githubã«ã‚‚æ›¸ã‹ã‚Œã¦ã„ã‚‹ãŒã€ https://github.com/studio3104/nata2 https://github.com/studio3104/fluent-plugin-nata2 ä»¥ä¸‹ã¯ç°¡å˜ãªæµã‚Œã€‚ ã¾ãšnata2è‡ªä½“ã®è¨å®šã€‚ git clone https://github.com/studio3104/nata2.git cd ./nata2 bundle install vim ./config
mattarin 2014/07/20
mysql

fluentd
ãƒªãƒ³ã‚¯
ã€Žã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã«ãŠã‘ã‚‹DBæ§‹æˆ&å¯¾å¿œè¨˜ã€
2ãƒ¶æœˆå‰ã«ã‚¤ãƒ³ãƒ•ãƒ«ã‚¨ãƒ³ã‚¶ã¨ã‚¦ã‚£ãƒ«ã‚¹æ€§èƒƒè…¸ç‚Žã§ã²ã©ããƒ€ãƒ¡ãƒ¼ã‚¸ã‚’å—ã‘ãŸå¢—ç”°(@masudaK)ã§ã™ã€‚ã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã¯2009å¹´2æœˆã«å§‹ã¾ã£ãŸã‚µãƒ¼ãƒ“ã‚¹ã§ã€FLASHãƒ»Javaã§ä½œã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ãã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã«MySQLã‚’ç”¨ã„ã¦ã¾ã™ã€‚æœ¬è¨˜äº‹ã§ã¯ã€ã‚ãŸãã—ãŒ2å¹´ã»ã©è¦‹ç¶šã‘ã¦ã„ã‚‹ã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã®DBç’°å¢ƒã«ã¤ã„ã¦æ§‹æˆã‚„ã€æ—¥ã€…ã©ã®ã‚ˆã†ã«ã—ã¦å•é¡Œã¨å‘ãåˆã£ã¦ã„ã‚‹ã‹ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ã‚¤ãƒ³ãƒ•ãƒ©å¯„ã‚Šã®å†…å®¹ãŒå¤šã„ãŸã‚ã€ã‚¢ãƒ—ãƒªå¯„ã‚Šã®è©±ã¯å¼Šç¤¾ç”Ÿæ²¼ã®è³‡æ–™ã‚’å¾¡è¦§ãã ã•ã„ã€‚ 1. æ§‹æˆã¨è¦æ¨¡ 1.1. æ§‹æˆ ã¾ãšæ§‹æˆã§ã™ãŒã€èªã¿æ›¸ãã¯ã™ã¹ã¦ãƒžã‚¹ã‚¿ãƒ¼ã¸è¡Œã†ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã¯å‚ç…§ã‚’å‘ã‘ãšã€ãƒ›ãƒƒãƒˆã‚¹ã‚¿ãƒ³ãƒã‚¤ã¨ã—ã¦ä½¿ã£ã¦ã„ã¾ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«é–¢ã—ã¦ã¯2012å¹´ä¸æ—¬ã¾ã§ã¯5.0ã‚’ä½¿ã£ã¦ã¾ã—ãŸãŒã€DCç§»è»¢ã«ã‚ã‚ã›ã¦5.5ã«ã‚ã’ã¾ã—ãŸã€‚ãƒãƒƒã‚¯æ©Ÿèƒ½ã‚’ç”¨ã„ãŸã‚·ãƒ£ãƒ¼ãƒ‰æ§‹æˆã‚’ã—ã¦ã¾ã—ã¦ã€2014å¹´3æœˆç¾åœ¨6ã‚·ãƒ£ãƒ¼ãƒ‰ã«ãª
mattarin 2014/05/25
mysql
ãƒªãƒ³ã‚¯
Ruby on Rails on MySQL ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°å…¥é–€
Rails 3 ç³»+MySQL ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒ“ã‚¹å‘ã‘ã« 1. ã©ã®ã‚ˆã†ã«ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’æŽ¢ã™ã®ã‹ 2. ã©ã®ã‚ˆã†ãªè¨è¨ˆã‚’è¡Œãˆã°ã„ã„ã®ã‹ 3. Railsä¸Šã§ã©ã®ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã‘ã°ã„ã„ã®ã‹ ã®3ç‚¹ã«çµžã£ã¦ã“ã®ãƒ—ãƒ¬ã‚¼ãƒ³ã‚’ã¿ã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œãˆã‚‹ã‚ˆã†ã«è³‡æ–™ä½œæˆã‚’è¡Œã„ã¾ã—ãŸRead less
mattarin 2014/02/27
rails

mysql
ãƒªãƒ³ã‚¯
Facebookã«ãŠã‘ã‚‹MySQLã‚’ç”¨ã„ãŸå¤§è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®ç¾å®Ÿï½žMySQL Connect 2013
ç±³ã‚ªãƒ©ã‚¯ãƒ«ãŒä¸»å‚¬ã™ã‚‹MySQLã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒMySQL Connectã€ãŒ9æœˆ21æ—¥ã‹ã‚‰23æ—¥ã¾ã§ã€ã‚µãƒ³ãƒ•ãƒ©ãƒ³ã‚·ã‚¹ã‚³ã§é–‹å‚¬ã•ã‚Œã¾ã—ãŸã€‚Oracle OpenWorldã€JavaOneã¨ã®åŒæ™‚é–‹å‚¬ã§ã—ãŸã€‚ åŸºèª¿è¬›æ¼”ã®1ã¤ã«ã¯ã€MySQLã®ãƒ˜ãƒ“ãƒ¼ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ã‚ã‚‹Facebookã®Harrison Fiskæ°ãŒç™»å£‡ã€‚Facebookã«ãŠã‘ã‚‹MySQLã®å½¹å‰²ã€å¤§è¦æ¨¡é‹ç”¨ã®èƒŒæ™¯ãªã©ã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ãã®å†…å®¹ã‚’ãƒ€ã‚¤ã‚¸ã‚§ã‚¹ãƒˆã§ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ MySQL@Facebook Lots and lots of small data Harrison Fiskæ°ã€‚ Facebookã§ãƒ‡ãƒ¼ã‚¿ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¼ãƒ ã®ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚’ã—ã¦ã„ã‚‹ã€‚ç¤¾å†…ã§ã¯MySQLã¯ã‚‚ã¡ã‚ã‚“ã€HBase Hadoopãªã©ã«ã‚‚é–¢ã‚ã£ã¦ã„ã‚‹ã€‚ ã¾ãšã¯ã€ã©ã‚“ãªç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã£ã¦ã„ã‚‹ã®ã‹ã«ã¤ã„ã¦ã€‚ Facebookã¨ã¯åŸºæœ¬çš„ã«ã‚°ãƒ©ãƒ•ã ã€‚ã‚°
mattarin 2013/09/29
mysql

facebook
ãƒªãƒ³ã‚¯
(å¸°ã£ã¦ããŸ)InnoDBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æœ€é©åŒ–ã®åŸºç¤Ž | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚Perconaã®ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹ç†è€…ãŒã€InnoDBã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºç¤Žã«ã¤ã„ã¦ã€ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚„OSã®é¸å®šã‹ã‚‰ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®æŽ¨å¥¨å€¤ã¾ã§è§£èª¬ã™ã‚‹ã€‚ æœ€è¿‘ã€2007å¹´ã«Peter ZaitevãŒæ›¸ã„ãŸã€ŒInnoDBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æœ€é©åŒ–ã®åŸºç¤Žã€ã¨ã„ã†è¨˜äº‹ã‚’è¦‹ã¤ã‘ãŸã€‚ã“ã‚Œã¯ç´ æ™´ã‚‰ã—ã„è¨˜äº‹ã§ã€èªã‚“ã§ã„ã‚‹ã¨ã€MySQLã¨Percona Serversãã—ã¦ä»Šæ—¥åˆ©ç”¨å¯èƒ½ãªå…¨ã¦ã®åŸºç›¤æŠ€è¡“ã«é–¢ã—ã¦ã€6å¹´è¿‘ãã®é–“ã«ä½•ãŒå¤‰ã‚ã£ã¦ããŸã®ã‹ã‚’è¦‹ç›´ã—ã¦ã¿ãŸã„ã¨æ€ã‚ã›ã‚‹ã‚‚ã®ã ã€‚ æœ¬å½“ã«ãŸãã•ã‚“ã®ã“ã¨ãŒå¤‰ã‚ã£ãŸã‚‚ã®ã ï¼ã“ã®è¨˜äº‹ã§ã¯ã€InnoDBã®ä½¿ç”¨ã«åŠ¹æžœçš„ãªãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®å¤šãã«ã€ç‰¹ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®è¦³ç‚¹ã‹ã‚‰ç„¦ç‚¹ã‚’å½“ã¦ã‚‹ã€‚ç§ã¯ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã€Percona Supportã§ã¯InnoDBãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®é©åˆ‡ãªã‚µã‚¤ã‚ºã«é–¢ã™ã‚‹è³ªå•ãŒãŸãã•ã‚“å¯„ã›ã‚‰ã‚Œã¦ã„ã‚‹
mattarin 2013/09/29
mysql

tips
ãƒªãƒ³ã‚¯
é–‹ç™ºã‚¹ãƒ”ãƒ¼ãƒ‰ã‚¢ã‚¯ã‚»ãƒ«å…¨é–‹ã¶ã£ã¡ãŽã‚Šï¼æ—¥æœ¬ã‚ˆã€ã“ã‚ŒãŒ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
mattarin 2012/10/01
ã‚ã¨ã§

mysql
ãƒªãƒ³ã‚¯
å…¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®çµ±è¨ˆæƒ…å ±ã‚’ã‚µã‚¤ã‚ºé †ã«ä¸€è¦§è¡¨ç¤ºã™ã‚‹
MySQLã«ãŠã„ã¦ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚µã‚¤ã‚ºã€ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã€å¹³å‡ãƒ¬ã‚³ãƒ¼ãƒ‰é•·ãªã©ã®çµ±è¨ˆæƒ…å ±ã‚’çŸ¥ã‚‹ä¸Šã§show table statusã¯å®šç•ªã§ã™ã€‚ãŸã é›‘å¤šãªè¡¨ç¤ºé …ç›®ã‚‚å¤šã„ã®ã§ã€ãŸãã•ã‚“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®çµ±è¨ˆã‚’è¦‹ã‚‹å ´åˆã€å¿…è¦ãªæƒ…å ±ã ã‘ã‚’è¿”ã—ãŸã„ã“ã¨ã¯å¤šã„ã§ã™ã€‚ã¾ãŸå…¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã†ã¡ã€ã©ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒä¸€ç•ªå¤§ãã„ã®ã‹ã‚’çŸ¥ã‚ŠãŸã„ã¨ã‹ã€ã‚µã‚¤ã‚ºãŒå¤šã„é †ã«ä¸€è¦§è¡¨ç¤ºã—ãŸã„ã¨ã‹ã€ä¸€ç›®ã§åˆ†ã‹ã‚‹ã‚ˆã†ãªæƒ…å ±ãŒã»ã—ã„ã“ã¨ã‚‚å¤šã„ã§ã™ã€‚ ã“ã†ã„ã†ã¨ãã¯information_schema.tablesã‚’ä½¿ã†ã¨ä¾¿åˆ©ã§ã™ã€‚ä»¥ä¸‹ã®ä¾‹ã§ã¯ã€appãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å…¨ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ã„ã¦ã€ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚º+ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚µã‚¤ã‚ºã€ã®å¤§ãã„é †ã«ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã€å¹³å‡ãƒ¬ã‚³ãƒ¼ãƒ‰é•·ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚º(MB)ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚µã‚¤ã‚º(MB)ãªã©ã‚’è¿”ã—ã¦ã„ã¾ã™ã€‚ use app; select table_name, engine, table_
mattarin 2012/09/25
mysql

tips
ãƒªãƒ³ã‚¯
ãƒ‰ãƒ³.com Â» Blog Archive Â» HandlerSocket Plugin for MySQLã‚’å…¥ã‚Œã¦ã¿ãŸã€‚
ã¡ã¨ã€æ°—ã«ãªã£ãŸã®ã§ã€èª¿ã¹ãŸæ™‚ã®ãƒ¡ãƒ¢ã€‚ HandlerSocket Plugin for MySQL InnoDBç‰ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã®æ€§èƒ½ã‚’é™ç•Œã¾ã§å¼•ãå‡ºã—ã¾ã™ã€‚ ã¨ã„ã†è¨€è‘‰ã«æƒ¹ã‹ã‚Œã¦ã€ã€ã€ http://engineer.dena.jp/2010/08/handlersocket-plugin-for-mysql.html ã•ã¦ã€ãƒ¡ãƒ¢ã¯ä¸‹è¨˜ã€‚ â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€”â€” æ¦‚è¦ ãƒ»MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’é«˜é€ŸåŒ–ã™ã‚‹ãŸã‚ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã™ã€‚ ç‰¹å¾´ ãƒ»MySQLã‚’NoSQLãƒ©ã‚¤ã‚¯ã«ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ãƒ»MySQLãƒ¬ã‚¤ãƒ¤ã‚’é€šã•ãšTCP/IPçµŒç”±ã§InnoDBã‚’ç›´æŽ¥æ“ä½œã—InnoDBã‚¨ãƒ³ã‚¸ãƒ³ã®æ€§èƒ½ã‚’é™ç•Œã¾ã§å¼•ãå‡ºã™ã€‚ MySQLãƒ¬ã‚¤ãƒ¤ã¨ã¯ SQLæ–‡ã®è§£æžã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚ªãƒ¼ãƒ—ãƒ³/ãƒãƒƒã‚¯/ã‚¢ãƒ³ãƒãƒƒ
mattarin 2012/09/23
mysql

HandlerSocket
ãƒªãƒ³ã‚¯
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
mattarin 2012/08/05
php

mysql
ãƒªãƒ³ã‚¯
ã†ã‚‹ã†ç§’ã®ã‚ã¨ã«MySQLãªã©ã®CPUä½¿ç”¨çŽ‡ãŒé«˜é¨°ã™ã‚‹ä»¶ã«ã¤ã„ã¦ - SH2ã®æ—¥è¨˜
2012å¹´7æœˆ1æ—¥ã®ã†ã‚‹ã†ç§’ã®ã‚ã¨ã«ã€MySQLã‚„Javaãªã©ã®CPUä½¿ç”¨çŽ‡ãŒé«˜é¨°ã™ã‚‹äº‹è±¡ãŒå ±å‘Šã•ã‚Œã¦ã„ã¾ã™ã€‚ CPU %user %nice %system %iowait %steal %idle 08æ™‚30åˆ†01ç§’ all 0.02 0.00 0.02 0.04 0.00 99.91 08æ™‚40åˆ†01ç§’ all 0.02 0.00 0.02 0.08 0.00 99.88 08æ™‚50åˆ†01ç§’ all 0.02 0.00 0.02 0.03 0.00 99.92 09æ™‚00åˆ†01ç§’ all 0.11 0.00 0.13 0.04 0.00 99.72 09æ™‚10åˆ†01ç§’ all 23.02 0.00 29.09 0.11 0.00 47.78 09æ™‚20åˆ†01ç§’ all 23.11 0.00 29.08 0.06 0.00 47.75 09æ™‚30åˆ†01ç§’ all 22.85 0.00
mattarin 2012/07/02
VPSãŒå†èµ·å‹•ã—ãŸã®ã“ã‚ŒãŒç†ç”±ã ã‚ã†ã‹

mysql
ãƒªãƒ³ã‚¯
Rubyã§MySQLã«ç¹‹ããŸã‚ã®ruby-mysqlã¨mysql2 - ãŸã”ã‚‚ã‚Šã™ãƒ¡ãƒ¢
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã¯ MySQL Casual Advent Calendar 2011 - MySQL Casual ã®10æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ã“ã‚“ã°ã‚“ã¯ã€‚tagomorisã§ã™ã€‚ã•ã¨ã—ã§ã™ã€‚ã‚¿ã‚´ãƒ¢ãƒªã‚¹ã® s ã¯ã•ã¨ã—ã® s ã§ã™(å®Ÿè©±)ã€‚Twitterã§ #ã•ã¨ã— ã¨ã„ã†ãƒãƒƒã‚·ãƒ¥ã‚¿ã‚°ãŒæµã‚Œã‚‹ãŸã³ã€ã²ãã‹ã«ã³ãã£ã¨ã—ã¦ã¾ã™ã€‚ Rubyã‹ã‚‰MySQLã«ç¹‹ãã¨ãã«ã©ã†ã™ã‚‹ã®ã€ã¨ã¨ã‚Šã‚ãˆãš gem search -r mysql ã¨ã‹ã‚„ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã—ã¦å¤§é‡ã«ã‚ã‚Œã“ã‚Œå‡ºã¦ãã¦ã©ã†ã™ã‚Œã°ã„ã„ã‚“ã ï¼ ã¨ã„ã†æ°—åˆ†ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã†ã„ã†æ°—åˆ†ã«ãªã£ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã€ç¾çŠ¶ã‚’ç°¡å˜ã«ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ruby-mysql æ˜”ã‹ã‚‰ã®å®šç•ªã§ã™ãã€‚ä½œè€…ã¯ id:tmtms ã®ã¨ã¿ãŸã¾ã•ã²ã‚ã•ã‚“ã€‚rubygemsã¨ã‹ä½¿ã‚ã‚Œã‚‹å‰ã‹ã‚‰ Ruby/MySQL ã¨ã„ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªåã§çŸ¥ã‚‰ã‚Œã¦ã„ã¾ã—ãŸã€‚Googleã§æ¤œç´¢ã™ã‚‹ã¨ãƒˆ
mattarin 2012/05/16
ruby

mysql
ãƒªãƒ³ã‚¯
ricollab Web Tech Blog Â» Blog Archive Â» MySQLãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ï¼ˆãã®2ï¼šæ€§èƒ½æ¤œè¨¼ç·¨ï¼‰
ã“ã‚“ã«ã¡ã¯ã€æ¿±ç”°ã§ã™ã€‚ å‰å›žã‹ã‚‰æ™‚é–“ãŒçµŒã£ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€ä»Šå›žã¯ã€Œæ€§èƒ½æ¤œè¨¼ç·¨ã€ã¨ã„ã†ã“ã¨ã§ã€ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ãƒ‰ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦å®Ÿéš›ã«ãƒ‡ãƒ¼ã‚¿ã‚’æŒ¿å…¥ãƒ»å‚ç…§ã™ã‚‹ã“ã¨ã§ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã®æ€§èƒ½é¢ã‚’æ¤œè¨¼ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ æ€§èƒ½æ¤œè¨¼ç’°å¢ƒ ä½¿ç”¨ã—ãŸãƒžã‚·ãƒ³ã®ã‚¹ãƒšãƒƒã‚¯ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ OS CentOS 5.3 32bit (on Windows XP Pro SP3 32bit via VMware Server 2.0.0) CPU Core2 Duo E8300 2.83GHz (VMã«ã¯1CPUã‚’å‰²ã‚Šå½“ã¦) Memory 3.25GB (VMã«ã¯512MBã‚’å‰²ã‚Šå½“ã¦) MySQL ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŠã‚ˆã³è¨å®šã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ãªãŠã€MySQL ã‚µãƒ¼ãƒãŠã‚ˆã³ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¯åŒä¸€ãƒžã‚·ãƒ³ä¸Šã§å‹•ä½œã•ã›ã¾ã—ãŸã€‚ MySQL 5.1.35-community (è¨å®šã¯ my-medium.cnf ã‚’ãã®ã¾ã¾ä½¿ç”¨)
mattarin 2012/04/24
mysql
ãƒªãƒ³ã‚¯
ã‚«ãƒªãƒ“ã‚¢ãƒ³ã‚³ãƒ æœŸé–“é™å®šã‚¹ãƒšã‚·ãƒ£ãƒ«ãƒ¼ç„¡æ–™ãŠè©¦ã—é–‹å§‹ï¼
mattarin 2012/04/22
mysql

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