makına p4 3.0 1 gb ram centoz direckadmin

cat /etc/my.cnf

[root@ipc1 ~]# cat /etc/my.cnf_orig
[mysqld]
datadir = /var/lib/mysql
basedir = /usr/
port = 3306
wait_timeout = 15
socket = /var/lib/mysql/mysql.sock
skip-locking
skip-innodb
max_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 60
connect_timeout = 30
tmp_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
query_cache_limit = 2M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 256M
sort_buffer = 256M
read_buffer = 2M
write_buffer = 2m

[mysqlhotcopy]
interactive-timeout
[root@ipc1 ~]#



[root@ipc1 ~]# uname -a
Linux ipc1.ipcare.nl 2.6.9-34.ELsmp #1 SMP Wed Mar 8 00:27:03 CST 2006 i686 i686 i386 GNU/Linux
[root@ipc1 ~]#


[root@ipc1 ~]# ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 16379
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[root@ipc1 ~]#


top - 09:49:34 up 1 day, 8:56, 1 user, load average: 4.59, 4.69, 3.00
Tasks: 134 total, 2 running, 132 sleeping, 0 stopped, 0 zombie
Cpu(s): 30.8% us, 9.9% sy, 0.0% ni, 10.5% id, 44.4% wa, 4.4% hi, 0.0% si
Mem: 1034332k total, 553712k used, 480620k free, 1736k buffers
Swap: 1048568k total, 21724k used, 1026844k free, 44144k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
24481 apache 16 0 33268 15m 4448 R 14 1.6 0:09.24 httpd
24483 apache 15 0 33916 17m 4460 S 9 1.7 0:10.37 httpd
29708 mysql 18 0 39332 15m 1620 D 9 1.5 0:00.31 mysqld
22071 apache 16 0 31488 14m 4460 S 8 1.5 0:05.98 httpd
29710 mysql 18 0 39332 15m 1620 S 7 1.5 0:00.22 mysqld
18972 apache 15 0 34160 17m 4476 S 6 1.7 0:18.76 httpd
26709 apache 16 0 31212 14m 4448 S 5 1.4 0:01.71 httpd
22072 apache 15 0 32720 16m 4456 S 2 1.6 0:09.53 httpd
21403 apache 15 0 31448 14m 4548 S 2 1.5 0:18.23 httpd
19300 apache 15 0 34020 17m 4460 S 1 1.7 0:16.00 httpd
14717 dovecot 16 0 4692 1108 1056 S 1 0.1 0:02.83 imap-login
15112 named 16 0 48004 2076 1612 S 1 0.2 0:03.41 named
18725 apache 15 0 32352 15m 4452 S 1 1.5 0:21.86 httpd
19714 apache 15 0 32108 15m 4564 S 1 1.5 0:14.52 httpd
25525 apache 16 0 30832 14m 4448 S 1 1.4 0:04.26 httpd
21399 apache 15 0 31336 14m 4452 S 0 1.4 0:18.06 httpd
24479 apache 15 0 34052 17m 4552 S 0 1.7 0:09.78 httpd



[root@ipc1 ~]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) 4 CPU 3.00GHz
stepping : 9
cpu MHz : 3002.341
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe lm pni monitor ds_cpl cid xtpr
bogomips : 6008.78

processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) 4 CPU 3.00GHz
stepping : 9
cpu MHz : 3002.341
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe lm pni monitor ds_cpl cid xtpr
bogomips : 5999.41

[root@ipc1 ~]#


[root@ipc1 ~]# free
total used free shared buffers cached
Mem: 1034332 521104 513228 0 2212 53628
-/+ buffers/cache: 465264 569068
Swap: 1048568 21724 1026844
[root@ipc1 ~]#