-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Kevin Burton wrote: > It seems strange that long_query_time is seconds based. I'm trying to > get most of our queries down to sub second time. > > 1 second is WAY too long. I'd ideally like 500ms. > > Can you specify .5 for long_query_time? Doesn't seem to be working the > way I'd hoped....... > > Kevin >
Kevin, (you probably already know this, but I'm posting it anyways). Since you're using JDBC, you can log the slow queries on the client, which will also log the location in your code where they happened. The two properties you want are: logSlowQueries=true slowQueryThresholdMillis=n (where n is the number of milliseconds that should pass to trigger a slow query being logged). This only exists in C/J 3.1.x and newer, but it'd be pretty darn easy to hack it into C/J 3.0 if you wanted to stick some code in Connection.execSQL(). -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Connectivity www.mysql.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCf8i9tvXNTca6JD8RAmdBAJwK+7+tezeu6LBQMNpJV6NxFwHf6QCeM85c LK2w4G1jy8kaRRSRRAeo4i8= =u3C2 -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]