Re: 6.2 Stable + Mysql 5.0 poor performance

ivo tasev wrote:
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:)

Try looking at hard drive usage.

--
Sphinx of black quartz judge my vow!

_______________________________________________
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

  • 6.2 Stable + Mysql 5.0 poor performance
    ... There is 6.2 Stable on it and mysql 5.0 from the ports. ... I`m performing the following test with super-smack: ...
    (freebsd-performance)
  • Re: [PHP] mysql_affected_rows() function
    ... I use PHP v. 4.3.3 and MySQL v 4.1.0a and ... I have the same experience as Tyler. ... Also when performing INSERT and UPDATE ... commands. ...
    (php.general)
  • Re: MySQL PHP problems
    ... though when trying to access the result set returned by performing a ... I've performed queries on the database outwith ... php, and it correctly returned the correct details. ... You should *always* check the results of any call to MySQL and handle errors appropriately! ...
    (comp.lang.php)
  • Assigning values to arrays
    ... I am performing a MySQL SELECT (which returns multiple rows) to ... $result and then extracting the results with ...
    (comp.lang.php)
  • Re: [PHP] Slow searches in large database
    ... Start by checking the MySQL docs to find out if indexes are used with "IN" ... Given that you are essentially performing a sequential read of the ... db, not a PHP question. ... >We have a mysql database that has approximately 20,000 records and has a ...
    (php.general)