MySQL High Availability: Tools for Building Robust Data Centers by Charles Bell; Mats Kindahl; Lars Thalmann

Author:Charles Bell; Mats Kindahl; Lars Thalmann
Language: eng
Format: mobi
Tags: Database Management, Programming Languages, Reference:Computers, Computers, General, Desktop Applications, Client, Databases, SQL, Relational databases, MySQL (Electronic resource), server computing
ISBN: 9780596807306
Publisher: O'Reilly Media
Published: 2010-07-16T21:29:18.744000+00:00

The replace operation is not allowed.

Indexes are less efficient than for a single table.

The Merge storage engine is best suited for very large database (VLDB) applications, like data warehousing, where data resides in more than one table in one or more databases. You can also use it to help solve partitioning problems where you want to partition horizontally but do not want to add the complexity of the partition table options.

Clearly, with so many choices of storage engines, it is possible to choose engines that can hamper performance or, in some cases, prohibit certain solutions. For example, if you never specify a storage engine when the table is created, MySQL uses the default storage engine. If not set manually, the default storage engine reverts to the platform-specific default, which may be MyISAM on some platforms. This may mean you are missing out on optimizing lookup tables or limiting features of your application by not having transactional support. It is well worth the extra time to include an analysis of storage engine choices when designing or tuning your databases.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.