tap-mysql is very very slow in pulling data. It is taking more than 10 min to pull 1 million records. Whereas if i write my own python code , it takes 30-40 second for 1 million record. Can anyone tell me what is the issue ?

What command takes 10 min / 1 million records?

meltano tap-postgres > out

? If so then you know it's the tap that's slow, then I think you have to look at why it's slow so I'd open up a profiler https://sdk.meltano.com/en/latest/dev_guide.html#testing-performance