re: gaps in data stored to mariadb

[Paul Coleman]

I have data coming into earthworm and being written to a mariadb database but the data presents with gaps. Screenshot 2025-01-07 151018.png shows an image taken from swarm and all station databases look the same with the gap. The other screenshot show a snippet of sniffwave and all the stations are streaming information without gaps. I also attached the getmenu results, mysql's error.log and mysqls' server config file, in the hope someone can steer me in the direction of a solution. p.s. the data is being streamed to 2 server simultaneously and only one presents with the problem... The tables for the database are InnoDB.

[Stefan Lisowski]

If the tables really are InnoDB that's a problem. Winston doesn't
perform well with engines other than MyISAM.

Back up your database before you try this, but maybe this will help your
performance:

select concat('alter table ',table_schema,'.',table_name,'
engine=MyISAM;')
from information_schema.tables
where engine = 'InnoDB';

should get you a list of commands you can run to convert Winston to
MyISAM. (Obviously only run this on the Winston tables, this query will
show all tables that are InnoDB.)

> --
> --
> You received this message because you are subscribed to the Google
> Groups "Earthworm Community Forum" group.
>
> To post to this group, send an email to earthwo...@googlegroups.com
>
> To unsubscribe from this group, send an email to
> earthworm_for...@googlegroups.com
>
> For more options, visit this group at
> http://groups.google.com/group/earthworm_forum?hl=en <http://
> groups.google.com/group/earthworm_forum?hl=en>
>
> ---
> You received this message because you are subscribed to the Google
> Groups "Earthworm Community Forum" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to earthworm_for...@googlegroups.com
> <mailto:earthworm_for...@googlegroups.com>.
> To view this discussion visit https://groups.google.com/d/msgid/
> earthworm_forum/3b0c5557-257a-41d4-adaa-2cfe0e272aa3n%40googlegroups.com
> <https://groups.google.com/d/msgid/earthworm_forum/3b0c5557-257a-41d4-
> adaa-2cfe0e272aa3n%40googlegroups.com?utm_medium=email&utm_source=footer>.


--








*To follow ISTI news and updates please subscribe to our newsletter
"the isti letter" at  https://www.isti.com/newsletter-sign-up
<https://www.isti.com/newsletter-sign-up>.*