Tag Archives: Linux

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: , , ,

How to rebuild Ubuntu package from the sources

There are two ways (at least) to rebuild Ubuntu package from the source. Using Ubuntu diff file and dpkg-buildpackage Download source from Ubuntu repository. Download Ubuntu diff file and apply it: patch -p1 < ubuntu.diff Build package: dpkg-buildpackage -rfakeroot Using .dsc file and debuild Download .dsc file Run following command: dpkg-source -x file.dsc Note, sometimes… 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