Upgarding to lastest version

kirandev92

Hello, We are currently planning to upgrade our production from osticket (v1.10.1-79-g4bd0bd9) to lastest osticket v1.18. During out testing on a test setup we observerd that the upgarde procedure is taking around 3-4 hours. Is this expected duration? Note: We have huge number of tickets logged into our system till date.

DB Size: 30 GB

Hardware specifications:
RAM: 64GB
Processor: Intel(R) Xeon(R) CPU E5-2603 v4 @ 1.70GHz
CPU's: 6

KevinTheJedi

kirandev92

Your db server is simply not able to handle such load which is why it’s taking forever. You need to optimize MySQL and dedicate more resources so it’s faster. This has nothing to do with osTicket itself.

Cheers.

kirandev92

Thanks for the response. Let's say I have the ideal hardware in place and mysql optimzed. How long's the ideal upgrade time fron version v1.10 to v1.18 ?

KevinTheJedi

kirandev92

Depends on how much your server can handle. A typical database with say ₃ GB should take around 1-3 minutes at most. The more data you have the more the system has to work to apply the patches. Some patches since v1.10 generates a new table, copies data, and deletes the old table which can take some time especially if you have a ton of data and/or mysql is slow.

Cheers.