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 > >
