From: Brent Clark
Date: June 21 2012 10:39am
Subject: Re: Indexing about 40 Billion Entries
List-Archive: http://lists.mysql.com/mysql/227717
Message-Id: <4FE2F9EE.9000009@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit


On 20/06/2012 11:45, Christian Koetteritzsch wrote:
> Hi guys,
>
> As the title says I'm trying to index 40 billion entries with two indexes on a server with 16 cores and 128GB RAM. The table is the one below and it is a myisam table. The *.myd file is about 640GB
>

Hiya

I am unable to help. But one question that was running through my mind, as I was reading this is:

How do you do your backups?

I use mylvmbackup on a slave master replication server, but I would love to know how or what you use and do your backups.

Hope you come right with your problem.

Thanks
Brent