MariaDB optimieren Hilfe

MariaDB optimieren.

Hi!

Habe folgendes Problem:
auf dem Server ist ne Software installiert, welche mit MariaDB läuft.

Wenn ich nun von anderen PC´s im Netzwerk auf die Software bzw. MariaDB zugreife, werden die Zugriffe sehr langsam und das System oder die Software wird träge ohne Ende.
Kann ich da was an den Einstellungen in MariaDB in der my.ini ändern ?

Anbei der Inhalt der my.ini -Datei :

1. Example MariaDB config file for very large systems.

#

1. This is for a large system with memory of 1G-2G where the system runs mainly
2. MariaDB.

#

1. MariaDB programs look for option files in a set of
2. locations which depend on the deployment platform.
3. You can copy this option file to one of those
4. locations. For information about these locations, do:
5. 'my_print_defaults --help' and see what is printed under
6. Default options are read from the following files in the given order:
7. More information at: http://dev.mysql.com/doc/mysql/en/option-files.html

#

1. In this file, you can use all long options that a program supports.
2. If you want to know which options a program supports, run the program
3. with the "--help" option.

1. The following options will be passed to all MySQL clients

[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock

1. Here follows entries for some specific programs

1. The MySQL server

[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M

1. Try number of CPU's*2 for thread_concurrency

thread_concurrency = 8

1. Alte Passwortlänge verwenden

old-passwords

#Path to installation directory. All paths are usually resolved relative to this.
basedir=C:/Programme/MariaDB 10.1/data

#Path to the database root
datadir=C:/Programme/MariaDB 10.1/data

1. The default character set that will be used when a new schema or table is
2. created and no character set is defined

default-character-set=latin1

1. The default storage engine that will be used when create new tables when

default-storage-engine=INNODB

1. Replication Master Server (default)
2. binary logging is required for replication

log-bin=mysql-bin

1. required unique id between 1 and 2^32 - 1
2. defaults to 1 if master-host is not set
3. but will not function as a master if omitted

server-id = 1

1. Uncomment the following if you are using InnoDB tables

innodb_data_home_dir = C:/Programme/MariaDB 10.1/data
#innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_group_home_dir = C:/Programme/MariaDB 10.1/data

1. You can set .._buffer_pool_size up to 50 - 80 %
2. of RAM but beware of setting memory usage too high

innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M

1. Set .._log_file_size to 25 % of buffer pool size

innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50


[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

1. Remove the next comment character if you are not familiar with SQL

#safe-updates

[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Systeminfo beim Server (momentan normaler PC)

Wer kann mir hier weiterhelfen ?