79458

Compression and the InnoDB Redo Log Files

Before a compressed page is written to a data file, MySQL writes a copy of the page to the redo

log (if it has been recompressed sińce the last time it was written to the database). This is done to

ensure that redo logs are usable for crash recovery, even in the unlikely case that the zlib library is

upgraded and that change introduces a compatibility problem with the compressed data. Therefore,

some increase in the size of log files, or a need for morę frequent checkpoints, can be expected when

using compression. The amount of increase in the log file size or checkpoint frequency depends

on the number of times compressed pages are modified in a way that

requires reorganization and

recompression.

Notę that compressed tables use a different file format for the redo log and the per-table tablespaces

than in MySQL 5.1 and earlier. The MySQL Enterprise Backup product supportsthis latest Barracuda

file format for compressed InnoDB tables. The older InnoDB Hot Backup product can only back up

tables using the file format Antelope, and thus does not support compressed InnoDB tables.

Wyszukiwarka

Podobne podstrony:
Managing the Online Redo Log The online redo log files arc a critical component in database rccovcry
Redo log over-commit handling. It is possible to control a data node’s handling of operations when t
About Online Redo Log Files Every Oracle database has a set of two or morę online redo log files. Th
Media Recovery If you rcstorc thc archi vcd redo log files and data filcs, then you must perform med
Enabling Archiving of Redo Log Files To back up thc databasc whilc it is open, or to be ablc to perf
PDF INFO & TEST FILEHOW TO USE PDF FILES ON THE INTERNETYiewing PDF Files On-Line It is possible
Filesort Probes The filesort probes are triggered whenever a filesort operation is applied to a tabl
REIDER PART 2
23 ChaPTi-r 7_Lower Leg, Foot, and Ankle 283 tear. In severe injuries, thc examiner is
P5140029 ScApulohumml DWunction wm oi Ihr * m Mattornhip to the humcrws during novm.il r»ngt* ot mot
eDonkey Detection Synopsis There is a peer-to-peer file sharing application listening on the remote
177STRUTS Investigation of the compressive strength of spruce struts of rectungul&r cross sectio
Viewing Online Redo Log File Information You can usc EM Express to view status and multiplexing info
Enable InnoDB Memcached Binary Log with innodb_api_enable_binlog: •To use the InnoDB memcached plugi
The Slave Relay Log The relay log, like the binary log, consists of a set of numbered files containi
Comprehensive study of building energy renovation activities and the uptake of nearly

więcej podobnych podstron