Running mysqldump without piping to file such as:

mysqldump -u root -pPASS db  

is really slow on windows. If I do

mysqldump -u root -pPASS db > db.sql 

it runs fast.

This might not seem like a big deal as I can always pipe to a file. BUT I am using mysqldump from a script and I just want the raw output so I don’t have to load the file in memory or save a temp file.

Linux and Mac there is NOT a difference if I pipe it to a file or just let it output.

Is there a way to fix this? This is for mysql 5.6.x

The full command I run is:

mysqldump --user=$  db_username --password=$  db_password --tz-utc=false --single-transaction --routines --triggers db 

but I have tried a lot of combos and nothing makes it fast.