• This forum has a zero tolerance policy regarding spam. If you register here to publish advertising, your user account will be deleted without further questions.

Apache und MYSQL optimieren

Naja, mit grep nach Variablen zu suchen, zeigt einem halt nur die Variablen und nicht das ganze Bild. Vielleicht ist es einfacher gdb zu nutzen und an den interessanten Stellen im Code breakpoints zu setzen. Dann kann man ja sehen was bei > 256 passiert.

Dokumentation ist geduldig.
 
Last edited by a moderator:
Sooo, der Server läuft jetzt schon ne Weile mit den Empfehlungen von DjTom-i und habe jetzt MySQLTuner nochmal gestartet, kann nochmal jemand drüberschauen? :)

Apache
Code:
<IfModule mpm_prefork_module>
    Serverlimit             5000
    StartServers              25
    MinSpareServers           25
    MaxSpareServers           50
    MaxRequestWorkers       5000
    MaxConnectionsPerChild 10000
</IfModule>

my.cnf
Code:
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1
#
# * Fine Tuning
#
key_buffer_size         = 32M
max_allowed_packet      = 32M
thread_stack            = 1M
thread_cache_size       = 8
join_buffer_size        = 4M
open_files_limit        = 64000
max_heap_table_size     = 64M
tmp_table_size          = 64M
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options  = BACKUP
max_connections         = 500
table_open_cache        = 5000
table_definition_cache  = 5000
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#log_slow_queries       = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id              = 1
#log_bin                        = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size   = 100M
#binlog_do_db           = include_database_name
#binlog_ignore_db       = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

MySQLTuner
Code:
 >>  MySQLTuner 1.7.0 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script
[OK] Logged in using credentials from debian maintenance account.
[OK] Currently running supported MySQL version 5.7.16
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
[--] Data in MEMORY tables: 872K (Tables: 2)
[--] Data in MyISAM tables: 2G (Tables: 262)
[--] Data in InnoDB tables: 2M (Tables: 79)
[OK] Total fragmented tables: 0

-------- Security Recommendations ------------------------------------------------------------------
[OK] There are no anonymous accounts for any database users
[OK] All database users have passwords assigned
[--] There are 612 basic passwords in the list.

-------- CVE Security Recommendations --------------------------------------------------------------
[OK] NO SECURITY CVE FOUND FOR YOUR VERSION

-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 3d 4h 12m 2s (16M q [59.653 qps], 1M conn, TX: 847G, RX: 4G)
[--] Reads / Writes: 91% / 9%
[--] Binary logging is disabled
[--] Physical Memory     : 7.7G
[--] Max MySQL memory    : 3.0G
[--] Other process memory: 768.6M
[--] Total buffers: 256.0M global + 5.6M per thread (500 max threads)
[--] P_S Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 329.1M (4.15% of installed RAM)
[OK] Maximum possible memory usage: 3.0G (38.72% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (0/16M)
[OK] Highest usage of available connections: 2% (13/500)
[OK] Aborted connections: 0.00%  (18/1388965)
[!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
[OK] Query cache is disabled by default due to mutex contention on multiprocessor machines.
[OK] Sorts requiring temporary tables: 0% (2K temp sorts / 1M sorts)
[!!] Joins performed without indexes: 133436
[OK] Temporary tables created on disk: 3% (11K on disk / 302K total)
[OK] Thread cache hit rate: 99% (262 created / 1M connections)
[!!] Table cache hit rate: 13% (2K open / 16K opened)
[OK] Open file limit used: 42% (2K/5K)
[OK] Table locks acquired immediately: 99% (20M immediate / 20M locks)

-------- Performance schema ------------------------------------------------------------------------
[--] Performance schema is disabled.

-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.

-------- MyISAM Metrics ----------------------------------------------------------------------------
[OK] Key buffer used: 100.0% (33M used / 33M cache)
[OK] Key buffer size / total MyISAM indexes: 32.0M/603.6M
[OK] Read Key buffer hit rate: 99.6% (707M cached / 2M reads)
[!!] Write Key buffer hit rate: 42.6% (977K cached / 561K writes)

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[OK] InnoDB buffer pool / data size: 128.0M/2.3M
[!!] Ratio InnoDB log file size / InnoDB Buffer pool size (37.5 %): 48.0M/128.0M should be equal 25%
[OK] InnoDB buffer pool instances: 1
[--] Number of InnoDB Buffer Pool Chunk : 1 for 1 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[OK] InnoDB Read buffer efficiency: 99.99% (4826285 hits/ 4826986 total)
[!!] InnoDB Write Log efficiency: 119.5% (23389 hits/ 19573 total)
[OK] InnoDB log waits: 0.00% (0 waits / 42962 writes)

-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is disabled.

-------- TokuDB Metrics ----------------------------------------------------------------------------
[--] TokuDB is disabled.

-------- XtraDB Metrics ----------------------------------------------------------------------------
[--] XtraDB is disabled.

-------- RocksDB Metrics ---------------------------------------------------------------------------
[--] RocksDB is disabled.

-------- Spider Metrics ----------------------------------------------------------------------------
[--] Spider is disabled.

-------- Connect Metrics ---------------------------------------------------------------------------
[--] Connect is disabled.

-------- Galera Metrics ----------------------------------------------------------------------------
[--] Galera is disabled.

-------- Replication Metrics -----------------------------------------------------------------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] This is a standalone server.

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
    Adjust your join queries to always utilize indexes
    Increase table_open_cache gradually to avoid file descriptor limits
    Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
    Beware that open_files_limit (5000) variable
    should be greater than table_open_cache (2245)
Variables to adjust:
    join_buffer_size (> 4.0M, or always use indexes with joins)
    table_open_cache (> 2245)
    innodb_log_file_size should be equals to 1/4 of buffer pool size (=32M) if possible.
 
Du hast ja table_open_cache noch nicht gesetzt.. Oder den MySql Server seitdem nicht restartet (Up for: 3d 4h 12m 2s)..

Die prüfen/setzen:

Code:
table_open_cache            = 5000
table_definition_cache = 5000
join_buffer_size = 32M
 
Du hast ja table_open_cache noch nicht gesetzt.. Oder den MySql Server seitdem nicht restartet (Up for: 3d 4h 12m 2s)..

Die prüfen/setzen:

Code:
table_open_cache            = 5000
table_definition_cache = 5000
join_buffer_size = 32M

Habe ich, steht in meiner my.cnf in Posts#22.

join_buffer_size hatte ich auf 4M, den Wert habe ich nun auf 32M gesetzt. Das hatte ich übersehen... :eek:
 
Es macht wenig Sinn nur einzelne Werte zu betrachten, man muss immer alle Werte im Blick halten, um auch Wechselwirkungen kalkulieren zu können.
Meine Empfehlung hatte ich Dir bereits in Post #12 genannt und diese solltest Du nur komplett übernehmen und nach zwei/drei Tagen können wir sie bei Bedarf noch weiter feintunen.
 
Hier nochmal die Ausgabe von Tuning Primer, vielleicht hilft euch das mehr um rauszufinden was optimiert werden kann...

Code:
        -- MYSQL PERFORMANCE TUNING PRIMER --
             - By: Matthew Montgomery -

MySQL Version 5.7.16 x86_64

Uptime = 3 days 0 hrs 29 min 45 sec
Avg. qps = 78
Total Questions = 20438773
Threads Connected = 2

Server has been running for over 48hrs.
It should be safe to follow these recommendations

To find out more information on how each of these
runtime variables effects performance visit:
http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
Visit http://www.mysql.com/products/enterprise/advisors.html
for info about MySQL's Enterprise Monitoring and Advisory Service

SLOW QUERIES
The slow query log is NOT enabled.
Current long_query_time = 10.000000 sec.
You have 0 out of 20438794 that take longer than 10.000000 sec. to complete
Your long_query_time seems to be fine

BINARY UPDATE LOG
The binary update log is NOT enabled.
You will not be able to do point in time recovery
See http://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery.html

WORKER THREADS
Current thread_cache_size = 8
Current threads_cached = 7
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine

MAX CONNECTIONS
Current max_connections = 500
Current threads_connected = 2
Historic max_used_connections = 12
The number of used connections is 2% of the configured maximum.
You are using less than 10% of your configured max_connections.
Lowering max_connections could help to avoid an over-allocation of memory
See "MEMORY USAGE" section to make sure you are not over-allocating

No InnoDB Support Enabled!

MEMORY USAGE
Max Memory Ever Allocated : 595 M
Configured Max Per-thread Buffers : 16.41 G
Configured Max Global Buffers : 192 M
Configured Max Memory Limit : 16.60 G
Physical Memory : 7.73 G

Max memory limit exceeds 90% of physical memory

KEY BUFFER
Current MyISAM index space = 631 M
Current key_buffer_size = 32 M
Key cache miss rate is 1 : 317
Key buffer free ratio = 0 %
You could increase key_buffer_size
It is safe to raise this up to 1/4 of total system memory;
assuming this is a dedicated database server.

QUERY CACHE
Query cache is enabled
Current query_cache_size = 16 M
Current query_cache_used = 16 K
Current query_cache_limit = 1 M
Current Query cache Memory fill ratio = .10 %
Current query_cache_min_res_unit = 4 K
Your query_cache_size seems to be too high.
Perhaps you can use these resources elsewhere
MySQL won't cache query results that are larger than query_cache_limit in size

SORT OPERATIONS
Current sort_buffer_size = 256 K
Current read_rnd_buffer_size = 256 K
Sort buffer seems to be fine

JOINS
Current join_buffer_size = 32.00 M
You have had 161833 queries where a join could not use an index properly
join_buffer_size >= 4 M
This is not advised
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.

OPEN FILES LIMIT
Current open_files_limit = 5000 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine

TABLE CACHE
Current table_open_cache = 2245 tables
Current table_definition_cache = 5000 tables
You have a total of 464 tables
You have 2240 open tables.
Current table_cache hit rate is 10%
, while 99% of your table cache is in use
You should probably increase your table_cache

TEMP TABLES
Current max_heap_table_size = 64 M
Current tmp_table_size = 64 M
Of 344807 temp tables, 3% were created on disk
Created disk tmp tables ratio seems fine

TABLE SCANS
Current read_buffer_size = 128 K
Current table scan ratio = 259 : 1
read_buffer_size seems to be fine

TABLE LOCKING
Current Lock Wait ratio = 1 : 2672
You may benefit from selective use of InnoDB.
If you have long running SELECT's against MyISAM tables and perform
frequent updates consider setting 'low_priority_updates=1'
If you have a high concurrency of inserts on Dynamic row-length tables
consider setting 'concurrent_insert=ALWAYS'.
 
Hast du denn noch ein aktutes Problem?

Versuch mal, wie von Joe User vorgeschlagen, den query_cache zu deaktivieren. Ich teste damit aktuell etwas herum, bislang beeindruckend erfolgreich. Auch wenn ich immer noch irritiert davon bin, dass ich davon so gar nichts wusste, aber man lernt halt auch nach einem guten halben Jahrzehnt Linux-Administration nicht aus ;)
 
Er hat noch immer das Problem der exorbitant hohen join_buffer_size, welche allein schon zu 16GB RAM Verbrauch bei nur <8 GB verbautem RAM führt.

Die JOINs nutzen bei ihm keine Indexe, da hilft nunmal auch kein Anheben der join_buffer_size.

Auch die maxconnections sind mit 500 viel zu hoch, der Standardwert reicht hier völlig.

Last but not least, sollte er auf InnoDB umsteigen, aber das ist ein anderes Thema...


Ich bin erstmal raus, mein Lösungsvorschlag steht in Post #12.
 
Der Server läuft jetzt seit 3 Tagen mit den Daten von Joe User aus Beitrag Nr. 12.

Tuning Primer:

Code:
        -- MYSQL PERFORMANCE TUNING PRIMER --
             - By: Matthew Montgomery -

MySQL Version 5.7.16 x86_64

Uptime = 3 days 2 hrs 18 min 26 sec
Avg. qps = 71
Total Questions = 19148051
Threads Connected = 2

Server has been running for over 48hrs.
It should be safe to follow these recommendations

To find out more information on how each of these
runtime variables effects performance visit:
http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
Visit http://www.mysql.com/products/enterprise/advisors.html
for info about MySQL's Enterprise Monitoring and Advisory Service

SLOW QUERIES
The slow query log is NOT enabled.
Current long_query_time = 0.500000 sec.
You have 0 out of 19148073 that take longer than 0.500000 sec. to complete
Your long_query_time seems to be fine

BINARY UPDATE LOG
The binary update log is NOT enabled.
You will not be able to do point in time recovery
See http://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery.html

WORKER THREADS
Current thread_cache_size = 8
Current threads_cached = 7
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine

MAX CONNECTIONS
Current max_connections = 500
Current threads_connected = 2
Historic max_used_connections = 14
The number of used connections is 2% of the configured maximum.
You are using less than 10% of your configured max_connections.
Lowering max_connections could help to avoid an over-allocation of memory
See "MEMORY USAGE" section to make sure you are not over-allocating

No InnoDB Support Enabled!

MEMORY USAGE
Max Memory Ever Allocated : 487 M
Configured Max Per-thread Buffers : 3.05 G
Configured Max Global Buffers : 400 M
Configured Max Memory Limit : 3.44 G
Physical Memory : 7.73 G
Max memory limit seem to be within acceptable norms

KEY BUFFER
Current MyISAM index space = 642 M
Current key_buffer_size = 256 M
Key cache miss rate is 1 : 3218
Key buffer free ratio = 0 %
You could increase key_buffer_size
It is safe to raise this up to 1/4 of total system memory;
assuming this is a dedicated database server.

QUERY CACHE
Query cache is supported but not enabled
Perhaps you should set the query_cache_size

SORT OPERATIONS
Current sort_buffer_size = 4 M
Current read_rnd_buffer_size = 512 K
Sort buffer seems to be fine

JOINS
Current join_buffer_size = 516.00 K
You have had 188198 queries where a join could not use an index properly
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
If you are unable to optimize your queries you may want to increase your
join_buffer_size to accommodate larger joins in one pass.

Note! This script will still suggest raising the join_buffer_size when
ANY joins not using indexes are found.

OPEN FILES LIMIT
Current open_files_limit = 5000 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine

TABLE CACHE
Current table_open_cache = 2245 tables
Current table_definition_cache = 4096 tables
You have a total of 464 tables
You have 2240 open tables.
Current table_cache hit rate is 16%
, while 99% of your table cache is in use
You should probably increase your table_cache

TEMP TABLES
Current max_heap_table_size = 256 M
Current tmp_table_size = 256 M
Of 398481 temp tables, 2% were created on disk
Created disk tmp tables ratio seems fine

TABLE SCANS
Current read_buffer_size = 256 K
Current table scan ratio = 274 : 1
read_buffer_size seems to be fine

TABLE LOCKING
Current Lock Wait ratio = 1 : 2677
You may benefit from selective use of InnoDB.
If you have long running SELECT's against MyISAM tables and perform
frequent updates consider setting 'low_priority_updates=1'
If you have a high concurrency of inserts on Dynamic row-length tables
consider setting 'concurrent_insert=ALWAYS'.

MySQLTuner:

Code:
 >>  MySQLTuner 1.7.0 - Major Hayden <major@mhtx.net>
>>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
>>  Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script
[OK] Logged in using credentials from debian maintenance account.
[OK] Currently running supported MySQL version 5.7.16
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
[--] Data in MEMORY tables: 1M (Tables: 2)
[--] Data in MyISAM tables: 2G (Tables: 262)
[--] Data in InnoDB tables: 2M (Tables: 81)
[OK] Total fragmented tables: 0

-------- Security Recommendations ------------------------------------------------------------------
[OK] There are no anonymous accounts for any database users
[OK] All database users have passwords assigned
[--] There are 612 basic passwords in the list.

-------- CVE Security Recommendations --------------------------------------------------------------
[OK] NO SECURITY CVE FOUND FOR YOUR VERSION

-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 3d 2h 23m 42s (19M q [71.568 qps], 1M conn, TX: 1062G, RX: 5G)
[--] Reads / Writes: 91% / 9%
[--] Binary logging is disabled
[--] Physical Memory     : 7.7G
[--] Max MySQL memory    : 3.7G
[--] Other process memory: 962.5M
[--] Total buffers: 656.0M global + 6.2M per thread (500 max threads)
[--] P_S Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 743.5M (9.38% of installed RAM)
[OK] Maximum possible memory usage: 3.7G (47.72% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (0/19M)
[OK] Highest usage of available connections: 2% (14/500)
[OK] Aborted connections: 0.00%  (3/1441902)
[!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
[OK] Query cache is disabled by default due to mutex contention on multiprocessor machines.
[OK] Sorts requiring temporary tables: 0% (1K temp sorts / 2M sorts)
[!!] Joins performed without indexes: 188220
[OK] Temporary tables created on disk: 2% (11K on disk / 398K total)
[OK] Thread cache hit rate: 99% (80 created / 1M connections)
[!!] Table cache hit rate: 16% (2K open / 13K opened)
[OK] Open file limit used: 44% (2K/5K)
[OK] Table locks acquired immediately: 99% (25M immediate / 25M locks)

-------- Performance schema ------------------------------------------------------------------------
[--] Performance schema is disabled.

-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.

-------- MyISAM Metrics ----------------------------------------------------------------------------
[OK] Key buffer used: 100.0% (268M used / 268M cache)
[OK] Key buffer size / total MyISAM indexes: 256.0M/642.6M
[OK] Read Key buffer hit rate: 100.0% (980M cached / 304K reads)
[!!] Write Key buffer hit rate: 39.1% (1M cached / 621K writes)

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[OK] InnoDB buffer pool / data size: 128.0M/2.6M
[!!] Ratio InnoDB log file size / InnoDB Buffer pool size (37.5 %): 48.0M/128.0M should be equal 25%
[OK] InnoDB buffer pool instances: 1
[--] Number of InnoDB Buffer Pool Chunk : 1 for 1 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[OK] InnoDB Read buffer efficiency: 99.99% (5180814 hits/ 5181467 total)
[!!] InnoDB Write Log efficiency: 166.97% (30149 hits/ 18057 total)
[OK] InnoDB log waits: 0.00% (0 waits / 48206 writes)

-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is disabled.

-------- TokuDB Metrics ----------------------------------------------------------------------------
[--] TokuDB is disabled.

-------- XtraDB Metrics ----------------------------------------------------------------------------
[--] XtraDB is disabled.

-------- RocksDB Metrics ---------------------------------------------------------------------------
[--] RocksDB is disabled.

-------- Spider Metrics ----------------------------------------------------------------------------
[--] Spider is disabled.

-------- Connect Metrics ---------------------------------------------------------------------------
[--] Connect is disabled.

-------- Galera Metrics ----------------------------------------------------------------------------
[--] Galera is disabled.

-------- Replication Metrics -----------------------------------------------------------------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] This is a standalone server.

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
    Adjust your join queries to always utilize indexes
    Increase table_open_cache gradually to avoid file descriptor limits
    Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
    Beware that open_files_limit (5000) variable
    should be greater than table_open_cache (2245)
Variables to adjust:
    join_buffer_size (> 512.0K, or always use indexes with joins)
    table_open_cache (> 2245)
    innodb_log_file_size should be equals to 1/4 of buffer pool size (=32M) if possible.
 
Jetzt noch vernünftige WebApps einsetzen und über InnoDB nachdenken, dann läuft es richtig rund.
 
Back
Top