-
What is this?
From advanced Bash tricks to Python gotchas to MySQL tutorials, this blog covers various topics in programming and systems administration. Find out how to get more done and have fun! Keep up with the latest by subscribing to the RSS feed!About the Author
This is the tech blog of Samuel Huckins. You can check out my homepage and other websites below, or send me a message here.-
-
Recent Posts
Post categories
Tags
Apache Apple Bash bookmarks CLI command database Desktop disk editor efficiency Excel filesystem firefox graph graphing hardware HTML information keyboard Launchy Linux logging migration Mobile monitoring MySQL PDF Programming putty Python Ruby scripting Security ssh subversion svn sysadmin Trac Ubuntu vim Vista web web applications WindowsBlogroll
Handy Links
My Sites
My del.icio.us
-
- Posts 191
- Words in Posts 69,962
- Comments 482
-
Category Archives: MySQL
Troubleshooting MySQL queries: a useful workflow
Configuring and optimizing MySQL servers, from the underlying hardware to the instance settings on up to the application queries, is a multi-faceted and complex process. Here I’d like to assume you’ve got a well-configured physical server (it’s at least functioning … Continue reading
Debugging bottlenecks with the MySQL Query Profiler
I was throughly pleased to discover the MySQL Query Profiler facility recently. Somehow I hadn’t heard about it (or recalled anyway) until now. In short it provides a very easy way to view how much time (down to the microsecond) … Continue reading
Tune MySQL like a pro with MySQLTuner
I came across MySQLTuner recently and was most pleasantly surprised. It’s a Perl script that only requires your MySQL user and password to provide detailed and useful checks of a running MySQL instance. First though, check out the awesome URL … Continue reading
Better access to MySQL create view statements
I’ve found that I often create several views that are variations on an initial one, providing a slightly different convenient slice of the data as the need arises. But when a view is created the syntax actually stored can be … Continue reading
Advanced ordering of MySQL results
MySQL’s “order by” keyword allows the order in which result rows are returned to be defined. This is quite useful in a wide variety of circumstances. You can specify any number of columns whose values you want to order the … Continue reading