Einzelnen Beitrag anzeigen
Alt 25.04.2012, 15:12
Benutzerbild von Joe User
Joe User Joe User ist offline
Registered User
Registriert seit: 11.2008
Ort: Hamburg
Alter: 39
Beiträge: 3.836
Zitat von Unifex Beitrag anzeigen
Einige Werte von Tuning Primer machen mir ein wenig Sorgen.
Welche genau?

Folgendes würde mir Sorgen bereiten:
Zitat von Unifex Beitrag anzeigen
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
max_allowed_packet	= 64M
max_connections        = 150
join_buffer_size = 8M
query_cache_size  = 1G
#log_slow_queries	= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#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...
PayPal.Me/JoeUserWings for LifeWings for Life World Run
RootForum CommunityFreeBSD Remote InstallationFreeBSD Web Hosting System

„If there’s more than one possible outcome of a job or task, and one of those outcomes will result in disaster or an undesirable consequence, then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.
Mit Zitat antworten