Hi Jordan Rookie query regarding mysql performance
Will increase or decreasing the value of "max_connections" in mysql.cnf help in the cloudstack database performance? [mysqld] innodb_rollback_on_timeout=1 innodb_lock_wait_timeout=600 max_connections=350 log-bin=mysql-bin binlog-format = 'ROW' server-id=source-01 innodb_rollback_on_timeout=1 innodb_lock_wait_timeout=600 max_connections=350 log-bin=mysql-bin binlog-format = 'ROW' Regards Kiran ________________________________ From: jordan j <yordan...@gmail.com> Sent: 02 February 2023 13:24 To: users@cloudstack.apache.org <users@cloudstack.apache.org> Subject: Re: understand Cloudstack Database performance During some analysis I noticed that Cloudstack does not send more than 2000 queries to the database. Is there a way to increase that value? With the current setup creating a /16 network takes about 70 seconds. I found a variable on the CS global settings called details.batch.query.size which is 2000 and increased it to 5000. However after CS reboot the amount of queries going to the database still did not pass more than 2000. Does anyone know where the value of the database query limit is? Regards, Jordan On Tue, Jan 31, 2023 at 2:58 AM jordan j <yordan...@gmail.com> wrote: > Hello everyone! > > ACS 4.17.2 with a separate database. ACS currently has no vm instances. > > While creating some /16 user networks we noticed some timeouts on the API. > After some tests - the smaller the new network the less the issues. > > Checking the database - there were 600 slow queries on average. > The db server is separate - 8gb of ram and 6gb given for > innodb_buffer_pool_size. > Buffing the vm RAM to 64 gb did not help. > > What did help was increasing join_buffer_size to 64MB. > > Optimization tips in the docs do not give much info: page > https://docs.cloudstack.apache.org/en/latest/adminguide/tuning.html > > Is there an optimization guide that has to be done for CS to perform > normally? > Are there any rules that need to be followed while scaling the > infrastructure? > > Regards, > Jordan >
