lp:~knielsen/mysqlatfacebook/mwl234
- Get this branch:
- bzr branch lp:~knielsen/mysqlatfacebook/mwl234
Branch merges
Branch information
Recent revisions
- 3630. By Kristian Nielsen
-
MWL#234: Implement protection against changing @@do_not_replicate in the middle of statement or transaction.
- 3628. By Mark Callaghan
-
Add log_query_
sample_ rate and log_error_ sample_ rate When log_query_
sample_ rate is > 0, then 1 / log_query_ sample_ rate of all queries
are written to the slow query log. When log_error_sample_ rate is > 0, then
1 / log_error_sample_ rate of all queries that raise an error are written to the
slow query log.These do not change behavior for the existing parameters that also determine
when a statement is logged.This also fixes the Errno value printed in the slow query log so that it is
usually correct. - 3627. By Mark Callaghan
-
Change the default for innodb_
ibuf_max_ pct_of_ buffer from 25% to 50% to
match existing behavior - 3625. By Mark Callaghan
-
Adds the Innodb my.cnf variable innodb_
sync_checkpoint _limit.
This is a percentage and is used to override the sync and async checkpoint
limits. This is ignored when set to 0. Those limits determine when dirty
pages are flushed to enforce fuzzy checkpoint constraints. Making this
greater than 80 might reduce the dirty page flush rate. Assume that max_size
is the sum of the transaction log file sizes, then the current code sets the
sync checkpoint limit to 0.9 * 0.9 * (15/16) of max_size (about 75% of it)
and the async limit to 0.9 * 0.9 * (7/8) of max size (about 70% of it).
When this is set to a non-zero value, then the sync limit is set to
(sync_checkpoint_limit/ 100) * 0.95 of max_size and the async limit is set to
(sync_checkpoint_limit/ 100) * 0.90 of max_size. The impact of this is that
you get the performance benefits of a larger transaction log file without
making it larger.
"
Below, "age" is Innodb_lsn_current - Innodb_lsn_oldest
Also adds SHOW STATUS counters:
Innodb_preflush_ async_limit - limit at which async page flushes are done for
fuzzy checkpoint
Innodb_preflush_ sync_limit - limit at which sync page flushes are done for
fuzzy checkpoint
Innodb_preflush_ async_margin - age minus preflush_ async_limit
Innodb_preflush_ sync_margin - age minus preflush_sync_limit
Innodb_checkpoint_ lsn - LSN of last checkpoint
Innodb_lsn_current - current LSN
Innodb_lsn_current_ minus_oldest - current LSN minus oldest LSN for which there
is a dirty page in the buffer pool
Innodb_lsn_current_ minus_last_ checkpoint
Innodb_lsn_oldest - min of the oldest modification LSN from all dirty pages
Innodb_purged_pages - number of pages processed by trx_purge
"
I ran sysbench for a read-write workload using 2 x 1900 transaction log files
and with innodb_sync_checkpoint _limit= 95, the page write rate was 80% of the rate with
the default settings. - 3624. By Mark Callaghan
-
Backport the fix for http://
bugs.mysql. com/bug. php?id= 59143. The fix is in the 5.1
mysql-server branch on launchpad and is obtained via "bzr log -r revno:3452.13.3 -p" - 3623. By Mark Callaghan
-
Add Records_
in_range_ calls column to IS.user_statistics
This column counts the number of calls to handler::records_ in_range per account
Branch metadata
- Branch format:
- Branch format 7
- Repository format:
- Bazaar repository format 2a (needs bzr 1.16 or later)