No filesystem errors No hardware error No smartctl error Disk read test runs at constant180mb/s per disk (linux md raid 1) without problems (via dd if=disk1(2,3,4) of=/dev/null) No problema at mdstat Using xfs filesystem ---
Im traveling now with time i will update database and check handler variables to see ehat happened Em terça-feira, 17 de junho de 2014, Roberto Spadim <[email protected]> escreveu: > Hi guys > > Well thats a update at a field with a where with full primary key fields > > Where with > (Fields)=(consts) or > field=const and field=const ... > > Work the same way with same time > > ---- > > Yes thats a bigint field (with int i got same problem) > the first partition is used for negative values > And others partitions to positive values > I'm running update only at negative values all others rows > (partitions) with positive value only have insert, no updates and no delete > > I'm using the primary key at where clausule in other words i'm using a > unique key or a unique index. I'm updating a field without indexes (a field > not indexed) > > I don't know why the mariadb stop 5 seconds or more, since it's a > partition with less than 1000 rows and no index field was changed > > > Any ideas? > > > > > > Em terça-feira, 17 de junho de 2014, James Briggs <[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> escreveu: > >> Hi Roberto. >> >> 1) nf is a bigint, so why are you inserting a string value ('-18')? >> 2) is there some reason you aren't using indexes? >> 3) after you resolve 1 and 2, do repair table. >> >> Thanks, James. >> >> -------------------------------------------- >> On Tue, 6/17/14, Roberto Spadim <[email protected]> wrote: >> >> Subject: [Maria-developers] problem with update and myisam >> To: "[email protected]" < >> [email protected]> >> Date: Tuesday, June 17, 2014, 1:31 PM >> >> hi guys, could anyone >> help me with https://mariadb.atlassian.net/browse/MDEV-6355 >> thanks >> >> >> -- >> Roberto Spadim >> >> >> -----Inline Attachment Follows----- >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-developers >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~maria-developers >> More help : https://help.launchpad.net/ListHelp >> >> > > -- > Roberto Spadim > SPAEmpresarial > Eng. Automação e Controle > > -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
