Toni Mueller wrote:
mind you that "my" problems radically increased with 5.x - nobody is
talking about 4.x anymore.
You checked these right?
Many details that might help you.
http://www.openbsdsupport.org/mysql.htm
Just a thought.
Daniel
Hello,
On Fri, 08.09.2006 at 10:51:00 +0200, Lukasz Sztachanski <[EMAIL PROTECTED]>
wrote:
> mysql Ver 12.22 Distrib 4.0.27, for unknown-openbsd3.8 (i386)
> Uptime: 94 days 17 hours 17 min 50 sec
mind you that "my" problems radically increased with 5.x - nobody is
talking about
Here to reduce the questions on the installation and configuration of
MySQL on OpenBSD. I put a document up with more details on it.
http://openbsdsupport.org/mysql.htm
Yeap, the English may not be perfect, but the steps are there.
Hope this help anyway.
Best,
Daniel
PS: I don't think I for
On Sunday, 10 September 2006 at 17:30:00 +0200, Henning Brauer wrote:
> we just run with increaeed maxfiles (kern.maxfiles=4096). the mysql
> config mysqld section:
>
> [mysqld]
Thanks Henning for sharing the info.
Zoong
* Zoong PHAM <[EMAIL PROTECTED]> [2006-09-08 18:04]:
> On Thursday, 7 September 2006 at 17:03:55 +0200, Henning Brauer wrote:
> >
> > as said before, our mysqlds on sparc64, mp- & up-i386, and sparc are
> > very stable; some see more than 400 queries/s sometimes.
>
> Do you mind to share your /
Gustavo Rios wrote:
Hey folks,
On 6/20/06, Jesse Gumm <[EMAIL PROTECTED]> wrote:
It's good, but if it's a multiprocessor machine, OpenBSD won't take
full advantage of the other processors with MySQL since MySQL is
multi-threaded. But it's stable, and runs reasonably fast (and you
are assured t
Hey folks,
On 6/20/06, Jesse Gumm <[EMAIL PROTECTED]> wrote:
It's good, but if it's a multiprocessor machine, OpenBSD won't take
full advantage of the other processors with MySQL since MySQL is
multi-threaded. But it's stable, and runs reasonably fast (and you
are assured the system is more sec
On Thursday, 7 September 2006 at 17:03:55 +0200, Henning Brauer wrote:
>
> as said before, our mysqlds on sparc64, mp- & up-i386, and sparc are
> very stable; some see more than 400 queries/s sometimes.
Do you mind to share your /etc/sysctl.conf
and /etc/my.cnf ?
Thanks
Zoong
Kyle George wrote:
Not exactly related, but there's also a bug I've experienced on 3.9 with
DBD::mysql. See: http://rt.cpan.org/Public/Bug/Display.html?id=20868
I have probably found that bug and I'm waiting for a fix from a guy at
mysql. Here it is the last email from him.
Bye.
9 +0300
> To: misc@openbsd.org
> Subject: Re: Opinion of MySQL 5.xx on OpenBSD 3.9...
>
> > Hello,
> >
> > On Thu, 22.06.2006 at 12:49:22 +0200, Henning Brauer <[EMAIL PROTECTED]>
> > wrote:
> > > I haven't seen stability problems with mysql on OpenBSD
Kyle George wrote:
On Thu, 7 Sep 2006, Jacob Yocom-Piatt wrote:
i too was "unlucky" until i read some posts on misc@ several months
back. adding
_mysql:\
:datasize=1024M:\
:maxproc=4096:\
:openfiles-cur=2048:\
:openfiles-max=8192:\
:stacksize-cur=16M:\
On Thu, 7 Sep 2006, Toni Mueller wrote:
> Hello,
>
> On Thu, 22.06.2006 at 12:49:22 +0200, Henning Brauer <[EMAIL PROTECTED]>
> wrote:
> > I haven't seen stability problems with mysql on OpenBSD in a long time.
> > not even on sparc64.
>
> then you are very lucky, imho.
>
> On a variety of OpenBS
Make sure that you have your 'open-files-limit' parameter set to a sane
value in your my.cnf. If you don't have anything set for that limit
the default is extremely low (so low that using views tended to not
work on my dev box). I have been using "open-files-limit = 8192",
however YMMV.
A very
On Thu, 7 Sep 2006, Jacob Yocom-Piatt wrote:
> i too was "unlucky" until i read some posts on misc@ several months
> back. adding
> _mysql:\
> :datasize=1024M:\
> :maxproc=4096:\
> :openfiles-cur=2048:\
> :openfiles-max=8192:\
> :stacksize-cur=16M:\
>
On 2006/09/07 09:35, Matthew Peltzer wrote:
> >060830 22:37:02 [Warning] Could not increase number of max_open_files
> >to more than 1772 (request: 8192)
$ sysctl kern.maxfiles
kern.maxfiles=1772
login.conf limits also apply (exactly which section depends on
how mysqld is started).
this comes up
On Thu, 7 Sep 2006, Matthew Peltzer wrote:
> On 9/7/06, Tim Donahue <[EMAIL PROTECTED]> wrote:
> > Make sure that you have your 'open-files-limit' parameter set to a sane
> > value in your my.cnf. If you don't have anything set for that limit
> > the default is extremely low (so low that using vi
On 9/7/06, Tim Donahue <[EMAIL PROTECTED]> wrote:
Make sure that you have your 'open-files-limit' parameter set to a sane
value in your my.cnf. If you don't have anything set for that limit
the default is extremely low (so low that using views tended to not
work on my dev box). I have been usin
Original message
>Date: Thu, 7 Sep 2006 17:03:55 +0200
>From: Henning Brauer <[EMAIL PROTECTED]>
>Subject: Re: Opinion of MySQL 5.xx on OpenBSD 3.9...
>To: misc@openbsd.org
>
>* Toni Mueller <[EMAIL PROTECTED]> [2006-09-07 12:14]:
>> Hello,
>>
Make sure that you have your 'open-files-limit' parameter set to a sane
value in your my.cnf. If you don't have anything set for that limit
the default is extremely low (so low that using views tended to not
work on my dev box). I have been using "open-files-limit = 8192",
however YMMV.
Tim Dona
* Toni Mueller <[EMAIL PROTECTED]> [2006-09-07 12:14]:
> Hello,
>
> On Thu, 22.06.2006 at 12:49:22 +0200, Henning Brauer <[EMAIL PROTECTED]>
> wrote:
> > I haven't seen stability problems with mysql on OpenBSD in a long time.
> > not even on sparc64.
>
> then you are very lucky, imho.
no, you
Subject: Re: Opinion of MySQL 5.xx on OpenBSD 3.9...
Same here, a lot of problems since 3.7. :(
Because of that, two client servers was migrated to freebsd :/
-Original message-
From: Toni Mueller [EMAIL PROTECTED]
Date: Thu, 7 Sep 2006 13:09:09 +0300
To: misc@openbsd.org
Subject: Re:
Same here, a lot of problems since 3.7. :(
Because of that, two client servers was migrated to freebsd :/
-Original message-
From: Toni Mueller [EMAIL PROTECTED]
Date: Thu, 7 Sep 2006 13:09:09 +0300
To: misc@openbsd.org
Subject: Re: Opinion of MySQL 5.xx on OpenBSD 3.9...
> He
Hello,
On Thu, 22.06.2006 at 12:49:22 +0200, Henning Brauer <[EMAIL PROTECTED]> wrote:
> I haven't seen stability problems with mysql on OpenBSD in a long time.
> not even on sparc64.
then you are very lucky, imho.
On a variety of OpenBSD boxes, and with a variety of MySQL versions, I
experienc
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hej Daniel,
Daniel Ouellet wrote:
> Marian Hettwer wrote:
>
>> I'd love to have the time to give OpenBSD a chance on our production
>> system. Seems unlikely, since we're running Linux only :(
>
> Really, a coffee break I tell you. That's all you
Marian Hettwer wrote:
I'd love to have the time to give OpenBSD a chance on our production
system. Seems unlikely, since we're running Linux only :(
Time, well a coffee break, that's all you need.
See setting up OpenBSD in 5 minutes from scratch, even here with pause
in the process too:
htt
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Daniel,
Daniel Ouellet wrote:
>
> In the end, run what you fell comfortable with, but to the original
> question, is MySQL run good on OpenBSD.
>
> The answer to that is YES!
>
ACK :)
sorry, I was just out for some statistics. Did some not seri
mysql> status;
--
44 Open tables: 455 Queries per second avg: 5.117
--
# dmesg
OpenBSD 3.9 (GENERIC) #617: Thu Mar 2 02:26:48 MST 2006
[EMAIL PROTECTED]:/usr/src/sys/arch/i386/compile/GENERIC
cpu0: Intel Pentium III ("GenuineIntel" 686-class) 844 MHz
real mem = 2
On Mon, Jun 26, 2006 at 04:41:48PM +0200, Anders J wrote:
> Could i ask how your login class (/etc/login.conf) for mysql looks like?
> And maybe your [mysqld_safe] entry in/etc/my.cnf?
> I already modified my kern.maxfiles in /etc/sysctl.conf to
> kern.maxfiles=1 and in my own /etc/login.conf c
Could i ask how your login class (/etc/login.conf) for mysql looks like?
And maybe your [mysqld_safe] entry in/etc/my.cnf?
I already modified my kern.maxfiles in /etc/sysctl.conf to
kern.maxfiles=1 and in my own /etc/login.conf class i have set the
follwing values:
mysql:\
:datasize=infinity:\
thus Marian Hettwer spake:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daniel Ouellet wrote:
mysql> status;
--
44 Open tables: 455 Queries per second avg: 5.117
--
# dmesg
OpenBSD 3.9 (GENERIC) #617: Thu Mar 2 02:26:48 MST 2006
[EMAIL PROTECTED]:/usr/src/s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daniel Ouellet wrote:
> mysql> status;
> --
> 44 Open tables: 455 Queries per second avg: 5.117
> --
>
>
>
> # dmesg
> OpenBSD 3.9 (GENERIC) #617: Thu Mar 2 02:26:48 MST 2006
> [EMAIL PROTECTED]:/usr/src/sys/arch/i3
Marian Hettwer wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Julian,
Julian Bolivar wrote:
I use MySQL 5.0.18 and OpenBSD 3.9 for AMD64 and work fine, and I used
a lot of insert / hour in it, using Innodb tables.
What means "a lot" ? Can you provide a mysqladmin status, or a show
Hi, I can't gift you exact numbers, but "a lot" are between 500,000 and
1,000,000 inserts by hour. Every hour I process a huge (~5GB ) text file
and extract some records from it and are storage in MySQL DB. I can
show you more information later.
Thanks and Regards.
Julian
Marian Hettwer w
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Julian,
Julian Bolivar wrote:
>
> I use MySQL 5.0.18 and OpenBSD 3.9 for AMD64 and work fine, and I used
> a lot of insert / hour in it, using Innodb tables.
>
What means "a lot" ? Can you provide a mysqladmin status, or a show
status from mysql
On 6/22/06, Julian Bolivar <[EMAIL PROTECTED]> wrote:
Henning Brauer wrote:
> * Anders J <[EMAIL PROTECTED]> [2006-06-20 21:06]:
>
>> Hello List.
>> A customer have a mailserver solution wich must be moved to a new
>> hardware, today its is running on a old suse 9.2 but i really want to
>> use Op
Hi Brauer and Anders
What is the diference between the actual threading library and rtheads?
I use MySQL 5.0.18 and OpenBSD 3.9 for AMD64 and work fine, and I used
a lot of insert / hour in it, using Innodb tables.
Thanks and Regards,
Julian Bolivar
Henning Brauer wrote:
* Anders J <[EMA
* Anders J <[EMAIL PROTECTED]> [2006-06-20 21:06]:
> Hello List.
> A customer have a mailserver solution wich must be moved to a new
> hardware, today its is running on a old suse 9.2 but i really want to
> use OpenBSD if possible.
> It uses postfix, cyrus-imap and mysql as the backend for users do
Frank Bax wrote:
Actually, the option is really --disable-keys. The --opt option is just
a shorthand for several options (including --disable-keys).
There is more as well and refer to the man page for all the details:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
The --opt
Doesn't
At 04:54 PM 6/20/06, Daniel Ouellet wrote:
Bryan Irvine wrote:
Works ok for me. Hasn't crashed or anything like that. I use mysql 5 on
OpenBSD that some web apps talk too. I just did an import of a previous
dump, and it took somewhere in the neighboorhood of 7 hours give or take.
(for a few
Bryan Irvine wrote:
Works ok for me. Hasn't crashed or anything like that. I use mysql 5 on
OpenBSD that some web apps talk too. I just did an import of a previous
dump, and it took somewhere in the neighboorhood of 7 hours give or take.
(for a few tens of million INSERTS that's not bad).
Thi
Works ok for me. Hasn't crashed or anything like that. I use mysql 5 on
OpenBSD that some web apps talk too. I just did an import of a previous
dump, and it took somewhere in the neighboorhood of 7 hours give or take.
(for a few tens of million INSERTS that's not bad).
This is run on a slighlty
On Tue, Jun 20, 2006 at 08:56:36PM +0200, Anders J wrote:
> Hello List.
> A customer have a mailserver solution wich must be moved to a new
> hardware, today its is running on a old suse 9.2 but i really want to
> use OpenBSD if possible.
> It uses postfix, cyrus-imap and mysql as the backend for u
Anders J wrote:
My self have experienced mixed issues with MysSQL on OpenBSD and also
read and heard about performance and stability problems with MySQL on
OpenBSD.
I use it for years (7+) without issues. The only one I recall was with
3.23.46, yeap, really old, where the database restart itse
It's good, but if it's a multiprocessor machine, OpenBSD won't take
full advantage of the other processors with MySQL since MySQL is
multi-threaded. But it's stable, and runs reasonably fast (and you
are assured the system is more secure, being OpenBSD and all).
My only concern, then, is really
Hello List.
A customer have a mailserver solution wich must be moved to a new
hardware, today its is running on a old suse 9.2 but i really want to
use OpenBSD if possible.
It uses postfix, cyrus-imap and mysql as the backend for users domain
info, contacts etc. (only 58 named users and 3 domains a
45 matches
Mail list logo
