Separate Database Server
Posted: Sun Nov 09, 2014 9:17 pm
I installed 1.25.0 on a debian server (no X). I have an instance of mysql on another machine so I used zmhost to point it there. I altered the tables to use the InnoDB engine.
The performance is poor. Perhaps 10 seconds to paint an options popup window.
If I point it to the local mysql instance the time goes down to about 1-2 seconds.
Everything is terribly sluggish when I use the remote database.
Is this normal? I've got a pair of 3.5ghz machines, both with 8gb of memory and on a gigabit network, mysql versions are the same.
The performance is poor. Perhaps 10 seconds to paint an options popup window.
If I point it to the local mysql instance the time goes down to about 1-2 seconds.
Everything is terribly sluggish when I use the remote database.
Is this normal? I've got a pair of 3.5ghz machines, both with 8gb of memory and on a gigabit network, mysql versions are the same.