INFORMATION_SCHEMA is usually the place to go when
you want to get facts about a system (how many tables do we have?
what are the 10 largest tables? What is data size and index size
for table t?, etc). However it is also quite common that such
queries are very slow and create lots of I/O load. Here is a tip
to avoid theses hassles: set
This is a topic we already talked about, but given the number of systems suffering from …[Read more...]