Alıntı:
{Üstat}´isimli üyeden Alıntı
benim makinem p4 3.2 2 gb ram i var linux centos plesk 8.1 kurulu ağırlık hep php siteler mysql versiyonu 4.1.20
Kod:
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
buda top
Kod:
5:55pm up 4:12, 2 users, load average: 4.55, 3.07, 2.48
130 processes: 126 sleeping, 4 running, 0 zombie, 0 stopped
CPU states: 43.8% user, 11.8% system, 0.0% nice, 44.3% idle
Mem: 2066544K av, 1424700K used, 641844K free, 0K shrd, 103332K buff
Swap: 1510100K av, 0K used, 1510100K free 801728K cached
PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND
4770 mysql 15 0 143M 39M 4648 S 0 32.4 1.9 57:24 mysqld
15948 apache 16 0 65484 38M 4516 S 0 21.9 1.8 0:02 httpd
15973 apache 15 0 67188 40M 4940 S 0 12.8 1.9 0:05 httpd
17097 apache 16 0 66680 39M 4188 S 0 10.0 1.9 0:01 httpd
17209 apache 17 0 65108 37M 4416 S 0 9.5 1.8 0:01 httpd
16468 apache 16 0 60200 34M 4316 R 0 2.3 1.7 0:00 httpd
15941 apache 16 0 65720 38M 4520 R 0 0.4 1.9 0:02 httpd
15972 apache 15 0 65852 38M 4520 S 0 0.4 1.9 0:02 httpd
17288 root 16 0 2612 1692 1476 R 0 0.4 0.0 0:00 top
1 root 16 0 3544 560 480 S 0 0.0 0.0 0:00 init
2 root 0K 0 0 0 0 SW 0 0.0 0.0 0:00 migration/0
3 root 34 19 0 0 0 SWN 0 0.0 0.0 0:00 ksoftirqd/0
4 root 0K 0 0 0 0 SW 0 0.0 0.0 0:00 migration/1
5 root 34 19 0 0 0 SWN 0 0.0 0.0 0:00 ksoftirqd/1
6 root 5 -10 0 0 0 SW< 0 0.0 0.0 0:00 events/0
normalde cpu %80-90 larda geziyor |
sadece [mysqld] bolumunu asagidaki sekilde duzenle, innodb kullaniyorsan skip-innodb satirini kaldir.
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-locking
skip-innodb
key_buffer = 256M
table_cache = 1024
max_connections = 500
query-cache-type = 1
query-cache-size = 64M