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

somat id:somat

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

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

DBIx::ProfileManager ã§ SQL Profiling | BLOG - DeNA Engineering
é¢¨é‚ªã‚’å¼•ãã£ã±ãªã—ã§å…¨ç„¶æ²»ã‚‰ãªã„å±±å£ã§ã™ã€‚æã‚‰ããƒãƒƒãƒˆä¸Šã§ã¯ zigorou ã¨è¨€ã†ãƒãƒ³ãƒ‰ãƒ«ã§ã”å˜çŸ¥ã®æ–¹ã‚‚ã„ã‚‰ã£ã—ã‚ƒã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã¾ãšã¯æŠ€è¡“ç³»ã®ãƒã‚¿ã®ç¬¬1å¼¾ã§ã™ã€‚ ä»Šå›žã¯å®Ÿéš›ã«ãƒ¢ãƒã‚²ãƒ¼ã‚ªãƒ¼ãƒ—ãƒ³ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ç”¨ã„ã¦ã„ã‚‹ SQL Profiling ã®æ–¹æ³•ã‚’ã”ç´¹ä»‹è‡´ã—ã¾ã™ã€‚ DBI::Profile ã«ã¤ã„ã¦ ãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³ ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ MySQL ã‚’ç”¨ã„ã¦ãŠã‚Šã€ã‚µãƒ¼ãƒãƒ¼ã‚µã‚¤ãƒ‰ãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰ç®¡ç†ãƒ„ãƒ¼ãƒ«ã¾ã§ã®ã»ã¨ã‚“ã©ãŒ Perl ã§æ›¸ã‹ã‚Œã¦ãŠã‚Šã€ å½“ç„¶ãªãŒã‚‰ DBI ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¾ãŸã¯ãã‚Œã‚’åˆ©ç”¨ã—ãŸãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ DB ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã€ã‚ªãƒ¼ãƒ—ãƒ³ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ãƒãƒ¼ãƒ ã§ä½œã£ãŸ OpenSocial RESTful API ã§ã™ãŒã€ãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³å†…ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¤§é‡ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ç‚ºã«æ—¥ã€…ã©ã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªãŒå®Ÿè¡Œã•ã‚Œã€ã©ã‚Œãã‚‰ã„ã®å®Ÿè¡Œæ™‚é–“ãŒæŽ›ã‹ã£ã¦ã„ã‚‹ã‹ã¯å¸¸ã«æ°—ã«ãªã‚‹
somat 2013/10/28
SQL

Perl

CPAN

database

performance

profiling
ãƒªãƒ³ã‚¯
MongoDB Query Performance over Ranges & Indexes that Help | MongoLab - MongoDB Hosting
Greetings adventurers! If youâ€™ve been travelling through Mongo DB indexing terr itory for any amount of time, you may have heard or derived the following maxim:Â If your queries contain a sort/orderby clause, add the sorted field to the end of the index servicing the query. In many cases when querying for documents containing equivalent values, the above mantra is very helpful (by equivalency, I mean
somat 2013/01/05
mongodb

performance

search

database
ãƒªãƒ³ã‚¯
A vendor-independent comparison of NoSQL databases: Cassandra, HBase, MongoDB, Riak
A vendor-independent comparison of NoSQL databases: Cassandra, HBase, Mongo DB, Riak By Sergey Bushik, senior R&D engineer at Altoros Systems Inc., special to Network World October 22, 2012 04:26 PM ET "The more alternatives, the more difficult the choice." -- Abbe' D'Allanival In 2010, when the world became enchanted by the capabilities of cloud systems and new databases designed to serve them, a
somat 2012/11/11
performance

database
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ Cassandraã€Mongodbã€SQLiteã€H2ã€MySQLã€Postgres - cypher256's blog
ä¸‹è¨˜ã®ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒè‰¯ã•ã’ãª SQLite ã‚’ä½¿ç”¨äºˆå®šã§ã™ãŒã€ã‚‚ã£ã¨é€Ÿã„ã‚‚ã®ãŒç„¡ã„ã‹ç¢ºèªã®ãŸã‚ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¨ˆæ¸¬ã—ã¦ã¿ã¾ã—ãŸã€‚SQL åˆ©ç”¨å‰æã§ã™ãŒã€NoSQL ãŒåœ§å€’çš„ãªæ€§èƒ½ã‚’å‡ºã™å ´åˆã¯æ¤œè¨Žã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã®ã§ KVS ã‚‚ç¢ºèªã—ã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ä»¶æ•°ã¯ 1 å„„ä»¶ç¨‹åº¦ã€JDBC SQL åˆ©ç”¨å¯èƒ½ INSERTã€UPDATE ã¯ãƒãƒƒãƒ SELECT ã¯ä¸»ã‚ãƒ¼ã‚¢ã‚¯ã‚»ã‚¹æ€§èƒ½ã‚’é‡è¦– å°†æ¥ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®ãŸã‚ã®åˆ†æ•£ã¯ã‚ã‚Šãˆã‚‹ãŒã€ã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ³ã§é…ã„ã®ã¯ã ã‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ è¨ˆæ¸¬ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å ã‚¿ã‚¤ãƒ— å½¢æ…‹ è©•åˆ¤ è¨ˆæ¸¬ã«ã¤ã„ã¦ã®å‚™è€ƒ SQLite RDB çµ„ã¿è¾¼ã¿ â€»2 ãŠã‚‚ã¡ã‚ƒã€Androidæ¨™æº– JDBCæ“ä½œ â€»1 H2 RDB çµ„ã¿è¾¼ã¿ â€»2 çµ„ã¿è¾¼ã¿æœ€é€Ÿ JDBCæ“ä½œ â€»1 Derby RDB çµ„ã¿è¾¼ã¿ â€»2 Javaæ¨™æº–ã§
somat 2012/11/08
performance

database
ãƒªãƒ³ã‚¯
https://www.oracle.com/technetwork/jp/content/parallel-exe-evening-100714-251722-ja.pdf
somat 2012/09/08
database

performance
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5) - SH2ã®æ—¥è¨˜
ã¨ã„ã†ã‚ã‘ã§ã€JPOUG> SET EVENTS 20120721 | Japan Oracle User Groupã«å‚åŠ ã—ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚é€šå¸¸ã®å‹‰å¼·ä¼šã¨æ¯”ã¹ã¦ç™ºè¡¨è€…ã¨è´è¬›è€…ã®ä¸€ä½“æ„Ÿã‚’å¢—ã™ãŸã‚ã®å·¥å¤«ãŒãªã•ã‚Œã¦ã„ã¦ã€ã¨ã¦ã‚‚è‰¯ã‹ã£ãŸã¨æ€ã„ã¾ã™ã€‚æœ‰é™ã‚³ãƒ¼ãƒ’ãƒ¼ã‹ã¨æ€ã£ãŸã‚‰ç„¡é™ãƒ“ãƒ¼ãƒ«ã ã£ãŸã®ã‚‚é©šãã§ã™ã€‚JPOUGã®é‹å–¶ãƒ¡ãƒ³ãƒã®ã¿ãªã•ã¾ã€ä¼šå ´ã‚’æä¾›ã—ã¦ãã ã•ã£ãŸæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ç§ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5)ã¨é¡Œã—ã¦éŽåŽ»4å›žåˆ†ã®ã¾ã¨ã‚ã¨è‡ªä½œãƒ„ãƒ¼ãƒ«ã®ç´¹ä»‹ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚JdbcRunnerã¯Oracle Databaseã€MySQLã¨PostgreSQLã®é–“ã§TPC-Bã¨TPC-Cã®æ€§èƒ½æ¯”è¼ƒãŒã§ãã‚‹å”¯ä¸€ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã®ã§ã€ã„ã‚ã„ã‚è©¦ã—ã¦ã¿ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚è©¦ã—ãŸçµæžœ
somat 2012/07/24
database

performance

tool

test
ãƒªãƒ³ã‚¯
Slow Query Questions - PostgreSQL wiki
Guide to Asking Slow Query Questions In any given week, some 50% of the questions on #postgresql IRC and 75% on pgsql-performance are requests for help with a slow query. However, it is rare for the requester to include complete information about their slow query, frustrating both them and those who try to help. Please post performance related questions to the pgsql-performance mailing list or to
somat 2012/05/29
ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã«ã¤ã„ã¦è³ªå•ã™ã‚‹ã¨ãã®ã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ã€‚æä¾›ã™ã¹ãæƒ…å ±ã€èžãå‰ã«ã‚„ã‚‹ã¹ãã“ã¨(EXPLAINã®çµæžœã‚ˆã‚€, ANALYZE/VACUUM, work_mem ã®å¢—æ¸›ç‰)

PostgreSQL

SQL

database

performance
ãƒªãƒ³ã‚¯
Reading PgAdmin Graphical Explain Plans - Postgres OnLine Journal
One of our favorite features of PgAdmin is the graphical explain plan feature. While a graphical explain plan is not a complete substitute for EXPLAIN or EXPLAIN ANALYZE text plans, it does provide a quick and easy to read view that can be used for further analysis. In this article, we'll walk thru using the explain plan to troubleshoot query performance. To use the graphical explain plan feature
somat 2012/04/26
PostgreSQL

performance

database

pgAdmin

SQL
ãƒªãƒ³ã‚¯
SQLã‚¢ã‚¿ãƒžã‚¢ã‚«ãƒ‡ãƒŸãƒ¼ è¨˜äº‹ä¸€è¦§ | gihyo.jp
æœ€çµ‚å›žã€€OLAPé–¢æ•°ã§å¼·åŠ›ãªçµ±è¨ˆå‡¦ç†ã‚’å®Ÿç¾ï¼â€•æ‰‹ç¶šãåž‹ã‹ã‚‰ç†è§£ã™ã‚‹SQLã€€ï¼ˆ5ï¼‰é›†åˆæŒ‡å‘ã¨æ‰‹ç¶šãåž‹ ãƒŸãƒƒã‚¯ 2010-05-28 æœ€çµ‚å›žã€€OLAPé–¢æ•°ã§å¼·åŠ›ãªçµ±è¨ˆå‡¦ç†ã‚’å®Ÿç¾ï¼â€•æ‰‹ç¶šãåž‹ã‹ã‚‰ç†è§£ã™ã‚‹SQLã€€ï¼ˆ4ï¼‰OLAPé–¢æ•°ã¨é›†ç´„é–¢æ•°ã‚’çµ„ã¿åˆã‚ã›ã‚‹ ãƒŸãƒƒã‚¯ 2010-05-27
somat 2012/04/26
database

performance

PostgreSQL

SQL
ãƒªãƒ³ã‚¯
DBã‚¢ã‚¿ãƒžã‚¢ã‚«ãƒ‡ãƒŸãƒ¼ è¨˜äº‹ä¸€è¦§ | gihyo.jp
æœ€çµ‚å›žã€€æ²»ç™‚ã¨ã—ã¦ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°â€•ã‚·ã‚¹ãƒ†ãƒ ã®ç—…æ°—ã¯ã©ã†æ²»ã™ï¼Ÿï¼ˆ3ï¼‰ ãƒŸãƒƒã‚¯ 2011-04-01
somat 2012/04/26
database

performance

PostgreSQL
ãƒªãƒ³ã‚¯
PostgreSQL tuning technique
PostgreSQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯é›† SELECT ... WHERE foo = 100 ORDER BY barã‚’SELECT ... WHERE foo = 100 ORDER BY i, jã«æ›¸ãæ›ãˆã‚‹(2004/08/18æŽ²è¼‰) SELECT * FROM t1 WHERE i = 100 ORDER BY j; ã®ã‚ˆã†ãªãƒ‘ã‚¿ãƒ¼ãƒ³ã®æ¤œç´¢ã§ã¯ï¼Œiã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã“ã¨ã§ã‚ã‚‹ç¨‹åº¦ã®é«˜ é€ŸåŒ–ãŒã§ãã¾ã™ãŒï¼Œãã®å¾Œã§ã‚½ãƒ¼ãƒˆãŒç™ºç”Ÿã—ï¼Œé€Ÿåº¦ä½Žä¸‹ã®è¦å› ã«ãªã‚Šã¾ã™ï¼Ž SELECT * FROM t1 WHERE i = 100 ORDER BY j LIMIT 5; ã®ã‚ˆã†ã«ï¼Œå‡ºåŠ›çµæžœä»¶æ•°ã‚’åˆ¶é™ã—ã‹ã¤jã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã¨ï¼Œä»Šåº¦ã¯jã®ã‚¤ ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã†ã‚ˆã†ã«ãªã‚Šã¾ã™ï¼Ž ã—ã‹ã—ï¼Œã‚ˆãè€ƒãˆã¦ã¿ã‚‹ã¨ï¼Œiã§æ¤œç´¢ã—ï¼Œjã§ã‚½ãƒ¼ãƒˆã™ã‚‹ã®ã¯iã¨jã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ ã‚¹ã®ä¸¡æ–¹ã‚’ä½¿ãˆã°ä¸€åº¦ã«ã§ãã‚‹ã¯ãšã§ã™
somat 2012/04/11
ã‚·ãƒ¼ãƒ©ã‚«ãƒ³ã‚¹æœ¬ç¬¬4ç‰ˆã®ã‚µãƒ–ãƒšãƒ¼ã‚¸ / 1.æ¤œç´¢æ¡ä»¶ã¨order by ã«ä½¿ã†ã‚«ãƒ©ãƒ ã§è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹/ 2.group by æŒ‡å®šã§ HashAggregate ã¤ã‹ã‚ã›ã‚‹

PostgreSQL

database

tips

performance

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

performance

tips

database

PostgreSQL
ãƒªãƒ³ã‚¯
1