Toon posts:

mysql wel erg vaak

Pagina: 1
Acties:
  • 132 views sinds 30-01-2008
  • Reageer

zondag 22 juli 2001 23:20

Acties:

Verwijderd

Topicstarter
code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

tcp   0 0 localhost:3821        localhost:mysql    TIME_WAIT   
tcp   0 0 localhost:mysql      localhost:1213       ESTABLISHED 
tcp   0 0 localhost:1213        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:1154       ESTABLISHED 
tcp   0 0 localhost:1154        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:1053       ESTABLISHED 
tcp   0 0 localhost:1053        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:1036       ESTABLISHED 
tcp   0 0 localhost:1036        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:1035       ESTABLISHED 
tcp   0 0 localhost:1035        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:1034       ESTABLISHED 
tcp   0 0 localhost:1034        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:1033       ESTABLISHED 
tcp   0 0 localhost:1033        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:1032       ESTABLISHED 
tcp   0 0 localhost:1032        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:4959       ESTABLISHED 
tcp   0 0 localhost:4959        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:4958       ESTABLISHED 
tcp   0 0 localhost:4958        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:4957       ESTABLISHED 
tcp   0 0 localhost:4957        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:4956       ESTABLISHED 
tcp   0 0 localhost:4956        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:4955       ESTABLISHED 
tcp   0 0 localhost:4955        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:4954       ESTABLISHED 
tcp   0 0 localhost:4954        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:4953       ESTABLISHED 
tcp   0 0 localhost:4953        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:4952       ESTABLISHED 
tcp   0 0 localhost:4952        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:4951       ESTABLISHED 
tcp   0 0 localhost:4951        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:4944       ESTABLISHED 
tcp   0 0 localhost:4944        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:4943       ESTABLISHED 
tcp   0 0 localhost:4943        localhost:mysql    ESTABLISHED 
tcp   0 0 localhost:mysql      localhost:4942       ESTABLISHED 
tcp   0 0 localhost:4942        localhost:mysql    ESTABLISHED 
unix  1 [ W ]    STREAM     CONNECTED     4142779 /var/lib/mysql/mysql.sock
unix  1 [ W ]    STREAM     CONNECTED     4142770 /var/lib/mysql/mysql.sock
unix  1 [ W ]    STREAM     CONNECTED     4142681 /var/lib/mysql/mysql.sock
unix  1 [ W ]    STREAM     CONNECTED     4142622 /var/lib/mysql/mysql.sock
unix  1 [ W ]    STREAM     CONNECTED     4141338 /var/lib/mysql/mysql.sock
unix  1 [ W ]    STREAM     CONNECTED     4131411 /var/lib/mysql/mysql.sock
unix  1 [ W ]    STREAM     CONNECTED     4131362 /var/lib/mysql/mysql.sock
unix  1 [ W ]    STREAM     CONNECTED     4122947 /var/lib/mysql/mysql.sock
unix  1 [ W ]    STREAM     CONNECTED     4113668 /var/lib/mysql/mysql.sock
unix  1 [ W ]    STREAM     CONNECTED     4112351 /var/lib/mysql/mysql.sock

dit kreeg ik te zien na een
code:
1

[root admin]# netstat | grep mysql |less

Betekend dit dat er gewoon veel mensen tegelijkertijd van een dbase gebruik maken? Of is het ernstiger. Had vanmiddag nog een scriptkidde eraf moeten gooien, dus ik ben een beetje huiverig.

maandag 23 juli 2001 01:45

Acties:
  • Coen Rosdorff
  • Registratie: Januari 2000
  • Niet online

Coen Rosdorff

Ziet eruit als php met persistent connecties enabled. Niks om je druk over te maken denk ik.

maandag 23 juli 2001 01:47

Acties:

Verwijderd

Doe eens een SHOW PROCESSLIST; in mysql.

maandag 23 juli 2001 07:35

Acties:
  • ACM
  • Registratie: Januari 2000
  • Niet online

ACM

Software Architect

Werkt hier

't Zijn allemaal lokale verbindingen.
Wat ik dan weer niet vat, is dat je zowel lokale netwerk- als socketvervindingen hebt.

Maar als je dat lijstje zou krijgen van t.net's database servers, zou je veel harder gillen ;)

Om te checken of het persistent php connecties zijn.
Kan je ook nog es 'ps xauf' doen, bij mysql is dat minder duidelijk dan bij postgresql te bekijken, maar je krijgt er een aardig overzicht van.
Reageer