Dear MySQL users,
MySQL Connector/Python 2.0.0-alpha is the first alpha version of
2.0 release series of the pure Python database driver for MySQL.
It is intended to introduce users to the new features.
This release is not feature complete but it should be stable
enough for users to understand
Hi Chris,
> -Original Message-
> From: Chris Knipe [mailto:sav...@savage.za.org]
> Sent: Thursday, 24 July 2014 19:18
> To: mysql@lists.mysql.com
> Subject: Avoiding table scans...
>
> mysql> SELECT MIN(ArtNumber) AS ArtNumber, MessageID FROM
> 78168ea0a9b3b513a1f2d39b559b406e WHERE ArtNu
>
>
> Try this
>
> SELECT ArtNumber, MessageID FROM 78168ea0a9b3b513a1f2d39b559b406e WHERE
> ArtNumber=(SELECT MIN(ArtNumber) FROM 78168ea0a9b3b513a1f2d39b559b406e
> WHERE ArtNumber>2118806)
>
>
+---+---+
| ArtNumber | MessageID
|
Il 24/07/14 11:57, Chris Knipe ha scritto:
> On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman
> wrote:
>> - Original Message -
>>> From: "Chris Knipe"
>>> To: mysql@lists.mysql.com
>>> Sent: Thursday, 24 July, 2014 11:17:50 AM
>>> Subject: Avoiding table scans...
>>>
>>> mysql> SELECT
On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman wrote:
> - Original Message -
>> From: "Chris Knipe"
>> To: mysql@lists.mysql.com
>> Sent: Thursday, 24 July, 2014 11:17:50 AM
>> Subject: Avoiding table scans...
>>
>> mysql> SELECT MIN(ArtNumber) AS ArtNumber, MessageID FROM
>> 78168ea
- Original Message -
> From: "Chris Knipe"
> To: mysql@lists.mysql.com
> Sent: Thursday, 24 July, 2014 11:17:50 AM
> Subject: Avoiding table scans...
>
> mysql> SELECT MIN(ArtNumber) AS ArtNumber, MessageID FROM
> 78168ea0a9b3b513a1f2d39b559b406e WHERE ArtNumber > '2118806';
You're putti
Hi All,
I have a couple of *huge* tables, they're still busy populating, but once
done I suspect it will hold well over 3 billion records (and that's more
than likely the start of the problem).
The mysql server is a highly optimized, powerful server with some 128GB ram,
data + binlogs on RAID10 S
