Re: ReisserFS
Peter Skipworth wrote: > > I'd heard that even in general use, some users had a noticeable increase > in disk reads/writes under ReiserFS...it sounds like you haven't > experienced this (?). I'm thinking about moving over to ReiserFS as well, > shortly, and am looking for as much feedback from people using it as > possible... Mileage may vary. We had in one test speed improvement of 30% on writes. But this depends :) -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia <___/ - 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: ReisserFS
Right, As far as *MySQL* goes I haven't noticed this in particular. That's because most mysql reads are indexed and use keys/caches. As far as general performance goes, I've definitely noticed it. (Creation/Deletion of large and large number of files is much, MUCH faster than ext2 - and reiserfs just 'feels' faster overall.) Any partition that I make with size >1gb will be a reiserfs partition (until something better comes along :) -S > > I'd heard that even in general use, some users had a noticeable increase > in disk reads/writes under ReiserFS...it sounds like you haven't > experienced this (?). I'm thinking about moving over to ReiserFS as well, > shortly, and am looking for as much feedback from people using it as > possible... > > regards, > > P > > > > Why would there be conflics? Reiserfs and MySQL dont know anything about > > eachother, the first one is a filysystem, the second one a database that > > lives on top of it. > > > > But to answer your question - yes, I've been using mysql on > reiserfs for a > > long time now, works perfect. MySQL wont become any faster or > anything, but > > it works. > > > > (I installed reiserfs because I was tired of the long ext2 waiting times > > when deleting/checking a 30Gb partition.) > > > > -S > > > > > > - > > 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
Re: ReisserFS
I have had the nulls in log-files/mail-files problem. This is with the latest kernels that have patches relating to this problem. I have been working with Cris (Rieser Programmer) daily to locate the problem I have had no other problems and enjoy the the fast mounting that the Reiser file-system afords.. ( Nick Pasich ) On Thu, 22 Feb 2001, Simon Windsor wrote: > > Has anyone user MySql on a ReisserFS file system ? > > > > Where any problems encountered ? and do you have any pearls of wisdom > > that you are willing to share ? > > No problems at all. Even power outages and severe crashes did not touch > the MySQL stuff on the ReiserFS file system, but that's probably all luck. > > :-) > > Regards, Jan > > -- WebSite: http://www.users.cts.com/sd/n/npasich _ _ _ __ _ __ __ _ ___(_) ___| |__ | '_ \| '_ \ / _` / __| |/ __| '_ \ | | | | |_) | (_| \__ \ | (__| | | | |_| |_| .__/ \__,_|___/_|\___|_| |_|@sd.cts.com |_| - 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: ReisserFS
I'd heard that even in general use, some users had a noticeable increase in disk reads/writes under ReiserFS...it sounds like you haven't experienced this (?). I'm thinking about moving over to ReiserFS as well, shortly, and am looking for as much feedback from people using it as possible... regards, P > Why would there be conflics? Reiserfs and MySQL dont know anything about > eachother, the first one is a filysystem, the second one a database that > lives on top of it. > > But to answer your question - yes, I've been using mysql on reiserfs for a > long time now, works perfect. MySQL wont become any faster or anything, but > it works. > > (I installed reiserfs because I was tired of the long ext2 waiting times > when deleting/checking a 30Gb partition.) > > -S > > > - > 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
Re: ReisserFS
On Thu, 22 Feb 2001, William R. Mussatto wrote: > What is the hardware (32 bit or 64) and what is the maximum files size > MySql will support on it? Thanks. I'm a mere end user when it comes to ReiserFS... I think you should be able to find all information you need on http://www.reiserfs.com/ As for MySQL, I guess the Fine Manual is the place to check, or even a search on http://www.google.com/ might do it. (The question has been asked before on the list, but I do not remember the correct answer.) Regards, Jan-Aage -- Mr. Jan-Aage Bruvoll Managing Director Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK Office/fax: +44 20 72408283 Mobile: +44 7740291600 - 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: ReisserFS
RE ReiserFS What is the hardware (32 bit or 64) and what is the maximum files size MySql will support on it? Thanks. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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: ReisserFS
Jan-Aage Bruvoll writes: > On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: > > No, that is not just luck. > > > > ReiserFS is a journalling file system. > > Sure thing. The luck part was referring to the fact that even the > consistency in the tables was ok, which is more on the luck side, since > all buffers were flushed at the time of the crashes. > > Regards, > Jan > > That is true, unless you are using BDB. Then even flushing buffers should not matter. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: ReisserFS
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: > No, that is not just luck. > > ReiserFS is a journalling file system. Sure thing. The luck part was referring to the fact that even the consistency in the tables was ok, which is more on the luck side, since all buffers were flushed at the time of the crashes. Regards, Jan - 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: ReisserFS
Jan-Aage Bruvoll writes: > On Thu, 22 Feb 2001, Simon Windsor wrote: > > No problems at all. Even power outages and severe crashes did not touch > the MySQL stuff on the ReiserFS file system, but that's probably all luck. > > :-) > > Regards, Jan > > No, that is not just luck. ReiserFS is a journalling file system. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: ReisserFS
Hi, Is any body knows that is there nay way to use mySQL with out installing it fully. I mean to say just install service manager and other required drivers. Or can somebody let me know that what are the minium service require from mysql setup to run the mySQL server to win NT. Sanjeev -Original Message- From: Jan-Aage Bruvoll [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 10:58 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: ReisserFS On Thu, 22 Feb 2001, Simon Windsor wrote: > Has anyone user MySql on a ReisserFS file system ? > > Where any problems encountered ? and do you have any pearls of wisdom > that you are willing to share ? No problems at all. Even power outages and severe crashes did not touch the MySQL stuff on the ReiserFS file system, but that's probably all luck. :-) Regards, Jan - 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
RE: ReisserFS
> -Original Message- > From: Simon Windsor [mailto:[EMAIL PROTECTED]] > Sent: 22 February 2001 16:22 > To: [EMAIL PROTECTED] > Subject: ReisserFS > > > Hi > > Has anyone user MySql on a ReisserFS file system ? > > Where any problems encountered ? and do you have any pearls of > wisdom that you are willing to share ? > > Thanks > > Simon Why would there be conflics? Reiserfs and MySQL dont know anything about eachother, the first one is a filysystem, the second one a database that lives on top of it. But to answer your question - yes, I've been using mysql on reiserfs for a long time now, works perfect. MySQL wont become any faster or anything, but it works. (I installed reiserfs because I was tired of the long ext2 waiting times when deleting/checking a 30Gb partition.) -S - 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: ReisserFS
On Thu, Feb 22, 2001 at 03:22:13PM +, Simon Windsor wrote: > Hi > > Has anyone user MySql on a ReisserFS file system ? Yes. > Where any problems encountered ? and do you have any pearls of > wisdom that you are willing to share ? It "just works". :-) -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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: ReisserFS
On Thu, 22 Feb 2001, Simon Windsor wrote: > Has anyone user MySql on a ReisserFS file system ? > > Where any problems encountered ? and do you have any pearls of wisdom > that you are willing to share ? No problems at all. Even power outages and severe crashes did not touch the MySQL stuff on the ReiserFS file system, but that's probably all luck. :-) Regards, Jan - 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