Menghitung Current Mysql Max Connection

Script berikut ini berfungsi menghitung jumlah koneksi aktif di database mysql. SCript ini bisa anda gunakan untuk monitoring query yang mungkin looping sehingga mengakibatkan koneksi database terputus.

Berikut ini scriptnya

<?php
define('DB_HOST','mysql_host');
define('DB_USER','mysql_user');
define('DB_PASSWORD','mysql_passwd');

$conn = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('Could not connect: ' . mysql_error());
echo "TOTAL Koneksi<br>";
$rs = mysql_query("SELECT host,count(host) FROM information_schema.processlist GROUP BY host");
$data = mysql_fetch_assoc($rs);
echo "<pre>";
print_r($data);
echo "</pre>";

echo "Total Thread<br>";
$rs = mysql_query("SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE variable_name='threads_connected'");
$data = mysql_fetch_assoc($rs);
echo "<pre>";
print_r($data);
echo "</pre>";

echo "Listing Proses<br>";
$processlist=array();
$rs = mysql_query("SELECT host,command,info FROM information_schema.processlist");
while($row=mysql_fetch_assoc($rs)){
     $processlist[] = $row['host'].' '.$row['command'].' '.$row['info'];
}
echo "<pre>";
print_r($processlist);
echo "</pre>";

?>

Selamat mencoba

Leave a Reply

Your email address will not be published. Required fields are marked *

What is 15 + 12 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)

 

Wordpress SEO Plugin by SEOPressor