Re: Indexing about 40 Billion Entries

[Brent Clark]

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