Hi Tim, all!
Tim Holmes wrote:
[[...]]
My databases are located on a different physical machine from the one
running the database server - (for backup etc reasons)
IMO, this is a "no-no": You add complexity and (potential) bottlenecks
to your setup. You should store your data local to the machine running
the server processes, because several operations (like locking) are only
possible on local files / disks.
Rather do remote backups than remote routine operation.
(This does not imply that backup were no routine activity!)
The databases reside in /home/mysql - that's an NFS share, which I know
for a fact is valid, as I have other data being used from the share
NFS is a good example: Typically, it does not support locking.
HTH,
Jörg
--
Joerg Bruehe, Senior Production Engineer
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
