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 :
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);
ce qui me donne comme résultats :
1ère connexion
Array ( [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 connexion
Array ( [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 connexion
Array ( [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 connexion
Array ( [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 ?