Tag Archives: mysql

How to get size of Mysql tables

In the previous post I wrote about a way to get a Mysql database size from Mysql shell. Now I’d like to share a way to get size of each Mysql table: SELECT table_name,`engine` ,ROUND(data_length/1024/1024/1024,2) total_size_gb, ROUND(index_length/1024/1024/1024,2) total_index_size_gb, table_rows FROM information_schema.TABLES WHERE table_schema = ‘rt3’; It’s useful if you need to know what you should… Continue reading →

Tags: , , ,

Log for Mysql console session

To log Mysql console session use option –tee (two dashes!) with full path to the log file: mysql -uroot my_db –tee=/tmp/mysql_console.log As result the file /tmp/mysql_console.log will contains all commands and queries with result of their executions. That might be helpful to keep your queries for using next time or for troubleshooting. The author of… Continue reading →

Tags: , , ,

Get Adobe Flash player