sorry, I did not know about it.
Thanks for the response.
On deep dive I could realize that the position table seems to be the culprit as the rows are as high as 71 million.
https://www.traccar.org/forums/topic/postion-table-mysql-optimize/
You have any idea how we can optimize this or partition this and use without affecting the core traccar working ?
Are there any particular configuration file parameters to be used for Teletonika FMB920 devices when they are being used with GT06, TK103 and TK101.
As position updates for all devices are affected once these devices start moving.