Tags » Scripting
Like many people tasked with managing OS X/macOS machines, I use VMware Fusion to do a lot of testing. Fusion enables me to test in various versions of OS X, and to easily make changes and revert to a prior state. 1,050 more words
Ever wanted to just look at QPS in real time while logged into your server?
Well here’s a little command line hackery to do it quick and dirty. 89 more words
This only works if you’re using innodb_file_per_table.
Purpose: import this csv quickly into google sheets (or other spreadsheet) and compare MySQL’s internal data size to the container size on disk to determine tables needing to be optimized (or “null altered”) to reclaim disk space and maybe increase performance due to defragmentation. 134 more words