diff options
| author | Michael Widenius <monty@mysql.com> | 2010-07-19 21:08:06 +0300 |
|---|---|---|
| committer | Michael Widenius <monty@mysql.com> | 2010-07-19 21:08:06 +0300 |
| commit | ad18f1d6a2b7f4f0358f3b372529dcc19f9e90b3 (patch) | |
| tree | 6e2ec2191aef1e788be37a6a3940dbd519b809a9 /mysql-test/r/status_user.result | |
| parent | 4f564a5443c6a907449bc4d2c3e7f6f89dbf4485 (diff) | |
| download | mariadb-git-ad18f1d6a2b7f4f0358f3b372529dcc19f9e90b3.tar.gz | |
Changed usage statistics to use 64 bit ints instead of 32 for all relevant variables.
Fixes LP#583314 user_statistics - INT overflow
mysql-test/r/status_user.result:
Update test results
sql/sql_show.cc:
Changed usage statistics to use 64 bit ints instead of 32 for all relevant variables.
Diffstat (limited to 'mysql-test/r/status_user.result')
| -rw-r--r-- | mysql-test/r/status_user.result | 88 |
1 files changed, 44 insertions, 44 deletions
diff --git a/mysql-test/r/status_user.result b/mysql-test/r/status_user.result index a39f0819c58..636eeabfffc 100644 --- a/mysql-test/r/status_user.result +++ b/mysql-test/r/status_user.result @@ -3,66 +3,66 @@ select variable_value from information_schema.global_status where variable_name= show columns from information_schema.client_statistics; Field Type Null Key Default Extra CLIENT varchar(64) NO -TOTAL_CONNECTIONS int(21) NO 0 -CONCURRENT_CONNECTIONS int(21) NO 0 -CONNECTED_TIME int(21) NO 0 +TOTAL_CONNECTIONS bigint(21) NO 0 +CONCURRENT_CONNECTIONS bigint(21) NO 0 +CONNECTED_TIME bigint(21) NO 0 BUSY_TIME double NO 0 CPU_TIME double NO 0 -BYTES_RECEIVED int(21) NO 0 -BYTES_SENT int(21) NO 0 -BINLOG_BYTES_WRITTEN int(21) NO 0 -ROWS_READ int(21) NO 0 -ROWS_SENT int(21) NO 0 -ROWS_DELETED int(21) NO 0 -ROWS_INSERTED int(21) NO 0 -ROWS_UPDATED int(21) NO 0 -SELECT_COMMANDS int(21) NO 0 -UPDATE_COMMANDS int(21) NO 0 -OTHER_COMMANDS int(21) NO 0 -COMMIT_TRANSACTIONS int(21) NO 0 -ROLLBACK_TRANSACTIONS int(21) NO 0 -DENIED_CONNECTIONS int(21) NO 0 -LOST_CONNECTIONS int(21) NO 0 -ACCESS_DENIED int(21) NO 0 -EMPTY_QUERIES int(21) NO 0 +BYTES_RECEIVED bigint(21) NO 0 +BYTES_SENT bigint(21) NO 0 +BINLOG_BYTES_WRITTEN bigint(21) NO 0 +ROWS_READ bigint(21) NO 0 +ROWS_SENT bigint(21) NO 0 +ROWS_DELETED bigint(21) NO 0 +ROWS_INSERTED bigint(21) NO 0 +ROWS_UPDATED bigint(21) NO 0 +SELECT_COMMANDS bigint(21) NO 0 +UPDATE_COMMANDS bigint(21) NO 0 +OTHER_COMMANDS bigint(21) NO 0 +COMMIT_TRANSACTIONS bigint(21) NO 0 +ROLLBACK_TRANSACTIONS bigint(21) NO 0 +DENIED_CONNECTIONS bigint(21) NO 0 +LOST_CONNECTIONS bigint(21) NO 0 +ACCESS_DENIED bigint(21) NO 0 +EMPTY_QUERIES bigint(21) NO 0 show columns from information_schema.user_statistics; Field Type Null Key Default Extra USER varchar(48) NO -TOTAL_CONNECTIONS int(21) NO 0 -CONCURRENT_CONNECTIONS int(21) NO 0 -CONNECTED_TIME int(21) NO 0 +TOTAL_CONNECTIONS int(11) NO 0 +CONCURRENT_CONNECTIONS int(11) NO 0 +CONNECTED_TIME int(11) NO 0 BUSY_TIME double NO 0 CPU_TIME double NO 0 -BYTES_RECEIVED int(21) NO 0 -BYTES_SENT int(21) NO 0 -BINLOG_BYTES_WRITTEN int(21) NO 0 -ROWS_READ int(21) NO 0 -ROWS_SENT int(21) NO 0 -ROWS_DELETED int(21) NO 0 -ROWS_INSERTED int(21) NO 0 -ROWS_UPDATED int(21) NO 0 -SELECT_COMMANDS int(21) NO 0 -UPDATE_COMMANDS int(21) NO 0 -OTHER_COMMANDS int(21) NO 0 -COMMIT_TRANSACTIONS int(21) NO 0 -ROLLBACK_TRANSACTIONS int(21) NO 0 -DENIED_CONNECTIONS int(21) NO 0 -LOST_CONNECTIONS int(21) NO 0 -ACCESS_DENIED int(21) NO 0 -EMPTY_QUERIES int(21) NO 0 +BYTES_RECEIVED bigint(21) NO 0 +BYTES_SENT bigint(21) NO 0 +BINLOG_BYTES_WRITTEN bigint(21) NO 0 +ROWS_READ bigint(21) NO 0 +ROWS_SENT bigint(21) NO 0 +ROWS_DELETED bigint(21) NO 0 +ROWS_INSERTED bigint(21) NO 0 +ROWS_UPDATED bigint(21) NO 0 +SELECT_COMMANDS bigint(21) NO 0 +UPDATE_COMMANDS bigint(21) NO 0 +OTHER_COMMANDS bigint(21) NO 0 +COMMIT_TRANSACTIONS bigint(21) NO 0 +ROLLBACK_TRANSACTIONS bigint(21) NO 0 +DENIED_CONNECTIONS bigint(21) NO 0 +LOST_CONNECTIONS bigint(21) NO 0 +ACCESS_DENIED bigint(21) NO 0 +EMPTY_QUERIES bigint(21) NO 0 show columns from information_schema.index_statistics; Field Type Null Key Default Extra TABLE_SCHEMA varchar(192) NO TABLE_NAME varchar(192) NO INDEX_NAME varchar(192) NO -ROWS_READ int(21) NO 0 +ROWS_READ bigint(21) NO 0 show columns from information_schema.table_statistics; Field Type Null Key Default Extra TABLE_SCHEMA varchar(192) NO TABLE_NAME varchar(192) NO -ROWS_READ int(21) NO 0 -ROWS_CHANGED int(21) NO 0 -ROWS_CHANGED_X_INDEXES int(21) NO 0 +ROWS_READ bigint(21) NO 0 +ROWS_CHANGED bigint(21) NO 0 +ROWS_CHANGED_X_INDEXES bigint(21) NO 0 set @save_general_log=@@global.general_log; set @@global.general_log=0; set @@global.userstat=1; |