MySQL 8.x GA release date?

Is there a planned release date for MySQL 8.x generally available release?

Re: monitoring mysql performance

Am 02.11.2017 um 20:09 schrieb Miguel González: 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

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

[ANN] 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. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

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

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. It can be used for production environments. It is appropriate for use with MySQL server versions 5.5-5.7. It is now available in source and binary form from

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.

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

2017/10/18 18:32 ... Roger House: I get the same behavior with the MySQL Command Line Tool when I run it on Windows, Mac OS X, and Ubuntu, so I'm pretty sure the problem has to do with mysql itself. What do you know about the displays to which the client is writing? In the case of "cmd" under

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

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

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

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

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

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. MySQL 5.7.20 is recommended for use on production systems. For an overview of what's new in MySQL 5.7, please see

[ANN] 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. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

Re: Last established connection timestamp by a specific user

Unfortunately not with the standard configuration. You're best bet going forward would be to look at MySQL Enterprise Audit - https://www.mysql.com/products/enterprise/audit.html On Tue, Oct 10, 2017 at 3:54 PM, Gone, Sajan wrote: > Hi, > >We have a MySQL instance which is

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`. On this instance I am trying to figure out the most recent timestamp at which a specific user has established a connection to this instance (or) performed any DML operations

Re: Question about contributing a patch

On 10/9/2017 3:27 AM, Xiaoyu Wang wrote: Hello,I reported a bug, at https://bugs.mysql.com/bug.php?id=87637, 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

Question about contributing a patch

Hello,I reported a bug, at https://bugs.mysql.com/bug.php?id=87637, 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

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

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

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

Can you please stop using C++ comments in header files designed for C programming? /opt3/dbs/mys/8.0/include/mysql.h:36:1: error: C++ style comments are not allowed in ISO C90 [-Werror] // Small extra definitions to avoid pulling in my_inttypes.h in client code. ^

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 https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-8.html MySQL

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

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. It allows writing both C++ applications

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. This contradicts RFC 7159, which suggests that duplicate key

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. This is the first release candidate of MySQL 8.0.

Re: Omit another where clause from original query

2017/09/19 17:19 ... Don Wieland: Of these found rows, I want to omit those rows where there are rows found after the END TimeStamp based on ?below ?where clause: WHERE 1 AND apt.appt_status_id IN (16) AND apt.user_id IN (3) AND apt.time_start > ‘1504238399' We are trying to find Former

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

Re: innodb_read_only issues

On Thu, Sep 7, 2017, at 02:04 PM, shawn l.green wrote: > Hello Josh, > > > What appears to be missing on that page is a discussion what to do with > the "temporary tablespace" used to hold intrinsic (internal) temporary > tables created by different types of queries you could execute. > >

Re: innodb_read_only issues

Hello Josh, On 9/6/2017 11:01 PM, Josh Paetzel wrote: I've followed the instructions at https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html Which starts with: 14.6.2 Configuring InnoDB for Read-Only Operation You can now query InnoDB tables where the MySQL data directory

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. DAC for MySQL allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll.

innodb_read_only issues

I've followed the instructions at https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html 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

[ANN] 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. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

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

[ANN] 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. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

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,

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

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

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

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

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

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. This is the first public milestone release of MySQL 8.0.

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 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 5.7.19 is recommended for use on production systems. For an overview of what's new in MySQL 5.7, please see

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

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

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

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 https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-7.html MySQL

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. It allows writing both C++

Re: MySQL Cluster Manager 1.4.3 has been released

Hi, Sree, I'm taking care of the release now. Docs should be up soon. Daniel On 10/07/2017 6:53 AM, Sreedhar S wrote: Dear MySQL Users, MySQL Cluster Manager 1.4.3 has been released and can be downloaded from the My Oracle Support (MOS) website. It will also be available on Oracle Software

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

[ANN] 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. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

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

Dear all, Benetl, a free ETL tool for MySQL, is out in version 4.8. This new version is providing some code optimizations, tests coverage improvement. This version supports Java 1.8 and providesone bug correction. You should really update. Benetl is freely dowloadable

Fwd: Re: Something strange here...

Hello List, So sorry about the bad click. I meant to "Reply to list" but instead just replied to the original poster. This is the exact same advice that hsv@ just provided. If I had paid attention I could have saved him the duplication of efforts. My apologies to him and everyone else.

Re: Something strange here...

2017/06/13 17:42 ... Chris Knipe: Can someone explain to me why this is happening please: mysql> SELECT * FROM CustomerDetails WHERE Username=’blah’\G *** 1. row *** EntryID: F83D4109-DCA8-426F-98B1-00B4AF117ACB Username:

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

Something strange here...

Hi all, Can someone explain to me why this is happening please: mysql> SELECT * FROM CustomerDetails WHERE Username=’blah’\G *** 1. row *** EntryID: F83D4109-DCA8-426F-98B1-00B4AF117ACB Username: blah AccountVolume: 0 1 row

[ANN] 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 ( http://www.qxorm.com/) ! 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

Re: mysqld_multi

Am 01.06.2017 um 00:01 schrieb Matthew Black: I DON'T RUN SYSTEMD, so that's not an option. At all. Why is that so hard to grasp? then just clone the sysvinit script as i have done years ago before syetemd on dozens of machines without ever touch mysqld_multi - why is that so hard to

RE: mysqld_multi

I DON'T RUN SYSTEMD, so that's not an option. At all. Why is that so hard to grasp? Where do I enter the command "create table database" when mysqld isn't running? It isn't possible to launch mysqld when there's no database directory or initialized database. You fail to grasp my problem and

Re: mysqld_multi

Am 31.05.2017 um 17:48 schrieb Matthew Black: # mysql -uroot -p --socket=/MySQLdb/cba/mysql.sock mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; mysql> quit I was simply seeking those three commands, but the reference manual did not provide a real-world example. they don't

RE: mysqld_multi

Thank you all for the tips. I've read the manual multiple times and it is NOT clear what options are necessary in a multi environment. The missing element was provided by Oracle support: I need to use --defaults-file=my.cnf as in: # mysqld --defaults-file=cba.cnf --initialize --user=cba

[ANN] 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. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

Re: Which choice of mysql??

On 5/24/2017 12:21, Papa wrote: 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

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

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

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. When I try to import the sql via command

Re: mysqld_multi

Hello Matthew, On 5/19/2017 12:19 PM, Matthew Black wrote: 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

Re: mysqld_multi

can't you just stop reply-all so that responses are going back to the list Am 20.05.2017 um 12:01 schrieb Johan De Meersman: He means a database, not a schema. Instance would have been clearer as terminology goes, admittedly, but in a MySQL context the two are identical. database and

Re: mysqld_multi

He means a database, not a schema. Instance would have been clearer as terminology goes, admittedly, but in a MySQL context the two are identical. -- Sent from my Android device with K-9 Mail. Please excuse my brevity. -- MySQL General Mailing List For list archives:

Re: mysqld_multi

Am 19.05.2017 um 18:42 schrieb Matthew Black: Sorry, but that is not the least bit helpful. We are not ready for RHEL 7, which is VERY different than prior versions. I don't really need the victim blaming for using an earlier RHEL release that is still fully supported and in widespread use.

RE: mysqld_multi

Sorry, but that is not the least bit helpful. We are not ready for RHEL 7, which is VERY different than prior versions. I don't really need the victim blaming for using an earlier RHEL release that is still fully supported and in widespread use. As for /etc/my.cnf, that's where one defines the

Re: mysqld_multi

Am 19.05.2017 um 18:19 schrieb Matthew Black: 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

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

Network throughput for mysql replication

Hi Guys I am once again having a weird issue... well weird to me anyway. We have a master,slave setup using mysql 5.7 and they are both connected on the same network segment through the same switch. During the weekend a HUGE amount of processing was done on the master, and thus

Re: tcmalloc mysql 5.7.14

Hi Shawn Thank you for the response. I have in fact in the meantime installed jemmalloc libraries on a few servers and the issue with the memory is definitely gone when using jemmalloc library. I do still feel this is a bug though , as I am only able to produce this issue when using

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:

Re: Ssd vs mix of ssd and spinning disk

Hi Shain, On 5/8/2017 1:53 PM, Shain Miley wrote: 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.

Re: tcmalloc mysql 5.7.14

(yes, I recognize how late this reply is) On 5/8/2017 7:56 AM, Reindl Harald wrote: Am 08.05.2017 um 13:51 schrieb Machiel Richards: 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

Re: Ssd vs mix of ssd and spinning disk

Am 08.05.2017 um 19:53 schrieb Shain Miley: 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

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

Re: tcmalloc mysql 5.7.14

I upgraded my mysql on my laptop to the MariaDB which is using the jemmalloc as you stated and that seems to work well. However on the servers it is running the Percona mysql 5.7.14 and there are no specific malloc libraries configured. >From what I understood , this then uses the normal OS

Re: tcmalloc mysql 5.7.14

Am 08.05.2017 um 13:51 schrieb Machiel Richards: 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

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

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 'replica@10.0.15.183:3306',replication started in log 'FIRST' at position 4

MySQL Community Server 5.5.56 has been released

Dear MySQL users, MySQL Server 5.5.56 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.56 is recommended for use on production systems. Binary packages for MySQL 5.5.56 are identical to those for MySQL 5.5.55, except for the version

MySQL Connector/ODBC 5.3.8 has been released

Dear MySQL users, MySQL Connector/ODBC 5.3.8, 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

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

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

Re: Can not add foreign key constraint

Hello, My thanks to everyone who helped on this issue. The index did it. Thanks. Dave. On 4/28/17, Johan De Meersman wrote: > That is quite different, as I suspected :-) > > Referential keys require an index on the target table that begins with the > referenced field, so

Re: Can not add foreign key constraint

That is quite different, as I suspected :-) Referential keys require an index on the target table that begins with the referenced field, so you'll need to add one on user, as was specified in the create table you originally posted. On 28 April 2017 01:21:39 CEST, David Mehler

MySQL Connector/J 5.1.42 has been released

Dear MySQL Users, MySQL Connector/J 5.1.42, 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

Re: Can not add foreign key constraint

Hello, Here's the output of the command show create table virtual_users: create table virtual_users;

Re: Can not add foreign key constraint

Hello, Tried recreating the virtual_users table didn't solve anything. Would it be possible for anyone to check out my box directly? Thanks. Dave. On 4/24/17, Peter Brawley wrote: > On 4/24/2017 20:47, David Mehler wrote: >> Hello, >> >> Thanks. Here's the create

Re: Can not add foreign key constraint

On 4/24/2017 20:47, David Mehler wrote: Hello, Thanks. Here's the create statements for virtual_domains, virtual_users, and the one that isn't working lastauth: CREATE TABLE `virtual_domains` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) )

Re: Can not add foreign key constraint

Hello, Thanks. Here's the create statements for virtual_domains, virtual_users, and the one that isn't working lastauth: CREATE TABLE `virtual_domains` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE

Re: DATETIME vs CHAR for "timestamp"

> On Apr 14, 2017, at 1:07 PM, shawn l.green wrote: > > That all depends. Do you... Hi Shawn, I thought I had replied to your response, but it looks like I didn’t. Thank you for your email. It was a thorough response and the links were very helpful, as

Re: Can not add foreign key constraint

Hello, I'm running Mysql 5.7.18. My virtual_users are working fine, it's the new table that isn't. Or am I missing something? Thanks. Dave. On 4/24/17, Peter Brawley wrote: > On 4/24/2017 17:41, David Mehler wrote: >> Hello, >> >> Here's the output. I hope it

Re: Can not add foreign key constraint

Hello, Here's the output. I hope it helps. root@localhost [mail]> CREATE TABLE IF NOT EXISTS `lastauth` ( -> `user` varchar(40) NOT NULL, -> `remote_ip` varchar(18) NOT NULL, -> `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -> PRIMARY KEY

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