MySQL Manual
7 MySQL Table Types
- 7.6
BDBorBerkeleyDBTables- 7.6.1 Overview of
BDBTables - 7.6.2 Installing
BDB - 7.6.3
BDBstartup options - 7.6.4 Characteristics of
BDBtables: - 7.6.5 Things we need to fix for
BDBin the near future: - 7.6.6 Operating systems supported by
BDB - 7.6.7 Restrictions on
BDBTables - 7.6.8 Errors That May Occur When Using
BDBTables
- 7.6.1 Overview of
7.6.5 Things we need to fix for BDB in the near future:
-
It's very slow to open many
BDBtables at the same time. If you are going to useBDBtables, you should not have a very big table cache (like >256) and you should use--no-auto-rehashwith themysqlclient. We plan to partly fix this in 4.0. -
SHOW TABLE STATUSdoesn't yet provide that much information forBDBtables. - Optimise performance.
- Change to not use page locks at all when we are scanning tables.
