[B! DB] otakumesiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

otakumesi id:otakumesi

DBã«é–¢ã™ã‚‹otakumesiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

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

How Does a Database Work?
otakumesi 2017/09/07
Database

sql

db

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQL ã§ utf8 ã¨ utf8mb4 ã®æ··åœ¨ã§èµ·ãã‚‹ã“ã¨ - tmtms ã®ãƒ¡ãƒ¢
MySQL ã‚’ UTF-8 ã§ä½¿ãŠã†ã¨æ€ã£ã¦ãƒãƒžã‚ŠãŒã¡ãªã®ã¯ charset utf8 ã‚’æŒ‡å®šã—ã¦ã—ã¾ã†ã“ã¨ã§ã™ã€‚ MySQL ã® UTF-8 ã«ã¯æ´å²çš„äº‹æƒ…ã«ã‚ˆã‚Š utf8 ã¨ utf8mb4 ã®äºŒã¤ã‚ã‚Šã¾ã™ã€‚ UTF-8 ã¯1ãƒã‚¤ãƒˆã€œ4ãƒã‚¤ãƒˆã§1æ–‡å—ãŒæ§‹æˆã•ã‚Œã‚‹æ–‡å—ã‚³ãƒ¼ãƒ‰ã§ã™ãŒã€MySQL ã® utf8 ã¯4ãƒã‚¤ãƒˆæ–‡å—ã‚’æ‰±ã†ã“ã¨ãŒã§ãã¾ã›ã‚“ã€‚ãƒãƒžã‚ŠãŸããªã‘ã‚Œã° utf8mb4 ã‚’ä½¿ã„ã¾ã—ã‚‡ã†ã€‚ utf8 ã‚’ä½¿ã£ã¦ã—ã¾ã£ãŸå ´åˆã«4ãƒã‚¤ãƒˆæ–‡å—ãŒã©ã®ã‚ˆã†ã«æ‰±ã‚ã‚Œã‚‹ã‹ã€è‡ªåˆ†ã§ã‚‚ã†ã‚è¦šãˆã ã£ãŸã®ã§ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã™ã€‚ ç™»éŒ² æŽ¥ç¶šãŒ utf8mb4 ã§ã‚«ãƒ©ãƒ ãŒ utf8mb4 ã‚ãŸã‚Šã¾ãˆã§ã™ãŒã€ãã®ã¾ã¾ç™»éŒ²ã•ã‚Œã¾ã™ã€‚ mysql> insert into utf8mb4 (c) values ('ç¾Žå‘³ã—ã„ðŸ£ã¨ðŸº'); mysql> select * from utf8mb4; +--------
otakumesi 2017/01/24
mysql

DB

utf8

Unicode
ãƒªãƒ³ã‚¯
PostgreSQL and MySQL: Millions of Queries per Second
This blog compares how PostgreSQL and MySQL handle millions of queries per second. Anastasia:Â Can open source databases cope with millions of queries per second? Many open source advocates would answer â€œyes.â€ However, assertions arenâ€™t enough for well-grounded proof. Thatâ€™s why in this blog post, we share the benchmark testing results from Alexander Korotkov (CEO of Development, Postgres Professio
otakumesi 2017/01/07
postgresql

mysql

db
ãƒªãƒ³ã‚¯
ã‚«ãƒ¼ãƒã‚®ãƒ¼ãƒ¡ãƒãƒ³ã®DBã«é–¢ã™ã‚‹è¬›ç¾©ãŒé¢ç™½ã„ã®ã§ãŠã™ã™ã‚ - ã ã„ãŸã„ã‚ˆãã‚ã‹ã‚‰ãªã„ãƒ–ãƒã‚°
ã“ã“ã«æ›¸ãã“ã¨ã«ã‚ˆã£ã¦é€”ä¸ã§ã‚„ã‚ã‚‰ã‚Œãªãã™ã‚‹ãƒ¡ã‚½ãƒƒãƒ‰ã§ã™ã€‚ ãƒãƒƒã‚«ãƒ¼ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚’çœºã‚ã¦ã„ãŸã‚‰ä»¥ä¸‹ã®ã‚ˆã†ãªCSç³»è¬›ç¾©å‹•ç”»ã®ã¾ã¨ã‚ãƒªãƒã‚¸ãƒˆãƒªãŒæµã‚Œã¦ã„ã¾ã—ãŸã€‚ GitHub - Developer-Y/cs-video-courses: List of Computer Science courses with video lectures. ã¸ãƒ¼ã£ã¨æ€ã„ãªãŒã‚‰ä½•å€‹ã‹ãƒãƒã£ã¦ã¿ãŸã¨ã“ã‚ä»¥ä¸‹ã«å‡ºãã‚ã—ã¾ã—ãŸã€‚ 15721.courses.cs.cmu.edu è‹±èªžãŒï¼ˆè‡ªåˆ†ã«ã¨ã£ã¦ï¼‰èžãå–ã‚Šã‚„ã™ãã€å‹•ç”»ã®å“è³ªï¼ˆç”»è³ªã‚„ã‚¹ãƒ©ã‚¤ãƒ‰ãŒã¡ã‚ƒã‚“ã¨è¦‹ãˆã‚‹ã‹ã©ã†ã‹ã¨ã„ã£ãŸéƒ¨åˆ†ï¼‰ã‚‚è‰¯ã„ã‚‚ã®ã§ã‹ã¤èˆˆå‘³ã®ã‚ã‚‹å†…å®¹ã§å‡ºæ¥ã‚Œã°ã‚¹ãƒ©ã‚¤ãƒ‰ã‚‚ãŠã—ã‚ƒã‚Œã§ãƒ»ãƒ»ãƒ»ã¨ãªã‚‹ã¨ãªã‹ãªã‹å°‘ãªã„ã§ã™ãŒã€ã“ã‚Œã¯ã‹ãªã‚Šè¦‹ã‚„ã™ã„ã§ã™ã€‚ ã‚¹ãƒ©ã‚¤ãƒ‰ã‚‚æ¦‚å¿µå›³ãŒé »ç¹ã«ç™»å ´ã—ãŸã‚Šã—ã¦ã€ã“ã‚Œã ã‘ã§ã‚‚èžãå–ã‚Œãªã‹ã£ãŸéƒ¨åˆ†ãªã©ã‚’ã‹ãªã‚Šè£œå®Œã§ãã¾ã™ã€‚ ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«ãƒšãƒ¼ã‚¸
otakumesi 2016/12/12
DB

Database

å‹‰å¼·

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

computer

ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£
ãƒªãƒ³ã‚¯
Rails ã§ååˆ†ã«æ´»ç”¨ã•ã‚Œã¦ã„ãªãã¦ã‚‚ã£ãŸã„ãªã„ ActiveRecord::Relation ã®ãƒ¡ã‚½ãƒƒãƒ‰ TOP 10 - æ‰é¢¨å‘‚2.0 - A Lifelog -
2013å¹´12æœˆ2æ—¥æ›´æ–°: å‚ç…§ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã®ã§ Rails 4 ã®æƒ…å ±ã‚’è¨³æ³¨ã¨ã—ã¦è¿½è¨˜ã—ã¾ã—ãŸã€‚ã¾ãŸã€Rails 4 ã«é–¢ã™ã‚‹æƒ…å ±ã¯ã€ WEB+DB PRESS Vol.73 ãŒéžå¸¸ã«å‚è€ƒã«ãªã‚‹ã®ã§ã€ä¸€èªã‚’ãŠã™ã™ã‚ã—ã¾ã™ã€‚ ã“ã®æ–‡ç« ã¯ Mitch Crowe æ°ã®ãƒ–ãƒã‚°ã‚ˆã‚Š 2012å¹´4æœˆ14æ—¥ã®è¨˜äº‹ã‚’ç¿»è¨³ã—ãŸã‚‚ã®ã§ã™ã€‚ The 10 Most Underused ActiveRecord::Relation Methods http://blog.mitchcrowe.com/blog/2012/04/14/10-most-underused-activerecord-relation-methods/ æ˜¨æ—¥ã¯ ActiveRecord::Relation ã®ã‚³ãƒ¼ãƒ‰ã«è†ã¾ã§æµ¸ã‹ã£ã¦ã€ä½¿ã‚ã‚Œã¦ã„ã‚‹ã®ã‚’ã“ã‚Œã¾ã§å…¨ç„¶è¦‹ãŸã“ã¨ãŒãªã„é¢ç™½ã„ãƒŠã‚²ãƒƒãƒˆã‚’æ€ã„å‡ºã•ã›ã¦ãã‚ŒãŸã€‚ã“ã®è¨˜äº‹ã§ã€ååˆ†ã«æ´»ç”¨
otakumesi 2016/09/20
ActiveRecord

ruby

rails

db

relation

é–‹ç™º
ãƒªãƒ³ã‚¯
åˆå¿ƒè€…ã®ãŸã‚ã®SQLã‚¬ã‚¤ãƒ‰???? : SQLã‚’ç›´æ„Ÿçš„ã«ç†è§£ã—ã‚ˆã† | POSTD
SELECT * WHERE a=b FROM c ï¼Ÿã€€ãã‚Œã¨ã‚‚ SELECT WHERE a=b FROM c ON * ï¼Ÿ ã‚‚ã—ã‚ãªãŸãŒç§ã®ã‚ˆã†ãªãƒ—ãƒã‚°ãƒ©ãƒžã ã£ãŸã‚‰ã€SQLã¯ã€åˆã‚ã¯å„ªã—ãè¦‹ãˆã‚‹è¨€èªžã®1 ã¤ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ï¼ˆãŸã å˜ã«æ™®é€šã®è‹±èªžé€šã‚Šèªã‚ã°ã„ã„ã§ã™ã‹ã‚‰ï¼‰ã€‚ã§ã™ãŒã€ä½•ã‹ã—ã‚‰ã®ç†ç”±ã§ã€ãªã‚“ã¦ã“ã¨ã®ãªã„ã‚¯ã‚¨ãƒªã«ã‚‚ã„ã¡ã„ã¡æ£ã—ã„ã‚·ãƒ³ã‚¿ãƒƒã‚¯ã‚¹ã‚’ã‚°ã‚°ã‚‰ãªã‘ã‚Œã°ã„ã‘ãªã„ã§ã—ã‚‡ã†ã€‚ ã„ãšã‚ŒJOINã«AGGREGTATIONã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ãŸã©ã‚Šç€ãã§ã—ã‚‡ã†ãŒã€èªã‚“ã ã¨ã—ã¦ã‚‚ã•ã£ã±ã‚Šã§ã—ã‚‡ã†ã€‚ä¾‹ãˆã°æ¬¡ã®ã‚ˆã†ãªæ„Ÿã˜ã§ã™ã€‚ SELECT members.firstname || ' ' || members.lastname AS "Full Name" FROM borrowings JOIN members ON members.memberid=borrowings.memberid JOIN
otakumesi 2016/08/18
SQL

DB

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
DBè«–ç†è¨è¨ˆã®ãƒŽã‚¦ãƒã‚¦ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? DBè¨è¨ˆã®æ¦‚è¦ã‚’ç°¡å˜ã«ãŠã•ã‚‰ã„ã—ãŸå¾Œã€è«–ç†è¨è¨ˆã«ã¤ã„ã¦ä¸»ã«ã¾ã¨ã‚ã¦ã„ãã¾ã™ã€‚ DBè¨è¨ˆã®å…¨ä½“æ‰‹é †ã®ãŠã•ã‚‰ã„ DBè¨è¨ˆã¯ã€å¤§ããè«–ç†è¨è¨ˆã¨ç‰©ç†è¨è¨ˆã«åˆ†ã‘ã‚‰ã‚Œã¾ã™ã€‚ è«–ç†è¨è¨ˆ æ¦‚å¿µã‚¹ã‚ãƒ¼ãƒžã‚’å®šç¾©ã—ã¾ã™ã€‚ ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®æŠ½å‡º ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®å®šç¾© æ£è¦åŒ– ERå›³ã®ä½œæˆ ç‰©ç†è¨è¨ˆ è«–ç†è¨è¨ˆã®çµæžœã‚’å—ã‘ã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹ãŸã‚ã®ç‰©ç†çš„ãªé ˜åŸŸã‚„æ ¼ç´æ–¹æ³•ã‚’æ±ºã‚ã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾© ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å®šç¾© ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã®ã‚µã‚¤ã‚¸ãƒ³ã‚° ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®å†—é•·æ§‹æˆæ±ºå®š ãƒ•ã‚¡ã‚¤ãƒ«ã®ç‰©ç†é…ç½®æ±ºå®š ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ§‹æˆè¦ç´ ã®ãŠã•ã‚‰ã„ è¡Œã¨åˆ— è¡Œ(ãƒ¬ã‚³ãƒ¼ãƒ‰)ï¼šæ¨ªã®ãƒ‡ãƒ¼ã‚¿ã®çµ„ åˆ—(ã‚«ãƒ©ãƒ
otakumesi 2016/08/02
DB

è¨è¨ˆ

SQL
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
otakumesi 2016/05/05
SQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql

DB
ãƒªãƒ³ã‚¯
ãƒ¤ãƒ•ãƒ¼ç¤¾å†…ã§ã‚„ã£ã¦ã‚‹MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚»ãƒŸãƒŠãƒ¼å¤§å…¬é–‹
3. Yahoo! JAPANã®RDBç’°å¢ƒ â€¢ 11g RAC Enterprise Edition â€¢ ç´„200DB â€¢ ã‚µãƒ¼ãƒ 200å°, Exadata ã‚‚ã‚ã‚‹ã‚ˆ â€¢ MySQL 5.1 (RR,Mixed) Percona 5.5 (RR,Mixed) Percona 5.6 (RC,RBR,GTID) â€¢ ç´„500DB â€¢ ã‚µãƒ¼ãƒ 300å° Oracle Database MySQL Percona
otakumesi 2016/02/23
MySQL

SQL

db

ã‚µãƒ¼ãƒ
ãƒªãƒ³ã‚¯
MySQLã§INSERTã®ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã«åµŒã‚‹äººã‚’1äººã§ã‚‚æ¸›ã‚‰ã™ãŸã‚ã« - ichirin2501's diary
ã“ã®è¨˜äº‹ã¯ã¯ã¦ãªãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼2015ã®12æœˆ24æ—¥ã®è¨˜äº‹ã§ã™ã€‚ æ˜¨æ—¥ã¯ id:stefafafan ã•ã‚“ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨è‹±èªžã§ã—ãŸã€‚ ã“ã‚“ã«ã¡ã¯ã€ã“ã‚“ã°ã‚“ã¯ã€‚ ã‚¯ãƒªã‚¹ãƒžã‚¹ãƒ»ã‚¤ãƒ´ã§ã™ãã€çš†ã•ã‚“ã¯ã©ã®ã‚ˆã†ãªä¸€æ—¥ã‚’éŽã”ã•ã‚Œã‚‹(ãŸ)ã®ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯ä¸€äººã§ã™ã€‚ æ”¹ã‚ã¾ã—ã¦ã€å…ˆæ—¥åˆã‚ã¦ã®åˆã‚³ãƒ³ã‚’çµŒé¨“/å¤±æ•—ã—ã¦äºŒåº¦ã¨è¡Œã‹ãªã„ã¨èª“ã£ãŸ ã¯ã¦ãªã® id:ichirin2501 ã§ã™ã€‚ä»Šå›žã¯å°ãƒã‚¿ã¨ã—ã¦MySQL(InnoDB)ã®BULK INSERTã«ãŠã‘ã‚‹ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã®è©±ã‚’ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ãŸã ã€å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ãŒçµ¡ã‚€ã¨è¤‡é›‘ã«ãªã‚‹ã®ã§ä»Šå›žã¯è§¦ã‚Œã¾ã›ã‚“ã€‚ãã‚Œã«ã¤ã„ã¦ã¯ã“ã¡ã‚‰ã‚’å‚ç…§ãã ã•ã„ã€‚ ã‚ã€ã‚¿ã‚¤ãƒˆãƒ«ã¯ã‚ªãƒžãƒ¼ã‚¸ãƒ¥ã§ã™*1ã€‚ Topic æ¤œè¨¼ç’°å¢ƒ INSERTã®ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ é¿ã‘ã‚‰ã‚Œãªã„ã‚±ãƒ¼ã‚¹ ã‚‚ã—ãã¯ãƒãƒƒã‚¯ã™ã‚‹ ãƒªãƒˆãƒ©ã‚¤å‡¦ç†ã«æ³¨æ„ åˆæœŸãƒ‡ãƒ¼ã‚¿ Duplicateã®å ´åˆ Deadlockã®
otakumesi 2015/12/27
MySQL

DB

ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯
ãƒªãƒ³ã‚¯
è«–ç†å‰Šé™¤ãŒäº‘ã€…ã«ã¤ã„ã¦ - mike-neckã®ãƒ–ãƒã‚°
ä»Šæ—¥æœã‚¤ãƒã§è¦‹ãŸã‚¨ãƒ³ãƒˆãƒªãƒ¼ãŒã“ã‚Œã§ã—ãŸã€‚ qiita.com è«–ç†å‰Šé™¤ã®å¼Šå®³ã¯è‰²ã€…ãªã¨ã“ã‚ã§è¨€ã‚ã‚Œã¦ã„ã‚‹ã‘ã©ã€åƒ•ã®è¶³ã‚Šãªã„é ã§ç†è§£ã—ã¦ã„ã‚‹æ‰€ã«ã‚ˆã‚‹ã¨ã€äºŒã¤ã®å€¤ã—ã‹æŒãŸãªã„å‰Šé™¤ãƒ•ãƒ©ã‚°çš„ãªã‚‚ã®ã¯ã‚«ãƒ¼ãƒ‡ã‚£ãƒŠãƒªãƒ†ã‚£ãŒäº‘ã€…ã§æ¤œç´¢æ¡ä»¶ã«ã¤ã‘ã¦ã‚‚æ€§èƒ½ä¸Šçš„ã«ã‚‚ã‚ˆããªã„ã—ã€æ„å‘³ãŒãªã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ è«–ç†å‰Šé™¤ã‚’å®Œå…¨ã«æ‚ªã ã¨ã¯è¨€ã„ã¾ã›ã‚“ãŒã€è«–ç†å‰Šé™¤ã‚’æ¥µåŠ›æŽ’ã—ãŸã„äººãŸã¡ã¯ã€åŸºæœ¬çš„ã«ãƒ‡ãƒ¼ã‚¿ãã®ã‚‚ã®ã‚’å‰Šé™¤ã™ã‚‹ã€ã‚‚ã—ãã¯è«–ç†å‰Šé™¤ã¨ã„ã†ã®ã¯ã¾ã è¦ä»¶çš„ã«æœªç¢ºå®šãªè¦ç´ ãŒéš ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‚’ç¤ºã™ãƒ•ãƒ©ã‚°ã§ã‚ã‚‹ã¨è€ƒãˆã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ åƒ•ãŒITã®æ¥ç•Œã§ã‚ãƒ£ãƒªã‚¢ã‚’ã‚¹ã‚¿ãƒ¼ãƒˆã—ã¦ã‹ã‚‰2å¹´ç›®ãã‚‰ã„ã«é…ç½®ã•ã‚ŒãŸãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã¯Tå—åž‹ERæ‰‹æ³•ã¨ã„ã†ã®ã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’ã—ã¦ã„ã¦ã€ãã“ã§ã‹ãªã‚Šé›ãˆã‚‰ã‚ŒãŸã‚ã‘ã§ã™ãŒã€ãã®æ™‚ã«ã¯ã ã„ãŸã„ã“ã®ã‚ˆã†ãªåŽŸå‰‡ã‚’å©ãã“ã¾ã‚Œã¾ã—ãŸã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã«çŠ¶æ…‹ã‚’æŒãŸã›ãªã„ ç©¶æ¥µã«ã¯æ©Ÿæ¢°ãŒèªè˜ã™ã‚‹ã‚ãƒ¼ã¨ã€äººé–“ã«ã¨ã£ã¦æ„
otakumesi 2015/12/27
ã‚ã¨ã§èªã‚€

è«–ç†å‰Šé™¤

DB
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä»•çµ„ã¿ (1/3) | POSTD
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒè©±é¡Œã«æŒ™ãŒã‚‹ã¨ãã€ç§ã¯ä½•ã‹ãŒè¶³ã‚Šãªã„ã¨æ€ã‚ãšã«ã¯ã„ã‚‰ã‚Œã¾ã›ã‚“ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚ã‚‰ã‚†ã‚‹ã¨ã“ã‚ã§ä½¿ã‚ã‚Œã¦ãŠã‚Šã€ãã®ç¨®é¡žã‚‚ã€å°è¦æ¨¡ã§ä¾¿åˆ©ãªSQLiteã‹ã‚‰ãƒ‘ãƒ¯ãƒ•ãƒ«ãªTeradataã¾ã§æ§˜ã€…ã§ã™ã€‚ã—ã‹ã—ã€ãã‚ŒãŒã©ã†ã„ã†ä»•çµ„ã¿ã§æ©Ÿèƒ½ã—ã¦ã„ã‚‹ã‹ã‚’èª¬æ˜Žã—ãŸã‚‚ã®ã¨ãªã‚‹ã¨ã€ãã®æ•°ã¯ã”ãã‚ãšã‹ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ä¾‹ãˆã°ã€Œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ä»•çµ„ã¿ã€ãªã©ã§æ¤œç´¢ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ãƒ’ãƒƒãƒˆæ•°ã®å°‘ãªã•ã‚’å®Ÿæ„Ÿã§ãã‚‹ã¨æ€ã„ã¾ã™ã€‚ã•ã‚‰ã«ãã‚Œã‚‰ã®è¨˜äº‹ã¯çŸã„ã‚‚ã®ãŒã»ã¨ã‚“ã©ã§ã™ã€‚é€†ã«ã€è¿‘å¹´æµè¡Œã—ã¦ã„ã‚‹æŠ€è¡“ï¼ˆãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã€NoSQLã€JavaScriptãªã©ï¼‰ã‚’æ¤œç´¢ã—ãŸå ´åˆã€ãã‚Œã‚‰ã®æ©Ÿèƒ½ã‚’è©³ã—ãèª¬æ˜Žã—ãŸè¨˜äº‹ã¯ãŸãã•ã‚“è¦‹ã¤ã‹ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ã‚‚ã¯ã‚„å¤§å¦ã®æŽˆæ¥ã‚„ç ”ç©¶è«–æ–‡ã€å°‚é–€æ›¸ãªã©ã§ã—ã‹æ‰±ã‚ã‚Œãªã„ã‚ˆã†ãªå¤ãã¦é€€å±ˆãªæŠ€è¡“ãªã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ç§ã¯é–‹ç™ºè€…ã¨ã—ã¦ã€ç†è§£ã—ã¦ã„ãªã„ã‚‚ã®ã‚’
otakumesi 2015/09/18
ã‚ã¨ã§èªã‚€

DB
ãƒªãƒ³ã‚¯
MySQL(InnoDB)ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã®å‚™å¿˜éŒ² - What is it, naokirin?
æœ€è¿‘ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦èª¿ã¹ã‚‹ã“ã¨ãŒã‚ã£ãŸã®ã§ã€å¿˜ã‚Œãªã„ã†ã¡ã«å‡ºæ¥ã‚‹é™ã‚Šæƒ…å ±ã‚’æ®‹ã—ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ ã¡ãªã¿ã«MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯5.5ãŠã‚ˆã³5.6ã®æƒ…å ±ã‚’å…ƒã«ã—ã¦ã„ã¾ã™ã€‚ InnoDBã«ãŠã‘ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ§‹é€ B+Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ InnoDBã§ã¯ãƒ‡ãƒ¼ã‚¿ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã¨å‘¼ã°ã‚Œã‚‹é ˜åŸŸã«ã‚ã‚Šã¾ã™ã€‚ã•ã‚‰ã«ã“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã¯ãƒšãƒ¼ã‚¸ï¼ˆãƒ–ãƒãƒƒã‚¯ï¼‰å˜ä½ã§ç®¡ç†ã•ã‚Œã¦ãŠã‚Šã€ã“ã®ãƒšãƒ¼ã‚¸å˜ä½ã§B+TreeãŒæ§‹æˆã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ã¤ã¾ã‚ŠI/Oã®å˜ä½ã¯ãƒšãƒ¼ã‚¸å˜ä½ã«ãªã£ã¦ã„ã‚‹ã€ã¨ã„ã†ã“ã¨ã§ã™ã€‚ ã‚¯ãƒ©ã‚¹ã‚¿ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã‚»ã‚«ãƒ³ãƒ€ãƒªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ InnoDBã§ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¤œç´¢ã‚„æ“ä½œã«ä½¿ã‚ã‚Œã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã—ã¦2ç¨®é¡žã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒå˜åœ¨ã—ã¾ã™ã€‚ãã‚Œã¯ã‚¯ãƒ©ã‚¹ã‚¿ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆClustered indexï¼‰ã¨ã‚»ã‚«ãƒ³ãƒ€ãƒªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆSecondary Indexï¼‰ã§ã™ã€‚ ã‚¯ãƒ©ã‚¹ã‚¿ã‚¤ãƒ³
otakumesi 2015/09/10
MySQL

db
ãƒªãƒ³ã‚¯
1