Many thanks Aravind, I've started to go through some of those ideas, appreciated. It is not an indexes thing but good shout there.
I noticed the free memory take a nose dive very very low when GoCD is starting up, and when that message is displayed it dwindles down and down and then eventually gets to around 100mb free before rising up again as Java disappears from 'top'. I've checked the memory profile and its quite different from the original machine - almost 2gb less RAM and no swap at all. I'll get those changed and try again tomorrow. I expected to see some Hibernate logging but can't see any so I'll try and get the logback-include tweaked to help there and report back. Many thanks Michael On Mon, 15 Mar 2021 at 20:47, Aravind SV <[email protected]> wrote: > Yes, 17.11 is quite old and it’s hard to say what the problem could be. A > couple of things I’d look at: > > 1. Run: kill -3 go-server-process-id and it will show you stack > traces, which might tell you what the main thread is doing. > 2. The pipeline timeline update query is quite time consuming, but > everything else being the same, it should be as fast as the older setup. > Maybe some DB indexes are missing? > 3. You could see if the same behaviour is seen if you move to a new DB > schema on the old DB server itself to remove any suspicion on the new DB > server’s performance. > > I notice a lot of the backup and restore docs speak about backup and > restoring the db but it isn’t clear whether there is any data that would > stop you loading that dump up in a different location or not - something > specific to the ’old home’ of the db data that you’d need to amend before > you could use that as the database for a newer system. > > I don’t think there is anything like that. > > Cheers, > Aravind > -- You received this message because you are subscribed to the Google Groups "go-cd" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/CAPb0%3D%2BQKOVoC6nRnRmNt2cem67QyqzcpjzXNn9%2Bdr3AwzyMDxw%40mail.gmail.com.
