[Maria-developers] problem with update and myisam
hi guys, could anyone help me with https://mariadb.atlassian.net/browse/MDEV-6355 thanks -- Roberto Spadim
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@spadim.com.br> wrote: Subject: [Maria-developers] problem with update and myisam To: "maria-developers@lists.launchpad.net" <maria-developers@lists.launchpad.net> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
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@yahoo.com> 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@spadim.com.br <javascript:;>> wrote:
Subject: [Maria-developers] problem with update and myisam To: "maria-developers@lists.launchpad.net <javascript:;>" < maria-developers@lists.launchpad.net <javascript:;>> 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@lists.launchpad.net <javascript:;> Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
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@spadim.com.br> 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@yahoo.com <javascript:_e(%7B%7D,'cvml','james.briggs@yahoo.com');>> 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@spadim.com.br> wrote:
Subject: [Maria-developers] problem with update and myisam To: "maria-developers@lists.launchpad.net" < maria-developers@lists.launchpad.net> 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@lists.launchpad.net 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
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@spadim.com.br>:
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@spadim.com.br> 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@yahoo.com> 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@spadim.com.br> wrote:
Subject: [Maria-developers] problem with update and myisam To: "maria-developers@lists.launchpad.net" < maria-developers@lists.launchpad.net> 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@lists.launchpad.net 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
the problem was the internet connection, now i'm with a better internet to test, sorry the results: with ()=() 5 seconds with field=const, 0,06seconds 2014-06-18 0:05 GMT-03:00 Roberto Spadim <roberto@spadim.com.br>:
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@spadim.com.br>:
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@spadim.com.br> 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@yahoo.com> 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@spadim.com.br> wrote:
Subject: [Maria-developers] problem with update and myisam To: "maria-developers@lists.launchpad.net" < maria-developers@lists.launchpad.net> 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@lists.launchpad.net 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
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
participants (2)
-
James Briggs -
Roberto Spadim