Hello Taseff: > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:owner-freebsd- > [EMAIL PROTECTED] On Behalf Of ivo tasev > Sent: Friday, May 11, 2007 2:02 AM > To: freebsd-performance@freebsd.org > 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@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "[EMAIL PROTECTED]"
