Besoin d'un coup de main pour configuration d'un dédié

Besoin d'un coup de main pour configuration d'un dédié - Infrastructures serveurs - Systèmes & Réseaux Pro

Marsh Posté le 10-08-2011 à 17:50:26    

Bonjour à tous et un grand merci à ceux qui prendront le temps de lire ce sujet !
 
Je suis éditeur web, j'ai une petite dizaine de sites sous Wordpress et 2 forums (phpBB et vBulletin). Je suis chez Amen, j'étais sur un privé VDS30 et j'ai dû passer sur un dédié (ici ECO 6000) car Amen avait suspendu mon pack (à 2 reprises) pour non respect des CGU (d'après eux je consommais trop de CPU).
 
J'ai ainsi migré mes sites vers le nouveau serveur dédié. Le serveur tourne sous Debian 5 avec Plesk que j'ai mis à jour en version 10. J'ai réalisé la migration sous les conseils d'Amen en utilisant Plesk et l'outil de migration 'automatique'. Le problème, c'est que Plesk sur le privé était en version inférieure (potentiellement un souci de migration, ça reste à vérifier).
 
Les sites ont été migrés, les ndd redirigés. Seulement voilà, j'ai rapidement remarqué qu'un de mes forums générait trop de requêtes apache (des paquets d'apache2 dans top en ssh), les 6Go de RAM du serveur se remplissent, et au final l'ensemble des sites deviennent impossibles à charger). Quand je coupe le domaine avec le forum (le forum est sur un sous domaine, sur le domaine principal il y a aussi un site), l'ensemble charge mais assez lentement.
 
J'ai demandé des coups de mains à pas mal de monde, quelques problèmes m'ont proposé des configs mySql et Apache, mais au final le problème n'est pas réglé. J'ai par la suite décidé de supprimer temporairement le forum (tout en laissant l'autre site sur le même domaine disponible), le problème de requêtes s'est stoppé quelques heures mais a repris rapidement et maintenant je me retrouve avec des sites qui peuvent charger mais il faut attendre généralement entre 20 à 40 secondes en fonction du moment de la journée.
 
Donc là je suis plutôt coincé, mon outil de travail principal (mes sites) ne fonctionne pas correctement et ça va commencer à devenir difficile de gagner ma vie. Vous imaginez la situation, sachant que je n'ai pas un profil très technique.
 
Mes hypothèses :
 

  • problème de configuration apache : comme expliqué, j'ai eu quelques coups de main, mais au final rien ne change, peut être faut-il encore regarder ça
  • problème de configuration mysql : quand le serveur commence à ne plus répondre, j'ai souvent des erreurs mySQL, les sites n'arrivent pas à accéder aux bases, ce genre de chose
  • DDoS ou similaire : ça peut paraître absurde, mais en gardant en tête le fait qu'Amen ait suspendu mon ancien pack il y a déjà 2 semaines pour surconsommation, pourquoi pas ?  
  • problème de migration : les bases sont corrompues, les fichiers déconnent, je sais pas. Le truc c'est que les sites quand ils chargent bien fonctionnent parfaitement, c'est juste une question de vitesse de chargement


 
Solutions appliquées pour l'instant :
 

  • Repair / optimize de toutes les tables (via phpmyadmin et ssh)
  • Tentatives de configurations d'Apache et Mysql


 
J'ai intitulé mon sujet par rapport au souci de configuration, car j'ai vraiment l'impression que tous mes ennuis viennent de là (je l'espère en fait), mais à vrai dire je suis totalement dans le flou.
 
De quelles infos auriez-vous besoin afin de me filer un petit coup de main qui me permette enfin de reprendre le boulot normalement ? :)
 
Merci beaucoup pour votre temps !
 
- Axel
 
ps : pour information, quand j'ai des erreurs elles sont du type :
 
Pour vBulletin (par email) :
 

Code :
  1. Database error in vBulletin :
  3. mysqli_real_connect() [<a href='function.mysqli-real-connect'>function.mysqli-real-connect</a>]: (08004/1040): Too many connections
  4. /var/www/vhosts/xxxxx/subdomains/forums/httpdocs/includes/class_core.php on line 1305


 
 
Dans Plesk même :
 

Code :
  1. ERROR: PleskFatalException
  2. Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections


 
 
Pour les sites parfois :
 

Code :
  1. Error establishing a database connection


Message édité par baggynou le 10-08-2011 à 17:56:01
Reply

Marsh Posté le 10-08-2011 à 17:50:26   

Reply

Marsh Posté le 10-08-2011 à 18:12:28    

A priori c'est assez explicite regarde le nombe de connexions autorisees dans la config mysqm my.cnf et essaye de l'augmenter

Reply

Marsh Posté le 10-08-2011 à 18:59:17    

Bonjour et merci pour cette réponse, j'en profite pour c/c mes configs my.cnf et apache. Dites-moi si vous voyez quelque chose qui vous choque (désolé pour la longueur des textes :/) :
 
my.cnf:
 

Code :
  1. GNU nano 2.0.7               File: my.cnf
  3. # bind-address          = 127.0.0.1
  4. #
  5. # * Fine Tuning
  6. #
  7. #key_buffer             = 16M
  8. key_buffer              = 32M
  10. #max_allowed_packet     = 16M
  11. max_allowed_packet      = 32M
  13. thread_stack            = 128K
  14. thread_cache_size       = 8
  15. # This replaces the startup script and checks MyISAM tables if needed
  16. # the first time they are touched
  17. myisam-recover          = BACKUP
  18. #max_connections        = 5000
  19. #table_cache            = 64
  20. #thread_concurrency     = 10
  21. #
  22. # * Query Cache Configuration
  23. #
  24. #query_cache_limit       = 1M
  25. #query_cache_size        = 16M
  26. query_cache_limit        = 4M
  27. query_cache_size         = 32M
  29. #
  30. # * Logging and Replication
  31. #
  32. # Both location gets rotated by the cronjob.
  33. # Be aware that this log type is a performance killer.
  34. #log            = /var/log/mysql/mysql.log
  35. #
  36. # Error logging goes to syslog. This is a Debian improvement :)
  37. #
  38. # Here you can see queries with especially long duration
  39. #log_slow_queries       = /var/log/mysql/mysql-slow.log
  40. #long_query_time = 2
  41. #log-queries-not-using-indexes
  42. #
  43. # The following can be used as easy to replay backup logs or for replication.
  44. # note: if you are setting up a replication slave, see README.Debian about
  45. #       other settings you may need to change.
  46. #server-id              = 1
  47. #log_bin                        = /var/log/mysql/mysql-bin.log
  48. expire_logs_days        = 10
  49. max_binlog_size         = 100M
  50. #binlog_do_db           = include_database_name
  51. #binlog_ignore_db       = include_database_name
  52. #
  53. # * BerkeleyDB
  54. #
  55. # Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
  56. skip-bdb
  59. #
  60. # * InnoDB
  61. #
  62. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
  63. # Read the manual for more InnoDB related options. There are many!
  64. # You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
  65. #skip-innodb
  66. #
  67. # * Security Features
  68. #
  69. # Read the manual, too, if you want chroot!
  70. # chroot = /var/lib/mysql/
  71. #
  72. # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
  73. #
  74. # ssl-ca=/etc/mysql/cacert.pem
  75. # ssl-cert=/etc/mysql/server-cert.pem
  76. # ssl-key=/etc/mysql/server-key.pem
  80. [mysqldump]
  81. quick
  82. quote-names
  83. max_allowed_packet      = 16M
  85. [mysql]
  86. #no-auto-rehash # faster start of mysql but no tab completition
  88. [isamchk]
  89. key_buffer              = 16M
  91. #
  92. # * NDB Cluster
  93. #
  94. # See /usr/share/doc/mysql-server-*/README.Debian for more information.
  95. #
  96. # The following configuration is read by the NDB Data Nodes (ndbd processes)
  97. # not from the NDB Management Nodes (ndb_mgmd processes).
  98. #
  99. # [MYSQL_CLUSTER]
  100. # ndb-connectstring=127.0.0.1
  103. #
  104. # * IMPORTANT: Additional settings that can override those from this file!
  105. #   The files must end with '.cnf', otherwise they'll be ignored.
  106. #
  107. !includedir /etc/mysql/conf.d/


 
 
apache2.conf :
 

Code :
  1. # Based upon the NCSA server configuration files originally by Rob McCool.
  2. #
  3. # This is the main Apache server configuration file.  It contains the
  4. # configuration directives that give the server its instructions.
  5. # See http://httpd.apache.org/docs/2.2/ for detailed information about
  6. # the directives.
  7. #
  8. # Do NOT simply read the instructions in here without understanding
  9. # what they do.  They're here only as hints or reminders.  If you are unsure
  10. # consult the online docs. You have been warned.
  11. #
  12. # The configuration directives are grouped into three basic sections:
  13. #  1. Directives that control the operation of the Apache server process as a
  14. #     whole (the 'global environment').
  15. #  2. Directives that define the parameters of the 'main' or 'default' server,
  16. #     which responds to requests that aren't handled by a virtual host.
  17. #     These directives also provide default values for the settings
  18. #     of all virtual hosts.
  19. #  3. Settings for virtual hosts, which allow Web requests to be sent to
  20. #     different IP addresses or hostnames and have them handled by the
  21. #     same Apache server process.
  22. #
  23. # Configuration and logfile names: If the filenames you specify for many
  24. # of the server's control files begin with "/" (or "drive:/" for Win32), the
  25. # server will use that explicit path.  If the filenames do *not* begin
  26. # with "/", the value of ServerRoot is prepended -- so "/var/log/apache2/foo.log"
  27. # with ServerRoot set to "" will be interpreted by the
  28. # server as "//var/log/apache2/foo.log".
  29. #
  31. ### Section 1: Global Environment
  32. #
  33. # The directives in this section affect the overall operation of Apache,
  34. # such as the number of concurrent requests it can handle or where it
  35. # can find its configuration files.
  36. #
  38. #
  39. # ServerRoot: The top of the directory tree under which the server's
  40. # configuration, error, and log files are kept.
  41. #
  42. # NOTE!  If you intend to place this on an NFS (or otherwise network)
  43. # mounted filesystem then please read the LockFile documentation (available
  44. # at <URL:http://httpd.apache.org/docs-2.1/mod/mpm_common.html#lockfile> );
  45. # you will save yourself a lot of trouble.
  46. #
  47. # Do NOT add a slash at the end of the directory path.
  48. #
  49. ServerRoot "/etc/apache2"
  51. #
  52. # The accept serialization lock file MUST BE STORED ON A LOCAL DISK.
  53. #
  54. #<IfModule !mpm_winnt.c>
  55. #<IfModule !mpm_netware.c>
  56. LockFile /var/lock/apache2/accept.lock
  57. #</IfModule>
  58. #
  59. # PidFile: The file in which the server should record its process
  60. # identification number when it starts.
  61. # This needs to be set in /etc/apache2/envvars
  62. #
  63. PidFile ${APACHE_PID_FILE}
  65. #
  66. # Timeout: The number of seconds before receives and sends time out.
  67. #
  68. Timeout 30
  70. #
  71. # KeepAlive: Whether or not to allow persistent connections (more than
  72. # one request per connection). Set to "Off" to deactivate.
  73. #
  74. #KeepAlive On
  75. KeepAlive On
  77. #
  78. # MaxKeepAliveRequests: The maximum number of requests to allow
  79. # during a persistent connection. Set to 0 to allow an unlimited amount.
  80. # We recommend you leave this number high, for maximum performance.
  81. #
  82. MaxKeepAliveRequests 100
  84. #
  85. # KeepAliveTimeout: Number of seconds to wait for the next request from the
  86. # same client on the same connection.
  87. #
  88. KeepAliveTimeout 5
  90. ##
  91. ## Server-Pool Size Regulation (MPM specific)
  92. ##
  94. # prefork MPM
  95. # StartServers: number of server processes to start
  96. # MinSpareServers: minimum number of server processes which are kept spare
  97. # MaxSpareServers: maximum number of server processes which are kept spare
  98. # MaxClients: maximum number of server processes allowed to start
  99. # MaxRequestsPerChild: maximum number of requests a server process serves
  101. <IfModule mpm_prefork_module>
  102.     StartServers          5
  103.     MinSpareServers       5
  104.     MaxSpareServers      10
  105.     MaxClients          256
  106.     MaxRequestsPerChild   0
  107. </IfModule>
  108. <IfModule mpm_worker_module>
  109.     StartServers          2
  110.     MinSpareThreads      25
  111.     MaxSpareThreads      75
  112.     ThreadLimit          64
  113.     ThreadsPerChild      25
  114.     MaxClients          256
  115.     MaxRequestsPerChild   0
  116. </IfModule>
  119. # These need to be set in /etc/apache2/envvars
  120. User ${APACHE_RUN_USER}
  121. Group ${APACHE_RUN_GROUP}
  123. #
  124. # AccessFileName: The name of the file to look for in each directory
  125. # for additional configuration directives.  See also the AllowOverride
  126. # directive.
  127. #
  129. AccessFileName .htaccess
  131. #
  132. # The following lines prevent .htaccess and .htpasswd files from being
  133. # viewed by Web clients.
  134. #
  135. <Files ~ "^\.ht">
  136.     Order allow,deny
  137.     Deny from all
  138. </Files>
  139. #
  140. # DefaultType is the default MIME type the server will use for a document
  141. # if it cannot otherwise determine one, such as from filename extensions.
  142. # If your server contains mostly text or HTML documents, "text/plain" is
  143. # a good value.  If most of your content is binary, such as applications
  144. # or images, you may want to use "application/octet-stream" instead to
  145. # keep browsers from trying to display binary files as though they are
  146. # text.
  147. #
  148. DefaultType text/plain
  151. #
  152. # HostnameLookups: Log the names of clients or just their IP addresses
  153. # e.g., www.apache.org (on) or 204.62.129.132 (off).
  154. # The default is off because it'd be overall better for the net if people
  155. # had to knowingly turn this feature on, since enabling it means that
  156. # each client request will result in AT LEAST one lookup request to the
  157. # nameserver.
  158. #
  159. HostnameLookups Off
  161. # ErrorLog: The location of the error log file.
  162. # If you do not specify an ErrorLog directive within a <VirtualHost>
  163. # container, error messages relating to that virtual host will be
  164. # logged here.  If you *do* define an error logfile for a <VirtualHost>
  165. # container, that host's errors will be logged there and not here.
  166. #
  167. ErrorLog /var/log/apache2/error.log
  169. #
  170. # LogLevel: Control the number of messages logged to the error_log.
  171. # Possible values include: debug, info, notice, warn, error, crit,
  172. # alert, emerg.
  173. #
  174. LogLevel warn
  176. # Include module configuration:
  177. Include /etc/apache2/mods-enabled/*.load
  178. Include /etc/apache2/mods-enabled/*.conf
  180. # Include all the user configurations:
  181. Include /etc/apache2/httpd.conf
  183. # Include ports listing
  184. Include /etc/apache2/ports.conf
  185. #
  186. # The following directives define some format nicknames for use with
  187. # a CustomLog directive (see below).
  188. # If you are behind a reverse proxy, you might want to change %h into %{X-Forwarded-For}i
  189. #
  190. LogFormat "%v:%p %h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" vhost_combined
  191. LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
  192. LogFormat "%h %l %u %t \"%r\" %>s %b" common
  193. LogFormat "%{Referer}i -> %U" referer
  194. LogFormat "%{User-agent}i" agent
  196. #
  197. # Define an access log for VirtualHosts that don't define their own logfile
  198. CustomLog /var/log/apache2/other_vhosts_access.log vhost_combined
  200. #
  201. # Customizable error responses come in three flavors:
  202. # 1) plain text 2) local redirects 3) external redirects
  203. #
  204. # Some examples:
  205. #ErrorDocument 500 "The server made a boo boo."
  206. #ErrorDocument 404 /missing.html
  207. #ErrorDocument 404 "/cgi-bin/missing_handler.pl"
  208. #ErrorDocument 402 http://www.example.com/subscription_info.html
  209. #
  211. #
  212. # Putting this all together, we can internationalize error responses.
  213. #
  214. # We use Alias to redirect any /error/HTTP_<error>.html.var response to
  215. # our collection of by-error message multi-language collections.  We use
  216. # includes to substitute the appropriate text.
  217. #
  218. # You can modify the messages' appearance without changing any of the
  219. # default HTTP_<error>.html.var files by adding the line:
  220. #
  221. #   Alias /error/include/ "/your/include/path/"
  222. #
  223. # which allows you to create your own set of files by starting with the
  224. # /usr/share/apache2/error/include/ files and copying them to /your/include/path/,
  225. # even on a per-VirtualHost basis.  The default include files will display
  226. # your Apache version number and your ServerAdmin email address regardless
  227. # of the setting of ServerSignature.
  228. #
  229. # The internationalized error documents require mod_alias, mod_include
  230. # and mod_negotiation.  To activate them, uncomment the following 30 lines.
  232. #    Alias /error/ "/usr/share/apache2/error/"
  233. #
  234. #    <Directory "/usr/share/apache2/error">
  235. #        AllowOverride None
  236. #        Options IncludesNoExec
  237. #        AddOutputFilter Includes html
  238. #        AddHandler type-map var
  239. #        Order allow,deny
  240. #        Allow from all
  241. #        LanguagePriority en cs de es fr it nl sv pt-br ro
  242. #        ForceLanguagePriority Prefer Fallback
  243. #    </Directory>
  244. #    ErrorDocument 400 /error/HTTP_BAD_REQUEST.html.var
  245. #    ErrorDocument 401 /error/HTTP_UNAUTHORIZED.html.var
  246. #    ErrorDocument 403 /error/HTTP_FORBIDDEN.html.var
  247. #    ErrorDocument 404 /error/HTTP_NOT_FOUND.html.var
  248. #    ErrorDocument 405 /error/HTTP_METHOD_NOT_ALLOWED.html.var
  249. #    ErrorDocument 408 /error/HTTP_REQUEST_TIME_OUT.html.var
  250. #    ErrorDocument 410 /error/HTTP_GONE.html.var
  251. #    ErrorDocument 411 /error/HTTP_LENGTH_REQUIRED.html.var
  252. #    ErrorDocument 412 /error/HTTP_PRECONDITION_FAILED.html.var
  253. #    ErrorDocument 413 /error/HTTP_REQUEST_ENTITY_TOO_LARGE.html.var
  254. #    ErrorDocument 414 /error/HTTP_REQUEST_URI_TOO_LARGE.html.var
  255. #    ErrorDocument 415 /error/HTTP_UNSUPPORTED_MEDIA_TYPE.html.var
  256. #    ErrorDocument 500 /error/HTTP_INTERNAL_SERVER_ERROR.html.var
  257. #    ErrorDocument 501 /error/HTTP_NOT_IMPLEMENTED.html.var
  258. #    ErrorDocument 502 /error/HTTP_BAD_GATEWAY.html.var
  259. #    ErrorDocument 503 /error/HTTP_SERVICE_UNAVAILABLE.html.var
  260. #    ErrorDocument 506 /error/HTTP_VARIANT_ALSO_VARIES.html.var
  264. # Include of directories ignores editors' and dpkg's backup files,
  265. # see README.Debian for details.
  267. # Include generic snippets of statements
  268. Include /etc/apache2/conf.d/
  270. # Include the virtual host configurations:
  271. Include /etc/apache2/sites-enabled/
  272. AddOutputFilter INCLUDES .shtml
  273. AddType text/html .shtml
  274. AddType application/x-httpd-php .php
  275. AddType application/x-httpd-php-source .phps


 

Reply

Marsh Posté le 11-08-2011 à 21:25:06    

Le max_connections du my.cnf est commenté je connais pas la valeur par défaut essaye de ce côté

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed