Slow Upload Speed

[jack111]

Executed the same sql script with webmin via the upload option in less the 4 minutes.

If I had used SQLYOG it woud have taken 2 hours. This seems to apply for navicat as well.

Anybody any ideas

[peterlaursen]

What are the INSERT statements like in your file? Single-row inserts for bulk inserts?

Basically you should use as large BULK inserts as your configuration allows for.

Was that the issue?

[jack111]

Hi

thanks for the reply.

have tried with both bulk and single row inserts does not make much of a difference. Though with single insers the file size is much bigger thus will take longer.

issue is the slow speed taken to execute sql scripts.

While I can take any sql file of size say 4mb and execute it via webmin via uploading on my mysql database in less than 10 minutes max usually takes about 5 minutes. With sqlyog or navicat it takes about 2 hours.

donot understand what is going on

[peterlaursen]

webmin uploads from local hard-disk

sqlyog sends over network.

and this: “Have a upload speed of about 400kb/s …” does not mean that the server or remote network lets you transfer data to MySQL at that rate.

Basically this is a configuration issue on the server/the remote network.

What sort of hosting are we talking about?

How do you connect?

[jack111]

The server is a dedicated server with a 100mbps connection to a internet backbone.

My broadband connection is 10mbps download and 384Kbps upload.

connect using tunelling via SSH when using sqlyog.

do you know where I set it so that i can allow a faster upload

I think it might be a configuring OPENSSH to allow faster uploads

thanks

[Monte]

I'm having the same problem too.

[peterlaursen]

@Monte

Please explain the problem more in detail, and please inform about the program version and connection method!

But most likely this is a server/remote network configuration/resource issue.  The remote host simply only 'absorbs' the data in that rate.  Wioth my personal (cheap) ISP I sometimes have to accept transfer reate of around 10 kbit/sec.  There are 200/ (or 2000?) more users on the same server …  

[Monte]

Sorry it took me so long to get back. I have V-Bulletin, SQLyog 5.21. Thanks. I'm having another another problem on it but I'll start a new thread; deals with an error message.

peterlaursen wrote on Jan 10 2007, 09:00 PM:

@Monte

Please explain the problem more in detail, and please inform about the program version and connection method!

But most likely this is a server/remote network configuration/resource issue.  The remote host simply only 'absorbs' the data in that rate.  Wioth my personal (cheap) ISP I sometimes have to accept transfer reate of around 10 kbit/sec.  There are 200/ (or 2000?) more users on the same server …  

[Author]

Posts