sorry guys, maybe i was a bit confuse the solution of field=const and field=const ... worked
thanks, please close mdev-6355 2014-06-17 21:29 GMT-03:00 Roberto Spadim <[email protected]>: > 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]> >> 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 > > -- 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
