Hi Cansu, Using your configurations I was about to load the database in less than 1:30 hours. So huge difference.
Thank you very much. Leonardo On Mon, May 28, 2012 at 9:53 PM, Leonardo Piga <[email protected]> wrote: > Thanks, Cansu. 'wa' is high (86% for the core mysql is executing). > > I did some estimations and I am writting about 67 friends per second. > It will take 34 more hours to finish. I will wait since I have already > waited 3 days. > > Tomorrow I will compare your my.cnf with mine and I will let you know. > > Thanks again, > > Leonardo > > > On Mon, May 28, 2012 at 11:28 PM, Cansu Kaynak <[email protected]> wrote: >> Dear Leonardo, >> Most probably, this is because of the disk write latency that the insertion >> operations are exposed to. You can verify it by checking the vmstat output, >> the 'wa' field. >> If the wait time is high, please compare your MySQL configuration parameters >> with the ones in my.cnf, >> under apache-olio-php-src-0.2/webapp/php/trunk/etc/. >> In particular, make sure that the buffer pool and log buffer are large (need >> tuning depending on the aggregate memory size). >> Moreover, make sure that innodb_doublewrite >> and innodb_flush_log_at_trx_commit parameters are set to 0 and 2 >> respectively as in my.cnf, so that the database is exposed to the disk >> latency at the minimum. >> >> -- >> Cansu >> >> >> >> >> On May 29, 2012, at 12:54 AM, Leonardo Piga wrote: >> >> Hello, >> >> I am setting up the Web Serving Benchmark, but the dbload too is >> taking too much time. >> >> I set the scale factor to 12000, the tool is running for 4 days and >> has generated more than 9GB of data. However, the process seems too >> slow for me. >> >> What load scale do you suggest for populating the Olio database. How >> long does it take to generate the data? >> >> Thank you >> >> --Leonardo >> >>
