My VPS provider mounts my /home partition via NFSv3 and it's causing me all kinds of headaches. I have my website served from ~/html/ using SQLite as the DB and I'm constantly seeing hung Apache processes that are threads with an open connection to my SQLite DB. I've read all the caveats about doing PHP over NFS, and all my systems are using up-to-date NFS implementations (Fedora 19 and Centos 6.4).
I don't have any problems reading any of the DBs, only writing to them. Consider the number of write requests my site should be generating I'm really surprised it's an issue. I'm sure it's something on the order of 6 write operations a *day*. Is there anything I can do to make SQLite/PHP/NFS behave better or am I'm totally SOL? Here are the NFS options they told me to use: nfs.server.com:/mnt/sata/pool-02/perturb.org/ on /home type nfs (rw,relatime,sync,vers=3,rsize=32768,wsize=32768,namlen=255,hard,proto=udp,timeo=11,retrans=3,sec=sys,mountaddr=1.2.3.4,mountvers=3,mountport=45465,mountproto=udp,local_lock=none,addr=1.2.3.4) Do I need to look at a different locking mechanism? sqlite> INSERT INTO Item VALUES (9999999,'Foobar'); Error: database is locked _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
