[Taxidermista]

peterlaursen wrote on Sep 9 2005, 01:40 PM:

That is the problem, I believe.  A server configuration issue that re-negotiation of the connection for the execution of each insert is so slow.

Try a test: Export a subset of a database with about 100-500 KB of data in one insert statement import it again and see what happens.

Actually, if you use SQLyog for export you can have BULK insert statement or INDIVIDUAL insert statements.  I miss the option to choose a BULK size myself. The default BULK size is almost 5 MB and that is too much for my server configuration, and using INDIVIDUAL statements is slow.

[post=”7120″]<{POST_SNAPBACK}>[/post]

I'll do that, I'll try SQLyog backup and play with the bulk size option.

[Taxidermista]

Thanks anyway. I guess we are dealing with a really bad hosting here. Any suggestions about good hosting options are welcome (if it's not against the rules).

[Taxidermista]

Ritesh wrote on Sep 9 2005, 12:49 PM:

Are your SQL dump as BULK INSERTS or INDIVIDUAL INSERTs?

Can you try importing the dump from the mysql command line tool?

[post=”7116″]<{POST_SNAPBACK}>[/post]

They are indivual inserts. Small tables upload with phpMyAdmin go fast, I don't know nothing about mysql command line tools. 🙁

[Taxidermista]

Ritesh wrote on Sep 9 2005, 12:32 PM:

Very strange that its so slow on a direct connection. Do you find any sluggishness with other options?

Nope, and ftp upload is fast, 32 KB/s sustained.

Quote:

BTW, whats your connection speed?

[post=”7114″]<{POST_SNAPBACK}>[/post]

DSL 1024/380, typical spaniard “broadband”. 😆

[Taxidermista]

Ritesh wrote on Sep 9 2005, 05:59 AM:

Are you using HTTP Tunneling or Direct Connection?

[post=”7110″]<{POST_SNAPBACK}>[/post]

Direct connection.

peterlaursen wrote on Sep 9 2005, 07:02 AM:

To me it sounds like the server is overloaded! Or just badly configured!

I have experienced write speed at my webhost at 6-8 KB/sec but not as low as 2  🙁

Sometimes load varies a lot  depending on time of day or week.

BTW: How do the insert statements look like?

If there is one statement for each row, it can be MUCH slower than if the statements are longer.  No matter … there is not much you can do about it this time.

[post=”7111″]<{POST_SNAPBACK}>[/post]

Yes, one for row. The server is dedicated (or this is what they said, who knows…) and the forum is obviously down right now so no reason for overloading.

I'll try later some SQLyog-only backup/restore operations to see what happens.

[Author]

Posts