Listing files in that one production network area with 1M+ files.
Top 10 largest files and folders
Top 30 largest files on this FS in MB
Top 30 largest files and folders on this FS, limited to 4 decent folders, in MB
Size of files matching pattern
Top 40 largest ZFS
Finding files in date range.
copying partition tables
Sending fast with mbuffer
Sending fastest with nc
Recieving (pulling) a zfs volume
Mount zpool by id
Top 30 processes using SWAP
cron to log cpu usage. Useful for shared host with alot of remote processes / batch jobs.
Watching for new tcp connections
Scan network for an open port
Checking for multiple MAC addresses on network
reviewing multicast addresses on host
Cipher and protocol enumerations
Virtual host certificate check
Certificate expiry check
Check deployed certificate
clear ldap user caching issue
select processes not sleeping
select processes running for more than 1 minute (time==60seconds)
Kill a users running queries
Purge binary logs older than 10 days minimum ideal retention.
Move Binlogs to free up space (dont copy large numbers limit to 10 oldest at a time)
Export to csv
Database size in MB
Skip binlog (prevent propagation of DDL i.e. long alter table/index statements)
Skip a replication error (duplicate keys, indexes)
Use mysqldump to create second slave replica backup. slave statement will be MySQL master. WARNING: IO thread will continue but slave thread will be stopped during mysqldump!
Fast DB restore (skip bin log)
Standby replication lag
Blocking processes queued
Blocked and blocking queries.
Blocking queries runtimes over 1min.
Show count of queries that are causing blocking.
Stop a blocking query.
Stop a blocking query that will not cancel.
Export to CSV