Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Select_full_join 92 The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.

Posted on 2009-05-07
4
Medium Priority
?
874 Views
Last Modified: 2012-05-06
Hello,

My Celerom 2.4 with 2GB and windows 2003 server is running almost at 100% CPU usage all day because of MySQL server.
MySQL Status it is saying:

Handler_read_rnd        5,199        The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
Handler_read_rnd_next       166 M       The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.

Joins       Variable        Value        Description
Select_full_join       92       The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.
Select_full_range_join       0       The number of joins that used a range search on a reference table.
Select_range       20       The number of joins that used ranges on the first table. (It's normally not critical even if this is big.)
Select_range_check       0       The number of joins without keys that check for key usage after each row. (If this is not 0, you should carefully check the indexes of your tables.)
Select_scan       1,222       The number of joins that did a full scan of the first table.

my.cnf has been configured as follows:

query_cache_size=128M
table_cache=4096
tmp_table_size=512M
thread_cache_size=80
max_allowed_packet=16M
long_query_time = 1
log-slow-queries=C:/Program Files/MySQL/slow.log
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=64M
key_buffer_size=512M
join_buffer_size=256M
read_buffer_size=2M
read_rnd_buffer_size=2M
sort_buffer_size=2M

You can see on the code part my slow.log file.
I have one table with 160MB that is causing all this trouble.
What can I do to improve performance? I know that celeron is weak. But what can I do?
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.77-community-nt-log (MySQL Community Edition (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time                 Id Command    Argument
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.77-community-nt-log (MySQL Community Edition (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time                 Id Command    Argument
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.77-community-nt-log (MySQL Community Edition (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time                 Id Command    Argument
# Time: 090507 14:00:14
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 8  Rows_examined: 93053
use laclise_laclise;
SELECT  cliente.codcliente, cliente.rg, cliente.orgao, cliente.sexo, cliente.cliente, cliente.nascimento 
          FROM cliente
          WHERE (cliente.cliente like '%CLECIA SANTOS%')
          ORDER BY cliente.cliente ASC
          LIMIT 0,20;
# Time: 090507 14:01:37
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000141'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000954'));
# Time: 090507 14:01:40
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000143'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000955'));
# Time: 090507 14:01:43
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '1010'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000956'));
# Time: 090507 14:01:47
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '7.0'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000957'));
# Time: 090507 14:01:50
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 238831
SELECT 
                examepredefinido.codagencia,
                examepredefinido.codsolicitacao,
                examepredefinido.coditem, 
                examepredefinido.codresultado
                FROM examepredefinido
                where (
                        (examepredefinido.codagencia     = 'CJ'    ) and
                        (examepredefinido.codsolicitacao = '00012787') and
                        (examepredefinido.coditem        = '00000888') 
                      );
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000189'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000959'));
# Time: 090507 14:01:54
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000154'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000960'));
# Time: 090507 14:01:57
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000148'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000961'));
# Time: 090507 14:02:00
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000161'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000963'));
# Time: 090507 14:02:03
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 238836
SELECT  
                          codagencia, 
                          codsolicitacao, 
                          coditem,                
                          codresultado
                          FROM examepredefinido
                          where ((codagencia ='ID') and (codsolicitacao='00002938') and (coditem='00000996'));
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000168'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000964'));
# Time: 090507 14:02:06
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000177'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000965'));
# Time: 090507 14:02:10
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000183'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000967'));
# Time: 090507 14:02:13
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '2'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000969'));
# Time: 090507 14:02:16
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 238838
SELECT  
                          codagencia, 
                          codsolicitacao, 
                          coditem,                
                          codresultado
                          FROM examepredefinido
                          where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000970'));
# Time: 090507 14:02:18
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 238838
SELECT  
                          codagencia, 
                          codsolicitacao, 
                          coditem,                
                          codresultado
                          FROM examepredefinido
                          where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000971'));
# Time: 090507 14:02:20
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 112321
SELECT 
                     lanche.codvenda,
                     lanche.codagencia ,
                     lanche.codsolicitacao ,
                     lanche.codproduto ,
                     lanche.qtd ,
                     lanche.vlproduto,
                     lancheproduto.produto,
                     lanchesolicitacao.dtsolicitacao,
                     lanchesolicitacao.usucliente,
                     lanchesolicitacao.pago,
                     lanchesolicitacao.hssolicitacao
                   FROM lanche 
                   INNER JOIN lancheproduto     ON (lancheproduto.codproduto = lanche.codproduto)
                   INNER JOIN lanchesolicitacao ON  (lanchesolicitacao.codagencia = lanche.codagencia) and  (lanchesolicitacao.codsolicitacao = lanche.codsolicitacao)
                   WHERE ((lanchesolicitacao.dtsolicitacao >= '2009-05-07')  and (lanchesolicitacao.dtsolicitacao <= '2009-05-07') and (lanchesolicitacao.usucliente = 'GLM1')) and (lanche.pago = 0 )
                   ORDER BY lanchesolicitacao.dtsolicitacao, lanchesolicitacao.hssolicitacao, lanchesolicitacao.usucliente;
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000202'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000971'));
# Time: 090507 14:02:27
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000223'
                                            where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000978'));
# Time: 090507 14:03:04
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 238839
SELECT codagencia, codsolicitacao,  coditem, codresultado 
                                    FROM examepredefinido 
                                    where (codagencia = 'CN')         and 
                                          (codsolicitacao = '00001788') and 
                                          (coditem = '00000974');
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 7  Lock_time: 0  Rows_sent: 0  Rows_examined: 93054
SELECT  cliente.codcliente, cliente.rg, cliente.orgao, cliente.sexo, cliente.cliente, cliente.nascimento 
          FROM cliente
          WHERE (cliente.cliente like '%CLUDENICE SANTANA ROCHA CARVALHO%')
          ORDER BY cliente.cliente ASC
          LIMIT 0,20;
# Time: 090507 14:03:08
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 93054
SELECT 
       cliente.codcliente, 
       cliente.rg, 
       cliente.orgao, 
       cliente.sexo, 
       cliente.cliente, 
       cliente.nascimento,
       clientecontato.dddfone, 
       clientecontato.fone,
       clientecontato.tipofone,
       clientecontato.dddcelular,
       clientecontato.celular
        FROM cliente
                LEFT OUTER JOIN clientecontato ON (clientecontato.codcliente = cliente.codcliente )
                WHERE (cliente.cliente like '%CLUDENICE SANTANA ROCHA CARVALHO%')
                ORDER BY cliente.cliente ASC
                LIMIT 0,20;
# Time: 090507 14:03:16
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 238839
SELECT codagencia, codsolicitacao,  coditem, codresultado 
                                    FROM examepredefinido 
                                    where (codagencia = 'CN')         and 
                                          (codsolicitacao = '00001788') and 
                                          (coditem = '00000984');
# Time: 090507 14:03:17
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 1  Rows_examined: 93054
SELECT  cliente.codcliente, cliente.rg, cliente.orgao, cliente.sexo, cliente.cliente, cliente.nascimento 
          FROM cliente
          WHERE (cliente.cliente like '%CLAUDENICE SANTANA ROCHA CARVALHO%')
          ORDER BY cliente.cliente ASC
          LIMIT 0,20;
# Time: 090507 14:03:20
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 93055
SELECT 
       cliente.codcliente, 
       cliente.rg, 
       cliente.orgao, 
       cliente.sexo, 
       cliente.cliente, 
       cliente.nascimento,
       clientecontato.dddfone, 
       clientecontato.fone,
       clientecontato.tipofone,
       clientecontato.dddcelular,
       clientecontato.celular
        FROM cliente
                LEFT OUTER JOIN clientecontato ON (clientecontato.codcliente = cliente.codcliente )
                WHERE (cliente.cliente like '%CLAUDENICE SANTANA ROCHA CARVALHO%')
                ORDER BY cliente.cliente ASC
                LIMIT 0,20;
# Time: 090507 14:03:27
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 7  Lock_time: 0  Rows_sent: 0  Rows_examined: 238839
SELECT 
                examepredefinido.codagencia, 
                examepredefinido.codsolicitacao, 
                examepredefinido.coditem, 
                examepredefinido.codresultado,
                exameresultado.resultado
                FROM examepredefinido 
                INNER JOIN exameresultado ON (exameresultado.codresultado = examepredefinido.codresultado) 
                where ((examepredefinido.codagencia ='CJ') and (examepredefinido.codsolicitacao='00013188') and (examepredefinido.coditem='00000963'));
# Time: 090507 14:03:31
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
insert into acessoip(codacesso , usuario        ,   dthsconexao  ,   iplogin    ,   onde ) values
                                             (NULL      , 'ASR1' , '2009-05-07 14:03:28' , '189.71.247.70' , '/conmarcado.php?codusuario=5023129811951204041ASR1&tl=&pagina=1&filtro=&filtro2=&filtro3=&classificado=&data1=&doc=');
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 641
SELECT 
                examepredefinido.codagencia, 
                examepredefinido.codsolicitacao, 
                examepredefinido.coditem, 
                tabitemprocedimento.item,
                exameresultado.codresultado,
                exameresultado.resultado,
                examepredefinido.codresultado r
                FROM examepredefinido 
                INNER JOIN tabitemprocedimento ON (tabitemprocedimento.coditem = examepredefinido.coditem)
                INNER JOIN exameresultado      ON (exameresultado.coditem = tabitemprocedimento.coditem)
                where ((examepredefinido.codagencia ='CJ') and (examepredefinido.codsolicitacao='00013188') and (examepredefinido.coditem='00000963')  );
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 4  Lock_time: 0  Rows_sent: 1  Rows_examined: 189
SELECT usuario,codusuario,nome,nivel,codagencia FROM jlusuario where (codusuario = '1100222844431294121EMSS');
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SELECT count(codatendimentomedico) qtdmarcados  FROM marcado where (crm = '450') and  (marcadopara = '2009-05-08') and (tipomarcado <> 'X');
# Time: 090507 14:03:56
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 93054
SELECT  cliente.codcliente, cliente.rg, cliente.orgao, cliente.sexo, cliente.cliente, cliente.nascimento 
          FROM cliente
          WHERE (cliente.cliente like '%CLECIA DOS SANTOS A%')
          ORDER BY cliente.cliente ASC
          LIMIT 0,20;
# Time: 090507 14:03:59
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 93055
SELECT 
       cliente.codcliente, 
       cliente.rg, 
       cliente.orgao, 
       cliente.sexo, 
       cliente.cliente, 
       cliente.nascimento,
       clientecontato.dddfone, 
       clientecontato.fone,
       clientecontato.tipofone,
       clientecontato.dddcelular,
       clientecontato.celular
        FROM cliente
                LEFT OUTER JOIN clientecontato ON (clientecontato.codcliente = cliente.codcliente )
                WHERE (cliente.cliente like '%CLECIA DOS SANTOS A%')
                ORDER BY cliente.cliente ASC
                LIMIT 0,20;
# Time: 090507 14:04:19
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE marcado SET
                            ususalasenha   = 'EMSS',
                            dthspagamento  = '2009-05-07 14:04:19',
                            vlpago         = '0',
                            tipomarcado    = 'R',
                            vlmedico       = '0' 
                WHERE ( codmarcado = '0361562' );
# Time: 090507 14:07:41
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '89'
                                            where ((codagencia ='CN') and (codsolicitacao='00001791') and (coditem='00000852'));
# Time: 090507 14:07:44
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '37'
                                            where ((codagencia ='CN') and (codsolicitacao='00001791') and (coditem='00000851'));
# Time: 090507 14:07:45
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
# administrator command: Init DB;
# Time: 090507 14:07:47
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '181'
                                            where ((codagencia ='CN') and (codsolicitacao='00001791') and (coditem='00000905'));
# Time: 090507 14:07:49
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '94'
                                            where ((codagencia ='CN') and (codsolicitacao='00001791') and (coditem='00000906'));
# Time: 090507 14:07:52
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '18.8'
                                            where ((codagencia ='CN') and (codsolicitacao='00001791') and (coditem='00000908'));
# Time: 090507 14:07:54
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '70'
                                            where ((codagencia ='CN') and (codsolicitacao='00001791') and (coditem='00000909'));
# Time: 090507 14:07:56
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '92.2'
                                            where ((codagencia ='CN') and (codsolicitacao='00001791') and (coditem='00000910'));
# Time: 090507 14:07:59
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '2.5'
                                            where ((codagencia ='CN') and (codsolicitacao='00001791') and (coditem='00000913'));
# Time: 090507 14:08:02
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '1.3'
                                            where ((codagencia ='CN') and (codsolicitacao='00001791') and (coditem='00000914'));
# Time: 090507 14:09:43
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE `marcado`        SET `codhsmarcadopara` = '288'     WHERE codhsmarcadopara = '';
# Time: 090507 14:10:01
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 10641  Rows_examined: 10641
SELECT * FROM examecaixa;
# Time: 090507 14:10:04
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SELECT * FROM examecaixa;
# Time: 090507 14:10:10
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE marcado SET
                            npg    = '13'
                WHERE ( codmarcado = '0361900' );
# Time: 090507 14:10:31
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 238940
SELECT  
                          codagencia, 
                          codsolicitacao, 
                          coditem,                
                          codresultado
                          FROM examepredefinido
                          where ((codagencia ='ID') and (codsolicitacao='00002943') and (coditem='00000868'));
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.77-community-nt-log (MySQL Community Edition (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time                 Id Command    Argument
# Time: 090507 14:23:35
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 101  Rows_examined: 10588
use laclise_laclise;
SELECT  
         exame.codagencia, 
         exame.codsolicitacao, 
         exame.codexame, 
         exame.resultado,
         exame.dtrecebido,         
         exame.status,
         examesetor.codsetor,
         examesolicitacao.codcliente,  
         cliente.codcliente,
         cliente.cliente,
         cliente.nascimento,
         examesetor.qtdlinhas,
         examesetor.traco
         FROM exame
         INNER JOIN examesetor        ON (examesetor.codprocpi = exame.codexame )
         INNER JOIN examesolicitacao  ON (examesolicitacao.codagencia = exame.codagencia) and (examesolicitacao.codsolicitacao = exame.codsolicitacao)
         INNER JOIN cliente           ON (cliente.codcliente = examesolicitacao.codcliente)
         WHERE (  
                 (examesetor.codsetor = '46')  and
                 (exame.dtrecebido = '2009-05-07')      and
                 (exame.status = '')  
               )
          ORDER BY exame.codagencia, exame.codsolicitacao, exame.codexame;
# Time: 090507 14:23:42
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE medico SET
                               dttrabalho   = '2009-05-07'
                   WHERE ( crm = '11011' );
# Time: 090507 14:23:44
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 49750
SELECT sum(vlpago)torecebidousuario
                                       FROM marcado
                                       WHERE (( ususalasenha = 'ARS1')AND 
                                            (dthspagamento LIKE '2009-05-07%')AND
                                            (x <> 'X') AND 
                                            (x <> 'S') );
# Time: 090507 14:23:47
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 9  Rows_examined: 16075
SELECT 
                            codcxdia, usucaixa, dtcaixa, hsfechado, cxinicial, movimento, credito, debito, recolhido, saldo 
                           FROM caixadiausuario 
                           where ((usucaixa = 'ARS1') and (dtcaixa='2009-05-07') and (hsfechado = '00:00:00'));
# Time: 090507 14:23:49
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE caixadiausuario SET
                                   movimento   = '595',
                                   saldo       = '595' 
                      WHERE (usucaixa = 'ARS1') and (dtcaixa='2009-05-07') and (hsfechado = '00:00:00');
# Time: 090507 14:28:50
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE marcado SET
                            npg    = '12'
                WHERE ( codmarcado = '0361910' );
# Time: 090507 14:28:53
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE marcado SET
                            ususalasenha   = 'EMSS',
                            dthspagamento  = '2009-05-07 14:28:52',
                            vlpago         = '35',
                            tipomarcado    = 'E',
                            vlmedico       = '24.5' 
                WHERE ( codmarcado = '0361910' );
# Time: 090507 14:36:57
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE marcado SET
                                                     x = 'S'
                                        WHERE ( codmarcado = '0361905' );
# Time: 090507 14:37:10
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE marcado SET
                                                     x = 'S'
                                        WHERE ( codmarcado = '0361761' );
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 93068
SELECT  cliente.codcliente, cliente.rg, cliente.orgao, cliente.sexo, cliente.cliente, cliente.nascimento 
          FROM cliente
          WHERE (cliente.cliente like '%JOSE DAVID%')
          ORDER BY cliente.cliente ASC
          LIMIT 0,20;
# Time: 090507 14:37:12
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 93068
SELECT COUNT(codcliente) qtd FROM cliente
                              WHERE (cliente.cliente like '%JOSE DAVID%');
# Time: 090507 14:37:13
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE marcado SET
                                                     x = 'S'
                                        WHERE ( codmarcado = '0361674' );
# Time: 090507 14:37:14
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 93069
SELECT 
       cliente.codcliente, 
       cliente.rg, 
       cliente.orgao, 
       cliente.sexo, 
       cliente.cliente, 
       cliente.nascimento,
       clientecontato.dddfone, 
       clientecontato.fone,
       clientecontato.tipofone,
       clientecontato.dddcelular,
       clientecontato.celular
        FROM cliente
                LEFT OUTER JOIN clientecontato ON (clientecontato.codcliente = cliente.codcliente )
                WHERE (cliente.cliente like '%JOSE DAVID%')
                ORDER BY cliente.cliente ASC
                LIMIT 0,20;
# Time: 090507 14:37:31
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 4  Lock_time: 0  Rows_sent: 2  Rows_examined: 112347
SELECT 
                     lanche.codvenda,
                     lanche.codagencia ,
                     lanche.codsolicitacao ,
                     lanche.codproduto ,
                     lanche.qtd ,
                     lanche.vlproduto,
                     lancheproduto.produto,
                     lanchesolicitacao.dtsolicitacao,
                     lanchesolicitacao.usucliente,
                     lanchesolicitacao.pago,
                     lanchesolicitacao.hssolicitacao
                   FROM lanche 
                   INNER JOIN lancheproduto     ON (lancheproduto.codproduto = lanche.codproduto)
                   INNER JOIN lanchesolicitacao ON  (lanchesolicitacao.codagencia = lanche.codagencia) and  (lanchesolicitacao.codsolicitacao = lanche.codsolicitacao)
                   WHERE ((lanchesolicitacao.dtsolicitacao >= '2009-05-07')  and (lanchesolicitacao.dtsolicitacao <= '2009-05-07') and (lanchesolicitacao.usucliente = 'ESP1')) and (lanche.pago = 0 )
                   ORDER BY lanchesolicitacao.dtsolicitacao, lanchesolicitacao.hssolicitacao, lanchesolicitacao.usucliente;
# Time: 090507 14:40:49
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 16076  Rows_examined: 32152
SELECT * FROM caixadiausuario order by codcxdia desc;
# Time: 090507 14:41:26
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000139'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000954'));
# Time: 090507 14:41:28
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000143'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000955'));
# Time: 090507 14:41:30
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '1020'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000956'));
# Time: 090507 14:41:33
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '6.0'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000957'));
# Time: 090507 14:41:36
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000189'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000959'));
# Time: 090507 14:41:39
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000154'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000960'));
# Time: 090507 14:41:44
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE `marcado` 
                        SET 
                               `tipomarcado` =  'S'  
                        WHERE 
                              `codmarcado` = '0361475';
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000148'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000961'));
# Time: 090507 14:41:51
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 7  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000161'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000963'));
# Time: 090507 14:41:55
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000168'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000964'));
# Time: 090507 14:41:59
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000177'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000965'));
# Time: 090507 14:42:02
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000184'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000967'));
# Time: 090507 14:42:06
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '2'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000969'));
# Time: 090507 14:42:10
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000201'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000971'));
# Time: 090507 14:42:13
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000196'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013179') and (coditem='00000972'));
# Time: 090507 14:43:10
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 5  Rows_examined: 93068
SELECT  cliente.codcliente, cliente.rg, cliente.orgao, cliente.sexo, cliente.cliente, cliente.nascimento 
          FROM cliente
          WHERE (cliente.cliente like '%SILVANIA DE SOUZA%')
          ORDER BY cliente.cliente ASC
          LIMIT 0,20;
# Time: 090507 14:49:53
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 11104  Rows_examined: 30461
SELECT  
                   examesolicitacao.codagencia,
                   examesolicitacao.codsolicitacao,
                   examesolicitacao.codcliente,
                   examesolicitacao.dtsolicitacao,
                   examesolicitacao.codconvenio,
                   examesolicitacao.apagar,
                   cliente.rg, 
                   cliente.orgao, 
                   cliente.cliente,
                   cliente.nascimento,
                   tabconvenio.codconvenio,
                   tabconvenio.convenio,
                   examesolicitacao.deletado
                   FROM examesolicitacao
                   INNER JOIN cliente      ON    ( cliente.codcliente       = examesolicitacao.codcliente ) 
                   INNER JOIN tabconvenio  ON    ( tabconvenio.codconvenio  = examesolicitacao.codconvenio )
                   WHERE (( tabconvenio.codconvenio = '0001') and  (examesolicitacao.deletado = ''));
# Time: 090507 14:50:51
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 4410  Rows_examined: 13230
SELECT  
                   examesolicitacao.codagencia,
                   examesolicitacao.codsolicitacao,
                   examesolicitacao.codcliente,
                   examesolicitacao.dtsolicitacao,
                   examesolicitacao.codconvenio,
                   examesolicitacao.apagar,
                   cliente.rg, 
                   cliente.orgao, 
                   cliente.cliente,
                   cliente.nascimento,
                   tabconvenio.codconvenio,
                   tabconvenio.convenio,
                   examesolicitacao.deletado
                   FROM examesolicitacao
                   INNER JOIN cliente      ON  ( cliente.codcliente       = examesolicitacao.codcliente ) 
                   INNER JOIN tabconvenio  ON  ( tabconvenio.codconvenio  = examesolicitacao.codconvenio )
                   WHERE ((  (examesolicitacao.dtsolicitacao >= '2009-04-01') and (examesolicitacao.dtsolicitacao <= '2009-04-30')  ))  
                   ORDER BY examesolicitacao.dtsolicitacao desc 
                   LIMIT 0,9999;
# Time: 090507 14:50:54
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 4383  Rows_examined: 13176
SELECT  
                   examesolicitacao.codagencia,
                   examesolicitacao.codsolicitacao,
                   examesolicitacao.codcliente,
                   examesolicitacao.dtsolicitacao,
                   examesolicitacao.codconvenio,
                   examesolicitacao.apagar,
                   cliente.rg, 
                   cliente.orgao, 
                   cliente.cliente,
                   cliente.nascimento,
                   tabconvenio.codconvenio,
                   tabconvenio.convenio,
                   examesolicitacao.deletado
                   FROM examesolicitacao
                   INNER JOIN cliente      ON  ( cliente.codcliente       = examesolicitacao.codcliente ) 
                   INNER JOIN tabconvenio  ON  ( tabconvenio.codconvenio  = examesolicitacao.codconvenio )
                    WHERE ((  (examesolicitacao.dtsolicitacao >= '2009-04-01') and (examesolicitacao.dtsolicitacao <= '2009-04-30')  )) and (examesolicitacao.deletado = '') ORDER BY examesolicitacao.dtsolicitacao desc 
                   LIMIT 0,9999;
# Time: 090507 14:54:22
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 10642  Rows_examined: 10642
SELECT * FROM examecaixa;
# Time: 090507 14:58:32
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 2  Rows_examined: 112363
SELECT 
                     lanche.codvenda,
                     lanche.codagencia ,
                     lanche.codsolicitacao ,
                     lanche.codproduto ,
                     lanche.qtd ,
                     lanche.vlproduto,
                     lancheproduto.produto,
                     lanchesolicitacao.dtsolicitacao,
                     lanchesolicitacao.usucliente,
                     lanchesolicitacao.pago,
                     lanchesolicitacao.hssolicitacao
                   FROM lanche 
                   INNER JOIN lancheproduto     ON (lancheproduto.codproduto = lanche.codproduto)
                   INNER JOIN lanchesolicitacao ON  (lanchesolicitacao.codagencia = lanche.codagencia) and  (lanchesolicitacao.codsolicitacao = lanche.codsolicitacao)
                   WHERE ((lanchesolicitacao.dtsolicitacao >= '2009-05-07')  and (lanchesolicitacao.dtsolicitacao <= '2009-05-07') and (lanchesolicitacao.usucliente = 'DSO1')) and (lanche.pago = 0 )
                   ORDER BY lanchesolicitacao.dtsolicitacao, lanchesolicitacao.hssolicitacao, lanchesolicitacao.usucliente;
# Time: 090507 15:06:59
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE `marcado`        SET `usuario`          = 'Eduardo' WHERE usuario = '';
# Time: 090507 15:10:17
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 10646  Rows_examined: 10646
SELECT * FROM examecaixa;
# Time: 090507 15:30:23
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000377'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013203') and (coditem='00000885'));
# Time: 090507 15:30:45
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 16080  Rows_examined: 32160
SELECT * FROM caixadiausuario order by codcxdia desc;
# Time: 090507 15:38:49
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000009'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013232') and (coditem='00000884'));
# Time: 090507 15:45:31
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '112.000'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012838') and (coditem='00001038'));
# Time: 090507 15:45:34
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000487'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012838') and (coditem='00001040'));
# Time: 090507 15:45:36
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000489'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012838') and (coditem='00001041'));
# Time: 090507 15:45:39
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000503'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012838') and (coditem='00001048'));
# Time: 090507 15:45:41
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000508'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012838') and (coditem='00001050'));
# Time: 090507 15:45:48
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000514'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012838') and (coditem='00001053'));
# Time: 090507 15:45:50
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000516'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012838') and (coditem='00001054'));
# Time: 090507 15:45:52
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000519'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012838') and (coditem='00001055'));
# Time: 090507 15:45:54
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000522'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012838') and (coditem='00001057'));
# Time: 090507 15:45:56
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000526'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012838') and (coditem='00001058'));
# Time: 090507 15:45:58
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000527'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012838') and (coditem='00001059'));
# Time: 090507 15:46:00
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000530'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012838') and (coditem='00001060'));
# Time: 090507 15:50:03
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 239524
SELECT codagencia, codsolicitacao,  coditem, codresultado 
                                    FROM examepredefinido 
                                    where (codagencia = 'CN')         and 
                                          (codsolicitacao = '00001801') and 
                                          (coditem = '00000972');
# Time: 090507 15:58:10
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE `marcado` 
                        SET 
                               `marcadopara` =  '2009-05-07' , 
                               `tipomarcado` =  'C' , 
                               `vlconsulta`  =  '40'  , 
                               `qtdmarcados` =  '2' , 
                               `vlpago`      =  '40'      , 
                               `npg`         =  '10'         ,
                               `vlmedico`    =  '32'    ,
                               `codconvenio` =  '0017'
                        WHERE 
                              `codmarcado` = '0361429';
# Time: 090507 15:59:15
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 239547
# administrator command: Init DB;
# Time: 090507 15:59:24
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 9  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '106'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013088') and (coditem='00000852'));
# Time: 090507 15:59:29
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 5  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SELECT  
               codagencia, 
               codsolicitacao, 
               codexame, 
               vlexame, 
               status, 
               resultado, 
               dtrecebido 
               FROM exame
               where ((codagencia ='CJ') and (codsolicitacao='00013088') and (codexame='00000916'));
# Time: 090507 15:59:33
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '247'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013088') and (coditem='00000916'));
# Time: 090507 15:59:52
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE `marcado`        SET `codhsmarcadopara` = '288'     WHERE codhsmarcadopara = '';
# Time: 090507 15:59:55
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE `tabatendimento` SET `codhstermino`     = '288'     WHERE codatendimentomedico  <> '00sda003';
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 2  Rows_examined: 93084
SELECT  cliente.codcliente, cliente.rg, cliente.orgao, cliente.sexo, cliente.cliente, cliente.nascimento 
          FROM cliente
          WHERE (( cliente.rg like '%120521%'))
          ORDER BY cliente.cliente ASC
          LIMIT 0,20;
# Time: 090507 15:59:57
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE `marcado`        SET `usuario`          = 'Eduardo' WHERE usuario = '';
# Time: 090507 15:59:58
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 2  Rows_examined: 93086
SELECT 
       cliente.codcliente, 
       cliente.rg, 
       cliente.orgao, 
       cliente.sexo, 
       cliente.cliente, 
       cliente.nascimento,
       clientecontato.dddfone, 
       clientecontato.fone,
       clientecontato.tipofone,
       clientecontato.dddcelular,
       clientecontato.celular
        FROM cliente
                LEFT OUTER JOIN clientecontato ON (clientecontato.codcliente = cliente.codcliente )
                WHERE (( cliente.rg like '%120521%'))
                ORDER BY cliente.cliente ASC
                LIMIT 0,20;
# Time: 090507 16:00:05
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '88'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013089') and (coditem='00000852'));
# Time: 090507 16:00:08
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '167'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013089') and (coditem='00000916'));
# Time: 090507 16:00:16
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 6  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '9.6'
                                            where ((codagencia ='CJ') and (codsolicitacao='00013089') and (coditem='00000850'));
# Time: 090507 16:02:48
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE `marcado` 
              SET 
                     `tipomarcado` =  'X' 
              WHERE 
                    `codmarcado` = '0361830';
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.77-community-nt-log (MySQL Community Edition (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time                 Id Command    Argument
# Time: 090507 16:09:34
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 17  Lock_time: 0  Rows_sent: 320  Rows_examined: 29108
use laclise_laclise;
SELECT  
         exame.codagencia, 
         exame.codsolicitacao, 
         exame.codexame, 
         exame.resultado,
         exame.dtrecebido,         
         exame.status,
         examesetor.codsetor,
         examesolicitacao.codcliente,  
         cliente.codcliente,
         cliente.cliente,
         cliente.nascimento,
         examesetor.qtdlinhas,
         examesetor.traco
         FROM exame
         INNER JOIN examesetor        ON (examesetor.codprocpi = exame.codexame )
         INNER JOIN examesolicitacao  ON (examesolicitacao.codagencia = exame.codagencia) and (examesolicitacao.codsolicitacao = exame.codsolicitacao)
         INNER JOIN cliente           ON (cliente.codcliente = examesolicitacao.codcliente)
         WHERE (  
                 (examesetor.codsetor = '34')  and
                 (exame.dtrecebido = '2009-05-07')      and
                 (exame.status = '')  
               )
          ORDER BY exame.codagencia, exame.codsolicitacao, exame.codexame;
# Time: 090507 16:09:39
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 20  Rows_examined: 86469
SELECT 
       cliente.codcliente, 
       cliente.rg, 
       cliente.orgao, 
       cliente.sexo, 
       cliente.cliente, 
       cliente.nascimento,
       clientecontato.dddfone, 
       clientecontato.fone,
       clientecontato.tipofone,
       clientecontato.dddcelular,
       clientecontato.celular
        FROM cliente
                LEFT OUTER JOIN clientecontato ON (clientecontato.codcliente = cliente.codcliente )
                WHERE (cliente.cliente like '%ANDRESA%')
                ORDER BY cliente.cliente ASC
                LIMIT 0,20;
# Time: 090507 16:10:08
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE `marcado`        SET `usuario`          = 'Eduardo' WHERE usuario = '';
# Time: 090507 16:11:32
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000482'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001037'));
# Time: 090507 16:11:35
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '112.000'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001038'));
# Time: 090507 16:11:38
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000488'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001040'));
# Time: 090507 16:11:40
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000489'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001041'));
# Time: 090507 16:11:44
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000503'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001048'));
# Time: 090507 16:11:47
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000508'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001050'));
# Time: 090507 16:11:49
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000510'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001051'));
# Time: 090507 16:11:51
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000511'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001052'));
# Time: 090507 16:11:53
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000514'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001053'));
# Time: 090507 16:11:58
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000519'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001055'));
# Time: 090507 16:12:00
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000524'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001057'));
# Time: 090507 16:12:02
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000526'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001058'));
# Time: 090507 16:12:05
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000527'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001059'));
# Time: 090507 16:12:07
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000530'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001060'));
# Time: 090507 16:12:12
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 5  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE examepredefinido SET
                                            codresultado    = '00000486'
                                            where ((codagencia ='CJ') and (codsolicitacao='00012529') and (coditem='00001061'));
# Time: 090507 16:13:22
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 4  Rows_examined: 1269
SELECT  
         exame.codagencia, 
         exame.codsolicitacao, 
         exame.codexame, 
         exame.resultado,
         exame.dtrecebido,         
         exame.status,
         examesetor.codsetor,
         examesolicitacao.codcliente,  
         cliente.codcliente,
         cliente.cliente,
         cliente.nascimento,
         examesetor.qtdlinhas,
         examesetor.traco
         FROM exame
         INNER JOIN examesetor        ON (examesetor.codprocpi = exame.codexame )
         INNER JOIN examesolicitacao  ON (examesolicitacao.codagencia = exame.codagencia) and (examesolicitacao.codsolicitacao = exame.codsolicitacao)
         INNER JOIN cliente           ON (cliente.codcliente = examesolicitacao.codcliente)
         WHERE (  
                 (examesetor.codsetor = '53')  and
                 (exame.dtrecebido = '2009-05-07')      and
                 (exame.status = '')  
               )
          ORDER BY exame.codagencia, exame.codsolicitacao, exame.codexame;
# Time: 090507 16:14:40
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 11104  Rows_examined: 30461
SELECT  
                   examesolicitacao.codagencia,
                   examesolicitacao.codsolicitacao,
                   examesolicitacao.codcliente,
                   examesolicitacao.dtsolicitacao,
                   examesolicitacao.codconvenio,
                   examesolicitacao.apagar,
                   cliente.rg, 
                   cliente.orgao, 
                   cliente.cliente,
                   cliente.nascimento,
                   tabconvenio.codconvenio,
                   tabconvenio.convenio,
                   examesolicitacao.deletado
                   FROM examesolicitacao
                   INNER JOIN cliente      ON    ( cliente.codcliente       = examesolicitacao.codcliente ) 
                   INNER JOIN tabconvenio  ON    ( tabconvenio.codconvenio  = examesolicitacao.codconvenio )
                   WHERE (( tabconvenio.codconvenio = '0001') and  (examesolicitacao.deletado = ''));
# Time: 090507 16:14:51
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 112379
SELECT 
                     lanche.codvenda,
                     lanche.codagencia ,
                     lanche.codsolicitacao ,
                     lanche.codproduto ,
                     lanche.qtd ,
                     lanche.vlproduto,
                     lancheproduto.produto,
                     lanchesolicitacao.dtsolicitacao,
                     lanchesolicitacao.usucliente,
                     lanchesolicitacao.pago,
                     lanchesolicitacao.hssolicitacao
                   FROM lanche 
                   INNER JOIN lancheproduto     ON (lancheproduto.codproduto = lanche.codproduto)
                   INNER JOIN lanchesolicitacao ON  (lanchesolicitacao.codagencia = lanche.codagencia) and  (lanchesolicitacao.codsolicitacao = lanche.codsolicitacao)
                   WHERE ((lanchesolicitacao.dtsolicitacao >= '2009-04-06')  and (lanchesolicitacao.dtsolicitacao <= '2009-05-07') and (lanchesolicitacao.usucliente = 'ADM2')) and (lanche.pago = 0 )
                   ORDER BY lanchesolicitacao.dtsolicitacao, lanchesolicitacao.hssolicitacao, lanchesolicitacao.usucliente;
# Time: 090507 16:20:23
# User@Host: laclise_user[laclise_user] @ data6.nspmanaged.com [75.125.14.50]
# Query_time: 2  Lock_time: 0  Rows_sent: 10648  Rows_examined: 10648
SELECT * FROM examecaixa;

Open in new window

0
Comment
Question by:ZenithBR
  • 2
  • 2
4 Comments
 
LVL 51

Expert Comment

by:Steve Bink
ID: 24334113
It sounds like you are suffering from a lack of proper indexing.  Have you optimized them at all?  For example, this query:

UPDATE examepredefinido SET codresultado    = '00000202' where ((codagencia ='CN') and (codsolicitacao='00001788') and (coditem='00000971'));

I see that several times in the log.  Indexing that table on a composite key of codresultado/codagencia/codsolicitacao/coditem may be helpful.  

The SELECT queries that use multiple joins should also be using indexed fields for their join field.  If not, you're talking about a table scan against a table scan.  If you have 1000 rows in each, that's essentially 1000000 rows the engine has to scan through.  

What optimizations do you have in place already for your queries?
0
 

Author Comment

by:ZenithBR
ID: 24337653
Hello,

I have indexed many fields and MySQL is running much better now. Most of then didn't had any index.
Composite key index are better than indexing each field? Even if the composite index is larger than sum of each field index?

As far as I now I don't have any optimization after this indexes.

Best Regards,
Zenith
0
 
LVL 51

Accepted Solution

by:
Steve Bink earned 2000 total points
ID: 24341599
>>> Composite key index are better than indexing each field?

Depends on how they are being used.  For example, if you have an index based on columns a,b,c, then searching for (a=) or (a=,b=) or (a=,b=,c=) will be improved by using it.  That same index will be of no use if you're only searching for (b=,c=).  You could another index for b,c, but you also have to keep in mind that index definitions and maintenance carry their own overhead.  "Over-optimization" can yield many of the same problems as too little optimization.

I recommend reading through the optimization chapter of the MySQL manual.  It provides a large amount of insight into how the engine works, and, consequently, how to design your database to leverage the engine as much as possible.  While the entire chapter is a worthwhile read, the specific area you're probably interested in right now is here:

http://dev.mysql.com/doc/refman/5.0/en/optimizing-database-structure.html

Sections 7.4.2 through 7.4.4 are most relevant to this question.
0
 

Author Closing Comment

by:ZenithBR
ID: 31579190
Thanks.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question