# msyql 5.0 and sysbench can't get over 550T/s

**URL:** <https://forums.percona.com/t/msyql-5-0-and-sysbench-cant-get-over-550t-s/508>\
**Category:** Other MySQL® Questions\
**Created:** [October 31, 2007, 12:56am UTC](https://forums.percona.com/t/msyql-5-0-and-sysbench-cant-get-over-550t-s/508 "2007-10-31T00:56:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![luma](https://avatars.discourse-cdn.com/v4/letter/l/d6d6ee/32.png) [@luma](https://forums.percona.com/u/luma)\
**Post date:** [October 31, 2007, 12:56am UTC](https://forums.percona.com/t/msyql-5-0-and-sysbench-cant-get-over-550t-s/508/1 "2007-10-31T00:56:28Z")

</div>

Hi everyone,

I am doing a read only test on freebsd 7.0beta 64bit.  
The server is:  
dual xeon 3.2  
5 gigs of ram  
490gig RAID 10 array  
Hyper threading DISABLED (enabled I get 450T/s or so)

The OS has just been freshly installed. After the install I installed from ports:  
Bash  
mysql 5.0.45  
wget

I prepared the database using:  
sysbench --test=oltp --num-threads=4 --mysql-user=root --max-time=60 --max-requests=0 --oltp-read-only=on --oltp-table-size=1000000 prepare

Then I did a 6 minute warm up using:  
sysbench --test=oltp --num-threads=4 --mysql-user=root --max-time=360 --max-requests=0 --oltp-read-only=on --oltp-table-size=1000000 run

Then several runs with the same command but 60 seconds.

I get 545 to 550 every time.

I have tried the 4BSD and the ULE scheduler.

Here is my my.cnf:

[client]#password = your\_passwordport = 3306socket = /tmp/mysql.sock[server]port=3306socket=/tmp/mysql.sockuser=mysqldatadir=/var/db/mysql/basedir=/usr/localmax\_connections=3000max\_connect\_errors=10table\_cache=2048max\_allowed\_packet=1Mbinlog\_cache\_size=1Mmax\_heap\_table\_size=64Msort\_buffer\_size=64Kjoin\_buffer\_size=1Mthread\_cache=16thread\_concurrency=4thread\_stack=196Kquery\_cache\_size=0ft\_min\_word\_len=4default\_table\_type=MYISAMtransaction\_isolation=REPEATABLE-READtmp\_table\_size=64Mskip-lockingserver-id=1innodb\_status\_file=0innodb\_data\_home\_dir=/var/db/mysql/innodb\_data\_file\_path=ibdata1:100M:autoextendinnodb\_log\_group\_home\_dir=/var/db/mysql/innodb\_buffer\_pool\_size=500Minnodb\_additional\_mem\_pool\_size=20Minnodb\_log\_file\_size=900Minnodb\_log\_files\_in\_group=2innodb\_log\_buffer\_size=8Minnodb\_flush\_log\_at\_trx\_commit=1innodb\_lock\_wait\_timeout=300innodb\_locks\_unsafe\_for\_binlog=1innodb\_thread\_concurrency=0

Any ideas on how I can improve performance? Or are the numbers pretty good?

This is a test machine with no data on it so I can try anything )

Thanks

Luma