Oracle 5.0, Справочное руководство

Страница: 521 / 3232

Server System Variables
501
Variable Name
time_zone
Variable Scope Global, Session
Dynamic Variable Yes
Permitted Values
Type
string
The current time zone. This variable is used to initialize the time zone for each client that
connects. By default, the initial value of this is
'SYSTEM'
(which means, “use the value of
system_time_zone
[498] ”). The value can be specified explicitly at server startup with the
--
default-time-zone
[406] option. See Section 10.6, “MySQL Server Time Zone Support” .
•
timed_mutexes
[501]
Version Introduced 5.0.3
Command-Line Format
--timed_mutexes
Option-File Format
timed_mutexes
Option Sets Variable Yes,
timed_mutexes
[501]
Variable Name
timed_mutexes
Variable Scope Global
Dynamic Variable Yes
Permitted Values
Type
boolean
Default
OFF
This variable controls whether
InnoDB
mutexes are timed. If this variable is set to 0 or
OFF
(the
default), mutex timing is disabled. If the variable is set to 1 or
ON
, mutex timing is enabled. With
timing enabled, the
os_wait_times
value in the output from
SHOW ENGINE INNODB MUTEX
indicates the amount of time (in ms) spent in operating system waits. Otherwise, the value is 0. This
variable was added in MySQL 5.0.3.
•
timestamp = {timestamp_value | DEFAULT}
[501]
Set the time for this client. This is used to get the original timestamp if you use the binary log to
restore rows.
timestamp_value
should be a Unix epoch timestamp, not a MySQL timestamp.
SET timestamp
affects the value returned by
NOW()
[926] but not by
SYSDATE()
[928] . This
means that timestamp settings in the binary log have no effect on invocations of
SYSDATE()
[928] .
The server can be started with the
--sysdate-is-now
[423] option to cause
SYSDATE()
[928]
to be an alias for
NOW()
[926] , in which case
SET timestamp
affects both functions.
•
tmp_table_size
[501]
Command-Line Format
--tmp_table_size=#
Option-File Format
tmp_table_size
Option Sets Variable Yes,
tmp_table_size
[501]
Variable Name
tmp_table_size
Variable Scope Global, Session
Dynamic Variable Yes
Permitted Values
Type
numeric
Default
system dependent