{"title":" ID\u30921000\u305a\u3064\u5897\u3084\u3059\uff08ndbcluster\uff09","width":"100%","url":"https://so-wh.at/entry/20100629/p1","categories":["MYSQL"],"author_url":"https://blog.hatena.ne.jp/winebarrel/","type":"rich","image_url":null,"height":"190","blog_url":"https://so-wh.at/","version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fso-wh.at%2Fentry%2F20100629%2Fp1\" title=\" ID\u30921000\u305a\u3064\u5897\u3084\u3059\uff08ndbcluster\uff09 - so what\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2010-06-29 00:00:00","author_name":"winebarrel","blog_title":"so what","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","description":"ndbcluster\u3067\u3082\u8a66\u3057\u3066\u307f\u305f\u3002 CREATE TABLE `sequence` ( `id` int(10) unsigned NOT NULL ) ENGINE=ndbcluster [root@ip-XXX-XXX-XXX-XXX ~]# time ruby test.rb real 5m12.842s user 0m0.028s sys 0m0.016s5\u5206\u304b\u20261666qps\u3001\u307e\u3042\u8a31\u5bb9\u7bc4\u56f2\u304b\u306a\u3002 [root@ip-XXX-XXX-XXX-XXX ~]# mysql sandbox -e \"select id from hoge\" | sort | uniq | wc -l 5000\u2026"}