3月 28th, 2012

NoSQLパフォーマンス? 較

Posted in NoSQL/KVS by admin

こちらのサイトぜ MySQL(HEAPエンジボ )ぜ memcachedの速度? 較を実施しています。
http://blog.asial.co.jp/220

追加でその? ぜ NoSQLソフトウェアとの? 較も実施しました。
とりあえずNoSQLは初めてなので、上っ面だけで深く突っ込んで調査しない。(最初に宣言)
検証サーバは、仮惜 CPUコア×4、メモボ 4Gの仮想サーバ上で? 施しています。

§ 性能? 証方?
NoSQLデータベースに対し、100,000件のレコード挿入、検索、削除を実施する。
・挿入するレコードは、Keyにループ回数ぜ MD5ボ ッシュ? ()、Valueぜ CRC32チェックサム値。
・? 索は、Keyを検索条件にしぜ Valueを圏 得。圏 得したデータはメモリに格? するだけでが出力しない。
・削除は、TRUNCATEのような処理ではなぜ 、Keyを検索条件にしぜ 1件? に削除。

§ 性能? 証? 果
nosql_perf
・処理速度ぜ 3回の平均値を表示
・使用したJDKバージョンは「1.6.0_20」
・各ソフトウェアで確保したメモリは? 3GB

§ まとめ
ボ memcachedは、MySQLぜ HEAPエンジンと? 較しても高速。
ボ TokyoCabinet/TokyoTyrantは、memcachedとほぼ同等の処理速度。データ永続性がある為、ディスク書き込みが発生する。ただし、それ程サーバ負荷は? ぜ ないので、フロントアプリケーション側で利用するKVSソフトウェアとしては適していると思゜ れる。
ボ MongoDBは、スキーマレスのデータベースなのぜ RDBでいうテーブル? 義が不要なのが非常に楽。また、memcachedよりも挿入、検索スピードが速いが、1件削除が異常に遅い。(要調査?
ボ Cassandraは、比較的高速ではあるがディスクぜ flushされた後の? 索処理が遅い。Hadoopとの親和性もある為、オンライン処理ではなぜ 、バッチ処理用途が向いている。
ボ VoltDBがなぜか遅い。(要調査?

§ 要追加調?
ボ MongoDBの削陜 (remove)が異常に遅い
ボ VoltDBの処理が異常に遅い。hprofでは以下のメソッドぜ 65%占めている。

java.lang.Object.wait
sun.nio.ch.EPollArrayWrapper.poll
java.util.concurrent.locks.LockSupport.park
sun.nio.ch.SocketDispatcher.read

ボ 100,000件だけではなぜ 、処理件数によってどう性能が変゜ るのかという特性も確かめる必要があるかもしれない。

You can leave a comment, or trackback from your own site. RSS 2.0

47 comments

  1. フリーローン比較 says:

    一般的には銀行系や信販系のカードローンは消費者金融に比べると金利が低いものです。その代わりに審査の条件が厳しい場合もありますが、低金利で人気のある会社をいくつかご紹介します。

    4月 8th, 2016 at 2:01:00

  2. Blythe says:

    That is true for funding advice as well.

    4月 20th, 2019 at 11:51:06

  3. i love pron says:

    sQjqU0 It as not that I want to replicate your website, but I really like the pattern. Could you tell me which design are you using? Or was it tailor made?

    4月 22nd, 2019 at 22:34:09

  4. i love pron says:

    KJLhwX You might have an incredibly nice layout for the blog i want it to work with on my site too.

    4月 23rd, 2019 at 2:06:30

  5. bit.ly says:

    Wow! At last I got a weblog from where I be
    able to genuinely take helpful facts concerning my study and knowledge.

    4月 24th, 2019 at 1:46:53

  6. http://tinyurl.com/y2tr3s8g says:

    Wow, fantastic weblog layout! How lengthy have you ever been blogging for?
    you make running a blog glance easy. The overall look of your website is magnificent, let alone the content material!

    4月 24th, 2019 at 3:40:16

  7. https://tinyurl.com says:

    Excellent way of explaining, and fastidious piece of writing
    to get data on the topic of my presentation subject matter,
    which i am going to convey in school.

    4月 24th, 2019 at 4:56:13

  8. Bob says:

    I’m amazed, I have to admit. Rarely do I encounter
    a blog that’s equally educative and engaging, and without a doubt, you’ve
    hit the nail on the head. The issue is something that too few folks are speaking
    intelligently about. I’m very happy that I came across this in my search for something regarding this.

    4月 24th, 2019 at 5:30:39

  9. http://tinyurl.com says:

    Peculiar article, totally what I wanted to find.

    4月 24th, 2019 at 6:24:15

  10. tinyurl.com says:

    This article offers clear idea in support of the new people of blogging, that really how to do blogging.

    4月 24th, 2019 at 7:03:10

  11. http://tinyurl.com/ says:

    Fantastic beat ! I wish to apprentice while you amend
    your web site, how can i subscribe for a blog website?
    The account helped me a acceptable deal. I had been a little bit acquainted of this your broadcast provided bright clear idea

    4月 24th, 2019 at 7:27:07

  12. Mauro Pereira Martins cunhado says:

    Good info. Lucky me I ran across your site by chance
    (stumbleupon). I’ve book-marked it for later!

    4月 24th, 2019 at 7:28:46

  13. Mellisa says:

    Hi superb website! Does running a blog like
    this require a massive amount work? I’ve no expertise in computer programming but I
    was hoping to start my own blog soon. Anyhow, should you have any ideas or techniques
    for new blog owners please share. I know this is
    off topic but I just had to ask. Thanks!

    4月 24th, 2019 at 9:41:11

  14. tinyurl.com says:

    Greetings from Los angeles! I’m bored at work so I decided to browse your
    site on my iphone during lunch break. I enjoy the knowledge you
    present here and can’t wait to take a look when I get home.

    I’m surprised at how quick your blog loaded on my mobile ..
    I’m not even using WIFI, just 3G .. Anyhow, very good blog!

    4月 24th, 2019 at 12:02:53

  15. http://tinyurl.com/yxfpajpj says:

    Just desire to say your article is as amazing. The clearness for your submit is simply cool and that i can assume you
    are an expert on this subject. Well together with your permission let me to take hold of your RSS feed to keep up to date
    with drawing close post. Thanks one million and please carry on the enjoyable
    work.

    4月 24th, 2019 at 12:14:45

  16. Edgar says:

    Simply wish to say your article is as astounding.
    The clarity in your post is simply excellent and i can assume you’re an expert
    on this subject. Fine with your permission allow me to
    grab your feed to keep updated with forthcoming post.
    Thanks a million and please carry on the enjoyable work.

    4月 24th, 2019 at 14:00:47

  17. Josefina says:

    Cool blog! Is your theme custom made or did you download it from somewhere?
    A design like yours with a few simple adjustements would really make my blog stand out.
    Please let me know where you got your design. With thanks

    4月 24th, 2019 at 14:28:22

  18. http://tinyurl.com/y3pxn23p says:

    Hello there! I could have sworn I’ve visited this blog before but after looking at a few of the articles I
    realized it’s new to me. Regardless, I’m definitely pleased I discovered it and I’ll be bookmarking it and checking back often!

    4月 24th, 2019 at 14:42:02

  19. Imogen says:

    I’ve read some good stuff here. Certainly value bookmarking for revisiting.
    I surprise how a lot attempt you put to create this kind of magnificent informative site.

    4月 24th, 2019 at 15:55:00

  20. Leonardo Martins de Almeida says:

    Howdy! This post could not be written any better! Reading this post reminds
    me of my previous room mate! He always kept chatting about this.
    I will forward this post to him. Fairly certain he will have a good read.
    Many thanks for sharing!

    4月 24th, 2019 at 15:58:53

  21. reputação online says:

    Its such as you read my mind! You appear to understand a lot approximately this,
    like you wrote the ebook in it or something. I believe that you just
    can do with some p.c. to force the message house a bit, but instead of that, this is fantastic blog.
    A great read. I’ll certainly be back.

    4月 24th, 2019 at 16:41:57

  22. tinyurl.com says:

    Everyone loves what you guys tend to be up too.
    This sort of clever work and reporting! Keep up the
    wonderful works guys I’ve incorporated you guys to my blogroll.

    4月 24th, 2019 at 17:27:58

  23. tinyurl.com says:

    It’s awesome to pay a quick visit this site and reading the views of
    all mates on the topic of this paragraph, while I am also zealous of
    getting experience.

    4月 24th, 2019 at 18:17:52

  24. Joanne says:

    I’m really inspired along with your writing skills as well as with the format
    on your weblog. Is that this a paid subject matter
    or did you modify it yourself? Either way
    stay up the excellent high quality writing, it is uncommon to see a nice blog like
    this one nowadays..

    4月 24th, 2019 at 18:18:17

  25. Rodrigo Branco says:

    Hi there! I could have sworn I’ve been to this website before but after browsing through many
    of the articles I realized it’s new to me. Regardless, I’m definitely happy I came across
    it and I’ll be book-marking it and checking back
    regularly!

    4月 24th, 2019 at 20:23:43

  26. Rodrigo Branco says:

    When some one searches for his essential thing, therefore he/she needs to be available
    that in detail, so that thing is maintained over here.

    4月 24th, 2019 at 21:54:33

  27. Luiz Gastão Bittencourt says:

    I am really loving the theme/design of your site. Do you ever
    run into any internet browser compatibility issues?
    A small number of my blog readers have complained about my site not working correctly in Explorer but looks great in Safari.
    Do you have any suggestions to help fix this problem?

    4月 24th, 2019 at 22:49:53

  28. Rodrigo Branco says:

    I have read so many articles or reviews concerning the blogger lovers except this article is actually a nice article, keep it
    up.

    4月 24th, 2019 at 23:28:17

  29. Leonardo Martins de Almeida says:

    hi!,I like your writing very so much! share we be in contact more about your post on AOL?
    I require an expert in this house to unravel my problem.
    May be that’s you! Looking forward to see you.

    4月 25th, 2019 at 0:11:43

  30. tinyurl.com says:

    We’re a gaggle of volunteers and opening a new scheme in our
    community. Your website provided us with useful information to work on.
    You’ve done a formidable process and our whole neighborhood can be thankful to you.

    4月 25th, 2019 at 1:28:33

  31. http://bit.ly says:

    hello there and thank you for your info – I have certainly
    picked up anything new from right here. I did however expertise a
    few technical points using this website, since I experienced to reload the website a
    lot of times previous to I could get it to load correctly.
    I had been wondering if your hosting is OK?
    Not that I am complaining, but slow loading instances times will sometimes affect your
    placement in google and could damage your
    high quality score if ads and marketing with Adwords.
    Anyway I’m adding this RSS to my e-mail and could look out for much
    more of your respective exciting content. Ensure that
    you update this again very soon.

    4月 25th, 2019 at 2:13:09

  32. Soila says:

    An outstanding share! I have just forwarded this onto a
    co-worker who was doing a little research on this.
    And he in fact bought me lunch due to the fact that I stumbled upon it for him…
    lol. So let me reword this…. Thanks for the meal!!
    But yeah, thanx for spending some time to discuss this issue here on your blog.

    4月 25th, 2019 at 5:46:45

  33. Rodrigo Branco says:

    Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically tweet
    my newest twitter updates. I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have some
    experience with something like this. Please let me know if you
    run into anything. I truly enjoy reading your blog and I look forward to your new updates.

    4月 25th, 2019 at 6:19:06

  34. http://tinyurl.com/y5g573zr says:

    Hi there, its fastidious piece of writing regarding media
    print, we all be familiar with media is a impressive source of facts.

    4月 25th, 2019 at 6:21:06

  35. Klefer says:

    You really make it seem so easy with your presentation but I find this matter to be
    really something that I think I would never understand.

    It seems too complex and very broad for me. I’m looking forward for your next post,
    I’ll try to get the hang of it!

    4月 25th, 2019 at 6:48:42

  36. Cathy says:

    I do not even know how I ended up here, however I thought this post was
    good. I do not recognize who you might be but definitely you’re going to a well-known blogger when you
    aren’t already. Cheers!

    4月 25th, 2019 at 6:57:12

  37. Bernadine says:

    Hi, Neat post. There is an issue with your site in web explorer, could test this?

    IE nonetheless is the marketplace leader and a good section of other
    folks will omit your excellent writing due to this problem.

    4月 25th, 2019 at 11:00:07

  38. Jefferson says:

    I think that everything published made a great deal of sense.
    However, what about this? what if you were to create a awesome headline?
    I ain’t saying your content isn’t solid, however what if you
    added something to possibly get people’s attention? I
    mean wall-climb » NoSQLパフォーマンス? 較 is
    kinda boring. You might glance at Yahoo’s front page and see
    how they write article titles to grab viewers to open the links.

    You might add a video or a pic or two to get readers interested about everything’ve got to say.
    Just my opinion, it could make your posts a little bit more interesting.

    4月 25th, 2019 at 11:14:12

  39. tinyurl.com says:

    This is very interesting, You’re a very skilled blogger.
    I’ve joined your feed and look forward to seeking more of your great post.
    Also, I’ve shared your website in my social networks!

    4月 25th, 2019 at 12:46:43

  40. tinyurl.com says:

    Why viewers still make use of to read news papers
    when in this technological globe all is accessible
    on web?

    4月 25th, 2019 at 16:00:18

  41. Mauro Pereira Martins cunhado says:

    Attractive section of content. I just stumbled upon your website
    and in accession capital to claim that I acquire in fact enjoyed account your blog posts.
    Any way I’ll be subscribing in your feeds and even I
    success you access persistently rapidly.

    4月 25th, 2019 at 16:02:58

  42. Deanne says:

    Unquestionably believe that which you said. Your favorite reason appeared to be on the internet the easiest
    thing to be aware of. I say to you, I definitely get
    irked while people think about worries that they just don’t know about.
    You managed to hit the nail upon the top as well as defined out
    the whole thing without having side effect , people could take a signal.
    Will likely be back to get more. Thanks

    4月 25th, 2019 at 16:31:32

  43. Kassie says:

    After going over a handful of the blog posts on your web page, I seriously like your technique of blogging.

    I added it to my bookmark website list and will be checking back in the near future.
    Take a look at my web site too and let me know your opinion.

    4月 25th, 2019 at 16:57:19

  44. http://tinyurl.com/y3u76ef6 says:

    Great beat ! I wish to apprentice while you amend your
    site, how could i subscribe for a blog website? The account aided me a acceptable deal.

    I had been a little bit acquainted of this your broadcast
    offered bright clear concept

    4月 25th, 2019 at 16:58:40

  45. Jarrod says:

    I pay a quick visit each day some web sites and sites to read articles,
    however this website offers feature based writing.

    4月 25th, 2019 at 17:37:33

  46. Darnell says:

    Greetings from Ohio! I’m bored to death at work so I decided to browse your
    site on my iphone during lunch break. I enjoy the knowledge you present here and can’t wait to take a look when I get home.
    I’m shocked at how fast your blog loaded on my phone ..
    I’m not even using WIFI, just 3G .. Anyhow, excellent blog!

    4月 25th, 2019 at 17:52:39

  47. Mia says:

    I am sure this paragraph has touched all the internet viewers,
    its really really good post on building up new web site.

    4月 25th, 2019 at 19:17:54

Leave a comment