otimizacao de banco de dados
olá pessoal, estou utilizando o Apache/2.2.11
veja relatorio abaixo... o site está travando ... nao está aguentando a qtde de visitas;
alguem tem alguma sugestao em topicos de como otimiza-lo da melhor maneira possivel para nao sobrecarregar o servidor?
uso servidor dedicado 4mbps de banda compartilhada... mas tenho certeza que nao é so a banda que está prejudicando o andamento do sistema
Server Version: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8b mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP/5.2.8Server Built: Feb 18 2009 10:48:58 Current Time: Sunday, 29-Mar-2009 16:03:48 BRTRestart Time: Sunday, 29-Mar-2009 15:15:17 BRTParent Server Generation: 0Server uptime: 48 minutes 31 secondsTotal accesses: 9844 - Total Traffic: 105.8 MBCPU Usage: u11.67 s.59 cu0 cs0 - .421% CPU load3.38 requests/sec - 37.2 kB/second - 11.0 kB/request177 requests currently being processed, 10 idle workersWWWWKWWWWWWWWWWWWWWWWWWWWWWWWWKWWWWWWWWWWWW.W_.WWW_W.Under-Linux.Org O Portal do Administador de Sistemas
WWW_WWWWWWW_WWWWWWWWK.W..W..WWW...W_WWWWWW...WWW_KWKWWWW....WWWK
_.KWWWWWWWWWWWW...W.W.W.WW.WWWW_WWW..WW.W.WWWW.W...K....WWWW.WWW
.W.WWW...WWWW_.KW...WWW.WWWWW.W.W.WW.WW....WKW.W....WW.W..W.W.W.
Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
SrvPIDAccMCPU SSReqConnChildSlotClientVHostRequest 0-080560/9/85W 0.0616800.00.081.08 189.78.67.81facildownloads.com.brGET /2008-01-10/fundamentos-de-etica-empresarial-e-economica-3- 1-092620/7/52W 0.0217300.00.040.44 200.223.136.114facildownloads.com.brGET /2008-11-26/nero-9-serial-16829.html HTTP/1.1 2-085320/8/51W 0.0449700.00.070.46 201.27.221.71facildownloads.com.brGET /2007-05-08/bus-driver-demo-5999.html HTTP/1.1 3-090640/11/84W 0.047500.00.120.57 201.75.2.46facildownloads.com.brGET /2007-02-21/direitos-humanosnormas-e-convencoes-12627.html 4-0107722/21/86K 0.1133591.30.160.98 200.102.227.138facildownloads.com.brGET /ad_gerenciador/getAds.php?pos=menuEsquerdo&pg=23&ac=1 HTTP 5-083670/41/126W 0.1517200.00.481.35 201.18.125.141facildownloads.com.brGET /2007-05-25/jewel-quest-solitaire-ii-6101.html HTTP/1.1 6-085800/20/91W 0.0887400.00.381.07 201.67.236.61facildownloads.com.brGET /2008-02-28/o-diario-de-negocios-de-maslow-15999.html HTTP/ 7-092680/9/87W 0.031100.00.110.88 187.21.250.69facildownloads.com.brGET /2008-02-06/locacao-e-despejocomentarios-a-lei-8245-915-edi 8-085370/14/90W 0.0497900.00.260.72 201.2.145.32facildownloads.com.brGET /2008-11-28/windows-messenger-8_5-16830.html HTTP/1.1 9-090950/9/60W 0.0298200.00.170.61 201.2.145.32facildownloads.com.brGET /2008-11-28/windows-messenger-8_5-16830.html HTTP/1.1 10-085880/2/80W 0.0375400.00.000.72 200.230.78.130facildownloads.com.brGET /2008-02-18/manual-de-direito-comercialdireito-de-empresa20 11-078210/61/84W 0.1893900.00.781.07 189.107.1.46facildownloads.com.brGET /2008-02-22/terceiro-setor-controle-e-fiscalizacao-12925.ht 12-0108470/4/59W 0.013500.00.040.65 189.47.142.166facildownloads.com.brGET /2008-02-12/como-implantar-o-e-business-13419.html HTTP/1.1 13-092700/6/70W 0.0114700.00.040.67 189.81.27.232facildownloads.com.brGET /Templates/logomarca-grande.png HTTP/1.1 14-085900/1/42W 0.0286400.00.000.43 189.79.75.151facildownloads.com.brGET /2007-02-23/brushes-para-photoshop-vintage-cameras-2282.htm 15-093110/2/36W 0.0116100.00.000.39 189.46.84.231facildownloads.com.brGET /2008-02-24/logistica-aplicada3-edicao-16390.html HTTP/1.1 16-091160/16/104W 0.071100.00.241.21 86.42.144.118facildownloads.com.brGET /2007-01-06/a-bela-e-a-fera-maison-des-lunes-26456.html HTT 17-054180/63/63W 0.1917200.00.830.83 201.80.89.61facildownloads.com.brGET /2007-09-13/principios-institucionais-da-defensoria-publica 18-093120/1/91W 0.0087600.00.021.09 189.17.96.131facildownloads.com.brGET /2007-09-15/windows-media-player-codecs-9_0-3941.html HTTP/ 19-085910/14/60W 0.093700.00.210.60 200.149.105.206facildownloads.com.brGET /2008-01-14/parasitologia-humana-11-edicao-14657.html HTTP/ 20-0107740/11/79W 0.07100.00.101.02 66.196.119.21facildownloads.com.brGET /sitemap.txt HTTP/1.1 21-092740/0/18W 0.0093600.00.000.03 189.24.171.163facildownloads.com.brGET /2008-01-14/gestao-de-contratos-de-terceirizacao-na-adminis 22-092750/1/94W 0.0117200.00.000.85 189.24.155.6facildownloads.com.brGET /2007-04-03/manual-de-bioquimica-com-correlacoes-clinicas-6 23-0107900/7/54W 0.006700.00.020.60 200.138.161.132facildownloads.com.brGET /2008-02-20/planos-de-contas12--edicao-11427.html HTTP/1.1 24-072030/28/48W 0.0593800.00.460.71 201.12.149.245facildownloads.com.brGET /2007-01-23/financas-corporativas-aplicadas-10041.html HTTP 25-083790/36/89W 0.1295900.00.290.82 189.24.93.130facildownloads.com.brGET /2007-09-20/pretty-good-mahjongg-2_3-6213.html HTTP/1.0 26-086010/6/32W 0.0317200.00.060.29 66.235.124.59facildownloads.com.brGET /2007-05-04/1st-screensaver-photo-studio-professional-2_0_2 27-092780/0/82W 0.0593500.00.000.94 72.30.79.98facildownloads.com.brGET /html/bestDownloads.php?i=7060 HTTP/1.0 28-092830/17/50W 0.113800.00.090.36 201.88.100.75facildownloads.com.brGET /html/novidades.php HTTP/1.1 29-092840/5/65W 0.0389100.00.000.69 201.95.70.33facildownloads.com.brGET /2007-08-04/sis315-agp-graphic-drivers-8327.html HTTP/1.1 30-086172/20/36K 0.07100.00.280.47 189.72.234.217facildownloads.com.brGET /css/detalhesProdutos.css HTTP/1.1 31-092850/1/67W 0.0092000.00.000.78 189.31.58.149facildownloads.com.brGET /2007-03-26/direito-das-fundacoes-privadas-13232.html HTTP/ 32-091190/6/42W 0.0092700.00.100.45 189.24.171.163facildownloads.com.brGET /2008-01-14/gestao-de-contratos-de-terceirizacao-na-adminis 33-092860/0/65W 0.0093000.00.000.48 201.19.107.16facildownloads.com.brGET /2008-02-01/qualidade-ambiental-iso-14000-14929.html HTTP/1 34-093130/0/90W 0.0090100.00.000.95
otimizacao de banco de dados
ola, o problema é a restricao orcamentaria e inexperiencia... precisamos configurar o linux e apache...para um servidor de grande demanda...o que parece é que o servidor está configurado em modo default, e esse modo nao atende as necessidades para grande demanda de requisicoes.
vc tem msn? o meu é [email protected]
vc mora em natal?
abracos!
