It's possibly a DNS problem (reverse DNS exactly).
You know, I'm feeling a bit stupid here... That was indeed the problem,
as the new server hadn't been moved on DNS yet.
I put the IP address into the windows hosts file on the DB server, and
the problem cleared up immediately.
Thanks!
-Doug
It's possibly a DNS problem (reverse DNS exactly).
Best regards.
OK folks, I'm kind of stumped; looking into things a bit more, but
thought I'd hit the list and see if anyone had any suggestions for a
rock to look under, in case I'm missing it...
DB Server: Windows 2003, 8-way CPU, lots of RAM, MySQL 4.1.22-nt binary
from MySQL
Current Production web server:
I am using 3.23.58 (server and client) on FreeBSD 5.2-RC1 and all of what
I am about to describe is being performed locally.
When importing dumped data (with something like mysql dbname
dbname.dump) the import is being performed at ~60 queries a second. This
is MUCH slower than when I was
I have found that by dumping with --extended-insert, the subsequent import
is MUCH faster. Of course it only issues 450 odd queries for the data set
instead of ~200k...
-mike
[EMAIL PROTECTED]
12/23/03 05:02 PM
To
[EMAIL PROTECTED]
cc
Subject
Strange performance problem importing