Where i can change innodb_lock_wait_timeout?

Locked
User avatar
frajer
Posts: 29
Joined: Thu 23. Apr 2020, 22:00

Where i can change innodb_lock_wait_timeout?

Post by frajer »

Hello, im having issues with database, and i have to increase "innodb_lock_wait_timeout".
I tried to find it in KeyHelp Admin Control Panel and User Control Panel, but i didnt find it :(

Where i can find this function/thing?

Thanks!
User avatar
Jolinar
Community Moderator
Posts: 3560
Joined: Sat 30. Jan 2016, 07:11
Location: Weimar (Thüringen)
Contact:

Re: Where i can change innodb_lock_wait_timeout?

Post by Jolinar »

frajer wrote: Tue 28. Apr 2020, 17:13 Where i can find this function/thing?
Specific MySQL Settings may be stored and changed within /etc/mysql/mariadb.conf.d/90-tuning.cnf
Wenn jemand inkompetent ist, dann kann er nicht wissen, daß er inkompetent ist. (David Dunning)

Data Collector für Community Support
___
Ich verwende zwei verschiedene Schriftfarben in meinen Beiträgen /
I use two different font colors in my posts:
  • In dieser Farbe schreibe ich als Moderator und gebe moderative Hinweise oder begründe moderative Eingriffe /
    In this color, I write as a moderator and provide moderative guidance or justify moderative interventions
  • In dieser Farbe schreibe ich als Community Mitglied und teile meine private Meinung und persönlichen Ansichten mit /
    In this color, I write as a community member and share my personal opinions and views
User avatar
frajer
Posts: 29
Joined: Thu 23. Apr 2020, 22:00

Re: Where i can change innodb_lock_wait_timeout?

Post by frajer »

I think its a wrong file, because after setting higher value, i'm still having issues with query error 1205.


EDIT: I tried to setup higher value in PMA, but my db user doesn't have SUPER permissions.
User avatar
Jolinar
Community Moderator
Posts: 3560
Joined: Sat 30. Jan 2016, 07:11
Location: Weimar (Thüringen)
Contact:

Re: Where i can change innodb_lock_wait_timeout?

Post by Jolinar »

Please post the content of your 90-tuning.cnf.
Wenn jemand inkompetent ist, dann kann er nicht wissen, daß er inkompetent ist. (David Dunning)

Data Collector für Community Support
___
Ich verwende zwei verschiedene Schriftfarben in meinen Beiträgen /
I use two different font colors in my posts:
  • In dieser Farbe schreibe ich als Moderator und gebe moderative Hinweise oder begründe moderative Eingriffe /
    In this color, I write as a moderator and provide moderative guidance or justify moderative interventions
  • In dieser Farbe schreibe ich als Community Mitglied und teile meine private Meinung und persönlichen Ansichten mit /
    In this color, I write as a community member and share my personal opinions and views
User avatar
frajer
Posts: 29
Joined: Thu 23. Apr 2020, 22:00

Re: Where i can change innodb_lock_wait_timeout?

Post by frajer »

#
# KeyHelp Tuning Settings
# System-Memory > 2 GB
#

[mysqld]

# mySQL Tuning
max_connections = 2000
key_buffer_size = 250M
max_allowed_packet = 64M
thread_stack = 256K
tmp_table_size = 128M
max_heap_table_size = 128M
thread_cache_size = 128
table_cache = 8192
table_definition_cache = 4096
open_files_limit = 16544

# InnoDB Configuration
innodb_file_per_table = 1
innodb_buffer_pool_size = 500M
innodb_lock_wait_timeout = 120
# Query Cache Configuration
query_cache_limit = 256M
query_cache_size = 2G
query_cache_type = 1

EDIT: MY VPS -
16 gb ram
8 cpus
160gb ssd
1gb uplink

apache 2.4
ubuntu 18.04
keyhelp 20.0
maria db 10.1.44
php 7.2.24 / i changed it to 7.4.3
Locked