Optimize All MySql Tables
If you need to quickly optimize ALL tables in a mysql instance this simple command will optimize everything.
mysqlcheck –optimize -A
Clear MySql Query Cache Without a Restart
So you’ve allocated some memory to cache your queries, but you need to clear the MySql query cache. You could do a MySql restart, but you probably don’t want to do that on a production server.
…so bust that cache with a query!
RESET QUERY CACHE
Coding at Extreme Altitude
For the last few days I’ve had my head in the sand working on a huge, but necessary undertaking. I’ve got a website that’s generating a large amount of traffic. It’s hosted on the MediaTemple (gs), and the (gs) can’t keep up.
I’ll have a lot more details in the next day or so, but things [...]
Expeditions.ticean.com
I’ve added a new site section to this site at expeditions.ticean.com. My family has been planning a backpacking trip on a segment of the Appalachian Trail. We’ll be hiking a 30 mile stretch, and with a party of 8, there’s quite a few logistics to iron out. The new project site is intended to [...]
Easy JavaScript to Restrict Textbox Input
Want to use JavaScript to restrict the characters that can be input on a textbox? It’s easy!
Here’s a very small function that will remove illegal characters, and replace spaces with hyphens. I used on a textfield that was used as part of a url.
Javascript:
restrictAlias = function(o){
var r = /[^A-Z|a-z|0-9|-]/g;
o.value = o.value.replace(’ [...]
Syncing Backup FROM Amazon S3
There’s plenty of information available on the interwebs for backing up a local directory to Amazon S3. But there’s not as much information if you need to do the opposite, keep a local directory synced with S3 without the forward sync present. I figured out a simple way to do it, using a Ruby script, S3Sync.
All My Base Are Belong to Nannerpuss!
Everybody’s voting and reporting today on which Super Bowl ad was their favorite. I think the showing was pretty strong this year. Most of the ads were good. But there was one standout among the crowd…
Nothing compared with Nannerpuss, 8 seconds of WTF just happened:
Call Me “Scientist” – Facebook Connected
Awww jeah! Looks like I’ve got my own app up on Facebook now, and I am making a post to myself, from myself.
Don’t be jealous. If you are, you can log in with your Facebook account and tell me about it.
Don’t be jealous. If you are, you can log in with your Facebook account and tell me about it.
Recursive File Lowercasing: Moving Files from Windows to Linux
I recently needed to recursively lowercase files and directories on a Linux server. The real task at hand was to move a bazillion files from a Windows server onto a Linux box. All the files were going to be placed on a webserver so the casing needed to be standardized. I looked all around to find a recursive script and found some, but through the task I found an easy way to do this.
Best Hack Ever – Roadside Zombies
Some pranksters in Austin, TX pulled off the best. prank. ever. They hijacked two electronic road signs, and tweaked them to display warning messages about Zombies. I love it. I’m surprised it didn’t cause accidents. I would have snorted hot coffee all over myself. Or maybe wrecked while reaching for my bug out bag. …read more
