List:General Discussion« Previous MessageNext Message »
From:Brent Clark Date:June 21 2012 10:39am
Subject:Re: Indexing about 40 Billion Entries
View as plain text  
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
Thread
Indexing about 40 Billion EntriesChristian Koetteritzsch20 Jun
  • Re: Indexing about 40 Billion EntriesAnanda Kumar20 Jun
    • RE: Indexing about 40 Billion EntriesRick James20 Jun
      • Re: Indexing about 40 Billion EntriesChristian Koetteritzsch20 Jun
        • Re: Indexing about 40 Billion EntriesChristian Koetteritzsch20 Jun
        • RE: Indexing about 40 Billion EntriesRick James20 Jun
          • Re: Indexing about 40 Billion EntriesChristian Koetteritzsch21 Jun
            • Re: Indexing about 40 Billion Entriesmos21 Jun
              • Re: Indexing about 40 Billion EntriesChristian Koetteritzsch21 Jun
              • RE: Indexing about 40 Billion EntriesRick James21 Jun
          • UNION and ORDER BYhsv22 Jun
            • RE: UNION and ORDER BYRick James22 Jun
  • Re: Indexing about 40 Billion EntriesShawn Green20 Jun
    • RE: Indexing about 40 Billion EntriesRick James20 Jun
  • Re: Indexing about 40 Billion EntriesBrent Clark21 Jun