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 ideas why this happens?
> next time i will have no possiblity to increase maxfiles again.
> i am sure it depends on mysql cause the other things running
> there at the moment are doing nearly nothing.
> 
> thanks
> regards
> 
> Sven Huster
> Senior Unix System Administrator
> *BSD, Linux, Solaris
> 

Sven,

1) what is ther server you are using?
2) what kind of nfs ?
3) have you played with read_buffer and write_buffer nfs options ?
4) What kind of tables are you defining ?


-
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




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
> 
> 
> -
> 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
> 
> 

-- 
--
Antonio Gulli'Ideare S.p.a  tel: (+39) 050  575300
[EMAIL PROTECTED]  Lungarno Mediceo 56   fax: (+39) 050  575583
whois:   AG2-ORG  I-56126 Pisa, Italy   http://www.ideare.com net: 

print pack"C*",split/\D+/,`echo "16iII*o\U@{$/=$z;[(pop,pop,unpack"H*",<>
)]}\EsMsKsN0[lN*1lK[d2%Sa2/d0http://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




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.  Worked
>fine as long as there was only one mysql server accessing
>the data.  The network as 100 Mbs, and the SQL volume was
>pretty low.
>

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 ideas why this happens?
next time i will have no possiblity to increase maxfiles again.
i am sure it depends on mysql cause the other things running
there at the moment are doing nearly nothing.

thanks
regards

Sven Huster
Senior Unix System Administrator
*BSD, Linux, Solaris


-
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




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 
pretty low.

--Josh

_
Joshua Chamas   Chamas Enterprises Inc.
NodeWorks >> free web link monitoring   Huntington Beach, CA  USA 
http://www.nodeworks.com1-714-625-4051

-
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




mysql over nfs on netapp filer

2001-03-29 Thread Sven Huster

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


-
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