DevHeads.net

Help

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.

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

Download MySQL Workbench 6.3.10 GA now, for Windows, macOS 10.11+,
Oracle Linux 7, Fedora 26 and 27, Ubuntu 16.04 and 17.10
or sources, from:

<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 6.3.10 (2017-11-15)
Bugs Fixed

* Performance

monitoring mysql performance

Hi,

I have a VPS Web server (Apache 2.4/PHP 7.x + Varnish 4.1) running with
MySQL 5.6. I have 20 Gb of RAM. I serve Wordpress sites mainly all using
innodb.

So I´m thinking of ways of improving MySQL performance and of course
for that, you need to measure.

Currently I´m checking, there are no slow queries and read and writes
perform well.

Mroonga 7.07 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.08 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

ANN: Upscene releases Database Workbench 5.3.4

Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool:

" Database Workbench 5.3.4 "

This release includes bugfixes on version 5.3 which included a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and adds several other features.

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

"Version 5 included many new features", says Martijn Tonies, founder of Ups

MySQL Connector/Net 6.9.10 has been released

Dear MySQL users,

MySQL Connector/Net 6.9.10 is a maintenance release for the 6.9.x
series of the .NET driver for MySQL.

ANN: Stored routine debugger Hopper, version 2.0 released

Dear ladies and gentlemen,

Upscene Productions is proud to announce version 2 of "Hopper", a stored
routine debugger for InterBase, Firebird and MySQL.

This version includes support for Firebird 3 packages and stored functions,
MySQL diagnostic-statements, binary data in variables and much more.

For more information, check the Hopper page on this website. <a href="http://www.upscene.com/stored_procedure_debugger/" title="http://www.upscene.com/stored_procedure_debugger/">http://www.upscene.com/stored_procedure_debugger/</a>

About Hopper
Hopper is a stored routine debugging tool for MySQL, Firebird and InterBase.

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

I use a Python program to write text containing Unicode characters to a
MySQL
database.  As an example, two of the characters are

    u'\u2640' a symbol for Venus or female
    u'\u2642' a symbol for Mars or male

I use utf8mb4 for virtually all character sets involved with MySQL.  Here is
an excerpt from /etc/mysql/my.cnf

    [client]
    default-character-set=utf8mb4

    [mysql]
    default-character-set=utf8mb4

    [mysqld]
    character-set-server =utf8mb4

I'm not sure that the [client] option does anything, but it doesn't seem to
hurt.

In addition, all tables are created wi

MySQL Cluster 7.3.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 (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.3.19, has been released and can be downloaded from

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

MySQL Cluster 7.4.17 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 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.4 makes significant advances in performance;
operational efficiency (such as enhanced reporting and faster restarts
and upg

MySQL Cluster 7.5.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.5.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 Community Server 5.6.38 has been released

Dear MySQL users,

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

MySQL Community Server 5.7.20 has been released

Dear MySQL users,

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

Mroonga 7.07 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.07 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

Last established connection timestamp by a specific user

Hi,

We have a MySQL instance which is currently running on version `5.7.11-enterprise-commercial-advanced-log`.

Question about contributing a patch

Hello,I reported a bug, at <a href="https://bugs.mysql.com/bug.php?id=87637" title="https://bugs.mysql.com/bug.php?id=87637">https://bugs.mysql.com/bug.php?id=87637</a>, as well as a patch. And Bogdan, the bug hunter, told me this patch would show up on the dev contribution report. So, could anyone please tell me how to contact dev team, or how can I know the progress about integrating the patch. By the way, I signed Oracle Contributor Agreement.
Any reply would be a great help.
Thanks, sincerely
Xiaoyu

MySQL Shell 8.0.3-dmr has been released

Dear MySQL users,

This is the second development release version of MySQL Shell 8.0
(a component of the MySQL Server). The MySQL Shell is provided under
Oracle's dual-license.

MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server.

MySQL Router 8.0.3-dmr has been released

Dear MySQL users,

MySQL Router 8.0.3 dmr is the first development release for
MySQL Router 8.0 series.

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 applications with high availability requirements
is greatly simplified by MySQL Router.

MySQL Connector/Net 8.0.9-dmr has been released

Dear MySQL users,

MySQL Connector/Net 8.0.9 is the sixth development release that expands
cross-platform support to Linux and macOS when using Microsoft's .NET Core
framework. Now, .NET developers can use the X DevAPI with .NET Core and
Entity Framework Core (EF Core) 1.0 to create server applications that run
on Windows, Linux and macOS. We are very excited about this change and
really look forward to your feedback on it!

MySQL Connector/Net 8.0.9 is also the eighth development release of MySQL
Connector/Net to add support for the new X DevAPI.

MySQL Connector/Java 8.0.8-dmr has been released

Dear MySQL users,

MySQL Connector/J 8.0.8 Development Release is a development milestone
release for the 8.0.x series.

This release includes the following new features and changes, also
described in more detail on

<a href="https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-8.html" title="https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-8.html">https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-8.html</a>

MySQL Connectors and other MySQL client tools and applications now
synchronize the first digit of their version number with the (highest)
MySQL server version they support.
This change makes it easy and intuitive to decide which client version
to use for which server version.

As always, we recommend that you c

MySQL Connector/Python 8.0.5 DMR has been released

Dear MySQL users,

MySQL Connector/Python 8.0.5 dmr is the sixth development release 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 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/" title="http://dev.mysql.com/doc/x-devapi-userguide/en/">http://dev.mysql.com/doc/x-devapi-userguide/en/</a>.

MySQL Connector/C++ 8.0.6-dmr has been released

Dear MySQL users,

MySQL Connector/C++ 8.0.6-dmr is the next development milestone release
(dmr) 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.

A question about Oracle Contributor Agreement

Hi, I signed Oracle Contributor Agreement about a month ago, but have not got a response. I reported a bug, but I can not contribute my patch. So, could anyone please tell me how long will it take before I am informed? Thanks, sincerely

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

[This is part 2 of the announcement]

Bugs Fixed

* Incompatible Change; JSON: If a JSON object contained
multiple members with the same key name, MySQL kept the
first member and discarded the remainder.

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

[Due to size limitations, the announcement is split in 2. This is part 1.]

Dear MySQL users,

MySQL Server 8.0.3-rc (Release Candidate) is a new version of the world's
most popular open source database.

Omit another where clause from original query

I have a working query:

/* start */

SELECT
u.user_id,
u.first_name AS u_first_name,
u.last_name AS u_last_name,
c.client_id AS c_client_id,
c.first_name AS c_first_name,
c.middle_name AS c_middle_name,
c.last_name AS c_last_name,
c.address AS c_address,
c.city AS c_city,
c.state AS c_state,
c.zip AS c_zip,
c.dob AS dob_ymd,
c.phone_home AS c_phone_home,
c.phone_cell AS c_phone_cell,
c.phone_work AS c_phone_work,
c.email AS c_email,
c.other_contacts AS c_other_contacts,
count(*) AS apt_qty

FROM tl_appt apt

JOIN tl_clients c ON c.client_id = apt.client_id
JOIN tl_rooms r

ANN: DAC for MySQL 3.2.0-alpha is out!

MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also
known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct
connect to MySQL database server.

innodb_read_only issues

I've followed the instructions at
<a href="https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html" title="https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html">https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html</a>

Which starts with:

14.6.2 Configuring InnoDB for Read-Only Operation

You can now query InnoDB tables where the MySQL data directory is on
read-only media, by enabling the --innodb-read-only configuration option
at server startup.

Exactly what I want to do.

However the server bails out trying to create files.

2017-09-07T02:12:33.688368Z 0 [Note] InnoDB: Started in read only mode
2017-09-07T02:12:33.688405Z 0 [Note] InnoDB: Mutexes and rw_locks use
GCC atomic builtins
2017-09-07T02:12:3

Mroonga 7.06 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.06 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

MySQL Connector/Python 2.1.7 GA has been released

Dear MySQL users,

MySQL Connector/Python 2.1.7 GA is a fifth GA version of 2.1 release
series of the pure Python database driver for MySQL. It can be used for
production environments.

MySQL Connector/Python version 2.1.7 GA is compatible with MySQL Server
versions 5.5 and greater. Python 2.6 and greater as well as Python 3.4
and greater are supported.

Mroonga 7.05 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.05 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

MySQL Shell 1.0.10 GA has been released

Dear MySQL Users,

A new GA (general availability) version of MySQL Shell
(a component of the MySQL Server) has been made
available: MySQL Shell 1.0.10 GA. The MySQL Shell is provided
under Oracle's dual-license.

MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server.

MySQL Connector/J 5.1.43 has been released

Dear MySQL Users,

MySQL Connector/J 5.1.43, 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
<a href="http://dev.mysql.com/downloads/connector/j/5.1.html" title="http://dev.mysql.com/downloads/connector/j/5.1.html">http://dev.mysql.com/downloads/connector/j/5.1.html</a>
and mirror sites as well as Maven-2 repositories.

MySQL Connector Java (Commercial) is already available for download on the
My Oracle Support (MOS) website.

MySQL Cluster 7.5.7 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.7, 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.3.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 (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.3.18, 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>

MySQL Cluster 7.4.16 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 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.4 makes significant advances in performance;
operational efficiency (such as enhanced reporting and faster restarts
and upg

MySQL Community Server 8.0.2-dmr has been released (part 2/2)

[ This is part 2 of the announcement ]

Logging Notes

* These error-logging changes have been made:

+ The server is now more forgiving if it cannot find
the configured error-message file (specified using
the lc_messages_dir and lc_messages system
variable). Previously, the server aborted the
startup process and exited. Now the server writes a
message to the error log and defaults to built-in
English messages.

MySQL Community Server 8.0.2-dmr has been released (part 1/2)

Dear MySQL users,

[Due to file size limitations, the announcement is split in 2
parts. This is part 1.]

MySQL Server 8.0.2-dmr (Milestone Release) is a new version of the world's
most popular open source database.

MySQL Community Server 5.5.57 has been released

Dear MySQL users,

MySQL Server 5.5.57 is a new version of the 5.5 production release
of the world's most popular open source database. MySQL 5.5.57 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.7.19 has been released

Dear MySQL users,

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

MySQL Connector/Python 8.0.4-dmr has been released

Dear MySQL users,

MySQL Connector/Python 8.0.4 dmr is the fifth development release 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 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/" title="http://dev.mysql.com/doc/x-devapi-userguide/en/">http://dev.mysql.com/doc/x-devapi-userguide/en/</a>.

MySQL Shell 8.0.0-dmr has been released

Dear MySQL users,

This is the first development release version of MySQL Shell 8.0
(a component of the MySQL Server). The MySQL Shell is provided under
Oracle's dual-license.

MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server.

MySQL Connector/Net 8.0.8-dmr has been released

Dear MySQL users,

MySQL Connector/Net 8.0.8 is the fifth development release that expands
cross-platform support to Linux and macOS when using Microsoft's .NET Core
framework. Now, .NET developers can use the X DevAPI with .NET Core and
Entity Framework Core (EF Core) 1.0 to create server applications that run
on Windows, Linux and macOS. We are very excited about this change and
really look forward to your feedback on it!

MySQL Connector/Net 8.0.8 is also the seventh development release of MySQL
Connector/Net to add support for the new X DevAPI.

MySQL Connector/Java 8.0.7-dmr has been released

Dear MySQL users,

MySQL Connector/J 8.0.7 Development Release is a development milestone
release for the 8.0.x series.
This release includes the following new features and changes, also described
in more detail on
<a href="https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-7.html" title="https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-7.html">https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-7.html</a>

MySQL Connectors and other MySQL client tools and applications now
synchronize the first digit of their version number with the (highest)
MySQL server version they support.
This change makes it easy and intuitive to decide which client version
to use for which server version.

Connector/J 8.0.7 is the first relea

MySQL Connector/C++ 8.0.5-dmr has been released

Dear MySQL users,

MySQL Connector/C++ 8.0.5-dmr is the next development milestone
release of the MySQL Connector/C++ 8.0 series (formely 2.0 series).

Connector/C++ 8.0 can be used to access MySQL implementing Document
Store or in a traditional way, using SQL queries.

Upscene releases Database Workbench 5.3.2

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

“ Database Workbench 5.3.2 “

This release includes bugfixes on version 5.3 which included a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and adds several other features.

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

"Version 5 included many new features", says Martijn Tonies, founder of Up

Mroonga 7.04 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.04 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

Re: Something strange here...

2017/06/13 17:42 ... Chris Knipe:

Performance degradation after drop table

Hello list,

I come here with a case I can say very strange.

I explain, we have a db server with mysql version 5.5.49 on debian
jessie. Some
days ago, our workflow allowed us to purge a large table from one of our
db
servers. By large I mean a table which had 350GB in size.

To purge that table, I displayed the table configuration (show create
table
tblname), then dropped that table and recreated it with the informations
from
the show create table command.

QxOrm 1.4.4 and QxEntityEditor 1.2.2 released : boost dependency fully removed (replaced by C++11 features)

Hello,

*QxOrm library 1.4.4* and *QxEntityEditor application 1.2.2* just released (
<a href="http://www.qxorm.com/" title="http://www.qxorm.com/">http://www.qxorm.com/</a>) !

QxOrm library doesn't depend on boost framework anymore (the boost
dependency has been fully removed, replaced by some C++11 features).
So QxOrm library is now a pure Qt library which depends only on QtCore and
QtSql by default.
For backward compatibility, QxOrm library still supports some boost classes
(boost smart-pointers, unordered containers, boost::optional, etc...) : you
have to define _QX_ENABLE_BOOST compilation option to enable these features.

Main advantages are :
- QxOrm

Mroonga 7.03 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.03 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

Which choice of mysql??

I am learning Java and I'd like to use MySQL to create, delete and
update databases using Java. I have done this with C++ SQLite, but now,
as I said, I want to port my code to Java [not easy for a Java nubby].
However, the MySQL installer [mysql-installer-web-community-5.7.18.1]
has several choices of which I am not familiar. I don't use MS-Office at
all, I use OpenOffice, so, when at the "Choosing a Setup Type" window,
'Developer Default' requires some MS products I do not have.

MySQL for Excel 1.3.7 has been released

Dear MySQL users,

The MySQL Windows Experience Team is proud to announce the
release of MySQL for Excel version 1.3.7. This is a maintenance
release for 1.3.x. It can be used for production environments.

MySQL for Excel is an application plug-in enabling data analysts
to very easily access and manipulate MySQL data within Microsoft
Excel.

restore from Mysql Administrator

I have an SQL file from a Mysql Administrator backup. Database and tables are
encoded in latin1, but the sql file is encoded in utf-8. Fine so far.

However, some varchars have been hexdumped, and strings have been converted to
utf-8 before these hexdumps.

mysqld_multi

I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to replace an aging 5.1 system running on RHEL 5. We run mysqld_multi with multiple instances, each database on its own TCP Port 33xx. I'm having trouble creating a database on the new server in a multi environment.

Can anyone provide a simple example of how to edit /etc/my.cnf file and command line steps necessary for creating a new database running on, for example, port 3311?

Thanks in advance.

matthew

Network throughput for mysql replication

Hi Guys

I am once again having a weird issue...

MySQL Connector/C++ 1.1.9 has been released

Dear MySQL Users,

A new GA (general availability) version of MySQL Connector/C++ has
been made available: MySQL Connector/C++ 1.1.9 GA. The MySQL
Connector/C++ provides a C++ API for connecting client applications to
the MySQL Server 5.5 or newer.

You can download the production release at:

<a href="http://dev.mysql.com/downloads/connector/cpp/1.1.html" title="http://dev.mysql.com/downloads/connector/cpp/1.1.html">http://dev.mysql.com/downloads/connector/cpp/1.1.html</a>

MySQL Connector C++ (Commercial) will be available for download on the
My Oracle Support (MOS) website.

Ssd vs mix of ssd and spinning disk

Hello,
We have traditionally setup our mysql database servers with a mix of ssd and spinning disk drives.

We use the ssd drives (Raid-1) for the mysql tablespace data, and we use the spinning disks (15 sas in Raid-1) for the index data, etc.

I am wondering if going forward we should simply put all of the data on the ssd drives.

tcmalloc mysql 5.7.14

Hi Guys

I hope this mail finds everyone well.

We are having an issue with memory allocations on mysql 5.7.14 whereby
mysql is not releasing the memory that is being allocated during
mysqldump processes.

This has been logged as a bug with mysql dev team however they do not
see this as a bug and suggested we test using another malloc library
such as tcmalloc.

However from what I can see, this is no longer included in mysql 5.7
and thus I am trying to find out if anyone can tell me how to enable /
install this and how to tell mysql to use this library.

I need to do some tes

Error 1837

Hi,

On a fresh new master-slave very simple setup with just a Magento 1.5 DB
under MySQL 5.6.35, I'm getting this error with a memory table:

2017-05-03 07:08:37 1109 [Note] Slave I/O thread: connected to master
' ... at 10 dot 0.15.183:3306',replication started in log 'FIRST' at
position 4
2017-05-03 11:38:18 1109 [ERROR] Slave SQL: Error 'When
@@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a
different value after a COMMIT or ROLLBACK. Please check GTID_NEXT
variable manual page for detailed explanation.

Syndicate content