Re: MySQL over NFS: performance?

2003-06-27 Thread Jeremy Zawodny
On Fri, Jun 27, 2003 at 09:20:45AM +0200, [EMAIL PROTECTED] wrote: > > I have an installation of MySQL where the data directory is located > on an NFS share. Client and server are connected by Full Duplex > Gigabit Ethernet (both hosts run Linux 2.4.21). The NFS is exported > with "sync" option. >

Re: MySQL over NFS

2002-08-20 Thread Brian Moon
MAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 8:57 AM Subject: Re: MySQL over NFS | | > Also, what we have done is used a replicating box as a select only server. | > This requires you to write your code in such a way that only selects get | > sent to the

Re: MySQL over NFS

2002-08-20 Thread lcalero
> Also, what we have done is used a replicating box as a select only server. > This requires you to write your code in such a way that only selects get > sent to the slave. A simple function wrapper in PHP is all we needed. I've been thinking of this idea too but it's a bit of a problem becau

Re: MySQL over NFS

2002-08-20 Thread Thomas Seifert
Isn't that what the MySQL-Replication is for? Thomas On Tue, 20 Aug 2002 08:07:24 -0500 "Brian Moon" <[EMAIL PROTECTED]> wrote: > This is an interesting idea. I would be a happy man if it would actually > work. My experiences with NFS would lead me to believe that this would not > help and co

Re: MySQL over NFS

2002-08-20 Thread Brian Moon
AIL PROTECTED]> To: "Luis Calero" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 8:07 AM Subject: Re: MySQL over NFS | This is an interesting idea. I would be a happy man if it would actually | work. My experiences with NFS would lead me to believ

Re: MySQL over NFS

2002-08-20 Thread Brian Moon
This is an interesting idea. I would be a happy man if it would actually work. My experiences with NFS would lead me to believe that this would not help and could hurt the performance of existing MySQL server even more. My use has been limited to a file server for our web nodes, so, this is a b

Re: MySQL over NFS

2002-08-20 Thread Tod Harter
On Tuesday 20 August 2002 06:39 am, Luis Calero wrote: NFS locking is ALWAYS problematical. You might have no problems, you might also be instantly in hell. Its really hard actually to answer your question. NFS implementations vary greatly in their quality. In addition it depends on the NICs

Re: mysql over nfs on netapp filer

2001-03-29 Thread Antonio Gulli
> > Hi, > > my problem is that now the second time the performance of my f740 > goes down every day. > i solved the prob with increasing maxfiles (no to the max for the > volume). > after that the cpu of the filer, which went up from > 25% peak to 90% peak in 5 days, goes down again. > > any i

Re: mysql over nfs on netapp filer

2001-03-29 Thread Antonio Gulli
Yep, what do you need ? Sven Huster wrote: > Hi there, > > i anybody out there running mysql on a netapp filer as data storage? > > regards > > Sven Huster > Senior Unix System Administrator > *BSD, Linux, Solaris > > > - >

Re: mysql over nfs on netapp filer

2001-03-29 Thread Sven Huster
Am 00:20 30.03.2001 schrieb Joshua Chamas: >*This message was transferred with a trial version of CommuniGate(tm) Pro* >Sven Huster wrote: > > > > Hi there, > > > > i anybody out there running mysql on a netapp filer as data storage? > > > >Yes, I've done this for a client from a linux server. Wo

Re: mysql over nfs on netapp filer

2001-03-29 Thread Joshua Chamas
Sven Huster wrote: > > Hi there, > > i anybody out there running mysql on a netapp filer as data storage? > Yes, I've done this for a client from a linux server. Worked fine as long as there was only one mysql server accessing the data. The network as 100 Mbs, and the SQL volume was prett

Re: Mysql over NFS

2001-02-06 Thread Nathan Cook
EMAIL PROTECTED]> Sent: Tuesday, February 06, 2001 4:18 PM Subject: Re: Mysql over NFS > Nope... > > It's stated explicitly in the docs that this is a *Bad Idea* (with caps, > even! *grin*). You'll need to look at other options - replication, > possibly, either

Re: Mysql over NFS

2001-02-06 Thread Peter Skipworth
Nope... It's stated explicitly in the docs that this is a *Bad Idea* (with caps, even! *grin*). You'll need to look at other options - replication, possibly, either on to the same machine with your db on a different drive, or (probably preferable) onto a seperate box. regards, P On Tue, 6 Feb