[B! database][performance] uchiuchiyamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

uchiuchiyama id:uchiuchiyama

databaseã¨performanceã«é–¢ã™ã‚‹uchiuchiyamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (22)

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

Mongoã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ”¹å–„ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã¿ãŸ - Qiita
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯é—‡é›²ã«è²¼ã‚Œã°ã„ã„ã¨ã„ã†ç‰©ã§ã¯ãªãã€æ—¢å˜ã®ã‚·ã‚¹ãƒ†ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã™ã‚‹ã®ã§ã‚ã‚Œã°èª¿æŸ»ã‹ã‚‰è¡Œã†ã®ãŒå®šçŸ³ã¨ã„ã†ã“ã¨ã§ã€ã¾ãšã¯ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã®èª¿æŸ»æ–¹æ³•ã‹ã‚‰ç´¹ä»‹ã—ã¾ã™ã€‚ æ’²æ»…ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒª ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒª # ã¾ãšã¯MongoShellã«ãƒã‚°ã‚¤ãƒ³ã—ã¾ã™ $ mongo # DBã‚’é¸æŠžã—ã¾ã™ use sample # db.setProfilingLevel(level, slowms) # level:1 ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã®ã¿å‡ºåŠ› # level:2 ã™ã¹ã¦ # slowms ä»¥ä¸‹ã®ä¾‹ã ã¨20msä»¥ä¸Šã‹ã‹ã£ã¦ã„ã‚‹ã‚¯ã‚¨ãƒªã‚’å‡ºåŠ›ã™ã‚‹ db.setProfilingLevel(1,20) # ã„ãã¤ã‹ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ãŸã‚ã¨ã«å®Ÿè¡Œã—ã¦ã¿ã¾ã™ # forEach(printjson) ã¯è¦‹ã‚„ã™ãæ•´å½¢ã™ã‚‹ãƒ¡ã‚½ãƒƒãƒ‰ db.system.profile.find().forEach(printjson) >
uchiuchiyama 2016/06/14
mongodb

rails

database

tutorial

performance
ãƒªãƒ³ã‚¯
RDB - å®Ÿä¾‹ã§å¦ã¶ã€JOIN (NLJ) ãŒé…ããªã‚‹ç†å±ˆã¨å¯¾å‡¦æ³• - Qiita
"Nested Loop Joinã—ã‹å–ã‚Šä¸Šã’ã¦ç„¡ã„ã®ã«ã‚¿ã‚¤ãƒˆãƒ«ãŒå¤§ãã™ãŽãªã„ã‹" ã¨æŒ‡æ‘˜ã‚’é ‚ã„ãŸã®ã§ã€ã‚¿ã‚¤ãƒˆãƒ«ã‚’ä¿®æ£ã—ã¾ã—ãŸã€‚Merge Joinã¨Hash Joinã®ã“ã¨ã¯ã¾ãŸä»Šåº¦æ›¸ã“ã†ã¨æ€ã„ã¾ã™ã€‚ ã€ŒJOINã¯é…ã„ã€ã¨ã‚ˆãè¨€ã‚ã‚Œã¾ã™ã€‚ç‰¹ã«RDBã‚’ä½¿ã„å§‹ã‚ã¦é–“ãŒãªã„å†…ã«ãã†ã„ã†è¨€èª¬ã«è§¦ã‚ŒãŸçµæžœã€ŒJOIN=æ‚ªã€ã¨ã„ã†èªè˜ã§å›ºå®šåŒ–ã•ã‚Œã¦ã—ã¾ã£ã¦ã„ã‚‹äººã‚‚å¤šã„ã‚ˆã†ã«æ„Ÿã˜ã¦ã„ã¾ã™ã€‚ ãŸã—ã‹ã«ã€JOINã‚’å«ã‚€ã‚ˆã†ãªSELECTæ–‡ã¯ã€å«ã¾ãªã„ã‚‚ã®ã«æ¯”ã¹ã¦é‡ãŸããªã‚‹å‚¾å‘ãŒã‚ã‚‹ã“ã¨ã¯äº‹å®Ÿã§ã™ã€‚ã¾ãŸã€æœ¬è³ªçš„ã«å•ã„åˆã‚ã›ãŸã„å†…å®¹ãŒè¤‡é›‘ã§ã€å¯¾å‡¦ã™ã‚‹ã“ã¨ãŒé›£ã—ã„ã‚‚ã®ã‚‚å˜åœ¨ã—ã¾ã™ã€‚ã—ã‹ã—ã€RDBã®ä¸ã§ä¸€ä½“ã©ã†ã„ã†ã“ã¨ãŒèµ·ãã¦ã„ã‚‹ã®ã‹ã‚’çŸ¥ã‚Šã€ãã‚Œã«åŸºã„ã¦å¯¾å‡¦ã™ã‚Œã°é«˜é€ŸåŒ–ã§ãã‚‹ã“ã¨ã‚‚å°‘ãªããªã„ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ æœ¬ç¨¿ã§ã¯ã€JOINã®å†…éƒ¨å‹•ä½œã‚’è§£èª¬ã—ãŸä¸Šã§ã€Webã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½œã£ã¦ã„ã‚‹ã¨ã‚ˆãå‡ºã¦ãã‚‹JOIN SQLã‚’ä¾‹é¡Œã«
uchiuchiyama 2015/07/13
sql

performance

database

mysql

development
ãƒªãƒ³ã‚¯
Railsã§å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã¾ã¨ã‚ã¦æ›´æ–°ã™ã‚‹ãªã‚‰find_eachä½¿ã†ã‚ˆã - (ï¾Ÿâˆ€ï¾Ÿ)oå½¡ sasata299's blog
2013å¹´03æœˆ22æ—¥16:17 Ruby Railsã§å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã¾ã¨ã‚ã¦æ›´æ–°ã™ã‚‹ãªã‚‰find_eachä½¿ã†ã‚ˆã ã¨ã„ã†ã“ã¨ã§ãƒ¡ãƒ¢ç¨‹åº¦ã§ã™ãŒæ›¸ã„ã¨ãã¾ã™ã€‚ Railsã«ã¯ find_each ã¨ã„ã†ãƒ¡ã‚½ãƒƒãƒ‰ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚é€šå¸¸ã® each ãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€å…¨ãƒ‡ãƒ¼ã‚¿ã‚’ã¾ã¨ã‚ã¦ãƒ¡ãƒ¢ãƒªã«å±•é–‹ã—ã¦ã‹ã‚‰å‡¦ç†ã‚’é–‹å§‹ã—ã¾ã™ã€‚ãã®ãŸã‚ã€ååˆ†ã«ãƒ¡ãƒ¢ãƒªã«è¼‰ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã§ã‚ã‚Œã°ä½•ã‚‚å•é¡Œãªã„ã§ã™ãŒã€æ•°ç™¾ä¸‡ã€æ•°åƒä¸‡ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿é‡ã«ãªã£ã¦ãã‚‹ã¨ãƒ¡ãƒ¢ãƒªã«è¼‰ã‚Šãã‚‰ãšã«æº¢ã‚Œã¦ã—ã¾ã£ã¦å¤§å¤‰ãªã“ã¨ã«ãªã‚Šã¾ã™ã€‚ find: å…¨ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¡ãƒ¢ãƒªã«å±•é–‹ã—ã¦ã‹ã‚‰å‡¦ç† find_each: å°‘ã—ãšã¤ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¡ãƒ¢ãƒªã«å±•é–‹ã—ã¤ã¤å‡¦ç† ãã†ã„ã†ã¨ãã«ã¯ find_each ãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ã„ã¾ã—ã‚‡ã†ã€‚ã“ã‚Œã¯å°‘ã—ãšã¤ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¡ãƒ¢ãƒªã«å±•é–‹ã—ã¦å‡¦ç†ã‚’è¡Œã„ã¾ã™ï¼ˆãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯1,000ä»¶ãšã¤ï¼‰ã€‚å…¨éƒ¨ã¾ã¨ã‚ã¦ã§ã¯ãªãã¡ã‚‡ã£ã¨ãšã¤ãƒ¡ãƒ¢ãƒªã«å±•é–‹ã—ã¦ã
uchiuchiyama 2014/12/07
rails

performance

database

development
ãƒªãƒ³ã‚¯
rails4 ã§ãƒãƒ«ã‚¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆ : sonots:blog
uchiuchiyama 2014/12/07
rails

database

performance
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
uchiuchiyama 2012/09/12
database

postgresql

mysql

performance
ãƒªãƒ³ã‚¯
MongoDBã®ã‚¢ãƒ¬ã‚’ã‚¢ãƒ¬ã™ã‚‹
1. Mongo DBã®ã‚¢ãƒ¬ã‚’ã‚¢ãƒ¬ã™ã‚‹ æ ªå¼ä¼šç¤¾ã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆ ã‚¢ãƒ¡ãƒ¼ãƒäº‹æ¥æœ¬éƒ¨ãƒ”ã‚°ãƒ‡ã‚£ãƒ´ã‚£ã‚¸ãƒ§ãƒ³ æ¡‘é‡Žâ€ƒç« å¼˜ 12å¹´7æœˆ8æ—¥æ—¥æ›œæ—¥ 2. ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ ï® Mongo DBCasual ï® ã‚‚ã‚“ã”ãŸã‚“ã«ã¤ã„ã¦ãŠã•ã‚‰ã„ ï® é‹ç”¨æ™‚ã«ã‚ã£ãŸã“ã¨é›† ï® éšœå®³æ™‚ä½•è¦‹ã‚‹ï¼Ÿ ï® ã¾ã¨ã‚ 12å¹´7æœˆ8æ—¥æ—¥æ›œæ—¥ 3. è‡ªå·±ç´¹ä»‹ ï® æ¡‘é‡Žç« å¼˜ ï¬ ã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆ ï¬ Ameba ã‚’é‹å–¶ã—ã¦ã„ã¾ã™ã€‚ ï¬ ãƒ”ã‚°ãƒ©ã‚¤ãƒ•ã®é‹ç”¨ï¼æ§‹ç¯‰ã‚’æ‹…å½“ ï¬ Twitter ï¬ @kuwa_tw ï¬ Blog ï¬ http://d.hatena.ne.jp/akuwano/ ï¬ è‘—æ›¸ï¼æ´»å‹• ï¬ ã€ŒMySQLã«ã‚ˆã‚‹ã‚¿ãƒ•ãªã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ 12å¹´7æœˆ8æ—¥æ—¥æ›œæ—¥
uchiuchiyama 2012/07/08
mongodb

development

database

performance

presentation
ãƒªãƒ³ã‚¯
NoSQLã¨ã—ã¦MySQLã‚’ä½¿ã†DeNAãŒã€memcachedã‚ˆã‚Šã‚‚é«˜é€Ÿãª75ä¸‡ã‚¯ã‚¨ãƒªï¼ç§’ã‚’å®Ÿç¾
ãƒ¢ãƒã‚²ãƒ¼ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã¯ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«NoSQLã‚’ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ãªãœã‹ï¼Ÿ ãã‚Œã¯MySQL/InnoDB 5.1ã®ç’°å¢ƒã§ç§’é–“75ä¸‡ã‚¯ã‚¨ãƒªã¨ã„ã†ã€å¤šãã®NoSQLã§ã‚‚å®Ÿç¾ã§ããªã„ã‚ˆã†ãªé«˜æ€§èƒ½ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã‹ã‚‰ã€‚DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ã¯ã€è‡ªèº«ã®ãƒ–ãƒã‚°ã«ã“ã‚“ãªå†…å®¹ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒUsing MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity serverã€ï¼ˆè‹±èªžï¼‰ã‚’ãƒœã‚¹ãƒˆã—ã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server æ¾ä¿¡æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€å¤§è¦æ¨¡ãªãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ä¼æ¥ã®å¤šãã¯åˆ†æ•£ç’°å¢ƒã§
uchiuchiyama 2010/10/27
mysql

memcached

dena

database

performance

cache
ãƒªãƒ³ã‚¯
Ywcafe.net
Ywcafe.net This Page Is Under Construction - Coming Soon! Why am I seeing this 'Under Construction' page? Related Searches: Free Credit Report music videos Migraine Pain Relief Best Mortgage Rates Credit Card Application Trademark Free Notice Review our Privacy Policy Service Agreement Legal Notice Privacy Policy
uchiuchiyama 2009/08/04
postgresql

performance

database
ãƒªãƒ³ã‚¯
Q4M - a Message Queue for MySQL
Q4M (Queue for MySQL) is a message queue licensed under GPL that works as a pluggable storage engine of MySQL, designed to be robust, fast, flexible. It is already in production quality, and is used by several web services (see Users of Q4M). To start using Q4M, download either a binary or source distribution from the install page, and follow the installation instructions. A small tutorial is also
uchiuchiyama 2008/02/06
database

mysql

performance

q4m
ãƒªãƒ³ã‚¯
mixiã®ç”Ÿã¿ã®è¦ªâ€œãƒã‚¿ãƒ©æ°â€ãŒèªžã‚‹MySQLã®æ„å¤–ãªåˆ©ç”¨æ³• ï¼ TechTargetã‚¸ãƒ£ãƒ‘ãƒ³
æ—¥è¨˜ã ã‘ã§4å„„ä»¶ã®ãƒ‡ãƒ¼ã‚¿ ãƒŸã‚¯ã‚·ã‚£ãŒé‹å–¶ã™ã‚‹SNSã€Œmixiã€ã¯ã€2007å¹´7æœˆæœ«æ®µéšŽã§ãƒ¦ãƒ¼ã‚¶ãƒ¼æ•°ãŒ1110ä¸‡äººã€‚äººãŒ12äººé›†ã¾ã‚Œã°ã€1äººã¯mixiãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã„ã†ã‚ã‘ã ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ–çŽ‡ï¼ˆãƒã‚°ã‚¤ãƒ³é–“éš”ãŒ3æ—¥ä»¥å†…ï¼‰ã¯ç´„62ï¼…ã¨é«˜ãã€2007å¹´4æœˆã‹ã‚‰6æœˆã®æœˆé–“å¹³å‡ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ã¯117.5å„„ã«é”ã—ãŸã€‚æ—¥è¨˜ã ã‘ã§ã‚‚4å„„ä»¶ä»¥ä¸Šã«ä¸Šã‚‹ãªã©ã€è“„ç©ã™ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã‚‚èŽ«å¤§ã€‚2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‹ã‚‰ã€ã‚ãšã‹3å¹´åŠã§ç¾åœ¨ã®å·¨å¤§ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã¸ã¨ç™ºå±•ã—ãŸã®ã ã€‚ ãƒŸã‚¯ã‚·ã‚£ã¯ã€ã€ŒLAMPï¼ˆOSã®Linuxã€Webã‚µãƒ¼ãƒã®Apacheã€DBMSã®MySQLã€é–‹ç™ºè¨€èªžã®Perlã€PHPã€Pythonï¼‰ã€ã¨å‘¼ã°ã‚Œã‚‹Webã‚·ã‚¹ãƒ†ãƒ å‘ã‘ã®æ¨™æº–çš„ãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆä»¥ä¸‹ã€OSSï¼‰ã§ã‚·ã‚¹ãƒ†ãƒ ã‚’è‡ªç¤¾é–‹ç™ºã—ã€å®‰ä¾¡ãªPCã‚µãƒ¼ãƒã‚’1000å°ä»¥ä¸Šé€£ãã‚‹è¶…åˆ†æ•£æ§‹æˆã§mixiã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã¦ã„ã‚‹ï¼ˆåºƒå‘Šé…ä¿¡ãªã©å‘¨è¾ºæ©Ÿèƒ½ã§ã¯
uchiuchiyama 2007/09/12
database

performance

mysql

perl

mixi

development
ãƒªãƒ³ã‚¯
Inside Tokyo Cabinet ãã®å£± - mixi engineer blog
ç´„åŠå¹´é–“ã®æ²ˆé»™ã‚’ç ´ã£ã¦OSSã®ä¸–ç•Œã«æˆ»ã£ã¦ãã¤ã¤ã‚ã‚‹mikioã§ã™ã€‚å…ˆæ—¥ã€Tokyo Cabinetï¼ˆä»¥ä¸‹ã€ŒTCã€ã¨å‘¼ã³ã¾ã™ï¼‰ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ä»Šå›žã‹ã‚‰æ•°å›žã«åˆ†ã‘ã¦ã€TCã®è¨è¨ˆã¨è‹¦åŠ´è©±ã«ã¤ã„ã¦é€£è¼‰ã—ã¦ã¿ã¾ã™ã€‚ DBMã¨ã¯ TCã¯ã€ã„ã‚ã‚†ã‚‹DBMã®ç³»èœã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã€å˜ç´”ãªãƒãƒƒã‚·ãƒ¥ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ•ã‚¡ã‚¤ãƒ«ä¸Šã§æ°¸ç¶šåŒ–ã™ã‚‹ã ã‘ã®æ©Ÿèƒ½ã‚’æä¾›ã—ã¾ã™ã€‚DBMã¯AT&Tã®å¤ä»£UNIXã®æ™‚ä»£ã‹ã‚‰å—ã‘ç¶™ãŒã‚Œã‚‹ä¼çµ±èŠ¸èƒ½ãªã®ã§ã™ãŒã€ç§ã¯ãã†ã„ã†æž¯ã‚ŒãŸæŠ€è¡“ãŒå¤§å¥½ããªã®ã§ã™ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒžã®çš†ã•ã‚“ã¯ã€Perlã‚„Rubyã§ã¯ãƒãƒƒã‚·ãƒ¥ï¼ˆé€£æƒ³é…åˆ—ï¼‰ã¨å‘¼ã°ã‚Œã€Javaã‚„C++ã§ã¯mapã¨å‘¼ã°ã‚Œã‚‹ã‚ˆã†ãªã€ä½•ã‚‰ã‹ã®ã‚ãƒ¼ã«é–¢é€£ã¥ã‘ã¦ãªã‚“ã‚‰ã‹ã®å€¤ã‚’è¨˜éŒ²ã™ã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã£ã¦å®Ÿã«ã‚ˆãä½¿ã„ã¾ã™ã‚ˆãã€‚ä¾‹ãˆã°mixiã§ã¯ã€ãƒ¦ãƒ¼ã‚¶ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã«é–¢é€£ã™ã‚‹æƒ…å ±ï¼ˆåå‰ã¨ã‹ãƒ‹ãƒƒã‚¯ãƒãƒ¼ãƒ ã¨ã‹ï¼‰ã¯ã€ãƒ¦ãƒ¼ã‚¶IDã‚’ã‚ãƒ¼ã«ã—ãŸãƒãƒƒ
uchiuchiyama 2007/08/30
algorithm

database

performance
ãƒªãƒ³ã‚¯
Page not found - ãƒ•ã‚¡ã‚¤ãƒ¤ãƒ¼ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆ
The page you are trying to reach does not exist, or has been moved. Please use the menus or the search box to find what you are looking for.
uchiuchiyama 2007/08/29
postgresql

database

performance

development
ãƒªãƒ³ã‚¯
HOMMEZå…¬å¼ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚·ãƒ§ãƒƒãƒ—
HOMMEZ(ã‚ªãƒ ã‚º)ã¯ç”·æ€§ã®å¿ƒã¨èº«ä½“ã®å¥åº·ã‚’æ”¯æ´ã—ã€ä¸€äººã§ã‚‚å¤šãã®äººãŒåä¾›ã‚’å¾—ã‚‹å¹¸ã›ã‚„ç”·æ€§ã¨ã—ã¦ã®å–œã³ã‚’äº«å—ã§ãã‚‹ç¤¾ä¼šã®å®Ÿç¾ã‚’ç›®æŒ‡ã—ã¦ã„ã¾ã™ã€‚ç”·æ€§ã®å¦Šæ´»ã€æ´»åŠ›ã«ã¾ã¤ã‚ã‚‹æƒ…å ±ã‚„å•†å“ã®åŠ›ã§æ€§ã‚„å¦Šæ´»ã«æ‚©ã‚€ç”·æ€§ãŒåŠ¹çŽ‡çš„ã«ç´å¾—æ„Ÿã‚’æŒã£ã¦æ´»å‹•ã§ãã‚‹æ©Ÿä¼šã‚’å‰µå‡ºã—ã¾ã™ã€‚
uchiuchiyama 2007/08/29
postgresql

performance

development

database
ãƒªãƒ³ã‚¯
ç”»åƒã‚‚DBã«æ ¼ç´ã—ã¦ç®¡ç†ã™ã‚‹ ï¼æ‰±ã„ãŒã‚ã‚“ã©ã†ãªLOB(ãƒ©ãƒ¼ã‚¸ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ)ã¯ä½¿ã‚ãªã„æ–¹æ³•ã‚‚å«ã‚
Ywcafe.net This Page Is Under Construction - Coming Soon! Why am I seeing this 'Under Construction' page? Related Searches: Health Insurance High Speed Internet Work from Home Healthy Weight Loss Best Penny Stocks Trademark Free Notice Review our Privacy Policy Service Agreement Legal Notice Privacy Policy
uchiuchiyama 2007/08/24
database

image

web

tips

apache

performance

development
ãƒªãƒ³ã‚¯
ãƒãƒƒã‚¯ãƒŠãƒ³ãƒãƒ¼ â€“ ãŠãvillage
ã“ã®URLã®ãƒšãƒ¼ã‚¸ã¯è¡¨ç¤ºã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã›ã‚“ã§ã—ãŸã€‚ IQã‚µãƒ¼ãƒãƒ¼
uchiuchiyama 2007/08/14
rails

database

mysql

tips

performance
ãƒªãƒ³ã‚¯
æ›´æ–°ãŒã‚ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã«ã¯InnoDBã‚’é¸ã¼ã†ã€‚MyISAMã‚’é¸æŠžã™ã‚‹ãªã‚‰ãã‚Œãªã‚Šã®ç†ç”±ãŒå¿…è¦ã€‚ãã‚Œã«InnoDBã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯ãã‚“ãªã«æ‚ªããªã„ã‚ˆã€‚ || ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°Blog: ã‚¤ãƒ³ã‚¿ãƒ¼ã‚ªãƒ•
AWSã‚¢ãƒ‰ãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”ç›¸è«‡ã«ä¹—ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„ææ¡ˆãŒã‚‚ã‚‰ãˆãªã„ ã‚¯ãƒ©ã‚¦ãƒ‰ã®å°Žå…¥ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ ç¤¾å†…ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„ã‚‹äººãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’è©³ã—ãçŸ¥ã‚ŠãŸã„
uchiuchiyama 2007/07/03
mysql

performance

database
ãƒªãƒ³ã‚¯
ã€ãƒ¬ãƒãƒ¼ãƒˆã€‘8.3ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯åŠ‡çš„ã«å‘ä¸Šã™ã‚‹ - ã‚³ã‚¢ãƒ¡ãƒ³ãƒãƒ¼ãŒèªžã‚‹PostgreSQLã®ä»Š (2) PostgreSQL 8.3ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒã™ã”ã„! - æ–°æ©Ÿèƒ½ã¯"HOT"! | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
PostgreSQLã®é–‹ç™ºã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ« æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®PostgreSQL 8.3ã¯ã™ã§ã«4æœˆã«ãƒ•ãƒªãƒ¼ã‚ºã•ã‚Œã¦ãŠã‚Šã€ã€Œã‚ã¨ã¯ç´°ã‹ãªãƒã‚°ã‚„ã€ã©ã®ãƒ‘ãƒƒãƒã‚’é©ç”¨ã™ã‚‹ã‹(ã‚ã‚‹ã„ã¯å¤–ã™ã‹)ã¨ã„ã£ãŸã“ã¨ã‚’æ±ºã‚ã‚‹ã ã‘ã€(Berkusæ°)ã¨ã„ã†ã€‚Berkusæ°ã®å‘¨å›²ã§ã¯ã€Œã‚‚ã†8.3ã®ä½œæ¥ã¯ã»ã¨ã‚“ã©çµ‚ã‚ã£ã¦ã„ã‚‹ã®ã§ã€ã¿ã‚“ãª8.4ã®è©±ã—ã‹ã—ãªã„ã‚“ã ã‚ˆ(ç¬‘)ã€ã¨ã„ã†çŠ¶æ…‹ã ã¨ã‹ã€‚ã»ã¼ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«é€šã‚Šã«8.3ã®é–‹ç™ºã‚’é€²ã‚ã¦ã“ã‚ŒãŸã“ã¨ã«ã¤ã„ã¦ã€Berkusæ°ã¯ã€Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®é–‹ç™ºã§ã‚ã£ã¦ã‚‚ã€ã§ãã‚‹ã ã‘å½“åˆã®ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«é€šã‚Šã«é€²è¡Œã§ãã‚‹ã‚ˆã†ã«åŠªåŠ›ã™ã¹ãã ã€‚8.3ã®é–‹ç™ºã‚’äºˆå®šé€šã‚Šé€²ã‚ã‚‰ã‚ŒãŸã“ã¨ã«ã¤ã„ã¦ã¯æº€è¶³ã—ã¦ã„ã‚‹ã€‚ãŸã ã—8.4ã¯è‹¥å¹²é…ã‚Œæ°—å‘³ã‹ã‚‚ã—ã‚Œãªã„ã€‚é€²æ—ã«é–¢ã—ã¦ã¯éšæ™‚å ±å‘Šã—ã¦ã„ããŸã„ã¨æ€ã†ã€ã¨èªžã‚Šã€ä»–ã®OSSã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã‚‚ã‚‚ã£ã¨é–‹ç™ºã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’æ°—ã«ã™ã¹ãã€ã¨ã—ãŸã€‚ æ°—ã«ãªã‚‹8.3ã®æ€§èƒ½ã ãŒã€Ber
uchiuchiyama 2007/06/18
postgresql

database

performance
ãƒªãƒ³ã‚¯
MySQL Island
MySQLã«é–¢ã™ã‚‹æƒ…å ±ã‚’è¼‰ã›ã¦ã„ãã¾ã™ã€‚ èµ·å‹•ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€€(2007/01/13) æ¼”ç®—åãƒ»é–¢æ•°ã€€(2007/01/11) SELECTæ–‡ã€€(2007/01/11) CREATE TABLEæ§‹æ–‡ã€€(2007/01/11) GROUP BYé–¢æ•°ã€€(2007/01/11) ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã€€(2007/01/11) ã‚µãƒ¼ãƒã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã€€(2007/01/11) ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ã†ã€€(2009/12/20) InnoDBã€€(2007/01/11) å„ç¨®Tipsã€€(2007/07/03)
uchiuchiyama 2007/01/18
database

mysql

tips

performance
ãƒªãƒ³ã‚¯
InnoDB vs MyISAM (vs Falcon) ã‚’èªã‚“ã§èˆˆå‘³æ·±ã„ã¨æ€ã£ãŸç‚¹ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
InnoDB vs MyISAM vs Falcon benchmarks - part 1 ã‚’èªã‚“ã ã€‚èˆˆå‘³æ·±ã‹ã£ãŸã€‚ ã ã‘ã ã¨ãƒŠãƒ³ãªã®ã§ã€æ€ã£ãŸã“ã¨ã‚’ãƒ¡ãƒ¢ã£ã¦ã¿ã‚‹ã€‚ ãŒã‚“ã°ã‚ŒFalcon ã¾ã ç”Ÿã¾ã‚ŒãŸã¦ãªã®ã§ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã®çµæžœã¯å‚è€ƒç¨‹åº¦ã«ã€‚ InnoDB vs MyISAM The second goal of benchmark was a popular myth that MyISAM is faster than InnoDB in reads, as InnoDB is transactional, supports Foreign Key and has an operational overhead. As you will see it is not always true. ã®é€šã‚Šã€ã©ã¡ã‹ã¨ã„ã†ã¨(Falconã‚ˆã‚Š)InnoDBã¨MyISAMã®æ€§èƒ½æ¯”è¼ƒã®æ–¹ãŒèˆˆå‘³æ·±ã„ç‚¹ãŒ
uchiuchiyama 2007/01/11
database

tips

mysql

performance
ãƒªãƒ³ã‚¯
MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã™ã‚‹84ã®TIPS:phpspoté–‹ç™ºæ—¥èªŒ
Top 84 MySQL Performance Tips -- Debian Admin MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries. MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã™ã‚‹84ã®TIPS. æ¬¡ã®ã‚ˆã†ãªæ„Ÿã˜ã®TIPSãŒ84ç´¹ä»‹ã•ã‚Œã¦ã‚‹ã¨ã„ã†ã“ã¨ã§ä¸€åº¦ã¯ç›®ã‚’é€šã—ã¦ãŠããŸã„ã§ã™ãã€‚ ä»¥ä¸‹ã€æµã—èªã¿ã§ãƒ¡ãƒ¢ ã‚¯ã‚¨ãƒªã®ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ã«ã¯Explainæ–‡ã‚’ä½¿ãŠã† ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã‚’æ´»ç”¨ã—ã‚ˆã† GROUP BY ã‚’ä½¿ã†ã¨ãã¯ DISTINCTã‚’ä½¿ã‚ãªã„ LIMIT m,n ã¯ãã‚“ãªã«é€Ÿããªã„ã‹ã‚‚ inno
uchiuchiyama 2006/12/30
introduction

mysql

tips

database

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