MySQL Cluster 7.5.6 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-Ma

MySQL Cluster 7.2.28 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-Ma

MySQL Community Server 8.0.1-dmr has been released (part 3/3)

an error. Such values are now handled correctly in MySQL JSON documents. The underlying issue was traced to a problem with RapidJSON, which has been reported to that library's developers as Issue #849 (https://github.com/miloyip/rapidjson/issues/849). (Bug

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

spaces with respect to its parent. Examples: mysql> SELECT JSON_PRETTY('123'); ++ | JSON_PRETTY('123') | ++ | 123| ++ mysql> SELECT JSON_PRETTY("[1,3,5]"); ++ | JSO

MySQL Community Server 5.7.18 has been released

Dear MySQL users, MySQL Server 5.7.18, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.18 is recommended for use on production systems. For an overview of what's new in MySQL 5.7, please see http://dev.mysql.com/doc/refman/5.7/en/mysql

MySQL Community Server 5.5.55 has been released

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

MySQL for Visual Studio 1.2.7 has been released

Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL for Visual Studio 1.2.7. This is a maintenance release for 1.2.x. It can be used for production environments. MySQL for Visual Studio is a product that includes all of the Visual Studio integration

MySQL Community Server 5.6.36 has been released

Dear MySQL users, MySQL Server 5.6.36, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.36 is recommended for use on production systems. For an overview of what's new in MySQL 5.6, please see http://dev.mysql.com/doc/refman/5.6/en/mysql

ANN: DAC for MySQL 3.1.0 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

Re: MySQL server has gone away

Am 03.04.2017 um 21:22 schrieb Mahmood N: well, who did set it that low? ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!! on a proper server you have a local smtpd like postfix listening on 127.0.0.1 and hence you can send thousands of messages within seconds

Re: MySQL server has gone away

>well, who did set it that low? ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!! Anyway, thanks.  Regards, Mahmood On Monday, April 3, 2017 11:37 PM, Reindl Harald <h.rei...@thelounge.net> wrote: Am 03.04.2017 um 20:41 schrieb Mahmood N: > Good

Re: MySQL server has gone away

taking more than 2 weeks about that! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL server has gone away

Good news! I changed wait_timeout=30 to wait_timeout=600 and now the error disappears... I don't know if long_query_time=1 has effect. Regards, Mahmood On Monday, April 3, 2017 10:32 PM, Mahmood N wrote: Dear reindl, I tested with both 5 and 1 and see the log

Re: MySQL server has gone away

Dear reindl, I tested with both 5 and 1 and see the log files are empty. I am really confused about that error and it is taking more than 2 weeks about that! Regards, Mahmood

Re: MySQL server has gone away

ins > > log_error=/var/log/mysql/error.log > slow_query_log=1 > slow_query_log_file=/var/log/mysql/error_slow.log > max_connections=200 > max_user_connections=30 > wait_timeout=30 > interactive_timeout=50 > long_query_time=5 > character-set-client-handshake

Re: MySQL server has gone away

So I set long_query_time=5 and restarted the service. Test the email page again. Still the logs are empty.  Regards, Mahmood

Re: MySQL server has gone away

>since when is phpinfo() - the *real* active configuration be it changed >by some config snippet, vhost-configuration or even ini_set() - the same >than a random file in /etc? Sorry I totally didn't understand that sentence... Regards, Mahmood

Re: MySQL server has gone away

the email test, the refresh time for that page is about 5 minutes. if you think a moment you realize that lower values are better when 5 seconds don't log any query and you have obvious slow queries look also in phpinfo() for mysqlnd and mysql params containing "timeout" and/or "

Re: MySQL server has gone away

resh time for that page is about 5 minutes. >look also in phpinfo() for mysqlnd and mysql params containing "timeout" >and/or "max" in /etc/php/7.0/apache2/php.ini I see ;mysqlnd.net_read_timeout = 31536000 Note that is comment.  Regards, Mahmood

Re: MySQL server has gone away

Am 03.04.2017 um 18:11 schrieb Mahmood N: The my.conf file contains log_error=/var/log/mysql/error.log slow_query_log=1 slow_query_log_file=/var/log/mysql/error_slow.log max_connections=200 max_user_connections=30 wait_timeout=30 interactive_timeout=50 long_query_time=5 character-set-client

Re: MySQL server has gone away

The my.conf file contains log_error=/var/log/mysql/error.log slow_query_log=1 slow_query_log_file=/var/log/mysql/error_slow.log max_connections=200 max_user_connections=30 wait_timeout=30 interactive_timeout=50 long_query_time=5 character-set-client-handshake = FALSE thread_concurrency = 8

Re: MySQL server has gone away

Am 03.04.2017 um 17:52 schrieb Mahmood N: Dear all, Currently max_allowed_packet is set to 8M. That test email is simply a test email containing some basic information in the message body to assure that the email system works. Thing that can help me is to put mysql in the debug mode in one

Re: MySQL server has gone away

Dear all, Currently max_allowed_packet is set to 8M. That test email is simply a test email containing some basic information in the message body to assure that the email system works. Thing that can help me is to put mysql in the debug mode in one terminal and at the same time, submit a test

Re: MySQL server has gone away

On 4/3/2017 8:15 AM, Mahmood N wrote: When I click on the submit button in Moodle and it is waiting for refresh, I execute the mysql command but the output is not meaningful mahmood@ce:/var/www/html/courses$ mysql -u moodle -p Enter password: Welcome to the MySQL monitor. Commands end

Re: MySQL server has gone away

When I click on the submit button in Moodle and it is waiting for refresh, I execute the mysql command but the output is not meaningful mahmood@ce:/var/www/html/courses$ mysql -u moodle -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 30912

Re: MySQL server has gone away

I'd suspect the underlying query is poorly designed for the amount of data you have stored. If you have access to the mysql server you could connect to it using any mysql client and run 'show full processlist' to see the query as that page is trying to load. The query is probably in the 'sending

Re: MySQL server has gone away

Thanks for the quick reply. So, how can I get further information? Thing is that, after 5 minutes, when I refresh the page every thing is normal.  Regards, Mahmood On Monday, April 3, 2017 3:39 PM, Ken D'Ambrosio <k...@jots.org> wrote: Basically, it says that MySQL is not resp

Re: MySQL server has gone away

Basically, it says that MySQL is not responding to queries. So it likely has died, or perhaps is mis-configured. On April 3, 2017 7:07:25 AM EDT, Mahmood N <nt_mahm...@yahoo.com> wrote: >Hi,I am using Moodle which itself uses SQL for the database. Problem is >that, when I run the

MySQL server has gone away

Hi,I am using Moodle which itself uses SQL for the database. Problem is that, when I run the email plugin and execute the command, the refresh time of the page becomes high (in the order of 3-5 minutes) and at the end, I see this message Debug info: MySQL server has gone away SELECT id, sid

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

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

MySQL Connector/C++ 2.0.4 m2 has been released

Dear MySQL users, MySQL Connector/C++ 2.0.4 is the next development milestone of the MySQL Connector/C++ 2.0 series. Connector/C++ 2.0 can be used to access MySQL implementing Document Store or in a traditional way, using SQL queries. It allows writing both C++ applications using X DevAPI

MySQL Connector/Net 7.0.7 m6 has been released

Dear MySQL users, MySQL Connector/Net 7.0.7 is the fourth development release that expands cross-platform support to Linux and OS X 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 6.0.6-m5 has been released

Dear MySQL users, MySQL Connector/J 6.0.6 m5 Development Release is a developer milestone release for the 6.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/6.0/en/news-6-0-6.html As always

MySQL Connector/NodeJS 1.0.6 M5 has been released

Dear MySQL users, MySQL Connector/Node.js is a new Node.js driver for use with the X DevAPI. This release, v1.0.6 M5, is the fourth development release of the MySQL Connector/Node.js 1.0 series. The X DevAPI enables application developers to write code that combines the strengths

MySQL Cluster Manager 1.4.2 has been released

Dear MySQL Users, MySQL Cluster Manager 1.4.2 has been released and can be downloaded from the My Oracle Support (MOS) website. It will also be available on Oracle Software Delivery Cloud at http://edelivery.oracle.com with the next monthly update MySQL Cluster Manager is an optional component

MySQL Router 2.1.2 RC has been released

Dear MySQL users, MySQL Router 2.1.2 RC is a release candidate for MySQL Router 2.1. 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

MySQL Router 2.1.2 RC has been released

Dear MySQL users, MySQL Router 2.1.2 RC is a release candidate for MySQL Router 2.1. 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

MySQL Shell 1.0.8 RC has been released

Dear MySQL users, MySQL Shell 1.0.8 RC is the first release candidate of the MySQL for MySQL Shell 1.0 series. The MySQL Shell is an interactive JavaScript, Python and SQL command-line interface, supporting development and administration for the MySQL Server. The MySQL Shell includes the X

MySQL Enterprise Backup 4.1.0 has been released

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

MySQL Connector/J 5.1.41 has been released

Dear MySQL Users, MySQL Connector/J 5.1.41, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.41 is suitable for use with many MySQL server versions, including 4.1, 5.0, 5.1, 5.4 and 5.5. MySQL Connector

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

Hi, Mroonga 7.00 has been released! Even though major version upgrade, it keeps compatibility of Mroonga database. 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

MySQL Workbench 6.3.9 GA has been released

Dear MySQL users, The MySQL developer tools team announces 6.3.9 as our GA release for MySQL Workbench 6.3. For the full list of changes in this revision, visit http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html For discussion, join the MySQL Workbench Forums: http

MySQL Utilities 1.6.5 GA has been released

Dear MySQL users, MySQL MySQL Utilities 1.6.5 is a GA version of 1.6 release series. It can be used for production environments. MySQL Utilities version 1.6.5 GA is compatible with MySQL Server versions 5.5 and greater. Python v2.6 and v2.7 are supported. It is available for download from

MySQL Cluster 7.5.5 has been released

Dear MySQL Users, MySQL Cluster 7.5.5 (GA) is a GA release for MySQL Cluster 7.5. 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

MySQL Cluster 7.2.27 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-Ma

mysql Archiving engine

available, etc... Can anyone please advise on this ? Any info will be greatly appreciated. Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

MySQL Connector/C++ 1.1.8 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.8 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

MySQL Community Server 5.7.17 has been released

Dear MySQL users, MySQL Server 5.7.17, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.17 is recommended for use on production systems. For an overview of what's new in MySQL 5.7, please see http://dev.mysql.com/doc/refman/5.7/en/mysql

MySQL Community Server 5.5.54 has been released

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

MySQL Connector/NET 6.10.0 alpha has been released

Dear MySQL users, MySQL Connector/Net 6.10.0 alpha is the first release to provide Entity Framework Core 1.1 support and to enable compression in the .NET Core version of the driver for enhanced cross-platform application development. To download MySQL Connector/Net 6.10.0 alpha, see

Re: a curse on OS sierra and MySQL?

Well, the command sudo /usr/local/mysql/support-files/mysql.server stop generates the error message: ERROR! MySQL server PID file could not be found! On the other hand, sudo launchctl unload -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist stops the server and sudo /usr/local

Re: a curse on OS sierra and MySQL?

On 12/3/2016 13:58, Martin Mueller wrote: I was able to install a version of MySQL 5.6 on OS Sierra. It appears that the “launchdaemon’ method works while the mysql.server start/stop method does not work. In retrospect I should have seen that, but I also think that the official documentation

Re: a curse on OS sierra and MySQL?

=/var/run/mysqld/mysqld.pid? I believe you need to ensure that the pid file specified in my.cnf exists and that the mysql daemon owns it ... mkdir /var/run/mysqld touch /var/run/mysqld/mysqld.pid chown -R mysql:mysql /var/run/mysqld Also see http://superuser.com/questions/159486/how-to-kill

Re: a curse on OS sierra and MySQL?

2016/12/02 18:58 ... Martin Mueller: Alas, running the stop and start commands under sudo makes zero difference. This is a very frustrating problem, and I hope somebody in the MySQl documentation department will take a look at it. It’s cleary a problem that has been around for years because

Re: a curse on OS sierra and MySQL?

Alas, running the stop and start commands under sudo makes zero difference. This is a very frustrating problem, and I hope somebody in the MySQl documentation department will take a look at it. It’s cleary a problem that has been around for years because the Web is full of complaints and tips

Re: a curse on OS sierra and MySQL?

On 12/2/2016 16:59, Martin Mueller wrote: I have been trying repeatedly and in vain to install the community edition of MySQL 5.7.16 on an iMac running OS sierra. I religiously followed the instructions for uninstalling previous versions found at http://community.jaspersoft.com/wiki

a curse on OS sierra and MySQL?

I have been trying repeatedly and in vain to install the community edition of MySQL 5.7.16 on an iMac running OS sierra. I religiously followed the instructions for uninstalling previous versions found at http://community.jaspersoft.com/wiki/uninstall-mysql-mac-os-x, and installation

Re: Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again

Am 01.12.2016 um 08:26 schrieb Götz Reinicke - IT Koordinator: it happend again and I can't fix it, may be someone has a working solution and information on that: surely -> man systemd LimitNOFILE=infinity LimitMEMLOCK=infinity OOMScoreAdjust=-1000 I installed the most recent mysql

Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again

Hi, it happend again and I can't fix it, may be someone has a working solution and information on that: I installed the most recent mysql 5.6 community on a server and do get a lot of "errno: 24 - Too many open files". There are suggestions to increase the open_files_limit,

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

Hi, Mroonga 6.11 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 http://mroonga.org

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

is the core component of Mroonga.) 2) Groonga 4.0.3 vs Elasticsearch 1.1.2 at 2014, around indexing http://blog.createfield.com/entry/2014/07/22/080958 (Japanese) 3) Mroonga vs InnoDB[ngram] vs InnoDB[MeCab] benchamrk on MySQL 5.7 at July 2016 https://slide.rabbit-shocker.org/authors/kou

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

Can you post some benchmarks or comparison with elasticsearch? Sent from ProtonMail mobile Original Message On 29 ott 2016 05:03, Kentaro Hayashi wrote: Hi, Mroonga 6.10 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search

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

Hi, Mroonga 6.10 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 http://mroonga.org

MySQL Connector/NET 7.0.6 m5 development has been released

Dear MySQL users, MySQL Connector/Net 7.0.6 is the third development release that expands cross-platform support to Linux and OS X 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/Python 2.0.5 GA has been released

Dear MySQL users, MySQL Connector/Python 2.0.5 GA is a new GA version of 2.0 release series of the pure Python database driver for MySQL. It can be used for production environments. MySQL Connector/Python version 2.0.5 is compatible with MySQL Server versions 5.5 and greater. Python 2.6

ANN: DAC for MySQL 3.0.7 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

MySql installer for windows 7

Hi all—   I am new to the list and to MYSql. I downloaded MySqlcommunity and I tried to installing it using MySql installer. I am stuck whereMYSql needs to manually connect to Python 3.4 which I had already installed onmy computer. But for some reason, the installer cannot connect to Pythin 3.4

MySQL Connector/C++ 2.0.3 m3 Development Release has been released

Dear MySQL users, MySQL Connector/C++ 2.0.3 is the next development milestone of the MySQL Connector/C++ 2.0 series, and the first public release. Apart from covering more X DevAPI features, it adds a new, plain C API, called XAPI, that offers functionality similar to X DevAPI to applications

MySQL Cluster 7.3.15 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-Ma

MySQL Community Server 5.7.16 has been released

Dear MySQL users, MySQL Server 5.7.16, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.16 is recommended for use on production systems. For an overview of what's new in MySQL 5.7, please see http://dev.mysql.com/doc/refman/5.7/en/mysql

MySQL Community Server 5.6.34 has been released

Dear MySQL users, MySQL Server 5.6.34, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.34 is recommended for use on production systems. For an overview of what's new in MySQL 5.6, please see http://dev.mysql.com/doc/refman/5.6/en/mysql

MySQL Connector/Node.js 1.0.4 m3 Development Release has been released

Dear MySQL users, MySQL Connector/Node.js is a new Node.js driver for use with the X DevAPI. This release, v1.0.4 M3, is the third development release of the MySQL Connector/Node.js 1.0 series. The X DevAPI enables application developers to write code that combines the strengths

Starting MySQL takes a long long time

Hello all, Had a normal MySQL shutdown, reboot and then this happens: 161010 10:58:30 [Note] Plugin 'FEDERATED' is disabled. 161010 10:58:31 InnoDB: The InnoDB memory heap is disabled 161010 10:58:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions 161010 10:58:31 InnoDB

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

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

Re: MySQL Platform Migration

l Harald" <h.rei...@thelounge.net> > To: "MySql" <mysql@lists.mysql.com> > Sent: Tuesday, 13 September, 2016 13:39:59 > Subject: Re: MySQL Platform Migration > Am 13.09.2016 um 12:13 schrieb Johan De Meersman: >> - Original Message - >>>

Re: MySQL Platform Migration

rieb Johan De Meersman: - Original Message - From: "Ryan Coleman" <ryan.cole...@cwis.biz> Subject: Re: MySQL Platform Migration Because they want to be belittled by european jackasses online. The thing is, while he has a bit of a rough edge, his technical advice is alway

Re: MySQL Platform Migration

gt; wrote: > > > >> Am 13.09.2016 um 12:13 schrieb Johan De Meersman: >> - Original Message - >>> From: "Ryan Coleman" <ryan.cole...@cwis.biz> >>> Subject: Re: MySQL Platform Migration >>> >>> Because they want to

Re: MySQL Platform Migration

Am 13.09.2016 um 12:13 schrieb Johan De Meersman: - Original Message - From: "Ryan Coleman" <ryan.cole...@cwis.biz> Subject: Re: MySQL Platform Migration Because they want to be belittled by european jackasses online. The thing is, while he has a bit of a rough edg

Re: MySQL Platform Migration

- Original Message - > From: "Reindl Harald" <h.rei...@thelounge.net> > Subject: Re: MySQL Platform Migration > > we discussed this multiple times here True; but new people on the list may not have seen that. > when you *copy* the datadir on the targe

Re: MySQL Platform Migration

- Original Message - > From: "Matthias Schmidt" <b...@admilon.net> > Subject: Re: MySQL Platform Migration > > I had to make certain adjustements to the config file thou. Interesting - what changes did you have to make? I would expect most things to just keep

Re: MySQL Platform Migration

Am 13.09.2016 um 12:09 schrieb Johan De Meersman: - Original Message - From: "Reindl Harald" <h.rei...@thelounge.net> Subject: Re: MySQL Platform Migration why shouldn't it when the identical software is running? it's just a bunch of files used by mysql Littl

Re: MySQL Platform Migration

- Original Message - > From: "Ryan Coleman" <ryan.cole...@cwis.biz> > Subject: Re: MySQL Platform Migration > > Because they want to be belittled by european jackasses online. The thing is, while he has a bit of a rough edge, his technical advice is

Re: MySQL Platform Migration

- Original Message - > From: "Reindl Harald" <h.rei...@thelounge.net> > Subject: Re: MySQL Platform Migration > > why shouldn't it when the identical software is running? > it's just a bunch of files used by mysql Little/big endianness, for one, although I

MySQL Community Server 8.0.0-dmr has been released (part 3/3)

[This is part 3 of the announcement] Bugs Fixed * Important Change: The empty string value is now accepted as a key when used with JSON functions such as JSON_EXTRACT(). In such cases, it must be quoted. (Bug #79643, Bug #22366102) * MySQL Cluster: Previously

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

Performance Schema Error Summary Tables (http://dev.mysql.com/doc/refman/8.0/en/error-summary-tables.html) If you upgrade to this MySQL release from an earlier version, you must run mysql_upgrade (and restart the server) to incorporate these changes

Re: MySQL Platform Migration

s I was using also a newer version of mysql I ran mysql_upgrade -u root -p after starting mysql and all is now running fine. I had to make certain adjustements to the config file thou. imho a change from Darwin to Linux (which one) isn’t that much different. cheers Matthias > Am 12.09.2016 um

Re: MySQL Platform Migration

m to take the proven route, as described in the mysql documentation proven route? proven is that you can *test* how it works out by * hot rsync * shut down the old server * cold rsync * start the old server which is scriptable to minimize downtime after that (while the old machine is still in

Re: MySQL Platform Migration

t; It is bad practice to do so in my eyes (and yes that is an *opinion*). >> When you advice people, instruct them to take the proven route, as >> described in the mysql documentation > > proven route? > > proven is that you can *test* how it works out by > * hot rsync

Re: MySQL Platform Migration

en you advice people, instruct them to take the proven route, as described in the mysql documentation proven route? proven is that you can *test* how it works out by * hot rsync * shut down the old server * cold rsync * start the old server which is scriptable to minimize downtime after

Re: MySQL Platform Migration

Hi, . It is bad practice to do so in my eyes (and yes that is an *opinion*). When you advice people, instruct them to take the proven route, as described in the mysql documentation. Second, mastering mysqldump should be golden standard for any DBA. Telling someone that asks for guidance to simply

Re: MySQL Platform Migration

Am 12.09.2016 um 10:48 schrieb Harrie Robins: Ok let's drop this. Simply copying files to migrate a server is not the approach to take (in my humble opinion) And why? When you start with "Get the same release-version of mysql running on the target platform" and dump/load what's

Re: MySQL Platform Migration

Ok let's drop this. Simply copying files to migrate a server is not the approach to take (in my humble opinion). First asses the situation, a platform migration? Get the same release-version of mysql running on the target platform. Dump your mysql database the with the excellent tool mysqldump

Re: MySQL Platform Migration

wrote: Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal: Is the mysql datafile compatible with different operation system ? I have not done this in the past. why shouldn't it when the identical software is running? it's just a bunch of files used by mysql as said copy it to the new machine a

Re: MySQL Platform Migration

On Sep 10, 2016, at 11:56 PM, Reindl Harald <h.rei...@thelounge.net> >wrote: >> >> >> Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal: >>> Is the mysql datafile compatible with different operation system ? I >>>have not done this in the past. >&g

Re: MySQL Platform Migration

Because they want to be belittled by european jackasses online. On Sep 10, 2016, at 11:56 PM, Reindl Harald <h.rei...@thelounge.net> wrote: > > > Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal: >> Is the mysql datafile compatible with different operation system

Re: MySQL Platform Migration

Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal: Is the mysql datafile compatible with different operation system ? I have not done this in the past. why shouldn't it when the identical software is running? it's just a bunch of files used by mysql as said copy it to the new machine and you

Re: MySQL Platform Migration

Hi Reindl, Is the mysql datafile compatible with different operation system ? I have not done this in the past. Regarding cross-post, mysql list was bouncing due to html email format. Didn't realize until today. That's why posted in mariadb. Thanks Suresh - Original Message - From

Re: MySQL Platform Migration

Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal: Is there any documentation for migrating mysql 5.0 database from darwin to Linux what do you need to migrate? shutdown mysqld, copy the datadir to the new machine, stat mysqld with adopted configuration ion the new machine - done P.S

MySQL Platform Migration

Hi, Is there any documentation for migrating mysql 5.0 database from darwin to Linux. Thanks Suresh Rajagopal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: MySql Swapping issues

Hi Machiel, On 8/09/2016 05:24, Machiel Richards wrote: ... Biggest issue at the moment is mysql taking all physical memory until nothing left, the starts swapping as well until that is completely used up. Since you are using MySQL 5.7, you can consider enabling memory instrumentation

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