The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
server surcharge
Hi guys
i have a big big probleme with surcharge of my server and database error ! I think that a relationship with the hack: good now when I turn these hack is the catalyst: Cyb - Statistics Advanced Forum Latest X Threads Forum on Home vBSEO vBSEO:: Sitemap Generator I looks on with TOP, so I watch httpd very frequent and mysqld What is surprising is that the former host while niquel worked with these hack but this is the big overload what's more I really need this hack! I present below my configuration: httpd.conf Citation: # # This is the main Apache HTTP server configuration file. It contains the # configuration directives that give the server its instructions. # See <URL:http://httpd.apache.org/docs/2.2> for detailed information. # In particular, see # <URL:http://httpd.apache.org/docs/2.2/mod/directives.html> # for a discussion of each configuration directive. # # Do NOT simply read the instructions in here without understanding # what they do. They're here only as hints or reminders. If you are unsure # consult the online docs. You have been warned. ServerRoot "/etc/httpd" Listen 80 #LoadModule dummy_module /usr/lib/apache/mod_dummy.so #LoadModule php5_module /usr/lib/apache/libphp5.so Include /etc/httpd/conf/extra/httpd-phpmodules.conf User apache Group apache ServerAdmin admin@localhost DocumentRoot "/var/www/html" <Directory /home/*> AllowOverride All Options -MultiViews -Indexes FollowSymlinks IncludesNoExec +Includes <Limit GET POST OPTIONS PROPFIND> Order allow,deny Allow from all </Limit> <LimitExcept GET POST OPTIONS PROPFIND> Order deny,allow Deny from all </LimitExcept> </Directory> <Directory /> Options All AllowOverride All </Directory> <Directory "/var/www/html"> Options Indexes FollowSymLinks AllowOverride All Order allow,deny Allow from all <IfModule mod_suphp.c> suPHP_Engine On suPHP_UserGroup webapps webapps </IfModule> </Directory> <IfModule dir_module> DirectoryIndex index.html index.htm index.shtml index.php index.php5 index.php4 index.php3 index.phtml index.cgi </IfModule> <FilesMatch "^\.ht"> Order allow,deny Deny from all Satisfy All </FilesMatch> ErrorLog /var/log/httpd/error_log LogLevel warn <IfModule log_config_module> #replace %b with %O for more accurate logging <IfModule mod_logio.c> LogFormat "%h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" combined LogFormat "%h %l %u %t \"%r\" %>s %O" common LogFormat "%O" bytes LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio </IfModule> CustomLog /var/log/httpd/access_log common </IfModule> <IfModule alias_module> # Include some DirectAdmin alias Include conf/extra/httpd-alias.conf </IfModule> <Directory "/var/www/cgi-bin"> AllowOverride None Options None Order allow,deny Allow from all </Directory> DefaultType text/plain <IfModule mime_module> TypesConfig conf/mime.types AddType application/x-gzip .tgz AddEncoding x-compress .Z AddEncoding x-gzip .gz .tgz AddType application/x-compress .Z AddType application/x-gzip .gz .tgz AddHandler cgi-script .cgi AddHandler type-map var AddType text/html .shtml AddOutputFilter INCLUDES .shtml AddType video/x-ms-asf .avi AddType video/mpeg .mpg AddType video/mpeg .mpeg AddType video/quicktime .mov AddType video/x-ms-wmv .wmv </IfModule> #EnableMMAP off #EnableSendfile off ################################################## ##################################### # Do not change anything in included files, because they are rewritten by DirectAdmin # ################################################## ##################################### # This is needed for PHP Include conf/extra/httpd-php-handlers.conf # Server-pool management (MPM specific) Include conf/extra/httpd-mpm.conf # Multi-language error messages Include conf/extra/httpd-multilang-errordoc.conf # Fancy directory listings Include conf/extra/httpd-autoindex.conf # Language settings Include conf/extra/httpd-languages.conf # User home directories #Include conf/extra/httpd-userdir.conf # Real-time info on requests and configuration Include conf/extra/httpd-info.conf # Virtual hosts Include conf/extra/httpd-vhosts.conf # Local access to the Apache HTTP Server Manual #Include conf/extra/httpd-manual.conf # Distributed authoring and versioning (WebDAV) Include conf/extra/httpd-dav.conf # Various default settings Include conf/extra/httpd-default.conf # Secure (SSL/TLS) connections Include conf/extra/httpd-ssl.conf # Deflate module settings Include conf/extra/httpd-deflate.conf # All the DirectAdmin vhosts Include conf/extra/directadmin-vhosts.conf # All suPHP directives Include conf/extra/httpd-suphp.conf # All the other includes needed by the custombuild script Include conf/extra/httpd-includes.conf ################################################## ##################################### # End of included files that are rewritten by DirectAdmin # ################################################## ##################################### <IfModule ssl_module> SSLRandomSeed startup builtin SSLRandomSeed connect builtin </IfModule> my.cnf Citation: [mysqld] local-infile=0 socket=/tmp/mysql.sock skip-name-resolve safe-show-database #old_passwords back_log = 50 skip-innodb max_connections = 800 key_buffer_size = 640M myisam_sort_buffer_size = 128M join_buffer_size = 2M read_buffer_size = 2M sort_buffer_size = 8M table_cache = 4000 thread_cache_size = 512 wait_timeout = 60 connect_timeout = 10 tmp_table_size = 64M max_heap_table_size = 64M max_allowed_packet = 64M net_buffer_length = 16384 max_connect_errors = 10 thread_concurrency = 16 concurrent_insert = 2 table_lock_wait_timeout = 30 read_rnd_buffer_size = 1M bulk_insert_buffer_size = 32M query_cache_limit = 6M query_cache_size = 288M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65536 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 default-storage-engine = MyISAM max_write_lock_count = 16 [mysqld_safe] nice = -10 open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 512M sort_buffer = 64M read_buffer = 16M write_buffer = 16M ############################################ AND DATABASE ERROR mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (11) Database error in vBulletin 3.7.4: Invalid SQL: SELECT user.username, (user.options & 512) AS invisible, user.usergroupid, session.userid, session.inforum, session.lastactivity, session.useragent, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM session AS session LEFT JOIN user AS user ON(user.userid = session.userid) WHERE session.lastactivity > 1226049603 ORDER BY username ASC; MySQL Error : MySQL server has gone away Error Number : 2006 ####################################" #################### server configuration RAM : 1GB DDRAM HDD : 160 GB CPU : Intel 1 X Core Duo T2450 Linux Debian ##################### EDIT: Version vBulletin : 3.7.4 PHP 5.2.6 Serveur web : apache2handler Version MySQL 5.0.67 users online : de 100 ~ 150 ~ 300 ~ 380 |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|