Document known issues with compressed InnoDB tables
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Medium
|
Hrvoje Matijakovic | ||
2.1 |
Fix Released
|
Medium
|
Hrvoje Matijakovic | ||
2.2 |
Fix Released
|
Medium
|
Hrvoje Matijakovic |
Bug Description
There is a number of XtraBackup-related issues with compressed InnoDB tables. Those issues result from either server-side bugs, or OS configuration and thus, cannot be fixed on the XtraBackup side. However, we want to document them to at least make users aware of possible issues and workarounds. I'm not sure what part of the PXB manual this belongs, how about a new "Known issues and limitations" section?
Issues:
- For MySQL or Percona Server versions 5.1 and 5.5 there are known and unfixed bugs with redo-logging of updates to compressed InnoDB tables. For example, internal Oracle bug #16267120 has been fixed only in MySQL 5.6.12, but not in 5.1 or 5.5. The bug is about compressed page images not being logged on page reorganization and thus, creating a possibility for recovery process to fail in case a different zlib version is being used when replaying a MLOG_ZIP_
- For MySQL or Percona Server version 5.6 it is NOT recommended to set innodb_
Related branches
- Alexey Kopytov (community): Approve
-
Diff: 225 lines (+42/-38)13 files modifieddoc/source/conf.py (+2/-0)
doc/source/faq.rst (+1/-1)
doc/source/glossary.rst (+3/-0)
doc/source/howtos/setting_up_replication.rst (+1/-1)
doc/source/index.rst (+1/-0)
doc/source/innobackupex/creating_a_backup_ibk.rst (+1/-1)
doc/source/innobackupex/how_innobackupex_works.rst (+1/-1)
doc/source/innobackupex/innobackupex_option_reference.rst (+1/-1)
doc/source/innobackupex/innobackupex_script.rst (+0/-2)
doc/source/innobackupex/throttling_ibk.rst (+4/-0)
doc/source/installation/apt_repo.rst (+7/-7)
doc/source/installation/yum_repo.rst (+7/-24)
doc/source/known_issues.rst (+13/-0)
- Alexey Kopytov (community): Approve
-
Diff: 240 lines (+42/-47)13 files modifiedstorage/innobase/xtrabackup/doc/source/conf.py (+2/-0)
storage/innobase/xtrabackup/doc/source/faq.rst (+1/-1)
storage/innobase/xtrabackup/doc/source/glossary.rst (+3/-0)
storage/innobase/xtrabackup/doc/source/howtos/setting_up_replication.rst (+1/-1)
storage/innobase/xtrabackup/doc/source/index.rst (+1/-0)
storage/innobase/xtrabackup/doc/source/innobackupex/creating_a_backup_ibk.rst (+1/-1)
storage/innobase/xtrabackup/doc/source/innobackupex/how_innobackupex_works.rst (+1/-1)
storage/innobase/xtrabackup/doc/source/innobackupex/innobackupex_option_reference.rst (+1/-1)
storage/innobase/xtrabackup/doc/source/innobackupex/innobackupex_script.rst (+0/-2)
storage/innobase/xtrabackup/doc/source/innobackupex/throttling_ibk.rst (+4/-0)
storage/innobase/xtrabackup/doc/source/installation/apt_repo.rst (+7/-7)
storage/innobase/xtrabackup/doc/source/installation/yum_repo.rst (+7/-33)
storage/innobase/xtrabackup/doc/source/known_issues.rst (+13/-0)
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PXB-692