https://bugzilla.wikimedia.org/show_bug.cgi?id=69182
--- Comment #2 from metatron <[email protected]> --- While normal queries now perform greatly with SSD, there's still no cure for that problem. I removed every fancy stuff like GROUP BY and SUM() and touched it like a virgin, querying one schema after another. This simple loop freezes the whole listener for like 200 sec. Just tried it again with s1 and s2. foreach ( $schemata as $i => $schema ){ $queryString =" SELECT table_schema, data_length, index_length FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = '$schema' "; if ( $result = $db->query($queryString) ){ while( $row = $result->fetch_assoc() ){ $datalen += $row["data_length"]; $indexlen += $row["index_length"]; } } } -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
