Bonjour,
n'ayant pas trouvé mon bonheur sur le forum "PHP & MySQL" (post ici), je me dis que j'aurai peut-être plus de réponses ici..
En résumé, j'ai un script PHP dans lequel il me semble qu'il y a plusieurs connexions à la base de données. Je me suis servi de "SHOW STATUS" pour trouver le nombre de connexions simultanées, mais je ne comprend pas trop le sens des résultats.
Pour faire plus simple, j'ai créé un fichier de test, dans lequel j'ouvre 4 connexions à la même base de données :
ce qui me donne comme résultats :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
52
53
54
55
56
57
58
59
60 $GLOBALS['SQL_ADDRESS']='mon_host'; $GLOBALS['SQL_LOGIN']='mon_login'; $GLOBALS['SQL_PASSWORD']='mon_password'; $GLOBALS['SQL_DB']='ma_base'; $connect = mysql_connect($GLOBALS["SQL_ADDRESS"],$GLOBALS["SQL_LOGIN"],$GLOBALS["SQL_PASSWORD"]); $db = mysql_select_db($GLOBALS['SQL_DB']); echo "<u>1ère connexion</u><br>"; $res_process = mysql_query('SHOW STATUS LIKE \'Connections\''); while ($row_status = mysql_fetch_array($res_process)) { print_r($row_status);echo "<br>"; } mysql_free_result($res_process); $res_process = mysql_query('SHOW STATUS LIKE \'THREAD%\''); while ($row_status = mysql_fetch_array($res_process)) { print_r($row_status);echo "<br>"; } mysql_free_result($res_process); $connect2 = mysql_connect($GLOBALS["SQL_ADDRESS"],$GLOBALS["SQL_LOGIN"],$GLOBALS["SQL_PASSWORD"]); $db2 = mysql_select_db($GLOBALS['SQL_DB']); echo "<u>2ème connexion</u><br>"; $res_process = mysql_query('SHOW STATUS LIKE \'Connections\''); while ($row_status = mysql_fetch_array($res_process)) { print_r($row_status);echo "<br>"; } mysql_free_result($res_process); $res_process = mysql_query('SHOW STATUS LIKE \'THREAD%\''); while ($row_status = mysql_fetch_array($res_process)) { print_r($row_status);echo "<br>"; } mysql_free_result($res_process); $connect3 = mysql_connect($GLOBALS["SQL_ADDRESS"],$GLOBALS["SQL_LOGIN"],$GLOBALS["SQL_PASSWORD"]); $db3 = mysql_select_db($GLOBALS['SQL_DB']); echo "\t<u>3ème connexion</u><br>"; $res_process = mysql_query('SHOW STATUS LIKE \'Connections\''); while ($row_status = mysql_fetch_array($res_process)) { print_r($row_status);echo "<br>"; } mysql_free_result($res_process); $res_process = mysql_query('SHOW STATUS LIKE \'THREAD%\''); while ($row_status = mysql_fetch_array($res_process)) { print_r($row_status);echo "<br>"; } mysql_free_result($res_process); $connect4 = mysql_connect($GLOBALS["SQL_ADDRESS"],$GLOBALS["SQL_LOGIN"],$GLOBALS["SQL_PASSWORD"]); $db4 = mysql_select_db($GLOBALS['SQL_DB']); echo "<u>4ème connexion</u><br>"; $res_process = mysql_query('SHOW STATUS LIKE \'Connections\''); while ($row_status = mysql_fetch_array($res_process)) { print_r($row_status);echo "<br>"; } mysql_free_result($res_process); $res_process = mysql_query('SHOW STATUS LIKE \'THREAD%\''); while ($row_status = mysql_fetch_array($res_process)) { print_r($row_status);echo "<br>"; } mysql_free_result($res_process);
1ère connexionArray ( [0] => Connections [Variable_name] => Connections [1] => 70765 [Value] => 70765 )
Array ( [0] => Threads_cached [Variable_name] => Threads_cached [1] => 6 [Value] => 6 )
Array ( [0] => Threads_connected [Variable_name] => Threads_connected [1] => 2 [Value] => 2 )
Array ( [0] => Threads_created [Variable_name] => Threads_created [1] => 39 [Value] => 39 )
Array ( [0] => Threads_running [Variable_name] => Threads_running [1] => 2 [Value] => 2 )
2ème connexionArray ( [0] => Connections [Variable_name] => Connections [1] => 70765 [Value] => 70765 )
Array ( [0] => Threads_cached [Variable_name] => Threads_cached [1] => 6 [Value] => 6 )
Array ( [0] => Threads_connected [Variable_name] => Threads_connected [1] => 2 [Value] => 2 )
Array ( [0] => Threads_created [Variable_name] => Threads_created [1] => 39 [Value] => 39 )
Array ( [0] => Threads_running [Variable_name] => Threads_running [1] => 2 [Value] => 2 )
3ème connexionArray ( [0] => Connections [Variable_name] => Connections [1] => 70765 [Value] => 70765 )
Array ( [0] => Threads_cached [Variable_name] => Threads_cached [1] => 6 [Value] => 6 )
Array ( [0] => Threads_connected [Variable_name] => Threads_connected [1] => 2 [Value] => 2 )
Array ( [0] => Threads_created [Variable_name] => Threads_created [1] => 39 [Value] => 39 )
Array ( [0] => Threads_running [Variable_name] => Threads_running [1] => 2 [Value] => 2 )
4ème connexionArray ( [0] => Connections [Variable_name] => Connections [1] => 70765 [Value] => 70765 )
Array ( [0] => Threads_cached [Variable_name] => Threads_cached [1] => 6 [Value] => 6 )
Array ( [0] => Threads_connected [Variable_name] => Threads_connected [1] => 2 [Value] => 2 )
Array ( [0] => Threads_created [Variable_name] => Threads_created [1] => 39 [Value] => 39 )
Array ( [0] => Threads_running [Variable_name] => Threads_running [1] => 2 [Value] => 2 )
sauf que je ne sais absolument pas interpréter ces résultats..qui peut m'éclairer ?
Partager