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!
Where i can change innodb_lock_wait_timeout?
- Jolinar
- Community Moderator
- Posts: 3607
- Joined: Sat 30. Jan 2016, 07:11
- Location: Weimar (Thüringen)
- Contact:
Re: Where i can change innodb_lock_wait_timeout?
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:
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
Re: Where i can change innodb_lock_wait_timeout?
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.
EDIT: I tried to setup higher value in PMA, but my db user doesn't have SUPER permissions.
- Jolinar
- Community Moderator
- Posts: 3607
- Joined: Sat 30. Jan 2016, 07:11
- Location: Weimar (Thüringen)
- Contact:
Re: Where i can change innodb_lock_wait_timeout?
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:
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
Re: Where i can change innodb_lock_wait_timeout?
#
# 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
# 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