2 questions about the olio with MySQL

["Fang, Xiang" <xi...@intel.com>]

Hi Shanti and Akara,

After I change the mysql wait_timeout and interactive_timeout to 40 seconds, the too many connections was partial resolved.

But I got another issue, when olio workload was running in steady state, the user CPU utilization of MySQL machine was continue increasing with falcon engine, after it reached about 100%, there was many timeout happened in client. With innodb engine, the CPU utilization was also continue increasing also.

Do you think this is reasonable?

Another question is about the client timeout, currently I found it was 30 seconds, can we change this value? If it is, why do you choose this value? does this value match to real world?

Thanks very much,
Xiang