Jump to content

Recommended Posts

max connections non dovrebbe essere uguale a 1/2 della ram? (invece di 4000 ho messo 3000) comunque ho pensato che visto ho la ram libera la sfrutto... avrò anche sbagliato, ma era una prova.. :(

 

mysql> show processlist;

+-------+----------+-----------+------------+---------+------+-------+------------------+

| Id | User | Host | db | Command | Time | State | Info |

+-------+----------+-----------+------------+---------+------+-------+------------------+

| 31134 | root | localhost | NULL | Query | 0 | NULL | show processlist |

| 31144 | sito | localhost | dbsito | Sleep | 0 | | NULL |

+-------+----------+-----------+------------+---------+------+-------+------------------+

3 rows in set (0.00 sec)

Share this post


Link to post
Share on other sites

Ho portato a 300 max connections e ottimizzato tutte le tabelle (molte sono uscite corrotte).. vediamo se in quest'ora mi arriva una email di munin come ha fatto tutta la giornata...

 

Usu queste sono le informazioni:

 

velocità cpu / singolo o multiprocessore:

CPU number: 4

model name : Intel® Xeon® CPU X3360 @ 2.83GHz

model name : Intel® Xeon® CPU X3360 @ 2.83GHz

model name : Intel® Xeon® CPU X3360 @ 2.83GHz

model name : Intel® Xeon® CPU X3360 @ 2.83GHz

cpu MHz : 2830.000

cpu MHz : 2830.000

cpu MHz : 2830.000

cpu MHz : 2830.000

cache size : 6144 KB

cache size : 6144 KB

cache size : 6144 KB

cache size : 6144 KB

Ram:

Memory: used free (MB)

1269 6612

Tipo HD/configurazione:

ATA Hitachi HDS72107 (Direct-Access)

RAID 1 / software

 

Sistema Operativo:

Debian Lenny

 

apache version: 2.2.9 (Debian)

 

PHP version: 5.2.6-1+lenny3

 

MySQL version: 5.0.51a

 

TOP:

top - 20:04:52 up 43 days, 10:25, 1 user, load average: 11.17, 8.92, 8.34

Tasks: 248 total, 2 running, 235 sleeping, 0 stopped, 11 zombie

Cpu(s): 10.6%us, 5.9%sy, 0.0%ni, 77.1%id, 6.1%wa, 0.0%hi, 0.2%si, 0.0%st

Mem: 8072020k total, 7980704k used, 91316k free, 706012k buffers

Swap: 36869152k total, 1672756k used, 35196396k free, 5339436k cached

 

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

12630 nomesito1 20 0 119m 11m 5332 R 25 0.1 0:00.13 php-cgi

12628 nomesito2 20 0 0 0 0 Z 23 0.0 0:00.12 php-cgi <defunct>

12631 nomesito3 20 0 0 0 0 Z 19 0.0 0:00.10 php-cgi <defunct>

12634 root 20 0 0 0 0 Z 19 0.0 0:00.10 php-cgi <defunct>

30714 root 20 0 271m 33m 9592 D 12 0.4 0:20.31 php

20625 mysql 20 0 1262m 321m 5488 S 6 4.1 6:12.00 mysqld

9690 www-data 20 0 454m 54m 1504 S 2 0.7 0:01.11 apache2

9736 www-data 20 0 466m 56m 1912 S 2 0.7 0:01.05 apache2

1 root 20 0 10312 608 572 S 0 0.0 0:11.48 init

2 root 15 -5 0 0 0 S 0 0.0 0:00.01 kthreadd

3 root RT -5 0 0 0 S 0 0.0 0:29.63 migration/0

4 root 15 -5 0 0 0 S 0 0.0 2:47.85 ksoftirqd/0

5 root RT -5 0 0 0 S 0 0.0 0:50.78 migration/1

6 root 15 -5 0 0 0 S 0 0.0 2:20.60 ksoftirqd/1

7 root RT -5 0 0 0 S 0 0.0 1:15.03 migration/2

8 root 15 -5 0 0 0 S 0 0.0 1:31.28 ksoftirqd/2

9 root RT -5 0 0 0 S 0 0.0 1:23.50 migration/3

10 root 15 -5 0 0 0 S 0 0.0 1:10.42 ksoftirqd/3

11 root 15 -5 0 0 0 S 0 0.0 0:22.30 events/0

12 root 15 -5 0 0 0 S 0 0.0 0:18.18 events/1

13 root 15 -5 0 0 0 S 0 0.0 1:13.45 events/2

14 root 15 -5 0 0 0 S 0 0.0 0:27.10 events/3

15 root 15 -5 0 0 0 S 0 0.0 0:00.00 khelper

19 root RT -5 0 0 0 S 0 0.0 0:00.00 kstop/0

20 root RT -5 0 0 0 S 0 0.0 0:00.00 kstop/1

21 root RT -5 0 0 0 S 0 0.0 0:00.00 kstop/2

22 root RT -5 0 0 0 S 0 0.0 0:00.00 kstop/3

161 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/0

162 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/1

163 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/2

164 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/3

165 root 15 -5 0 0 0 S 0 0.0 0:06.77 kblockd/0

166 root 15 -5 0 0 0 S 0 0.0 0:02.09 kblockd/1

167 root 15 -5 0 0 0 S 0 0.0 0:04.88 kblockd/2

168 root 15 -5 0 0 0 S 0 0.0 0:02.33 kblockd/3

169 root 15 -5 0 0 0 S 0 0.0 0:00.00 kacpid

170 root 15 -5 0 0 0 S 0 0.0 0:00.00 kacpi_notify

238 root 15 -5 0 0 0 S 0 0.0 0:00.00 ata/0

239 root 15 -5 0 0 0 S 0 0.0 0:00.00 ata/1

 

KeepAlive On

MaxKeepAliveRequests 100

KeepAliveTimeout 15

 

<IfModule mpm_prefork_module>

StartServers 5

MinSpareServers 5

MaxSpareServers 10

MaxClients 150

MaxRequestsPerChild 0

</IfModule>

 

<IfModule mpm_worker_module>

StartServers 2

MaxClients 150

MinSpareThreads 25

MaxSpareThreads 75

ThreadsPerChild 25

MaxRequestsPerChild 0

</IfModule>

 

con find / -size +2000000k non ha dato risultatiuname - a:

Linux ******** 2.6.28.4-xxxx-std-ipv6-64 #4 SMP Wed Sep 9 22:10:20 UTC 2009 x86_64 GNU/Linux

 

ulimit -aH

core file size (blocks, -c) unlimited

data seg size (kbytes, -d) unlimited

scheduling priority (-e) 0

file size (blocks, -f) unlimited

pending signals (-i) 71680

max locked memory (kbytes, -l) 64

max memory size (kbytes, -m) unlimited

open files (-n) 16000

pipe size (512 bytes, -p) 8

POSIX message queues (bytes, -q) 819200

real-time priority (-r) 0

stack size (kbytes, -s) unlimited

cpu time (seconds, -t) unlimited

max user processes (-u) 71680

virtual memory (kbytes, -v) unlimited

file locks (-x) unlimited

Spero di aver dato informazioni utili... nel frattempo munin mi ha inviato un altra email di

Load average

WARNINGs: load is 11.51 (outside range [:10]) :(

Share this post


Link to post
Share on other sites

Ho fatto anche repair.. ogni tanto mi usciva note : The storage engine for the table doesn't support repair.. Comunque non si è risolto ancora :( ma non c'è nessun applicativo che dice cosa è in esecuzione per lungo tempo da far rallentare tutto? perchè a quanto ho capito apache e mysql non è che rallentano tanto..

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
Sign in to follow this  

×