| 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