Friday, October 10, 2014

50 State Coins updated to version 1.6

Category: Reference
Released: Jul 27, 2012
Updated: Oct 10, 2014
Version: 1.6
Size: 16.2 MB
Language: English
Seller: Ivan Klishch
iTunes link: 50 State Coins

'50 State Coins' application has been updated to version 1.6

This version contains some fixes and improvements, including:
New 2014 Quarters from "America the Beautiful Quarters" collection!
✔ added iOS 8 support

To see full list of features go to application page.

Friday, February 07, 2014

Backup script for all SmugMug albums and photos

It's a really small script to make a backup of all photos from SmugMug
Configuration of this script is easy, just change 3 variables in PHP:

To read more go to script page on Github

Friday, January 31, 2014

Killing Long-Running MySQL Processes

Killing long running MySQL queries is easy. There is KILL command

where PROCESS_ID is an ID from SHOW PROCESSLIST command. I have created small PHP script to kill all long running processes using RegExp.

You can checkout it from my Github:

Just change $host, $user and $password to access your MySQL server, and add regexp that matches your query.

Change $minExecutionTimeToKill to minimum number of seconds that query should be running before killing.

To run simply execute:

$ php ./kill.php

View on Github