autocommit <https://mariadb.com/kb/en/library/server-system-variables/#sysvar_autocommit> ON
Il giorno lun 13 apr 2020 alle ore 01:46 Roberto Spadim < robe...@spadim.com.br> ha scritto: > Check if autocommit is off > > Em dom, 12 de abr de 2020 às 17:12, Armando B. <hmandevt...@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 < >> robe...@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. <hmandevt...@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 > -- 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