MySQL Forums
Forum List  »  InnoDB

Re: SHOW VARIABLES: which table holds my.cnf startup varibles?
Posted by: Rick James
Date: March 10, 2009 08:00PM

If you are accessing them from Perl/PHP/etc, SHOW VARIABLES feels like a table with 2 columns and a couple hundred rows.

If you are trying to copy them into a table, consider:
SELECT * FROM information_schema.GLOBAL_VARIABLES;

There is also SESSION_VARIABLES.

At the moment I see 5 differences on my server. 4 came from doing SET NAMES utf8; the other is PSEUDO_THREAD_ID (re: PROCESSLIST).

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: SHOW VARIABLES: which table holds my.cnf startup varibles?
3220
March 10, 2009 08:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.