#Database Delay to execute a query

1 messages · Page 1 of 1 (latest)

timid estuary
# 
[      script:oxmysql] UPDATE kartik_banking_cards SET balance = balance + ? WHERE card_number = ? [5000,"4267794582167958"]```

- Tried changing vps 
- increasing the allocated RAM to MariaDB

Stack: HEIDI SQL, MariaDB, Qbox
topaz cairn
#

Lots of duplicate entries.

timid estuary
topaz cairn
#

In that wall of text it's unable to insert because a duplicate key entry is being made.

timid estuary
#

any fastest way to resolve this?

hearty trail
#

i don't know if this helps but have you tried restarting mariadb? i usually encounter this if the database had been running for some time and from what I've observed is that it slows down overtime.

plain harness
#

I be having this same issue. So restarting maridb would fix this? I have to try that.

timid estuary
#

I haven't got time to tell the dev to try as I'm not into tech stuff much related to database