Home  |  Contact Us  |  Order Form  |  Shopping Cart  |  Need Help? Call 800-788-4085
Search

SE Network Plus client experiences slow performance (Mac OS X server)

Server Operating System: Mac OS X

Note: If you are experiencing slow performance when a Windows computer is hosting the SE Network Plus server software, see SE Network Plus client experiences slow performance (Windows server).

SE Versions: SE 2.1 Network Plus

Symptoms:
Customers using the SE Network Plus client software experience noticeable latency, network lag, or overall slow performance. Some client computers may have acceptable response, while most experience slow response.

Solution:
The problem is due to DNS resolution errors in MySQL, the database management system that SE Network Plus uses. Performance suffers because SE is trying to do name resolution of the clients. Perform the following steps to turn off name resolution on the Mac OS X server:

  1. From the Mac OS X server, go to the /Applications/Utilities folder, and double-click Activity Monitor. The Activity Monitor window opens.
  2. Make sure All Processes is selected in the drop-down list in the upper-right corner of the window.
  3. Find and select mysqld in the list of processes, and click Quit Process.
  4. Click Force Quit, and then minimize the Activity Monitor window.
  5. Open the my.cnf file with a text editor such as TextEdit. The my.cnf file is located in the /Applications/RNSENetworkPlus/RNSEServer/ServerFiles folder.
  6. Add the skip-name-resolve command in the Server Section of the my.cnf file as shown below:

    # SERVER SECTION
    # ----------------------------------------------------------------------
    #
    #The following options will be read by the MySQL Server. Make sure that you
    #have installed the server correctly (see above) so it reads this
    #file.
    #
    [mysqld]
    # The TCP/IP Port the MySQL Server will listen on port=23460
    socket=/tmp/rnsemysql.sock

    skip-name-resolve

    #Path to installation directory. All paths are usually resolved relative to this.
    #basedir=
         
    #Path to the database root
    #datadir=

    Note: If you are using v2.1.1 or later, the skip-name-resolve command is already in the my.cnf file (it should be at the end of the file), but it is marked as a comment with the # symbol. To enable the skip-name-resolve command, just delete the # symbol at the beginning of that line.
  7. Save the my.cnf file.
     
  8. Reboot the server.
  9. Test the client computers that you know were experiencing slow response. The problem should be resolved.