Comments on: More on variables ambiguities https://shlomi-noach.github.io/blog/mysql/more-on-variables-ambiguities Blog by Shlomi Noach Wed, 14 Oct 2009 19:49:41 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: INFORMATION_SCHEMA.GLOBAL_STATUS: watch out | code.openark.org https://shlomi-noach.github.io/blog/mysql/more-on-variables-ambiguities/comment-page-1#comment-4881 Wed, 14 Oct 2009 19:49:41 +0000 https://shlomi-noach.github.io/blog/?p=799#comment-4881 […] There are a few ON/OFF values (I’ve expressed my opinion and concerns on these here and here; why not just use 0/1?). SSL_CIPHER seems like the only variable which can get long enough to […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/more-on-variables-ambiguities/comment-page-1#comment-1751 Thu, 30 Apr 2009 17:29:36 +0000 https://shlomi-noach.github.io/blog/?p=799#comment-1751 @Giuseppe:

I don’t mind that much that some variables can have options like “OFF/ON/DISABLED”
I would just expect it to be consistent for that particular variable throughout parameters, variables, SHOW and mysqld.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/more-on-variables-ambiguities/comment-page-1#comment-1750 Thu, 30 Apr 2009 17:27:18 +0000 https://shlomi-noach.github.io/blog/?p=799#comment-1750 @Sergei,

A YES variable (I never mentioned a NO):

mysql> show global variables like ‘updat%’;
+—————————-+——-+
| Variable_name | Value |
+—————————-+——-+
| updatable_views_with_limit | YES |
+—————————-+——-+
1 row in set (0.01 sec)

I didn’t know about the –enable, –disable: very interesting!
The –skip is familiar from mysqldump.

]]> By: Sergei Golubchik https://shlomi-noach.github.io/blog/mysql/more-on-variables-ambiguities/comment-page-1#comment-1749 Thu, 30 Apr 2009 16:43:20 +0000 https://shlomi-noach.github.io/blog/?p=799#comment-1749 –skip –enable –disable can be used with any boolean option.
For example as –enable-innodb-file-per-table

Also, boolean options accept TRUE/FALSE.

What option accepts YES/NO ? I couldn’t find any.

ON/OFF (and DISABLED), as far as I could see, is only accepted by event-scheduler, I’m fixing that.

]]> By: Giuseppe Maxia https://shlomi-noach.github.io/blog/mysql/more-on-variables-ambiguities/comment-page-1#comment-1742 Thu, 30 Apr 2009 05:23:39 +0000 https://shlomi-noach.github.io/blog/?p=799#comment-1742 Just to make your life more difficult, some variables can also accept “disabled”
http://dev.mysql.com/doc/refman/5.1/en/events-configuration.html#events-event-scheduler-option
and some options are disabled by “–skip-option-name” instead.
Yes. We need more consistency.

]]>