Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 983 10 Older Entries

Displaying posts with tag: Uncategorized (reset)

MySQL Group Replication: Auto-increment configuration/handling
Employee_Team +0 Vote Up -0Vote Down

In 0.5.0 version of MySQL Group Replication plugin, we have introduced the Auto-increment configuration/handling feature through which auto increment variables (auto_increment_increment and auto_increment_offset) are auto configured by the plugin, so that different members of the group don’t generate duplicated auto increment values.…

The Primary Component in Galera Cluster
+0 Vote Up -0Vote Down

In this post, we will describe the Primary Component, a central concept in how Galera ensures that there is no opportunity for database inconsistency or divergence between the nodes in case of a network split.

What is the Primary Component?

The Primary Component is that set of Galera nodes that can communicate with each other over the network and contains the majority of the nodes. In case of a network partition, it is those nodes that can safely commit a transaction. A cluster can only have one such set of nodes, as there can only be one majority. No other set of nodes will commit transactions, thus removing the possibility of …

  [Read more...]
MySQL Group Replication – 0.4.0 Labs Release
Employee_Team +2 Vote Up -0Vote Down

Hi all, it is time again to do another preview release of MySQL Group Replication, the plugin that brings multi-master update everywhere to MySQL, like we described in Hello World post.

We are very proud to do the third preview release of MySQL Group Replication, which introduces new exciting features, please enjoy the highlights!…

MySQL Group Replication: Plugin Version Access Control.
Employee_Team +2 Vote Up -0Vote Down

Here is version 0.4.0 of the MySQL Group Replication plugin, our solution that gives you virtual synchronous updates on any member of a MySQL server group. With this new version you can expect a bunch of bug fixes and new features.…

MySQL Group Replication – 0.4.0 Labs Release Plugin Packages
Employee_Team +1 Vote Up -0Vote Down

The multi master plugin for MySQL is here. MySQL Group Replication provides virtually synchronous updates on any member in a group of MySQL servers, with conflict handling and automatic group membership management and failure detection.

You can read about all MySQL Group Replication features following the tag MySQL Group Replication.

On this blog post we will present the packages the MySQL Group Replication 0.4.0 offers and what are the tasks that you need to perform to install the plugin on the MySQL server.

  [Read more...]
Is mysql/innodb good for high volume inserts?
+0 Vote Up -0Vote Down

As we are collecting an ever increasing amount of data and analyzing it, data storage products with alternate file structures have become popular, such as LSMs (log structured merge files) which is implemented in Cassandra and Hbase, as well as fractal indexes found in TokuDB/MX, which is an alternate file structure plugin for mysql and [...]

NDB 7.4 & SYS schema: When getting locks, detecting the guilty SQL & o.s.pid.
Employee +1 Vote Up -0Vote Down

Here’s a way to detect the sql query causing a lock or a session to fail, and also to identify the o.s.pid if need be (btw, no rocket science). “a” way.. I’m sure there are many others, so feel free to suggest, please.

So, we’re using MCM, and have created a MySQL Cluster like mentioned in the cluster intro session (in Spanish I’m afraid), using 7.4.6, which comes with 5.6.24.

With the env up and running, set up a schema, some data and run a few queries:

mysql> create database …
  [Read more...]
Error: 1034 HY000 Incorrect key file for table /tmp/#sql_actor_return; try to repair it
+0 Vote Up -0Vote Down

It mentions in the message that you can try to repair it. Also, if you look at the actual FILEPATH you get, you can find out more:

  • if it is something like /tmp/#sql_actor_return it means that MySQL needs to create a temporary table because of the query size. It stores it in /tmp, and that there is not enough space in your /tmp for that temporary table. increase the tmp_table_size variable and /tmp/ partition size
  • If it contains the name of an actual table instead, it means that this table is very likely corrupted and you should repair it using  …
  [Read more...]
MySQL ERROR 1114 : The table is full
+0 Vote Up -0Vote Down

If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits.

Limits on Table size : The following table lists some examples of operating system file-size limits. This is only a rough guide and is not intended to be definitive.

If you do encounter a full-table error, there are several reasons why it might have occurred:

  • The …
  [Read more...]
on ORDER BY optimization | Domas Mituzas
+0 Vote Up -0Vote Down

http://dom.as/2015/07/30/on-order-by-optimization/

An insightful exploration by Domas (Facebook) on how some of the MySQL optimiser’s decision logic is sometimes naive, in this case regarding ORDER BY optimisation.

Quite often, “simple” logic can work better than complex logic as chasing all the corner cases can just make things worse – but sometimes, logic can be too simple.

Everything must be made as simple as possible, but no simpler.
— Albert Einstein / Roger Sessions

10 Newer Entries Showing entries 31 to 40 of 983 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.