Bug #55666 [NEW]: mysql_stat says questions but outputs queries information_schema.global_statu

From: Operating system: LINUX PHP version: 5.3SVN-2011-09-10 (SVN) Package: MySQL related Bug Type: Bug Bug description:mysql_stat says questions but outputs queries information_schema.global_statu 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 -- Edit bug report at https://bugs.php.net/bug.php?id=55666&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=55666&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=55666&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=55666&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=55666&r=fixed Fixed in SVN and need be documented: https://bugs.php.net/fix.php?id=55666&r=needdocs Fixed in release: https://bugs.php.net/fix.php?id=55666&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=55666&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=55666&r=needscript Try newer version: https://bugs.php.net/fix.php?id=55666&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=55666&r=support Expected behavior: https://bugs.php.net/fix.php?id=55666&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=55666&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=55666&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=55666&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=55666&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=55666&r=dst IIS Stability: https://bugs.php.net/fix.php?id=55666&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=55666&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=55666&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=55666&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=55666&r=mysqlcfg