~percona-dev/percona-server/fb_changes_auto_lru_dump

  • Committer: Alexey Kopytov
  • Date: 2011-01-12 17:45:39 UTC
  • Revision ID: akopytov@gmail.com-20110112174539-oc5jqjet4yml6f71
Merged Facebook's changes to innodb_lru_dump_restore.patch:

LRU is dumped to a temporary file first to avoid partially written files
in backups or in case of a crash.

Release the LRU mutex while doing memset and file IO.  Should mimimize
the impact on the host during scheduled LRU dump.  Basic detection of
LRU cycling should the next page to dump be put back at the head of the
LRU during the unlocked window.

Added option innodb_lru_dump_old_pages to control whether old pages are
included in the LRU dump. The default is to only dump young pages.

Added option innodb_lru_load_max_entries specifying the maximum number
of LRU entries to restore.  The default is 512k entries (8GB).
Consecutive pages are merged and only count as one, so you will probably
load more pages than this number of LRU entries.

Switched to writing out LRU in priority order.

Load in LRU priority order, but always merge consecutive pages.

Add status vars for LRU restore progress: lru_restore_total_pages and
lru_restore_loaded_pages.

Added restore rate limiting (restore no more than innodb_io_capacity
pages per second).  In my testing, a value of 5000 is fine for a
pre-up-ip warmup, but this should be reduced to 500 before serving
traffic to ensure adequate IO capacity is available for foreground
threads.
Filename Latest Rev Last Changed Committer Comment Size
..
build 7.5.2 13 years ago Aleksandr Kuzminsky 1. Set Percona Server version 11.0; 2. Added .spec Diff
HandlerSocket-Plugin-for-MySQL 146.2.3 13 years ago Aleksandr Kuzminsky Added HandlerSocket-Plugin-for-MySQL sources Diff
mysql-test 6.1.2 13 years ago kinoyasu reorder and adjust mysql-test acript and add simpl Diff
UDF 174.1.1 13 years ago Aleksandr Kuzminsky added UDF functions from maatkit Diff
bug580324.patch 149.1.1 13 years ago Oleg Tsarev port Oleg's patches to 5.1.53 3.6 KB Diff Download File
bug677407.patch 176 13 years ago Oleg Tsarev port Oleg's and Alexey's patches to 5.1.54 4.9 KB Diff Download File
bugfix48929.patch 176 13 years ago Oleg Tsarev port Oleg's and Alexey's patches to 5.1.54 4.5 KB Diff Download File
control_online_alter_index.patch 177.4.1 13 years ago Oleg Tsarev fix bug #688643 Command-line option process separ 4.2 KB Diff Download File
COPYING.innodb-deadlock-count-patch 7.3.1 13 years ago Oleg Tsarev fix bug 569288 1.6 KB Diff Download File
COPYING.show_temp_51 2 13 years ago kinoyasu merge 5.1.45 rev 36: but I cannot accept show_temp 1.6 KB Diff Download File
error_pad.patch 129.1.1 13 years ago Oleg Tsarev fix diff -Nur syntax to diff -ruN 8 KB Diff Download File
fix-bug671764.patch 177.4.1 13 years ago Oleg Tsarev fix bug #688643 Command-line option process separ 1 KB Diff Download File
File handlersocket.patch 174.1.4 13 years ago Aleksandr Kuzminsky fixed handlersocket build bug 893 bytes Diff Download File
i_s_innodb_buffer_pool_pages.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 25.3 KB Diff Download File
innodb_adjust_defaults.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 2 KB Diff Download File
innodb_admin_command_base.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 5.4 KB Diff Download File
innodb_buffer_pool_shm.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 35.9 KB Diff Download File
innodb_deadlock_count.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 3.4 KB Diff Download File
innodb_dict_size_limit.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 15.8 KB Diff Download File
innodb_expand_import.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 19 KB Diff Download File
innodb_expand_undo_slots.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 6.9 KB Diff Download File
innodb_extend_slow.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 29.1 KB Diff Download File
innodb_extra_rseg.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 13.6 KB Diff Download File
innodb_fast_checksum.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 12 KB Diff Download File
innodb_fast_shutdown.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 8.4 KB Diff Download File
innodb_files_extend.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 20.9 KB Diff Download File
innodb_fix_misc.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 5.2 KB Diff Download File
innodb_io_patches.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 47.7 KB Diff Download File
innodb_lru_dump_restore.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 32.5 KB Diff Download File
innodb_opt_lru_count.patch 149 13 years ago kinoyasu ported Yasufumi patches for 5.1.53 9.8 KB Diff Download File
innodb_overwrite_relay_log_info.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 16.8 KB Diff Download File
innodb_pass_corrupt_table.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 38.8 KB Diff Download File
innodb_purge_thread.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 15.4 KB Diff Download File
innodb_recovery_patches.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 16.8 KB Diff Download File
innodb_separate_doublewrite.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 35.3 KB Diff Download File
innodb_show_enhancements.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 8.5 KB Diff Download File
innodb_show_lock_name.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 12.1 KB Diff Download File
innodb_show_status.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 14.4 KB Diff Download File
innodb_show_sys_tables.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 19.2 KB Diff Download File
innodb_split_buf_pool_mutex.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 112 KB Diff Download File
innodb_stats.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 61.6 KB Diff Download File
innodb_swap_builtin_plugin.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 8.7 KB Diff Download File
innodb_thread_concurrency_timer_based.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 6.7 KB Diff Download File
File install_tests.sh 166.2.1 13 years ago Oleg Tsarev add --without-response_time_distribution 795 bytes Diff Download File
log_connection_error.patch 176 13 years ago Oleg Tsarev port Oleg's and Alexey's patches to 5.1.54 2.8 KB Diff Download File
lrusort.py 1 14 years ago kinoyasu merge, reorder and port patches based on mysql 5.1 696 bytes Diff Download File
Makefile 176.1.1 13 years ago Aleksandr Kuzminsky Maatkit UDF functions are added to a distribution 1.6 KB Diff Download File
microsec_process.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 1.7 KB Diff Download File
mysql-syslog.patch 166.2.1 13 years ago Oleg Tsarev add --without-response_time_distribution 3.9 KB Diff Download File
mysql-test.diff 183.1.1 13 years ago Aleksandr Kuzminsky ported mysql-tests from 5.1.53 251 KB Diff Download File
mysql_dump_ignore_ct.patch 102.1.1 13 years ago kinoyasu add header and rule, as the first step of the reor 2.5 KB Diff Download File
mysql_remove_eol_carret.patch 166.2.1 13 years ago Oleg Tsarev add --without-response_time_distribution 2.9 KB Diff Download File
File normalize_patches.sh 176 13 years ago Oleg Tsarev port Oleg's and Alexey's patches to 5.1.54 1.5 KB Diff Download File
optimizer_fix.patch 177.4.1 13 years ago Oleg Tsarev fix bug #688643 Command-line option process separ 6.8 KB Diff Download File
percona-support.patch 174.1.10 13 years ago Aleksandr Kuzminsky Added UDF installation instructions, some other mi 1 KB Diff Download File
profiling_slow.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 12.6 KB Diff Download File
query_cache_enhance.patch 177.4.1 13 years ago Oleg Tsarev fix bug #688643 Command-line option process separ 28.6 KB Diff Download File
README.txt 1 14 years ago kinoyasu merge, reorder and port patches based on mysql 5.1 481 bytes Diff Download File
File regenerate_patch.sh 138.1.1 13 years ago Oleg Tsarev fix bug 673426 1.6 KB Diff Download File
remove_fcntl_excessive_calls.patch 133.1.1 13 years ago Oleg Tsarev port patches to 5.1.52 2.9 KB Diff Download File
response-time-distribution.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 31 KB Diff Download File
series 187.1.1 13 years ago Oleg Tsarev remove wrong patch 1.4 KB Diff Download File
show_patches.patch 175 13 years ago kinoyasu Yasufumi patches are ported to 5.1.54 10.2 KB Diff Download File
show_slave_status_nolock.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 4.8 KB Diff Download File
show_temp_51.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 14.3 KB Diff Download File
slow_extended.patch 181.1.1 13 years ago Alexey Kopytov Bug #693818: funcs_1.storedproc fails on 12.4 The 55.5 KB Diff Download File
sql_no_fcache.patch 176 13 years ago Oleg Tsarev port Oleg's and Alexey's patches to 5.1.54 13.6 KB Diff Download File
suppress_log_warning_1592.patch 177.4.1 13 years ago Oleg Tsarev fix bug #688643 Command-line option process separ 3.2 KB Diff Download File
userstat.patch 190 13 years ago Alexey Kopytov Merged Facebook's changes to innodb_lru_dump_resto 124 KB Diff Download File