Поиск по этому блогу

суббота, 20 января 2018 г.

Comparing mydumper vs pure mysqldump

Today I tested mydumper.
It showed very cool results, see below.
Data size + index size is 9054MB. Here is timing of dumping/restoring the same database using mydumper vs mysqldump.
     |  mysqldump/restore dump |mydumper/loader
dump   | real    1m36.642s     |real    0m49.342s
restore| real    32m32.732s     |real    20m32.215s

Also during compilation I faced with issue:
mydumper.c:2814: error: ‘MYSQL_TYPE_JSON’ undeclared (first use in this function)
mydumper.c:2814: error: (Each undeclared identifier is reported only once
mydumper.c:2814: error: for each function it appears in.)
make[2]: *** [CMakeFiles/mydumper/mydumper.c.o] Error 1
make[1]: *** [CMakeFiles/mydumper/all] Error 2
make: *** [all] Error 2
Probably because I am using Percoan 5.6 dev package and JSON data type was introduced only in 5.7. I have commented 2 lines with the 
./mydumper.c: /* if (fields[i].type == MYSQL_TYPE_JSON) g_string_append(statement_row, "CONVERT("); */

./mydumper.c: /* if (fields[i].type == MYSQL_TYPE_JSON) g_string_append(statement_row, " USING UTF8MB4)"); */
I hope it will not affect me unless I am using 5.7+.



1 комментарий: