Re: MySQL performance concern

2010-10-03 Thread Rumen Telbizov
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

Re: MySQL performance concern

2010-10-03 Thread Ivan Voras
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

Re: MySQL performance concern

2010-10-03 Thread Steven Williamson
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

Re: MySQL performance concern

2010-10-02 Thread Steven Hartland
- 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:

Re: MySQL performance concern

2010-10-02 Thread Jeremy Chadwick
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

Re: MySQL performance concern

2010-10-02 Thread Rumen Telbizov
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

Re: MySQL performance concern

2010-10-02 Thread Steven Hartland
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

Re: MySQL performance concern

2010-10-02 Thread Ronald Klop
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

Re: MySQL performance concern

2010-10-02 Thread Matthew Seaman
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