Both on the same database and same user?

|
svart 2021-11-11 00:11:41
so… you insert 1 row. then update it and in the meanwhile you observer amount of “locked rows” is million? is it correct?
madno 2021-11-11 00:12:42
Yes , lock is in slave and on a partitioned table
svart 2021-11-11 00:13:53
I understand that. what is binlog_format? can you share innodb status via external link?
madno 2021-11-11 00:14:46
Binlog format is row
madno 2021-11-11 00:15:14
Give me a min for the status link
svart 2021-11-11 00:17:30
would be nice if you wil share the output of “show full processlist” as well
madno 2021-11-11 00:17:56
Ok
madno 2021-11-11 00:22:04
But I thing I noticed that if there is no partition and I add *created* to the PK , so new PK becomes (id, created)..same row locks is happening…
madno 2021-11-11 00:26:44
hereis the full processlist and innodb status
madno 2021-11-11 00:28:54
https://www.toptal.com/developers/hastebin/relufaguhi.yaml
madno 2021-11-11 00:41:01
https://www.toptal.com/developers/hastebin/obuyilafuf.yaml
madno 2021-11-11 00:41:28
madno 2021-11-11 00:41:01
https://www.toptal.com/developers/hastebin/obuyilafuf.yaml

added table definition here. Please check

svart 2021-11-11 00:52:34
questions: 1) could you please show the update statement? 2) are you able to reproduce the issue without the “update” statement, i.e. with only insert statement? 3) how much rows in the partition where inserted record located?
madno 2021-11-11 00:53:49
svart 2021-11-11 00:52:34
questions: 1) could you please show the update statement? 2) are you able to reproduce the issue without the “update” statement, i.e. with only insert statement? 3) how much rows in the partition where inserted record located?

Ok will try out this and share

madno 2021-11-11 06:24:33
svart 2021-11-11 00:52:34
questions: 1) could you please show the update statement? 2) are you able to reproduce the issue without the “update” statement, i.e. with only insert statement? 3) how much rows in the partition where inserted record located?

https://www.toptal.com/developers/hastebin/zicaludoha.shell

madno 2021-11-11 06:25:44
svart 2021-11-11 00:52:34
questions: 1) could you please show the update statement? 2) are you able to reproduce the issue without the “update” statement, i.e. with only insert statement? 3) how much rows in the partition where inserted record located?

for 3), not sure how to check that

madno 2021-11-11 06:29:41
added innodb status
https://www.toptal.com/developers/hastebin/orobuwuwup.sql
Yoga2369 2021-11-11 17:23:06
Any group/forum for Ingres database?
MdAsgarindia 2021-11-11 17:54:37
HI FRIENDS
MdAsgarindia 2021-11-11 17:54:53
i have one customer table
MdAsgarindia 2021-11-11 17:55:16
mysql_en-13954.jpg

MdAsgarindia 2021-11-11 17:56:07
mysql_en-13955.jpg
I am trying to get the data based on state name then it’s showing blank
MdAsgarindia 2021-11-11 17:56:17
can someone help me in this
Yoga2369 2021-11-11 18:48:09
MdAsgarindia 2021-11-11 17:56:07
I am trying to get the data based on state name then it’s showing blank

Both on the same database and same user?

MdAsgarindia 2021-11-11 19:30:46
Yoga2369 2021-11-11 18:48:09
Both on the same database and same user?

Yes

Yoga2369 2021-11-11 19:31:33
Disconnect and try again
MdAsgarindia 2021-11-11 22:36:02
mysql_en-13965.jpg
Hi
i have a customer table
MdAsgarindia 2021-11-11 22:36:03
mysql_en-13967.jpg
when i am trying to get average age of customer whose region is north , i am getting null as result
MdAsgarindia 2021-11-11 22:36:03
can someone help me here
k_karsh 2021-11-12 00:01:48
MdAsgarindia 2021-11-11 22:36:03
when i am trying to get average age of customer whose region is north , i am getting null as result

Do u have any records from east region?

k_karsh 2021-11-12 00:03:31
mysql_en-13969.jpg

MdAsgarindia 2021-11-12 00:16:00
k_karsh 2021-11-12 00:01:48
Do u have any records from east region?

Yes it have

Yoga2369 2021-11-12 06:38:35
MdAsgarindia 2021-11-11 22:36:03
when i am trying to get average age of customer whose region is north , i am getting null as result

Check any of your row has null in age column

MdAsgarindia 2021-11-12 06:39:46
Yoga2369 2021-11-12 06:38:35
Check any of your row has null in age column

i haved checked and it doesn’t have any null valu

rodrigo_tc7 2021-11-12 08:24:10
Is your column case sensitive?
|