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+.
MGM Grand Casino, Las Vegas - DrmCD
ОтветитьУдалитьMGM Grand Casino is 파주 출장샵 an MGM 군포 출장마사지 Resorts, 경상북도 출장샵 Nevada-based 김해 출장샵 casino with a total of 752 slot machines, 11 table games and a 부산광역 출장샵 poker room.