Re: find any row with NULL

- Original Message - > From: "lejeczek" > Subject: Re: find any row with NULL > ok, whereas that fist example was about all (and find > columns' names without knowing) columns - would there be a > simple(r) syntax to find that (not)NULLs in a list of given > column

Re: find any row with NULL

- Original Message - > From: "lejeczek" > Subject: Re: find any row with NULL > > shame NULL won't work as in: > > select user_id,completetion_time from depression where > NULL in(email_me, other_diagnosis); > or does it? No, because NULL != NULL - it is why there

Re: find any row with NULL

On 09/07/16 14:13, Hal.sz S.ndor wrote: 2016/07/08 09:15 ... Johan De Meersman: You will have to repeat all the column names - no wildcards in where clause fieldnames - but the clause you're looking for is WHERE field IS NULL. Or IS NOT NULL if you want those:-) Well, one could try this:

ANN: DAC for MySQL 3.0.6 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 Enterprise Backup 4.0.2 has been released

Dear MySQL users, MySQL Enterprise Backup v4.0.2, 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

ANN: Beta of the Database Designer for MySQL 2.1.8 is out!

This beta introduces brand new SSH tunneling machinery out of the box! No 3rd party solutions should be installed. Also, there is a more flexible solution for columns default values implemented. From now and on developer may control if these values are quoted or not, allowing set empty strings or

MySQL Cluster 7.2.25 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: check_mysql_health poll

Useful knowledge, thank you, Shawn. Good to see confirmed that qcache_hits + com_select is the global total - that's not always very clear in the docs. I just noticed that when I copied the list for extra exposure, I didn't actually say what I was exposing :-p Gerhard Laußer, who maintains

Re: check_mysql_health poll

On 7/15/2016 6:58 AM, Johan De Meersman wrote: Hey, I just happened upon your poll, so I'm sending you brief mail because I have a different opinion still :-) I'm also CCing the MySQL list, as I feel that more input on this might be a good thing - and it's worth some exposure anyway. I

check_mysql_health poll

Hey, I just happened upon your poll, so I'm sending you brief mail because I have a different opinion still :-) I'm also CCing the MySQL list, as I feel that more input on this might be a good thing - and it's worth some exposure anyway. I believe there are two distinct measures that can be

Re: find any row with NULL

- Original Message - > From: "Sándor Halász" > Subject: Re: find any row with NULL > > from information_schema.columns where (table_schema, table_name, You could, but information_schema queries can get pretty slow on large databases, especially so with InnoDB. Recent

Re: Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work

I did the following test: My program still uses MySQL 5.7 libmysqlclient.so, but I connect now to a 5.6.16 server. And the SQL interrupt works fine... so I suspect there is a MySQL server issue in 5.7. Seb On 07/12/2016 01:01 PM, Sebastien FLAESCH wrote: About: > B) For some reason, the

Re: Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work

About: > B) For some reason, the program does not want to exit() - (must investigate) In fact we use prepared statements with a sequence of mysql_stmt_init, mysql_stmt_prepare, mysql_stmt_execute, mysql_stmt_fetch, ... and mysql_stmt_close. After the statement was interrupted, we try to free

Re: find any row with NULL

2016/07/08 09:15 ... Johan De Meersman: You will have to repeat all the column names - no wildcards in where clause fieldnames - but the clause you're looking for is WHERE field IS NULL. Or IS NOT NULL if you want those:-) Well, one could try this: set @sel=(select 'SELECT ' ||

Re: find any row with NULL

On 7/8/2016 9:15 AM, Johan De Meersman wrote: As a clear example of what it is useful for, imagine a situation where you're performing an inventory on an existing warehouse. You have the list of all the products they've ever sold, but you need to differentiate between 'this product is not in

Re: find any row with NULL

You will have to repeat all the column names - no wildcards in where clause fieldnames - but the clause you're looking for is WHERE field IS NULL. Or IS NOT NULL if you want those :-) Remember, NULL is a special value that is not the same as zero or the empty string; nor to itself: NULL !=

find any row with NULL

hi there, I've been searching the vastness of the net but cannot find - how - to get all the rows with a NULL. And like any novice I wonder if this can be done without reiterating all the columns names(not manually at least)? Some expert would say it is easy, how easy is it? with an

mysqld_multi doesn't support !include or !includedir directives

Hi, I try to use !includedir directive with mysqld_multi for load other option files but nothing is loaded by mysql. In the default my.cnf, I have only the includedir directive for my configuration directory : !includedir /etc/my.cnf.d And in /etc/my.cnf.d/mysql3306.cnf I have :

Re: parallel installations of mysql

> From: Reindl Harald > > Am 03.07.2016 um 04:47 schrieb Martin Mueller: >> If port 3306 is taken, how is one supposed to know that 3307 is a good >> alternative? Why not 3317 or 3703 > > seriously? > > when this is your point about bad documentation than you just

... ERROR! The server quit without updating PID file

I ran into the problem referred to in the subject line. It seems to be fairly common, to judge from stuff on the Internet, but none of the explanations or solutions offered there were of any help to me. I run MySql 5.22 on a Mac desktop with El Capitan, but the MySQL installation is inherited

Query interruption with MySQL 5.7 using KILL QUERY in signal handler does no more work

Hi all, I use the following technique to cancel a long running query: In the SIGINT signal handler, I restart a connection and I perform a KILL QUERY mysql-process-id-of-running-query This was working find with MySQL 5.6. But with 5.7 (5.7.11), we get now a different result: A) The query

Re: parallel installations of mysql

Am 03.07.2016 um 04:47 schrieb Martin Mueller: If port 3306 is taken, how is one supposed to know that 3307 is a good alternative? Why not 3317 or 3703 seriously? when this is your point about bad documentation than you just don't have a point - there is no "good alternive". ist's only a

Re: parallel installations of mysql

Thanks. That’s helpful and makes me think that there may be a “Mac hole” in the MySQL documentation. Windows is one thing and Linux another. OS X is sort of Unix, but only sort of, and the conventions are not as firmly established. For instance, the instructions for the MySQl Sandbox—on the

Re: parallel installations of mysql

Am 03.07.2016 um 00:49 schrieb Martin Mueller: After struggling for several hours with installing an alternate installation of MySQL, I’ve concluded that this may be beyond my feeble powers but also that the official instructions are not very good. They are written for system administrators

Re: parallel installations of mysql

2016/07/02 18:49 ... Martin Mueller: It’s clear from Section 6.6 of the Reference manual that I need to make sure that the new installation differs from the old one with regard to the data directory, the port number, the socket, the shared memory-base-name, and the pid-file. It’s less clear

Re: parallel installations of mysql

Dear Mr. Green, After struggling for several hours with installing an alternate installation of MySQL, I’ve concluded that this may be beyond my feeble powers but also that the official instructions are not very good. They are written for system administrators who are doing work of this kind

Re: corrupt INNO table

Am 02.07.2016 um 16:49 schrieb Martin Mueller: I run MySQL 5.6 on OS 10.11. There is a table that appears to be corrupt: it does not respond to queries, and the command to drop it does not execute. The database seems to be OK in other respects. What can I do to get rid of the table? Would

corrupt INNO table

I run MySQL 5.6 on OS 10.11. There is a table that appears to be corrupt: it does not respond to queries, and the command to drop it does not execute. The database seems to be OK in other respects. What can I do to get rid of the table? Would it be safe just to remove the two .frm and .ibd

MySQL Connector/NET 6.8.8 has been released

Dear MySQL users, MySQL Connector/Net 6.8.8 is a maintenance release for the 6.8.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

MySQL Connector/NET 6.9.9 has been released

Dear MySQL users, MySQL Connector/Net 6.9.9 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

Re: signal handling in mysql cli

Hello Sebastien, You should stop top-posting, it inverts the flow of your investigation making it harder to follow. (see bottom) On 6/21/2016 12:45 PM, Sebastien FLAESCH wrote: The process list show my (killed) thread as follows: mysql> show processlist;

[ANN] Mroonga 6.06 - storage engine, fast fulltext search, CJK ready

Hi, Mroonga 6.06 has been released! ## What is Mroonga? 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/ The characteristics of Mroonga:

MySQL Connector/J 6.0.3 m2 Development Release has been released

Dear MySQL users, MySQL Connector/J 6.0.3 m2 Development Release is a developer milestone release for the 6.0.x series. It is the second public release of the current Connector/J 6.0 development branch, providing an insight to upcoming features. Although some of these are still under

MySQL Connector/J 6.0.3 m2 Development Release has been released

Dear MySQL users, MySQL Connector/J 6.0.3 m2 Development Release is a developer milestone release for the 6.0.x series. It is the second public release of the current Connector/J 6.0 development branch, providing an insight to upcoming features. Although some of these are still under

MySQL Connector/Node.js 1.0.3 m2 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.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

Re: signal handling in mysql cli

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

Re: signal handling in mysql cli

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

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

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,

Fwd: GTID SUSPENDING

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?

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

Precautions to not run out of disk space?

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

MySQL Connector/NET 7.0.3 m2 development has been released

Dear MySQL users, MySQL Connector/Net 7.0.3 is the second development release of MySQL Connector/Net to add support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax

Re: call the appropriate and correct database

- Original Message - > From: "HaidarPesebe" > Subject: call the appropriate and correct database > How do I call first database table as follows : > > id | country | province | distric | cost > > 1 | USA |

call the appropriate and correct database

How do I call first database table as follows : id | country | province | distric | cost 1 | USA | Alanama | distrik | 20 2 | USA | Alabama | distrik2 | 22 3 | USA | Alabama | distrik3 | 22 4 | France | Paris | disrik4 | 30 now I use 3 kinds of

MySQL Workbench 6.3.7 GA has been released

Dear MySQL users, The MySQL developer tools team announces 6.3.7 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 Community Server 5.7.13 has been released

Dear MySQL users, MySQL Server 5.7.13, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.13 is recommended for use on production systems. Since MySQL Server 5.7.12, we have introduced the concept of Rapid Plugins. Out of the box, 5.7.13 follows

MySQL Community Server 5.7.13 has been released

Dear MySQL users, MySQL Server 5.7.13, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.13 is recommended for use on production systems. Since MySQL Server 5.7.12, we have introduced the concept of Rapid Plugins. Out of the box, 5.7.13 follows

MySQL Community Server 5.6.31 has been released

Dear MySQL users, MySQL Server 5.6.31, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.31 is recommended for use on production systems. For an overview of what's new in MySQL 5.6, please see

MySQL Community Server 5.5.50 has been released

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

MySQL Cluster 7.5.2 has been released (part 2/2)

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.5.2 has been released (part 1/2)

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

alter table and 'something wrong in indexes'?

Hi! I use mysql/innodb tables on aws services in a small table (about 2M records) I changed some columns datatypes from unsigned int to decimal and from float to decimal I didn't change anything about primary key or other indexes after the change (done without troubles), all my queries where

Re: understanding the binlog

- On May 20, 2016, at 8:38 PM, Bernd Lentes bernd.len...@helmholtz-muenchen.de wrote: > Hi, > > i'm currently creating a replication and got in contact with the binlog. I use > row-based logging. I read already the doc but i still have some questions. > Maybe you can help me. > > An

Re: Adding values returned by GREATEST

2016/05/14 16:23 ... shawn l.green: > ... If the numeric > value is quoted, it is still interpreted as an index if there is no > matching string in the list of enumeration values. One of the many cases where I believe that MySQL s attempt to be helpful by converting is not helpful. Thus it

MySQL doesn't shutdown cleanly sometimes

Hi all, I have a fresh install of Ubuntu 16.04 LTS Server x64 in a VirtualBox VM with its provided MySQL, without any additional databases currently. Sometimes the shutdown of MySQL itself fails with the logs looking like the following: > 2016-05-20T12:59:28.924585Z 0 [Note] InnoDB: FTS optimize

understanding the binlog

Hi, i'm currently creating a replication and got in contact with the binlog. I use row-based logging. I read already the doc but i still have some questions. Maybe you can help me. An excerp from a relay-log: # at 329 #160520 17:00:01 server id 1 end_log_pos 259 Query thread_id=94

ANN: Database Designer for MySQL 2.1.7 released!

New maintenance release introduces JSON type support. Full change log: [!] JSON type support added! [-] "Rare EStringListError during Table editor opening" bug fixed You're welcome to download the Database Designer for MySQL 2.1.7 right now at:

Re: Adding values returned by GREATEST

On 5/14/2016 2:57 PM, Peter Brawley wrote: On 5/14/2016 11:16, shawn l.green wrote: Hello Sukhjinder, On 5/3/2016 8:55 AM, Sukhjinder K. Narula wrote: Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql,

Re: Adding values returned by GREATEST

On 5/14/2016 11:16, shawn l.green wrote: Hello Sukhjinder, On 5/3/2016 8:55 AM, Sukhjinder K. Narula wrote: Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql, so a query is like below: For example table t

Re: Adding values returned by GREATEST

Hello Sukhjinder, On 5/3/2016 8:55 AM, Sukhjinder K. Narula wrote: Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql, so a query is like below: For example table t has 6 fields with values as follows: A =

MySQL Connector/J 5.1.39 has been released

Hello all, MySQL Connector Java 5.1.39, a maintenance release of the production 5.1 branch, has been released. Connector/J is a Type-IV pure-Java JDBC driver for MySQL, supporting the JDBC 4.2 API. It is suitable for use with MySQL server versions 5.5, 5.6, and 5.7. MySQL Connector Java is

Memory leak caused by query table meta data?

Hi there, We know that normally Mysql is good at controlling memory usage but the problem we are seeing is a bit suspicious. I want to ask for help to see whether somebody can help on debugging the issue. Feel free to let me know if there are more details needed. The databases we have are all

Reformat: Connector/Python and calling stored procedures with backticks

Hi again, Sorry about the bad formatting of my previous e-mail.Hopefully this copy will be more readable, or else I will just leave it at that. I have also included some extra info at the bottom that might be relevant. Hi, everyone I'm having trouble using MySQL Connector/Python's

Connector/Python and calling stored procedures with backticks

Hi, everyone I'm having trouble using MySQL Connector/Python's cursor.callproc() method to call stored procedures whose names include backticks. Here is the entire traceback (with minor redactions): Traceback (most recent call last): File "C:\Users\[...]\Bottle\Website\website.py", line 108,

Re: utf8 options under Mysql

2016/04/22 04:49 ... Jigal van Hemert: It works for a lot of Western European languages very well, but in some cases there are problems. For Asian languages there are a lot more problems. For example, 'ß' isn't considered the same as 'ss'. Well, the former is an sz-ligature, and the latter is a

Adding values returned by GREATEST

Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql, so a query is like below: For example table t has 6 fields with values as follows: A = 1, B = 3, C=0, D = 0, E = 1 and F = 0 and I run a query: SELECT

Re: slave to master

On 4/30/2016 3:22 AM, Thomas wrote: Am Freitag, 29. April 2016, 14:49:57 schrieb william drescher: On 4/28/2016 5:20 PM, Thomas wrote: Hi, I have setup an master slave replication. This works fine. I have running an Apache webserver and some other programms accessing the master. Whats the

Re: slave to master

Am Freitag, 29. April 2016, 14:49:57 schrieb william drescher: > On 4/28/2016 5:20 PM, Thomas wrote: > > Hi, > > > > I have setup an master slave replication. > > This works fine. > > I have running an Apache webserver and some other programms accessing the > > master. > > Whats the standard

Re: slave to master

Am 29.04.2016 um 20:49 schrieb william drescher: On 4/28/2016 5:20 PM, Thomas wrote: Hi, I have setup an master slave replication. This works fine. I have running an Apache webserver and some other programms accessing the master. Whats the standard pocedure if master fail? I want to start

Re: slave to master

Am 29.04.2016 um 22:22 schrieb Mahmoud Alshinhab: I was think of it from the cloud prospective, as for example you can guarantee that Amazon's Elastic Load Balancer won't be a single point of failure, so I was thinking how can I use MariaDB MaxScale and in the same time guarantee that it won't

Re: slave to master

I was think of it from the cloud prospective, as for example you can guarantee that Amazon's Elastic Load Balancer won't be a single point of failure, so I was thinking how can I use MariaDB MaxScale and in the same time guarantee that it won't be a single point of failure. -- Eng. Mahmoud

Re: slave to master

On 4/28/2016 5:20 PM, Thomas wrote: Hi, I have setup an master slave replication. This works fine. I have running an Apache webserver and some other programms accessing the master. Whats the standard pocedure if master fail? I want to start up the programms on the slave by hand and then they

Re: slave to master

Am 29.04.2016 um 17:27 schrieb Mahmoud Alshinhab: I also like the MariaDB Max scale that Reindl Harald Sent -Thanks- However I don't know if it is possible to use 2 servers of the max scale with a load balancer in front of them or not. I always try to avoid the Single Point of Failure get

Re: slave to master

I also like the MariaDB Max scale that Reindl Harald Sent -Thanks- However I don't know if it is possible to use 2 servers of the max scale with a load balancer in front of them or not. I always try to avoid the Single Point of Failure.

Re: slave to master

Am 29.04.2016 um 17:20 schrieb Mahmoud Alshinhab: Master/slave connection selection It’s the application that has to decide to use master or slave connection (the master connection is set by default). Switching the type of connection is done by using JDBC connection.setReadOnly(boolean

Re: slave to master

I quote this from the page[1]: Load balancing implementation Random picking When initializing a connection or after a failed connection, the connector will attempt to connect to a host with a certain role (slave/master). The connection is selected randomly among the valid hosts. Thereafter, all

Re: slave to master

It was actually built for Amazon's Aurora, but it should work with any mysql-compatible protoco. -- Eng. Mahmoud Alshinhab AWS Cloud Support Engineer Fedora Ambassador Wiki : https://fedoraproject.org/wiki/User:Tuxawy mahmoud.alshin...@gmail.com tux...@fedoraproject.org On Fri, Apr 29, 2016 at

Re: slave to master

Am 29.04.2016 um 15:07 schrieb Johan De Meersman: From: "Mahmoud Alshinhab" Subject: Re: slave to master I think you should have a look at MariaDB Connector[1]. It provides Load balancing and failover as Failover occurs when a connection to a primary database

Re: slave to master

> From: "Mahmoud Alshinhab" > Subject: Re: slave to master > I think you should have a look at MariaDB Connector[1]. > It provides Load balancing and failover as Failover occurs when a connection > to > a primary database server fails and the connector will open up

Re: slave to master

Hi, I think you should have a look at MariaDB Connector[1]. It provides Load balancing and failover as Failover occurs when a connection to a primary database server fails and the connector will open up a connection to another database server. For example, server A has the current connection.

Re: slave to master

- Original Message - > From: "Jason Mallory" > Subject: RE: slave to master > > Master-master with load balancer would be best That's a bit brief, isn't it? :-) It's more than worth pointing out that your loadbalancer should not actually be loadbalancing the

RE: slave to master

Master-master with load balancer would be best Jason Mallory, MySQL/SQL Server DBA p: +1.480.752.1198 | m: +1.480.823.7771 | f: +1. 480.752.1105  |  www.iridium.com The information contained in this email is strictly

slave to master

Hi, I have setup an master slave replication. This works fine. I have running an Apache webserver and some other programms accessing the master. Whats the standard pocedure if master fail? I want to start up the programms on the slave by hand and then they are accessing the mySQL slave. Can

ANN: DAC for MySQL 3.0.5 meets RAD Studio 10.1 Berlin!

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.

using indices with SMALL tables

I am regularly using indices on medium-big tables (1000 to > 5 entries), and even on temporary tables (which I use a lot) in joins (EXPLAIN SELECT is your friend). But I'd never thought indices were needed for small tables (100-200 entries). I recently found they are useful too, and I'd

Re: utf8 options under Mysql

Hi, On 22/04/2016 04:50, Martin Mueller wrote: MySQL has a bewildering variety of unicode collation choices. Most of them are language specific, but what is the difference between "utf8-general-ci", "utf8-unicode-ci", and "utf8-unicode-520-ci." Do they differ in the range of characters they

utf8 options under Mysql

MySQL has a bewildering variety of unicode collation choices. Most of them are language specific, but what is the difference between "utf8-general-ci", "utf8-unicode-ci", and "utf8-unicode-520-ci." Do they differ in the range of characters they can handle or is it just a matter of the cort

Re: Lost Connection Upon Loading Dump

On 4/21/2016 10:51, Stephen R Guglielmo wrote: Hello, I have a empty db that I'm trying to load a .sql file (created via mysqldump) into. The dump has 791611 lines and is 807 MB. Loading the dump is consistently failing at line 1763. Line 1763 is an INSERT statement. The line is 95610

Re: parallel installations of mysql

On 4/20/2016 2:04 PM, Martin Mueller wrote: I am running MySQL 5.6.22 on an iMac as a desktop database. I would like to install 5.7.12. Can I install it as a parallel and independent instance? And if so, are there special problems to watch out for? Why would I want to do this? Well, I

Lost Connection Upon Loading Dump

Hello, I have a empty db that I'm trying to load a .sql file (created via mysqldump) into. The dump has 791611 lines and is 807 MB. Loading the dump is consistently failing at line 1763. Line 1763 is an INSERT statement. The line is 95610 characters long. The error is: ERROR 2013 (HY000) at line

Re: parallel installations of mysql

That works nicely, you just need to make sure that you set up the second instance on a different port, with different data and log directories etc. Do you expect many issues from the upgrade? In most cases, an in-place upgrade should work the same or better than the old version :-) -

parallel installations of mysql

I am running MySQL 5.6.22 on an iMac as a desktop database. I would like to install 5.7.12. Can I install it as a parallel and independent instance? And if so, are there special problems to watch out for? Why would I want to do this? Well, I have a set of databases and tables on the old

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

Dear all, Benetl, a free ETL tool for MySQL, is out in version 4.7. This new version is providing some code optimizations, performance and tests coverage improvement. This version provides also two corrections : - correcting one bug in debug mode. - correcting one bug in logging system. You

MySQL Cluster 7.2.24 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 Connector/NET 7.0.2 m1 Development Release has been released

Dear MySQL users, MySQL Connector/Net 7.0.2 M1 is the first development release of MySQL Connector/Net to add support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like

MySQL Connector/J 6.0.2 m1 Development Release has been released

Dear MySQL users, MySQL Connector/J 6.0.2 m1 Development Release is a developer milestone release for the 6.0.x series. It is the first public release of the current Connector/J 6.0 development branch, providing an insight to upcoming features. Although some of these are still under

MySQL for Visual Studio 2.0.2 m1 Development Release has been released

Dear MySQL users, MySQL for Visual Studio 2.0.2 M1 is the first development release of the MySQL for Visual Studio 2.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 Community Server 5.6.30 has been released

Dear MySQL users, MySQL Server 5.6.30, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.30 is recommended for use on production systems. For an overview of what's new in MySQL 5.6, please see

MySQL Connector/Node.js 1.0.2 m1 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.2 M1, is the first 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

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