# Poor performance and crashing

**URL:** <https://forums.percona.com/t/poor-performance-and-crashing/1247>\
**Category:** Other MySQL® Questions\
**Created:** [August 26, 2009, 8:55am UTC](https://forums.percona.com/t/poor-performance-and-crashing/1247 "2009-08-26T08:55:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yaotzin](https://avatars.discourse-cdn.com/v4/letter/y/77aa72/32.png) [@Yaotzin](https://forums.percona.com/u/Yaotzin)\
**Post date:** [August 26, 2009, 8:55am UTC](https://forums.percona.com/t/poor-performance-and-crashing/1247/1 "2009-08-26T08:55:30Z")

</div>

I’ve got a virtual server with 256 RAM and 256 swap. I’ve ran load tests for this system but it seems, that over 100 users will bring mysql down. Could someone take a look at my my.cnf and tell if there’s something seriously wrong here.

I removed all comments to save space.

[client]port = 3306socket = /var/run/mysqld/mysqld.sock[mysqld]port = 3306socket = /var/run/mysqld/mysqld.sockskip-lockingkey\_buffer = 128Mmax\_allowed\_packet = 1Mtable\_cache = 256sort\_buffer\_size = 1Mread\_buffer\_size = 1Mread\_rnd\_buffer\_size = 4Mmyisam\_sort\_buffer\_size = 64Mthread\_cache\_size = 8query\_cache\_size= 16Mthread\_concurrency = 8log-bin=mysql-binserver-id = 1[mysqldump]quickmax\_allowed\_packet = 16M[mysql]no-auto-rehash# Remove the next comment character if you are not familiar with SQL#safe-updates[isamchk]key\_buffer = 128Msort\_buffer\_size = 128Mread\_buffer = 2Mwrite\_buffer = 2M[myisamchk]key\_buffer = 128Msort\_buffer\_size = 128Mread\_buffer = 2Mwrite\_buffer = 2M[mysqlhotcopy]interactive-timeoutlog\_slow\_queries = /var/log/mysql/mysql-slow.loglong\_query\_time = 2

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [August 26, 2009, 2:44pm UTC](https://forums.percona.com/t/poor-performance-and-crashing/1247/2 "2009-08-26T14:44:08Z")

</div>

Key\_buffer is a tad large if you also run a webserver. Aside from that, I can’t say much based on just your config. If you really got 128M of frequently used indices, you probably need a RAM upgrade.