For mysql, if your datafiles will not fit in ram, I would highly recommend not putting it on nfs. Mysql doesn't have any data caching, so every query will have to go thru the network to get the data. if, however, you do have enough ram on the machine to store all the datafiles in memory, then we have not seen this problem. But the other points that Matthew brought up about network connectivity till apply.
OT, Matthew, we've got oracle running over NFS on NetAPP filers and we've had extremely good performance. Of course we have 100Meg or GigE between them, but the only problems we ever have is when we have queries that do full table scans. Anyways just my couple pennies.. --shak Matthew Darcy wrote: >I have done oracle on NFS and it is not really the best option due to NFS >locking. > >ie a poor network or if the NFS server drops, or the NIS/NIS+ (assuming you >are using automount maps) dies this will hold your development/production up >no end. Also oracle's table locking (not sure if mysql has this) causes >problems over NFS. > >The only time I have seen it work ok was on a veritas cluster using the >Oracle/NFS export as a failover and it worked BAD the machine failed over >quite a few times and picked up but the machines had to be very powerfull as >there was tons of rollbacks and non commited transactions, and non bound >variables over NFS was soooo slow. > >I am sure you could do it but it is not wise. > >I have stored Oracle binarys on NFS so that clients could access oracle and >manage it over NFS but never had good performance keeping the data on NFS. > >Matt. > > >-----Original Message----- >From: Shen, Lei (CIT) [mailto:[EMAIL PROTECTED]] >Sent: 12 December 2001 14:28 >To: [EMAIL PROTECTED] >Subject: Mysql in NFS > > > >Hi! Dose anyone has a experience to building mysql database in network files >system? and php? can you get me some information? thank you > >-----Original Message----- >From: Marek Kustka [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, December 12, 2001 8:23 AM >To: [EMAIL PROTECTED] >Subject: Embedded MySQL server && the outside world > > >Hi folks, > >does embedded server tcp-listen to the outside world i.e. it could >be used by another app or perhaps been accessed by the same app >using ODBC? > >OR > >is MySQL C API the only way to control it? > >Thanks, Marek > > >--------------------------------------------------------------------- >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 > >--------------------------------------------------------------------- >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 > > >--------------------------------------------------------------------- >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 > -- Shakeel Sorathia Systems Administrator (626) 660-3502 --------------------------------------------------------------------- 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
