- 08 Jul, 2009 2 commits
-
-
calvin authored
The original PAUSE instruction patch (r5470) does not compile on Windows. Also, there is an elegant way of doing it on Windows - YieldProcessor(). Approved by: Heikki (on IM)
-
rb://133inaam authored
This patch introduces heuristics based flushing rate of dirty pages to avoid IO bursts at checkpoint. 1) log_capacity / log_generated per second gives us number of seconds in which ALL dirty pages need to be flushed. Based on this rough assumption we can say that n_dirty_pages / (log_capacity / log_generation_rate) = desired_flush_rate 2) We use weighted averages (hard coded to 20 seconds) of log_generation_rate to avoid resonance. 3) From the desired_flush_rate we subtract the number of pages that have been flushed due to LRU flushing. That gives us pages that we should flush as part of flush_list cleanup. And that is the number (capped by maximum io_capacity) that we try to flush from the master thread. Knobs: ====== innodb_adaptive_flushing: boolean, global, dynamic, default TRUE. Since this heuristic is very experimental and has the potential to dramatically change the IO pattern I think it is a good idea to leave a knob to turn it off. Approved by: Heikki
-
- 07 Jul, 2009 3 commits
-
-
rb://138inaam authored
The current implementation is to try to flush the neighbors of every page that we flush. This patch makes the following distinction: 1) If the flush is from flush_list AND 2) If the flush is intended to move the oldest_modification LSN ahead (this happens when a user thread sees little space in the log file and attempts to flush pages from the buffer pool so that a checkpoint can be made) THEN Do not try to flush the neighbors. Just focus on flushing dirty pages at the end of flush_list Approved by: Heikki
-
rb://126inaam authored
Based on contribution from Google Inc. This patch introduces a new parameter innodb_io_capacity to control the rate at which master threads performs various tasks. The default value is 200 and higher values imply more aggressive flushing and ibuf merges from within the master thread. This patch also changes the ibuf merge from synchronous to asynchronous. Another minor change is not to force the master thread to wait for a log flush to complete every second. Approved by: Heikki
-
calvin authored
Windows will support PAUSE instruction by default.
-
- 06 Jul, 2009 2 commits
- 02 Jul, 2009 1 commit
-
-
vasil authored
Use PAUSE instruction inside spinloop if it is available. The patch was originally developed by Mikael Ronstrom <mikael@mysql.com> and can be found here: http://bazaar.launchpad.net/%7Emysql/mysql-server/mysql-5.4/revision/2768 http://bazaar.launchpad.net/%7Emysql/mysql-server/mysql-5.4/revision/2771 http://bazaar.launchpad.net/%7Emysql/mysql-server/mysql-5.4/revision/2772 http://bazaar.launchpad.net/%7Emysql/mysql-server/mysql-5.4/revision/2774 http://bazaar.launchpad.net/%7Emysql/mysql-server/mysql-5.4/revision/2777 http://bazaar.launchpad.net/%7Emysql/mysql-server/mysql-5.4/revision/2799 http://bazaar.launchpad.net/%7Emysql/mysql-server/mysql-5.4/revision/2800 Approved by: Heikki (rb://137)
-
- 30 Jun, 2009 18 commits
-
-
inaam authored
Non functional change. s/Percona/Percona Inc./
-
marko authored
(ISO 8859-1 encoded U+00AD SOFT HYPHEN) with a cheap ASCII substitute.
-
marko authored
-
marko authored
as this function is used within InnoDB Hot Backup.
-
marko authored
with UNIV_HOTBACKUP.
-
marko authored
-
marko authored
Invoke os_get_os_version() at most once.
-
marko authored
-
marko authored
-
marko authored
-
marko authored
-
marko authored
-
marko authored
-
marko authored
-
marko authored
very similar to ha_search_and_delete_if_found().
-
marko authored
This function is unused, but it could turn out to be a useful debugging aid.
-
marko authored
-
marko authored
-
- 29 Jun, 2009 7 commits
-
-
marko authored
-
marko authored
to track down Issue #289.
-
marko authored
or SET GLOBAL innodb_file_format_check=DEFAULT. innodb_file_format.test: New test for innodb_file_format and innodb_file_format_check. innodb_file_format_name_validate(): Store the string in *save. innodb_file_format_name_update(): Check the string again. innodb_file_format_check_validate(): Store the string in *save. innodb_file_format_check_update(): Check the string again. Issue #282, rb://140 approved by Heikki Tuuri
-
marko authored
Do not do arithmetics on void pointers.
-
marko authored
buf_fix_count. This could explain Issue #156. Tested by Michael.
-
marko authored
Start prebuilt->trx before locking the table. This should fix Issue #293 and could fix Issue #229. Approved by Sunny (over IM).
-
- 26 Jun, 2009 1 commit
-
-
calvin authored
-
- 25 Jun, 2009 4 commits
- 24 Jun, 2009 1 commit
-
-
calvin authored
Suggested by Marko.
-
- 23 Jun, 2009 1 commit
-
-
calvin authored
Change the header file path from ../storage/innobase/include/ to ../include/. In the planned 5.1 + plugin release, the source directory of the plugin will not be in storage/innobase. Approved by: Heikki (IM)
-