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
