OVH Community, your new community space.

slow fourm with a massive server when 500 users online !


BigMAC
12-10-2010, 11:04
Do you have any cache software installed?

If not i would think about getting LBCache.

http://linuxbox.co.uk/vbulletin_cach...th_lbcache.php

Cheers,

Thelen
06-10-2010, 02:37
Heh, typical crappy support from VB then <_<

Myatu makes a good suggestion, baring that you should see there happens to be any cronjob running at that time, or something that for a brief time will tie up SQL.

Myatu
05-10-2010, 19:37
Oof! Other than the memory problems as already pointed out, you had "skip-innodb" enabled as well. I would re-import the tables with innoDB, as they're all in myisam undoubtedly.

When you've done all the things explained by the others, keep the setting for a while and then run mysqltuner (see http://blog.mysqltuner.com/) to see where some bottlenecks are. Very simple script, but very helpful as well.

AdamD
05-10-2010, 18:53
If you need a hand with it, let me know.

I run my own forum on an OVH server (www.uoforums.com) and although it doesn't have AS many people on as yours does, yours shouldn't be slow at all.

jayqoz
05-10-2010, 18:48
Quote Originally Posted by yonatan
only restart the mysql service , not the whole server.
thanks yonatan for your replay , i restarted mysql service and hope this will solve this issue.

Quote Originally Posted by Thelen
Why don't you ask vBulletin for support?

From your description and the low loads etc, it does definitely sound like a Apache -> PHP -> MySQL bottleneck, but without knowing anything about VB specifically I can't say.

they asked me to optimize my database tables , i did but nothing really was helpful

Thelen
05-10-2010, 12:09
Why don't you ask vBulletin for support?

From your description and the low loads etc, it does definitely sound like a Apache -> PHP -> MySQL bottleneck, but without knowing anything about VB specifically I can't say.

yonatan
05-10-2010, 07:36
only restart the mysql service , not the whole server.

jayqoz
05-10-2010, 02:16
Quote Originally Posted by gregoryfenton
Just a few changes to try in mysqld:
Code:
[mysqld] 
character-set-server        = latin1 
init-connect='SET NAMES  latin1' 
default-character-set        = latin1 
user                         = mysql 
port                         = 3306 
socket                         = /var/run/mysqld/mysqld.sock 
pid-file                     = /var/run/mysqld/mysqld.pid 
log-error                     = /var/log/mysql/mysqld.err 
basedir                     = /usr 
datadir                     = /var/lib/mysql 
skip-locking 
key_buffer                     = 128M 
max_allowed_packet             = 1M 
table_cache                 = 128 
sort_buffer_size             = 512K 
net_buffer_length             = 8K 
read_buffer_size             = 256K 
read_rnd_buffer_size         = 512K 
myisam_sort_buffer_size     = 8M 
language                     = /usr/share/mysql/english
i will apply these changes right now

do i need to restart the server afterward ? or changes will apply in real time ?

also what if i doubled these values ? would it be better ?
these small values like 1M really annoy me

gregoryfenton
05-10-2010, 00:47
Just a few changes to try in mysqld:
Code:
[mysqld] 
character-set-server        = latin1 
init-connect='SET NAMES  latin1' 
default-character-set        = latin1 
user                         = mysql 
port                         = 3306 
socket                         = /var/run/mysqld/mysqld.sock 
pid-file                     = /var/run/mysqld/mysqld.pid 
log-error                     = /var/log/mysql/mysqld.err 
basedir                     = /usr 
datadir                     = /var/lib/mysql 
skip-locking 
key_buffer                     = 128M 
max_allowed_packet             = 1M 
table_cache                 = 128 
sort_buffer_size             = 512K 
net_buffer_length             = 8K 
read_buffer_size             = 256K 
read_rnd_buffer_size         = 512K 
myisam_sort_buffer_size     = 8M 
language                     = /usr/share/mysql/english

jayqoz
04-10-2010, 23:15
and thats my setting for PHP ( i had to delete the first part becasue posts are limited to 30000 characters long.

[PHP]
PHP Code:

;;;;;;;;;;;;;;;;;;;
Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time 90     Maximum execution time of each scriptin seconds
max_input_time 
120    Maximum amount of time each script may spend parsing request data
memory_limit 
1028M      Maximum amount of memory a script may consume (1024MB)


;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
Error handling and logging ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

error_reporting is a bit-field.  Or each number up to get desired error
reporting level
E_ALL             All errors and warnings (doesn't include E_STRICT)
; E_ERROR           - fatal run-time errors
; E_WARNING         - run-time warnings (non-fatal errors)
; E_PARSE           - compile-time parse errors
; E_NOTICE          - run-time notices (these are warnings which often result
;                     from a bug in your code, but it'
s possible that it was
;                     intentional (e.g., using an uninitialized variable and
;                     
relying on the fact it's automatically initialized to an
;                     empty string)
; E_STRICT            - run-time notices, enable to have PHP suggest changes
;                     to your code which will ensure the best interoperability
;                     and forward compatibility of your code
; E_CORE_ERROR      - fatal errors that occur during PHP'
s initial startup
E_CORE_WARNING    warnings (non-fatal errorsthat occur during PHP's
;                     initial startup
; E_COMPILE_ERROR   - fatal compile-time errors
; E_COMPILE_WARNING - compile-time warnings (non-fatal errors)
; E_USER_ERROR      - user-generated error message
; E_USER_WARNING    - user-generated warning message
; E_USER_NOTICE     - user-generated notice message
;
; Examples:
;
;   - Show all errors, except for notices and coding standards warnings
;
;error_reporting = E_ALL & ~E_NOTICE
;
;   - Show all errors, except for notices
;
;error_reporting = E_ALL & ~E_NOTICE | E_STRICT
;
;   - Show only errors
;
;error_reporting = E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR
;
;   - Show all errors except for notices and coding standards warnings
;
error_reporting  =  E_ALL & ~E_NOTICE

; Print out errors (as a part of the output).  For production web sites,
; you'
re strongly encouraged to turn this feature off, and use error logging
instead (see below).  Keeping display_errors enabled on a production web site
may reveal security information to end userssuch as file paths on your Web
serveryour database schema or other information.
display_errors On

Even when display_errors is onerrors that occur during PHP's startup
; sequence are not displayed.  It'
s strongly recommended to keep
display_startup_errors offexcept for when debugging.
display_startup_errors Off

Log errors into a log file (server-specific logstderr, or error_log (below))
; As 
stated aboveyou're strongly advised to use error logging in place of
; error displaying on production web sites.
log_errors = Off

; Set maximum length of log_errors. In error_log information about the source is
; added. The default is 1024 and 0 allows to not apply any maximum length at all.
log_errors_max_len = 1024

; Do not log repeated messages. Repeated errors must occur in same file on same
; line until ignore_repeated_source is set true.
ignore_repeated_errors = Off

; Ignore source of message when ignoring repeated messages. When this setting
; is On you will not log errors with repeated messages from different files or
; sourcelines.
ignore_repeated_source = Off

; If this parameter is set to Off, then memory leaks will not be shown (on
; stdout or in the log). This has only effect in a debug compile, and if
; error reporting includes E_WARNING in the allowed list
report_memleaks = On

; Store the last error/warning message in $php_errormsg (boolean).
track_errors = Off

; Disable the inclusion of HTML tags in error messages.
; Note: Never use this feature for production boxes.
;html_errors = Off

; If html_errors is set On PHP produces clickable error messages that direct
; to a page describing the error or function causing the error in detail.
; You can download a copy of the PHP manual from http://www.php.net/docs.php
; and change docref_root to the base URL of your local copy including the
; leading '
/'. You must also specify the file extension being used including
; the dot.
; Note: Never use this feature for production boxes.
;docref_root = "/phpmanual/"
;docref_ext = .html

; String to output before an error message.
;error_prepend_string = ""

; String to output after an error message.
;error_append_string = ""

; Log errors to specified file.
;error_log = filename

; Log errors to syslog (Event Log on NT, not valid in Windows 95).
;error_log = syslog


;;;;;;;;;;;;;;;;;
; Data Handling ;
;;;;;;;;;;;;;;;;;
;
; Note - track_vars is ALWAYS enabled as of PHP 4.0.3

; The separator used in PHP generated URLs to separate arguments.
; Default is "&".
;arg_separator.output = "&"

; List of separator(s) used by PHP to parse input URLs into variables.
; Default is "&".
; NOTE: Every character in this directive is considered as separator!
;arg_separator.input = ";&"

; This directive describes the order in which PHP registers GET, POST, Cookie,
; Environment and Built-in variables (G, P, C, E & S respectively, often
; referred to as EGPCS or GPC).  Registration is done from left to right, newer
; values override older values.
variables_order = "EGPCS"

; Whether or not to register the EGPCS variables as global variables.  You may
; want to turn this off if you don'
t want to clutter your scripts' global scope
; with user data.  This makes most sense when coupled with track_vars - in which
; case you can access all of the GPC variables through the $HTTP_*_VARS[],
; variables.
;
; You should do your best to write your scripts so that they do not require
; register_globals to be on;  Using form variables as globals can easily lead
; to possible security problems, if the code is not very well thought of.
register_globals = Off

; Whether or not to register the old-style input arrays, HTTP_GET_VARS
; and friends.  If you'
re not using themit's recommended to turn them off,
; for performance reasons.
register_long_arrays = On

; This directive tells PHP whether to declare the argv&argc variables (that
; would contain the GET information).  If you don'
use these variablesyou
should turn it off for increased performance.
register_argc_argv On

When enabledthe SERVER and ENV variables are created when they're first
; used (Just In Time) instead of when the script starts. If these variables
; are not used within a script, having this directive on will result in a
; performance gain. The PHP directives register_globals, register_long_arrays,
; and register_argc_argv must be disabled for this directive to have any affect.
auto_globals_jit = On

; Maximum size of POST data that PHP will accept.
post_max_size = 92M

; Magic quotes
;

; Magic quotes for incoming GET/POST/Cookie data.
magic_quotes_gpc = On

; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.
magic_quotes_runtime = Off

; Use Sybase-style magic quotes (escape ' 
with '' instead of \').
magic_quotes_sybase = Off

; Automatically add files before or after any PHP document.
auto_prepend_file =
auto_append_file =

; As of 4.0b4, PHP always outputs a character encoding by default in
; the Content-type: header.  To disable sending of the charset, simply
; set it to be empty.
;
; PHP'
s built-in default is text/html
default_mimetype 
"text/html"
;default_charset "iso-8859-1"

Always populate the $HTTP_RAW_POST_DATA variable.
;
always_populate_raw_post_data On


;;;;;;;;;;;;;;;;;;;;;;;;;
Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;

UNIX"/path1:/path2"
include_path ".:/usr/share/php5"
;
Windows"\path1;\path2"
;include_path ".;c:\php\includes"

The root of the PHP pagesused only if nonempty.
; if 
PHP was not compiled with FORCE_REDIRECTyou SHOULD set doc_root
; if you are running php as a CGI under any web server (other than IIS)
see documentation for security issues.  The alternate is to use the
cgi.force_redirect configuration below
doc_root 
=

The directory under which PHP opens the script using /~username used only
; if nonempty.
user_dir =

Directory in which the loadable extensions (modulesreside.
extension_dir "./"

Whether or not to enable the dl() function.  The dl() function does NOT work
properly in multithreaded serverssuch as IIS or Zeus, and is automatically
disabled on them.
enable_dl On

cgi.force_redirect is necessary to provide security running PHP as a CGI under
most web servers.  Left undefinedPHP turns this on by default.  You can
turn it off here AT YOUR OWN RISK
; **You CAN safely turn this off for IISin factyou MUST.**
cgi.force_redirect 1

; if cgi.nph is enabled it will force cgi to always sent Status200 with
every request.
cgi.nph 1

; if cgi.force_redirect is turned on, and you are not running under Apache or Netscape
; (iPlanetweb serversyou MAY need to set an environment variable name that PHP
will look for to know it is OK to continue execution.  Setting this variable MAY
cause security issuesKNOW WHAT YOU ARE DOING FIRST.
cgi.redirect_status_env = ;

FastCGI under IIS (on WINNT based OSsupports the ability to impersonate
security tokens of the calling client.  This allows IIS to define the
security context that the request runs under.  mod_fastcgi under Apache
does not currently support this feature (03/17/2002)
Set to 1 if running under IIS.  Default is zero.
fastcgi.impersonate 1;

Disable logging through FastCGI connection
fastcgi.log 0

cgi.rfc2616_headers configuration option tells PHP what type of headers to
; use when sending HTTP response code. If it's set 0 PHP sends Status: header that
; is supported by Apache. When this option is set to 1 PHP will send
; RFC2616 compliant header.
; Default is zero.
;cgi.rfc2616_headers = 0


;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;

; Whether to allow HTTP file uploads.
file_uploads = On

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
;upload_tmp_dir =

; Maximum allowed size for uploaded files.
upload_max_filesize = 100M


;;;;;;;;;;;;;;;;;;
; Fopen wrappers ;
;;;;;;;;;;;;;;;;;;

; Whether to allow the treatment of URLs (like http:// or ftp://) as files.
allow_url_fopen = On

; Define the anonymous ftp password (your email address)
;from="john@doe.com"

; Define the User-Agent string
; user_agent="PHP"

; Default timeout for socket based streams (seconds)
default_socket_timeout = 120

; If your scripts have to deal with files from Macintosh systems,
; or you are running on a Mac and need to deal with files from
; unix or win32 systems, setting this flag will cause PHP to
; automatically detect the EOL character in those files so that
; fgets() and file() will work regardless of the source of the file.
; auto_detect_line_endings = Off


;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
;
; If you wish to have an extension loaded automatically, use the following
; syntax:
;
;   extension=modulename.extension
;
; For example, on Windows:
;
;   extension=msql.dll
;
; ... or under UNIX:
;
;   extension=msql.so
;
; Note that it should be the name of the module only; no directory information
; needs to go here.  Specify the location of the extension with the
; extension_dir directive above.


; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.

;extension=php_mbstring.dll
;extension=php_bz2.dll
;extension=php_curl.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_exif.dll
;extension=php_fdf.dll
;extension=php_filepro.dll
;extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_ifx.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
;extension=php_mssql.dll
;extension=php_msql.dll
;extension=php_mysql.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_oracle.dll
;extension=php_pgsql.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_sockets.dll
;extension=php_sqlite.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
;extension=php_xmlrpc.dll
;extension=php_xsl.dll


;;;;;;;;;;;;;;;;;;;
; Module Settings ;
;;;;;;;;;;;;;;;;;;;

[Date]
; Defines the default timezone used by the date functions
;date.timezone = 

[Syslog]
; Whether or not to define the various syslog variables (e.g. $LOG_PID,
; $LOG_CRON, etc.).  Turning it off is a good idea performance-wise.  In
; runtime, you can define these variables by calling define_syslog_variables().
define_syslog_variables  = Off

[mail function]
; For Win32 only.
SMTP = localhost
smtp_port = 25

; For Win32 only.
;sendmail_from = me@example.com

; For Unix only.  You may supply arguments as well (default: "sendmail -t -i").
;sendmail_path =

; Force the addition of the specified parameters to be passed as extra parameters
; to the sendmail binary. These parameters will always replace the value of
; the 5th parameter to mail(), even in safe mode.
;mail.force_extra_parameters =

[SQL]
sql.safe_mode = Off

[ODBC]
;odbc.default_db    =  Not yet implemented
;odbc.default_user  =  Not yet implemented
;odbc.default_pw    =  Not yet implemented

; Allow or prevent persistent links.
odbc.allow_persistent = On

; Check that a connection is still valid before reuse.
odbc.check_persistent = On

; Maximum number of persistent links.  -1 means no limit.
odbc.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
odbc.max_links = -1

; Handling of LONG fields.  Returns number of bytes to variables.  0 means
; passthru.
odbc.defaultlrl = 4096

; Handling of binary data.  0 means passthru, 1 return as is, 2 convert to char.
; See the documentation on odbc_binmode and odbc_longreadlen for an explanation
; of uodbc.defaultlrl and uodbc.defaultbinmode
odbc.defaultbinmode = 1

[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
mysql.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
mysql.max_links = -1

; Default port number for mysql_connect().  If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysql.default_port =

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =

; Default host for mysql_connect() (doesn'
t apply in safe mode).
mysql.default_host =

; Default 
user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =

; Default password for mysql_connect() (doesn'
t apply in safe mode).
Note that this is generally a *badidea to store passwords in this file.
; *
Anyuser with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =

; Maximum time (in secondes) for connect timeout. -1 means no limit
mysql.connect_timeout = 60

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Errors will be displayed.
mysql.trace_mode = Off

[MySQLi]

; Maximum number of links.  -1 means no limit.
mysqli.max_links = -1

; Default port number for mysqli_connect().  If unset, mysqli_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysqli.default_port = 3306

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysqli.default_socket =

; Default host for mysql_connect() (doesn'
t apply in safe mode).
mysqli.default_host =

; Default 
user for mysql_connect() (doesn't apply in safe mode).
mysqli.default_user =

; Default password for mysqli_connect() (doesn'
t apply in safe mode).
Note that this is generally a *badidea to store passwords in this file.
; *
Anyuser with PHP access can run 'echo get_cfg_var("mysqli.default_pw")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysqli.default_pw =

; Allow or prevent reconnect
mysqli.reconnect = Off

[mSQL]
; Allow or prevent persistent links.
msql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
msql.max_persistent = -1

; Maximum number of links (persistent+non persistent).  -1 means no limit.
msql.max_links = -1

[PostgresSQL]
; Allow or prevent persistent links.
pgsql.allow_persistent = On

; Detect broken persistent links always with pg_pconnect().
; Auto reset feature requires a little overheads.
pgsql.auto_reset_persistent = Off

; Maximum number of persistent links.  -1 means no limit.
pgsql.max_persistent = -1

; Maximum number of links (persistent+non persistent).  -1 means no limit.
pgsql.max_links = -1

; Ignore PostgreSQL backends Notice message or not.
; Notice message logging require a little overheads.
pgsql.ignore_notice = 0

; Log PostgreSQL backends Noitce message or not.
; Unless pgsql.ignore_notice=0, module cannot log notice message.
pgsql.log_notice = 0

[Sybase]
; Allow or prevent persistent links.
sybase.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
sybase.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
sybase.max_links = -1

;sybase.interface_file = "/usr/sybase/interfaces"

; Minimum error severity to display.
sybase.min_error_severity = 10

; Minimum message severity to display.
sybase.min_message_severity = 10

; Compatability mode with old versions of PHP 3.0.
; If on, this will cause PHP to automatically assign types to results according
; to their Sybase type, instead of treating them all as strings.  This
; compatibility mode will probably not stay around forever, so try applying
; whatever necessary changes to your code, and turn it off.
sybase.compatability_mode = Off

[Sybase-CT]
; Allow or prevent persistent links.
sybct.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
sybct.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
sybct.max_links = -1

; Minimum server message severity to display.
sybct.min_server_severity = 10

; Minimum client message severity to display.
sybct.min_client_severity = 10

[bcmath]
; Number of decimal digits for all bcmath functions.
bcmath.scale = 0

[browscap]
;browscap = extra/browscap.ini

[Informix]
; Default host for ifx_connect() (doesn'
t apply in safe mode).
ifx.default_host =

; Default 
user for ifx_connect() (doesn't apply in safe mode).
ifx.default_user =

; Default password for ifx_connect() (doesn'
t apply in safe mode).
ifx.default_password =

Allow or prevent persistent links.
ifx.allow_persistent On

Maximum number of persistent links.  -1 means no limit.
ifx.max_persistent = -1

Maximum number of links (persistent non-persistent).  -1 means no limit.
ifx.max_links = -1

; If onselect statements return the contents of a text blob instead of its id.
ifx.textasvarchar 0

; If onselect statements return the contents of a byte blob instead of its id.
ifx.byteasvarchar 0

Trailing blanks are stripped from fixed-length char columns.  May help the
life of Informix SE users.
ifx.charasvarchar 0

; If onthe contents of text and byte blobs are dumped to a file instead of
keeping them in memory.
ifx.blobinfile 0

NULL's are returned as empty strings, unless this is set to 1.  In that case,
; NULL'
s are returned as string 'NULL'.
ifx.nullformat 0

[Session]
Handler used to store/retrieve data.
session.save_handler files

Argument passed to save_handler.  In the case of filesthis is the path
where data files are storedNoteWindows users have to change this
variable in order to use PHP's session functions.
;
; As of PHP 4.0.1, you can define the path as:
;
;     session.save_path = "N;/path"
;
; where N is an integer.  Instead of storing all the session files in
; /path, what this will do is use subdirectories N-levels deep, and
; store the session data in those directories.  This is useful if you
; or your OS have problems with lots of files in one directory, and is
; a more efficient layout for servers that handle lots of sessions.
;
; NOTE 1: PHP will not create this directory structure automatically.
;         You can use the script in the ext/session dir for that purpose.
; NOTE 2: See the section on garbage collection below if you choose to
;         use subdirectories for session storage
;
; The file storage module creates files using mode 600 by default.
; You can change that by using
;
;     session.save_path = "N;MODE;/path"
;
; where MODE is the octal representation of the mode. Note that this
; does not overwrite the process'
s umask.
;
session.save_path "/tmp"

Whether to use cookies.
session.use_cookies 1

This option enables administrators to make their users invulnerable to
attacks which involve passing session ids in URLsdefaults to 0.
session.use_only_cookies 1

Name of the session (used as cookie name).
session.name PHPSESSID

Initialize session on request startup.
session.auto_start 0

Lifetime in seconds of cookie or, if 0until browser is restarted.
session.cookie_lifetime 0

The path for which the cookie is valid.
session.cookie_path = /

The domain for which the cookie is valid.
session.cookie_domain =

Handler used to serialize data.  php is the standard serializer of PHP.
session.serialize_handler php

Define the probability that the 'garbage collection' process is started
on every session initialization.
The probability is calculated by using gc_probability/gc_divisor,
e.g1/100 means there is a 1chance that the GC process starts
on each request.

session.gc_probability 1
session
.gc_divisor     100

After this number of secondsstored data will be seen as 'garbage' and
cleaned up by the garbage collection process.
session.gc_maxlifetime 1440

NOTE: If you are using the subdirectory option for storing session files
;       (see session.save_path above), then garbage collection does *not*
;       
happen automatically.  You will need to do your own garbage
;       collection through a shell scriptcron entry, or some other method.
;       For 
examplethe following script would is the equivalent of
;       setting session.gc_maxlifetime to 1440 (1440 seconds 24 minutes):
;          
cd /path/to/sessionsfind -cmin +24 xargs rm

PHP 4.2 and less have an undocumented feature/bug that allows you to
to initialize a session variable in the global scopealbeit register_globals
is disabled.  PHP 4.3 and later will warn you, if this feature is used.
You can disable the feature and the warning separatelyAt this time,
the warning is only displayed, if bug_compat_42 is enabled.

session.bug_compat_42 1
session
.bug_compat_warn 1

Check HTTP Referer to invalidate externally stored URLs containing ids.
HTTP_REFERER has to contain this substring for the session to be
considered as valid.
session.referer_check =

How many bytes to read from the file.
session.entropy_length 0

Specified here to create the session id.
session.entropy_file =

;
session.entropy_length 16

;session.entropy_file = /dev/urandom

Set to {nocache,private,public,} to determine HTTP caching aspects
; or leave this empty to avoid sending anti-caching headers.
session.cache_limiter nocache

Document expires after n minutes.
session.cache_expire 180

trans sid support is disabled by default.
; Use 
of trans sid may risk your users security.
; Use 
this option with caution.
; - 
User may send URL contains active session ID
;   to other person viaemail/irc/etc.
; - 
URL that contains active session ID may be stored
;   in publically accessible computer.
; - 
User may access your site with the same session ID
;   always using URL stored in browser's history or bookmarks.
session.use_trans_sid = 0

; Select a hash function
; 0: MD5   (128 bits)
; 1: SHA-1 (160 bits)
session.hash_function = 0

; Define how many bits are stored in each character when converting
; the binary hash data to something readable.
;
; 4 bits: 0-9, a-f
; 5 bits: 0-9, a-v
; 6 bits: 0-9, a-z, A-Z, "-", ","
session.hash_bits_per_character = 4

; The URL rewriter will look for URLs in a defined set of HTML tags.
; form/fieldset are special; if you include them here, the rewriter will
; add a hidden  field with the info which is otherwise appended
; to URLs.  If you want XHTML conformity, remove the form entry.
; Note that all valid entries require a "=", even if no value follows.
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="

[MSSQL]
; Allow or prevent persistent links.
mssql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
mssql.max_persistent = -1

; Maximum number of links (persistent+non persistent).  -1 means no limit.
mssql.max_links = -1

; Minimum error severity to display.
mssql.min_error_severity = 10

; Minimum message severity to display.
mssql.min_message_severity = 10

; Compatability mode with old versions of PHP 3.0.
mssql.compatability_mode = Off

; Connect timeout
;mssql.connect_timeout = 5

; Query timeout
;mssql.timeout = 60

; Valid range 0 - 2147483647.  Default = 4096.
;mssql.textlimit = 4096

; Valid range 0 - 2147483647.  Default = 4096.
;mssql.textsize = 4096

; Limits the number of records in each batch.  0 = all records in one batch.
;mssql.batchsize = 0

; Specify how datetime and datetim4 columns are returned
; On => Returns data converted to SQL server settings
; Off => Returns values as YYYY-MM-DD hh:mm:ss
;mssql.datetimeconvert = On

; Use NT authentication when connecting to the server
mssql.secure_connection = Off

; Specify max number of processes. -1 = library default
; msdlib defaults to 25
; FreeTDS defaults to 4096
;mssql.max_procs = -1

; Specify client character set. 
; If empty or not set the client charset from freetds.comf is used
; This is only used when compiled with FreeTDS
;mssql.charset = "ISO-8859-1"

[Assertion]
; Assert(expr); active by default.
;assert.active = On

; Issue a PHP warning for each failed assertion.
;assert.warning = On

; Don'
t bail out by default.
;
assert.bail Off

User-function to be called if an assertion fails.
;
assert.callback 0

; Eval the expression with current error_reporting().  Set to true if you want
error_reporting(0around the eval().
;
assert.quiet_eval 0

[Verisign Payflow Pro]
; Default 
Payflow Pro server.
pfpro.defaulthost "test-payflow.verisign.com"

; Default port to connect to.
pfpro.defaultport 443

; Default timeout in seconds.
pfpro.defaulttimeout 30

; Default proxy IP address (if required).
;
pfpro.proxyaddress =

; Default 
proxy port.
;
pfpro.proxyport =

; Default 
proxy logon.
;
pfpro.proxylogon =

; Default 
proxy password.
;
pfpro.proxypassword =

[
COM]
path to a file containing GUIDsIIDs or filenames of files with TypeLibs
;com.typelib_file =
allow Distributed-COM calls
;com.allow_dcom true
autoregister constants of a components typlib on com_load()
;
com.autoregister_typelib true
register constants casesensitive
;com.autoregister_casesensitive false
show warnings on duplicate constat registrations
;com.autoregister_verbose true

[mbstring]
language for internal character representation.
;
mbstring.language Japanese

internal/script encoding.
Some encoding cannot work as internal encoding.
; (
e.gSJISBIG5ISO-2022-*)
;
mbstring.internal_encoding EUC-JP

http input encoding.
;
mbstring.http_input auto

http output encodingmb_output_handler must be
registered as output buffer to function
;
mbstring.http_output SJIS

enable automatic encoding translation according to
mbstring.internal_encoding settingInput chars are
converted to internal encoding by setting this to On.
Note: Do _not_ use automatic encoding translation for
;       
portable libs/applications.
;
mbstring.encoding_translation Off

automatic encoding detection order.
auto means
;mbstring.detect_order auto

substitute_character used when character cannot be converted
one from another
;mbstring.substitute_character none;

overload(replacesingle byte functions by mbstring functions.
mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),
etcPossible values are 0,1,2,or combination of them.
; For 
examplefor overload everything.
0No overload
1Overload mail() function
2Overload str*() functions
4Overload ereg*() functions
;mbstring.func_overload 0

enable strict encoding detection.
;
mbstring.strict_encoding Off

[FrontBase]
;
fbsql.allow_persistent On
;fbsql.autocommit On
;fbsql.default_database =
;
fbsql.default_database_password =
;
fbsql.default_host =
;
fbsql.default_password =
;
fbsql.default_user "_SYSTEM"
;fbsql.generate_warnings Off
;fbsql.max_connections 128
;fbsql.max_links 128
;fbsql.max_persistent = -1
;fbsql.max_results 128
;fbsql.batchSize 1000 

jayqoz
04-10-2010, 23:09
Quote Originally Posted by gregoryfenton
post your mysql settings and php settings

It could be an issue with memory usage (possibly not enough memory dedicated to mysql).


thanks gergoyfenton for your replay , i havent changed the configration for MySQL since i staretd on this server , could it be a problem ?


anyway this is the MySQL setting for my server
PHP Code:
# /etc/mysql/my.cnf: The global mysql configuration file.
# $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1,v 1.3 2006/05/05 19:51:40 chtekk Exp $

# The following options will be passed to all MySQL clients
[client]
#password                    = your_password
port                        3306
socket                        
= /var/run/mysqld/mysqld.sock
character
-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1

[php-cgi]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1

[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1

[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1

[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1

[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1

[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1

[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1

[myisamchk]
character-sets-dir=/usr/share/mysql/charsets

[myisampack]
character-sets-dir=/usr/share/mysql/charsets

# use [safe_mysqld] with mysql-3
[mysqld_safe]
err-log                        = /var/log/mysql/mysql.err

# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations
[mysqld]
character-set-server        latin1
init
-connect='SET NAMES  latin1'
default-character-set        latin1
user                         
mysql
port                         
3306
socket                         
= /var/run/mysqld/mysqld.sock
pid
-file                     = /var/run/mysqld/mysqld.pid
log
-error                     = /var/log/mysql/mysqld.err
basedir                     
= /usr
datadir                     
= /var/lib/mysql
skip
-locking
key_buffer                     
16M
max_allowed_packet             
1M
table_cache                 
64
sort_buffer_size             
512K
net_buffer_length             
8K
read_buffer_size             
256K
read_rnd_buffer_size         
512K
myisam_sort_buffer_size     
8M
language                     
= /usr/share/mysql/english

# security:
# using "localhost" in connects uses sockets by default
skip-networking
#bind-address                = 127.0.0.1

log-bin
server
-id                     1

# point the following paths to different dedicated disks
tmpdir                         = /tmp/
#log-update                 = /path-to-dedicated-directory/hostname

# you need the debug USE flag enabled to use the following directives,
# if needed, uncomment them, start the server and issue 
# #tail -f /tmp/mysqld.sql /tmp/mysqld.trace
# this will show you *exactly* what's happening in your server ;)

#log                        = /tmp/mysqld.sql
#gdb
#debug                        = d:t:i:o,/tmp/mysqld.trace
#one-thread

# uncomment the following directives if you are using BDB tables
#bdb_cache_size                = 4M
#bdb_max_lock                = 10000

# the following is the InnoDB configuration
# if you wish to disable innodb instead
# uncomment just the next line
skip-innodb
#
# the rest of the innodb config follows:
# don't eat too much memory, we're trying to be safe on 64Mb boxes
# you might want to bump this up a bit on boxes with more RAM
innodb_buffer_pool_size 16M
# this is the default, increase it if you have lots of tables
innodb_additional_mem_pool_size 2M
#
# i'd like to use /var/lib/mysql/innodb, but that is seen as a database :-(
# and upstream wants things to be under /var/lib/mysql/, so that's the route
# we have to take for the moment
#innodb_data_home_dir        = /var/lib/mysql/
#innodb_log_arch_dir        = /var/lib/mysql/
#innodb_log_group_home_dir    = /var/lib/mysql/
# you may wish to change this size to be more suitable for your system
# the max is there to avoid run-away growth on your machine
innodb_data_file_path ibdata1:10M:autoextend:max:128M
# we keep this at around 25% of of innodb_buffer_pool_size
# sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size)
innodb_log_file_size 5M
# this is the default, increase it if you have very large transactions going on
innodb_log_buffer_size 8M
# this is the default and won't hurt you
# you shouldn't need to tweak it
set-variable innodb_log_files_in_group=2
# see the innodb config docs, the other options are not always safe
innodb_flush_log_at_trx_commit 1
innodb_lock_wait_timeout 
50

[mysqldump]
quick
max_allowed_packet             
16M

[mysql]
# uncomment the next directive if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer                     20M
sort_buffer_size             
20M
read_buffer                 
2M
write_buffer                 
2M

[myisamchk]
key_buffer                     20M
sort_buffer_size             
20M
read_buffer                 
2M
write_buffer                 
2M

[mysqlhotcopy]
interactive-timeout 

jayqoz
04-10-2010, 23:02
Quote Originally Posted by zydron
Database could be problem indeed, now you say it...

Vbulletin stores a lot of data into the database EVERY HIT!.

You can't simply compare sites with each other, because you don't know the background infrastructure.

Could you post the processor load for these 2 proccesses?
Apache and MySQL
hello again zyrdon and i really appreciate your help and support

i am not that good with servers , i could not find the processor load for Apache and MySQL

but i referred to friday records ( the peak time ) and i found out the highest 5 processes ...

Memory usage - top 5 processes
Process name Memory size [kB]
1. /usr/sbin/clamd 194332
2. /usr/sbin/spamd -d -r /var/run/spamd/spamd.pid -m 5 -H -u qscand -v -x --siteconfigpath?/etc/spamassassin/ 78644
3. spamd child 78644
4. spamd child 78644
5. /usr/libexec/webmin/file/upload.cgi



how can i find the load for Apache and Myself.


i also forgot to mention that Mysql settings and configuration is deafult.

gregoryfenton
04-10-2010, 22:13
post your mysql settings and php settings

It could be an issue with memory usage (possibly not enough memory dedicated to mysql).

zydron
04-10-2010, 22:05
Database could be problem indeed, now you say it...

Vbulletin stores a lot of data into the database EVERY HIT!.

You can't simply compare sites with each other, because you don't know the background infrastructure.

Could you post the processor load for these 2 proccesses?
Apache and MySQL

YouWhat
04-10-2010, 22:05
they prob have some sort of load balancing in place on their servers so as they can then support that many users at any given time.

What you have to remember is that VBulletin is driven by php / mysql and so the database get called on not only for what data is being requested for each forum post, but also those logging in and out, the forum setting and more so it gets quite a heavy load, and the more users online at once the greater the load on the database / server.

jayqoz
04-10-2010, 21:57
Quote Originally Posted by YouWhat
My first guess would be the database read / write being the root of the problem for you especially if alot of members / users on there at once hammering away at it.
thanks YouWhat for the quick replay, could you please visit this forum http://www.traidnt.net/vb/ ?
this website has 20434 online user ! (1726 member and 18708 guest )
and nothing wrong with it.


thats nothing comared to my website www.animeiat.com/vb

so what do you think ?

YouWhat
04-10-2010, 21:48
My first guess would be the database read / write being the root of the problem for you especially if alot of members / users on there at once hammering away at it.

jayqoz
04-10-2010, 21:44

sorry zydron and thanks for your replay , i made it in colur to make it easy to read

currently i am on
Bi-Xeon / Bi-Opteron MG-10R BestOF

the load becomes on the whole website on peak times , i only have vbulltien script on my website , thats all.
i believe that my server is slow because everyone is complaining about it.



here is the black text version



--------------------------
Hi there

i am having a problem about more than 6 months ago

i have a website with vbulltien 3.7.3 forum.

my website is deadly slow when online users counter reaches 500 online users - peak times on ( Thursday night and Friday )




solutions:
people advised me migrate my data

so i transferred my website from RPS3 to a dadicated server SP-10R SSD
with the following specs:

-Processor: Intel Core i5 750 4x 2.66+ GHz 8 Mb L2 - QPI 2.5 GT/sec
-RAM: 8 GB DDR3
-HARDDISK: 2x 80 GB
-PORT: 100 MB/s

the problem still exists as before !!!

so i decided to upgrade my server from
dadicated server SP-10R SSD to Bi-Xeon / Bi-Opteron MG-10R BestOF
with the following specs:

-processesor: Intel Bi Xeon E5504 8x 2.00+ GHz
-RAM: 24 GB DDR3
-Harddisk: 2x 1500 GB - SATA2
-Port: 1GB/s

nothing really changed !!!

i keep paying 49 pounds for setup new server + monthly fees every time and nothing really helps !!


some useful statistics :

load on server at the time of slowness (peak times) Thursday evenings and Fridays:

-Load CPU : 4 %
-Load RAM : 6 %
-Load SWAP : 0 %

load on server at off peak time

-Load CPU : 4 %
-Load RAM :5 %
-Load SWAP : 0 %

average load

Average load ( loadavg1 ) : 0.25
Average load ( loadavg2 ) : 0.24
Average load ( loadavg3 ) : 0.19
Process(es) active ( loadactive ) : 0
Process(es) started ( loadup ) : 418


Controll panel : webmin

i am desperately looking for a generous help
is the problem from my all servers ? settings ? control panel ???


------------

zydron
04-10-2010, 21:36
off: Well first of all, remove the colors in your post, and post in black only, and a smaller font, get a headache from it.

on: Do you know what part is slow?
The server it self or just the connection?

RPS is not the fastest solution you can get though...

You post the load of the server, I have run a video site, which was high cpu load, but no slowing down. (celeron proccessor btw)
maybe its just the connection, which is jamming then?

jayqoz
04-10-2010, 21:13
Hi there

i am having a problem about more than 6 months ago


i have a website with vbulltien 3.7.3 forum www.aimeiat.com/vb.


my website is deadly slow when online users counter reaches 500 online users - peak times on ( Thursday night and Friday )





solutions:

people advised me migrate my data

so i transferred my website from
RPS3 to a dadicated server SP-10R SSD
with the following specs:

-Processor: Intel Core i5 750 4x 2.66+ GHz 8 Mb L2 - QPI 2.5 GT/sec
-RAM: 8 GB DDR3
-HARDDISK: 2x 80 GB
-PORT: 100 MB/s

the problem still exists as before !!!

so i decided to upgrade my server from
dadicated server SP-10R SSD to Bi-Xeon / Bi-Opteron MG-10R BestOF

with the following specs:

-processesor: Intel Bi Xeon E5504 8x 2.00+ GHz
-RAM: 24 GB DDR3
-Harddisk: 2x 1500 GB - SATA2
-Port: 1GB/s

nothing really changed !!!

i keep paying 49 pounds for setup new server + monthly fees every time and nothing really helps !!


some useful statistics :

load on server at the time of slowness (peak times) Thursday evenings and Fridays:

-Load CPU : 4 %
-Load RAM : 6 %
-Load SWAP : 0 %

load on server at off peak time

-Load CPU : 4 %
-Load RAM :5 %
-Load SWAP : 0 %

average load

Average load ( loadavg1 ) : 0.25
Average load ( loadavg2 ) : 0.24
Average load ( loadavg3 ) : 0.19
Process(es) active ( loadactive ) : 0
Process(es) started ( loadup ) : 418


Controll panel : webmin

i am desperately looking for a generous help
is the problem from my all servers ? settings ? control panel ???