Hi, You can dump databases without locking tables.
-Wei On Tuesday, 20 December 2022, Gary Dixon <gary.di...@quadris.co.uk.invalid> wrote: > Hi all > > > > CS v4.15.2 > > Hypervisor = KVM > > > > We have started to experience an issue on a frequent basis where the CS > mgmt. service is losing the connection to the database and believe it is > being caused by mysqldumps locking the tables. > > Looking at the db.properties file there are tuning parameters : > > # CloudStack database tuning parameters > > db.cloud.maxActive=250 > > db.cloud.maxIdle=30 > > db.cloud.maxWait=10000 > > db.cloud.validationQuery=SELECT 1 > > db.cloud.testOnBorrow=true > > db.cloud.testWhileIdle=true > > db.cloud.timeBetweenEvictionRunsMillis=40000 > > db.cloud.minEvictableIdleTimeMillis=240000 > > db.cloud.poolPreparedStatements=false > > db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true& > sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_ > IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'& > serverTimezone=UTC > > > > would changing the ‘maxwait’ value to a higher value stop the mgmt. > service losing the db connection whilst dumps are taken ? > > BR > > > > Gary > > > > > Gary Dixon > Senior Technical Consultant > T: +44 161 537 4990 > E: *v* <+44%207989717661>ms@quadris‑support.com > W: www.quadris.co.uk > The information contained in this e-mail from Quadris may be confidential > and privileged for the private use of the named recipient. The contents of > this e-mail may not necessarily represent the official views of Quadris. > If you have received this information in error you must not copy, > distribute or take any action or reliance on its contents. Please destroy > any hard copies and delete this message. >
