maria-developers team mailing list archive

[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
> <javascript:_e(%7B%7D,'cvml','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