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
858 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 50

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 50

Accepted Solution

by:
Steve Bink earned 500 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video discusses moving either the default database or any database to a new volume.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

743 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now