key_buffer, sort_buffer, record_buffer, max_connections parametreleri ile artirim yoluna gidebilirsiniz..
saygilar. -- ATILIM BOY http://www.enderunix.org/aboy Mesut GÜLNAZ wrote: > > 061228 12:53:06 Out of memory; Check if mysqld or some other process > uses all available memory. If not you may have to use 'ulimit' to > allow mysqld to use more memory or you can add more swap space > > > > Hatası alıyorum. > > > > last pid: 60524; load averages: 15.43, 18.32, 20.05 > up 9+01:25:02 12:55:35 > > 387 processes: 4 running, 383 sleeping > > CPU states: % user, % nice, % system, % interrupt, > % idle > > Mem: 586M Active, 2544M Inact, 294M Wired, 168M Cache, 112M Buf, 234M Free > > Swap: 6144M Total, 80K Used, 6144M Free > > > > PID USERNAME PRI NICE SIZE RES STATE TIME WCPU > CPU COMMAND > > 59890 mysql 20 0 539M 97168K kserel 6:34 49.02% > 49.02% mysqld > > 60361 www 4 0 31252K 16464K sbwait 0:00 0.20% > 0.20% httpd > > 60079 www 4 0 30776K 15940K sbwait 0:01 0.15% > 0.15% httpd > > > > > > > > -su-2.05b# ps auxwww | grep mysql > > mysql 59853 0,0 0,0 1788 1152 p0 I 12:45PM 0:00,01 > /bin/sh /usr/local/bin/mysqld_safe > --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql > --datadir=/var/db/mysql --pid-file=/var/db/mysql/www.domain.com.pid -O > max_connection=1000 > > mysql 59890 0,0 2,4 551704 97700 p0 S 12:45PM 7:17,55 > /usr/local/libexec/mysqld --defaults-extra-file=/var/db/mysql/my.cnf > --basedir=/usr/local --datadir=/var/db/mysql --user=mysql > --pid-file=/var/db/mysql/www.domain.com.pid --port=3306 > --socket=/tmp/mysql.sock -O max_connection=1000 > > -su-2.05b# > > > > Şeklinde çalışıyor. > > > > Apache ye olan istek sayısı: > > > > -su-2.05b# netstat -an | grep 100.80 | wc -l > > 1184 > > -su-2.05b# egrep MaxClients /usr/local/etc/apache/httpd.conf > > MaxClients 512 ==================è bu değeri 150 den max olan 512 ye > ben çıkardım. > > -su-2.05b# > > > > Örnek birkaç satır > > > > tcp4 0 0 100.100.100.100.80 *.* LISTEN > > tcp4 0 65559 100.100.100.100.80 88.234.103.242.1498 > FIN_WAIT_1 > > tcp4 0 64405 100.100.100.100.80 85.102.109.0.3054 > FIN_WAIT_1 > > tcp4 0 0 100.100.100.100.80 85.106.181.106.1831 > FIN_WAIT_2 > > tcp4 0 0 100.100.100.100.80 85.106.181.106.1830 > FIN_WAIT_2 > > tcp4 0 64777 100.100.100.100.80 85.102.210.77.2302 > FIN_WAIT_1 > > tcp4 0 65145 100.100.100.100.80 85.107.70.41.1477 > FIN_WAIT_1 > > tcp4 0 65872 100.100.100.100.80 81.213.133.163.2327 > FIN_WAIT_1 > > tcp4 0 55373 100.100.100.100.80 85.100.44.177.10329 > FIN_WAIT_1 > > tcp4 0 13844 100.100.100.100.80 83.66.102.39.2187 > FIN_WAIT_1 > > tcp4 0 46167 100.100.100.100.80 85.99.194.195.1449 > FIN_WAIT_1 > > tcp4 0 0 100.100.100.100.22 172.16.0.80.1428 > ESTABLISHED > > tcp4 0 36 100.100.100.100.22 172.16.0.80.1149 > ESTABLISHED > > > > disk durumu: > > > > /dev/ipsd0s1d 9.7G 2.5G 6.4G 28% /var > > > > Bu sorunu nasıl aşabilirim? Mysql performans değerlendirmesi yapabilen > bir tool var mı. Webserver performans test tool u gibi? > > > > Şimdiden teşekkürler. > --------------------------------------------------------------------- Listeye soru sormadan once lutfen http://ipucu.enderunix.org sitesine bakiniz. Cikmak icin, e-mail: [EMAIL PROTECTED] Liste arsivi: http://lists.enderunix.org Turkiye'nin ilk FreeBSD kitabi: http://www.acikakademi.com/catalog/freebsd
