note 37552 added to function.mysql-stat

and now, u call to mysql server <?php $Connect->Stats('ConnGet'); $Connect->Stats('ConnLst'); $Connect->Stats('ConnStat'); $Connect->Stats('ConnDBs'); ?> result is, ----------------------------------------------- Array ( [0] => mysql_server version: 4.0.16-Max [1] => mysql_protocol version: 10 [2] => mysql_host info: Localhost via UNIX socket [3] => mysql_client info: 3.23.58 ) Array ( [0] => 48 192.168.1.1:3685 supertool_pub Sleep 25 [1] => 86 supertools.com.br:1026 supertool_pub Sleep 2404 [2] => 87 192.168.1.1:3720 supertool_pub Sleep 2378 [3] => 162 localhost supertool_pub Processlist 0 ) Array ( [0] => Uptime: 143733 [1] => Threads: 4 [2] => Questions: 1528 [3] => Slow queries: 0 [4] => Opens: 216 [5] => Flush tables: 1 [6] => Open tables: 31 [7] => Queries per second avg: 0.011 ) ===================================== 031119 14:06:47 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 38 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 49, signal count 49 Mutex spin waits 138, rounds 2640, OS waits 6 RW-shared spins 86, OS waits 43; RW-excl spins 30, OS waits 0 ------------ TRANSACTIONS ------------ Trx id counter 0 3384 Purge done for trx's n:o < 0 3383 undo n:o < 0 0 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 9898, OS thread id 2801678 MySQL thread id 162, query id 1528 localhost supertool_pub SHOW INNODB STATUS ---TRANSACTION 0 0, not started, process no 9780, OS thread id 1556493 MySQL thread id 86, query id 938 supertools.com.br 192.168.1.2 root ---TRANSACTION 0 2721, not started, process no 9781, OS thread id 1572876 MySQL thread id 87, query id 939 192.168.1.1 root ---TRANSACTION 0 2729, not started, process no 1099, OS thread id 933899 MySQL thread id 48, query id 1526 192.168.1.1 root -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 40 OS file reads, 675 OS file writes, 524 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 199, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 257754 Log flushed up to 0 257754 Last checkpoint at 0 257754 0 pending log writes, 0 pending chkp writes 409 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 17490512; in additional pool allocated 910848 Buffer pool size 512 Free buffers 469 Database pages 42 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 19, created 23, written 373 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue Main thread process no. 992, id 114696, state: waiting for server activity Number of rows inserted 144, updated 203, deleted 13, read 1075 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ----------------------------------------------- ---- Manual Page -- http://www.php.net/manual/en/function.mysql-stat.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+37552 Delete -- http://master.php.net/manage/user-notes.php?action=delete+37552&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+37552&report=yes Search -- http://master.php.net/manage/user-notes.php