Re: Mysql into outfile problem

[Machiel Richards]

I have checked now and there is nothing in the Slow logs.




On 19/02/2014 15:33, Johan De Meersman wrote:

----- Original Message -----

From: "Machiel Richards" <machiel.richa...@gmail.com>
Subject: Mysql into outfile problem

              - when we run an explain on the query it shows that it is
using indexes and the amount of rows it accesses is about 165000 rows
out of a 90mil+ rows table

Not too bad, in and of itself, but explain only gives an estimate, and the 
actual query plan could potentially differ a lot. Have a look at 
https://dev.mysql.com/doc/refman/5.5/en/show-profile.html for some more 
performance debugging tools. If your query ends up in the slowlog (or you can 
turn on the general log for a moment), you can also look at Percona Toolkit 
(pt-query-digest etc) for some more toys.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql