Category Archives: Other dbs

Huge Data -vs- The Database, how the industry is adapting in the face of the data explosion

Note This Article was actually written back in May after the UC at the request of Linux Magazine, through a series of events It went unpublished. Between then and now Jeremy ended up doing a great job covering most of … Continue reading

Posted in Matt, mysql, Other dbs, performance | Comments Off on Huge Data -vs- The Database, how the industry is adapting in the face of the data explosion

The Importance of solid historical LAMP Statistics

An often overlooked and way underrated component to any site is the collection and reporting of solid historical performance metrics.   Don’t get me wrong, everyone collects some sort of web page stats, has access to mysql status variables, and uses … Continue reading

Posted in Common Mistakes, mysql, Other dbs, performance | Comments Off on The Importance of solid historical LAMP Statistics

Capture DB2 long running SQL

DB2 (LUW) V8 and higher has a couple of things that annoy me when it comes to performance tuning. The first is the obtrusive nature of the event monitor. To guarantee you capture all the sql statements running in an … Continue reading

Posted in db2, Other dbs, performance, script | Comments Off on Capture DB2 long running SQL

Server Performance and the Database

I am cleaning out some old scripts and it got me thinking back to a time before I rejoined the ranks of consultant… to many different jobs and many different people. Why is it that some companies or “tech” people … Continue reading

Posted in hardware, Other dbs, performance, rant, script | Comments Off on Server Performance and the Database