MySQL Data Dumper

Traditional mysqldump is 2 times faster than MyDumper

Asked by George

Hello,

We need to dump et load a database each day.
This database has more than 200 tables and the biggest table has more than 7 Million lines.

Currently we use the "traditional" mysqldump to export data.
We have read some articles about MyDumper & MyLoader and benchmark are clear : MyDumper is incredibly fast.

But after test with 4, 8 and 32 thread, mysqldump is two times faster than MyDumper in each case.

Command is executed via SSH as root.
OS and Mysql are on RAID 1.
Databases are on RAID 10.
(All RAID are in the same machine)

Can you help to find why ?

MORE INFORMATIONS :
CPU : 4 x 6 Cores (Intel Xeon)
RAM : 192 Gb
MySQL : 5.1.61
OS : CentOS 6.3

Thanks,
George.

Question information

Language:
English Edit question
Status:
Answered
For:
MySQL Data Dumper Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Launchpad Janitor (janitor) said : 		#1

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Revision history for this message
George (george1) said : 		#2

I'm still having this problem!

----- Mail original -----
De: "Launchpad Janitor" <email address hidden>
À: <email address hidden>
Envoyé: Samedi 8 Septembre 2012 14:21:56
Objet: Re: [Question #206674]: Traditional mysqldump is 2 times faster than MyDumper

Your question #206674 on MySQL Data Dumper changed:
https://answers.launchpad.net/mydumper/+question/206674

    Status: Open => Expired

Launchpad Janitor expired the question:
This question was expired because it remained in the 'Open' state
without activity for the last 15 days.

--
If you're still having this problem, you can reopen your question either
by replying to this email or by going to the following page and
entering more information about your problem:
https://answers.launchpad.net/mydumper/+question/206674

You received this question notification because you asked the question.

Revision history for this message
Domas Mituzas (domas-mituzas) said : 		#3

mysqldump relies on server performance, if you have scalability issues on your server, then they may affect mydumper operation.

Revision history for this message
George (george1) said : 		#4

Hello Domas Mituzas,

This server is a MySQL server. Only MySQL is running (+ Samba and SSH).

We didn't start mysqldump and mydumper at the same time.
Just test mydumper with 4, 8 and 32 thread. And going back to mysqldump.

It's a new server (July 2012) with 4 x 6 Cores and 192Gb RAM. We don't understand what can affect Mydumper performance.

Do we need some special edit in my.cnf for Mydumper ?

Can you help with this problem?

Provide an answer of your own, or ask George for more information if necessary.

To post a message you must log in.