Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 35153 10 Older Entries
Simplifying Docker Interactions with BASH Aliases
+0 Vote Up -0Vote Down


Docker has been consuming my life in the last few weeks. I have half a dozen projects in progress that use containers in some fashion, including my Visualizing MySQL’s Performance Schema project.

Since I prefer to work from a Mac laptop, I have to utilize an intermediary Linux Virtual Machine (VM) which runs the Docker daemon. Luckily, Docker Machine makes this a …

  [Read more...]
Getting started MySQL Group Replication on Ubuntu with MySQL Sandbox
+1 Vote Up -0Vote Down

Welcome to next topic dedicated to Group Replication plugin. Today’s topic is to get started with Group Replication. As you remember we set up our environment using MySQL Sandbox on Ubuntu 14.04 and also we have compiled plugin with MySQL 5.7.8-rc on Ubuntu 14.04. Please refer to this topics respectively:

  1. MySQL Sandbox creating test environment
  2. Compiling MySQL …
  [Read more...]
MySQL lost “AUTO_INCREMENT” after a long time
+0 Vote Up -0Vote Down


I create a empty table and then alter this table's "AUTO_INCREMENT" starts from 10000000.After a long time ,MySQL lost "AUTO_INCREMENT" definition when I show this table again. MariaDB has the same problem but Percona Server is fine.


Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 141028725
Server version: 5.6.17-log MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights …
  [Read more...]
New statements I'd like to see in MySQL 5.8
+1 Vote Up -0Vote Down

Following up on New features I'd like to see in MySQL 5.8, here are statements I would like to see in MySQL 5.8:

    When promoting a slave to master, I want to be able to enable all those events that are in SLAVESIDE_DISABLED state. Today I script an iteration over the events an constructing the ALTER EVENT...ENABLE statement one by one. Just activate those!
    I have a …

  [Read more...]
Sound advice for GTID, with caveats
+0 Vote Up -0Vote Down

During the PerconaLive conference in Amsterdam, I attended a session where I heard a good piece of advice about using GTID. It amounts to: look at SHOW SLAVE STATUS output, and if you see more than one line in the Executed_Gtid_Set field, this tells you immediately if someone has written on a slave database.
This is good advice. Let's dissect it. Here is what a regular slave looks like, when nobody has messed up with it:

*************************** 1. row ***************************

  [Read more...]
Using Apache Spark and MySQL for Data Analysis
+0 Vote Up -0Vote Down

What is Spark

Apache Spark is a cluster computing framework, similar to Apache Hadoop. Wikipedia has a great description of it:

Apache Spark is an open source cluster computing framework originally developed in the AMPLab at University of California, Berkeley but was later donated to the Apache Software Foundation where it remains today. In contrast to Hadoop’s two-stage disk-based MapReduce paradigm, Spark’s multi-stage in-memory primitives provides performance up to 100 times faster …

  [Read more...]
Employee_Team +1 Vote Up -0Vote Down

Because somebody asked for it on Freenode:

CREATE FUNCTION DATE_TRUNC(field ENUM('microsecond', 'millisecond', 'second', 'minute', 'hour', 'day', 'week', 'month', 'quarter', 'year', 'decade', 'century', 'millennium'), source datetime(6))
RETURNS datetime(6)
  IF field IN ('millisecond') THEN SET source = source - INTERVAL MICROSECOND(source) % 1000 MICROSECOND; END IF;
  IF field NOT IN ('microsecond', 'millisecond') THEN SET source = source - INTERVAL MICROSECOND(source) MICROSECOND; END IF;
  IF field NOT IN ('microsecond', 'millisecond', 'second') THEN SET source = source - INTERVAL SECOND(source) SECOND; END IF;
  IF field NOT IN ('microsecond', 'millisecond', 'second', …
  [Read more...]
Welcome Amazon Web Services to the MariaDB Community
+1 Vote Up -0Vote Down

Wed, 2015-10-07 17:43Roger Levy

At this week’s re:Invent conference, Amazon Web Services (AWS) announced it is joining the MariaDB community with the introduction of its Relational Database Service (RDS) for MariaDB. Amazon’s decision was driven by the growing demand among its customers for MariaDB, which now has over two million users in 45 countries.

The new offering will provide additional options for how users can deploy and consume MariaDB. Companies can leverage the AWS MariaDB offering for cloud-based managed database services or for building hybrid cloud/premises architectures for cloud bursting and disaster recovery. Look for …

  [Read more...]
Improved ALTER USER Syntax Support in 5.7
Employee_Team +1 Vote Up -0Vote Down

Complimenting the expanded CREATE USER syntax introduced in MySQL Server 5.7.6 is more useful ALTER USER syntax. Before MySQL Server 5.7.6, ALTER USER could only be used to expire a user’s password. That’s pretty limited. With changes made in MySQL Server 5.7.6, a better distinction is made between privilege-level attributes (those which are …

  [Read more...]
Problems not worth fixing
+0 Vote Up -0Vote Down

I worked on a closed-source DBMS years ago and the development cycle was 1) code for 6 months 2) debug for 18 months. Part 2 was longer than part 1 because the customers have high expectations for quality and the product delivers on that. But it was also longer because some co-workers might not have been code complete after 6 months and were quietly extending part 1 into part 2.

I fixed many bugs during part 2. One that I remember was in the optimizer. Someone added code to detect and remove duplicate expressions (A and A and B --> A and B). Alas the algorithm was O(N*N). Analytics queries can have complex WHERE clauses …

  [Read more...]
Showing entries 1 to 10 of 35153 10 Older Entries

Planet MySQL © 1995, 2015, 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.