Check if autocommit is off

Em dom, 12 de abr de 2020 às 17:12, Armando B. <hmandevteam@gmail.com> escreveu:

Hi Roberto,

thanks for your response.

I using InnoDB but not transaction, i use only insert statement without beginTransaction(), commit() and rollBack().

Il giorno sab 28 mar 2020 alle ore 16:28 Roberto Spadim <roberto@spadim.com.br> ha scritto:

Probably you are using transaction and not commiting

Em sáb, 28 de mar de 2020 às 06:01, Armando B. <hmandevteam@gmail.com> escreveu:

Hi all,

i have a MariaDB Server (10.1.35) with an InnoDB and a table with an Autoincrement ID field and some other data (no foreign keys but only index). This table have few records (~10000) that are increased with a csv import each some weeks.

I saw that sometimes, after import process, some records are hidden and come out after some time (also 40 min.)

could you help me ?

Armando

--

  Themonospot http://github.com/armando-basile/themonospot/
  Monosim http://github.com/armando-basile/monosim/
  Comex-Project http://github.com/armando-basile/comex-project/
  ViviVasto app https://play.google.com/store/apps/details?id=com.armandobasile.vivivasto

  vdr-getchannels - https://github.com/armando-basile/vdr-getchannels

  vdr-scripts - https://github.com/armando-basile/vdr-scripts

  

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

--

Roberto Spadim
SPAEmpresarial - Software ERP/Scada

Eng. Automação e Controle, Eng. Financeira

--

  Themonospot http://github.com/armando-basile/themonospot/
  Monosim http://github.com/armando-basile/monosim/
  Comex-Project http://github.com/armando-basile/comex-project/
  ViviVasto app https://play.google.com/store/apps/details?id=com.armandobasile.vivivasto

  vdr-getchannels - https://github.com/armando-basile/vdr-getchannels

  vdr-scripts - https://github.com/armando-basile/vdr-scripts

  

--

Roberto Spadim
SPAEmpresarial - Software ERP/Scada

Eng. Automação e Controle, Eng. Financeira