Fwd: GTID SUSPENDING

2016-06-21 Thread Camilo Vieira
Hi folks! I have noticed the GTID thread is sunpending since I upgraded the MySQL from 5.5 to 5.7. ​ ​I have tryed to disable GTI using : SET @@GLOBAL.GTID_MODE = OFF; But the problem persists... Somebody could clarify this situation for me? Thanks!!

Re: Precautions to not run out of disk space?

2016-06-21 Thread Reindl Harald
Am 21.06.2016 um 09:41 schrieb Götz Reinicke - IT Koordinator: we recently had a software bug who wrote gigs of data to our database in a loop and finally filled the whole system. O.K. we could serverside use a separate partition/storage for the database directory, but I was wondering is mysql

Re: signal handling in mysql cli

2016-06-21 Thread Sebastien FLAESCH
Hi all, The technique described in this thread is working fine with MySQL 5.6 (libmysqlclient). Basically, in a SIGINT signal handler, we establish a new connection to perform a KILL QUERY pid ... But with 5.7 (5.7.11) we get now a different result: A) The query is still interrupted,

Re: signal handling in mysql cli

2016-06-21 Thread Sebastien FLAESCH
Seems that after KILL QUERY mysql-thread-id, a call to mysql_stmt_close(stmt-handle) hangs... This did not happen in 5.6 ... Will try 5.7.13 ... Seb On 06/21/2016 04:03 PM, Sebastien FLAESCH wrote: Hi all, The technique described in this thread is working fine with MySQL 5.6

Re: signal handling in mysql cli

2016-06-21 Thread Sebastien FLAESCH
FYI, I get the same problem with MySQL 5.7.13. Seb On 06/21/2016 04:59 PM, Sebastien FLAESCH wrote: Seems that after KILL QUERY mysql-thread-id, a call to mysql_stmt_close(stmt-handle) hangs... This did not happen in 5.6 ... Will try 5.7.13 ... Seb On 06/21/2016 04:03 PM, Sebastien

Re: signal handling in mysql cli

2016-06-21 Thread Sebastien FLAESCH
The process list show my (killed) thread as follows: mysql> show processlist; ++-+-+---+-+--+--+--+ | Id | User| Host| db| Command | Time | State| Info |

MySQL Connector/Node.js 1.0.3 m2 Development Release has been released

2016-06-21 Thread hery . ramilison
Dear MySQL users, MySQL Connector/Node.js is a new Node.js driver for use with the X DevAPI. This release, v1.0.3 M2, is the second development release of the MySQL Connector/Node.js 1.0 series. The X DevAPI enables application developers to write code that combines the strengths of the

Precautions to not run out of disk space?

2016-06-21 Thread Götz Reinicke - IT Koordinator
Hi, we recently had a software bug who wrote gigs of data to our database in a loop and finally filled the whole system. O.K. we could serverside use a separate partition/storage for the database directory, but I was wondering is mysql has a feature/option to set some sort of "minimum disk