{"type":"rich","height":"190","author_name":"buty4649","description":"\u30d1\u30a4\u30d7\u3067\u631f\u3080\u3053\u3068\u3067\u9032\u6357\u8868\u793a\u304c\u51fa\u6765\u308b pv \u30b3\u30de\u30f3\u30c9\u3068\u3063\u3066\u3082\u4fbf\u5229\u3067\u3059\u306d\u3002 nc\u30b3\u30de\u30f3\u30c9\u3067\u30d5\u30a1\u30a4\u30eb\u8ee2\u9001\u3059\u308b\u3068\u304d\u306bpv\u30b3\u30de\u30f3\u30c9\u3067\u9032\u6357\u3092\u8868\u793a\u3059\u308b - Glide Note - \u30b0\u30e9\u30a4\u30c9\u30ce\u30fc\u30c8blog.glidenote.com \u3057\u304b\u3057\u3001\u30d1\u30a4\u30d7\u306e\u9806\u756a\u3092\u8003\u3048\u306a\u3044\u3068ETA\u304c\u8868\u793a\u3055\u308c\u307e\u305b\u3093\u3002 \u4f8b\u3048\u3070\u3001gzip\u5727\u7e2e\u3055\u308c\u305fmysqldump\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30ea\u30b9\u30c8\u30a2\u3059\u308b\u3068\u3057\u307e\u3059\u3002 \u7d20\u76f4\u306b\u30b3\u30de\u30f3\u30c9\u3092\u5165\u529b\u3059\u308b\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308b\u3068\u601d\u3044\u307e\u3059\u3002 $ zcat dumpfile.gz | pv | mysql \u3053\u308c\u3060\u3068\u3001pv\u30b3\u30de\u30f3\u30c9\u306fdumpfile\u306e\u89e3\u51cd\u5f8c\u306e\u30b5\u30a4\u30ba\u304c\u5206\u304b\u3089\u306a\u3044\u306e\u3067\u3001ETA\u3092\u8868\u793a\u51fa\u6765\u307e\u305b\u3093\u3002 $ zcat dump\u2026","blog_url":"https://tech.buty4649.net/","title":"pv\u30b3\u30de\u30f3\u30c9\u3092\u9069\u5207\u306b\u914d\u7f6e\u3057\u3066ETA\u3092\u8868\u793a\u3059\u308b","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftech.buty4649.net%2Fentry%2F2015%2F08%2F04%2F122439\" title=\"pv\u30b3\u30de\u30f3\u30c9\u3092\u9069\u5207\u306b\u914d\u7f6e\u3057\u3066ETA\u3092\u8868\u793a\u3059\u308b - \u3076\u3066\u3044\u306e\u30ed\u30b0\u3067\u3076\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://tech.buty4649.net/entry/2015/08/04/122439","version":"1.0","image_url":"http://cdn-ak.f.st-hatena.com/images/fotolife/b/buty4649/20150804/20150804122403.png","blog_title":"\u3076\u3066\u3044\u306e\u30ed\u30b0\u3067\u3076\u30ed\u30b0","author_url":"https://blog.hatena.ne.jp/buty4649/","width":"100%","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","categories":[],"published":"2015-08-04 12:24:39"}