samba server slower than molasses using Access
FedoraForum.org - Fedora Support Forums and Community
Results 1 to 9 of 9
  1. #1
    Join Date
    May 2009
    Posts
    457
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    samba server slower than molasses using Access

    I installed a Linux server in a Windows shop in order to get Linux in the door and start by providing a STRONG backup plan for office files.
    The environment is that several office users have shared access to files and one manager also has his own private space.
    All users are members of a Linux group "smbusers" directly in the /etc/passwd file so the manager can play everywhere.

    I installed Samba on a brand new Linux box (2 cores) and we noted significant performance issues using Access files (a Windows DB manager).
    After reading many postings and net articles, I changed the samba configuration file. It may have improved things a little but the results are horrid.

    Below are my notes on performance and my smb.conf file (changing the user names for this note).
    My plan to get a Linux server helping out a small public service group have failed miserably (No good deed goes unpunished).
    Moving files to the server and back again seems fine, but using Access blows the whole thing.
    Perhaps the problem has to do with Access itself, but I am sure baffled. Any ideas to fix this would be vastly appreciated. Notes follow:
    ----
    We tested with a 95MByte Access DB trying to use.
    Attempting to open file and do a query using a Windows 10 box (up to date)
    The linux server is running fedora 29 and Samba (up to date) and is on a fixed IP locally.
    The net connection uses 100 MBit modem and the local internet is wired for same.
    Tests show linux box and windows boxes both have great net speed.

    File Location Opening the file open Access query
    on Windows box 1 second 4 seconds
    remote net server 1 second 1 second (using Dropbox)
    linux samba server 53 seconds 2-5 minutes (average 2, but sometimes quit after 5)

    Note that the Windows box and the linux box are on the same subnet (and router box)
    and the remote net file storage service is somewhere else on a file server which
    is just a paid for service. We wanted the linux server as we hoped it would be fast
    and provide local STRONG backup potential (use "dump" to save to 2TB USB disk).

    --- smb.conf as now configured is below
    many params are the default configurations but I wanted to be sure what I had
    --------------------------------------
    [global]
    server string = Linux Samba Server
    workgroup = somegroupname
    # added (often == default, but here for documentation)
    deadtime = 15
    disable netbios = yes
    # note the double ss below, but testparam found no issues - so left
    disable spoolss = yes
    domain logons = no
    domain master = yes
    dns proxy = no
    getwd cache = yes
    large readwrite = no
    local master = yes
    passdb backend = tdbsam
    preferred master = auto
    security = user
    server max protocol = SMB3
    socket options = TCP_NODELAY IPTOS_LOWDELAY
    strict locking = no
    strict sync = no
    sync always = no
    wins support = no

    [group]
    path = /home/group/exports
    valid users = @smbusers
    # control params
    browseable = yes
    create mask = 0777
    directory mask = 0777
    read only = no
    writeable = yes

    [manager]
    path = /home/manager/exports
    valid users = manager
    # control params
    browseable = yes
    create mask = 0777
    directory mask = 0777
    read only = no
    writeable = yes
    Last edited by rholme; 13th April 2019 at 12:31 PM.

  2. #2
    Join Date
    Jun 2004
    Location
    Maryland, US
    Posts
    7,557
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: samba server slower than molasses using Access

    Code:
    server max protocol = SMB3
    socket options = TCP_NODELAY IPTOS_LOWDELAY
    The performance tips page at wiki.samba.org
    https://wiki.samba.org/index.php/Performance_Tuning

    says setting those two are a bad idea on Linux.

    SMB Protocol Version
    Each new server message block (SMB) version adds new protocol features and improves performance. Additionally, recent Windows operating systems support the latest protocol versions. If a new SMB protocol version is implemented in Samba and considered stable, the default of the server max protocol parameter is set to the latest version. It is recommended that you do not set the server max protocol parameter in your smb.conf file. If the parameter is not set and you are updating Samba to a version that provides a new SMB protocol version, it is automatically available to the clients.
    To unset the parameter, remove the server max protocol entry from the [global] section of your smb.conf file.
    "The socket options Parameter
    Modern UNIX operating systems are tuned for high network performance by default. For example, Linux has an auto-tuning mechanism for buffer sizes. When you set the socket options parameter in the smb.conf file, you are overriding these settings. In most cases, setting this parameter decreases the performance.
    To unset the parameter, remove the socket options entry from the [global] section of your smb.conf file."
    But I'd suspect both of these are relatively minor and don't explain really bad slowness
    Last edited by marko; 13th April 2019 at 11:08 PM.

  3. #3
    Join Date
    Mar 2006
    Posts
    744
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Re: samba server slower than molasses using Access

    Have you tried setting up a direct cifs mount for the users use of the database? CIFS bypasses the smb.conf and uses the actual permission structure you've setup on the server. I've never used samba for other than browsing files. Your don't seem to have set up any logging so that you can review the file access issues. You should have some default logs of smb and nmb in /var/log/samba/ .
    jbkt23
    Thinkpads Depends on era T23 - X2xx
    AMD & Intel Boxes

  4. #4
    Join Date
    May 2009
    Posts
    457
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: samba server slower than molasses using Access

    Marko:
    Well, without those parameters it was truly slow. They did not seem to affect speed either way.
    And several fedora users suggested them. I may remove them as they did nothing. As for server max protocol - that is actually the default.

    Jbkt23:
    Will look into cifs, but have no idea how to increase logging.

    Thanks to both of you, I think this one is just how it is, but will keep trying.

  5. #5
    Join Date
    Mar 2006
    Posts
    744
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Re: samba server slower than molasses using Access

    I am wrong about cifs as it doesn't apply to windows machines.
    Have you looked at all in /var/log/samba/ to see what output is there?
    On the windows machines have you looked at the event application logs?
    Have you tried mapping the database directory to a users local windows partition ie T:\ ?
    jbkt23
    Thinkpads Depends on era T23 - X2xx
    AMD & Intel Boxes

  6. #6
    Join Date
    Mar 2006
    Posts
    744
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Re: samba server slower than molasses using Access

    A lot of the MS Access samba issues I find on the net are old, but here is one thread that may be helpful:
    https://www.experts-exchange.com/que...ba-Server.html
    my search terms: microsoft Access on Samba Server
    Gave a few hits worth exploring but no definitive answer.
    Note, "hosts" should be "host" in the above thread.
    jbkt23
    Thinkpads Depends on era T23 - X2xx
    AMD & Intel Boxes

  7. #7
    Join Date
    May 2009
    Posts
    457
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: samba server slower than molasses using Access

    I am not fond of MS and avoid as much as possible, so I know little about mapping to local windows partition.
    Will read up on your articles and check the machine when I can get to it again.
    Also the numbers about Dropbox are not really useful as I now understand that the file is actually local but auto-synchronized with the remote file copies.

  8. #8
    Join Date
    Feb 2019
    Location
    F29
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: samba server slower than molasses using Access

    What version of smbd are you using?

  9. #9
    Join Date
    May 2009
    Posts
    457
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: samba server slower than molasses using Access

    i have fedora 29 with the most recent and fully patched version samba.
    I cannot get to that machine without driving there so I cannot ask it what the revision is.
    But I fully patched everything and rebooted on 4/12/2019.

Similar Threads

  1. slower than molasses on a cold day
    By rholme in forum EOL (End Of Life) Versions
    Replies: 4
    Last Post: 13th December 2010, 02:04 PM
  2. Samba: How to switch user when you access to server from Windows?
    By yu xintian in forum Servers & Networking
    Replies: 4
    Last Post: 28th December 2009, 02:28 AM
  3. Windows can't access Samba server
    By eliufoo in forum Servers & Networking
    Replies: 8
    Last Post: 17th October 2007, 03:58 PM
  4. Can't access Samba server from second FC6 system
    By stratosfear in forum Servers & Networking
    Replies: 0
    Last Post: 26th December 2006, 04:25 PM
  5. Samba server can't access the directories.
    By mikedep333 in forum Servers & Networking
    Replies: 12
    Last Post: 25th August 2005, 01:06 AM

Posting Permissions

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