Optimisation Wrapper

DeZ7 years ago

Hello

I have around 250 vehicle and i keep 70 days of positions

Each device send around 100 positions by minute and my positions table is around 50 Go

How can i increase the wrapper process ?

For information i don't use geocode

I have logger.level set to all

And in wrapper.log i have this error :

FINEST|3492/0|Service traccar|17-08-25 00:02:11|Fri Aug 25 00:02:11 CEST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

Thanks

Anton Tananaev7 years ago

What do you want to increase?

DeZ7 years ago

i show a difference between fixtime and servertime.

I have a gap of 30 minutes.

But i don't know if it's due the communication delay or the traitment delay.

How can i check this ?

My server is not overloaded, mysql and traccar use around 2% of cpu, and mysql compute 800 Mo of RAM and traccar 250 Mo.

And more can you tell me why i have this error :

FINEST|3492/0|Service traccar|17-08-25 00:02:11|Fri Aug 25 00:02:11 CEST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

Thanks

Anton Tananaev7 years ago

Please ignore this error. That's not a problem.

250 MB of memory sounds too low. I would recommend to increate it.

DeZ7 years ago

Ok thanks, how can i increase this ?

Anton Tananaev7 years ago

Please read YAJSW documentation for details:

http://yajsw.sourceforge.net/YAJSW%20Configuration%20Parameters.html

DeZ7 years ago

Anton,

I add this in wrapper.conf

wrapper.java.initmemory=512

How can i explain or investigate about the gap between fixtime (or devicetime) and servertime ?

And for your information i add verifyServerCertificate=false in connection string parameter in traccar.xml and i don't have any error message about SSL in wrapper.log

<entry key='database.url'>jdbc:mysql://localhost:3306/traccar?allowMultiQueries=true&verifyServerCertificate=false& ...

Thanks

Anton Tananaev7 years ago

Have you looked at the logs? Is there delay between connection, HEX data and decoded position? Is there delay with log time?

DeZ7 years ago

Anton,

I have this for example

2017-08-29 11:18:02 DEBUG: [EB2C39A9: 5027 < 72.5] HEX: 000000000000034b08040000015e2d34594a0...
2017-08-29 11:18:02 DEBUG: [EB2C39A9: 5027 > 72.5] HEX: 00000004
...
2017-08-29 11:18:02  INFO: [EB2C39A9] id: 35..., time: 2017-08-29 10:55:59, lat: 49.63804, lon: 5.85074, speed: 44.3, course: 97.0
2017-08-29 11:18:02  INFO: [EB2C39A9] id: 35..., time: 2017-08-29 10:56:03, lat: 49.63797, lon: 5.85199, speed: 44.3, course: 95.0
...
2017-08-29 11:18:02  INFO: [EB2C39A9] id: 35..., time: 2017-08-29 10:56:04, lat: 49.63795, lon: 5.85230, speed: 44.3, course: 94.0
...
2017-08-29 11:18:02  INFO: [EB2C39A9] id: 35..., time: 2017-08-29 10:56:05, lat: 49.63794, lon: 5.85262, speed: 44.3, course: 94.0

How can i see connection step in log ?

Thanks

Anton Tananaev7 years ago

I don't see any delay, so I suspect it's device problem.

DeZ7 years ago

Ok thanks, i will check with teltonika

Flavio Dantas5 years ago

Hello Anton!
I hope you're well.
Greetings from Brazil from the city of Natal - RN!
I hereby support to find a situation that I believe is very peculiar.
I have noticed that daily between 8:00 pm and 10:00 pm on my linode the CPU spikes and the tracing application is left without access.
My services is hosted at https://www.linode.com/ and server and a vps with 4 cores CPU, 8 GB RAM, 160 GB SSD Storage, 5 TB Transfer 40 Gbps Network In 5000 Mbps Network Out I use PostgreSQL BD istanciado in AWS. I have at most 65 devices.
During the day the CPU gets maximum with 5% of consumption.
I have already used several resources to monitor and I can not locate the problem. The log does not generate information that indicates the problem
5 Linux commands to monitor CPU usage
1 - Top Command
2 - htop command
3 - netstat Command
4 - Vmstat Command
5 - ps command

In view of the above I request support so that you can standardize parameters and solve problems without risk of losses.
No more thank you for your valuable attention.

Flavio Dantas