Re: MySql crashes

[Wim Roffel]

Thank you for your response.

The site keeps crashing every two or three days. (I am now busy implementing swapping).

I looked with the top command at memory use and got at some point of time the following:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1708 toppers 20 0 128760 33984 24576 S 3.0 3.3 0:13.99 php5-cgi
1671 toppers 20 0 127164 26972 19352 S 1.7 2.6 0:08.28 php5-cgi
1066 mysql 20 0 458136 139420 6476 S 1.0 13.6 0:13.48 mysqld
1826 root 20 0 11148 3888 3112 S 1.0 0.4 0:00.08 sshd
2892 www-data 20 0 128272 8372 2528 S 0.7 0.8 0:00.40 apache2
3990 root 20 0 5420 1404 1052 R 0.3 0.1 0:00.35 top
1 root 20 0 4332 2344 1392 S 0.0 0.2 0:01.73 init

I assume that the VIRT column indicates how much memory I am using. That fits with the indication that only 150k is free (the %MEM column seems meaningless). However, that suggests that when 4 users would use the site that would mean 2x128k extra and crash the site.

What puzzles me is why mysql and the application use as much memory as they use and whether that is configurable.