MySQL Forums
Forum List  »  Backup

MySQLDump slow when target is a windows share
Posted by: Nickolai Nielsen
Date: June 28, 2010 04:00PM

Hi

I have a very strage issue.

i have an client/server application thats uses MySql, this app has over 100 installations.

One one site i expirience a very slow performance when dumping data from mysql back to the a server share.

The setup is a central server with file share and a MySQL database.
the app runs on the client, and the client run mysqldump for backup, and this dump uses the result switch with the target being a share on the server.
Normally this setup runs very smooth.
Database dump size is 1,2gb and around 100 tables with a few of them taking 90%

1. When dumping from server via client to server share: 300 kb/s
2. When dumping on server to server disk: 30 mb/s
3. When dumping from server to client disk: 30 mb/s

option 2 and 3 is not usable in normal day to day operation.

a normal filecopy of a 1,2gb file runs at 40-50 mb/s
a filecopy both ways at the same times runs at 20 mb/s per file.

network switch and network card in the server have been changed, 2 different clients have been testet.

any good ideas on where to go from here?

btw server runs windows 2008, client 1 windows 7, client 2 windows xp.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQLDump slow when target is a windows share
3472
June 28, 2010 04:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.