Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 16 6 Older Entries

Displaying posts with tag: Day Out (reset)

Variable's Day Out #16: innodb_log_file_size
+0 Vote Up -0Vote Down

Properties: 


Applicable To InnoDB
Server Startup Option --innodb_log_file_size=<value>
Scope Global
Dynamic Yes
Possible Values Integer: Range: 1M - 4G
<1M will be adjusted to 1M
Default Value 5M

  [Read more...]
Variable's Day Out #15: bulk_insert_buffer_size
+0 Vote Up -0Vote Down

Properties:

Applicable To MyISAM
Server Startup Option --bulk_insert_buffer_size=<value>
Scope Both
Dynamic Yes
Possible Values Integer:

Range: 0 - 4294967295 (4G)

Default Value 8388608 (8M)
  [Read more...]
Variable's Day Out #14: log_queries_not_using_indexes
+0 Vote Up -0Vote Down

Properties:

Applicable To MySQL Server
Server Startup Option --log-queries-not-using-indexes
Scope Global
Dynamic Yes
Possible Values Boolean
Default False
Category Performance, Monitoring, Best …
  [Read more...]
Variable's Day Out #13: binlog_format
+0 Vote Up -0Vote Down

Properties:

Applicable To MySQL Server
Introduced In 5.1.5
Server Startup Option --binlog-format=<value>
Scope Both
Dynamic Yes
Possible Values enum(ROW, STATEMENT, MIXED)
Default < 5.1.12: …
  [Read more...]
Variable's Day Out #12: innodb_flush_method
+0 Vote Up -0Vote Down

Properties:

Applicable To InnoDB on Unix like OS
Server Startup Option --innodb_flush_method=<value>
Scope Global
Dynamic No
Possible Values enum(O_DSYNC, O_DIRECT, <<none>> )
Default Value <<none>>
  [Read more...]
Variable's Day Out #11: large_pages
+0 Vote Up -0Vote Down

Properties:

Applicable To MySQL/Linux
Server Startup Option --large-pages
Scope Global
Dynamic No way
Possible Values True|False flag
Default Value False
Category Performance, Administration
  [Read more...]
Last 10 Variable Day Outs
+0 Vote Up -0Vote Down

Well, the first summary of last 10 variable day outs.

Day Outs:

  [Read more...]
Variable's Day Out #10: innodb_file_per_table
+0 Vote Up -0Vote Down

Properties:


Applicable To InnoDB
Server Startup Option --innodb-file-per-table
Scope Global
Dynamic General InnoDB Engine: No
InnoDB plug-in: Yes
Possible Values Enable|Disable Flag
Default Value Disabled
Category …
  [Read more...]
Variable's Day Out #9: long_query_time
+0 Vote Up -0Vote Down

Properties:



Applicable To MySQL Server
Server Startup Option --long-query-time=<value>
Scope Both
Dynamic Yes
Possible Values (< 5.1.21): Integer
(>=5.1.21): Numeric
Minimum Value (< 5.1.21): 1
(>=5.1.21): 0
  [Read more...]
Variable's Day Out #8: innodb_additional_mem_pool_size
+0 Vote Up -0Vote Down

Properties:

Applicable To InnoDB
Server Startup Option --innodb-additional-mem-pool-size=<value>
Scope Global
Dynamic No
Possible Values Integer: Range: 524288 (512K) - 4294967295 (4G)
Default Value 1048576 (1M)
  [Read more...]
Showing entries 1 to 10 of 16 6 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

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.