NYCPHP Meetup

[Daniel Convissor]

Hey Hans:

One possible thing could be the slow log.  Do you have it turned on?  If 
you do, large extended inserts will land in the slow query log, slowing 
down the whole insert process.

My workaround is before making my dump, create the file with a query at 
the top that extends the setting for long queries.

    echo "SET @@session.long_query_time = 3600;" > ~/$name.sql

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409