Page 1 of 1
Where i can change innodb_lock_wait_timeout?
Posted: Tue 28. Apr 2020, 17:13
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!
Re: Where i can change innodb_lock_wait_timeout?
Posted: Tue 28. Apr 2020, 19:04
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
Re: Where i can change innodb_lock_wait_timeout?
Posted: Thu 30. Apr 2020, 11:10
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.
Re: Where i can change innodb_lock_wait_timeout?
Posted: Thu 30. Apr 2020, 11:48
by Jolinar
Please post the content of your 90-tuning.cnf.
Re: Where i can change innodb_lock_wait_timeout?
Posted: Thu 30. Apr 2020, 11:58
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