What OS is the best platform for MySQL ?

--0-1741777609-1246894401=:11445
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Dear All,
=A0
I have been using MySQL on FreeBSD for 3 years and encounterd a lot of prob=
lems related to thread management. And 1 year ago, I found that my FreeBSD =
box does not go well with any MySQL revision after 5.1.17-beta, because the=
MySQL thread does not end although complied with LINUX_THREADS.
=A0
Now I want to chane platform for MySQL from FreeBSD to another OS.
Is there any advice for choosing OS?
=A0
Thanks in advance.
Best regards.
=A0
Nhat HV =0A
--0-1741777609-1246894401=:11445--

Re: What OS is the best platform for MySQL ?

--000e0cd2c6de817635046e0c9c0d
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

On Mon, Jul 6, 2009 at 11:33 AM, Blog Tieng Viet wrote:

> Dear All,
>
> I have been using MySQL on FreeBSD for 3 years and encounterd a lot of
> problems related to thread management. And 1 year ago, I found that my
> FreeBSD box does not go well with any MySQL revision after 5.1.17-beta,
> because the MySQL thread does not end although complied with LINUX_THREADS.
>
> Now I want to chane platform for MySQL from FreeBSD to another OS.
> Is there any advice for choosing OS?
>

I think any version of Linux is perfect with MySQL. It's optimized perfectly
for MySQL. I use Debian but mileage may vary.

--000e0cd2c6de817635046e0c9c0d--

Re: What OS is the best platform for MySQL ?

In the last episode (Jul 06), Blog Tieng Viet said:
> I have been using MySQL on FreeBSD for 3 years and encounterd a lot of
> problems related to thread management. And 1 year ago, I found that my
> FreeBSD box does not go well with any MySQL revision after 5.1.17-beta,
> because the MySQL thread does not end although complied with
> LINUX_THREADS.

Try building without LINUX_THREADS; that option shouldn't really be used
with FreeBSD 6 or newer.

--
Dan Nelson
dnelson@allantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: What OS is the best platform for MySQL ?

Dan Nelson wrote:
> In the last episode (Jul 06), Blog Tieng Viet said:
>> I have been using MySQL on FreeBSD for 3 years and encounterd a lot of
>> problems related to thread management. And 1 year ago, I found that my
>> FreeBSD box does not go well with any MySQL revision after 5.1.17-beta,
>> because the MySQL thread does not end although complied with
>> LINUX_THREADS.
>
> Try building without LINUX_THREADS; that option shouldn't really be used
> with FreeBSD 6 or newer.
>
Also This article may help if you have not yet abandoned Freebsd. It
shows how freebsd can outperform Linux in some cases.

http://people.freebsd.org/~kris/scaling/mysql.html

Ken


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: What OS is the best platform for MySQL ?

Ken Menzel wrote:
> Dan Nelson wrote:
>> In the last episode (Jul 06), Blog Tieng Viet said:
>>> I have been using MySQL on FreeBSD for 3 years and encounterd a lot of
>>> problems related to thread management. And 1 year ago, I found that my
>>> FreeBSD box does not go well with any MySQL revision after 5.1.17-beta,
>>> because the MySQL thread does not end although complied with
>>> LINUX_THREADS.
>>
>> Try building without LINUX_THREADS; that option shouldn't really be used
>> with FreeBSD 6 or newer.
>>
> Also This article may help if you have not yet abandoned Freebsd. It
> shows how freebsd can outperform Linux in some cases.


Do we really need to bash OS's for MySQL. Rather than questioning what
OS is best for MySQL we should ask how we can optimize MySQL for each OS.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: What OS is the best platform for MySQL ?

There are merits to most of the common operating systems. In some ways
each of them perform better at various functions. The question becomes
which are you most comfortable and familiar with? That way you can work
most effectively with the operating system to fulfill the potential of
your databases.

If you aren't comfortable with any in particular, I would recommend you
learn your way around a Linux distribution. Again, not because it is
better than any other in particular, but because it is BY FAR the most
commonly deployed operating system running MySQL. It isn't even close in
terms of percentages. Behind it are Solaris and Windows. The most support
on the web is available for Linux simply because more people work on it.
But, if you are a Solaris, FreeBSD or Windows guru by all means as a
friend of mine says.. party on (on those platforms..)

Hope that helps.

Keith

> Ken Menzel wrote:
>> Dan Nelson wrote:
>>> In the last episode (Jul 06), Blog Tieng Viet said:
>>>> I have been using MySQL on FreeBSD for 3 years and encounterd a lot of
>>>> problems related to thread management. And 1 year ago, I found that
>>>> my
>>>> FreeBSD box does not go well with any MySQL revision after
>>>> 5.1.17-beta,
>>>> because the MySQL thread does not end although complied with
>>>> LINUX_THREADS.
>>>
>>> Try building without LINUX_THREADS; that option shouldn't really be
>>> used
>>> with FreeBSD 6 or newer.
>>>
>> Also This article may help if you have not yet abandoned Freebsd. It
>> shows how freebsd can outperform Linux in some cases.
>
>
> Do we really need to bash OS's for MySQL. Rather than questioning what
> OS is best for MySQL we should ask how we can optimize MySQL for each OS.
>
>
>







--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: What OS is the best platform for MySQL ?

Carlos Williams wrote:
> On Wed, Jul 8, 2009 at 12:21 PM, John Meyer wrote:
>> Do we really need to bash OS's for MySQL. Rather than questioning what
>> OS is best for MySQL we should ask how we can optimize MySQL for each OS.
>
> Did I mis-read an email or can someone please explain to me how anyone
> has bashed a specific OS? I have only seen responses with what people
> suggest. Many even offered helpful suggestions for the OP to stay on
> FreeBSD rather than users saying FreeBSD sucks and Linux is crap
> running MySQL. Great suggestions from everyone!


A thread with the title "What OS is the best platform for MySQL" pretty
much is a troll line for bashing OS's. I'm not saying the responses are
good, I'm just saying that the premise of the thread is a little misguided.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: What OS is the best platform for MySQL ?

--0-910689393-1247150572=:5330
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi everyone,
=A0
Many thanks for alot of response for my question.
=A0
I learned a lot from following article.
=A0
http://people.freebsd.org/~kris/scaling/mysql.html
=A0
I will try=A0using FreeBsd 7.0 for MySQL.
=A0
Best regards.

--- On Wed, 7/8/09, Ken Menzel wrote:


From: Ken Menzel
Subject: Re: What OS is the best platform for MySQL ?
To: "Dan Nelson"
Cc: "Blog Tieng Viet" , "'Carlos Williams'" swill@gmail.com>, mysql@lists.mysql.com, "Jerry Schwartz" foshop.com>
Date: Wednesday, July 8, 2009, 11:10 PM


Dan Nelson wrote:
> In the last episode (Jul 06), Blog Tieng Viet said:
>> I have been using MySQL on FreeBSD for 3 years and encounterd a lot of
>> problems related to thread management.=A0 And 1 year ago, I found that m=
y
>> FreeBSD box does not go well with any MySQL revision after 5.1.17-beta,
>> because the MySQL thread does not end although complied with
>> LINUX_THREADS.
>=20
> Try building without LINUX_THREADS; that option shouldn't really be used
> with FreeBSD 6 or newer.
>=20
Also This article may help if you have not yet abandoned Freebsd.=A0 It sho=
ws how freebsd can outperform Linux in some cases.

http://people.freebsd.org/~kris/scaling/mysql.html

Ken

=0A
--0-910689393-1247150572=:5330--