Bug #25098 show variables, show status

• Submitted: 15 Dec 2006 16:33
• Modified: 28 Feb 2007 18:14
• Reporter: Roberto Spadim (Basic Quality Contributor)
• Status: Closed
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: 5.1.15
• OS: Any (all)
• Assigned to: Valeriy Kravchuk
• CPU Architecture: Any
• Tags: show status, show variables

[15 Dec 2006 16:33] Roberto Spadim

Description:
Hello today i'm using show variables, show status
could i use something like
select variable,value from information_schema.global_variables
select variable,value from information_schema.session_variables

select variable,value from information_schema.global_status
select variable,value from information_schema.session_status

???
with this i can get queries per second with only one query

we don't need update delete truncate or anything else on this tables, update may be usefull we could use it instead 
SET GLOBAL VARIABLE='value'
UPDATE information_schema.global_variables set value='value' where variable='VARIABLE'

How to repeat:
feature request

[28 Feb 2007 18:14] Valeriy Kravchuk

Thank you for a reasonable feature request. It is already implemented (since 5.1.12). Please, read the manual:

http://dev.mysql.com/doc/refman/5.1/en/status-table.html
http://dev.mysql.com/doc/refman/5.1/en/variables-table.html