http://ticean.com explore. create. destroy. improve. Wed, 03 Mar 2010 17:13:04 +0000 http://backend.userland.com/rss092 en If you need to quickly optimize ALL tables in a mysql instance this simple command will optimize everything. mysqlcheck --optimize -A http://ticean.com/2010/03/03/optimize-all-mysql-tables/ 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 http://ticean.com/2010/03/02/clear-mysql-query-cache-without-a-restart/ 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 ... http://ticean.com/2009/07/10/coding-at-extreme-altitude/ 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 ... http://ticean.com/2009/04/16/expeditionsticeancom/ 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 = ... http://ticean.com/2009/04/15/easy-javascript-to-restrict-textbox-input/ There's plenty of information available on the interwebs for backing up a local directory to Amazon S3. For home and light file sharing use, I'd highly recommend Jungle Disk. I use it at my corporate office and I have to say that it has been better & faster than the ... http://ticean.com/2009/02/17/syncing-backup-from-amazon-s3/ 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: http://ticean.com/2009/02/02/all-base-are-belong-to-nannerpuss/ 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.     ... http://ticean.com/2009/01/31/call-me-scientist-facebook-connected/ 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 ... http://ticean.com/2009/01/30/recursive-file-lowercasing-moving-files-from-windows-to-linux/ 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 ... http://ticean.com/2009/01/30/best-hack-ever-roadside-zombies/