maria-developers team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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 <roberto@xxxxxxxxxxxxx>:

> 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 <roberto@xxxxxxxxxxxxx>
> 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 <james.briggs@xxxxxxxxx>
>> 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 <roberto@xxxxxxxxxxxxx> wrote:
>>>
>>>  Subject: [Maria-developers] problem with update and myisam
>>>  To: "maria-developers@xxxxxxxxxxxxxxxxxxx" <
>>> maria-developers@xxxxxxxxxxxxxxxxxxx>
>>>  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     : maria-developers@xxxxxxxxxxxxxxxxxxx
>>>  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