On 28 Oct 2004, at 12:48, Anil Doppalapudi wrote:
mysqldump running very slow. what might be the reason
[...]
I don't have specific knowledge of your database, so our answers will
be quite vague, but :
Try running with --opt. This produces a less readable outfile, but
produces one much more
Hi.
There are too many things to consider: the size of the table, the load average
of the server, the MySQL configuration, etc. If you could provide us with
much more details - we could check it out and make a guess what's the
bottleneck. Still, anyway you will probably need to optimize your
You won't get any reasonable answers like this. How big is your db? How long
does mysqldump actually take? If you tell this, people can tell you if this
is like expected or too slow. Good answers depend on good questions.
But a hint: You can't expect mysqldump to run in fractions of seconds.
[mailto:[EMAIL PROTECTED]
Sent: Thursday, October 28, 2004 8:13 PM
To: [EMAIL PROTECTED]
Subject: Re: Mysqldump very slow
You won't get any reasonable answers like this. How big is your db? How long
does mysqldump actually take? If you tell this, people can tell you if this
is like expected or too slow