Enabling Real-Time MySQL to HDFS Integration Big Data is transforming the way organizations harness new insights from their business, and Apache Hadoop is at the center of that transformation. Batch processing delivered by Map/Reduce remains central to Hado...
It was not possible to upgrade a community RPM to a commercial RPM using rpm -uvh or yum localupdate. To deal with this, the RPM spec file has been updated in MySQL 5.6.11, which has the following consequences: For a non-upgrade installation (no existing My...
Historically, many DDL operations on InnoDB tables were expensive. Many ALTER TABLE operations worked by creating a new, empty table defined with the requested table options and indexes, then copying the existing rows to the new table one-by-one, updating t...
Section Navigation [Toggle] 4.6 MySQL Administrative and Utility Programs4.6.1 innochecksum — Offline InnoDB File Checksum Utility 4.6.2 myisam_ftdump — Display Full-Text Index information 4.6.3 myisamchk — MyISAM Table-Maintenance Utility 4.6.4 myi...
Before you set up the plugin itself and the internal tables is uses, verify that your server has the required prerequisite software. Platform Support Currently, the memcached Daemon Plugin is only supported on Linux, Solaris, and OS X platforms. Software Pr...
Section Navigation [Toggle] Preface and Legal Notices Changes in MySQL 5.6.11 (Not yet released) Changes in MySQL 5.6.10 (2013-02-05) Changes in MySQL 5.6.9 (2012-12-11) Changes in MySQL 5.6.8 (2012-11-07) Changes in MySQL 5.6.7 (2012-09-29, Release Ca...
DBA and Developer Guide to MySQL 5.6 Building the Next Generation of Web Applications and Services At a glance, MySQL 5.6 is simply a better MySQL with improvements that enhance every functional area of the database kernel, including: Better Performance and...
一貫した読み取りとは、InnoDBがそのマルチ バージョニング機能を使用して、ある時点でのデータベースのスナップショットをクエリに提示する事を意味します。クエリには、その時点より前にコミットされたトランザクションによる変更のみが示され、その時点より後のトランザクシ...
MySQL 5.6 supports delayed replication such that a slave server deliberately lags behind the master by at least a specified amount of time. The default delay is 0 seconds. Use the MASTER_DELAY option for CHANGE MASTER TO to set the delay to N seconds: CHANG...
MySQL for Excel allows you to work directly and access a MySQL Server database from within Microsoft Excel. The main features include: Importing data into a new or existing Microsoft Excel spreadsheet. Exporting data from a Microsoft Excel spreadsheet to a ...
Section 2.11.1, “Upgrading MySQL”, has general update information. The items in the change lists provided later in this section enable you to identify upgrade issues that apply to your current MySQL installation. Some incompatibilities discussed there req...
Section Navigation [Toggle] 12.4 MySQL トランザクションとロッキング関連のステートメント12.4.1 START TRANSACTION、COMMIT、そして ROLLBACK 構文 12.4.2 ロールバックできないステートメント 12.4.3 暗黙のコミットを引き起こすステートメント 12.4.4 SAVEPOINT と ...
Section Navigation [Toggle] 14.2 The InnoDB Storage Engine14.2.1 Getting Started with InnoDB 14.2.2 Creating and Using InnoDB Tables and Indexes 14.2.3 Administering InnoDB 14.2.4 InnoDB Concepts and Architecture 14.2.5 InnoDB Performance Tuning and Tr...
Section Navigation [Toggle] D.1 Changes in Release 5.6.x (Development)D.1.1 Changes in MySQL 5.6.6 (Not yet released, Milestone 9) D.1.2 Changes in MySQL 5.6.5 (2012-04-10, Milestone 8) D.1.3 Changes in MySQL 5.6.4 (2011-12-20, Milestone 7) D.1.4 Chang...
Abstract This is the MySQL™ Reference Manual. It documents MySQL 5.6 through 5.6.7. MySQL Cluster is currently not supported in MySQL 5.6. For information about MySQL Cluster, please see MySQL Cluster NDB 7.2. MySQL 5.6 features. This manual describes fea...
MySQL サーバに接続しようとして Access denied エラーが発生した場合の対処法を、以下に示します。 MySQL のインストール後、mysql_install_db スクリプトを実行して権限テーブルを初期設定していなければ、これを行う。 See 項4.4.4. 「MySQL 権限の初期設定」。 以下のコマ...
もし MyISAM テーブルが可変長カラムを含んでいる場合(VARCHAR、 VARBINARY、 BLOB、または TEXT)、または ROW_FORMAT=DYNAMIC テーブルオプションで作成された場合は、動的ストレージフォーマットが使用されます。 動的フォーマットは、それぞれの行にその長さを示すヘッダー...
The MySQL server maintains many system variables that indicate how it is configured. Each system variable has a default value. System variables can be set at server startup using options on the command line or in an option file. Most of them can be changed ...
DATADIR は MySQL データディレクトリです（通常、バイナリインストールの場合は /usr/local/mysql/data、ソースインストールの場合は /usr/local/var）。 注意: これは、コンフィギャ時に指定されたディレクトリです。mysqld 起動時に --datadir で指定したディレクトリではあ...
We are always looking for interesting articles about MySQL! Have you written something and would like to it published here? Please contact us via feedback form » Global Transaction IDs & Utilities for Self-Healing Replication Clusters The new MySQL 5.6.5 De...
