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
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
