This question is an exact duplicate of: Mysql: select from information_schema.STATISTICS hanging or slow? never saw a result I’m trying to check statistics with select from information_schema.STATISTICS The query never ends. I have to stop it. I checked innodb_stats_on_metadata=0 like in this post enter link description here, it was already set to 0. Any idea?Read more