[MTOS-dev] Queries on Very Large Tables

[Kevin Shay]

At 4:08 PM -0300 5/12/08, Mark Carey wrote:
>On Mon, May 12, 2008 at 3:27 PM, Timothy Appnel <tim at appnel.com> wrote:
>  > Have you tried that query with just a load? Not sure this matters
>>  either, but what database back end are they using? <tim/>
>
>Okay, just tried it: 37 seconds, so pretty much the same.
>
>The db is MySQL - 4.1.20.
>
>On Mon, May 12, 2008 at 3:29 PM, David Scott <ds94103 at earthlink.net> wrote:
>  > Do you have command-line access to the database machine so that you can
>>  profile the query?
>
>I do, but I am not sure exactly what the query looks like that is
>submitted via MT and D::OD.

If you turn on MySQL's slow query logging, you should be able to see 
the actual query in the log file:

http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html

--Kevin