Tuesday, April 14, 2015

What is time really?

Setting your virtual machine's time by syncing with the host is usually a no no. Here is a powercli script to look up what VMs are syncing time with the host.

get-view -viewtype virtualmachine -Filter @{'Config.Tools.SyncTimeWithHost'='True'} | select name


Name ---- fileserver1 domaincontroller2 proxy remotedesktop printserver1

Thursday, April 9, 2015

optimize mysql and mariadb

Both of these scripts are great tools that can help you optimize the performance of your mysql or mariadb database. Take their recommendations with a grain of salt. It's a great place to start when digging into database performance issues.

MySQLTuner-perl
https://raw.github.com/major/MySQLTuner-perl/master/mysqltuner.pl

tuning primer
http://www.day32.com/MySQL/tuning-primer.sh