Thank you everyone for your comments!
On Sun, Oct 3, 2010 at 11:19 AM, Ivan Voras wrote:
> On 10/02/10 22:18, Rumen Telbizov wrote:
> > pool: tank
> > config:
> >
> > NAME STATE READ WRITE CKSUM
> > tank ONLINE 0 0 0
> > mirror
On 10/02/10 22:18, Rumen Telbizov wrote:
> pool: tank
> config:
>
> NAME STATE READ WRITE CKSUM
> tank ONLINE 0 0 0
> mirror ONLINE 0 0 0
> gpt/tank0 ONLINE 0 0 0
> gpt/tank
The tunings between your Linux and FreeBSD instances differ severely,
> and some of the variables don't even exist any longer (example:
> table_cache is now known as table_open_cache as of MySQL 5.1.3, and
> probably key_buffer vs. key_buffer_size too).
>
> Can you please rule out MySQL tunings bei
- Original Message -
From: Rumen Telbizov
To: Steven Hartland
Cc: freebsd-stable@freebsd.org
Sent: Saturday, October 02, 2010 9:18 PM
Subject: Re: MySQL performance concern
Hello everyone,
Here's the requested information below:
FreeBSD mysql 5.1.51:
my.cnf:
On Sat, Oct 02, 2010 at 01:18:20PM -0700, Rumen Telbizov wrote:
> Hello everyone,
>
> Here's the requested information below:
The tunings between your Linux and FreeBSD instances differ severely,
and some of the variables don't even exist any longer (example:
table_cache is now known as table_ope
Hello everyone,
Here's the requested information below:
FreeBSD mysql 5.1.51:
my.cnf:
skip-external-locking
key_buffer_size = 8192M
max_allowed_packet = 16M
table_open_cache = 2048
sort_buffer_size = 64M
read_buffer_size = 8M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 256M
thread_cache
When you say similar hardware whets the actual spec?
What do you have set in my.cnf?
What config options are you using for zfs?
- Original Message -
From: "Rumen Telbizov"
To:
Sent: Saturday, October 02, 2010 8:06 AM
Subject: MySQL performance concern
Hello everyone,
I am experi
On Sat, 02 Oct 2010 09:06:52 +0200, Rumen Telbizov
wrote:
Hello everyone,
I am experimenting with MySQL running on FreeBSD and comparing with
another
(older) setup running on a Linux box.
My results show that performance on Linux is significantly better than
FreeBSD although the hardware
On 02/10/2010 08:06:52, Rumen Telbizov wrote:
> Hello everyone,
>
> I am experimenting with MySQL running on FreeBSD and comparing with another
> (older) setup running on a Linux box.
> My results show that performance on Linux is significantly better than
> FreeBSD although the hardware is weaker