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
- Original Message -
From: Chris Knipe sav...@savage.za.org
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
On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman vegiv...@tuxera.be wrote:
- Original Message -
From: Chris Knipe sav...@savage.za.org
To: mysql@lists.mysql.com
Sent: Thursday, 24 July, 2014 11:17:50 AM
Subject: Avoiding table scans...
mysql SELECT MIN(ArtNumber) AS ArtNumber
Il 24/07/14 11:57, Chris Knipe ha scritto:
On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman vegiv...@tuxera.be
wrote:
- Original Message -
From: Chris Knipe sav...@savage.za.org
To: mysql@lists.mysql.com
Sent: Thursday, 24 July, 2014 11:17:50 AM
Subject: Avoiding table scans
Try this
SELECT ArtNumber, MessageID FROM 78168ea0a9b3b513a1f2d39b559b406e WHERE
ArtNumber=(SELECT MIN(ArtNumber) FROM 78168ea0a9b3b513a1f2d39b559b406e
WHERE ArtNumber2118806)
+---+---+
| ArtNumber | MessageID
|
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 ArtNumber