DevHeads.net

Help

MySQL Cluster 7.6.6 GA has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Paritioning (Sharding) - Read & write scalability
- Transactional consistency across partitioned and distributed datasets
- Parallel cross partition queries such as joins
- Active-Active/Multi-Master geographic replication
- 99.9999% High Availability with on-line maintenance and no single point of
failure
- NoSQL and SQL APIs (including C++, Java

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

Mroonga 8.03 has been released!

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

Document:
<a href="http://mroonga.org/docs/" title="http://mroonga.org/docs/">http://mroonga.org/docs/</a>

How to install: Install Guide
<a href="http://mroonga.org/docs/install.html" title="http://mroonga.org/docs/install.html">http://mroonga.org/docs/install.html</a>

Blog:
<a href="http://mroonga.org/en/blog/2018/05/29/mroonga-8.03.html" title="http://mroonga.org/en/blog/2018/05/29/mroonga-8.03.html">http://mroonga.org/en/blog/2018/05/29/mroonga-8.03.html</a>

Changes:
<a href="http://mroonga.org/docs/news.html#release-8.03" title="http://mroonga.org/docs/news.html#release-8.03">http://mroonga.org/docs/news.html#release-8.03</a>

The main changes are as follows.

MySQL Cluster Manager 1.4.6 has been released

Dear MySQL Users,

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

MySQL for Visual Studio 1.2.8 has been released

Dear MySQL users,

The MySQL Windows Experience Team is proud to announce the release
of MySQL for Visual Studio 1.2.8.

This is a maintenance release for 1.2.x.

Mroonga 8.02 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 8.02 has been released!

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

MySQL Cluster 7.6.5-dmr has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master 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.5-dmr, 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.20 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication
  - 99.999% High 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.10 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master 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.10, 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.3.21 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master 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.21, has been released and can be downloaded from

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

MySQL Connector/Python 8.0.11 has been released

Dear MySQL users,

MySQL Connector/Python 8.0.11 is the first GA release version
of the MySQL Connector Python 8.0 series. This series adds support for
the new X DevAPI. The X DevAPI enables application developers to write
code that combines the strengths of the relational and document models
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/Net 8.0.11 has been released

Dear MySQL users,

MySQL Connector/Net 8.0.11 is the first general availability release of
MySQL Connector/Net to add support for the new X DevAPI. The X DevAPI
enables application developers to write code that combines the strengths
of the relational and document models using a modern, 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 Connector/C++ 8.0.11 GA has been released

Dear MySQL users,

MySQL Connector/C++ 8.0.11 is the first GA release version of the
MySQL Connector/C++ 8.0 series.

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

MySQL Connector/ODBC 8.0.11 GA has been released

Dear MySQL users,

MySQL Connector/ODBC 8.0.11 is the first GA version of the MySQL
Connector/ODBC 8.0 series, the ODBC driver for the MySQL database
management system.

The available downloads include both a Unicode driver and an ANSI
driver based on the same modern codebase. Please select the 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 Community Server 5.6.40 has been released

Dear MySQL users,

MySQL Server 5.6.40, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.6.40 is
recommended for use on production systems.

For an overview of what's new in MySQL 5.6, please see

<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 Workbench 8.0.11-rc has been released

Dear MySQL users,

The MySQL developer tools team announces 8.0.11 as our release candidate (RC) for
MySQL Workbench 8.0.

For the full list of changes in this revision, visit
<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.11 (2018-04-19, Release Candidate)

* Functionality Added or Chang

MySQL Community Server 5.7.22 has been released

Dear MySQL users,

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

MySQL Enterprise Backup 8.0.11 has been released

Dear MySQL users,

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

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

[This is part 2 of the announcement]

     * Replication: A new system variable rpl_read_size is
       available to set the minimum amount of data in bytes that
       is read from the binary log files and relay log files.
       The default read size is 8KB.

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

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

Dear MySQL users,

MySQL Server 8.0.11 (GA) is a new version of the world's
most popular open source database. This is the first official release
of MySQL 8.0.

The new features in this release are now deemed to be of Release quality.

Note that 8.0.11 includes all features in MySQL 5.7 and previous 8.0
Development Milestone Releases.

MySQL optimization for testing purpose

Hi all,

Looking for some configuration tips to speed execution of our non-regression tests with MySQL.

We do pure functional testing, data persistence is not critical.

Our tests are not using a lot of data, but we create and drop a lot of test tables.

We have concurrency tests (processes locking rows), so this feature matters.

Are there some InnoDB params to enable or disable to speed up our tests?

Some tests behave a bit strange, sometimes one of our test takes 1 min 30 secs, sometimes
it takes only 15 seconds...

How can this happen?

Any log I could enable and provide here?

Thanks in

Mroonga 8.01 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 8.01 has been released!

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

Document:
<a href="http://mroonga.org/docs/" title="http://mroonga.org/docs/">http://mroonga.org/docs/</a>

How to install: Install Guide
<a href="http://mroonga.org/docs/install.html" title="http://mroonga.org/docs/install.html">http://mroonga.org/docs/install.html</a>

How to upgrade: Upgrade Guide
<a href="http://mroonga.org/docs/upgrade.html" title="http://mroonga.org/docs/upgrade.html">http://mroonga.org/docs/upgrade.html</a>

Blog:
<a href="http://mroonga.org/en/blog/2018/03/29/mroonga-8.01.html" title="http://mroonga.org/en/blog/2018/03/29/mroonga-8.01.html">http://mroonga.org/en/blog/2018/03/29/mroonga-8.01.html</a>

Changes:
<a href="http://mroonga.org/docs/news.html#release-8.01" title="http://mroonga.org/docs/news.html#release-8.01">http://mroonga.org/docs/news.html#release-8.01</a>

In this release, Mroonga requires latest Groonga 8.0.1 to fix bugs.

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

Five months ago I posted the query shown below on StackOverflow.  I got
one reply which was not of much help.  So I am trying again, hoping a
more MySQL-centric forum might be able to solve my problem.

Roger House

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

I use a 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.

MySQL Connector/Java 5.1.46 GA has been released

Dear MySQL Users,

MySQL Connector/J 5.1.46, a maintenance release of the production 5.1
branch has been released. Connector/J is the Type-IV pure-Java JDBC
driver for MySQL.

MySQL Connector Java is available in source and binary form from the
Connector/J download pages at
<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.

ANN: Upscene releases Database Workbench 5.4.2

Upscene releases Database Workbench 5.4.2

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

" Database Workbench 5.4.2 “

This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL.

Procedure error handling Best Practice

Long time Oracle PL/SQL coder but new to MySQL.

I have an error handler that looks like this ...

declare continue handler for sqlexception
begin
get diagnostics condition 1 @p3 = returned_sqlstate, @p4 = message_text;
set v_there_was_an_error_while_inserting_a_lead_summary := true;

insert into rit.rit_audit_message(severity,
message,
process_name,

summary_detail_map,
createdby2qmp_user,

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

Dear MySQL users,

MySQL Connector/C++ 8.0.7-rc is the release candidate (RC)
of the MySQL Connector/C++ 8.0 series.

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

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

Please don't bother to answer, I did figure it out, I'm sorry, for a bad
question and worse followup. Apparently I'm a spammer as well.

Apparently the error was caused by something else besides plugins in
my configuration. After carefully running --initialize from scratch
and modifying my.ini I was able to get mysqld.exe up and running just
fine on Windows 64 for MySQL 8.0 RC.

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

2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the
mysql.plugin table. Please run mysql_upgrade to create it.

How do I run mysql_upgrade if the mysqld server won't start?

Man how stupid am I?

Optimize fails due to duplicate rows error but no duplicates found

Good day guys,

I am hoping this mail finds you well.

I am at a bit of a loss here...

We are trying to run optimize against a table in order to reclaim disk space from archived data which has been removed.

However, after running for over an hour , the optimize fails stating there is a duplicate entry in the table.

We have now spent 2 days using various methods but we are unable to find any duplicates in the primary key and also nothing on the unique key fields.

Any idea on why optimize would still be failing ?

Regards

Mroonga 8.00 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 8.00 has been released!
This is a major version up! But It keeps backward compatibility.
You can upgrade to 8.0.0 without rebuilding database.

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

ANN: Upscene releases Database Workbench 5.4.0

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

" Database Workbench 5.4.0 "

This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL.

MySQL Connector/Python 8.0.6-rc has been released

Dear MySQL users,

MySQL Connector/Python 8.0.6-rc is the first release candidate version
of the MySQL Connector Python 8.0 series. This series adds support for
the new X DevAPI. The X DevAPI enables application developers to write
code that combines the strengths of the relational and document 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 Cluster 7.6.4-dmr has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master 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.4-dmr, 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 Connector/Java 8.0.9-rc has been released

Dear MySQL users,

MySQL Connector/Java 8.0.9-rc is the first Release Candidate
of the 8.0 branch of MySQL Connector/J, providing an insight into
upcoming features. It is suitable for use with MySQL Server versions
5.5, 5.6, 5.7, and 8.0.

MySQL Connector/Net 8.0.10-rc has been released

Dear MySQL users,

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

Mroonga 7.11 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.11 has been released!

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

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

[If you just recived an email with 8.0.3-rc in the title, please
ignore that. Sorry for the confusion]

* For builds on 32-bit platforms with Undefined Behavior
Sanitizer enabled, a stack-overrun check could cause a
server exit. (Bug #27224961)

* The server could hang during spatial reference system
(SRS) creation while another session was using that SRS.
(Bug #27220467)

* A lock for the privilege cache was acquired unnecessarily
during privilege-checking operations not involving table
permissions.

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

* For builds on 32-bit platforms with Undefined Behavior
Sanitizer enabled, a stack-overrun check could cause a
server exit. (Bug #27224961)

* The server could hang during spatial reference system
(SRS) creation while another session was using that SRS.
(Bug #27220467)

* A lock for the privilege cache was acquired unnecessarily
during privilege-checking operations not involving table
permissions.

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

Bugs Fixed

* Important Change: The following changes are made to the
PERIOD_ADD() and PERIOD_DIFF() functions:

+ A period value used with one of these functions may
not be negative.

+ The month part of a period value may not be equal to
0.
A period value used with one of these functions for which
at least one of these conditions is true now causes the
function to fail with an error.

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

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

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

MySQL Cluster 7.4.19 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication
  - 99.999% High 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.4.18 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication
  - 99.999% High 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

Examples of savepoints and transactions

Hi,
I have a system that uses begin and commit transactions. It works like a dream! ;)
Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution for rolling back test data is to use savepoints and rollback. I think it is hard to find examples of this scenario. Are there some good guides or tutorials out there somewhere? Any suggestions are welcome.

Best regards
Lars Nielsen

Can't get my query to return wanted data

Hi
I am running mysql 5.7.20 in ubuntu linux 17.10

I have 2 tables, member and status with contents like

member:
ident, given, surname
1 fred jones
2 john howard
3 henry wales
4 jenny brown

status:
ident year
1 2017
2 2017
3 2017
4 2017
1 2018
3 2018

I want my query to return the name and ident from the member table for all
members that has not got an entry in status with year=2018

I have been working on the following query to achieve this, but it only
returns data when there is no `year` entries for a selected year.

MySQL Cluster 7.3.20 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master 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.20, 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.5.9 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master 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.9, 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.39 has been released

Dear MySQL users,

MySQL Server 5.6.39, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.6.39 is
recommended for use on production systems.

For an overview of what's new in MySQL 5.6, please see

<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.21 has been released

Dear MySQL users,

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

In MySQL 8.0, how does one recognize roles?

Hi,

In MySQL 8.0, if you use CREATE ROLE, it seems to create an entry in mysql.users

But how does one distinguish between roles and users?

With regards,

Martijn Tonies
Upscene Productions
<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.

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

Hi,

Mroonga 7.10 has been released!

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

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

Syndicate content