Hi,
FreeBSD 7 should offer much better performance for MySQL. The FreeBSD
kernel developers have found ways to relieve some of the kernel
bottlenecks which permit multithreaded applications to operate much
better.
Regards,
Antony.
On 3 Jun 2008, at 03:43, VeeJay wrote:
Hi Guys
I need
Hi all !
VeeJay wrote:
[[...]]
At my job, I am going to build a Web Server with
1. FreeBSD 7.0-RELEASE amd64
2. Apache 2.2.8
3. PHP 4.4.8 (or may be PHP5, what do you suggest?)
Server's hardware configuration is as follow:
2 x Quad Core Xeon E5450 3.0GHz,2x6MB,1333FSB
16GB (8x2GB Dua
At 22:05 +0400 9/29/03, G B U wrote:
> On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote:
>
> Hmm... am I missing something?! IIRC there is nothing manual about Innodb
> not supporting spatial extensions. And on windows it seems that
all is working
> fine. This is from my Win2000 box with
At 21:33 +0400 9/29/03, G B U wrote:
> At 19:16 +0300 9/29/03, Victoria Reznichenko wrote:
>"G B U" <[EMAIL PROTECTED]> wrote:
>>
>> It seems to me that combination from the subject just doesn't work.
>> Every time I try to incorporate spatial column into Innodb table
>> Mysql dies. The si
> On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote:
> >
> > Hmm... am I missing something?! IIRC there is nothing manual about Innodb
> > not supporting spatial extensions. And on windows it seems that all is working
> > fine. This is from my Win2000 box with the same Mysql version:
> >
> >
On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote:
>
> Hmm... am I missing something?! IIRC there is nothing manual about Innodb
> not supporting spatial extensions. And on windows it seems that all is working
> fine. This is from my Win2000 box with the same Mysql version:
>
> mysql> create
> At 19:16 +0300 9/29/03, Victoria Reznichenko wrote:
> >"G B U" <[EMAIL PROTECTED]> wrote:
> >>
> >> It seems to me that combination from the subject just doesn't work.
> >> Every time I try to incorporate spatial column into Innodb table
> >> Mysql dies. The simplest case, easy to repeat is be
At 19:16 +0300 9/29/03, Victoria Reznichenko wrote:
"G B U" <[EMAIL PROTECTED]> wrote:
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case, easy to repeat is bellow.
When I'm trying to
"G B U" <[EMAIL PROTECTED]> wrote:
>
> It seems to me that combination from the subject just doesn't work.
> Every time I try to incorporate spatial column into Innodb table
> Mysql dies. The simplest case, easy to repeat is bellow.
> When I'm trying to create table with just one spatial column
Hi
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case, easy to repeat is bellow.
When I'm trying to create table with just one spatial column I'm
getting following error:
mysql> cre
In the last episode (Mar 15), Jesse Guardiani said:
> From: "Warren W. Gay VE3WWG" <[EMAIL PROTECTED]>
> > The OP didn't indicate where the files are being kept, and under
> > FreeBSD this can be significant. I know for example, that using UFS
> > file systems, are very slow compared to newer file
- Original Message -
From: "Warren W. Gay VE3WWG" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 4:45 PM
Subject: Re: FreeBSD + MySQL bottleneck
> The OP didn't indicate where the files are being kept, and under FreeBSD
> th
Jeremy Zawodny wrote:
On Fri, Mar 14, 2003 at 12:03:14PM -0800, Joe Stump wrote:
This may help - I just got this from a friend.
http://jeremy.zawodny.com/blog/archives/000203.html
Ugh.
I *really* need to update that. It has become a popular reference.
But I have some new information to a
On Friday 14 March 2003 12:34, Jeremy Zawodny wrote:
> On Fri, Mar 14, 2003 at 12:03:14PM -0800, Joe Stump wrote:
> > This may help - I just got this from a friend.
> >
> > http://jeremy.zawodny.com/blog/archives/000203.html
>
> Ugh.
>
> I *really* need to update that. It has become a popular refe
Matthias Trevarthan wrote:
>
> Howdy list,
>
> I run MySQL 3.23.54 with FreeBSD 4.6-RELEASE.
>
> We recently had a BBS get hammered by a lot of
> concentrated traffic.
>
> I currently run a 'mysql-optimize.sh' script from
> cron on Wednesday and Sunday that executes:
>
> ${bindir}/myisamchk -i
On Fri, Mar 14, 2003 at 12:03:14PM -0800, Joe Stump wrote:
> This may help - I just got this from a friend.
>
> http://jeremy.zawodny.com/blog/archives/000203.html
Ugh.
I *really* need to update that. It has become a popular reference.
But I have some new information to add.
The short version.
n [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2003 7:16 AM
To: [EMAIL PROTECTED]
Subject: FreeBSD + MySQL bottleneck
Howdy list,
I run MySQL 3.23.54 with FreeBSD 4.6-RELEASE.
We recently had a BBS get hammered by a lot of
concentrated traffic.
I currently run a 'mysql-optimize.sh
> So, my questions are these:
> ---
>
> Can any experienced MySQL-FreeBSD admins out there
> give me some pointers for identifying bottlenecks?
I have been running MySQl-FreeBSD for over a year now and we are now doing
about 140-150,000 page views a day all dynamic from t
Howdy list,
I run MySQL 3.23.54 with FreeBSD 4.6-RELEASE.
We recently had a BBS get hammered by a lot of
concentrated traffic.
I currently run a 'mysql-optimize.sh' script from
cron on Wednesday and Sunday that executes:
${bindir}/myisamchk -i -r --check --sort-index --analyze ${datadir}/*/*.MY
CTED]>
Sent: Friday, January 17, 2003 6:28 PM
Subject: FreeBSD: MySQL crash when importing 148 MB dumpfile
> Problem: I am migrating servers, from a dual PIII-866 Mhz with 384
MB of
> RAM running Linux to the following server configuration:
>
> Dual Athlon 1.5 Ghz
> 1 GB RAM
&g
Problem: I am migrating servers, from a dual PIII-866 Mhz with 384 MB of
RAM running Linux to the following server configuration:
Dual Athlon 1.5 Ghz
1 GB RAM
2 x 18 GIG SCSI drives.
FreeBSD 4.7-Stable
MySQL-Max-3.23.54a (ELF) i.e. without linuxthreads - runs on only 1 process.
I am trying to i
Is anyone else seeing odd problems with heavy use of UNIONs on a MySQL
4.0.x server on FreeBSD?
I seem to be able to induce the problem on FreeBSD but not Linux. I
have a lot more testing to do yet, but if someone else is seeing it
that would really help to narrow the bug down.
Thanks,
Jeremy
äÏÂÒÙÊ ÄÅÎØ.
> > | table_cache | 256 |
> > +---+---+
> >
> > m1# mysql -e "show status like 'Open%'"
> > +---+---+
> > | Variable_name | Value |
> > +---+---+
> > | Open_tables | 256 |
> > | Open_files| 446 |
> > | Open_streams | 0
In the last episode (Mar 22), Ozette Brown said:
> Dan,
>
> I guess I'm not hitting my systems openfile limit because I do not see "file table
>full"
> in my /var/log/messages.
> Here's the other info you inquired about:
>
> m1# sysctl kern.maxfiles kern.maxfilesperproc kern.openfiles
> kern.ma
Dan Nelson wrote:
> In the last episode (Mar 22), Ozette Brown said:
> > Andrey,
> >
> > Thank you for the reply.
> >
> > I read somewhere that when checking your maximum file descriptors your
>"kern.maxfiles
> > should be greater than kern.maxfilesperproc. My settings are:
> > kern.maxfiles =
In the last episode (Mar 22), Ozette Brown said:
> Andrey,
>
> Thank you for the reply.
>
> I read somewhere that when checking your maximum file descriptors your "kern.maxfiles
> should be greater than kern.maxfilesperproc. My settings are:
> kern.maxfiles = 8232
> kern.maxfilesperproc = 8232
; > I've tried upping the "mbufs", checking the "file descriptors",
> > "tweaking the mysqld server params", applying "soft-updates", and
> > "turning off Apache::DBI", nothing seems to work. I've seen at least 2
> > o
quot;, applying "soft-updates", and
> "turning off Apache::DBI", nothing seems to work. I've seen at least 2
> other mailing list entries where people have the exact same problem.
> The only solution I received was to switch to a Linux OS.
>
> I've al
king the mysqld server params", applying "soft-updates", and
"turning off Apache::DBI", nothing seems to work. I've seen at least 2
other mailing list entries where people have the exact same problem.
The only solution I received was to switch to a Linux OS.
I'
Chris Aitken wrote:
> I am writing a perl script on FreeBSD 4.3 running PHP and MySQL, however i
> get the following error message when I try and use DBI to connect to a
> MySQL database to pull some data.
>
> Can't locate DBI.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach
> /usr/libda
I am writing a perl script on FreeBSD 4.3 running PHP and MySQL, however i
get the following error message when I try and use DBI to connect to a
MySQL database to pull some data.
Can't locate DBI.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach
/usr/libdata/perl/5.0
0503 /usr/local/li
31 matches
Mail list logo
