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
> 78168ea0a9b
>
>
> 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
&
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>
- 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 WH
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