I have my dump file already automatically generated by something like: mysqldump my_db > db-dump-file.sql Workstation B: avg-cpu: %user %nice %system %iowait %steal %idle Server A: avg-cpu: %user %nice %system %iowait %steal %idleĭevice: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await r_await w_await svctm %util My import command: pv sql/master.sql | mysql -h'localhost' -u'root' -p'root' 'master' The big question is: How can the performance be factor 53 slower? I can not work like this :-( I already removed all databases on my workstation - no difference. I switched yesterday to MariaDB on my workstation - but before MariaDB the stats were even worse. The mysql/maria config is the stock config. I have an SQL dump, it's pretty big (411 MB) and it took 10 minutes to import on server A, the same import on my workstation B has an estimate (pipeviewer) of 8 hours to import (it imported 31 MB in 40 minutes)ġ core QEMU Virtual CPU version 1.0 - cpu MHz: 3400.020
0 kommentar(er)
