|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2011-09-25 13:21 UTC] johannes@php.net
-Status: Open
+Status: Bogus
[2011-09-25 13:21 UTC] johannes@php.net
[2011-09-25 13:49 UTC] linuxaomi at operamail dot com
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Wed Oct 22 09:00:01 2025 UTC |
Description: ------------ PHP 5.3.5 / MySQL 5.5.8 / XAMPP 1.7.4 for LINUX MySQL maintains two variables in information_schema.global_status: QUERIES and QUESTIONS. mysql_stat throws QUESTIONS but displays variable QUERIES. Problem has also been around in PHP 5.1 Test script: --------------- from php.net documentation <?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); $status = explode(' ', mysql_stat($link)); print_r($status); ?> Array ( [0] => Uptime: 5380 [1] => Threads: 2 [2] => Questions: 1321299 [3] => Slow queries: 0 [4] => Opens: 26 [5] => Flush tables: 1 [6] => Open tables: 17 [7] => Queries per second avg: 245.595 ) Expected result: ---------------- [2] => Queries: 1321299