Technology
Database noob making changes and something goes wrong…
Recently, I answered a question on a forum site from a user who stated they were “database noobs”. They made a change and had a problem. Here’s the advice I gave: Performing an ALTER to change storage engines won’t make rows disappear. However, let me offer some advice since you said you’re ‘database noobs’ in [...]
plotto the office lottery pool iphone app
Update: 2011-08-27 – Price change to $.95! yes, just Ninety-Five cents! Rock out America! – Version 1.1 coming soon! – Also, there’s been some curiosity about data persistence in the app, so let me clear this up. All app data is stored on the phone using a SQLite database. No data is stored remotely and [...]
Book Review: Programming iOS 4
“Programming iOS 4″ by Matt Neuburg; O’Reilly Media Summary: Good book. Lots of background on Objective-C. Good for experienced programmers that are new to programming Objective-C and those needing review of the basics. Great for programmers new to iOS. I’ve just finished reading “Programming iOS 4″ by Matt Neuburg. It’s a book about programming Objective-C [...]
sunlightjs syntax highlighting is fun and awesome
sunlightjs syntax highlighting is fun and awesome. Thanks, Tommy! http://sunlightjs.com/
My favority BASH one-liners
Let me preface this post by saying, these are hacks. Neither the best or the only ways to achieve the desired results. But hey, if they work for me, they may work for you. Enjoy! ping -i 10 4.2.2.2 Send a ping request to an IP address once every 10 seconds. Why would I do [...]
Row Deletion MySQL Stored Procedure
Scenario: You’ve got a huge history table that’s getting too big to deal with. It’s grown out of your control and the application has an SLA of 100% uptime. What now? My solution: The answer is to archive rows off the system, then delete rows by primary key. DROP PROCEDURE IF EXISTS proc_delete_id_range_safe; DELIMITER $$ [...]
Why I won’t use HandlerSocket in Production…
There is a ton of hype around HandlerSocket right now. It looks awesomely wonderfully fast, fun and useful… however, I suspect there’s another side to the story. These are my notions gleaned from my limited knowledge and experimentation: HandlerSocket has some great use cases, but from a DBA perspective, it is a dangerous toy. 1.) [...]
Identifying InnoDB Foreign Key Constraints
When using InnoDB tables in MySQL, the option exists to apply foreign key constraints. Data modelers do this for various reasons, which I’m not going to explore here. What’s important is that these constraints are religion for DBAs (and client software) and have to be respected to maintain data integrity. Knowing the hierarchy of data [...]
Use BASH to extract MySQL ACL list
Need to quickly extract all the GRANT info for your database users? Here’s a one-liner: for i in $( mysql -u readuser -pReadPassword -h your.host -e “SELECT CONCAT(user,’@\”,host,’\”) AS ACL FROM mysql.user ORDER BY user” -s ); do mysql -u readuser -pReadPassword -h your.host -e “SHOW GRANTS FOR $i” -s ; done ; Here’s a [...]
