Zitat:
Zitat von Unifex  Einige Werte von Tuning Primer machen mir ein wenig Sorgen. |
Welche genau?
Folgendes würde mir Sorgen bereiten:
Zitat:
Zitat von Unifex Code: The slow query log is NOT enabled.
Current long_query_time = 10.000000 sec.
The binary update log is NOT enabled.
You will not be able to do point in time recovery
Current max_connections = 150
Historic max_used_connections = 17
Current innodb_buffer_pool_size = 1.00 G
Current MyISAM index space = 398 M
Current key_buffer_size = 1.00 G
Current query_cache_size = 1.00 G
Current query_cache_used = 225 M
Current join_buffer_size = 8.00 M
You have had 9393 queries where a join could not use an index properly Code: #
max_allowed_packet = 64M
max_connections = 150
join_buffer_size = 8M
concurrent_insert=2
query_cache_size = 1G
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
innodb_buffer_pool_size = 1G
key_buffer_size = 1G
!includedir /etc/mysql/conf.d/ |
Jede einzelne gequotete Zeile macht mir Sorgen...