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 tables/options to get more speed, and, it's better to use --opt. "Anil Doppalapudi" <[EMAIL PROTECTED]> wrote: > mysqldump running very slow. what might be the reason > > Server details > =============== > > Dell > RAM : 4 GB > Innodb_buffer_pool_size : 1000MB > > i am using --quick option in mysqldump > > Thanks > Anil > DBA > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
