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

Displaying posts with tag: mysql (reset)

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...]
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...]
5 DevOps Conferences You Should Consider Attending
+0 Vote Up -0Vote Down

We love developer conferences, they are informative, fun and a great way to network with like minded people. The sessions can help you and your organization discuss and address technology challenges, learn how others are solving problems and exchange knowledge. Even if you can’t make it, most of these conferences are streamed online. Here are the 5 DevOp conferences you should consider attending.

AWS re:Invent

The annual cloud conference, by market leaders themselves, is an event which …

  [Read more...]
MariaDB Developers Meeting + User Group NL
+1 Vote Up -0Vote Down

Next week, all the MariaDB Server developers will descend to Amsterdam for the developer’s meeting. As you know the meeting is open to all interested parties, so we hope to see you in Amsterdam Tuesday Oct 13 – Thursday Oct 15. The schedule is now online as well.

In addition to that, Monday Oct 12 2015, there is also a …

  [Read more...]
New features I'd like to see in MySQL 5.8
+2 Vote Up -0Vote Down

Following up on Morgan Tocker's What would you like to see in MySQL 5.8?, having attended and participated at the brainstorming at Percona Live Amsterdam, and publishing this post while failing to comply with any of Morgan's suggested media, these are the features I would like to see in MySQL 5.8:

  • Dynamicly enable/disable log-bin and …
  [Read more...]
Showing entries 1 to 10 of 17294 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.