mysql - Slow Confluence during SQL Script Run -


we have issue regarding our atlassian confluence system.

basically have server shares our primary load of sql scripts data transformation production portion of month, our confluence , jira collaboration system.

notably - have noticed huge slow-downs when running large scripts , trying access confluence pages regardless of operation on confluence (render page, edit page, create page)...they bogged down , end waiting quite few seconds happen.

we started logging transaction levels. follows:

turned on general , slow query logs while script running.

noticed excessive activity confluence during time: number of sql statements issues rom 12:33:01pm 13:27:16pm:

  1. confluence 144,691
  2. jira 6,940

for confluence that's 43.85 statement per second. confluence statements, top were:

commit 38,286
set autocommit=1 28,519
rollback 27,809 set autocommit=0 27,809
set session transaction isolation level read committed 27,809
set session transaction isolation level repeatable read 27,809
select @@session.tx_isolation 712

main concerns in bold

so question is... confluence doing issuing many transaction level reads in short of time frame...?

even internal processing looking @ db should not looking @ db many times, whether it's security check or render data...

so again, confluence doing? if knows...is way operates? interested know if other peoples confluence logs show relative measurements...

why slowing down ? resource - sharing issue?

thanks in advance!

confluence can have it's database isolation level configured @ session level, or can rely on mysql's global configuration.

my guess confluence instance setting isolation level once per session. try configuring isolation level globally. instructions on how can found in confluence knowledge base

basically, need add

transaction-isolation=read-committed

to my.cnf file

more speaking, might review confluence installation guide mysql , make sure database configured way recommend (see https://confluence.atlassian.com/display/doc/database+setup+for+mysql#databasesetupformysql-step3.configuremysqlserver).


Comments

Post a Comment

Popular posts from this blog

monitor web browser programmatically in Android? -

i've got tricky question here. need users make payment bank (namely barclaycard) in uk. so, have https url , add parameters (such amount pay, order reference, etc) url, start http connection intent.actionview, redirect user browser can enter credit card details on bank's webpage , make payment our account successfully. far ? the code use below (i changed values privacy reasons) problem is, need app when user has completed/failed/cancelled payment. barclaycardautomatically redirects particular url when payment has succeeded, 1 if failed. there no way of knowing when barclaycard payment has succeeded go android app somehow ? button cardbutton = (button) findviewbyid(r.id.card_button); cardbutton.setonclicklistener(new view.onclicklistener() { @override public void onclick(view arg0) { string prehashstring = new string(); string prohashstring = new string(); string shapassphrase = new string(); shapassphrase = "gsvth£h70zkh...
Read more

Shrink a YouTube video to responsive width -

i have youtube video embedded on our website , when shrink screen tablet or phone sizes stops shrinking @ around 560px in width. standard youtube videos or there can add code make go smaller? you can make youtube videos responsive css. wrap iframe in div class of "videowrapper" , apply following styles: .videowrapper { float: none; clear: both; width: 100%; position: relative; padding-bottom: 56.25%; padding-top: 25px; height: 0; } .videowrapper iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } the .videowrapper div should inside responsive element. padding on .videowrapper necessary keep video collapsing. may have tweak numbers depending upon layout.
Read more

wpf - PdfWriter.GetInstance throws System.NullReferenceException -

i'm trying create pdf document using itextsharp 5.3.4 using following document document = new document(); filestream stm = new filestream(filename, filemode.create); pdfwriter writer = pdfwriter.getinstance(document, stm); i'm getting system.nullreferenceexception following stack trace: system.nullreferenceexception occurred hresult=-2147467261 message=la référence d'objet n'est pas définie à une instance d'un objet. source=itextsharp stacktrace: à itextsharp.text.version.getinstance() innerexception: i've verified neither document nor stm null, , if select "continue" in vs12 document created - exception thrown. updated itextsharp 5.4.0 , it's still occurring. can't find information on anywhere - got ideas? make sure not catching exceptions. nullreferenceexception can 1 caught , handled inside itextsharp, don't care it. fact can continue supports theory. change following setting verify: debug -> exceptions ...
Read more