DevHeads.net

Help

ANN: Upscene releases Database Workbench 5.6.0

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.

Replication and user privileges

I have a question about mysql replication.

MySQL Enterprise Backup 3.12.4 has been released

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.

Mroonga 9.00 - Fast fulltext search for all languages on MySQL

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.

mysql V 8.0.12 and mysqdump

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: Couldn't execute 'SHOW VARIABLES LIKE 'ndbinfo\_version'': MySQL
server has gone away (2006)

I seems it get stuck in this query:

explain SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE,
ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE
_TYPE = 'UNDO LOG' AND FILE_NAME IS NOT NULL A

MySQL Enterprise Backup 8.0.15 has been released

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 is a commercial
extension to the MySQL family of products.

MySQL Enterprise Backup 8.0.15 supports only the MySQL Server 8.0.15.
For earlier versions of MySQL 8.0, use the MySQL Enterprise Backup
version with the same version number as the server.

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

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 clusters.

By taking advantage of the new Group Replication technology, and
combined with the MySQL Shell, InnoDB clusters provide an integrated
solution for high availability and scalability for InnoDB based MySQL
databases, that does not require advanced MySQL expertise.

The deployment of applicat

MySQL Connector/Node.js 8.0.15 has been released

Dear MySQL users,

MySQL Connector/Node.js is a new Node.js driver for use with the X
DevAPI.

MySQL Connector/J 8.0.15 has been released

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.

MySQL Workbench 8.0.15 has been released

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
<a href="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html" title="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html">http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html</a>

For discussion, join the MySQL Workbench Forums:
<a href="http://forums.mysql.com/index.php?152" title="http://forums.mysql.com/index.php?152">http://forums.mysql.com/index.php?152</a>

The release is now available in source and binary form for a number of
platforms from our download pages at:

<a href="http://dev.mysql.com/downloads/tools/workbench/" title="http://dev.mysql.com/downloads/tools/workbench/">http://dev.mysql.com/downloads/tools/workbench/</a>

Enjoy!

Changes in MySQL Workbench 8.0.15 (2019-02-01, General
Availability)

   This release contains no fun

MySQL Connector/NET 8.0.15 has been released

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 relational and document models using a modern,
NoSQL-like syntax that does not assume previous experience writing
traditional SQL.

To learn more about how to write applications using the X DevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html" title="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html">http://dev.mysql.com/doc/x-devapi-userguide/en/index.html</a>.

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

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 Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server.

MySQL Community Server 8.0.15 has been released

Dear MySQL users,

MySQL Server 8.0.15, a new version of the popular Open Source
Database Management System, has been released.

MySQL Connector/ODBC 5.3.12 has been released

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 on the type of your application - Unicode or ANSI.
Server-side prepared statements are enabled by default. It is suitable
for use with any MySQL version from 5.5.

This is the sixth release of the MySQL ODBC driver conforming to the
ODBC 3.8 specification.

MySQL Cluster 7.6.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 geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.6.9 has been released and can be downloaded from

  <a href="http://www.mysql.com/downl" title="http://www.mysql.com/downl">http://www.mysql.com/downl</a>

MySQL Cluster 7.5.13 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 geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.5.13 has been released and can be downloaded from

  <a href="http://www.mysql.com/down" title="http://www.mysql.com/down">http://www.mysql.com/down</a>

MySQL Cluster 7.5.13 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 geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.5.13 has been released and can be downloaded from

  <a href="http://www.mysql.com/down" title="http://www.mysql.com/down">http://www.mysql.com/down</a>

MySQL Connector/C++ 8.0.14 has been released

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.

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

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 Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server.

MySQL Community Server 5.7.25 has been released

Dear MySQL users,

MySQL Server 5.7.25, a new version of the popular Open Source Database
Management System, has been released.

MySQL Workbench 8.0.14 has been released

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
<a href="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html" title="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html">http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html</a>

For discussion, join the MySQL Workbench Forums:
<a href="http://forums.mysql.com/index.php?152" title="http://forums.mysql.com/index.php?152">http://forums.mysql.com/index.php?152</a>

The release is now available in source and binary form for a number
ofplatforms from our download pages at:

<a href="http://dev.mysql.com/downloads/tools/workbench/" title="http://dev.mysql.com/downloads/tools/workbench/">http://dev.mysql.com/downloads/tools/workbench/</a>

Enjoy!

Changes in MySQL Workbench 8.0.14 (2019-01-21, General
Availability)

* Functionality Added or

MySQL Connector/NET 8.0.14 has been released

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 relational and document models using a modern,
NoSQL-like syntax that does not assume previous experience writing
traditional SQL.

To learn more about how to write applications using the XDevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html" title="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html">http://dev.mysql.com/doc/x-devapi-userguide/en/index.html</a>.

MySQL Connector/J 8.0.14 has been released

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.

MySQL Connector/ODBC 8.0.14 has been released

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 based on
the type of your
application - Unicode or ANSI.

MySQL Enterprise Backup 8.0.14 has been released

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
extension to the MySQL family of products.

MySQL Enterprise Backup 8.0.14 supports only the MySQL Server 8.0.14.
For earlier versions of MySQL 8.0, use the MySQL Enterprise Backup
version with the same version number as the server.

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

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 clusters.

By taking advantage of the new Group Replication technology, and
combined with the MySQL Shell, InnoDB clusters provide an integrated
solution for high availability and scalability for InnoDB based MySQL
databases, that does not require advanced MySQL expertise.

The deployment of applicat

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

[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 due
to the fact that NO_AUTO_CREATE_USER is enabled by
default in MySQL 5.7 but not supported in MySQL 8.0.
The behavior of the server in such circumstances now
depends on the setting of the pseudo_slave_mode system
variable.

MySQL Connector/Node.js 8.0.14 has been released

Dear MySQL users,

MySQL Connector/Node.js is a new Node.js driver for use with the X
DevAPI.

MySQL Community Server 8.0.14 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.14, a new version of the popular Open Source
Database Management System, has been released.

MySQL Community Server 5.6.43 has been released

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

<a href="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html" title="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html">http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html</a>

Starting with 5.6.11, Microsoft Windows packages for MySQL 5.6
are available both as a "full" installer and as a "web" installer.
The full installer is significantly larger and comes bundled with
the latest software releases available.

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

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 includes PostgreSQL 11, InterBase 2017 and MySQL 8.

There's also a new release of the free Lite Edition for MySQL: version 5.4.6 has been made available today.

Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you!

Here's the full list of c

Full text search not matching 2 letter word

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 cannot do repair table.

Im running the following query which I expect to match the following
record but it doesnt.

MySQL Cluster Manager 1.4.7 has been released

Dear MySQL Users,

MySQL Cluster Manager 1.4.7 can be downloaded from
the My Oracle Support (MOS) website.

undiscribe

|
undiscribe

Mroonga 8.09 - Fast fulltext search for all languages on MySQL

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.

Estimate mysqldump size

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
('information_schema','performance_schema','mysql');

but the result may be smaller than the real size.

I am writting a program that takes the result of mysqldump and pipe it
in a tar file.

MySQL Encryption-at-rest capability

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 implemented - is that correct ?

Also, if you can help us understand the security compliance requirements (like PCI-DSS etc.) this encryption can satisfy, that would be great. Thanks in advance !

Please confirm !
Regards,
Ven

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

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 run from the mysql8.0 server:
$ mysql -h db5.1server.mydomain.com -u my_user -p
Enter password:
ERROR 1043 (08S01): Bad handshake

Given the following bug report, what I am trying to do does not sound
hopeful:
<a href="https://bugs.mysql.com/bug.php?id=90994" title="https://bugs.mysql.com/bug.php?id=90994">https://bugs.mysql.com/bug.php?id=90994</a>

I'm in the middle of a transition from centos6 to ce

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

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
<a href="http://www.upscene.com" title="http://www.upscene.com">http://www.upscene.com</a>

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

High cpu usage

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 which was installed via Tarball file.

The server is setup as a slave and master and receives updates from opensips config nodes as well as registrations from workers.

Replication is paused during the day and forward replication (master) is disabled at the moment.

However , we are getting

MySQL Cluster 7.6.8 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 geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.6.8, has been released and can be downloaded from

  <a href="http://www.mysql.com/down" title="http://www.mysql.com/down">http://www.mysql.com/down</a>

MySQL Cluster 8.0.13-dmr has been released

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 has replication between clusters across multiple
geographical sites built-in.

MySQL Cluster 7.5.12 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 geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.5.12, has been released and can be downloaded from

  <a href="http://www.mysql.com/dow" title="http://www.mysql.com/dow">http://www.mysql.com/dow</a>

ANN: Upscene releases Database Workbench 5.4.6

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 Azure, a custom report writer, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and several other features.

Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you!

Here's the full list of

MySQL Connector/NET 8.0.13 has been released

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 relational and document models using a modern,
NoSQL-like syntax that does not assume previous experience writing
traditional SQL.

To learn more about how to write applications using the X DevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html" title="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html">http://dev.mysql.com/doc/x-devapi-userguide/en/index.html</a>.

MySQL Community Server 5.5.62 has been released

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 Database, taking advantage of
the latest multi-CPU and multi-core hardware and operating systems.

MySQL Community Server 5.6.42 has been released

Dear MySQL users,

MySQL Server 5.6.42, a new version of the popular Open Source Database
Management System, has been released.

MySQL Connector/Node.js 8.0.13 has been released

Dear MySQL users,

MySQL Connector/Node.js is a new Node.js driver for use with the X
DevAPI.

MySQL Community Server 5.7.24 has been released

Dear MySQL users,

MySQL Server 5.7.24, a new version of the popular Open Source
Database Management System, has been released.

MySQL Connector/ODBC 8.0.13 has been released

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 on the type of your application - Unicode or ANSI.
Server-side prepared statements are enabled by default. It is suitable
for use with any MySQL server version from 5.5.

This release of the MySQL ODBC driver is conforming to the ODBC 3.8
specification.

MySQL Workbench 8.0.13 has been released

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
<a href="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html" title="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html">http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html</a>

For discussion, join the MySQL Workbench Forums:
<a href="http://forums.mysql.com/index.php?152" title="http://forums.mysql.com/index.php?152">http://forums.mysql.com/index.php?152</a>

The release is now available in source and binary form for a number
ofplatforms from our download pages at:

<a href="http://dev.mysql.com/downloads/tools/workbench/" title="http://dev.mysql.com/downloads/tools/workbench/">http://dev.mysql.com/downloads/tools/workbench/</a>

Enjoy!

Changes in MySQL Workbench 8.0.13 (2018-10-22, General Availability)

* Server Support

*

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

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 clusters.

By taking advantage of the new Group Replication technology, and
combined with the MySQL Shell, InnoDB clusters provide an integrated
solution for high availability and scalability for InnoDB based MySQL
databases, that does not require advanced MySQL expertise.

The deployment of applicat

MySQL Enterprise Backup 8.0.13 has been released

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 Backup is a commercial
extension to the MySQL family of products.

MySQL Enterprise Backup 8.0.13 only supports MySQL Server 8.0.13. For
earlier versions of MySQL 8.0, use the MySQL Enterprise Backup version
with the same version number as the server.

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

[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 files, and thus no
longer had any purpose. (Bug #27995316)

* InnoDB: An assertion was raised during a DROP TABLE
operation. A thread that was accessing the table through
the memcached API released metadata locks before
releasing the table.

MySQL Connector/C++ 8.0.13 has been released

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.

MySQL Community Server 8.0.13 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.13, a new version of the popular Open Source
Database Management System, has been released.

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

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.

<a href="https://tdtemcerts.wordpress.com/2018/09/29/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/" title="https://tdtemcerts.wordpress.com/2018/09/29/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/">https://tdtemcerts.wordpress.com/2018/09/29/step-by-step-tutorial-how-to...</a>

<a href="https://tdtemcerts.blogspot.com/2018/09/step-by-step-tutorial-how-to-setup-your.html" title="https://tdtemcerts.blogspot.com/2018/09/step-by-step-tutorial-how-to-setup-your.html">https://tdtemcerts.blogspot.com/2018/09/step-by-step-tutorial-how-to-set...</a>

Thanks for reading!

info on open tables

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 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.

Based on information found we added grafana graphs and did notic

Mroonga 8.07 - Fast fulltext search for all languages on MySQL

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.

QxOrm 1.4.5 and QxEntityEditor 1.2.3 released : support MongoDB database and code source now on GitHub

Hello,

*QxOrm library 1.4.5* and *QxEntityEditor application 1.2.3* just released
: <a href="https://www.qxorm.com/" title="https://www.qxorm.com/">https://www.qxorm.com/</a>

*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 QxOrm manual (<a href="https://www.qxorm.com/qxorm_en/manual.html#manual_95" title="https://www.qxorm.com/qxorm_en/manual.html#manual_95">https://www.qxorm.com/qxorm_en/manual.html#manual_95</a>
<https://www.qxorm.com/qxorm_en/manual.html#manual_95>) and new sample
project available in ./test/qxBlogMongoDB/ directory- QxOrm library is now
available on GitHub (official repository) : <a href="https://github.com/QxOrm/QxOrm" title="https://github.com/QxOrm/QxOrm">https://github.com/QxOrm/QxOrm</a>
<https://github.co

Syndicate content