|
Server : Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/1.0.0-fips mod_auth_passthrough/2.1 mod_bwlimited/1.4 System : Linux server.jackjohnson.com 2.6.32-279.5.2.el6.x86_64 #1 SMP Fri Aug 24 01:07:11 UTC 2012 x86_64 User : jackjohn ( 502) PHP Version : 5.3.17 Disable Function : NONE Directory : /usr/share/mysql-test/t/ |
Upload File : |
--source include/have_innodb.inc --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings SET @userstat_running_old= @@userstat_running; SET GLOBAL userstat_running=ON; CREATE TABLE t1 ( id int(10), PRIMARY KEY (id)) ENGINE=InnoDB; INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10); SELECT COUNT(*) FROM t1; SELECT ROWS_READ FROM information_schema.table_statistics WHERE TABLE_NAME='t1'; SELECT ROWS_READ FROM information_schema.index_statistics WHERE TABLE_NAME='t1'; SET GLOBAL userstat_running= @userstat_running_old; DROP TABLE t1;