RE: 6.2 Stable + Mysql 5.0 poor performance

Hello Taseff:

-----Original Message-----
From: owner-freebsd-performance@xxxxxxxxxxx [mailto:owner-freebsd-
performance@xxxxxxxxxxx] On Behalf Of ivo tasev
Sent: Friday, May 11, 2007 2:02 AM
To: freebsd-performance@xxxxxxxxxxx
Subject: 6.2 Stable + Mysql 5.0 poor performance

Hi all,
i have machine with 2 x Quad Core Xeon cpu`s 2G ram and 4 3ware disks
in
raid10. There is 6.2 Stable on it and mysql 5.0 from the ports.

The mysql is installed with the following build options:
WITH_XCHARSET=all WITH_OPENSSL=yes BUILD_OPTIMIZED=yes
WITH_ARCHIVE=yes
WITH_FEDERATED=yes WITH_NDB=yes

I`m using libmap.conf with this in it:

[mysqld]
libpthread.so.2 libthr.so.2

This is what I have in my.cnf :

set-variable = key_buffer=1024M
set-variable = max_allowed_packet=64M
set-variable = thread_stack=1024K
set-variable = read_buffer_size=2M
set-variable = read_buffer_size=2M

set-variable = max_connections=350
set-variable = interactive_timeout=100
set-variable = wait_timeout=120
set-variable = max_user_connections=340

set-variable = query_cache_limit=1M
set-variable = query_cache_size=32M
set-variable = query_cache_type=1

set-variable = table_cache=1024
set-variable = thread_cache=128
set-variable = thread_cache_size=40
set-variable = thread_concurrency=16

I`m performing the following test with super-smack:
:~# time super-smack -d mysql
/usr/local/share/super-smack/select-key.smack 10 10000

the results are:Query Barrel Report for client smacker1
connect: max=1ms min=0ms avg= 0ms from 10 clients
Query_type num_queries max_time min_time
q_per_s
select_index 200000 0 0 18599.71

I can achieve better performance even on my colleague`s notebook with
6.2 stable !?

I`ll be very thankful if someone can give me any ideas:)

Here are some system tweaks that may help.

/etc/sysctl.conf

kern.threads.max_groups_per_proc=40000
kern.threads.max_threads_per_proc=40000
kern.maxfiles=65535
kern.maxfilesperproc=65535

/etc/libmap.conf

[mysqld]
libpthread.so.2 libthr.so.2
libpthread.so libthr.so

/boot/loader.conf

kern.maxdsiz="1073741824" # 1GB
kern.dfldsiz="1073741824" # 1GB
kern.maxssiz="134217728" # 128MB

Mike

_______________________________________________
freebsd-performance@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: [SLE] I HAD IT WORKING! MySQL under SuSE 9.0 Woes
    ... 040413 07:10:29 mysqld started ... 040413 7:10:32 Can't init databases ... Starting service MySQL ... Preparing host table ...
    (SuSE)
  • Re: mysql ??
    ... >>Mike I seem to be making some head way, I have the server running a sock ... > Definitely looks like a grant table problem. ... this is the weakest point in the mysql install procedure - you ... > the whole permission system while I muck with getting mysqld set up ...
    (alt.os.linux.suse)
  • Re: EMERGENCY - need to secure my server against an ongoing SPAMMER
    ... Most of my sites are dynamic and heavily rely on MySql. ... > that mysqld actually failed. ... Putting back the old files I noticed the log error was specifically ... access rights, disabled SELinux, and hey presto mysqld works again. ...
    (Fedora)
  • MySQL 4.0.18 server problem on FreeBSD 5.2-Current
    ... 040323 19:52:50 mysqld restarted ... 040323 19:52:50 InnoDB: Started ... I tried with linuxthreads-2.2.3_15 and linuxthreads-2.2.3_13 but mysql ... I even tried to downgrade mysql server to 4.0.17 but same error. ...
    (freebsd-current)
  • Errors in MYSQL 4.1.1
    ... Although a log ot really good work has been done on MYSQL, ... Lost connection to MySQL server during query ... $ Set NoOn ... It is possible that mysqld could use up to ...
    (comp.os.vms)