Posted 20 April 2012 - 02:31 AM
Posted 20 April 2012 - 04:50 AM
1) SQLyog(Help->About) and MySQL version(SELECT VERSION())
2) What type of connection(Direct/HTTP/SSH)?
3) Are you using Execute SQL script tool to upload SQL file? How big is the file?
Is the .SQL generated with SQLyog and if yes how is BULK settings?
Posted 20 April 2012 - 12:11 PM
2 - Tried MySQL (which I assume is what you mean be Direct) and SSH. There's no noticeable difference.
3 - Yes, Execute SQL. It doesn't matter how big it is. If it is a small file (less than 5 - 10 MB) I will generally use phpmyadmin on the server but I tried a 3 MB file just now and after a minute it had uploaded 5%. I tried a large file (100 MB) and after several minutes it was still at 0%. Yes, the file is created with SQLYog. I tried it with the create buld statements on and off and with the chunk setting on and off. No difference at all with any of the changes,that I can see.
Posted 20 April 2012 - 01:35 PM
Maybe also you could tell if you have binlogging enabled on the server with a "sync_binlog = 1" setting?
Posted 20 April 2012 - 06:24 PM
Posted 23 April 2012 - 07:12 AM
But most likely this is a server/remote network configuration issue. The remote host only absorbs the data in that rate. If you try importing from MySQL command line client the result would be the same(http://dev.mysql.com...h-commands.html).
Posted 23 April 2012 - 02:30 PM
Posted 25 April 2012 - 12:16 PM
Actually what happens inside SQLyog here is very little. It will be waiting for the 'go' from the server most of the time (for each statement). And if the server executes slowly or communication over the MySQL protocol to/from this server is slow this may be the problem. What kind of server is this? Is it some kind of 'shared hosting´?
You will need to compare with another client installed on same host/machine as SQLyog. For instance the 'mysql' command line client with the 'source' statement.
Alternatively you can let us try. We will then need to be able to connect. In that case please mail to support@webyog com with connection details and explain us how to reproduce this - including attaching the script.
Posted 27 April 2012 - 03:01 AM
In any event, I will setup a test account where you can see it yourself. I truly appreciate you offering to do this.
Posted 28 April 2012 - 04:40 PM
The quality of SQLyog is only topped by the excellent support of the people at SQLyog. I don't think I've ever dealt with a company that offers such excellent service.
Posted 29 April 2012 - 09:16 AM
With shared hosting some memory restriction/quota may be in place per user or per connection. That could explain why a BULK size equalling 'max_allowed_packet' setting does not work well on this environment.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users