Ich habe die Suche benutzt und ich habe auch einige Lösungsansätze gefunden.
Ich habe nun auch leider keine riesen Erfahrung mit Linux :-((
Der Server hat Suse 9.3
MySQL 4.1.10a
PHP Version 4.3.10
Darauf läuft ein phpbb mit ca 270 MB derzeit (Suchindex wurde gelöscht) und 1700 User.
Wenn sich so 9 User auf dem Server befinden, liegt die Auslastung des MySQL Dienstes bei 30% (mit Suchindex 60%).
Ich habe bereits PHP optimiert (versucht) ebenso MySQL (config siehe unten).
Auch habe ich etwas darüber gelesen, das man den Characteset richtig einstellen sollte, naja leider war das Ergebnis öhm verherrend :-(
Alle Umlaute waren weg und Tabellen vom Typ Char wurden mal eben einfach gekürzt Oo
Es ist ein 2GHZ
Mit 512 MB Arbeitsspeicher.
Welche Angaben bräuchtet ihr noch?
Ich bitte zu verzeihen, dass ich deswegen einen neuen Thread aufmache, aber ich habe nun Tagelang Foren gelesen und Google benutzt und ich kapiere die Dinge teilweise nicht oder aber sie brachten nichts.
Code: Select all
my.cnf [B---] 21 L:[ 1+14 15/ 68] *(264 /1158b)= . 10 0x0A
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=latin1
[mysqld]
user = mysql
socket = /var/lib/mysql/mysql.sock
bind-address =127.0.0.1
port = 3306
server-id = 1
skip-locking
skip-networking
skip-name-resolve
skip-external-locking
local-infile = 0
key_buffer_size = 64M
sort_buffer_size = 4M
read_buffer_size = 1M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
max_allowed_packet = 16M
net_buffer_length = 8K
thread_stack = 128K
thread_cache = 8
table_cache = 256
query_cache_type = 1
query_cache_size = 16M
query_cache_limit = 1M
thread_concurrency = 2
skip-innodb
old-passwords
default-character-set=latin1
collation-server=latin1_german2_ci
connect_timeout = 60
connect_timeout = 15
max_connections = 200
[safe_mysqld]
err-log=/var/lib/mysql/mysqld.log
log=/var/lib/mysql/mysqld.log
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
#no-auto-rehash
#safe-updates
default-character-set=latin1
[isamchk]
key_buffer = 64M
sort_buffer_size = 4M
read_buffer = 1M
write_buffer = 1M
[myisamchk]
key_buffer_size = 64M
sort_buffer_size = 4M
read_buffer = 1M
write_buffer = 1M
[mysqlhotcopy]
interactive-timeout
##########################
php.ini
php.ini [B---] 25 L:[ 1+57 58/175] *(1401/3763b)= . 10 0x0A
[PHP]
engine = On
;zend.ze1_compatibility_mode = On
short_open_tag = On
asp_tags = Off
precision = 14
y2k_compliance = On
output_buffering = 4096
;output_handler =
zlib.output_compression = Off
;zlib.output_handler =
implicit_flush = Off
unserialize_callback_func =
serialize_precision = 100
allow_call_time_pass_reference = Off
safe_mode = Off
safe_mode_gid = Off
safe_mode_include_dir =
safe_mode_exec_dir =
safe_mode_allowed_env_vars = PHP_
safe_mode_protected_env_vars = LD_LIBRARY_PATH
;open_basedir =
disable_functions =
disable_classes =
highlight.string = #DD0000
highlight.comment = #FF9900
highlight.keyword = #007700
highlight.bg = #FFFFFF
highlight.default = #0000BB
highlight.html = #000000
;ignore_user_abort = On
expose_php = Off
max_execution_time = 30
max_input_time = 60
memory_limit = 16M
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT
display_errors = On
display_startup_errors = Off
log_errors = Off
log_errors_max_len = 1024
ignore_repeated_errors = Off
ignore_repeated_source = Off
report_memleaks = On
track_errors = Off
html_errors = Off
;error_log = "/var/log/apache2/error_log"
;arg_separator.output = "&"
;arg_separator.input = ";&"
variables_order = "GPCS"
register_globals = Off
register_long_arrays = Off
register_argc_argv = On
;auto_globals_jit = Off
post_max_size = 8M
gpc_order = "GPC"
magic_quotes_gpc = On
magic_quotes_runtime = Off
magic_quotes_sybase = Off
php.ini [B---] 22 L:[ 58+57 115/175] *(2462/3763b)= . 10 0x0A
magic_quotes_sybase = Off
auto_prepend_file =
auto_append_file =
default_mimetype = "text/html"
;default_charset = "iso-8859-1"
;always_populate_raw_post_data = Off
include_path = ".:/usr/share/php"
extension_dir = "./"
extension_dir = /usr/lib/php/extensions
doc_root =
user_dir =
enable_dl = On
file_uploads = On
upload_tmp_dir =
upload_max_filesize = 6M
allow_url_fopen = Off
from = "anonymous@localhost"
user_agent = ""
default_socket_timeout = 60
auto_detect_line_endings = Off
[extension section]
extension=ftp.so
extension=gd.so
extension=zlib.so
extension=mbstring.so
extension=session.so
extension=mysql.so
[Date]
;date.timezone =
[Syslog]
define_syslog_variables = Off
[mail function]
SMTP = localhost
smtp_port = 25
;sendmail_from = me@example.com
;sendmail_path =
;mail.force_extra_parameters =
[SQL]
sql.safe_mode = Off
[MySQL]
mysql.allow_persistent = Off
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port =
mysql.default_socket =
mysql.default_host =
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Off
php.ini [B---] 27 L:[114+56 170/175] *(3720/3763b)= . 10 0x0A
mysql.connect_timeout = 60
mysql.trace_mode = Off
[MySQLi]
mysqli.max_links = -1
mysqli.default_port = 3306
mysqli.default_socket =
mysqli.default_host =
mysqli.default_user =
mysqli.default_pw =
mysqli.reconnect = Off
[PostgresSQL]
pgsql.allow_persistent = Off
pgsql.auto_reset_persistent = Off
pgsql.max_persistent = -1
pgsql.max_links = -1
pgsql.ignore_notice = 0
pgsql.log_notice = 0
[bcmath]
bcmath.scale = 0
[Session]
session.save_handler = files
session.save_path = "/tmp"
session.use_cookies = 1
session.use_only_cookies = 0
session.name = PHPSESSID
session.auto_start = 0
session.cookie_lifetime = 0
session.cookie_path = /
session.cookie_domain =
session.serialize_handler = php
session.gc_probability = 1
session.gc_divisor = 1000
session.gc_maxlifetime = 1440
session.bug_compat_42 = 0
session.bug_compat_warn = 1
session.referer_check =
session.entropy_length = 16
session.entropy_file = /dev/urandom
session.cache_limiter = nocache
session.cache_expire = 180
session.use_trans_sid = 0
session.hash_function = 0
session.hash_bits_per_character = 5
url_rewriter.tags = "a=href,area=href,frame=src,input=src,fieldset="
[Tidy]
;tidy.default_config = /usr/lib/php/default.tcfg
tidy.clean_output = Off
[soap]
soap.wsdl_cache_enabled = 1
soap.wsdl_cache_dir = "/tmp"
soap.wsdl_cache_ttl = 86400
php.ini [B---] 0 L:[117+58 175/175] *(3763/3763b)= <EOF>
[MySQLi]
mysqli.max_links = -1
mysqli.default_port = 3306
mysqli.default_socket =
mysqli.default_host =
mysqli.default_user =
mysqli.default_pw =
mysqli.reconnect = Off
[PostgresSQL]
pgsql.allow_persistent = Off
pgsql.auto_reset_persistent = Off
pgsql.max_persistent = -1
pgsql.max_links = -1
pgsql.ignore_notice = 0
pgsql.log_notice = 0
[bcmath]
bcmath.scale = 0
[Session]
session.save_handler = files
session.save_path = "/tmp"
session.use_cookies = 1
session.use_only_cookies = 0
session.name = PHPSESSID
session.auto_start = 0
session.cookie_lifetime = 0
session.cookie_path = /
session.cookie_domain =
session.serialize_handler = php
session.gc_probability = 1
session.gc_divisor = 1000
session.gc_maxlifetime = 1440
session.bug_compat_42 = 0
session.bug_compat_warn = 1
session.referer_check =
session.entropy_length = 16
session.entropy_file = /dev/urandom
session.cache_limiter = nocache
session.cache_expire = 180
session.use_trans_sid = 0
session.hash_function = 0
session.hash_bits_per_character = 5
url_rewriter.tags = "a=href,area=href,frame=src,input=src,fieldset="
[Tidy]
;tidy.default_config = /usr/lib/php/default.tcfg
tidy.clean_output = Off
[soap]
soap.wsdl_cache_enabled = 1
soap.wsdl_cache_dir = "/tmp"
soap.wsdl_cache_ttl = 86400
; Local Variables:
; tab-width: 4
; End: