jbmurphy.com – Page 31 – Tech ramblings by Jeffrey B. Murphy

Command to show all MySQL databases and their sizes

I found this MySQL query to list all DBs and their sizes here. I wanted to blog it, so it is easier for me to find.

mysql -e 'SELECT table_schema AS "Database name", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema;'

mysql command to show a table’s column names <- Why can't i remember this?

It is easy enough. Why can’t I remember this -> show columns from table name;

Just learned about /etc/resolver in OSX/BSD

I just learned that OSX/BSD has “conditional DNS” built into the os! Thanks to this post.

I wish I knew about this earlier! AND I wish the same thing existed for Windows machines!

Quick PowerShell script to “tail -f” dhcp logs

When I am working in Linux, I like to leave a log open with “tail -f”, so I can see the results of some test I am performing.

The other day I wanted to see when a new machine joined the network, so I could give it a static DHCP lease. Usually I connect to the DHCP server find the DHCP logs and open them in notepad. I finally wrote a quick script to “tail -f dhcp.log” in PowerShell.

function JBM-AD-GetDHCPLogs {
 PARAM($ServerName="dhcpServerName")
 $FileName="DhcpSrvLog-$(get-date -format ddd).log"
 $PATH="\\$ServerName\c$\Windows\System32\dhcp\$FileName"
 Get-Content $path –Wait
 }