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
#yapcasia ã§MySQL 5.7ã®ç½ ã«ã¤ã„ã¦LTã—ã¦ãã¾ã—ãŸ
ãƒã‚¿çš„ã«ã¯ 発掘ã™ã‚‹ãŸã³æ›¸ã溜ã‚ã¦ããŸãƒ–ãƒã‚°è¨˜äº‹ ã‹ã‚‰ 笑ã„ãŒå–ã‚Œãã†ãªã‚‚ã®ã‚’ 大事ãã†ãªã‚‚ã®ã®ã¿ã‚’ピックアップã—ã¦ç´¹ä»‹ã—ãŸæ„Ÿã˜ã§ã™ã€‚ 知らãªã„ã¨è‡´å‘½å‚·ã€ã§ã‚‚知ã£ã¦ã‚Œã°äºˆé˜²ã§ãる（ã¯ãšï¼‰ MySQL 5.7ã§ä¸å¹¸ã«ãªã‚‹äººãŒ1人ã§ã‚‚å°‘ãªããªã£ã¦ãれるã“ã¨ã‚’願ã£ã¦ã„ã¾ã™ã€‚ ã•ã¦ã€ä»Šå¹´ã®YAPC::Asiaã¯ãƒ¡ã‚¤ãƒ³ãƒˆãƒ©ãƒƒã‚¯ã‚‚トークを応募ã—ã¦ã„ãŸã®ã§ã™ãŒè¦‹äº‹ã«è½é¸ã—ãŸã®ã§ã€1日目ã¯å®Œå…¨ã«ãƒªãƒ©ãƒƒã‚¯ã‚¹ã—ã¦éŽã”ã—ã¾ã—ãŸã€‚LTã®æŽ¡å¦ã€å½“æ—¥ã«ãªã‚‹ã¾ã§ã‚ã‹ã‚“ãªã„ã®ã‹å¤§å¤‰ã ãªãƒ¼ã¨ã‹ã€ä»–人事ã ã£ãŸã‚“ã§ã™ãŒã€ 1日目ã®LT見るã˜ã‚ƒãªã„ã§ã™ã‹ã€‚ é¢ç™½ã„ã˜ã‚ƒãªã„ã§ã™ã‹ã€‚ 俺もã—ゃã¹ã‚ŠãŸããªã‚‹ã˜ã‚ƒãªã„ã§ã™ã‹ã€‚ ãªã£ãŸã‚“ã§ã™ã‚ˆï¼ï¼ï¼‘ ãŒã€ç¿Œæœã«ãªã£ã¦LTã®å¿œå‹Ÿãƒšãƒ¼ã‚¸ã‚’ãŸã©ã£ã¦ã¿ã‚‹ã¨
JSON SQL Injection and the Lessons Learned
This document discusses JSON SQL injection and lessons learned from vulnerabilities in SQL query builders. It describes how user-supplied JSON input containing operators instead of scalar values could manipulate queries by injecting conditions like id!='-1' instead of a specific id value. This allows accessing unintended data. The document examines how SQL::QueryMaker and a strict mode in SQL::Mak
Google BigQuery ã®è©± #yapcasia // Speaker Deck
フãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã®ãƒ‘ラダイムをå‚考ã«ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰é–‹ç™ºã‚’å†è€ƒã™ã‚‹ / TypeScript ã«ã‚ˆã‚‹ GraphQL ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰é–‹ç™º
Whereç‹™ã„ã®ã‚ーã€order byç‹™ã„ã®ã‚ー
11. I'm yoku0825 â— ã¨ã‚ã‚‹ä¼æ¥ã®DBA ◠オラクれãªã„ â— ãƒã‚¹ã‚°ã‚Œãªã„ ◠マイエスã‚ューエる ◠家ã«å¸°ã‚‹ã¨ â— å«ã®å¤« â— ã›ãŒã‚Œã®çˆ¶ ◠馬鹿ã ã‹ã‚‰ã‹ã‚ã„ã„ã‚ã‘ã˜ã‚ƒãªãã¦ã€ã‹ã‚ã„ㄠイルカãŒãŸã¾ãŸã¾ãƒã‚«ã ã£ãŸ 12. ã¯ã˜ã‚㫠◠サンプルデータ㯠MySQLã®ã‚µãƒ³ãƒ—ルデータ ベース(worldデータベース)ã‹ã‚‰ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ スを全ã¦å–ã£æ‰•ã£ãŸã‚‚ã®ã§ã™ â— http://dev.mysql.com/doc/index-other.html ◠コードã¯githubã«ä¸Šã’ã¦ã‚ã‚Šã¾ã™ â— https://github.com/yoku0825/yapc_2014 â— ã™ã”ã…ウンコードã§ã™â€¦ 13. ã¯ã˜ã‚㫠◠原則ã€MySQLã¯1ã¤ã®ãƒ†ãƒ¼ãƒ–ルã«ã¤ãåŒæ™‚ã«1 ã¤ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã—ã‹ä½¿ã„ã¾ã›ã‚“ â— Index mergeã¨ã‹ã‚ã‚‹ã‘ã©ã‚¢ãƒ¬ã¯ä¾‹å¤–ã ã—ç‹™ã£ã¦ ã‚„ã£ã¦ã‚‚速ããªã‚‹
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
MySQLã§2億件ã®ãƒ‡ãƒ¼ã‚¿æŠ•å…¥ã«75時間ï¼ï¼Ÿã ãŒå¢—å¼·ã¯ç„¡ç†ï¼ã ã£ãŸã‚‰å¾¹åº•çš„ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã‚„ã‚‹ãœã£ #yapcasia #yapcasiaD #MySQL
http://kfly8.github.io/yapc/20140830_social_game.html
{{#tags}}- {{label}}
{{/tags}}