How dependent is MySQL on proper NFS locking between threads of
the same server?
Some background: I have a small application with lots of data that
stores recent RADIUS records for lookup by techs to help diagnose
dialup problems. The application runs with MySQL 3.23.10 (yes, I
know, I ought to upgrade, but it's currently working fine) on a
small Alpha system running OSF 4.0D. The application is write-mostly
read-occasionally (at least 95% of the activity is REPLACE). The
problem: managers want to keep records for a much longer time, and
this machine doesn't have the disk space. Further, it probably
can't be expanded within reasonable cost.
Proposed solution: use this big NFS server we've got and put the
database on that. We can do striped and mirrored filesystems, and
set up more storage. There is *NO* intent to run multiple instances
of the server using the same database (we might switch to a more
powerful CPU) and I think it is possible to effectively threaten
the admins (I get to handle problems with this app most of the
time) with dire consequences if they run myisamchk while the server
is still running.
Problems: NFS locking doesn't seem to work. First try: copy
databases over, run myisamchk. Fails with "no locks available".
Start up rpc.lockd and rpc.statd. Run myisamchk. Hangs indefinitely.
The server is *NOT* running on this copy yet, and if myisamchk
won't work, it won't ever be.
Assuming that NFS locking can be gotten to work at all, it will
probably be flakey. Does MySQL depend on NFS locking (when database
is on NFS filesystem) to do table locking between different queries
sent to the same server? Does anyone see any problems with *ONE*
instance (but multiple threads at times) of the server running with
the database on a NFS filesystem, with manual locking between the
server and myisamchk?
Gordon L. Burditt
---------------------------------------------------------------------
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
