Quote from bulli on December 16, 2024, 19:14
Hello Pablo, we use our own server with Plesk, php 8.3.14, debian 12 and MariaDB 10.11.6.
Our server uses 64GB RAM, one
AMD Ryzen 7 PRO 8700GE w/ Radeon 780M Graphics (16 core(s)) processor and our search is not as fast as yours.
What are we doing wrong? Do you have specific settings?
Currently it looks like this:
/etc/mysql/mariadb.conf.d/50-server.cnf
max_connections = 500
wait_timeout = 300
interactive_timeout = 300
innodb_buffer_pool_size = 12G
innodb_log_file_size = 5G
innodb_flush_log_at_trx_commit = 2
query_cache_size = 0
innodb_read_io_threads = 8
innodb_write_io_threads = 8
innodb_buffer_pool_instances = 8
innodb_lru_scan_depth = 2048
innodb_purge_threads = 4
innodb_thread_concurrency = 0
innodb_buffer_pool_chunk_size = 128M
join_buffer_size = 1M
max_allowed_packet = 64M
innodb_log_buffer_size = 64M
innodb_strict_mode = 1
performance_schema = OFF
Is that right?
query_cache_type = 0
tmp_table_size = 512M
max_heap_table_size = 512M
table_open_cache = 10000
table_definition_cache = 10000
thread_cache_size = 150
innodb_flush_method = O_DIRECT_NO_FSYNC
innodb_io_capacity = 1000
innodb_io_capacity_max = 1500
innodb_flush_neighbors = 0
innodb_random_read_ahead = ON
innodb_read_ahead_threshold = 32
THX for Support
Hello Pablo, we use our own server with Plesk, php 8.3.14, debian 12 and MariaDB 10.11.6.
Our server uses 64GB RAM, one
AMD Ryzen 7 PRO 8700GE w/ Radeon 780M Graphics (16 core(s)) processor and our search is not as fast as yours.
What are we doing wrong? Do you have specific settings?
Currently it looks like this:
/etc/mysql/mariadb.conf.d/50-server.cnf
max_connections = 500
wait_timeout = 300
interactive_timeout = 300
innodb_buffer_pool_size = 12G
innodb_log_file_size = 5G
innodb_flush_log_at_trx_commit = 2
query_cache_size = 0
innodb_read_io_threads = 8
innodb_write_io_threads = 8
innodb_buffer_pool_instances = 8
innodb_lru_scan_depth = 2048
innodb_purge_threads = 4
innodb_thread_concurrency = 0
innodb_buffer_pool_chunk_size = 128M
join_buffer_size = 1M
max_allowed_packet = 64M
innodb_log_buffer_size = 64M
innodb_strict_mode = 1
performance_schema = OFF
Is that right?
query_cache_type = 0
tmp_table_size = 512M
max_heap_table_size = 512M
table_open_cache = 10000
table_definition_cache = 10000
thread_cache_size = 150
innodb_flush_method = O_DIRECT_NO_FSYNC
innodb_io_capacity = 1000
innodb_io_capacity_max = 1500
innodb_flush_neighbors = 0
innodb_random_read_ahead = ON
innodb_read_ahead_threshold = 32
THX for Support