{"provider_url":"https://hatena.blog","height":"190","categories":["MySQL"],"title":"Waiting for table metadata lock\u306e\u5bfe\u51e6\u306e\u4ed5\u65b9\u3001\u304a\u3055\u3089\u3044\u3002","blog_title":"\u306a\u304b\u3089\u306aLife","version":"1.0","published":"2018-12-08 09:00:00","description":"MySQL Casual Advent Calendar 2018 - Qiita 8\u65e5\u76ee\u306e\u8a18\u4e8b\u3067\u3059\u3002 \u99c6\u3051\u8fbc\u307f\u3002 \u3084\u304d\u306a\u304a\u3057\u3067\u3059\u3002 \u308f\u308a\u3068\u30cb\u30fc\u30ba\u304c\u3042\u308b\u3089\u3057\u304f\u3001\u3053\u306e\u30cd\u30bf\u3067\u904e\u53bb\u30a8\u30f3\u30c8\u30ea\u306b\u3061\u3087\u3044\u3061\u3087\u3044\u30a2\u30af\u30bb\u30b9\u304c\u304f\u308b\u306e\u3067\u3001\u3068\u306b\u304b\u304f\u6025\u3044\u3067\u3044\u308b\u4eba\u7528\u306b\u3001\u30b7\u30f3\u30d7\u30eb\u306b\u307e\u3068\u3081\u307e\u3057\u305f\u3002 MySQL5.6\u30015.7\u3067\u4f7f\u3048\u307e\u3059\u3002 \u305f\u3076\u30938.0\u3067\u3082\u4f7f\u3048\u308b\u3093\u3058\u3083\u306a\u3044\u304b\u306a\u3002\u77e5\u3089\u3093\u3051\u3069\u3002MySQL5.7\u3067Performance_schema.metadata_locks\u304c\u8ffd\u52a0\u3055\u308c\u305f\u3051\u3069\u3001\u3053\u308c\u3082\u8a2d\u5b9a\u5165\u308c\u306a\u3044\u3068\u4f7f\u3048\u306a\u3044\u3093\u3060\u3088\u306d\u3002 \u72af\u4eba\u3092\u7279\u5b9a\u3059\u308b\u3002 1. information_schema.innodb_trx\u3092\u5168\u4ef6\u53c2\u7167\u3059\u308b\u3002 \u5217\u2026","blog_url":"https://atsuizo.hatenadiary.jp/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fatsuizo.hatenadiary.jp%2Fentry%2F2018%2F12%2F08%2F090000\" title=\"Waiting for table metadata lock\u306e\u5bfe\u51e6\u306e\u4ed5\u65b9\u3001\u304a\u3055\u3089\u3044\u3002 - \u306a\u304b\u3089\u306aLife\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","width":"100%","url":"https://atsuizo.hatenadiary.jp/entry/2018/12/08/090000","image_url":"https://images-fe.ssl-images-amazon.com/images/I/510hZ8vAkXL._SL160_.jpg","author_name":"atsuizo","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/atsuizo/","type":"rich"}