Re: Can not add foreign key constraint

On 4/24/2017 15:28, Peter Brawley wrote: On 4/24/2017 13:59, David Mehler wrote: Hello, root@localhost [mail]> show engine innodb_status; ERROR 1286 (42000): Unknown storage engine 'innodb_status' Well it's very unlikely InnoDB made that up, it's probably in one of your Create texts. Ah,

Re: Can not add foreign key constraint

On 4/24/2017 2:10 PM, Peter Brawley wrote: On 4/24/2017 12:28, David Mehler wrote: ...snip Adding in a dummy Create Table for the missing referenced `virtual_domains`, we have ... drop table if exists lastauth, virtual_users, virtual_domains; CREATE TABLE virtual_domains ( id int

Re: Can not add foreign key constraint

Hello, Here's the engines I have: root@localhost [(none)]> show engines; ++-++--+--++ | Engine | Support | Comment | Transactions | XA |

Re: Can not add foreign key constraint

On 4/24/2017 13:59, David Mehler wrote: Hello, root@localhost [mail]> show engine innodb_status; ERROR 1286 (42000): Unknown storage engine 'innodb_status' Well it's very unlikely InnoDB made that up, it's probably in one of your Create texts. PB - This is on a Mysql 5.7 setup.

Re: Can not add foreign key constraint

Hello, root@localhost [mail]> show engine innodb_status; ERROR 1286 (42000): Unknown storage engine 'innodb_status' This is on a Mysql 5.7 setup. Thanks. Dave. On 4/24/17, Peter Brawley wrote: > On 4/24/2017 12:28, David Mehler wrote: >> Hello, >> >>Here's

Re: Can not add foreign key constraint

On 4/24/2017 12:28, David Mehler wrote: Hello, Here's the create table sand error message. root@localhost [(none)]> use mail; Database changed root@localhost [mail]> CREATE TABLE IF NOT EXISTS `lastauth` ( -> `user` varchar(40) NOT NULL, -> `remote_ip` varchar(18) NOT

Re: Can not add foreign key constraint

Hello, Here's the create table sand error message. root@localhost [(none)]> use mail; Database changed root@localhost [mail]> CREATE TABLE IF NOT EXISTS `lastauth` ( -> `user` varchar(40) NOT NULL, -> `remote_ip` varchar(18) NOT NULL, -> `timestamp` timestamp NOT NULL

Re: Can not add foreign key constraints

On 4/24/2017 9:18, David Mehler wrote: Hello, I'm trying to add a table to an existing database. I'm wanting it to get one of it's fields from an already existing table. I've done this before in this database. This works: CREATE TABLE `virtual_users` ( `id` int(11) NOT NULL

Re: Can not add foreign key constraints

Am 24.04.2017 um 16:18 schrieb David Mehler: I'm trying to add a table to an existing database. I'm wanting it to get one of it's fields from an already existing table. I've done this before in this database. This works: CREATE TABLE `virtual_users` ( `id` int(11) NOT NULL

Can not add foreign key constraints

Hello, I'm trying to add a table to an existing database. I'm wanting it to get one of it's fields from an already existing table. I've done this before in this database. This works: CREATE TABLE `virtual_users` ( `id` int(11) NOT NULL auto_increment, `domain_id` int(11) NOT NULL,

behavior and documents conflict for SELECT LAST_INSERT_ID()

Dear friends, 1. https://bugs.mysql.com/bug.php?id=78934 2. https://dev.mysql.com/doc/refman/5.7/en/information-functions.html#function_last-insert-id The document (2) says that LAST_INSERT_ID() will not be changed if no rows are inserted successfully. But (1) says that it's undefined when no

Upscene releases Database Workbench 5.3

Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.3 " This release includes a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for Firebird 3

Re: DATETIME vs CHAR for "timestamp"

On 4/14/2017 3:11 PM, SSC_perl wrote: I have creation date/time fields in my script that are formatted as |MM|DD|hh|mm|ss. Short of changing the script, should I set the field type in MySQL to DATETIME, or would it be better in terms of speed and efficiency to set it as

DATETIME vs CHAR for "timestamp"

I have creation date/time fields in my script that are formatted as |MM|DD|hh|mm|ss. Short of changing the script, should I set the field type in MySQL to DATETIME, or would it be better in terms of speed and efficiency to set it as char(19)? Or would it not make a difference?

Re: Automated SQL checker?

> On Apr 12, 2017, at 3:38 PM, Ronan McGlue wrote: > > Enable the slow log on the DB. Thanks Ronan. That sounds like it would be beneficial. I take it you’re referring to a setting on the server, though. If that’s the case, I don’t think I can do that as

Re: Automated SQL checker?

Hi Frank, Enable the slow log on the DB. Any queries which are above the threshold variable ( |long_query_time| ) will be logged . Default is 10s, so I assume you'd want to drop this down to 1-2 (

MySQL Shell 1.0.9 GA has been released

Dear MySQL Users, This is the first GA version of MySQL Shell (a component of the MySQL Server). The MySQL Shell is provided under Oracle's dual-license. MySQL Shell is an interactive JavaScript, Python and SQL console interface, supporting development and administration for the MySQL Server.

MySQL Router 2.1.3 GA has been released

Dear MySQL users, MySQL Router 2.1.3 GA is the first GA release 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

Re: Automated SQL checker?

> On Apr 11, 2017, at 1:26 PM, Michael Munger > wrote: > > Use MySQL workbench. Thanks, Michael. I played with it some already and it looks like it will give me a lot to work with. Will it also let me know if field types are wrong for the given

RE: Automated SQL checker?

Use MySQL workbench. Add query to the editor, execute, check results. Then, use the "Execution plan" feature to see how things are executing and look for bad things (Cartesian products, stupid loops, etc...) See also: Query stats. Michael Munger, dCAP, MCPS, MCNPS, MBSS High Powered Help,

Automated SQL checker?

Is there a way, perhaps with a script or a service, that one can check MySQL code to see about making it more efficient? I maintain an open source shopping cart written in Perl and it’s been awhile since the SQL has been worked on, so I want to see if it could use some updating.

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-Master

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-Master

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

[This is part 3 of the announcement] * JSON: When a JSON value consisted of a large sub-document wrapped in many levels of JSON arrays, objects, or both, serialization of the JSON value sometimes required an excessive amount time to complete. (Bug #23031146) *

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

[ This is part 2 of the announcement ] Functionality Added or Changed * InnoDB: By default, InnoDB reads uncommitted data when calculating statistics. In the case of an uncommitted transaction that deletes rows from a table, InnoDB excludes records that are

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

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 of the

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

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 wrote: Am 03.04.2017 um 20:41 schrieb Mahmood N: > Good news! > > I

Re: MySQL server has gone away

Am 03.04.2017 um 20:41 schrieb Mahmood N: 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. well, who did set it that low?

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

Am 03.04.2017 um 19:45 schrieb Mahmood N: So I set long_query_time=5 and restarted the service. Test the email page again. Still the logs are empty WTF - you had it set to 5 seconds 2 hours ago i am out here... Am 03.04.2017 um 18:11 schrieb Mahmood N: > The my.conf file contains >

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

Am 03.04.2017 um 19:26 schrieb Mahmood N: given that a reasonable server should be able to handle hunredts to thousands of requests per second anything above 1 second is a alert sign Excuse me, do you mean higher values are better? I didn't understand. I said in my posts that when I submit

Re: MySQL server has gone away

>given that a reasonable server should be able to >handle hunredts to thousands of requests per second anything above 1 >second is a alert sign Excuse me, do you mean higher values are better? I didn't understand. I said in my posts that when I submit the email test, the refresh time for that

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

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 with

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 wrote: Basically, it says that MySQL is not responding to

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 wrote: >Hi,I am using Moodle which itself uses SQL for the database. Problem is >that, when I run the email plugin

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

Re: seeing errors

On 3/25/2017 10:03 AM, Hal.sz S.ndor wrote: 2017/03/24 15:19 ... william drescher: While loading a database using the mysql command 'source' I see occasional warnings flash by on the screen. when it finished I used the command "show warnings," but only one warning showed (the last one). How

Re: seeing errors

2017/03/24 15:19 ... william drescher: While loading a database using the mysql command 'source' I see occasional warnings flash by on the screen. when it finished I used the command "show warnings," but only one warning showed (the last one). How can I see the warnings earlier in the load ?

seeing errors

While loading a database using the mysql command 'source' I see occasional warnings flash by on the screen. when it finished I used the command "show warnings," but only one warning showed (the last one). How can I see the warnings earlier in the load ? -bill -- MySQL General Mailing

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 or

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,

udf shared library import

I was not able to load a function in udf_example.so.  The response to CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example.so'; is Error Code: 1126. Can't open shared library 'udf_example.so' (errno: 0 /usr/lib64/mysql/plugin/udf_example.so: cannot open shared object file: No such file or

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 of the

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

Optimize table partitions

Good day everyone I hope this mail is finding everyone well. I am asking for some insight again today as I can not seem to find the correct info on the net. Some of our database tables are quite large with millions of records. However due to disk space issues, we have done

Re: multiple domain names mapped to a single IP

Am 02.03.2017 um 16:41 schrieb Bruce Ferrell: There are two ways to approach this: 1.) Turn off name resolution in MySQL and only do the ACL by IP. This is probably best as name resolution can slow the database and cause outright app failure if DNS fails for any reason. 2.) Make absolutely

Re: multiple domain names mapped to a single IP

Kaushal There are two ways to approach this: 1.) Turn off name resolution in MySQL and only do the ACL by IP. This is probably best as name resolution can slow the database and cause outright app failure if DNS fails for any reason. 2.) Make absolutely certain the names resolve correctly in

Re: multiple domain names mapped to a single IP

Am 02.03.2017 um 16:01 schrieb Kaushal Shriyan: Is there any pros and cons to multiple domain names mapped to a single IP work in MySQL client server setup like in case of httpd webserver there is a concept of VHost having multiple domain names mapped to a single IP? For example :-

multiple domain names mapped to a single IP

Hi, Is there any pros and cons to multiple domain names mapped to a single IP work in MySQL client server setup like in case of httpd webserver there is a concept of VHost having multiple domain names mapped to a single IP? For example :- int-mysqldbserver1.example.com :- 192.168.0.11

Re: Changing a field's data in every record

2017/02/18 ... debt: Is there a formula to change the format of the data in a single field in every record of a table? She has a "timestamp” in a text field formatted as 2017|02|16|04|58|42 and she wants to convert it to a more human readable format like 2017-02-16 @ 04:58:42 It

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

Re: Changing a field's data in every record

Am 20.02.2017 um 10:35 schrieb Lucio Chiappetti: On Sat, 18 Feb 2017, debt wrote: How does one "grab" the existing data and then change it? Can this be done solely in MySQL I am not sure to understand your question ... you usually manipulate data inside mysql ... but here it seems

Re: Changing a field's data in every record

On Sat, 18 Feb 2017, debt wrote: How does one "grab" the existing data and then change it? Can this be done solely in MySQL I am not sure to understand your question ... you usually manipulate data inside mysql ... but here it seems to me you are not talking of changing the

Re: Changing a field's data in every record

> On Feb 19, 2017, at 3:50 AM, Brad Barnett wrote: > > SUBSTRING_INDEX Thanks a million, Brad! That works perfectly. SUBSTRING_INDEX didn’t come up in my searches so this is the first I’ve heard of it. Also, as you could see, it wasn’t a true timestamp. It is

Re: Changing a field's data in every record

Erm. I've seen some weird responses to this. Yes, you can do this. First -- get the data into a usable format. Then, put it into a usable format (eg, timestamp for datetime field). Read up on how mysql interprets date/time data on fields. And, create a new timestamp or date field. Then, do

Re: Changing a field's data in every record

Am 19.02.2017 um 11:11 schrieb Peter Brawley: On 2/18/2017 15:13, debt wrote: I’ve been asked to post a question here for a friend. Is there a formula to change the format of the data in a single field in every record of a table? She has a "timestamp” in a text field formatted as

Re: Changing a field's data in every record

On 2/18/2017 15:13, debt wrote: I’ve been asked to post a question here for a friend. Is there a formula to change the format of the data in a single field in every record of a table? She has a "timestamp” in a text field formatted as 2017|02|16|04|58|42 and she wants to

Changing a field's data in every record

I’ve been asked to post a question here for a friend. Is there a formula to change the format of the data in a single field in every record of a table? She has a "timestamp” in a text field formatted as 2017|02|16|04|58|42 and she wants to convert it to a more human readable

[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:

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:

RE: io thread very slow copying binlogs

If you are confident that it's not the network, that pretty much leaves RAM or disk as the source of your problem. Assuming that you are seeing no performance issues on the master (I expect you would have mentioned), let's focus on the slave. The behaviour you describe sounds to me like you

Re: io thread very slow copying binlogs

Hey Morgan, Thanks for the tip. Might come in handy. But, I'm positive it's not a disconnect / reconnect thing. Or, at least not one affected by that timeout. I can do a watch ls -lh in the binlog dir, and see the relay log increasing in size by a M every 4 or 5 seconds or so. About

Re: io thread very slow copying binlogs

I should add that I've turned the SQL thread off, it makes no difference from what I can see... On Fri, 20 Jan 2017 10:31:38 -0500 Brad Barnett wrote: > > > > On Fri, 20 Jan 2017 10:30:09 -0500 > Brad Barnett wrote: > > > > > > > Hey Morgan, > >

RE: io thread very slow copying binlogs

Hi Brad, > MySQL community edition 5.6.29, running Linux. > > Binlogs never seem to get caught up on slaves. > > I've done all I can, to validate that this isn't network or disk related. > > Disk tests (using iostat and other methods) show lots of bandwidth left on > the slave and master. > >

io thread very slow copying binlogs

Hey all, I have a weird issue. MySQL community edition 5.6.29, running Linux. Binlogs never seem to get caught up on slaves. I've done all I can, to validate that this isn't network or disk related. Disk tests (using iostat and other methods) show lots of bandwidth left on the slave and

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

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-Master

Re: kill query and prepared statements

Sorry for the spam, and thanks for you suggestion Johan! http://bugs.mysql.com/bug.php?id=84470 Seb On 01/11/2017 11:21 AM, Johan De Meersman wrote: Seb, You should log a bug at http://bugs.mysql.com - this is not a developer list. /Johan - Original Message - From: "Sebastien

Re: kill query and prepared statements

Seb, You should log a bug at http://bugs.mysql.com - this is not a developer list. /Johan - Original Message - > From: "Sebastien FLAESCH" > To: "MySql" > Sent: Tuesday, 10 January, 2017 14:55:42 > Subject: kill query and prepared statements > Hi

Re: kill query and prepared statements

Just to be clear: This is a hint, to find the real problem, this is NOT A WORKAROUND for us! Seb On 01/10/2017 03:53 PM, Sebastien FLAESCH wrote: Investigating different API calls, to see if it makes a difference... Seems that the problem is related to the read-only cursor type option! If

Re: kill query and prepared statements

Investigating different API calls, to see if it makes a difference... Seems that the problem is related to the read-only cursor type option! If you comment out: unsigned long ct = (unsigned long) CURSOR_TYPE_READ_ONLY; s = mysql_stmt_attr_set(stmt, STMT_ATTR_CURSOR_TYPE, (const void *)

kill query and prepared statements

Hi all, I have reported this problem before, but I raise it again, since I still get this problem with 5.7.17 See attached code: I want to interrupt a long running statement with CTRL-C by starting a new connect to make a KILL QUERY. I am using the same technique as the mysql client code.

mysql Archiving engine

Good day all Compliments of the season to everyone and I hope that this mail finds all well. I am trying to find out a bit more regarding the archiving storage engine. We currently have an archiving process that the dev team wrote for archiving of data. However, management

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 at:

[ANN] QxOrm 1.4.3 and QxEntityEditor 1.2.1 released : the Qt ORM supports CMake and provides a new QxEntityEditor documentation

Hello, QxOrm library 1.4.3 and QxEntityEditor application 1.2.1 just released : http://www.qxorm.com/ The Qt ORM library now supports CMake and provides a new QxEntityEditor documentation : http://www.qxorm.com/qxorm_en/manual_qxee.html QxOrm library 1.4.3 changes log : - Support CMake : new

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

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 of the

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 the

Re: audit trails

Hi, On 8/12/2016 18:39, mach...@seworx.co.za wrote: ... So to recap what has been done for now : - Triggers to insert a record in audit table to show the table, type of query(insert/update) and who made the relevant change. - Trigger to prevent

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