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

TaKUMA id:TaKUMA

MySQLã«é–¢ã™ã‚‹TaKUMAã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

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

Uberã®Postgresqlã‹ã‚‰NoSQL on MySQLã¸ã®ç§»è¡Œã‚’èªã‚“ã§ã–ã£ãã‚Šã¾ã¨ã‚ãŸ
Uber-migrated-pg-to-mysql.md Why Uber Engineering Switched from Postgres to MySQL - Uber Engineering Blog ã®ã¾ã¨ã‚ Posgresqlã ã¨ pgã¯è¿½è¨˜åž‹ãªã®ã§å°‘ã—ã®æ›´æ–°ã§ã‚‚å¤šãã®diskã¸ã®writeãŒãŠãã‚‹ ã‚«ãƒ©ãƒ ã‚’ä¸€ã¤æ›´æ–°ã—ãŸã ã‘ã§å¤šãã®indexã®æ›¸ãæ›ãˆãŒèµ·ã“ã‚‹ ã‚ˆã£ã¦ã€replicationã¯WALã‚’é€ã‚‹ã®ã§æ›´æ–°ãŒå¤šã„ã¨WALãŒå¤§é‡ã«é€ã‚‰ã‚Œã‚‹ repcliationã§ã¯ç‰©ç†çš„ãªdiskã®å¤‰æ›´ã‚’é€ã‚‹ DCé–“ã§ãƒ¬ãƒ—ãƒªã™ã‚‹ã¨ãã¤ã„ bugãŒã‚ã£ã¦replicaé–“ã§MVCCã®ä¸æ•´åˆãŒèµ·ãã‚‹ masterã¨replicaåŒã˜diskä¸Šã®ãƒ‡ãƒ¼ã‚¿æ§‹æˆã‚’å…±æœ‰ã™ã‚‹ã®ã§upgradeãŒã¤ã‚‰ã„ cache readã¯syscallã¨osã®page cacheçµŒç”±ãªã®ã§é‡ã„ 1ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³1ãƒ—ãƒã‚»ã‚¹
TaKUMA 2016/08/23
MySQL

PostgreSQL
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚´ãƒ«ãƒ• - ãªã‚“ã¨3æ–‡å—ã§èªè¨¼å›žé¿ãŒå¯èƒ½ã«
æ˜¨æ—¥ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚´ãƒ«ãƒ• - èªè¨¼å›žé¿ã®æ”»æ’ƒæ–‡å—åˆ—ã¯ã©ã“ã¾ã§çŸãã§ãã‚‹ã‹?ã€ã«ã¦ã€èªè¨¼å›žé¿ã®æ”»æ’ƒæ–‡å—åˆ—ãŒ5æ–‡å—ã«ã§ãã‚‹ï¼ˆã€Œ'OR'1ã€ï¼‰ã“ã¨ã‚’ç¤ºã—ã¾ã—ãŸãŒã€@masa141421356ã•ã‚“ã¨ã€ã‚„ã¾ã–ãã•ã‚“ï¼ˆãŠäºŒäººã¨ã‚‚æ‹™è‘—ã®ãƒ¬ãƒ“ãƒ¥ã‚¢ãƒ¼ã§ã™ï¼‰ã‹ã‚‰ã€idã¨pwdã«ã¾ãŸãŒã£ãŸæ”»æ’ƒä¾‹ã‚’ç¤ºã—ã¦ã„ãŸã ãã¾ã—ãŸã€‚ã‚„ã¾ã–ãã•ã‚“ã®ä¾‹ã¯ã€MySQLé™å®šãªãŒã‚‰ã€ãªã‚“ã¨3æ–‡å—ã§ã™ã€‚ã“ã‚Œã¯ã™ã”ã„ã€‚ @masa141421356ã•ã‚“ã®æ”»æ’ƒä¾‹ @masa141421356ã•ã‚“ã®ãƒ„ã‚¤ãƒ¼ãƒˆã‚’å¼•ç”¨ã—ã¾ã™ã€‚ @ockeghem å¤§æŠµã®DBã§id=''OR' AND pwd='>' ' ãŒé€šã‚‹ã¨æ€ã„ã¾ã™ï¼ˆidå´ã«ã€Œ'ORã€, pwdå´ã«ã€Œ>' ã€ã§6æ–‡å—ï¼‰ã€‚é•·ã•0ã®æ–‡å—åˆ—ãŒNULLæ‰±ã„ã•ã‚Œãªã„DBãªã‚‰æœ€å¾Œã®ã‚¹ãƒšãƒ¼ã‚¹ã‚’æ¶ˆã—ã¦5æ–‡å—ã§ã™ã€‚ â€” masa141421356 (@masa141421356) June
TaKUMA 2014/10/13
security

MySQL

SQL Injection
ãƒªãƒ³ã‚¯
ClearDB MySQL | Heroku Dev Center
Effective November 30, 2024, ClearDB database services is discontinued. Transfer all data hosted by or on behalf of ClearDB to a supported database service, such as Heroku Postgres, before that date. Learn more about Databases & Data Management in Heroku. Learn how to Migrate from MySQL to Postgres on Heroku. Find other available database services in the Elements marketplace. Where possible, we ch
TaKUMA 2013/08/29
ClearDB

Heroku

MySQL
ãƒªãƒ³ã‚¯
coolestguyplanettech.comÂ -Â coolestguyplanettech ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
TaKUMA 2013/06/10
MySQL

Tips
ãƒªãƒ³ã‚¯
A Visual Explanation of SQL Joins
11 Oct 2007 A Visual Explanation of SQL Joins I thought Ligaya Turmelle's post on SQL joins was a great primer for novice developers. Since SQL joins appear to be set-based, the use of Venn diagrams to explain them seems, at first blush, to be a natural fit. However, like the commenters to her post, I found that the Venn diagrams didn't quite match the SQL join syntax reality in my testing. I love
TaKUMA 2012/08/27
ã‚ã‹ã‚Šã‚„ã™ã„

SQL

MySQL
ãƒªãƒ³ã‚¯
Sequel Pro
Full MySQL Support Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. Perfect Web Development Companion Whether you are a Mac Web Developer, Programmer or Software Developer your workflow will be streamlined with a native Mac OS X Application! Flexible Connectivity Sequel Pro gives you direct access to your MySQL Databases on local and remote se
TaKUMA 2012/08/23
Macç”¨ã®MySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ

MySQL

SQL

Software
ãƒªãƒ³ã‚¯
CREATE TABLEæ§‹æ–‡
CREATE TABLE æ§‹æ–‡ã§ä½¿ç”¨ã§ãã‚‹æ§˜ã€…ãªã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ MySQL5.0.16å¯¾å¿œ ã‚«ãƒ©ãƒ å®šç¾© AUTO_INCREMENT CREATE TABLE new_table ( i integer AUTO_INCREMENT ); ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã‚«ãƒ©ãƒ ã‚’å®šç¾©ã—ã¾ã™ã€‚ NULL / NOT NULL CREATE TABLE new_table ( i integer NOT NULL ); ã‚«ãƒ©ãƒ ã®NULLå¯å¦ã‚’è¨å®šã—ã¾ã™ã€‚ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯NULL(NULLå¯)ã§ã™ã€‚ DEFAULT CREATE TABLE new_table ( i integer NOT NULL DEFAULT 10 ); ã‚«ãƒ©ãƒ ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã‚’å®šç¾©ã—ã¾ã™ã€‚ COMMENT CREATE TABLE new_table ( i integer COMMENT 'column_comment'
TaKUMA 2012/08/21
MySQL

SQL
ãƒªãƒ³ã‚¯
ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ä½œæˆ
MySQL ã§ä½•ã‚‰ã‹ã®æ“ä½œã‚’è¡Œã†ã«ã¯ã€ä½œæˆæ¸ˆã¿ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ãƒã‚°ã‚¤ãƒ³ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ MySQL ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ãã«ã™ã¹ã¦ã®æ¨©é™ã‚’æŒã¤ root ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒä½œæˆã•ã‚Œã¾ã™ãŒã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã«æ–°ã—ã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’ä½œæˆã™ã‚‹ã“ã¨ãŒã§ãã€ãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ä¸Žãˆã‚‹æ¨©é™ã‚’è¨å®šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®å‰Šé™¤ã‚„æ¨©é™ã®å¤‰æ›´ã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å†è¨å®šã€ãã—ã¦ä½œæˆæ¸ˆã¿ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®å‰Šé™¤ã€ãªã©ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚
TaKUMA 2012/07/23
MySQL
ãƒªãƒ³ã‚¯
1