Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2006
    Location
    Santa Cruz, California
    Posts
    391

    Networked MySQL Server

    I got some questions about dedicated mysql server.

    I read some things about compression used, should I give this a try?
    Image

    Any other tweaks? The current os is centos (The server is donated) I plan to switch to debian etch or freebsd 6.2

    I got my.cnf tweaked right for the 2gb of ram I think but seems alittle slower then when it was on localhost, I was thinking dedicated mysql server would be quicker, its slow enough that my light weight mysql pages are running much slower

    As for the 100mbit line, what else do you guys run? I'm thinking of going to 1000mbit so I'd get about 200mbps atleast, any better way?
    [email protected]
    www.xenserv.com Your High Performance Hosting Specialists - Try the Xen Experience Today!
    http://uploadpla.net - My free Media hosting site.

  2. #2
    Join Date
    Jul 2002
    Location
    Kolding, Denmark
    Posts
    292
    Quote Originally Posted by cmanns View Post
    I got some questions about dedicated mysql server.

    I read some things about compression used, should I give this a try?
    Image
    That would probably be a good idea, assuming that both servers have sufficient CPU ressources available for compression/decompression.

    Any other tweaks? The current os is centos (The server is donated) I plan to switch to debian etch or freebsd 6.2

    I got my.cnf tweaked right for the 2gb of ram I think but seems alittle slower then when it was on localhost, I was thinking dedicated mysql server would be quicker, its slow enough that my light weight mysql pages are running much slower

    As for the 100mbit line, what else do you guys run? I'm thinking of going to 1000mbit so I'd get about 200mbps atleast, any better way?
    You have to remember that suddenly network latency comes into play. Connecting to a socket on localhost is faster than creating a connection through a couple of NIC's and a switch, and while a gigabit network will help, it cannot solve the problem entirely.

    Using persistent connections (if possible) may also help somewhat but look out for unused, stale connections; they may use valuable RAM and negate the advantage of using them.

    Note that persistent connections are next to useless if your webserver has keepalive set to "Off" since the information about the connection is discarded (on the webserver) when the apache thread is killed. Only MySQL queries executed within the same page will benefit from persistent connections in that case.

    If you use FastCGI I think that the persistent connections are stored within the FastCGI thread but I'm not sure.
    Best regards,

    Anders C. Madsen
    Golden Planet Support - http://www.goldenplanet.com

  3. #3
    Join Date
    Jan 2006
    Location
    Santa Cruz, California
    Posts
    391
    I'm using fastcgi & lighttpd

    Anything I should tune on the server so it'll handle the network connections better? It's not doing anything else then mysql atm, we're getting the gigabit soon too.
    [email protected]
    www.xenserv.com Your High Performance Hosting Specialists - Try the Xen Experience Today!
    http://uploadpla.net - My free Media hosting site.

  4. #4
    Join Date
    Jul 2002
    Location
    Kolding, Denmark
    Posts
    292
    I would wait for the gigabit and see if there is any need for further tuning of the network.

    I would try using persistent connections but again: Keep an eye out for stale connections, they tend to build up over time. Reduce the MySQL timeout to e.g. 120 seconds or so if needed (meaning that unused MySQL connections are killed af 120 seconds of inactivity.
    Best regards,

    Anders C. Madsen
    Golden Planet Support - http://www.goldenplanet.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •