Linux 4 All

Best Linux tricks source

This query will display both the total size and number of tables for each MySQL engine.

SELECT engine,ROUND(SUM(index_length+data_length)/1024/1024,2) AS 'size in MB',count(engine) FROM information_schema.tables GROUP BY engine;

Get MySQL queries using tcpdump arrow-right
Next post

arrow-left Display all of the FTP usernames and passwords in Plesk:
Previous post

Leave a Reply

Your email address will not be published. Required fields are marked *