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
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.
This may help - I just got this from a friend.
http://jeremy.zawodny.com/blog/archives/000203.html
--Joe
--
Joe Stump <[EMAIL PROTECTED]>
http://www.joestump.net
"Label makers are proof God wants Sys Admins to be happy."
-Original Message-
From: Matthias Trevarthan [mailto:[EMAIL PROTE
> 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
Hi Maximo,
The problem is that you have a config that requires more memory
than you have available. Please reduce key buffer, record buffer and
sort buffer. The clues are:
030117 17:02:55 Out of memory; Check if mysqld or some other
process uses
key_buffer_size + (record_buffer + sort_buff
äÏÂÒÙÊ ÄÅÎØ.
> > | 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
Andrey Kotrekhov wrote:
> äÏÂÒÙÊ ÄÅÎØ.
>
> I have the same problem.
> We increase max number of users in the kernel config and recompile.
> The problem is solve at most.
> Try to increase max number of open files in kernel.
>
> > Hi,
> >
> > I'm currently running FreeBSD 4.3-stable with MySQL 3.2
äÏÂÒÙÊ ÄÅÎØ.
I have the same problem.
We increase max number of users in the kernel config and recompile.
The problem is solve at most.
Try to increase max number of open files in kernel.
> Hi,
>
> I'm currently running FreeBSD 4.3-stable with MySQL 3.23.39. My problem
> is weird an unpreditab
17 matches
Mail list logo
