Why was “source” chosen? MySQL Asynchronous Replication is a change stream. Each replication configuration has a source and does not imply what role a server should have in the overall database architecture. Therefore, the use of e.g. “primary” does not fit, especially when replication is used to build database architectures topologies including bidirectional replication, multi-tiered replication,

The build phase The literature usually divides hash join in two phases; the build phase and the probe phase. In the build phase, the server builds an in-memory hash table where rows from one of the inputs are stored, using the join attribute(s) as the hash table key. This input is also known as the build input, and let us assume that ‘countries’ is designated as the build input. Ideally, the serve

The MySQL Development Team is happy to announce the first GA release of InnoDB Cluster–our integrated, native, full stack HA solution for MySQL. You can see highlights of the changes and improvements made since the RC release here, and you can download the GA packages from our MySQL APT (Ubuntu, Debian) and YUM (Redhat, OEL, Fedora) repositories or from dev.mysql.com. InnoDB Cluster consists of th

ハードウェアまたはオペレーティングシステムのアーキテクチャーによっては、デフォルト (通常は 4K バイト) よりも大きいメモリーページをサポートしています。 このサポートの実際の実装は、ベースとなるハードウェアやオペレーティングシステムに依存します。 大量のメモリーアクセスがあるアプリケーションの場合、大きいページを使用して、トランスレーションルックアサイドバッファー (TLB; Translation Lookaside Buffer) のミスが減ることによってパフォーマンスが改善される可能性があります。 MySQL では、InnoDB でラージページを使用して、バッファープールと追加のメモリープールにメモリーを割り当てることができます。 MySQL での標準的な大規模ページの使用では、サポートされる最大サイズである 4M バイトまでの使用が試行されます。 Solaris では「超大規

InnoDB INFORMATION_SCHEMA Transaction and Locking Information

I think most people will agree that downloading RPMs from a website is kind of old fashioned when there are yum repos. After a number of user requests, we have now launched the official yum repos for MySQL. Can’t wait? Neither can I. On a fresh install: Download a setup package for your distribution from http://dev.mysql.com/downloads/repo yum localinstall mysql-community-release-distro-release.no

InnoDB INFORMATION_SCHEMA Transaction and Locking Information

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 MySQL Server database. Appending Microsoft Excel data into an existing MySQL Server database table. Editing MySQL Server data directly from a M

Enabling Automatic InnoDB Configuration for a Dedicated MySQL Server

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 Changes in MySQL 5.6.3 (2011-10-03, Milestone 6) D.1.5 Changes in MySQL 5.6.2 (2011-04-11) D.1.6 Changes in MySQL 5.6.1 (Not released, Milestone 5)