[ANN] Mroonga 8.06 - Fast fulltext search for all languages on MySQL

Mroonga 8.06 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

Re: what is the rationale for not allowing LOCK TABLES in a stored procedure

Hello Mogens, On 8/18/2018 2:32 PM, Mogens Melander wrote: Guys, I think I remember this from way back. You could ask for a lock, and get an OK if it is safe. Something like, if there is pending transactions, on your target tables, you would get a NO. But then again. I could be wrong, and

Re: what is the rationale for not allowing LOCK TABLES in a stored procedure

Guys, I think I remember this from way back. You could ask for a lock, and get an OK if it is safe. Something like, if there is pending transactions, on your target tables, you would get a NO. But then again. I could be wrong, and Shawn is the authority on this. On 2018-08-18 23:59, shawn

Re: how to select the record with one sql statement?

Hello sea, On 8/13/2018 7:01 PM, sea wrote: helle, I have a table, like this: pigId dayweigt pig1 2018-1-121 pig2 2018-1-131 pig3 2018-1-141 pig1 2018-1-222 pig2 2018-1-2

Re: what is the rationale for not allowing LOCK TABLES in a stored procedure

Hello Jeff, On 8/13/2018 12:05 PM, j...@lxvi.net wrote: Hello, I have read through several pages of the reference manual, and I've seen several instances where it is stated that LOCK TABLES (and UNLOCK TABLES) is not allowed in a stored procedure, but so far, I haven't found an explanation as

MySQL Connector/J 5.1.47 GA has been released

Dear MySQL Users, MySQL Connector/J 5.1.47, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. MySQL Connector/J is available in source and binary form from the Connector/J download pages at

MySQL Connector/NET 6.10.8 has been released

Dear MySQL users, MySQL Connector/NET 6.10.8 is the fifth GA release with .NET Core now supporting various connection-string options and MySQL 8.0 server features. To download MySQL Connector/NET 6.10.8 GA, see the "Generally Available (GA) Releases" tab at

how to select the record with one sql statement?

helle, I have a table, like this: pigId dayweigt pig1 2018-1-121 pig2 2018-1-131 pig3 2018-1-141 pig1 2018-1-222 pig2 2018-1-231 pig3 2018-1-240 pig1

what is the rationale for not allowing LOCK TABLES in a stored procedure

Hello, I have read through several pages of the reference manual, and I've seen several instances where it is stated that LOCK TABLES (and UNLOCK TABLES) is not allowed in a stored procedure, but so far, I haven't found an explanation as to *why* that is. Could someone please enlighten me? Thanks

MySQL Connector/ODBC 5.3.11 has been released

Dear MySQL users, MySQL Connector/ODBC 5.3.11, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the driver type you need based

MySQL Shell 8.0.12 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users, MySQL Shell 8.0.12 is a maintenance release of MySQL Shell 8.0 Series (a component of the MySQL Server). The MySQL Shell is provided under Oracle's dual-license. MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Shell 8.0.12.

MySQL Connector/Node.js 8.0.12 has been released

Dear MySQL users, MySQL Connector/Node.js is a new Node.js driver for use with the X DevAPI. This release, v8.0.12, is a maintenance release of the MySQL Connector/Node.js 8.0 series. The X DevAPI enables application developers to write code that combines the strengths of the relational and

MySQL Connector/NET 8.0.12 has been released

Dear MySQL users, MySQL Connector/NET 8.0.12 is the second general availability release of MySQL Connector/NET to add support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern,

MySQL Cluster 7.4.21 has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL.  This storage engine provides:   - In-Memory storage - Real-time performance   - Transparent Auto-Sharding - Read & write scalability   - Active-Active/Multi-Master geographic replication   - 99.999% High

MySQL Community Server 5.5.61 has been released

Dear MySQL users, MySQL Server 5.5.61 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.61 is recommended for use on production systems. MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the

MySQL Connector/J 8.0.12 has been released

Dear MySQL users,   MySQL Connector/J Version 8.0.12 is the second GA release of the 8.0   branch of MySQL Connector/J. It is suitable for use with MySQL Server   versions 5.5, 5.6, 5.7, and 8.0. It supports the Java Database Connectivity   (JDBC) 4.2 API, and implements the X DevAPI. This

MySQL Cluster 7.2.34 has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides:   - In-Memory storage - Real-time performance (with optional     checkpointing to disk)   - Transparent Auto-Sharding - Read & write scalability   - Active-Active/Multi-Master

MySQL Cluster 7.5.11 has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides:   - In-Memory storage - Real-time performance (with optional     checkpointing to disk)   - Transparent Auto-Sharding - Read & write scalability   - Active-Active/Multi-Master

MySQL Community Server 5.6.41 has been released

Dear MySQL users, MySQL Server 5.6.41, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.41 is recommended for use on production systems. For an overview of what's new in MySQL 5.6, please see

MySQL Community Server 5.7.23 has been released

Dear MySQL users, MySQL Server 5.7.23, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.23 is recommended for use on production systems. For an overview of what's new in MySQL 5.7, please see

MySQL Community Server 8.0.12 has been released (part 2/2)

[Due to size limitation, this announcement is split in two. This is part 2] Bugs Fixed * Important Change; JSON: The JSON_TABLE() function now automatically decodes base-64 values and prints them using the character set given by the column specification. (Bug #90157,

MySQL Enterprise Backup 8.0.12 has been released

Dear MySQL users, MySQL Enterprise Backup 8.0.12, a new version of the online MySQL backup tool, is now available for download from the My Oracle Support (MOS) website as our latest GA release. This release will be available on eDelivery (OSDC) after the next upload cycle. MySQL Enterprise

MySQL Community Server 8.0.12 has been released (part 1/2)

[Due to size limitation, this announcement is split in two. This is part 1] Dear MySQL users, MySQL Server 8.0.12, a new version of the popular Open Source Database Management System, has been released. MySQL 8.0.12 is recommended for use on production systems. For an overview of what's new in

MySQL Workbench 8.0.12 has been released

Dear MySQL users, The MySQL developer tools team announces 8.0.12 as our first general availability (GA) for MySQL Workbench 8.0. For the full list of changes in this revision, visit http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html For discussion, join the MySQL Workbench

MySQL Connector/C++ 8.0.12 has been released

Dear MySQL users, MySQL Connector/C++ 8.0.12 is the second GA release version of the MySQL Connector/C++ 8.0 series. Connector/C++ 8.0 can be used to access MySQL implementing Document Store or in a traditional way, using SQL queries. It allows writing both C++ and plain C applications using X

Re: ANN: Upscene releases Database Workbench 5.4.4

Sent from my Samsung Galaxy smartphone. Original message From: "Martijn Tonies (Upscene Productions)" Date: 09/07/2018 13:17 (GMT+00:00) To: firebird-to...@yahoogroups.com, mysql@lists.mysql.com Subject: ANN: Upscene releases Database Workbench 5.4.4 Upscene Productions

ANN: Upscene releases Database Workbench 5.4.4

Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.4 “ This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases included a

ANN: Stored routine debugger Hopper, version 2.0.1 released

Dear ladies and gentlemen, Upscene Productions is proud to announce version 2.0.1 of "Hopper", a stored routine debugger for InterBase, Firebird and MySQL. Major version 2 has a fully renewed user interface, support for Firebird 3 packages, stored functions, MySQL diagnostic-statements, binary

MySQL Cluster 7.6.6 GA has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides: - In-Memory storage - Real-time performance (with optional checkpointing to disk) - Transparent Auto-Paritioning (Sharding) - Read & write scalability - Transactional

[ANN] Mroonga 8.03 - Fast fulltext search for all languages on,MySQL

Mroonga 8.03 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

MySQL Cluster Manager 1.4.6 has been released

Dear MySQL Users, MySQL Cluster Manager 1.4.6 can be downloaded from the My Oracle Support (MOS) website. It will also be available on Oracle Software Delivery Cloud at http://edelivery.oracle.com with the next monthly update MySQL Cluster Manager is an optional component of the MySQL Cluster

MySQL for Visual Studio 1.2.8 has been released

Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL for Visual Studio 1.2.8. This is a maintenance release for 1.2.x. It can be used for production environments. MySQL for Visual Studio is a product that includes all of the Visual Studio integration

[ANN] Mroonga 8.02 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 8.02 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

MySQL Cluster 7.6.5-dmr has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides: - In-Memory storage - Real-time performance (with optional checkpointing to disk) - Transparent Auto-Sharding - Read & write scalability - Active-Active/Multi-Master

MySQL Cluster 7.4.20 has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides:   - In-Memory storage - Real-time performance   - Transparent Auto-Sharding - Read & write scalability   - Active-Active/Multi-Master geographic replication   - 99.999% High

MySQL Cluster 7.5.10 has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides:   - In-Memory storage - Real-time performance (with optional     checkpointing to disk)   - Transparent Auto-Sharding - Read & write scalability   - Active-Active/Multi-Master

MySQL Cluster 7.3.21 has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides:   - In-Memory storage - Real-time performance (with optional     checkpointing to disk)   - Transparent Auto-Sharding - Read & write scalability   - Active-Active/Multi-Master

MySQL Connector/Python 8.0.11 has been released

Dear MySQL users, MySQL Connector/Python 8.0.11 is the first GA release version of the MySQL Connector Python 8.0 series. This series adds support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models

MySQL Connector/Net 8.0.11 has been released

Dear MySQL users, MySQL Connector/Net 8.0.11 is the first general availability release of MySQL Connector/Net to add support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern,

MySQL Connector/C++ 8.0.11 GA has been released

Dear MySQL users, MySQL Connector/C++ 8.0.11 is the first GA release version of the MySQL Connector/C++ 8.0 series. Connector/C++ 8.0 can be used to access MySQL implementing Document Store or in a traditional way, using SQL queries. It allows writing both C++ applications using X DevAPI or

MySQL Connector/ODBC 8.0.11 GA has been released

Dear MySQL users, MySQL Connector/ODBC 8.0.11 is the first GA version of the MySQL Connector/ODBC 8.0 series, the ODBC driver for the MySQL database management system. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the

MySQL Community Server 5.6.40 has been released

Dear MySQL users, MySQL Server 5.6.40, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.40 is recommended for use on production systems. For an overview of what's new in MySQL 5.6, please see

MySQL Workbench 8.0.11-rc has been released

Dear MySQL users, The MySQL developer tools team announces 8.0.11 as our release candidate (RC) for MySQL Workbench 8.0. For the full list of changes in this revision, visit http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html For discussion, join the MySQL Workbench Forums:

MySQL Community Server 5.7.22 has been released

Dear MySQL users, MySQL Server 5.7.22, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.22 is recommended for use on production systems. For an overview of what's new in MySQL 5.7, please see

MySQL Enterprise Backup 8.0.11 has been released

Dear MySQL users, MySQL Enterprise Backup 8.0.11, a new version of the online MySQL backup tool, is now available for download from the My Oracle Support (MOS) website as our latest GA release. This release will be available on eDelivery (OSDC) after the next upload cycle. MySQL Enterprise

MySQL Community Server 8.0.11 has been released (part 2/2)

[This is part 2 of the announcement] * Replication: A new system variable rpl_read_size is    available to set the minimum amount of data in bytes that    is read from the binary log files and relay log files.    The default read size is 8KB. If heavy disk I/O activity   

MySQL Community Server 8.0.11 has been released (part 1/2)

[Due to size limitations, the announcement is split in 2 parts. This is part 1.] Dear MySQL users, MySQL Server 8.0.11 (GA) is a new version of the world's most popular open source database. This is the first official release of MySQL 8.0. The new features in this release are now deemed to be

Re: MySQL optimization for testing purpose

On 04/03/2018 06:15 PM, Sebastien FLAESCH wrote: On 04/03/2018 05:59 PM, Sebastien FLAESCH wrote: Hi all, Looking for some configuration tips to speed execution of our non-regression tests with MySQL. We do pure functional testing, data persistence is not critical. Our tests are not using a

Re: MySQL optimization for testing purpose

On 04/03/2018 05:59 PM, Sebastien FLAESCH wrote: Hi all, Looking for some configuration tips to speed execution of our non-regression tests with MySQL. We do pure functional testing, data persistence is not critical. Our tests are not using a lot of data, but we create and drop a lot of test

MySQL optimization for testing purpose

Hi all, Looking for some configuration tips to speed execution of our non-regression tests with MySQL. We do pure functional testing, data persistence is not critical. Our tests are not using a lot of data, but we create and drop a lot of test tables. We have concurrency tests (processes

[ANN] Mroonga 8.01 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 8.01 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

Probably the dumbest suggestion yet, but have you tried "set names utf8" in the client? On 20 March 2018 20:50:08 CET, Roger House wrote: > > >On 03/15/2018 02:06 PM, Roger House wrote: >> >> >> On 03/15/2018 11:30 AM, shawn l.green wrote: >>> Hi Roger, >>> >>> (please note,

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

On 03/15/2018 02:06 PM, Roger House wrote: On 03/15/2018 11:30 AM, shawn l.green wrote: Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 22:59 schrieb Roger House: >>>

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

On 03/15/2018 11:30 AM, shawn l.green wrote: Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 22:59 schrieb Roger House: >>> In all respects except one, the treatment of

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 22:59 schrieb Roger House: >>> In all respects except one, the treatment of Unicode works just fine. >>> I can write Unicode

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

I am running Ubuntu MATE 16.04.  I have the problem also on Windows 7 and on Mac OS Version 10.11.6.  I do not think that the problem has to do with the operating system nor the terminal.  Everything about the Unicode text works fine in all tools such as editors, the cat command, etc.  It is

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

Am 13.03.2018 um 22:59 schrieb Roger House: In all respects except one, the treatment of Unicode works just fine. I can write Unicode to database tables, read it, display it, etc., with no problems. The exception is mysql, the MySQL Command-Line Tool. When I execute a SELECT statement to see

How to get the MySQL Command-Line Tool to display Unicode properly?

Five months ago I posted the query shown below on StackOverflow.  I got one reply which was not of much help.  So I am trying again, hoping a more MySQL-centric forum might be able to solve my problem. Roger House How to get the MySQL Command-Line Tool to display Unicode properly? I use a

MySQL Connector/Java 5.1.46 GA has been released

Dear MySQL Users, MySQL Connector/J 5.1.46, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. MySQL Connector Java is available in source and binary form from the Connector/J download pages at

ANN: Upscene releases Database Workbench 5.4.2

Upscene releases Database Workbench 5.4.2 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.2 “ This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version

Procedure error handling Best Practice

Long time Oracle PL/SQL coder but new to MySQL. I have an error handler that looks like this ... declare continue handler for sqlexception begin get diagnostics condition 1 @p3 = returned_sqlstate, @p4 = message_text; set v_there_was_an_error_while_inserting_a_lead_summary :=

MySQL Connector/C++ 8.0.7-rc has been released

Dear MySQL users, MySQL Connector/C++ 8.0.7-rc is the release candidate (RC) of the MySQL Connector/C++ 8.0 series. Connector/C++ 8.0 can be used to access MySQL implementing Document Store or in a traditional way, using SQL queries. It allows writing both C++ applications using X DevAPI or

Re: mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today

Subject: Re: mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today > 2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. > How do I run mysql_upgrade if the mysqld server won't start? Please don't bother to answer, I

Re: Optimize fails due to duplicate rows error but no duplicates found

(please do not top post - see my answer below) On 2/13/2018 4:00 PM, Machiel Richards wrote: ok, so we have managed to get an id out of the errors etc... however when we look in the table that id does not even exist at all. no idea what is going on here though.

Re: mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today

Am 23.02.2018 um 15:15 schrieb Bob Eby: 2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. How do I run mysql_upgrade if the mysqld server won't start? post the *full* errorlog and watch for invaluid config stuff most

mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today

2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. How do I run mysql_upgrade if the mysqld server won't start? Man how stupid am I? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Optimize fails due to duplicate rows error but no duplicates found

ok, so we have managed to get an id out of the errors etc... however when we look in the table that id does not even exist at all. no idea what is going on here though. From: shawn l.green Sent: 13 February 2018 09:51:33 PM To:

Re: Optimize fails due to duplicate rows error but no duplicates found

Thank you for the response. There are no partitioning involved at all... I will try the suggestion though and see if we get anything... Regards From: shawn l.green Sent: 13 February 2018 09:51:33 PM To: mysql@lists.mysql.com

Re: Optimize fails due to duplicate rows error but no duplicates found

Hello Machiel, On 2/13/2018 3:02 AM, Machiel Richards wrote: Good day guys, I am hoping this mail finds you well. I am at a bit of a loss here... We are trying to run optimize against a table in order to reclaim disk space from archived data which has been removed.

Optimize fails due to duplicate rows error but no duplicates found

Good day guys, I am hoping this mail finds you well. I am at a bit of a loss here... We are trying to run optimize against a table in order to reclaim disk space from archived data which has been removed. However, after running for over an hour , the optimize fails stating

[ANN] Mroonga 8.00 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 8.00 has been released! This is a major version up! But It keeps backward compatibility. You can upgrade to 8.0.0 without rebuilding database. Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage

ANN: Upscene releases Database Workbench 5.4.0

Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.0 " This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases included a

MySQL Connector/Python 8.0.6-rc has been released

Dear MySQL users, MySQL Connector/Python 8.0.6-rc is the first release candidate version of the MySQL Connector Python 8.0 series. This series adds support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document

MySQL Cluster 7.6.4-dmr has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides:   - In-Memory storage - Real-time performance (with optional     checkpointing to disk)   - Transparent Auto-Sharding - Read & write scalability   - Active-Active/Multi-Master

MySQL Connector/Java 8.0.9-rc has been released

Dear MySQL users, MySQL Connector/Java 8.0.9-rc is the first Release Candidate of the 8.0 branch of MySQL Connector/J, providing an insight into upcoming features. It is suitable for use with MySQL Server versions 5.5, 5.6, 5.7, and 8.0. It supports the Java Database Connectivity (JDBC) 4.2 API.

MySQL Connector/Net 8.0.10-rc has been released

Dear MySQL users, MySQL Connector/Net 8.0.10 is the first release candidate of MySQL Connector/Net to add support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax

[ANN] Mroonga 7.11 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 7.11 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

Re: Examples of savepoints and transactions

Hello Lars, On 1/24/2018 8:50 AM, Johan De Meersman wrote: What you're looking for is simple backup and restore :-) Savepoints are, simply put, markers within a transaction; allowing you to rollback only part of a transaction instead of the whole thing. A commit will inevitably commit the

Re: Examples of savepoints and transactions

Kind Regards / Med venlig hilsen Lars Nielsen > - Original Message - >> From: "Lars Nielsen" >> To: "MySql" >> Sent: Tuesday, 23 January, 2018 23:19:29 >> Subject: Re: Examples of savepoints and transactions > >>> Den 22-01-2018 kl. 22:01 skrev

Re: Examples of savepoints and transactions

What you're looking for is simple backup and restore :-) Savepoints are, simply put, markers within a transaction; allowing you to rollback only part of a transaction instead of the whole thing. A commit will inevitably commit the ENTIRE transactions, and thus remove the savepoints. A typical

Re: Examples of savepoints and transactions

Den 22-01-2018 kl. 22:01 skrev shawn l.green: Hello Lars, On 1/21/2018 3:37 PM, Lars Nielsen wrote: Hi, I have a system that uses begin and commit transactions. It works like a dream! ;) Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution

MySQL Community Server 8.0.3-rc has been released (part 3/3)

* For builds on 32-bit platforms with Undefined Behavior Sanitizer enabled, a stack-overrun check could cause a server exit. (Bug #27224961) * The server could hang during spatial reference system (SRS) creation while another session was using that SRS. (Bug

MySQL Community Server 8.0.4-rc has been released (part 3/3)

[If you just recived an email with 8.0.3-rc in the title, please ignore that. Sorry for the confusion] * For builds on 32-bit platforms with Undefined Behavior Sanitizer enabled, a stack-overrun check could cause a server exit. (Bug #27224961) * The server could hang

MySQL Community Server 8.0.4-rc has been released (part 2/3)

Bugs Fixed * Important Change: The following changes are made to the PERIOD_ADD() and PERIOD_DIFF() functions: + A period value used with one of these functions may not be negative. + The month part of a period value may not be equal to

MySQL Community Server 8.0.4-rc has been released (part 1/3)

[Due to size limitations, the announcement is split in 3. This is part 1.] MySQL Server 8.0.4-rc (Release Candidate) is a new version of the world's most popular open source database. This is the second release candidate of MySQL 8.0.

MySQL Cluster 7.4.18 has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides:   - In-Memory storage - Real-time performance   - Transparent Auto-Sharding - Read & write scalability   - Active-Active/Multi-Master geographic replication   - 99.999% High

MySQL Cluster 7.4.19 has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides:   - In-Memory storage - Real-time performance   - Transparent Auto-Sharding - Read & write scalability   - Active-Active/Multi-Master geographic replication   - 99.999% High

Re: Examples of savepoints and transactions

Hello Lars, On 1/21/2018 3:37 PM, Lars Nielsen wrote: Hi, I have a system that uses begin and commit transactions. It works like a dream! ;) Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution for rolling back test data is to use savepoints

Examples of savepoints and transactions

Hi, I have a system that uses begin and commit transactions. It works like a dream! ;) Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution for rolling back test data is to use savepoints and rollback. I think it is hard to find examples of this

Re: Can't get my query to return wanted data

On Fri, 19 Jan 2018 11:25:42 -0500, shawn l.green wrote: > Hello Chris, > > On 1/19/2018 12:50 AM, Chris Roy-Smith wrote: >> Hi I am running mysql 5.7.20 in ubuntu linux 17.10 >> >> I have 2 tables, member and status with contents like >> >> member: >> ident, given, surname 1 fred

Re: Can't get my query to return wanted data

Hello Chris, On 1/19/2018 12:50 AM, Chris Roy-Smith wrote: Hi I am running mysql 5.7.20 in ubuntu linux 17.10 I have 2 tables, member and status with contents like member: ident, given, surname 1 fredjones 2 johnhoward 3 henry wales 4 jenny brown status:

Can't get my query to return wanted data

Hi I am running mysql 5.7.20 in ubuntu linux 17.10 I have 2 tables, member and status with contents like member: ident, given, surname 1 fredjones 2 johnhoward 3 henry wales 4 jenny brown status: ident year 1 2017 2 2017 3 2017 4

MySQL Cluster 7.3.20 has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides:   - In-Memory storage - Real-time performance (with optional     checkpointing to disk)   - Transparent Auto-Sharding - Read & write scalability   - Active-Active/Multi-Master

MySQL Cluster 7.5.9 has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides:   - In-Memory storage - Real-time performance (with optional     checkpointing to disk)   - Transparent Auto-Sharding - Read & write scalability   - Active-Active/Multi-Master

MySQL Community Server 5.6.39 has been released

Dear MySQL users, MySQL Server 5.6.39, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.39 is recommended for use on production systems. For an overview of what's new in MySQL 5.6, please see

MySQL Community Server 5.7.21 has been released

Dear MySQL users, MySQL Server 5.7.21, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.21 is recommended for use on production systems. For an overview of what's new in MySQL 5.7, please see

In MySQL 8.0, how does one recognize roles?

Hi, In MySQL 8.0, if you use CREATE ROLE, it seems to create an entry in mysql.users But how does one distinguish between roles and users? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL

[ANN] Mroonga 7.10 - Fast fulltext search for all languages on,MySQL

Hi, Mroonga 7.10 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. * Document: http://mroonga.org/docs/ * How to install:

[ANN] Mroonga 7.09 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 7.09 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

MySQL Workbench 6.3.10 GA has been released

Dear MySQL users, The MySQL developer tools team announces 6.3.10 as our GA release for MySQL Workbench 6.3. For the full list of changes in this revision, visit http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html For discussion, join the MySQL Workbench Forums:

<    1   2   3   4   5   6   7   8   9   10   >