MySQL Forums
Forum List  »  Backup

mysqldump slower on 5.6 ?
Posted by: Christian Richter
Date: March 30, 2015 08:59AM


i recently updated from 5.5 to 5.6
I have 500 databases to dump, about 30gigs in total.
with 5.5 i took about 11 hours to complete the dumps, with 5.6 it takes +8 hours.
what i'm doing wrong?

my backup string:
$mysqldump --user=$USER --password=$PASS --host=$SERVER --default-character-set=utf8 $datenbank > $datenbank.$(date +%Y.%m.%d).sql

read from 8 disk hardware raid and dump to single SSD

all tables are myisam


Options: ReplyQuote

Written By
mysqldump slower on 5.6 ?
March 30, 2015 08:59AM
April 01, 2015 03:33PM

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.