Archive for category: Software Tricks

Monitor MySQL Processes on Amazon RDS Every Second

Monitor MySQL Processes on Amazon RDS Every Second

Do you run long MySQL queries? Do you want to know what your Amazon RDS database is really doing? With this one easy command, monitor processes on MySQL Amazon RDS (or any MySQL database) just like the “top” command for linux: mysqladmin –host=your.unique.address.rds.amazonaws.com –user=root –password=yourPassword -i 1 processlist –verbose –host – The host […]

Read more

 

Customize Mass Emails with Gmail – Mail Merge Tutorial

Customize Mass Emails with Gmail – Mail Merge Tutorial

I day dream about a free, full-fledged Google CRM product native to Gmail. I’m closer now with the ability to send customized mass emails from Gmail. It’s not the “perfect mass email solution”, but it: Is Free Uses Gmail/Google Docs only Is Google Contacts friendly This tutorial is based off […]

Read more

 

Amazon S3 Log Analysis Made Simple With Excel

Amazon S3 Log Analysis Made Simple With Excel

It wasn’t straightforward finding an easy way to analyze my Amazon S3 logs. I unsuccessfully tried several instructions and services before arriving at the simple solution below. I looked into paid services like S3Log, S3STAT, and Qloudstat. I tried the free version of Qloudstat, until my logs quickly exceeded the “free” limit, […]

Read more

 

Delete Large Attachments in Gmail Without Deleting the Message

Delete Large Attachments in Gmail Without Deleting the Message

Update: Instructions verified through use as recently as 4/28/16 Gmail promises that you will never have to delete another email again. Yet the 7668 MB offered (as of today) in the free email accounts can easily fill-up over time if you send the occasionally large file. Sure you can search out […]

Read more

 

Paste Text Without the Style or Formatting

I copy and paste text constantly. And a lot of that text is formatted, meaning that it is colored, or bolded, or size 34, or an odd font etc. 99% of the time I want to paste the text only but a lot of text editors will retain the style […]

Read more