ubuntu-users Digest, Vol 78, Issue 133

dti4zv4p a.arseneault at derytele.com
Fri May 27 04:09:48 UTC 2011


Le mardi 22 février 2011 à 19:44 +0000,
ubuntu-users-request at lists.ubuntu.com a écrit :
> Send ubuntu-users mailing list submissions to
> 	ubuntu-users at lists.ubuntu.com
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
> or, via email, send a message with subject or body 'help' to
> 	ubuntu-users-request at lists.ubuntu.com
> 
> You can reach the person managing the list at
> 	ubuntu-users-owner at lists.ubuntu.com
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of ubuntu-users digest..."
> 
> 
> Today's Topics:
> 
>    1. Re: LibreOffice Installation Question (NoOp)
>    2. Re: File system for MySQL server on Ubuntu (Hal Burgiss)
>    3. Re: File system for MySQL server on Ubuntu (Alan Holt)
>    4. Re: Can't Read PDF - SOLVED (Michael Satterwhite)
>    5. Re: File system for MySQL server on Ubuntu (MR ZenWiz)
>    6. Re: File system for MySQL server on Ubuntu (Alan Holt)
>    7. Re: File system for MySQL server on Ubuntu (Hal Burgiss)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Tue, 22 Feb 2011 10:08:33 -0800
> From: NoOp <glgxg at sbcglobal.net>
> To: ubuntu-users at lists.ubuntu.com
> Subject: Re: LibreOffice Installation Question
> Message-ID: <ik0u32$ld6$1 at dough.gmane.org>
> Content-Type: text/plain; charset=UTF-8
> 
> On 02/22/2011 09:44 AM, Barry Premeaux wrote:
> > http://www.ubuntugeek.com/how-to-install-libreoffice-in-ubuntu-using-deb-packages.html
> > 
> > It was the instructions I found here.  I went back over the last
> > thread on this subject and decided to go with the LibreOffice
> > installation instructions.  Every thing appears to be working fine.
> ...
> Glad you got it working.
> 
> As a side note: it is helpful if you include some portion of the email
> (and who) in your reply. That way when others read the post in the
> archives they will have some idea as to who & what you were replying to.
> See:
> http://www.ubuntu.com/support/community/mailinglists
> [Proper quoting:]
> Thanks :-)
> 
> 
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Tue, 22 Feb 2011 13:13:07 -0500
> From: Hal Burgiss <hal at burgiss.net>
> To: "Ubuntu user technical support,	not for general discussions"
> 	<ubuntu-users at lists.ubuntu.com>
> Subject: Re: File system for MySQL server on Ubuntu
> Message-ID:
> 	<AANLkTinwvoOfc=xkigMbL9MSSkUvFYd3q+4tTaYd6i47 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> On Tue, Feb 22, 2011 at 12:33 PM, Alan Holt <berber.it at gmail.com> wrote:
> 
> > I wonder which is the best filesystem to use with MySQL (to increase
> > performances) for huge MySQL server.
> >
> > I believe that MySQL needs fast creating/deleting files operation during
> > temporary table creation by example but also needs fast reading when
> > extracting lots of rows from a big table.
> >
> > What's your opinion ? Is Reiser the best or may it be ext3, ext4, xfs or
> > another
> > FS?
> >
> 
> Do you know what the server will be doing as a primary role? I ask because
> things like temporary tables are somewhat application specific. That being
> said, if I were starting from scratch I'd get the fastest drives I could,
> investigate raid controllers performance, config your partitions conrectly
> (ie turn off atime type settings ), and make sure to have plenty of memory
> for table and query caching available, etc. I suspect those things might
> make more difference than the filesystem for most use cases.
> 
> I personally use ext3, and worry about the other stuff I mentioned above.
> -- 
> Hal
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20110222/fac2e663/attachment-0001.html>
> 
> ------------------------------
> 
> Message: 3
> Date: Tue, 22 Feb 2011 20:48:02 +0200
> From: Alan Holt <berber.it at gmail.com>
> To: "Ubuntu user technical support,	not for general discussions"
> 	<ubuntu-users at lists.ubuntu.com>
> Subject: Re: File system for MySQL server on Ubuntu
> Message-ID:
> 	<AANLkTikK0HeRc+J04rjrPfVW7r+tF-mVit=QYS-BizP+ at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
> 
> Thank u, for your explanation, the primary role of my MySQL Ubuntu Server
> will be storage with the big massive of static data.
> Would be really important, it's searching. Like for example when you need to
> find one specific file from the billions and you need to find this in fast
> way.
> 
> Actually it's has to be DB storage.
> 
> I thought about XFS or EXT4, because ext4 filesystem can support volumes
> with sizes up to 1 exabyte and files with sizes up to 16 terabytes.
> It's exactly what I need, but I am not sure that I know how to configure
> it's right =(
> 
> On Tue, Feb 22, 2011 at 8:13 PM, Hal Burgiss <hal at burgiss.net> wrote:
> 
> > On Tue, Feb 22, 2011 at 12:33 PM, Alan Holt <berber.it at gmail.com> wrote:
> >
> >> I wonder which is the best filesystem to use with MySQL (to increase
> >> performances) for huge MySQL server.
> >>
> >> I believe that MySQL needs fast creating/deleting files operation during
> >> temporary table creation by example but also needs fast reading when
> >>  extracting lots of rows from a big table.
> >>
> >> What's your opinion ? Is Reiser the best or may it be ext3, ext4, xfs or
> >> another
> >> FS?
> >>
> >
> > Do you know what the server will be doing as a primary role? I ask because
> > things like temporary tables are somewhat application specific. That being
> > said, if I were starting from scratch I'd get the fastest drives I could,
> > investigate raid controllers performance, config your partitions conrectly
> > (ie turn off atime type settings ), and make sure to have plenty of memory
> > for table and query caching available, etc. I suspect those things might
> > make more difference than the filesystem for most use cases.
> >
> > I personally use ext3, and worry about the other stuff I mentioned above.
> > --
> > Hal
> >
> > --
> > ubuntu-users mailing list
> > ubuntu-users at lists.ubuntu.com
> > Modify settings or unsubscribe at:
> > https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
> >
> >
> 
> 
> -- 
> *?????, *
> *???? ????*
> *+9 72 54 285 952 3
> *
> *www.linuxspace.org* <http://www.linuxspace.org>
> *--*
> *Best regards.*
> *Alex Berber*
> *+9 72 54 285 952 3*
> *www.linuxspace.org* <http://www.linuxspace.org/>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20110222/5459f2b5/attachment-0001.html>
> 
> ------------------------------
> 
> Message: 4
> Date: Tue, 22 Feb 2011 12:53:22 -0600
> From: Michael Satterwhite <michael at weblore.com>
> To: "Ubuntu user technical support,	not for general discussions"
> 	<ubuntu-users at lists.ubuntu.com>
> Subject: Re: Can't Read PDF - SOLVED
> Message-ID: <4D640622.9000003 at weblore.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> On 02/22/2011 11:27 AM, Tony Pursell wrote:
> > Do you have Adobe Reader 9 installed? If you do, then go Applications >
> > Office>  Adobe Reader 9.  If it is there, go to Help>  About Adobe
> > Reader 9.  What is you version number?  The latest version is 9.4.1
> > 09/21/2010.
> >
> > If it is not installed, go Applications>  Ubuntu Software Centre and
> > under Get Software, click on Canonical Partners.  It should be in the
> > list for you to Install.
> >
> > I am assuming that you, like me, have the latest 10.10 version of
> > Ubuntu.
> >
> > Tony
> >
> >
> I didn't have Canonical Partners selected, so I didn't see it in the 
> repositories. I installed it and the document processes correctly. I'm 
> not thrilled that it has to be processed with the Adobe reader, but I 
> can certainly live with that for the few times its needed.
> 
> Thanks for the help.
> 
> 
> 
> ------------------------------
> 
> Message: 5
> Date: Tue, 22 Feb 2011 10:58:33 -0800
> From: MR ZenWiz <mrzenwiz at gmail.com>
> To: "Ubuntu user technical support,	not for general discussions"
> 	<ubuntu-users at lists.ubuntu.com>
> Subject: Re: File system for MySQL server on Ubuntu
> Message-ID:
> 	<AANLkTim7jDMWXbFaRLHkxx5=_O5mDZjHca6-krc+K1s5 at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
> 
> On Tue, Feb 22, 2011 at 10:48 AM, Alan Holt <berber.it at gmail.com> wrote:
> > Thank u, for your explanation, the?primary role of my MySQL Ubuntu Server
> > will be storage with the big massive of static data.
> > Would be really important, it's searching.?Like for example when you need to
> > find one specific file from the billions and you need to find this in fast
> > way.
> > Actually it's has to be DB storage.
> > I thought about XFS or EXT4,?because ext4 filesystem can support volumes
> > with sizes up to 1 exabyte and files with sizes up to 16 terabytes.
> > It's exactly what I need, but I am not sure that I know how to configure
> > it's right =(
> 
> 1) Please do not top-post to this list.
> 
> 2) In what way would you need to configure the filesystem other than
> by using the defaults?
> 
> 
> 
> ------------------------------
> 
> Message: 6
> Date: Tue, 22 Feb 2011 21:09:05 +0200
> From: Alan Holt <berber.it at gmail.com>
> To: mrzenwiz at gmail.com, "Ubuntu user technical support,	not for
> 	general discussions" <ubuntu-users at lists.ubuntu.com>
> Subject: Re: File system for MySQL server on Ubuntu
> Message-ID:
> 	<AANLkTi=PezLXBsC4qGPt_xoQdiDBoN+v9LWkCvD+vSo8 at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
> 
> >In what way would you need to configure the filesystem other than
> >by using the defaults?
> 
> To make FS much faster for reading then for writing.
> 
> --
> *?????, *
> *???? ????*
> *+9 72 54 285 952 3
> *
> *www.linuxspace.org* <http://www.linuxspace.org>
> *--*
> *Best regards.*
> *Alex Berber*
> *+9 72 54 285 952 3*
> *www.linuxspace.org* <http://www.linuxspace.org/>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20110222/948d2f60/attachment-0001.html>
> 
> ------------------------------
> 
> Message: 7
> Date: Tue, 22 Feb 2011 14:44:01 -0500
> From: Hal Burgiss <hal at burgiss.net>
> To: "Ubuntu user technical support,	not for general discussions"
> 	<ubuntu-users at lists.ubuntu.com>
> Subject: Re: File system for MySQL server on Ubuntu
> Message-ID:
> 	<AANLkTimdF099O0iFMQAZTGLzKbH8fi-ydGkBZeFfYa3p at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> On Tue, Feb 22, 2011 at 1:48 PM, Alan Holt <berber.it at gmail.com> wrote:
> 
> > Thank u, for your explanation, the primary role of my MySQL Ubuntu Server
> > will be storage with the big massive of static data.
> > Would be really important, it's searching. Like for example when you need
> > to find one specific file from the billions and you need to find this in
> > fast way.
> >
> > Actually it's has to be DB storage.
> >
> > I thought about XFS or EXT4, because ext4 filesystem can support volumes
> > with sizes up to 1 exabyte and files with sizes up to 16 terabytes.
> > It's exactly what I need, but I am not sure that I know how to configure
> > it's right =(
> >
> >
> I think google is using ext4 now, so its probably safe for the rest of us.
> 
> But I honestly think from pure performance standpoint, you will better spend
> your time configuring mysql probably, tweaking whatever filesystem you do
> use, buying your hardware right for the task at hand, and optimizing your
> sql queries.
> 
> I'd also suggest finding a mysql specific developers forum, since this is
> getting pretty far afield for this list. Not a users forum, but people who
> do high end mysql work. Like the guys at facebook :/
> 
> 
> 
> 
> -- 
> Hal
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20110222/c207f031/attachment.html>
> 
> ------------------------------
> 






More information about the ubuntu-users mailing list