Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 91 to 100 of 34980 10 Older Entries
Why you should be careful when Loading data in MySQL with Galera.
+0 Vote Up -0Vote Down

An old story that is not yet solve.

 

Why this article.

Some time ago I had open a bug report to codership through Seppo.

The report was about the delay existing in executing data load with FK. (https://bugs.launchpad.net/codership-mysql/+bug/1323765).

The delay I was reporting at that time were such to scare me a lot, but I know talking with Alex and Seppo that they were aware of the need to optimize the approach an some work was on going.

After some time …

  [Read more...]
HeidiSQL 9.3 released
+0 Vote Up -0Vote Down

This is a maintenance release which contains mainly bugfixes.

Get it from the download page.



Changelog:
* Bugfix: Crash in foreign key dropdown editor
* Bugfix: Crash when killing processes on very long running servers
* Bugfix: SQL error when accessing UUID and JSON columns in PostgreSQL via SUBSTR
* Bugfix: MSSQL: Prefer "schema.table" quoting over "schema"."table" when renaming a table
* Bugfix: Fix column type …










  [Read more...]
MariaDB 10.1.6 Overview and Highlights
+0 Vote Up -0Vote Down

MariaDB 10.1.6 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.1.6/

This is the 4th beta, and 7th overall, release of MariaDB 10.1. There were not many major changes in this release, but a few notable items, as well as many overall bugs fixed (I counted 156, down ~50% from 10.1.5).

Since it’s beta, I’ll only cover the major changes and additions, and omit covering general bug fixes (feel free to browse them all here).

…  [Read more...]
MySQL 5.6.26 Overview and Highlights
+1 Vote Up -0Vote Down

MySQL 5.6.26 was recently released (it is the latest MySQL 5.6, is GA), and is available for download here.

For this release, there are 3 “Functionality Added or Changed” items, 1 “Security Fix”, and 36 other bug fixes.

Out of those other 36 bugs, 13 are InnoDB, 1 Partitioning, 3 Replication, and 19 misc. (including 3 potentially crashing bug fixes, and 1 performance-related fix) Here are the ones of note:

  • Functionality Added/Changed: Replication: When using a multi-threaded slave, each worker thread has its own queue of …
  [Read more...]
Find Queries By Error Code With VividCortex
+0 Vote Up -0Vote Down

VividCortex now lets you search for queries that cause a specific error in your application. The error code itself will be database-specific, but for example error 1062 in MySQL is a duplicate key error, and in PostgreSQL error 23503 is a foreign key violation.

One of our customers requested that we add this feature so they could search for queries that cause UTF8 issues, which is a great example of when this can be useful.

To use this feature, click on the Queries navigation link, which brings up a catalog of every query we have seen execute in your systems. At the top, select the drop-down menu and filter by errors, then type in the …

  [Read more...]
Find Queries By Error Code With VividCortex
+0 Vote Up -0Vote Down

VividCortex now lets you search for queries that cause a specific error in your application. The error code itself will be database-specific, but for example error 1062 in MySQL is a duplicate key error, and in PostgreSQL error 23503 is a foreign key violation.

One of our customers requested that we add this feature so they could search for queries that cause UTF8 issues, which is a great example of when this can be useful.

To use this feature, click on the Queries navigation link, which brings up a catalog of every query we have seen execute in your systems. At the top, select the drop-down menu and filter by errors, then type in the error …

  [Read more...]
MySQL 5.5.45 Overview and Highlights
+1 Vote Up -0Vote Down

MySQL 5.5.45 was recently released (it is the latest MySQL 5.5, is GA), and is available for download here:

http://dev.mysql.com/downloads/mysql/5.5.html

This release, similar to the last 5.5 release, is mostly uneventful.

There were 0 “Functionality Added or Changed” items this time, 1 “Security Fix”, and just 9 bugs overall fixed.

Out of the 9 bugs, there were 3 InnoDB bugs, 1 security-related bug, and 1 potential crashing bug. Here are the ones worth noting:

  • InnoDB: An index record was not found on rollback due to …
  [Read more...]
MariaDB: InnoDB foreign key constraint errors
+0 Vote Up -0Vote Down

Introduction

A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table. The table containing the foreign key is called the child table, and the table containing the candidate key is called the referenced or parent table. The purpose of the foreign key is to identify a particular row of the referenced table. Therefore, it is required that the foreign key is equal to the candidate key in some row of the primary table, or else have no value (the NULL value). This is called a referential integrity constraint between the two tables. Because violations of these constraints can be the …

  [Read more...]
Log Buffer #435: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Sun of database technologies is shining through the cloud technology. Oracle, SQL Server, MySQL and various other databases are bringing forth some nifty offerings and this Log Buffer Edition covers some of them.

Oracle:

  • How to create your own Oracle database merge patch.
  • Finally the work of a database designer will be recognized! Oracle has announced the Oracle …
  [Read more...]
Oracle dump utility version 1.1
+0 Vote Up -0Vote Down

Today I released version 1.1 of myoradump for download from sourceforge. If you don't know what myoradump is, this is a utility for exporting data from an Oracle database in some relevant text format so that it can be imported to some other database.

The main thing in version 1.1 is that I have added a whole bunch of new output formats, so make it even easier to get your data out of expensive Oracle and into something more effective. The new formats supported are:

  • MySQL - The format of this is a bunch of INSERT …



  [Read more...]
10 Newer Entries Showing entries 91 to 100 of 34980 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.