Hi,
I'm running MySQL 3.23.51 on a Debian Linux server, and I've got a
performance question.
I have a perl application which builds up data in memory (in a hash) and
every 30 seconds forks and writes the data to a database. When both perl
script and MySQL server are on the same machine, the script manages to
finish writing to the database before the next child appears (*most* of
the time :-) ). However, if the script and MySQL server are on different
machines, separated by an uncongested 100 Mbs ethernet network, the
child always fails to write to the database within the 30 second window.
So, my questions are ...
* Is there a measure of the expected difference between these two
scenarios?
* Is there any explicit tuning which can be done to speed up access
over the network (short of adding gig-ethernet cards which isn't
likely) ?
The reason for not just leaving everything on the same machine is that
the expected growth over the next 6 months will mandate more than one
server to handle the incoming data, so the separation between script and
database engine is going to have to happen anyway.
Hopefully ...
Paul Wilson
Chime Communications Ltd
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
