Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^2: Optimizing mysql and inserts

by gossamer (Sexton)
on Jul 11, 2012 at 19:51 UTC ( [id://981241]=note: print w/replies, xml ) Need Help??


in reply to Re: Optimizing mysql and inserts
in thread Optimizing mysql and inserts

I've commented out the "$dbh->do($sql);" in my code, and it's substantially faster. That is definitely the bottleneck.

...few minutes later, after a few trial runs...

I grabbed a my.cnf from a larger server and put it in place of the existing one, and it's magnitudes faster! Turns out it was in how mysql was configured.

I think it's much better now. I'm actually pretty proud of myself for this, and thanks for everyone's help as well!

Thanks,
Alex

Replies are listed 'Best First'.
Re^3: Optimizing mysql and inserts
by huck (Prior) on Mar 15, 2017 at 02:47 UTC
Re^3: Optimizing mysql and inserts
by ruzam (Curate) on Jul 11, 2012 at 22:10 UTC

    Not that it's Perl related, but what kind of differences did you find in the my.cnf file?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://981241]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (6)
As of 2024-03-28 19:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found