[B! kamipo] a2ikmã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

a2ikm id:a2ikm

kamipoã«é–¢ã™ã‚‹a2ikmã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (33)

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

Treasure Dataã‚’é€€è·ã—ã¾ã™ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
æ€¥ãªãŠçŸ¥ã‚‰ã›ã§ã™ãŒã€8æœˆ31æ—¥ã‚’ã‚‚ã£ã¦Treasure Dataã‚’é€€è·ã™ã‚‹ã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ä»Šå¾Œã®æ´»å‹•ã«ã¤ã„ã¦ã¯ã„ã¾ã®ã¨ã“ã‚ãªã«ã‚‚æ±ºã¾ã£ã¦ã„ãªã„ã®ã§ã€è‡ªåˆ†ã«ãªã«ãŒã§ãã‚‹ã®ã‹ã€ã©ã‚“ãªãƒ‹ãƒ¼ã‚ºãŒã‚ã‚‹ã®ã‹ã€ã„ã‚ã„ã‚ç›¸è«‡ã«ä¹—ã£ã¦ã‚‚ã‚‰ãˆã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ã€‚ ãã£ã‹ã‘ã¯ã¨ã„ã†ã¨ã€é•·å¹´Railsã‚³ãƒ³ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚¿ãƒ¼/ãƒ¡ãƒ³ãƒ†ãƒŠãƒ¼ã¨ã—ã¦ä¸¦ã€…ãªã‚‰ã¬æ€ã„ã§æ´»å‹•ã—ã¦ããŸã‚“ã§ã™ãŒã€‚ ã©ã®ãã‚‰ã„ãŒã‚“ã°ã£ã¦ã„ãŸã‹ã¨ã„ã†ã¨ã€ãŸã¨ãˆã°2020å¹´8æœˆæ™‚ç‚¹ã®ã‚³ãƒŸãƒƒãƒˆæ•°ãƒ™ãƒ¼ã‚¹ã®ä»Šå¹´ã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ“ãƒ†ã‚£ã§ã„ã†ã¨ã€ä¸Šä½10äººã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ“ãƒ†ã‚£ã‚’æ¯æ•°ã«ã™ã‚‹ã¨ãã®åŠæ•°ãŒåƒ•ã«ãªã‚Šã¾ã™ã€‚ rails/rails contributors 2020-01-01 - 2020-08-26 Rails 5.0ä»¥é™ã®ã‚‚ç½®ã„ã¦ãŠãã¾ã™ã€‚ rails/rails contributors 2019-01-01 - 2019-12-31 rails/rails c
a2ikm 2020/08/26
ã™ã”ã„ï¼å¿œæ´ã—ã¦ã¾ã™ï¼

kamipo

career
ãƒªãƒ³ã‚¯
ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰å¼•æ•°ã®åˆ†é›¢ã¸ã®å¯¾å¿œã«Ruby 2.8.0-devã‚’ä½¿ã† - koicã®æ—¥è¨˜
å…ˆæ—¥ã®ãƒ‘ãƒƒãƒä¼šã§ kamipo ã•ã‚“ã«ã‚‚ã‚‰ã£ãŸã‚¢ãƒ‰ãƒã‚¤ã‚¹ã‚’æ›¸ãæ®‹ã—ã¦ãŠãã€‚ TL;DR ã¨ã—ã¦ã¯è¡¨é¡Œãã®ã¾ã¾ã€‚ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰å¼•æ•°ã®åˆ†é›¢ã¸ã®å¯¾å¿œã«Ruby 2.8.0-devã‚’ä½¿ã†ã¨ã„ã†ã‚‚ã®ã€‚ 2.8.0-devã‚’ä½¿ãˆã°ã‚¤ãƒ¼ã‚¸ãƒ¼ãƒ¢ãƒ¼ãƒ‰ã ã‘ã©2.7.0ç¸›ã‚Šãƒ—ãƒ¬ã‚¤ã ã¨å¸¸äººã«ã¯ã‚¯ãƒªã‚¢ä¸èƒ½ã®ã‚€ãšã‹ã—ã• https://t.co/tpJGTARwAcâ€” Ryuta Kamizono (@kamipo) 2020å¹´1æœˆ24æ—¥ Ruby 2.7.0 ã‚’ä½¿ã£ã¦ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰å¼•æ•°ã®åˆ†é›¢ã¸ã®è¦å‘Šã®ã¿ã§ãã‚Œã‚’æŠ‘åˆ¶ã—ã‚ˆã†ã¨ã™ã‚‹å ´åˆã¯ã€ã‚¹ãƒ¼ãƒ‘ãƒ¼ãƒãƒ¼ãƒ‰ãƒ¢ãƒ¼ãƒ‰ãƒ«ãƒ“ãƒ¼ã¨ãƒ‘ãƒƒãƒä¼šã§å‘¼ã°ã‚ŒãŸå¤‰æ›´ç®‡æ‰€ã®ç‰¹å®šãŒé›£ã—ã„ã‚±ãƒ¼ã‚¹ã«ãªã‚‹å ´åˆãŒã‚ã‚‹ã€‚ ã‚¹ãƒ¼ãƒ‘ãƒ¼ãƒãƒ¼ãƒ‰ãƒ¢ãƒ¼ãƒ‰ (Ruby 2.7.0) Ruby 3.0 ã«å‘ã‘ã¦ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰å¼•æ•°ã®åˆ†é›¢ãŒå¿…è¦ã«ãªã‚‹å ´åˆã¯ã€Ruby 2.7.0 ã‚’ä½¿ã†ã¨ä»¥ä¸‹ã®ã‚ˆã†ãªè¦å‘ŠãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ % ruby -v ru
a2ikm 2020/07/27
ruby

kamipo
ãƒªãƒ³ã‚¯
Ruby 2.7.0ã§ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰å¼•æ•°ã¨ã—ã¦æ¸¡ã•ã‚ŒãŸå¼•æ•°ãªã®ã‹ã©ã†ã‹ãƒ•ãƒ©ã‚°ã‚’ç¢ºã‹ã‚ã‚‹æ–¹æ³• - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
class Hash class << self def ruby2_keywords_hash?(hash) !new(*[hash]).default.equal?(hash) end def ruby2_keywords_hash(hash) _ruby2_keywords_hash(**hash) end private def _ruby2_keywords_hash(*args) args.last end ruby2_keywords(:_ruby2_keywords_hash) if respond_to?(:ruby2_keywords, true) end end RUBY_VERSION # => "2.7.0" def passed_kw?(*args) Hash.ruby2_keywords_hash?(args.last) end ruby2_keywords(
a2ikm 2020/02/27
ruby

kamipo
ãƒªãƒ³ã‚¯
ITã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã®ãƒˆãƒ¬ãƒ³ãƒ‰æƒ…å ± | Forkwell Press ï¼ˆãƒ•ã‚©ãƒ¼ã‚¯ã‚¦ã‚§ãƒ«ãƒ—ãƒ¬ã‚¹ï¼‰
ã•ã¾ã–ã¾ãªä¼æ¥ã§åƒãã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ãƒªãƒ¬ãƒ¼å½¢å¼ã§å¯¾è«‡ã‚’è¡Œã†DevRelayã€‚ãƒˆãƒ¬ã‚¸ãƒ£ãƒ¼ãƒ‡ãƒ¼ã‚¿ã® @kamipo ã“ã¨ä¸Šè–—ç«œå¤ªæ°ã«å¼•ãç¶šãã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼ã—ã¾ã™ã€‚ä»Šå›žã¯ã€è‡ªèº«ã‚’è¿½ã„è¾¼ã¿ç¶šã‘ã‚‹ç†ç”±ã‚„ãƒ¢ãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ç¶æŒã®æ–¹æ³•ã‚’ä¼ºã„ã¾ã—ãŸã€‚ã“ã®å¯¾è«‡ã¯ã€3éƒ¨æ§‹æˆï¼ˆvol.10ãƒ»vol.11ãƒ»vol.12ï¼‰ã§ãŠå±Šã‘ã—ã¾ã™ã€‚ DevRelayå…¨25å›žã¯ã“ã¡ã‚‰ã‹ã‚‰ã”è¦§ã„ãŸã ã‘ã¾ã™ è‡ªåˆ†ã‚’è¿½ã„è¾¼ã‚€ã“ã¨ã§ã—ã‹é€²ã‚ãªã„é ˜åŸŸãŒã‚ã‚‹ idesakuï¼šRails ã®å‹•å‘ã‚’æ¯Žæœãƒã‚§ãƒƒã‚¯ã—ã¦ã€ãƒ—ãƒ«ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’æŠ•ã’ç¶šã‘ã‚‹ã€ã¨ã„ã£ãŸå–¶ã¿ã‚’æ—¥èª²ã¨ã—ã¦ç¶™ç¶šã™ã‚‹ãƒ¢ãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€ã©ã“ã‹ã‚‰ç”Ÿã¾ã‚Œã‚‹ã‚“ã§ã—ã‚‡ã†ã‹ã€‚ kamipoï¼šä¸€ç•ªå¤§ãã„ã®ã¯ã€Œç¶šã„ã¦ã„ã‚‹ã“ã¨ã¯ç¶šã‘ãŸããªã‚‹ã€ã ã¨æ€ã„ã¾ã™ã€‚ idesakuï¼šãŸã—ã‹ã«ã€ä¸€åº¦ç¿’æ…£ã«ãªã£ã¦ã—ã¾ã£ãŸã“ã¨ã¯ã€æ–ã¡ãŒãŸããªã£ã¦ãã¾ã™ã‚ˆãã€‚ è€ƒãˆç¶šã‘ã‚‹ã“ã¨ã§æ–°ã—ã„æ°—ã¥ããŒå¾—ã‚‰ã‚Œã‚‹ kamipoï¼šã‚‚ã¨ã‚‚ã¨ã€ŒAc
a2ikm 2020/01/09
kamipo

interview
ãƒªãƒ³ã‚¯
Rails 6.0ã§Deprecatedã«ãªã‚‹Active Recordã®æŒ¯ã‚‹èˆžã„3ã¤ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
Deprecatedã«ã—ãŸçµŒç·¯ã¨ã„ã†ã‹èƒŒæ™¯ãŒä¼ã‚ã£ã¦ã‚‹ã®ã‹ã©ã†ã‹ã‚¢ãƒ¬ã ã¨æ€ã£ãŸã®ã§ã€ã“ã“ã«æ—¥æœ¬èªžã«ã¦æ›¸ãè¨˜ã—ã¦ãŠãã€‚ Deprecate mismatched collation comparison for uniquness validator by kamipo Â· Pull Request #35350 Â· rails/rails Â· GitHub Active Recordã®uniqueness validatorã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§case sensitiveãªæ¯”è¼ƒã‚’ã™ã‚‹ã‚“ã§ã™ãŒã€ã“ã‚ŒãŒã€æ–‡å—åˆ—ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®collationãŒcase insensitiveãªMySQLã¨ç›¸æ€§ãŒæ‚ªãã€DBä¸Šã®UNIQUEåˆ¶ç´„ã¨ä¸€è‡´ã—ãªã„æŒ¯ã‚‹èˆžã„ã ã£ãŸã‚ŠINDEXãŒåŠ¹çŽ‡ã‚ˆãä½¿ãˆãšDBãŒæ»ã¬ã¿ãŸã„ãªå•é¡Œã‚’å¼•ãèµ·ã“ã—ã¦ã„ã¾ã—ãŸã€‚ ä¾‹: æœ¬å½“ã«ã‚ã£ãŸRailsã®æ€–ã„è©± åƒ•ã‚‚ä¸»ã«ä»•äº‹ã®ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ“ãƒ¥ãƒ¼ã§éŽåŽ»ã«ä½•
a2ikm 2019/05/15
kamipo

rails

activerecord
ãƒªãƒ³ã‚¯
MySQLã®ã‚¯ã‚¨ãƒªã®è‰¯ã—æ‚ªã—ã¯rows_examinedã§åˆ¤æ–ã™ã‚‹ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
ä»•äº‹ã‚„ã‚‰ãªã‚“ã‚„ã‚‰ã§MySQLã®ã‚¯ã‚¨ãƒªã®è‰¯ã—æ‚ªã—ã‚’åˆ¤æ–ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã¨ãã€EXPLAINã®å†…å®¹ã ã‘ã ã¨ã©ã®ãã‚‰ã„è‰¯ããªã£ãŸã‚Šæ‚ªããªã£ãŸã®ã‹åˆ†ã‹ã‚‰ãªã„ã®ã§ SET long_query_time = 0; ã—ã¦rows_examined (ãã®ã‚¯ã‚¨ãƒªã§rows_sentè¡Œã®çµæžœã‚’è¿”ã™ãŸã‚ã«ä½•è¡Œã«è§¦ã£ãŸã®ã‹)ã‚‚ä¸€ç·’ã«æç¤ºã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã‚‹(å°‘ãªãã¨ã‚‚MySQL 5.7æ™‚ç‚¹ã§ã¯rows_examinedã¯slow_query_logã§ã—ã‹ç¢ºèªã§ããªã„ã¯ãšperformance_schemaãŒæœ‰åŠ¹ãªã‚‰events_statements_historyã‚„ãã®ä»²é–“ãŸã¡ã§ç¢ºèªã§ãã‚‹ã¨ã®ã“ã¨*1 MySQL :: MySQL 5.6 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 22.9.6 ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¹ã‚ãƒ¼ãƒžã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚¤ãƒ™ãƒ³ãƒˆãƒ†ãƒ¼ãƒ–ãƒ«)ã€‚ ä¾‹: ä¸Šã®ä¾‹ã®Beforeã¯ã€ã‚‚ã¨ã‚‚ã¨DBAãŒæ›¸ã„ãŸæ¸©ã‹ã¿ã®ã‚ã‚‹SQLã§O
a2ikm 2018/03/22
mysql
ãƒªãƒ³ã‚¯
xtrabackupã‚’ã¡ã‚‡ã£ã¨ä¾¿åˆ©ã«ä½¿ã† - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
xtrabackupã«ã¯innobackupexã¨ã„ã†ãƒ©ãƒƒãƒ‘ãƒ¼ã‚¹ã‚¯ãƒªãƒ—ãƒˆãŒä»˜å±žã—ã¦ã„ã¦ã€MySQLã®ãƒ—ãƒã‚»ã‚¹ã‚’æ¢ã‚ã‚‹ã“ã¨ãªããƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚Œã¦ä¾¿åˆ©ãªã‚“ã§ã™ãŒã€innobackupexã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å–ã‚‹ã¨ä»¥ä¸‹ã®ç‚¹ãŒä¸æº€ã ã£ãŸã‚Šã™ã‚‹ã€‚ --slave-infoã§ç”Ÿæˆã•ã‚Œã‚‹CHANGE MASTERæ–‡ãŒä¸å®Œå…¨ãªã®ã§slaveã®è¤‡è£½ãŒé¢å€’ InnoDBã¨MyISAMã®ãƒ•ã‚¡ã‚¤ãƒ«ã—ã‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã•ã‚Œãªã„ tritonnã§sennaã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ãŒãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã•ã‚Œãªãã¦å›°ã‚‹ ãã“ã§ã€innobackupexã¯Perlã§æ›¸ã‹ã‚Œã¦ã‚‹ã®ã§ç›´æŽ¥æ›¸ãæ›ãˆã¦master.infoã¨sennaã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚ä¸€ç·’ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã‚ˆã†ã«ã—ãŸã‚‰slaveç°¡å˜ã«è¤‡è£½ã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ä¾¿åˆ©ã§ã™ã‚ˆï¼
a2ikm 2017/02/14
xtrabackup

kamipo

innodb

mysql
ãƒªãƒ³ã‚¯
é‡‘é«ªã®ç¥žã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ»kamipo ä¼èª¬ã®ã‚‚ã†ã²ã¨ã¤ã®çœŸå®Ÿ ï¼ãƒˆãƒ¬ã‚¸ãƒ£ãƒ¼ãƒ‡ãƒ¼ã‚¿ ä¸Šè–—ç«œå¤ªæ° - Forkwell Press
a2ikm 2017/02/07
kamipo

interview

engineer

career
ãƒªãƒ³ã‚¯
ã€Œã“ã®å¢ƒåœ°ã«ã„ã‚‹ã®ã¯è‡ªåˆ†ã ã‘ã€âˆ’ è‡ªèº«ã‚’è¿½ã„è¾¼ã¿ç¶šã‘ã¦ãŸã©ã‚Šç€ãã€Œé«˜ã¿ã€ã¨ã¯ âˆ’Â ãƒˆãƒ¬ã‚¸ãƒ£ãƒ¼ãƒ‡ãƒ¼ã‚¿ kamipo æ° - Forkwell Press
a2ikm 2017/02/01
kamipo

engineer

interview
ãƒªãƒ³ã‚¯
å›ãŒãƒƒï¼ æ³£ã„ã¦ãƒžãƒ¼ã‚¸ã™ã‚‹ã¾ã§ã€ãƒ—ãƒ«ãƒªã‚¯ã‚’é€ã‚‹ã“ã¨ã‚’ã‚„ã‚ãªã„ãƒƒï¼ï¼ãƒˆãƒ¬ã‚¸ãƒ£ãƒ¼ãƒ‡ãƒ¼ã‚¿ ä¸Šè–—ç«œå¤ªæ° - Forkwell Press
a2ikm 2017/01/24
kamipo

interview
ãƒªãƒ³ã‚¯
MySQLã§ORDER BYã‚’ã¤ã‘ãªã„ã¨ãã®ä¸¦ã³é † - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
ãƒ¡ãƒªãƒ¼ã‚¯ãƒªã‚¹ãƒžã‚¹ï¼ðŸŽ…ðŸŽ„ ã“ã®ã‚¨ãƒ³ãƒˆãƒªã¯MySQL Casual Advent Calendar 2016ã®24æ—¥ç›®ã§ã™ã€‚ ä»Šæ—¥ã¯ã“ã‚Œã®è©±ã§ã™ï¼ @eagletmt å®Ÿè£…ã¨å®Ÿè¡Œè¨ˆç”»ä¾å˜ã§ã™(ãŸã¨ãˆã°InnoDBã§å˜ä¸€ã‚«ãƒ©ãƒ ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚ŒãŸå ´åˆã®sort orderã¯primary keyã«ãªã‚‹ã¯ãšã§ã™)â€” Ryuta Kamizono (@kamipo) December 4, 2016 @eagletmt ã™ã„ã¾ã›ã‚“ã€ã™ã“ã—é–“é•ã„ãŒã‚ã‚Šã¾ã—ãŸã€‚ã‚‚ã— hoge_id = ? ã®ã‚ˆã†ãªçµžã‚Šè¾¼ã¿ã§å˜ä¸€ã‚«ãƒ©ãƒ ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒæŽ¡ç”¨ã•ã‚ŒãŸå ´åˆã¯sort orderã¯primary keyã«ãªã‚‹ã¯ãšã§ã™ã€‚InnoDBå‰æãªã‚‰åŸºæœ¬çš„ã«å®Ÿè¡Œè¨ˆç”»ä¾å˜ã§ã™ã€‚â€” Ryuta Kamizono (@kamipo) December 4, 2016 @eagletmt MySQLã§order byç„¡ã—ã®ã¨
a2ikm 2017/01/03
innodb

kamipo

mysql
ãƒªãƒ³ã‚¯
MySQLã¨Unicode
Your browser doesn't support the features required by impress.js, so you are presented with a simplified version of this presentation. For the best experience please use the latest Chrome or Safari browser. Firefox 10 (to be released soon) will also handle it.
a2ikm 2016/01/24
kamipo

mysql

unicode

slide
ãƒªãƒ³ã‚¯
mysql-buildã§ã„ã‚ã‚“ãªãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã„ï¼ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
ã“ã‚Œã¯MySQL Casual Advent Calendar 2011 - MySQL Casualã®8æ—¥ç›®ã®è¨˜äº‹ã§ã™ï¼ UDFã§FizzBuzz id:sugyanã•ã‚“ãŒã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã§FizzBuzzã‚’ã‚„ã£ã¦ã„ãŸã®ã§MySQLã®UDF(user-defined function)ã§ã‚‚ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ kamipo/mysql_fizzbuzz Â· GitHub git clone git://github.com/kamipo/mysql_fizzbuzz.git cd mysql_fizzbuzz g++ -shared -fPIC -Wall -g mysql_fizzbuzz.cc -o mysql_fizzbuzz.so cp mysql_fizzbuzz.so /usr/local/mysql/lib/mysql/plugin mysql -u root -e "cr
a2ikm 2015/12/16
mysql-build

kamipo

mysql
ãƒªãƒ³ã‚¯
GitHub - kamipo/mysql-build: Compile and install 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
a2ikm 2015/12/08
mysql

kamipo
ãƒªãƒ³ã‚¯
Remove `DEFAULT_CHARSET` and `DEFAULT_COLLATION` by kamipo Â· Pull Request #22061 Â· rails/rails
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
a2ikm 2015/11/02
kamipo

activerecord

collation

charset

mysql
ãƒªãƒ³ã‚¯
ISUCON5 äºˆé¸å•é¡Œã®è§£èª¬ã¨è¬›è©• : ISUCONå…¬å¼Blog
ISUCON5ã®å‡ºé¡Œæ‹…å½“ã®ä¸€äººã€kamipoã§ã™ã€‚ ä»Šå›žã¯ISUCON5ã®äºˆé¸å•é¡ŒãŒã©ã†ã„ã†å•é¡Œã ã£ãŸã®ã‹ã€æŒ¯ã‚Šè¿”ã£ã¦ã¿ã¾ã—ã‚‡ã†ï¼ äºˆé¸å‡ºé¡Œã€ŒISUxiã€ä»Šå›žã®äºˆé¸ã®å‡ºé¡Œã«ãŠã‘ã‚‹ãƒ¡ã‚¤ãƒ³ãƒˆãƒ”ãƒƒã‚¯ã¯ã€ŒN+1å•é¡Œã€ã§ã—ãŸã€‚ã“ã®å•é¡Œã«ã†ã¾ãå¯¾å‡¦ã§ããŸã‹ã©ã†ã‹ãŒçµæžœã«å¤§ããå½±éŸ¿ã—ãŸã¨æ€ã„ã¾ã™ã€‚ã¾ãŸã€ISUxiã§ã¯N+1å•é¡Œå«ã‚åˆ¶é™æ™‚é–“å†…ã«ã¯å¯¾å‡¦ã—ãã‚Œãªã„ãã‚‰ã„å¤šãã®å•é¡ŒãŒã€Œ/ã€ãƒšãƒ¼ã‚¸ã«è©°ã‚è¾¼ã¾ã‚Œã¦ã„ãŸã®ã§ã€ã“ã‚Œã‚‰ã®å•é¡Œã¸ã®å„ªå…ˆé †ä½ä»˜ã‘ã‚„ç€å®Ÿã«å¯¾å‡¦ã§ãã‚‹ã‹ã‚‚é‡è¦ã§ã—ãŸã€‚ã¨ã„ã†ã‚ã‘ã§ã€ã€Œ/ã€ãƒšãƒ¼ã‚¸ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ã¤ã„ã¦è§£èª¬ã™ã‚‹ã“ã¨ã§æœ¬äºˆé¸ã®æŒ¯ã‚Šè¿”ã‚Šã¨ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ N+1ã€Œ/ã€ãƒšãƒ¼ã‚¸ã§ã¯is_friend?ã¨get_userã®å¤§é‡ã®å‘¼ã³å‡ºã—ãŒã‚ã‚Šã¾ã—ãŸã€‚ã“ã‚Œã‚‰ã¯user_idã«ç´ä»˜ããƒ‡ãƒ¼ã‚¿ãªã®ã§SQLã§JOINã™ã‚‹ã“ã¨ã§å‘¼ã³å‡ºã—ã‚’ç„¡ãã™ã“ã¨ãŒã§ãã¾ã™ã€‚ã‚‚ã—ãã¯ã€usersãƒ†ãƒ¼ãƒ–ãƒ«ã®å†…å®¹ã‚’å¤‰æ›´ã™ã‚‹æ©Ÿèƒ½
a2ikm 2015/10/07
isucon

kamipo

sql
ãƒªãƒ³ã‚¯
ãƒ«ãƒ¼ã‚¯ï¼MySQLã§ã¯kamipo TRADITIONALã‚’ä½¿ãˆï¼ | ãŠãã‚‰ãã¯ãã‚Œã•ãˆã‚‚å¹³å‡¡ãªæ—¥ã€…
ã‚ˆãMySQLã¯ã‚†ã‚‹ãµã‚ã ã‹ã‚‰ å€¤ãŒå‹æ‰‹ã«åˆ‡ã‚Šè©°ã‚ã‚‰ã‚Œã‚‹ ã‚¨ãƒ©ãƒ¼ãŒèµ·ããšã«å¤‰ãªå€¤/æ—¥ä»˜ãŒå…¥ã‚‹ ä¸æ£ãªã‚¹ã‚ãƒ¼ãƒžãŒå…¥ã£ã¦ã—ã¾ã† ãªã©è¨€ã‚ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ãŸã ãã‚Œã¯ã€ãã‚‚ãã‚‚ã®è¨å®šãŒæ‚ªã„ã®ã§ã™ã€‚(ç¢ºã‹ã«æ˜”ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒã‚†ã‚‹ãµã‚ãªã®ã¯ã„ã‘ãªã‹ã£ãŸã‚“ã§ã™ãŒ) ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯ä¸æ£ãªå€¤ãŒå…¥ã‚‰ãªã„ã‚ˆã†ã«è¨å®šã¯ã¨ã«ã‹ãåŽ³ã—ãã—ã¦ãŠãã®ãŒã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã€‚ ã˜ã‚ƒã‚ã©ã†ã™ã‚‹ã‹ã€‚ MySQLã¯SQL Modeã«ã‚ˆã£ã¦ã€ãã®è¾ºã‚Šã®åˆ¶ç´„ã‚’ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ä»¥å‰ã€MySQLã®sql-modeã§ä¸€ç•ªåŽ³ã—ã„ã‚„ã¤ã¯TRADITIONALã€ã¨ã„ã†ã®ã‚’æ›¸ã„ãŸã®ã§ã™ãŒã€å®Ÿã¯ãã‚Œã ã‘ã§ã¯ä¸ååˆ†ã§ã€TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BYã¨ã™ã‚‹ã®ãŒã‚ˆã‚Šå®‰å¿ƒãªã‚ˆã†ã§ã™ã€‚ ã“ã‚Œã¯kamipoã•ã‚“ã«æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ @songmu TRADITI
a2ikm 2015/07/09
kamipo

mysql

my.cnf

db
ãƒªãƒ³ã‚¯
Details
Application 19297 Dialog page 4 cannot be rendered successfully. Ensure the page template in use on page 4 is of template type "Dialog page", with appropriate JavaScript dialog initialization, dialog closure and dialog cancel code defined. Contact your application administrator.
a2ikm 2015/06/03
kamipo
ãƒªãƒ³ã‚¯
Treasure Dataã«å…¥ç¤¾ã—ã¾ã—ãŸ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
è¿‘æ³ãªã©ã‚’ãƒ–ãƒã‚°ã«æ›¸ã„ãŸã“ã¨ã¯ãªã‹ã£ãŸã‚“ã§ã™ãŒã€4æœˆã‹ã‚‰Treasure Dataã§åƒãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ 3æœˆã«æ–°ã—ã„ä»•äº‹ã‚’æŽ¢ã—ã¦ãŸã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ã¡ã‚‡ã†ã©å£°ã‚’ã‹ã‘ã¦ã‚‚ã‚‰ã£ã¦ã€ä»–ã«èª˜ã£ã¦ãã‚Œã¦ã‚‹ã¨ã“ã‚ã‚‚ã‚ã£ã¦ã„ã‚ã„ã‚è€ƒãˆãŸã‚“ã§ã™ã‘ã©ã€ä»Šã¾ã§è‡ªåˆ†ãŒã‚„ã£ã¦ãŸWebå±‹ã•ã‚“ã¨ã¯çµæ§‹ã¡ãŒã†å°‚é–€çš„ãªãƒ—ãƒãƒ€ã‚¯ãƒˆãŒé¢ç™½ãã†ã ã£ãŸã“ã¨ã€è©±ã—ã¦ã¿ã¦ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ä¸Šã®è§£æ±ºã—ãŸã„èª²é¡Œã«ã¤ã„ã¦ã™ã”ãå…·ä½“çš„ã«ã„ã‚ã„ã‚è©±ã—ã¦ãã‚ŒãŸã®ã§ã€ç•‘é•ã„ãªæ°—ã‚‚ã™ã‚‹ã‘ã©ã‚„ã‚Œã‚‹ã“ã¨ã¯çµæ§‹ã‚ã‚Šãã†ã ãªã¨ã‚¤ãƒ¡ãƒ¼ã‚¸ã§ããŸã®ã§å…¥ç¤¾ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã‚ã¨ã¯å£°ã‚’ã‹ã‘ã¦ãã‚Œã‚‹ã®ãŒ2é€±é–“é…ã‹ã£ãŸã‚‰ä»–ã®ã¨ã“ã‚ã«æ±ºã‚ã¡ã‚ƒã£ã¦ãŸã®ã§ã€ãŠäº’ã„ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ãŒåˆã£ã¦ãŸã“ã¨ã§è‡ªåˆ†ãŒæƒ³åƒã—ã¦ã„ãªã‹ã£ãŸé¸æŠžè‚¢ãŒç”Ÿã¾ã‚ŒãŸã“ã¨ã«ã‚‚é¢ç™½ã•ã‚’æ„Ÿã˜ã¦ã€ã¾ã‚ã“ã‚Œã‚‚è‡ªåˆ†ã®ä¸ã®ã²ã¨ã¤ã®ãƒãƒ£ãƒ¬ãƒ³ã‚¸ã ã¨æ€ã£ã¦è¿”äº‹ã‚’ã—ãŸã¨ã„ã†æ„Ÿã˜ã§ã™ã€‚ Hadoopã‚‚Fluentdã‚‚ã‚ˆãåˆ†ã‹ã‚‰ã‚“ã—Sl
a2ikm 2015/04/03
ãŠã‚ã§ã¨ã†ã”ã–ã„ã¾ã™ï¼//activerecord-mysql-awesomeãŒã‚ã‚ŠãŒãŸã‹ã£ãŸã®ã§ãƒŸãƒãƒ©ãƒ«ã‚¦ã‚©ãƒ¼ã‚¿ã‚’è´ˆã‚Šã¾ã—ãŸã€‚ã‚®ãƒ•ãƒˆãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒä»˜ã‘ã‚‰ã‚Œãªã‹ã£ãŸã®ã§ã“ã“ã§

kamipo

treasuredata

work

career
ãƒªãƒ³ã‚¯
MySQL ã¨ Unicode Collation Algorithm (UCA) - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
utf8_unicode_ci ã«å¯¾ã™ã‚‹æ—¥æœ¬ã®é–‹ç™ºè€…ã®è¦‹è§£ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹ ã§ã€æ—¥æœ¬èªžãŒåˆ†ã‹ã‚‹äººã«ã¯ utf8_unicode_ci ã®ãƒ¤ãƒã•ã‚’æ„Ÿã˜ã¦ã‚‚ã‚‰ãˆãŸã¨æ€ã†ã‚“ã§ã™ã‘ã©ã€ã“ã®æŒ™å‹•ã¯ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã‚ˆã‚‹ã¨ UCA ã¨ã„ã†ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã«ã‚ˆã‚‹ã‚‚ã®ã‚‰ã—ã„ã€‚ MySQL implements the xxx_unicode_ci collations according to the Unicode Collation Algorithm (UCA) described at http://www.unicode.org/reports/tr10/. The collation uses the version-4.0.0 UCA weight keys: http://www.unicode.org/Public/UCA/4.0.0/allkeys-4.0.0.txt. Currently,
a2ikm 2015/03/17
mysql

unicode

collation

kamipo
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸