{"blog_url":"https://shimx.hateblo.jp/","author_url":"https://blog.hatena.ne.jp/shimx/","version":"1.0","type":"rich","published":"2012-08-02 12:35:40","title":"\u53e4\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u306eInnoDB\u3060\u3068TRUNCATE TABLE\u3057\u3066\u3082\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u306e\u30b5\u30a4\u30ba\u304c\u6e1b\u3089\u306a\u3044\u4ef6","description":"\u4e45\u3005\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3002 \u4ed5\u4e8b\u4e2d\u3061\u3087\u3063\u3068\u554f\u984c\u306b\u306a\u3063\u305f\u4e8b\u304c\u3042\u308a\u307e\u3057\u3066 \u30b5\u30fc\u30d0\u306e\u5bb9\u91cf\u304c\u554f\u984c\u306b\u306a\u3063\u3066\"\u5bb9\u91cf\u4e0d\u8db3\u3060(\uff9f\u0414\uff9f)\uff7a\uff9e\uff99\uff67!!\"\u3063\u3066\u8b66\u5831\u304c\u9cf4\u308a\u6b62\u307e\u305a \u2193\u4e0d\u8981\u306a\u30c6\u30fc\u30d6\u30eb\u3092\u6d88\u3057\u3066\u5bb9\u91cf\u78ba\u4fdd\u305b\u306d\u3070\u2026\uff01\u2193 \u3051\u3069DROP\u3057\u3066\u30d7\u30ed\u30b0\u30e9\u30e0\u3044\u3058\u308b\u306e\u3081\u3093\u3069\u3044\u306a\u3042\u2026\u2193 ( \uff9f\u0434\uff9f)\uff8a\uff6f! TRUNCATE\u306a\u3089\u2026\u305d\u308c\u3067\u3082TRUNCATE\u306a\u3089\u304d\u3063\u3068\u306a\u3093\u3068\u304b\u3057\u3066\u304f\u308c\u308b\u2026\uff01 \u2193 TRUNCATE\u3060\u3093\u3002df\u3063\u3068\u3001\u3042\u308c\u2026\u7a7a\u304d\u5bb9\u91cf\u5897\u3048\u3066\u306d\u3048\u2026( \uff9f\u0434\uff9f) \u3068\u3044\u3046\u4e8b\u304c\u3042\u308a\u307e\u3057\u305f\u3002 TRUNCATE\u3063\u3066\u6319\u52d5\u7684\u306b\u306fDROP->CREATE\u3067OPTIMIZE\u306a\u3093\u3056\u3044\u3089\u306d\u3048\u3088\uff01\u3060\u3068\u601d\u3063\u3066\u3044\u305f\u306e\u3067\u3001\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3082\u6d88\u3057\u3066\u304f\u308c\u308b\u3068\u4fe1\u3058\u3066\u305f\u3093\u3067\u3059\u304c\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fshimx.hateblo.jp%2Fentry%2F2012%2F08%2F02%2F123540\" title=\"\u53e4\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u306eInnoDB\u3060\u3068TRUNCATE TABLE\u3057\u3066\u3082\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u306e\u30b5\u30a4\u30ba\u304c\u6e1b\u3089\u306a\u3044\u4ef6 - shimxmemo\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"shimx","height":"190","image_url":null,"provider_name":"Hatena Blog","blog_title":"shimxmemo","width":"100%","categories":[],"url":"https://shimx.hateblo.jp/entry/2012/08/02/123540","provider_url":"https://hatena.blog"}