Re: timing queries?

2005-10-01 Thread Roger Baklund
Jacek Becla wrote: Hi, Does anyone know how to execute SQL statements from a text file such that the summaries "X rows in set (X.YZ sec)" are printed for each query? Neither of these do it: mysql < batch-file mysql -e 'source batch-file' If you add verbosity using the parameter -vv (or -v

RE: timing queries?

2005-10-01 Thread Sujay Koduri
If you use source absolute-pathname from mysql command prompt, then it will execute each statement(or line) in the file individually and print the results exactly in the format you are looking for. sujay -Original Message- From: Jacek Becla [mailto:[EMAIL PROTECTED] Sent: Saturday, Octo

Re: timing problem

2005-09-29 Thread Nuno Pereira
Tony Leake wrote: On Thu, 2005-09-29 at 16:15 +0100, Nuno Pereira wrote: [EMAIL PROTECTED] wrote: This one is interesting in terms of concurrency... Is the app2 the one responsable for setting the flag? I supose that it is. If that happens it's important that app2 doesn't mess with the fla

Re: timing problem

2005-09-29 Thread SGreen
Nuno Pereira <[EMAIL PROTECTED]> wrote on 09/29/2005 11:15:08 AM: > [EMAIL PROTECTED] wrote: > > Tony Leake <[EMAIL PROTECTED]> wrote on 09/29/2005 07:08:24 AM: > > > > > >>Hi > >> > >>I have 2 applications communicating via a mysql database > >> > >>the db is 4.1.8 running on a debian linux sys

Re: timing problem

2005-09-29 Thread Tony Leake
On Thu, 2005-09-29 at 16:15 +0100, Nuno Pereira wrote: > [EMAIL PROTECTED] wrote: > > This one is interesting in terms of concurrency... > > Is the app2 the one responsable for setting the flag? I supose that it is. > If that happens it's important that app2 doesn't mess with the flag, i > mean

Re: timing problem

2005-09-29 Thread Nuno Pereira
[EMAIL PROTECTED] wrote: Tony Leake <[EMAIL PROTECTED]> wrote on 09/29/2005 07:08:24 AM: Hi I have 2 applications communicating via a mysql database the db is 4.1.8 running on a debian linux system. All tables are innodb app 1 1 runs on a windows machine, is written in c# and talks to the

Re: timing problem

2005-09-29 Thread Tony Leake
On Thu, 2005-09-29 at 09:30 -0400, [EMAIL PROTECTED] wrote: > The key here is > that you are making multiple changes from app1 that really should be > within a transaction. The entire process of writing sales data and > unsetting a flag from app1 needs to be transacted. That way the other >

Re: timing problem

2005-09-29 Thread SGreen
Tony Leake <[EMAIL PROTECTED]> wrote on 09/29/2005 07:08:24 AM: > Hi > > I have 2 applications communicating via a mysql database > > the db is 4.1.8 running on a debian linux system. > All tables are innodb > > app 1 1 runs on a windows machine, is written in c# and talks to the db > with odb

RE: timing

2003-02-01 Thread Mary Stickney
Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] -Original Message- From: David Brodbeck [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 3:09 PM To: 'Mary Stickney'; [EMAIL PROTECTED] Subject: RE: timing Have you checked for network problems? You might try F

RE: timing

2003-02-01 Thread David Brodbeck
Have you checked for network problems? You might try FTPing a file to and from the production server, or something similar, just to rule this out. I've had slowness problems with various apps that were driving me *nuts* until I found a network issue causing them. In a few cases I had a duplex mi

RE: timing

2003-01-31 Thread Mary Stickney
: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 6:07 PM To: Mary Stickney; [EMAIL PROTECTED] Subject: Re: timing Mary, > The Production server has MYSQL 3.23 and an older version of MYODBC then I > have. > They run in 8 minutes on my test server

Re: timing

2003-01-31 Thread Stefan Hinz, iConnect \(Berlin\)
Mary, > The Production server has MYSQL 3.23 and an older version of MYODBC then I > have. > They run in 8 minutes on my test server , about 4 minutes each. Printing to > a PDF driver. > On the Production Server they take HOURS to run and print. Maybe this won't help too much, but I've experienc

RE: timing

2003-01-30 Thread Mary Stickney
To: Mary Stickney; [EMAIL PROTECTED] Subject: RE: timing >They run in 8 minutes on my test server , about 4 minutes each. Printing to >a PDF driver. >On the Production Server they take HOURS to run and print. The production server is probably trying to do other stuff at the same tim

RE: timing

2003-01-30 Thread Mary Stickney
] -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 2:12 PM To: Mary Stickney; mysql list Subject: RE: timing You are positive there is nothing else running while you are trying to do your reports? Have you tried keeping an eye on the processlist

RE: timing

2003-01-30 Thread Mary Stickney
- From: Jennifer Goodie [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 1:57 PM To: Mary Stickney; [EMAIL PROTECTED] Subject: RE: timing >They run in 8 minutes on my test server , about 4 minutes each. Printing to >a PDF driver. >On the Production Server they take HOURS to run

RE: timing

2003-01-30 Thread Jennifer Goodie
on while you are running your reports? Is the production server tuned for the type of complex queries you are running? -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 12:02 PM To: Jennifer Goodie; [EMAIL PROTECTED] Subject: RE: timing

RE: timing

2003-01-30 Thread Mary Stickney
: Thursday, January 30, 2003 1:57 PM To: Mary Stickney; [EMAIL PROTECTED] Subject: RE: timing >They run in 8 minutes on my test server , about 4 minutes each. Printing to >a PDF driver. >On the Production Server they take HOURS to run and print. The production server is probably try

RE: timing

2003-01-30 Thread Jennifer Goodie
>They run in 8 minutes on my test server , about 4 minutes each. Printing to >a PDF driver. >On the Production Server they take HOURS to run and print. The production server is probably trying to do other stuff at the same time, making your reports slower. A machine with one active connection wi