Month: December 2011

  • List MySQL Table Space Consumption

    How much space is MySQL consuming? How do I find out which MySQL tables are the largest? Can I query MySQL to determine how much space it’s consuming? Try this to list the top 20 space offenders: SELECT engine, concat( table_schema, ‘.’, table_name ) table_name, concat( round( data_length / ( 1024 *1024 ) , 2 […]