Performance schon bei 200 Usern schlecht

Apache, Lighttpd, nginx, Cherokee
Post Reply
maik20
Posts: 6
Joined: 2005-05-02 21:45
 

Performance schon bei 200 Usern schlecht

Post by maik20 »

Hallo!

Ich habe einen Root Server (AMD Sempron 3000+, 2.048 MB DDR-RAM) auf dem ein Onlinespiel läuft! Das Spiel besteht eigentlich nur aus PHP-Seiten und einer 300mb großen Datenbank.

Mein Problem ist, dass der Server schon bei 200 Usern extrem langsam wird und der Seitenaufbau über 10 Sek dauert.

Leider habe ich von Linux, PHP und MySQL nicht das erforderliche Wissen um die Gesamt-Performance zu steigern. Vielleicht kann mir hier jemand helfen.

Hier mal ein "top"-Auszug:

Code: Select all

Tasks: 285 total,   5 running, 278 sleeping,   0 stopped,   2 zombie
Cpu(s):  75.2% user,  24.8% system,   0.0% nice,   0.0% idle
Mem:   2004336k total,   557972k used,  1446364k free,    13592k buffers
Swap:  1052248k total,        0k used,  1052248k free,   226564k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
10138 mysql     19   0 49416  48m 3696 R  4.4  2.5   0:00.32 mysqld-max
10179 mysql     18   0 49412  48m 3696 S  4.2  2.5   0:00.20 mysqld-max
 1611 root      16   0  1096 1096  748 R  3.7  0.1   0:53.99 top
 9967 mysql     16   0 49416  48m 3696 S  2.5  2.5   0:00.22 mysqld-max
10062 mysql     15   0 49416  48m 3696 S  2.5  2.5   0:00.15 mysqld-max
10168 mysql     15   0 49412  48m 3696 S  2.5  2.5   0:00.12 mysqld-max
10167 mysql     16   0 49396  48m 3696 S  2.3  2.5   0:00.11 mysqld-max
10172 mysql     18   0 49412  48m 3696 S  2.3  2.5   0:00.11 mysqld-max
10185 mysql     16   0 49412  48m 3696 S  2.3  2.5   0:00.11 mysqld-max
10187 mysql     16   0 49436  48m 3696 S  2.3  2.5   0:00.11 mysqld-max
10048 mysql     16   0 49416  48m 3696 S  2.1  2.5   0:00.10 mysqld-max
10192 mysql     18   0 49436  48m 3696 S  2.1  2.5   0:00.10 mysqld-max
10107 mysql     15   0 49416  48m 3696 S  1.9  2.5   0:00.10 mysqld-max
10131 mysql     19   0 49416  48m 3696 R  1.7  2.5   0:00.37 mysqld-max
10169 mysql     15   0 49412  48m 3696 S  1.5  2.5   0:00.23 mysqld-max
 9574 wwwrun    16   0 13168  12m  10m S  0.8  0.7   0:00.11 httpd2-prefork
  785 root      15   0  1364 1364 1148 S  0.6  0.1   0:03.84 pipelog.pl
 6537 wwwrun    16   0 12948  12m  10m S  0.6  0.6   0:00.69 httpd2-prefork
 8732 wwwrun    15   0 12316  12m  10m S  0.6  0.6   0:00.27 httpd2-prefork
 9382 wwwrun    15   0 12524  12m  10m S  0.6  0.6   0:00.19 httpd2-prefork
 9681 mysql     15   0 49416  48m 3696 S  0.6  2.5   0:01.49 mysqld-max
 9743 wwwrun    15   0 12448  12m  10m S  0.6  0.6   0:00.14 httpd2-prefork
 9928 wwwrun    15   0 12008  11m  10m S  0.6  0.6   0:00.07 httpd2-prefork
10008 mysql     15   0 49416  48m 3696 S  0.6  2.5   0:00.14 mysqld-max
10014 wwwrun    15   0 12088  11m  10m S  0.6  0.6   0:00.08 httpd2-prefork
10193 mysql     18   0 49436  48m 3696 S  0.6  2.5   0:00.03 mysqld-max
 4869 wwwrun    15   0 12552  12m  10m S  0.4  0.6   0:00.84 httpd2-prefork
 8135 wwwrun    15   0 12452  12m  10m S  0.4  0.6   0:00.44 httpd2-prefork
 8698 wwwrun    15   0 12568  12m  10m S  0.4  0.6   0:00.29 httpd2-prefork
 8740 wwwrun    15   0 12284  11m  10m S  0.4  0.6   0:00.26 httpd2-prefork
 8955 wwwrun    16   0 12312  12m  10m S  0.4  0.6   0:00.20 httpd2-prefork
 9364 wwwrun    15   0 12300  12m  10m S  0.4  0.6   0:00.16 httpd2-prefork
 9431 wwwrun    15   0 12728  12m  10m S  0.4  0.6   0:00.20 httpd2-prefork
 9450 wwwrun    16   0 12512  12m  10m S  0.4  0.6   0:00.15 httpd2-prefork
 9453 wwwrun    15   0 12220  11m  10m S  0.4  0.6   0:00.17 httpd2-prefork
 9598 wwwrun    15   0 12000  11m  10m S  0.4  0.6   0:00.09 httpd2-prefork
 9774 wwwrun    15   0 12128  11m  10m S  0.4  0.6   0:00.09 httpd2-prefork
 9883 wwwrun    15   0 12180  11m  10m S  0.4  0.6   0:00.07 httpd2-prefork
10004 wwwrun    15   0 12108  11m  10m S  0.4  0.6   0:00.06 httpd2-prefork
10023 wwwrun    16   0 12328  12m  10m S  0.4  0.6   0:00.08 httpd2-prefork
10097 wwwrun    16   0 11932  11m  10m S  0.4  0.6   0:00.03 httpd2-prefork
10137 mysql     15   0 49416  48m 3696 S  0.4  2.5   0:00.12 mysqld-max
10155 wwwrun    15   0 12492  12m  10m S  0.4  0.6   0:00.05 httpd2-prefork
10175 wwwrun    18   0 11892  11m  10m S  0.4  0.6   0:00.03 httpd2-prefork
10194 mysql     18   0 49436  48m 3696 S  0.4  2.5   0:00.02 mysqld-max
10197 wwwrun    15   0 10948  10m  10m S  0.4  0.5   0:00.02 httpd2-prefork
  612 mysql     15   0 49400  48m 3696 S  0.2  2.5   0:00.96 mysqld-max
 1946 wwwrun    15   0 13576  13m  10m S  0.2  0.7   0:01.85 httpd2-prefork
 4970 wwwrun    16   0 12796  12m  10m S  0.2  0.6   0:00.75 httpd2-prefork
 5431 wwwrun    15   0 12468  12m  10m S  0.2  0.6   0:00.45 httpd2-prefork
 7242 wwwrun    16   0 12644  12m  10m S  0.2  0.6   0:00.48 httpd2-prefork
 7372 wwwrun    15   0 12500  12m  10m S  0.2  0.6   0:00.47 httpd2-prefork
 7441 wwwrun    15   0 12872  12m  10m S  0.2  0.6   0:00.55 httpd2-prefork
 7641 wwwrun    15   0 12852  12m  10m S  0.2  0.6   0:00.39 httpd2-prefork
Und hier die PHP-Info

Code: Select all

PHP Logo
PHP Version 4.3.3

System 	Linux rom072 2.4.21-273-athlon #1 Mon Jan 17 13:03:46 UTC 2005 i686
Build Date 	Feb 16 2005 20:22:52
Configure Command 	'./configure' '--prefix=/usr/share' '--datadir=/usr/share/php' '--bindir=/usr/bin' '--libdir=/usr/share' '--includedir=/usr/include' '--sysconfdir=/etc' '--with-_lib=lib' '--with-config-file-path=/etc' '--with-exec-dir=/usr/lib/php/bin' '--disable-debug' '--enable-bcmath' '--enable-calendar' '--enable-ctype' '--enable-dbase' '--enable-discard-path' '--enable-exif' '--enable-filepro' '--enable-force-cgi-redirect' '--enable-ftp' '--enable-gd-imgstrttf' '--enable-gd-native-ttf' '--enable-inline-optimization' '--enable-magic-quotes' '--enable-mbstr-enc-trans' '--enable-mbstring' '--enable-mbregex' '--enable-memory-limit' '--enable-safe-mode' '--enable-shmop' '--enable-sigchild' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-trans-sid' '--enable-versioning' '--enable-wddx' '--enable-yp' '--with-bz2' '--with-dom=/usr/include/libxml2' '--with-ftp' '--with-gdbm' '--with-gettext' '--with-gmp' '--with-imap=yes' '--with-iodbc' '--with-jpeg-dir=/usr' '--with-ldap=yes' '--with-mcal=/usr' '--with-mcrypt' '--with-mhash' '--with-mysql=/usr' '--with-ndbm' '--with-pgsql=/usr' '--with-png-dir=/usr' '--with-readline' '--with-snmp' '--with-t1lib' '--with-tiff-dir=/usr' '--with-ttf' '--with-freetype-dir=yes' '--with-xml' '--with-xpm-dir=/usr/X11R6' '--with-zlib=yes' '--with-qtdom=/usr/lib/qt3' '--with-gd' '--with-openssl' '--with-curl' '--with-swf=/usr/src/packages/BUILD/swf/dist/' '--with-imap-ssl' '--enable-xslt' '--with-xslt-sablot' '--with-iconv' '--with-apxs2=/usr/sbin/apxs2-prefork' 'i586-suse-linux'
Server API 	Apache 2.0 Handler
Virtual Directory Support 	disabled
Configuration File (php.ini) Path 	/etc/php.ini
PHP API 	20020918
PHP Extension 	20020429
Zend Extension 	20021010
Debug Build 	no
Thread Safety 	disabled
Registered PHP Streams 	php, http, ftp, https, ftps, compress.bzip2, compress.zlib

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2003 Zend Technologies

PHP Credits
Configuration
PHP Core
Directive	Local Value	Master Value
allow_call_time_pass_reference	On	On
allow_url_fopen	On	On
always_populate_raw_post_data	Off	Off
arg_separator.input	&	&
arg_separator.output	&	&
asp_tags	Off	Off
auto_append_file	no value	no value
auto_prepend_file	no value	no value
browscap	no value	no value
default_charset	no value	no value
default_mimetype	text/html	text/html
define_syslog_variables	Off	Off
disable_classes	no value	no value
disable_functions	no value	no value
display_errors	On	On
display_startup_errors	Off	Off
doc_root	no value	no value
docref_ext	no value	no value
docref_root	no value	no value
enable_dl	On	On
error_append_string	no value	no value
error_log	no value	no value
error_prepend_string	no value	no value
error_reporting	2039	2039
expose_php	On	On
extension_dir	/usr/share/extensions/no-debug-non-zts-20020429	/usr/share/extensions/no-debug-non-zts-20020429
file_uploads	On	On
gpc_order	GPC	GPC
highlight.bg	#FFFFFF	#FFFFFF
highlight.comment	#FF8000	#FF8000
highlight.default	#0000BB	#0000BB
highlight.html	#000000	#000000
highlight.keyword	#007700	#007700
highlight.string	#DD0000	#DD0000
html_errors	On	On
ignore_repeated_errors	Off	Off
ignore_repeated_source	Off	Off
ignore_user_abort	Off	Off
implicit_flush	Off	Off
include_path	.:/usr/share/php	.:/usr/share/php
log_errors	Off	Off
log_errors_max_len	1024	1024
magic_quotes_gpc	On	On
magic_quotes_runtime	Off	Off
magic_quotes_sybase	Off	Off
max_execution_time	30	30
max_input_time	60	60
memory_limit	64M	64M
open_basedir	/srv/www/htdocs/web1/:/srv/www/htdocs/phpMyAdmin/:/srv/www/htdocs/confixx/html/gesperrt/	no value
output_buffering	no value	no value
output_handler	no value	no value
post_max_size	8M	8M
precision	12	12
register_argc_argv	On	On
register_globals	On	Off
report_memleaks	On	On
safe_mode	On	Off
safe_mode_exec_dir	/srv/www/htdocs/empty	no value
safe_mode_gid	Off	Off
safe_mode_include_dir	no value	no value
sendmail_from	me@localhost.com	me@localhost.com
sendmail_path	/usr/sbin/sendmail -t -i 	/usr/sbin/sendmail -t -i
serialize_precision	100	100
short_open_tag	On	On
SMTP	localhost	localhost
smtp_port	25	25
sql.safe_mode	Off	Off
track_errors	Off	Off
unserialize_callback_func	no value	no value
upload_max_filesize	2M	2M
upload_tmp_dir	/srv/www/htdocs/web1/phptmp/	no value
user_dir	no value	no value
variables_order	EGPCS	EGPCS
xmlrpc_error_number	0	0
xmlrpc_errors	Off	Off
y2k_compliance	On	On

apache2handler
Apache Version 	Apache/2.0.48 (Linux/SuSE)
Apache API Version 	20020903
Server Administrator 	[no address given]
Hostname:Port 	www.xx.xx.xxx.xx:0
User/Group 	wwwrun(30)/8
Max Requests 	Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts 	Connection: 300 - Keep-Alive: 15
Virtual Server 	Yes
Server Root 	/srv/www
Loaded Modules 	core prefork http_core mod_so mod_access mod_actions mod_alias mod_auth mod_auth_dbm mod_autoindex mod_cgi mod_dir mod_env mod_expires mod_include mod_log_config mod_mime mod_negotiation mod_setenvif mod_ssl mod_suexec mod_userdir sapi_apache2

Directive	Local Value	Master Value
engine	1	1
last_modified	0	0
xbithack	0	0

Apache Environment
Variable	Value
HTTP_HOST 	www.domain.de
HTTP_USER_AGENT 	Mozilla/5.0 (Windows; U; Windows NT 5.1; de-DE; rv:1.7.7) Gecko/20050414 Firefox/1.0.3
HTTP_ACCEPT 	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_LANGUAGE 	en-us,en;q=0.7,de-de;q=0.3
HTTP_ACCEPT_ENCODING 	gzip,deflate
HTTP_ACCEPT_CHARSET 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_KEEP_ALIVE 	300
HTTP_CONNECTION 	keep-alive
HTTP_COOKIE 	phpbb2mysql_data=a%3A0%3A%7B%7D
HTTP_CACHE_CONTROL 	max-age=0
PATH 	/usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin
SERVER_SIGNATURE 	<address>Apache/2.0.48 (Linux/SuSE) Server at www.domain.de Port 80</address>
SERVER_SOFTWARE 	Apache/2.0.48 (Linux/SuSE)
SERVER_NAME 	www.domain.de
SERVER_ADDR 	xx.xx.xxx.xx
SERVER_PORT 	80
REMOTE_ADDR 	xx.xxx.xx.xx
DOCUMENT_ROOT 	/srv/www/htdocs/web1/html
SERVER_ADMIN 	[no address given]
SCRIPT_FILENAME 	/srv/www/htdocs/web1/html/info.php
REMOTE_PORT 	21266
GATEWAY_INTERFACE 	CGI/1.1
SERVER_PROTOCOL 	HTTP/1.1
REQUEST_METHOD 	GET
QUERY_STRING 	no value
REQUEST_URI 	/info.php
SCRIPT_NAME 	/info.php

HTTP Headers Information
HTTP Request Headers
HTTP Request 	GET /no_osm/info.php HTTP/1.1
Host 	www.domain.de
User-Agent 	Mozilla/5.0 (Windows; U; Windows NT 5.1; de-DE; rv:1.7.7) Gecko/20050414 Firefox/1.0.3
Accept 	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
Accept-Language 	en-us,en;q=0.7,de-de;q=0.3
Accept-Encoding 	gzip,deflate
Accept-Charset 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive 	300
Cookie 	phpbb2mysql_data=a%3A0%3A%7B%7D
Cache-Control 	max-age=0
HTTP Response Headers
X-Powered-By 	PHP/4.3.3
Transfer-Encoding 	chunked
Content-Type 	text/html; charset=ISO-8859-1

bcmath
BCMath support 	enabled

bz2
BZip2 Support 	Enabled
BZip2 Version 	1.0.2, 30-Dec-2001

calendar
Calendar support 	enabled

ctype
ctype functions 	enabled

curl
CURL support 	enabled
CURL Information 	libcurl/7.10.5 OpenSSL/0.9.7b ipv6 zlib/1.1.4

dba
DBA support 	enabled
Supported handlers 	gdbm ndbm cdb cdb_make inifile flatfile

domxml
DOM/XML 	enabled
DOM/XML API Version 	20020815
libxml Version 	20510
HTML Support 	enabled
XPath Support 	enabled
XPointer Support 	enabled

exif
EXIF Support 	enabled
EXIF Version 	1.4 $Id: exif.c,v 1.118.2.23 2003/06/25 13:21:54 edink Exp $
Supported EXIF Version 	0220
Supported filetypes 	JPEG,TIFF

ftp
FTP support 	enabled

gd
GD Support 	enabled
GD Version 	bundled (2.0.15 compatible)
FreeType Support 	enabled
FreeType Linkage 	with freetype
T1Lib Support 	enabled
GIF Read Support 	enabled
JPG Support 	enabled
PNG Support 	enabled
WBMP Support 	enabled
XBM Support 	enabled

gettext
GetText Support 	enabled

gmp
gmp support 	enabled

iconv
iconv support 	enabled
iconv implementation 	glibc
iconv library version 	2.3.2

Directive	Local Value	Master Value
iconv.input_encoding	ISO-8859-1	ISO-8859-1
iconv.internal_encoding	ISO-8859-1	ISO-8859-1
iconv.output_encoding	ISO-8859-1	ISO-8859-1

imap
IMAP c-Client Version 	2001
SSL Support 	enabled

ldap
LDAP Support 	enabled
RCS Version 	$Id: ldap.c,v 1.130.2.4 2003/04/30 21:54:02 iliaa Exp $
Total Links 	0/unlimited
API Version 	2004
Vendor Name 	OpenLDAP
Vendor Version 	20122

mbstring
Multibyte Support 	enabled
Japanese support 	enabled
Multibyte (japanese) regex support 	enabled

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Directive	Local Value	Master Value
mbstring.detect_order	no value	no value
mbstring.encoding_translation	Off	Off
mbstring.func_overload	0	0
mbstring.http_input	pass	pass
mbstring.http_output	pass	pass
mbstring.internal_encoding	UTF-8	UTF-8
mbstring.language	neutral	neutral
mbstring.substitute_character	no value	no value

mcal
MCAL Support 	enabled
MCAL Version 	0.6 - 20000121

mcrypt
mcrypt support	enabled
version 	>= 2.4.x
Supported ciphers 	cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes
Supported modes 	cbc cfb ctr ecb ncfb nofb ofb stream

Directive	Local Value	Master Value
mcrypt.algorithms_dir	no value	no value
mcrypt.modes_dir	no value	no value

mhash
MHASH support 	Enabled
MHASH API Version 	20020524

mysql
MySQL Support	enabled
Active Persistent Links 	0
Active Links 	0
Client API version 	4.0.15
MYSQL_MODULE_TYPE 	external
MYSQL_SOCKET 	/var/lib/mysql/mysql.sock
MYSQL_INCLUDE 	-I/usr/include/mysql
MYSQL_LIBS 	-L/usr/lib -lmysqlclient

Directive	Local Value	Master Value
mysql.allow_persistent	Off	Off
mysql.connect_timeout	60	60
mysql.default_host	no value	no value
mysql.default_password	no value	no value
mysql.default_port	no value	no value
mysql.default_socket	no value	no value
mysql.default_user	no value	no value
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off

odbc
ODBC Support	enabled
Active Persistent Links 	0
Active Links 	0
ODBC library 	iodbc
ODBC_INCLUDE 	-I/usr/local/include
ODBC_LFLAGS 	-L/usr/local/lib
ODBC_LIBS 	-liodbc

Directive	Local Value	Master Value
odbc.allow_persistent	On	On
odbc.check_persistent	On	On
odbc.default_db	no value	no value
odbc.default_pw	no value	no value
odbc.default_user	no value	no value
odbc.defaultbinmode	return as is	return as is
odbc.defaultlrl	return up to 4096 bytes	return up to 4096 bytes
odbc.max_links	Unlimited	Unlimited
odbc.max_persistent	Unlimited	Unlimited

openssl
OpenSSL support 	enabled
OpenSSL Version 	OpenSSL 0.9.7b 10 Apr 2003

overload
User-Space Object Overloading Support 	enabled

pcre
PCRE (Perl Compatible Regular Expressions) Support 	enabled
PCRE Library Version 	4.3 21-May-2003

pgsql
PostgreSQL Support	enabled
PostgreSQL(libpq) Version 	7.3.9
Multibyte character support 	enabled
SSL support 	enabled
Active Persistent Links 	0
Active Links 	0

Directive	Local Value	Master Value
pgsql.allow_persistent	On	On
pgsql.auto_reset_persistent	Off	Off
pgsql.ignore_notice	Off	Off
pgsql.log_notice	Off	Off
pgsql.max_links	Unlimited	Unlimited
pgsql.max_persistent	Unlimited	Unlimited

posix
Revision 	$Revision: 1.51.2.2 $

qtdom
qtdom support	enabled

session
Session Support 	enabled
Registered save handlers 	files user

Directive	Local Value	Master Value
session.auto_start	Off	Off
session.bug_compat_42	On	On
session.bug_compat_warn	On	On
session.cache_expire	180	180
session.cache_limiter	nocache	nocache
session.cookie_domain	no value	no value
session.cookie_lifetime	0	0
session.cookie_path	/	/
session.cookie_secure	Off	Off
session.entropy_file	no value	no value
session.entropy_length	0	0
session.gc_divisor	100	100
session.gc_maxlifetime	1440	1440
session.gc_probability	1	1
session.name	PHPSESSID	PHPSESSID
session.referer_check	no value	no value
session.save_handler	files	files
session.save_path	/tmp	/tmp
session.serialize_handler	php	php
session.use_cookies	On	On
session.use_only_cookies	Off	Off
session.use_trans_sid	Off	Off

shmop
shmop support 	enabled

snmp
UCD-SNMP Support 	enabled
UCD-SNMP Version 	4.2.6

standard
Regex Library 	Bundled library enabled
Dynamic Library Support 	enabled
Path to sendmail 	/usr/sbin/sendmail -t -i

Directive	Local Value	Master Value
assert.active	1	1
assert.bail	0	0
assert.callback	no value	no value
assert.quiet_eval	0	0
assert.warning	1	1
auto_detect_line_endings	0	0
default_socket_timeout	60	60
safe_mode_allowed_env_vars	PHP_	PHP_
safe_mode_protected_env_vars	LD_LIBRARY_PATH	LD_LIBRARY_PATH
url_rewriter.tags	a=href,area=href,frame=src,input=src,form=,fieldset=	a=href,area=href,frame=src,input=src,form=,fieldset=
user_agent	no value	no value

swf
swf support 	enabled

tokenizer
Tokenizer Support 	enabled

wddx
WDDX Support	enabled
WDDX Session Serializer 	enabled

xml
XML Support 	active
XML Namespace Support 	active
EXPAT Version 	1.95.6

xslt
XSLT support 	enabled
Backend 	Sablotron
Sablotron Version 	0.98
Sablotron Information 	Cflags: -O2 -march=i586 -mcpu=i686 -fmessage-length=0 Libs: -L/usr/lib -lexpat Prefix: /usr

yp
YP Support 	enabled

zlib
ZLib Support 	enabled
Compiled Version 	1.1.4
Linked Version 	1.1.4

Directive	Local Value	Master Value
zlib.output_compression	Off	Off
zlib.output_compression_level	-1	-1
zlib.output_handler	no value	no value

Additional Modules
Module Name
dbase
filepro
sysvsem
sysvshm

Environment
Variable	Value
CONSOLE 	/dev/console
TERM 	linux
SHELL 	/bin/sh
get_module_list_done 	true
progress 	17
INIT_VERSION 	sysvinit-2.82
REDIRECT 	/dev/tty1
COLUMNS 	100
get_includes_done 	true
PATH 	/usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin
vga 	0x303
RUNLEVEL 	3
PWD 	/
PREVLEVEL 	N
LINES 	37
HOME 	/
SHLVL 	2
splash 	silent
sscripts 	20
_ 	/sbin/startproc
DAEMON 	/usr/sbin/httpd2-prefork
SWFFONTPATH 	/usr/share/php/swffonts

PHP Variables
Variable	Value
PHP_SELF 	/no_osm/info.php
_REQUEST["phpbb2mysql_data"]	a:0:{}
_COOKIE["phpbb2mysql_data"]	a:0:{}
_SERVER["HTTP_HOST"]	www.domain.de
_SERVER["HTTP_USER_AGENT"]	Mozilla/5.0 (Windows; U; Windows NT 5.1; de-DE; rv:1.7.7) Gecko/20050414 Firefox/1.0.3
_SERVER["HTTP_ACCEPT"]	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
_SERVER["HTTP_ACCEPT_LANGUAGE"]	en-us,en;q=0.7,de-de;q=0.3
_SERVER["HTTP_ACCEPT_ENCODING"]	gzip,deflate
_SERVER["HTTP_ACCEPT_CHARSET"]	ISO-8859-1,utf-8;q=0.7,*;q=0.7
_SERVER["HTTP_KEEP_ALIVE"]	300
_SERVER["HTTP_CONNECTION"]	keep-alive
_SERVER["HTTP_COOKIE"]	phpbb2mysql_data=a%3A0%3A%7B%7D
_SERVER["HTTP_CACHE_CONTROL"]	max-age=0
_SERVER["PATH"]	/usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin
_SERVER["SERVER_SIGNATURE"]	<address>Apache/2.0.48 (Linux/SuSE) Server at www.domain.de Port 80</address>
_SERVER["SERVER_SOFTWARE"]	Apache/2.0.48 (Linux/SuSE)
_SERVER["SERVER_NAME"]	www.domain.de
_SERVER["SERVER_ADDR"]	xx.xx.xxx.xx
_SERVER["SERVER_PORT"]	80
_SERVER["REMOTE_ADDR"]	84.167.95.104
_SERVER["DOCUMENT_ROOT"]	/srv/www/htdocs/web1/html
_SERVER["SERVER_ADMIN"]	[no address given]
_SERVER["SCRIPT_FILENAME"]	/srv/www/htdocs/web1/html/no_osm/info.php
_SERVER["REMOTE_PORT"]	21266
_SERVER["GATEWAY_INTERFACE"]	CGI/1.1
_SERVER["SERVER_PROTOCOL"]	HTTP/1.1
_SERVER["REQUEST_METHOD"]	GET
_SERVER["QUERY_STRING"]	no value
_SERVER["REQUEST_URI"]	/no_osm/info.php
_SERVER["SCRIPT_NAME"]	/no_osm/info.php
_SERVER["PHP_SELF"]	/no_osm/info.php
_SERVER["PATH_TRANSLATED"]	/srv/www/htdocs/web1/html/no_osm/info.php
_SERVER["argv"]	

Array
(
)

_SERVER["argc"]	0
_ENV["CONSOLE"]	/dev/console
_ENV["TERM"]	linux
_ENV["SHELL"]	/bin/sh
_ENV["get_module_list_done"]	true
_ENV["progress"]	17
_ENV["INIT_VERSION"]	sysvinit-2.82
_ENV["REDIRECT"]	/dev/tty1
_ENV["COLUMNS"]	100
_ENV["get_includes_done"]	true
_ENV["PATH"]	/usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin
_ENV["vga"]	0x303
_ENV["RUNLEVEL"]	3
_ENV["PWD"]	/
_ENV["PREVLEVEL"]	N
_ENV["LINES"]	37
_ENV["HOME"]	/
_ENV["SHLVL"]	2
_ENV["splash"]	silent
_ENV["sscripts"]	20
_ENV["_"]	/sbin/startproc
_ENV["DAEMON"]	/usr/sbin/httpd2-prefork
_ENV["SWFFONTPATH"]	/usr/share/php/swffonts
Wenn zur Beantwortung meiner Frage noch mehr infos gebraucht werden, dann gebe ich die gern heraus!

Vielen Dank im Vorraus

Maik
kawfy
Posts: 307
Joined: 2002-08-08 23:45
 

Standardtext Mysql :)

Post by kawfy »

Maik20 wrote:

Code: Select all

Cpu(s):  75.2% user,  24.8% system,   0.0% nice,   0.0% idle
Mem:   2004336k total,   557972k used,  1446364k free,    13592k buffers 
:arrow: Da wird ja klar, dass die CPU am Anschlag arbeitet. Den RAM-Mangel, der bei DB-fordernden Anwendungen so typisch ist, gibt es hier aber nicht. Möglicherweise hast du große Tabellen und kaum Indizes -- das bremst die Queries stark aus.

:!: Die "24.8% system" dürften wohl meist Plattenzugriffe des Mysql-DBMS sein. Mach' mal ein "iostat 1" und lass' das ein paar Sekunden laufen. Alternativ reicht auch "vmstat 1" (falls dir iostat fehlt und du zu faul zum installieren bist ...).

:?: was gibt bei so einem Belastungszustand denn "mysqladmin processlist" aus?

:!: aktiviere mal das mysql-log und fische dir die slow-queries raus und benutze den Mysql-Befehl "explain", um Schwächen in den Queries zu finden.

:idea: hier könnten wohl Mysql-Optimierungen helfen, z. B. mal den einen oder anderen Index setzen, diverse Mysql-Variablen ändern. Falls du dir das Wissen aneignen willst, solltest du ein Mysql-Buch oder ähnlich qualitative "Tuts" im Web benutzen. Auch auf dev.mysql.com gibt es da sicher Material. Falls diese Option für dich nicht in Frage kommt, solltest du den Hersteller des Online-Spieles um Rat fragen.
User avatar
Joe User
Project Manager
Project Manager
Posts: 11191
Joined: 2003-02-27 01:00
Location: Hamburg
Contact:
 

Re: Performance schon bei 200 Usern schlecht

Post by Joe User »

Welche Features des MySQL-Max nutzt Du? Persistente DB-Verbindungen in der php.ini deaktiviert? Query-Cache aktiviert?

BTW: Die Kiste benötigt dringend ein paar Updates, insbesondere der Kernel...
PayPal.Me/JoeUserFreeBSD Remote Installation
Wings for LifeWings for Life World Run

„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.
mausgreck
Posts: 84
Joined: 2005-03-19 17:22
 

Re: Standardtext Mysql :)

Post by mausgreck »

Ich verwende zwar nur PostgreSQL, aber das ist wohl eindeutig ein Fall von:
1) Caches raufdrehen
2) Queries optimieren
z. B. mal den einen oder anderen Index setzen
Aber bitte *nicht* zufällig irgendwelche Indizes setzen - das macht die Sache i.d.R. nur schlimmer.
phillux
Posts: 80
Joined: 2004-03-16 13:47
Location: Münster
 

Re: Performance schon bei 200 Usern schlecht

Post by phillux »

Suche nach "MySQL & Performance" und "PHP & Performance" sollten einige Ansätze bringen.

Weiterhin kann ich dir ein sehr gutes Buch empfehlen: "High Performance MySQL" aus dem O'Reilly Verlag ISBN 3-89721-388-5

Gruß, Phil
Post Reply