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

somat id:somat

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

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

æœ¬å½“ã¯æã‚ã—ã„åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ ã®è©±
2. 2CopyrightÂ©2017 NTT corp. All Rights Reserved. è«¸èª¬ã‚ã‚‹ãŒã€ã“ã“ã§ã®å®šç¾©ã¯ã€Œéƒ¨åˆ†çš„ãªæ•…éšœã‚’è¨±å®¹ã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã€ã®äº‹ è¤‡æ•°å°ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã‚’æŽ¥ç¶šã—ã¦ä¿¡é ¼æ€§ã‚’é«˜ã‚ãŸã‚Š ãƒ‡ãƒ¼ã‚¿ãŒé€”ä¸ã§åŒ–ã‘ã¦ã‚‚å†é€ã—ãŸã‚Šè¨‚æ£ã—ãŸã‚Š ä¸€éƒ¨ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãŒçªç„¶æ•…éšœã—ã¦ã‚‚å¼•ãç¶™ã„ã ã‚Š æ•…éšœã‚’è¨è¨ˆã®ä¸€éƒ¨ã«çµ„ã¿è¾¼ã‚€äº‹ãŒå¿…é ˆã¨ãªã‚‹ åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ ã¨ã¯ 3. 3CopyrightÂ©2017 NTT corp. All Rights Reserved. â€¢ ä¸–ã¯ã¾ã•ã«åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ æˆ¦å›½æ™‚ä»£ â€¢ Hadoopã‚’çš®åˆ‡ã‚Šã«æ¬¡ã€…å‡ºã¦ãã‚‹å·¨å¤§åˆ†æ•£OSS â€¢ ã‚·ãƒªã‚³ãƒ³ãƒãƒ¬ãƒ¼ã§ã‚‚åˆ†æ•£ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ãƒ™ãƒ³ãƒãƒ£ãƒ¼ãŒå¤šæ•°å‡ºç¾ â€¢ é«˜ä¿¡é ¼ãªã‚·ã‚¹ãƒ†ãƒ ã‚’ä½œã‚ã†ã¨æ€ã£ãŸå ´åˆã«ã¯è¤‡æ•°å°ã®ãƒžã‚·ãƒ³ã«ã‚ˆã‚‹é«˜å¯ç”¨æ§‹æˆ ãŒå‰æã«ãªã‚‹ â€¢ Googleã€Facebookã€Amazonç‰ã¯ã‚‚ã¡ã‚ã‚“ â€¢ é‡‘èžã€æµé€šãªã©ã®ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©
somat 2017/10/31
database

architecture
ãƒªãƒ³ã‚¯
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
ãƒªãƒ³ã‚¯
Using Redis as a Secondary Index for MySQL | code.flickr.com
Hey, did you notice, on the brand-spanking-new Yahoo homepage, right there on the side of the page, itâ€™s photos from your Flickr contacts (or maybe your groups)! No? Go check it out, Iâ€™ll wait. Ok, great, youâ€™re back! What you should have seen, assuming you have Flickr contacts (or are a member of some groups), is photos from your most recently active contact (or group!). Something likeâ€¦ this: (th
somat 2013/04/18
database

Redis
ãƒªãƒ³ã‚¯
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
ãƒªãƒ³ã‚¯
SAP High-Performance Analytic Appliance 1.0 (SAP HANA)
somat 2012/11/11
HANA

architecture

database
ãƒªãƒ³ã‚¯
http://www.dwbiconcepts.com/database/28-hana/105-sap-hana-architecture.html
somat 2012/11/11
HANA

architecture

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
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’ã©ã†ã‚„ã£ã¦å‘ä¸Šã•ã›ã‚‹ã‹
ã“ã‚Œã¾ã§Publickeyã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã«é–¢ã™ã‚‹ã•ã¾ã–ã¾ãªãƒˆãƒ”ãƒƒã‚¯ã‚’å–ã‚Šä¸Šã’ã¦ãã¾ã—ãŸã€‚ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã«ã¯ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‹ãƒ¼ã‚ºãŒã“ã‚Œã¾ã§ã«ãªãé«˜ã¾ã£ã¦ã„ã‚‹ãŸã‚ã§ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€ã“ã‚Œã¾ã§å–ã‚Šä¸Šã’ã¦ããŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã«é–¢ã™ã‚‹æŠ€è¡“ã‚’å°‘ã—ã¾ã¨ã‚ã¦ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ å¾“æ¥ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ã‚’æ‹¡å¼µ å¾“æ¥ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã—ã¦ã€æŠ€è¡“çš„å·¥å¤«ã‚’å‡ã‚‰ã™ã“ã¨ã§ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®Ÿç¾ã—ã‚ˆã†ã¨ã„ã†ã‚¢ãƒ—ãƒãƒ¼ãƒã«ã‚‚ã€ã•ã¾ã–ã¾ãªã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç ”ç©¶è€…ã®å¤§å¾¡æ‰€ã€ãƒžã‚¤ã‚±ãƒ«ãƒ»ã‚¹ãƒˆãƒ¼ãƒ³ãƒ–ãƒ¬ã‚¤ã‚«ãƒ¼æ°ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯æ±ºã—ã¦é…ããªã„ã¨ä¸»å¼µã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒé…ã„åŽŸå› ã¯ãƒãƒƒã‚¯ã€ãƒ©ãƒƒãƒã€ãƒªã‚½ãƒ¼ã‚¹ç®¡ç†ã«ã‚ã‚‹ã¨ã—ã¦ã€ãã‚Œã‚‰ã‚’æ¥µåŠ›æŽ’é™¤ã—ãŸã€ŒVoltDBã€ã‚’é–‹ç™ºã—ã¦ã„ã¾ã™ã€‚ NoSQLã‚’ä¸Šå›žã‚‹æ€§èƒ½ã®VoltDBã€ãã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£
somat 2012/11/11
database

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
http://www.bluefinsolutions.com/insights/blog/the_sap_hana_faq_answering_key_sap_in_memory_questions/
somat 2012/11/11
HANA

database
ãƒªãƒ³ã‚¯
Inheritance and sharding with Postgres
Iâ€™ve used sharding with inheritance in the past but on a warehousing backend where we did not need to worry about locks. Using LIKE to define child tables creates a maintenance burden but there are ways to work around it in your application code which can be made â€˜versionâ€™ aware. In effect you would never update old shards and only add those columns in the newer shards â€“ the application code being
somat 2012/11/11
database

PostgreSQL
ãƒªãƒ³ã‚¯
How to create a SAP HANA Developer Edition in the cloud
Tags: opensapawshana_devcenterdeveloperhanaamazondevcenter OLD VERSIONThis document is now out of date.For the latest information about getting an SAP HANA Developer Account on AWS or Azure, please see to the new tutorial on our new SAP HANA Developer Center. How much will this cost? SAP won't charge you anything for the license, but you will be responsible for operating your own cloud provider se
somat 2012/11/08
HANA

database

AWS
ãƒªãƒ³ã‚¯
https://jp.techcrunch.com/2012/10/31/20121027big-data-right-now-five-trendy-open-source-technologies/
somat 2012/11/08
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
ãƒªãƒ³ã‚¯
Sharding & IDs at Instagram
Welcome to the Instagram Engineering Blog, where we share insights on building and scaling our service. With more than 25 photos & 90 likes every second, we store a lot of data here at Instagram. To make sure all of our important data fits into memory and is available quickly for our users, weâ€™ve begun to shard our dataâ€”in other words, place the data in many smaller buckets, each holding a part of
somat 2012/09/20
Instagram ãŒ sharding ã—ãŸã¨ãã® ID æŒ¯ã‚Šåˆ†ã‘å‡¦ç†ã®è©³ç´°

PostgreSQL

database
ãƒªãƒ³ã‚¯
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å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
somat 2012/09/20
PostgreSQL

MySQL

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
ãƒªãƒ³ã‚¯
Percona Toolkit
All of Perconaâ€™s open source software products, in one place, to download as much or as little as you need.
somat 2012/07/18
Databaseç”¨ãƒ„ãƒ¼ãƒ«ã„ã‚ã„ã‚ã€‚MySQL ç”¨ã€ã¨ãªã£ã¦ã„ã‚‹ãŒã€å†…éƒ¨ã§ä½¿ã£ã¦ã‚‹ SQLParser ãªã©ã¯ PostgreSQL ç”¨ã«ã‚‚ä½¿ãˆã‚‹ã€‚å…ƒã¯ http://code.google.com/p/maatkit/ ã«ã‚ã£ãŸã‚‚ã®ãªã©ãŒçµ±åˆã•ã‚ŒãŸæ¨¡æ§˜

Perl

tool

database
ãƒªãƒ³ã‚¯
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
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸