Hi, we've experienced errors on cms new install with mariadb 10, we've tested on servers with mysql and there is no problems at all. Problem is a very high io mariadb process that leads sometimes to a timeout on cms install. No error on logs.
Also directadmin itself timeouts deleting a db or trying to access to mysql control with
Either your request was invalid or the program hasn't completed your request.
Please notify the server admin.
We'd like to know if someone have seen similar errors before doing the downgrade to mysql cause seems a bit odd this happens with cms pretty common like wp or prestashop or da itself.
This is the conf file:
[server]
max_allowed_packet = 200M
max_connections = 400
query_cache_size = 8M
tmp_table_size = 16M
max_heap_table_size = 16M
thread_cache_size = 4
table_open_cache = 400
innodb_buffer_pool_size = 1G
innodb_buffer_pool_instances =1
Tried to debug mariadb with this debug doc without luck:
https://mariadb.com/kb/en/mariadb/debugging-a-running-server-on-linux/
Regards
Also directadmin itself timeouts deleting a db or trying to access to mysql control with
Either your request was invalid or the program hasn't completed your request.
Please notify the server admin.
We'd like to know if someone have seen similar errors before doing the downgrade to mysql cause seems a bit odd this happens with cms pretty common like wp or prestashop or da itself.
This is the conf file:
[server]
max_allowed_packet = 200M
max_connections = 400
query_cache_size = 8M
tmp_table_size = 16M
max_heap_table_size = 16M
thread_cache_size = 4
table_open_cache = 400
innodb_buffer_pool_size = 1G
innodb_buffer_pool_instances =1
Tried to debug mariadb with this debug doc without luck:
https://mariadb.com/kb/en/mariadb/debugging-a-running-server-on-linux/
Regards