Database Performance Blog

15 Jun 2006

FreeBSD tests

By Vadim Tkachenko Benchmarks GitHub, InnoDB, MyISAM, Operating Systems 15 Comments

I’m continuing my experiments with different OS and today I tested FreeBSD 6.0 on my box.
(more details about box and benchmark see here https://www.percona.com/blog/2006/06/13/quick-look-at-ubuntu-606/).
Initially I was very pessimistic about FreeBSD, as results were (in transactions/sec, more is better.
for comparison the results from Suse 10.0):

InnoDB

threads
FreeBSD 6
Suse 10.0
Suse/ FreeBSD ratio

1
436.97
536.91
1.23

4
322.08
816.27
2.53

16
519.94
639.05
1.23

64
crash
547.07

256

357.09

MyISAM

threads
FreeBSD 6
Suse 10.0
Suse/ FreeBSD ratio

1
335.56
429.89
1.28

4
165.16
863.23
5.23

16
322.66
537.67
1.67

64
crash
516.00

256

346.65

The crash with […]

13 Jun 2006

MyISAM concurrent insert

By Vadim Tkachenko Benchmarks, Insight for DBAs GitHub, MyISAM, Operating Systems 12 Comments

Arjen posted a good note about MyISAM concurrent-insert features, though I should mention concurrent-insert can be cause of
scalablity and peformance problems on SMP boxes, especially on queries processing range-queries. The reason of problems is POSIX read-write locks, which are used to protect key_buffer from concurrent changes and called for each processed row. More info […]

13 Jun 2006

Quick look at Ubuntu 6.06

By Vadim Tkachenko Benchmarks GitHub, InnoDB, LAMP, MyISAM 3 Comments

There are a lot of talks around new coming Ubuntu 6.06, so I decided to make quick benchmarks.
I used sysbench 0.4.6 oltp-read-only workload with 1000000 rows against InnoDB and MyISAM tables.
Such workload is CPU-bound and allows to compare CPU / OS if we are using the same version of MySQL.
So I used MySQL 5.0.22 […]

09 Jun 2006

Why MySQL Could Be Slow With Large Tables

By Peter Zaitsev Insight for DBAs, MySQL GitHub, MySQL, Production, Tips 152 Comments

If you’ve been reading enough database-related forums, mailing lists, or blogs you have probably heard complains about MySQL being unable to handle more than 1,000,000 (or select any other number) rows by some of the users. On the other hand, it is well known with customers like Google, Yahoo, LiveJournal, and Technorati, MySQL has […]

08 Jun 2006

MySQL Server Variables – SQL layer or Storage Engine specific.

By Peter Zaitsev Insight for DBAs GitHub, MySQL Server Variables, Tips 15 Comments

MySQL Server has tons of variables which may be adjusted to change behavior or for performance purposes. They are documented in the manual as well as on new page Jay has created. Still I see constant confusion out where which of variables apply to storage engines only and which are used on […]

FreeBSD tests

MyISAM concurrent insert

Quick look at Ubuntu 6.06

Why MySQL Could Be Slow With Large Tables

MySQL Server Variables – SQL layer or Storage Engine specific.

Upcoming Webinars

Services

Products

Resources

More

About

Contact Us