Aleksey Midenkov
Aleksey Midenkov
@davidducos Sorry, I don't understand the example with concatenation. You can concatenate or cut out text from stream of course (but this is already *not easy*), that's not the point....
Related #1342
Also 0.15.1 is very old version. There was many bugfixes since then.
@davidducos `--compact` is not default in `mysqldump` (at least in MariaDB 10.4.32) I dumped without compact [1.sql](https://gist.github.com/midenok/92b7578fcd623845938acadc3f0ae98d#file-1-sql), with compact [2.sql](https://gist.github.com/midenok/92b7578fcd623845938acadc3f0ae98d#file-2-sql) and made diff [1-2.sql](https://gist.github.com/midenok/92b7578fcd623845938acadc3f0ae98d#file-1-2-diff) Man page says: ``` Produce more...
@davidducos I doubt `--compact` is good feature in terabyte world. When it was made in mysqldump I guess HDD was less than 1Gb. I remember the times when I cleaned...
Probably fixed in 0248d401f7ac98577a81aa4586cdc1fef319483a (see "Sporadic db switch failed fix" part)
The above example has only one index, integer key. Defer cannot help here, but OTOH has negative performance impact due to extra queuing. Maybe it should be disabled by default...
I hope commit message explains it: ``` Improve mydumper parallelism: integer sharding deferrer Integer PK is the only PK that allows parallelized sharding on mydumper. Non-integer PK tables utilize only...
This reproduction you mentioned does not create PK: ``` sysbench /usr/share/sysbench/oltp_write_only.lua --table-size=10000000 --tables=1 --threads=1 --mysql-user=root --mysql-db=sbtest --rate=10 --time=0 --report-interval=10 --create_secondary=off prepare ```
Just please build x64 version without the above long task list. It says: > Could not load component "foo_spider_monkey_panel.fb2k-component": This component was built for a different processor architecture.  I...