# Memory Problem - server always crashes.

**URL:** <https://forums.percona.com/t/memory-problem-server-always-crashes/939>\
**Category:** Other MySQL® Questions\
**Created:** [September 23, 2008, 7:02am UTC](https://forums.percona.com/t/memory-problem-server-always-crashes/939 "2008-09-23T07:02:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![a\_h\_uk](https://avatars.discourse-cdn.com/v4/letter/a/b19c9b/32.png) [@a\_h\_uk](https://forums.percona.com/u/a_h_uk)\
**Post date:** [September 23, 2008, 7:02am UTC](https://forums.percona.com/t/memory-problem-server-always-crashes/939/1 "2008-09-23T07:02:38Z")

</div>

I have a virtual dedicated server with 512MB RAM and 2GB Bursted RAM.

When my website gets busy, the server crashes and I have to restart the server to get my site back online. However, this is only temporary and happens again every few hours.

I contacted my host’s support department who said it was a memory problem. I checked the “top” command in SSH, and saw that mysql was using the most memory.

I think it maybe something to do with my my.cnf file configuration. Can someone please take a look: This is the file.

[mysqld]  
datadir=/var/lib/mysql  
socket=/var/lib/mysql/mysql.sock  
max\_connections=700  
max\_user\_connections=500  
interactive\_timeout=20  
wait\_timeout=20  
connect\_timeout=6  
thread\_cache\_size=128  
key\_buffer=16M  
join\_buffer=1M  
max\_allowed\_packet=64M  
table\_cache=1024  
record\_buffer=1M  
sort\_buffer\_size=2M  
read\_buffer\_size=2M  
max\_connect\_errors=1000

# Try number of CPU’s\*2 for thread\_concurrency

thread\_concurrency=4  
myisam\_sort\_buffer\_size=64M  
#log-bin  
server-id=1

[safe\_mysqld]  
err-log=/var/log/mysqld.log  
pid-file=/var/lib/mysql/mysql.pid  
open\_files\_limit=8192

[mysqldump]  
quick  
max\_allowed\_packet=16M

[mysql]  
no-auto-rehash  
#safe-updates

[isamchk]  
key\_buffer=32M  
sort\_buffer=32M  
read\_buffer=16M  
write\_buffer=16M

[myisamchk]  
key\_buffer=32M  
sort\_buffer=32M  
read\_buffer=16M  
write\_buffer=16M

Any help will be greatly appreciated.

Thanks

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [December 25, 2009, 11:06am UTC](https://forums.percona.com/t/memory-problem-server-always-crashes/939/2 "2009-12-25T11:06:25Z")

</div>

I don’t see anything wrong with your config. It might be the queries you are running.