-----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]

Reply via email to