MySQL Connector/ODBC 5.3.13 has been released

2019-04-29 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 5.3.13, 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 Cluster 7.6.10 has been released

2019-04-27 Thread Lars Tangvald
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.24 has been released

2019-04-26 Thread Hery Ramilison
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: Assistance with trigger

2019-04-26 Thread Machiel Richards
Please ignore my request as I have managed to figure this out. Thank you. had to rewrite the insert to use Old.Column1... etc... and that works quite well. From: Machiel Richards Sent: Friday, 26 April 2019 10:48 AM To: mysql@lists.mysql.com Subject:

Assistance with trigger

2019-04-26 Thread Machiel Richards
Hi All I am hoping this email finds all well. I would like to request some assistance with a MySQL trigger please. We need to implement a trigger that will in short terms make a backup of a row before it gets deleted. so we have tableA and TableB (backup table). I added a

MySQL Connector/ODBC 8.0.16 has been released

2019-04-25 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 8.0.16 is a new version in the MySQL Connector/ODBC 8.0 series, the ODBC driver for the MySQL Server. 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

MySQL Connector/Node.js 8.0.16 has been released

2019-04-25 Thread Gipson Pulla
Dear MySQL users, MySQL Connector/Node.js is a new Node.js driver for use with the X DevAPI. This release, v8.0.16, 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 Community Server 5.6.44 has been released

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

MySQL Connector/NET 8.0.16 has been released

2019-04-25 Thread Surabhi Bhat
Dear MySQL users, MySQL Connector/NET 8.0.16 is the fourth version to support Entity Framework Core 2.1 and the sixth general availability release of MySQL Connector/NET to add support for the new X DevAPI, which enables application developers to write code that combines the strengths of the

MySQL Community Server 5.7.26 has been released

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

MySQL Workbench 8.0.16 has been released

2019-04-25 Thread Balasubramanian Kandasamy
Dear MySQL users, The MySQL developer tools team announces 8.0.16 as our general available (GA) for MySQL Workbench 8.0. For the full list of changes in this revision, visit http://dev.mysql.com/doc/relnotes/workbench/en/news-8-0.html

MySQL Connector/Python 8.0.16 has been released

2019-04-25 Thread Balasubramanian Kandasamy
Dear MySQL users, MySQL Connector/Python 8.0.16 is the latest GA release version of the MySQL Connector Python 8.0 series. 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 that does not

MySQL Enterprise Backup 8.0.16 has been released

2019-04-25 Thread Bjorn Munch
MySQL Enterprise Backup 8.0.16, 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 Backup is a commercial

MySQL Router 8.0.16 for MySQL Server 8.0 and 5.7 has been released

2019-04-25 Thread Bjorn Munch
Dear MySQL users, MySQL Router 8.0.16 is a new release for MySQL Router 8.0 series. MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Router 8.0.16. The MySQL Router is a new building block for high availability solutions based on MySQL InnoDB

MySQL Community Server 8.0.16 has been released [part 2]

2019-04-25 Thread Bjorn Munch
[This is part 2 of the announcement] Bugs Fixed, continued * InnoDB: Write-ahead did not work as expected due to an incorrectly initialized variable. Thanks to Yuhui Wang for the contribution. (Bug #29028838, Bug #93442) * InnoDB: The base column information for a

MySQL Community Server 8.0.16 has been released [part 1]

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

Re: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?

2019-04-17 Thread shawn l.green
Hello, On 4/17/2019 10:29 AM, Turritopsis Dohrnii Teo En Ming wrote: Subject/Topic: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap? Good evening from Singapore, Our customer (company name is Confidential/not disclosed) reported that their MySQL

How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?

2019-04-17 Thread Turritopsis Dohrnii Teo En Ming
Subject/Topic: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap? Good evening from Singapore, Our customer (company name is Confidential/not disclosed) reported that their MySQL database has been found missing or was deleted a few times. They are using

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

2019-03-28 Thread Kentaro Hayashi
Hi, Mroonga 9.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: Replication and user privileges

2019-02-26 Thread Jim
On 2/26/2019 1:57 PM, Jim wrote: On 2/26/2019 9:44 AM, shawn l.green wrote: Hello Jim, On 2/25/2019 7:29 PM, Jim wrote: On 2/25/2019 5:46 PM, shawn l.green wrote: Hello Jim, On 2/25/2019 5:04 PM, Jim wrote: I have a question about mysql replication. I believe I understand most of it, but

Re: Replication and user privileges

2019-02-26 Thread Jim
On 2/26/2019 9:44 AM, shawn l.green wrote: Hello Jim, On 2/25/2019 7:29 PM, Jim wrote: On 2/25/2019 5:46 PM, shawn l.green wrote: Hello Jim, On 2/25/2019 5:04 PM, Jim wrote: I have a question about mysql replication. I believe I understand most of it, but have a question about user

Re: Replication and user privileges

2019-02-26 Thread shawn l.green
Hello Jim, On 2/25/2019 7:29 PM, Jim wrote: On 2/25/2019 5:46 PM, shawn l.green wrote: Hello Jim, On 2/25/2019 5:04 PM, Jim wrote: I have a question about mysql replication. I believe I understand most of it, but have a question about user privileges. I understand on the master, the

ANN: Upscene releases Database Workbench 5.6.0

2019-02-26 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: “ Database Workbench 5.6.0 " This new release brings you the Command Line Data Pump & Favorites feature (Pro Edition) and a few important bugfixes. Version 5.5 brought you

Re: Replication and user privileges

2019-02-25 Thread Jim
On 2/25/2019 5:46 PM, shawn l.green wrote: Hello Jim, On 2/25/2019 5:04 PM, Jim wrote: I have a question about mysql replication. I believe I understand most of it, but have a question about user privileges. I understand on the master, the replication user must have the Repl_slave_priv

Re: Replication and user privileges

2019-02-25 Thread shawn l.green
Hello Jim, On 2/25/2019 5:04 PM, Jim wrote: I have a question about mysql replication. I believe I understand most of it, but have a question about user privileges. I understand on the master, the replication user must have the Repl_slave_priv privilege as described here:

Replication and user privileges

2019-02-25 Thread Jim
I have a question about mysql replication. I believe I understand most of it, but have a question about user privileges. I understand on the master, the replication user must have the Repl_slave_priv privilege as described here:

MySQL Enterprise Backup 3.12.4 has been released

2019-02-15 Thread Surabhi Bhat
Dear MySQL users, MySQL Enterprise Backup v3.12.4, 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

Re: mysql V 8.0.12 and mysqdump

2019-02-14 Thread Walter Harms
> Halaasz Saandor hat am 9. Februar 2019 um 10:01 geschrieben: > > > 2019/02/08 10:32 ... Walter Harms: > > Hello list, > > i run into an unexpected problem with mysqldump: > > > > mysqldump --version > > mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL) > > > > > >

Re: mysql V 8.0.12 and mysqdump

2019-02-09 Thread Walter Harms
> Halaasz Saandor hat am 9. Februar 2019 um 10:01 geschrieben: > > > 2019/02/08 10:32 ... Walter Harms: > > Hello list, > > i run into an unexpected problem with mysqldump: > > > > mysqldump --version > > mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL) > > > > > >

Re: mysql V 8.0.12 and mysqdump

2019-02-09 Thread Halaasz Saandor
2019/02/08 10:32 ... Walter Harms: Hello list, i run into an unexpected problem with mysqldump: mysqldump --version mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL) when i try it results in: mysqldump: Error: 'Lost connection to MySQL server during query' when trying

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

2019-02-08 Thread Horimoto Yasuhiro
Hi, Mroonga 9.00 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 V 8.0.12 and mysqdump

2019-02-08 Thread Walter Harms
Hello list, i run into an unexpected problem with mysqldump: mysqldump --version mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL) when i try it results in: mysqldump: Error: 'Lost connection to MySQL server during query' when trying to dump tablespaces mysqldump:

MySQL Enterprise Backup 8.0.15 has been released

2019-02-01 Thread Bjorn Munch
Dear MySQL users, MySQL Enterprise Backup 8.0.15, 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 Backup

MySQL Router 8.0.15 for MySQL Server 8.0 and 5.7 has been released

2019-02-01 Thread Bjorn Munch
Dear MySQL users, MySQL Router 8.0.15 is a new release for MySQL Router 8.0 series. MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Router 8.0.15. The MySQL Router is a new building block for high availability solutions based on MySQL InnoDB

MySQL Connector/Node.js 8.0.15 has been released

2019-02-01 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/Node.js is a new Node.js driver for use with the X DevAPI. This release, v8.0.15, 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/J 8.0.15 has been released

2019-02-01 Thread Gipson Pulla
Dear MySQL users, MySQL Connector/J Version 8.0.15 is the GA release of the 8.0 branch of MySQL Connector/J. It is suitable for use with MySQL Server versions 8.0, 5.7, 5.6, and 5.5. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. This release includes the

MySQL Workbench 8.0.15 has been released

2019-02-01 Thread Prashant Tekriwal
Dear MySQL users, The MySQL developer tools team announces 8.0.15 as our general available (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 Forums:

MySQL Connector/NET 8.0.15 has been released

2019-02-01 Thread Surabhi Bhat
Dear MySQL users, MySQL Connector/NET 8.0.15 is the third version to support Entity Framework Core 2.1 and the fifth general availability release of MySQL Connector/NET to add support for the new X DevAPI, which enables application developers to write code that combines the strengths of the

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

2019-02-01 Thread Balasubramanian Kandasamy
Dear MySQL users, MySQL Shell 8.0.15 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.15.

MySQL Community Server 8.0.15 has been released

2019-02-01 Thread Bjorn Munch
Dear MySQL users, MySQL Server 8.0.15, a new version of the popular Open Source Database Management System, has been released. MySQL 8.0.15 is recommended for use on production systems. For an overview of what's new in MySQL 8.0, please see

MySQL Connector/ODBC 5.3.12 has been released

2019-01-27 Thread Balasubramanian Kandasamy
Dear MySQL users, MySQL Connector/ODBC 5.3.12, 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 Cluster 7.6.9 has been released

2019-01-22 Thread Lars Tangvald
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.13 has been released

2019-01-22 Thread Prashant Tekriwal
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.13 has been released

2019-01-22 Thread Prashant Tekriwal
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/C++ 8.0.14 has been released

2019-01-21 Thread Kent Boortz
Dear MySQL users, MySQL Connector/C++ 8.0.14 is a new 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 DevAPI

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

2019-01-21 Thread Kent Boortz
Dear MySQL users, MySQL Shell 8.0.14 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.14.

MySQL Community Server 5.7.25 has been released

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

MySQL Workbench 8.0.14 has been released

2019-01-21 Thread daniel . horecki
Dear MySQL users, The MySQL developer tools team announces 8.0.14 as our general available (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 Forums:

MySQL Connector/NET 8.0.14 has been released

2019-01-21 Thread Surabhi Bhat
Dear MySQL users, MySQL Connector/NET 8.0.14 is the second version to support Entity Framework Core 2.1 and the fourth general availability release of MySQL Connector/NET to add support for the new XDevAPI, which enables application developers to write code that combines the strengths of the

MySQL Connector/J 8.0.14 has been released

2019-01-21 Thread daniel . horecki
Dear MySQL users, MySQL Connector/J Version 8.0.14 is the GA release of the 8.0 branch of MySQL Connector/J. It is suitable for use with MySQL Server versions 8.0, 5.7, 5.6, and 5.5. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. This release includes

MySQL Connector/ODBC 8.0.14 has been released

2019-01-21 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 8.0.14 is a new version in the MySQL Connector/ODBC 8.0 series, the ODBC driver for the MySQL Server. 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

MySQL Enterprise Backup 8.0.14 has been released

2019-01-21 Thread Bjorn Munch
MySQL Enterprise Backup 8.0.14, 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 Backup is a commercial

MySQL Router 8.0.14 for MySQL Server 8.0 and 5.7 has been released

2019-01-21 Thread Bjorn Munch
Dear MySQL users, MySQL Router 8.0.14 is a new release for MySQL Router 8.0 series. MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Router 8.0.14. The MySQL Router is a new building block for high availability solutions based on MySQL InnoDB

MySQL Connector/Node.js 8.0.14 has been released

2019-01-21 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/Node.js is a new Node.js driver for use with the X DevAPI. This release, v8.0.14, 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 Community Server 8.0.14 has been released (part 2/2)

2019-01-21 Thread Bjorn Munch
[This is part 2 of the announcement] Bugs Fixed * Important Change: Importing a dump from a MySQL 5.7 server to a server running MySQL 8.0 often failed with ER_WRONG_VALUE_FOR_VAR when an SQL mode not supported by the 8.0 server was used. This could happen frequently

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

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

MySQL Community Server 5.6.43 has been released

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

ANN: Database Workbench 5.5.0 released and free Lite Edition for MySQL

2019-01-15 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.5.0 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.5.0 " This new release brings you support for the latest versions of supported database systems, that

Full text search not matching 2 letter word

2019-01-08 Thread Andrew Wood
Im trying to run a full text query on a two letter keyword 'K7'. I have set ft_min_word_len=2 and restarted the server and if I view the system vars in Mysql Workbench it shows it is set correctly. I have then dropped and re-created the index on the descrip column. It is an InnoDB table so I

MySQL Cluster Manager 1.4.7 has been released

2018-12-14 Thread Surabhi Bhat
Dear MySQL Users, MySQL Cluster Manager 1.4.7 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

Re: undiscribe

2018-12-02 Thread Reindl Harald
WTF look at the "List-Unsubscribe:" header in every list message and say thanks to fools using DMARC enabled domains on mailing-lists resulting in list footers are removd everywhere no mailing list unsubsribe on planet earth works that way spam every subscriber, you got a welcome message as you

undiscribe

2018-12-02 Thread 高强
| undiscribe -- Eric Gao Keep on going never give up. Blog: http://gaoqiangdba.blog.163.com/ http://gaoqiang.blog.chinaunix.net/ | | | | | |

Re: [ANN] Mroonga 8.09 - Fast fulltext search for all languages on MySQL

2018-11-28 Thread Horimoto Yasuhiro
Hi, Sorry, There was wrong release information in Mroonga 8.09. The MySQL 8 is not supported. That is still being handled. On 2018/11/29 14:12, Horimoto Yasuhiro wrote: > Hi, > > Mroonga 8.09 has been released! > > Mroonga is a MySQL storage engine that supports fast fulltext search > and

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

2018-11-28 Thread Horimoto Yasuhiro
Hi, Mroonga 8.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

Re: Estimate mysqldump size

2018-11-28 Thread Olivier
Ronan McGlue writes: > Hi Olivier, > > On 28/11/2018 8:00 pm, Olivier wrote: >> Hello, >> >> Is there a way that gives an estimate of the size of a mysqldump such a >> way that it would always be larger than the real size? >> >> So far, I have found: >> >> mysql -s -u root -e "SELECT

Re: Estimate mysqldump size

2018-11-28 Thread Olivier
Ronan McGlue writes: > Hi Olivier, > > On 28/11/2018 8:00 pm, Olivier wrote: >> Hello, >> >> Is there a way that gives an estimate of the size of a mysqldump such a >> way that it would always be larger than the real size? >> >> So far, I have found: >> >> mysql -s -u root -e "SELECT

Re: Estimate mysqldump size

2018-11-28 Thread Reindl Harald
Am 28.11.18 um 10:00 schrieb Olivier: > Is there a way that gives an estimate of the size of a mysqldump such a > way that it would always be larger than the real size? keep in mind that a dump has tons of sql statements not existing that way in the data -- MySQL General Mailing List For list

Re: Estimate mysqldump size

2018-11-28 Thread Ronan McGlue
Hi Olivier, On 28/11/2018 8:00 pm, Olivier wrote: Hello, Is there a way that gives an estimate of the size of a mysqldump such a way that it would always be larger than the real size? So far, I have found: mysql -s -u root -e "SELECT SUM(data_length) Data_BB FROM

Estimate mysqldump size

2018-11-28 Thread Olivier
Hello, Is there a way that gives an estimate of the size of a mysqldump such a way that it would always be larger than the real size? So far, I have found: mysql -s -u root -e "SELECT SUM(data_length) Data_BB FROM information_schema.tables WHERE table_schema NOT IN

MySQL Encryption-at-rest capability

2018-11-14 Thread Venkata Nagothi
Hi MySQL Community, Greetings ! I have a query regarding encryption-at-rest feature in MySQL Community Edition - What i understand is that Encryption-at-rest is supported from MySQL-5.7.11 community edition and only on file-per-table basis which means encryption at table-level can be

Re: Connections from mysql8.0 to mysql5.1 - bad handshake

2018-11-01 Thread shawn l.green
Hi Jim, On 10/31/2018 7:12 PM, Halaasz Saandor wrote: 2018/10/31 15:15 ... Jim: Given the following bug report, what I am trying to do does not sound hopeful: https://bugs.mysql.com/bug.php?id=90994 ... Any thoughts or do I need to accept that what I'm attempting just isn't going to work?

Re: Connections from mysql8.0 to mysql5.1 - bad handshake

2018-10-31 Thread Halaasz Saandor
2018/10/31 15:15 ... Jim: Given the following bug report, what I am trying to do does not sound hopeful: https://bugs.mysql.com/bug.php?id=90994 ... Any thoughts or do I need to accept that what I'm attempting just isn't going to work? From the same bug report, id=90994: [24 Oct 20:17]

Connections from mysql8.0 to mysql5.1 - bad handshake

2018-10-31 Thread Jim
I'm trying to configure replication of a mysql5.1 database master server to a mysql8.0 database server. But the replication connection will not succeed. I don't believe the issue is directly related to replication, because any connection attempt from mysql8.0 to mysql5.1 fails as follows. As

In MySQL 8, how do you distinguish between Roles and Users in table mysql.user?

2018-10-30 Thread Martijn Tonies (Upscene Productions)
Hi there, In MySQL 8, how can you figure out if an entry in the mysql.user table is a role or a user? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and

Re: High cpu usage

2018-10-26 Thread shawn l.green
Hello Machiel, (I am guessing you can only process top-posts?) When you stop only the IO thread, you may leave the last event recorded to the Relay Log incomplete. When it gets to that part of the Relay Log, the SQL thread may only be part-way through a transaction. It will keep that

Re: High cpu usage

2018-10-26 Thread Machiel Richards
Hi Shawn Thank you for the response. In order to pause the slave , the stop the sql_io_thread, and to unpause they simply start the thread. I have run "show engine innodb status" yes and the threads show 90% as sleeping and then a few selects , all from the same table as it

Re: High cpu usage

2018-10-25 Thread shawn l.green
Hello Machiel, On 10/25/2018 6:09 AM, Machiel Richards wrote: Good day all Hoping this mail finds you well. I am hoping someone can perhaps give us some guidance here as we now seem to be stuck on a problem and have not been able to find a solution after more than a month.

High cpu usage

2018-10-25 Thread Machiel Richards
Good day all Hoping this mail finds you well. I am hoping someone can perhaps give us some guidance here as we now seem to be stuck on a problem and have not been able to find a solution after more than a month. We are running an opensips server on Centos 6.5 , using mysql 5.7.13

MySQL Cluster 7.6.8 has been released

2018-10-23 Thread Lars Tangvald
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 8.0.13-dmr has been released

2018-10-23 Thread Balasubramanian Kandasamy
Dear MySQL Users, MySQL Cluster is the distributed database combining massive scalability and high availability. It provides in-memory real-time access with transactional consistency across partitioned and distributed datasets. It is designed for mission critical applications. MySQL Cluster

MySQL Cluster 7.5.12 has been released

2018-10-23 Thread Prashant Tekriwal
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

ANN: Upscene releases Database Workbench 5.4.6

2018-10-23 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.4.6 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: “ Database Workbench 5.4.6 " This is a bugfix release, previous releases included support for MariaDB 10.1 and 10.2, MySQL 5.7 and

MySQL Connector/NET 8.0.13 has been released

2018-10-22 Thread Surabhi Bhat
Dear MySQL users, MySQL Connector/NET 8.0.13 is the first version to support Entity Framework Core 2.1 and the third general availability release of MySQL Connector/NET to add support for the new X DevAPI,which enables application developers to write code that combines the strengths of the

MySQL Community Server 5.5.62 has been released

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

MySQL Workbench 8.0.13 has been released

2018-10-22 Thread daniel . horecki
Dear MySQL users, The MySQL developer tools team announces 8.0.13 as our general available (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 Forums:

MySQL Community Server 5.6.42 has been released

2018-10-22 Thread Surabhi Bhat
Dear MySQL users, MySQL Server 5.6.42, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.42 is recommended for use on production systems.    This release also incorporates all bug fixes and changes made in    previous NDB Cluster releases, as well

Benetl, a free ETL tool for MySQL, out in version 4.9

2018-10-22 Thread Benoît Carpentier
Dear all, Benetl, a free ETL tool for MySQL, is out in version 4.9. This new version is providing some code optimizations, tests coverage improvement. This version supports Java 1.8 and providesone bug correction (dist function now returns result as double type). You should really update.

MySQL Connector/Node.js 8.0.13 has been released

2018-10-22 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/Node.js is a new Node.js driver for use with the X DevAPI. This release, v8.0.13, 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 Community Server 5.7.24 has been released

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

MySQL Connector/ODBC 8.0.13 has been released

2018-10-22 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 8.0.13 is a new version in the MySQL Connector/ODBC 8.0 series, the ODBC driver for the MySQL Server. 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 Router 8.0.13 for MySQL Server 8.0 and 5.7 has been released

2018-10-22 Thread Bjorn Munch
Dear MySQL users, MySQL Router 8.0.13 is a new release for MySQL Router 8.0 series. MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Router 8.0.13. The MySQL Router is a new building block for high availability solutions based on MySQL InnoDB

MySQL Enterprise Backup 8.0.13 has been released

2018-10-22 Thread Bjorn Munch
Dear MySQL users, MySQL Enterprise Backup 8.0.13, 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.13 has been released (part 2/2)

2018-10-22 Thread Bjorn Munch
[This is part 2 of the announcement] Bugs Fixed * Important Note: The libevent library included with the MySQL Server was upgraded to version 2.1.8. (Bug #28207237) * InnoDB; Partitioning: Removed old InnoDB handler and partitioning code that referenced .frm

MySQL Connector/C++ 8.0.13 has been released

2018-10-22 Thread Balasubramanian Kandasamy
Dear MySQL users, MySQL Connector/C++ 8.0.13 is a new 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 DevAPI

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

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

Step-by-Step Tutorial: How to Setup Your Own e-Commerce Online Store using WooCommerce 3.4.5, Wordpress 4.9.8, and CentOS 1805 (LAMP) in Amazon AWS Cloud

2018-09-28 Thread Turritopsis Dohrnii Teo En Ming
Good morning from Singapore, You can read my step-by-step tutorial on How to Setup Your Own e-Commerce Online Store using WooCommerce 3.4.5, Wordpress 4.9.8, and CentOS 1805 (LAMP) in Amazon AWS Cloud at any one of my two redundant blogs. My blogs were configured in RAID 1 mirroring array.

Re: info on open tables

2018-09-28 Thread Halaasz Saandor
2018/09/28 07:48 ... Machiel Richards: During the times when it experiences issues, I found that there is always about 4-5 processes on mysql that gets stuck on "closing table" state and once the software (opensips) is restarted due to a sigfault, then these queries are killed as well.

info on open tables

2018-09-28 Thread Machiel Richards
Hi all I am hoping this mail finds all well. I have a question about mysql open tables and open_table_cache which I do not seem to be finding the answer to on the internet. We are busy investigating an issue on a server where we have erattic behaviour. During the times

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

2018-09-28 Thread Masafumi Yokoyama
Hi, Mroonga 8.07 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

[ANN] [Qt ORM] QxOrm 1.4.5 and QxEntityEditor 1.2.3 released : support MongoDB database and code source now on GitHub

2018-09-06 Thread QxOrm contact
Hello, *QxOrm library 1.4.5* and *QxEntityEditor application 1.2.3* just released : https://www.qxorm.com/ *QxOrm library 1.4.5 changes log :* * - Support MongoDB database : QxOrm library becomes a C++/Qt Object Document Mapper ODM library !- For more details about MongoDB integration, see

  1   2   3   4   5   6   7   8   9   10   >