List:General Discussion« Previous MessageNext Message »
From:Dominik Klein Date:November 27 2006 11:18am
Subject:Re: Performance Problems With Two Tables With Over 500K Rows
View as plain text  
>> My innodb_buffer_pool_size is:
>> innodb_buffer_pool_size         | 8388608
>>
>> That looks like 8MB... that sounds small if I have a DB with over 1M
>> rows to process.  No?
> 
> Yes, that's extremely small.  I'd go for at least 256M, and maybe 512M
> if your machine will primarily be doing mysql duties.
> 

Did you do this yet?

This should speed it up imho.

Regards
Dominik
Thread
Performance Problems With Two Tables With Over 500K RowsJohn Kopanas25 Nov
  • Re: Performance Problems With Two Tables With Over 500K RowsJohn Kopanas26 Nov
    • Re: Re: Performance Problems With Two Tables With Over 500K RowsJohn Kopanas26 Nov
      • Re: Re: Re: Performance Problems With Two Tables With Over 500K RowsDan Buettner26 Nov
        • Re: Re: Re: Re: Performance Problems With Two Tables With Over 500K RowsJohn Kopanas27 Nov
  • Re: Performance Problems With Two Tables With Over 500K RowsDan Nelson26 Nov
    • Re: Re: Performance Problems With Two Tables With Over 500K RowsJohn Kopanas27 Nov
      • Re: Performance Problems With Two Tables With Over 500K RowsDan Nelson27 Nov
        • Re: Re: Performance Problems With Two Tables With Over 500K RowsJohn Kopanas27 Nov
          • Re: Performance Problems With Two Tables With Over 500K RowsDan Nelson27 Nov
            • Re: Re: Performance Problems With Two Tables With Over 500K RowsJohn Kopanas27 Nov
          • Re: Re: Performance Problems With Two Tables With Over 500KRowsmos27 Nov
        • Re: Performance Problems With Two Tables With Over 500K RowsDominik Klein27 Nov
  • Re: Performance Problems With Two Tables With Over 500K RowsDuncan Hill27 Nov