note 104180 added to mysqli.get-connection-stats

No, the function mysqli_get_connection_stats() and the SQL statements "SHOW SESSION STATUS" do not return the same. mysqli_get_connection_stats() collects information at the client, within the PHP mysqlnd library. The information collected is not related to connection (session) statistics collected by the MySQL server. Using the SQL statement you can obtain rather server-centric data, such as "Created_tmp_files", whereas the mysqli_get_connection_stats() call gives rather client-centric data, such as "explicit_close" and "implicit_close". The information how many temporary tables have been created is only available at the server. The information how many PHP MySQL connections had to be closed implicitly by the PHP mysqlnd library is only available at the client. mysqli_get_connection_stats() and "SHOW SESSION STATUS" differ in: - where data is collected - how data is collected - what data is collected ---- Server IP: 85.214.154.209 Probable Submitter: 91.6.186.114 ---- Manual Page -- http://www.php.net/manual/en/mysqli.get-connection-stats.php Edit -- https://master.php.net/note/edit/104180 Del: integrated -- https://master.php.net/note/delete/104180/integrated Del: useless -- https://master.php.net/note/delete/104180/useless Del: bad code -- https://master.php.net/note/delete/104180/bad+code Del: spam -- https://master.php.net/note/delete/104180/spam Del: non-english -- https://master.php.net/note/delete/104180/non-english Del: in docs -- https://master.php.net/note/delete/104180/in+docs Del: other reasons-- https://master.php.net/note/delete/104180 Reject -- https://master.php.net/note/reject/104180 Search -- https://master.php.net/manage/user-notes.php