Category Archives: script

Logging all the queries with MySQL 5.0

Posted on January 28, 2009 by Yves Trudeau

With MySQL 5.1, getting and analyzing all the queries hitting the database is very easy even if you don’t have access to the MySQL enterprise Monitor.  You can either activate the general log or, my favourite option, activate the slow … Continue reading →

Posted in mysql, performance, script, yves | 4 Comments

Capture DB2 long running SQL

Posted on September 26, 2007 by Matthew Yonkovit

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

Server Performance and the Database

Posted on September 26, 2007 by Matthew Yonkovit

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

Interesting tool out there

Posted on September 13, 2007 by Matthew Yonkovit

http://www.fr3nd.net/projects/mysqlpdump/ This allows a mysqldump to be broken up into multiple files, and lets you multi-thread the dump process. Worth checking out!

Posted in links, mysql, script | 1 Comment