Scotch Box is a preconfigured Vagrant Box with a full array of LAMP Stack features to get you up and running with Vagrant in no time.
#mysql
MySQLTuner
Awesome perl script for getting tuning/optimization suggestions for a MySQL server.
My Development Setup/Flow
Developers seem to love to hear about how other developers work, so I thought I’d try to capture my entire environment, from end to end, in a single post. This will change (has changed) over time and depending on the project/company/whatever, but this is how things are for me right now. A couple of points up front:
- I work for Automattic, so a lot of this is influenced by our internal policies/security/workflow.
- I don’t always use all components of this “system”. I’ll try to detail when I do/don’t use certain parts of it as I go.
OK, here goes.
Note: This turned into a little bit of a summary of how we work internally at Automattic as well. Oh well, maybe it’ll provide some inspiration, I think we do some pretty cool things.
MySQLTuner.pl
Perl script that scans a MySQL install and suggests different settings that might be more optimized for its load profile.
Search and Replace for WordPress Databases
Search and Replace for WordPress Databases
Script that allows you to search/replace values in your WP database, even within serialized strings.
Real World Web: Performance & Scalability
Real World Web: Performance & Scalability
Awesome (and very long) slideshow on all sorts of scalability and performance techniques for massive websites/services.
TightURL Project Page
“TightURL takes a very long URL as input, and returns a very short URL within the TightURL namespace.”
Storing Hierarchical Data in a Database
Storing Hierarchical Data in a Database
Tutorial/summary of some different approaches to storing hierarchical information in a database.
Maatkit
“A toolkit that provides advanced functionality for MySQL”
Querious
“Viewing, searching, editing, importing, exporting, and structuring your data has never been so easy. With Querious, you can even open up raw CSV or Tab files in a spreadsheet-like document. Need to rename or reorder the columns? No problem. Searching for data is a breeze, and you can even convert the whole file to another format in a snap.”