Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mongodb hanging on 1 million rows #37

Open
deeTEEcee opened this issue Nov 30, 2017 · 5 comments
Open

mongodb hanging on 1 million rows #37

deeTEEcee opened this issue Nov 30, 2017 · 5 comments

Comments

@deeTEEcee
Copy link

trying to insert 1 million rows into mongodb but it hangs

@emirozer
Copy link
Owner

hmm, okay I guess at the time of developing this tool i did not consider huge inserts.
Merely chunking the data for multi insert should make it not hang but its just a gut feeling.
I will take a look in the upcoming days.

@deeTEEcee
Copy link
Author

haha no problem. my use case right now is im trying to figure out how to handle mass deletion and how i should split it into different jobs, how long it takes to delete x records. just researching here and there for that.

@JacobHZ
Copy link

JacobHZ commented Apr 13, 2018

I also have this problem,when use mysql and insert 30000rows,log appears "Lost connection to MySQL server at '127.0.0.1:3306', system error: 32 Broken pipe".

@emirozer
Copy link
Owner

Ok for 30k rows this should absolutely not happen. I can investigate this in the coming week.
@JacobHZ would you mind sharing your system details (os / mem / python version)

@JacobHZ
Copy link

JacobHZ commented Apr 16, 2018

@emirozer
system details:
macOS High Sierra 10.13.4
memory:8GB 1600 MHz DDR3
python version:3.6.0
mysql version: mysql Ver 14.14 Distrib 5.7.21, for osx10.13 (x86_64) using EditLine wrapper
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants