Re: SELECT/JOIN performance on temporary tables depends on timing of index creation

Gleb: Aha. OK, we tried using OPTIMIZE instead of ANALYZE, and that does indeed update the Cardinality of the index, the way you would expect. Thanks very much for figuring this out! I really appreciate the help. Thanks again! Allan "Gleb Paharenko" <[EMAIL PROTECTED]> wrote in message new

Re: SELECT/JOIN performance on temporary tables depends on timing of index creation

Hello. I've checked this and found that ANALYZE table really doesn't work, but OPTIMIZE table made its work. In case it won't help you send to list complete definitions of you tables and queries. Allan Miller wrote: > Hi Gleb, > > Thanks for the quick response. Unfortunately, ANALYZE

Re: SELECT/JOIN performance on temporary tables depends on timing of index creation

Hi Gleb, Thanks for the quick response. Unfortunately, ANALYZE TABLE does not appear to affect the Cardinality field of a temporary table (it is still NULL, even with rows added). Only by creating the index itself after the insert seems to make the query faster. I also tried FORCE INDEX and it

Re: SELECT/JOIN performance on temporary tables depends on timing of index creation

Hello. > Why is it that adding an index before or after the addition of data >makes a difference on SELECT performance? Check whether the problem still exists if you run ANALYZE table after inserts in case you have already created indexes. FORCE_INDEX in the SELECT clause should help as

SELECT/JOIN performance on temporary tables depends on timing of index creation

In MySQL 4.1.11, if you create two temporary tables with non-unique indices as part of the CREATE TEMPORARY TABLE statement, then insert several hundred (or thousand) rows, a subsequent SELECT using a JOIN between the two tables is substantially slower than if you create the indices after inserti

Re: timing queries?

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?

, October 01, 2005 1:20 AM To: mysql@lists.mysql.com Subject: timing queries? 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 '

timing queries?

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' 'source batch-file' run inside mysql command-line does it, but then I n

Re: timing problem

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

ls for the flag to be unset, then reads the sales data. > >> > >>Sometimes whem app 2 reads the data there is nothing to be read, i am > >>logging the queries that app 2 is using to do the inserts, then by the > >>time i can open up a terminal and query the tabl

Re: timing problem

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

Sometimes whem app 2 reads the data there is nothing to be read, i am logging the queries that app 2 is using to do the inserts, then by the time i can open up a terminal and query the table manually the data is there. The only thing I can assume it that there is some kind of timing issue and

Re: timing problem

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

> app 2 polls for the flag to be unset, then reads the sales data. > > Sometimes whem app 2 reads the data there is nothing to be read, i am > logging the queries that app 2 is using to do the inserts, then by the > time i can open up a terminal and query the table manually the data is

timing problem

2 is using to do the inserts, then by the time i can open up a terminal and query the table manually the data is there. The only thing I can assume it that there is some kind of timing issue and the data is not fully written when I try to read it, this doesn't happen every time and may only b

Re: Changing the Prompt for timing purposes

e interface is very basic. Can it be modified like the > shell command prompts so that I can include date/time for timing benchmarks? > > Secondly, is there an "echo" command in MYSQL command prompt so that I can see

RE: Changing the Prompt for timing purposes

Tom Crimmins <[EMAIL PROTECTED]> wrote on 04/13/2005 12:37:44 PM: > > On Wednesday, April 13, 2005 11:29, [EMAIL PROTECTED] wrote: > > > Hi, > > The MYSQL command line interface is very basic. Can it be modified > > like the shell command prompts so that I can

RE: Changing the Prompt for timing purposes

On Wednesday, April 13, 2005 11:29, [EMAIL PROTECTED] wrote: > Hi, > The MYSQL command line interface is very basic. Can it be modified > like the shell command prompts so that I can include date/time for > timing benchmarks? > > Secondly, is there an "echo" com

Changing the Prompt for timing purposes

Hi, The MYSQL command line interface is very basic. Can it be modified like the shell command prompts so that I can include date/time for timing benchmarks? Secondly, is there an "echo" command in MYSQL command prompt so that I can see the command I issued or a log file that I ca

RE: timing

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

ne it multiple times. ;) > -Original Message- > From: Mary Stickney [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 30, 2003 9:08 AM > To: [EMAIL PROTECTED] > Subject: timing > > > > I have 2 Crystal Reports 8.5 (for the record I didn't make > these report

RE: timing

: 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

onnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Mary Stickney" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 30, 2003 3:08 PM Subject: timing >

RE: timing

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

] -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

- 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

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

: 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

f queries. -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 6:08 AM To: [EMAIL PROTECTED] Subject: timing I have 2 Crystal Reports 8.5 (for the record I didn't make these reports) that draw straight from the MYSQL database. They use only

timing

I have 2 Crystal Reports 8.5 (for the record I didn't make these reports) that draw straight from the MYSQL database. They use only 1 table. I am calling them to print from VB 6.0 Theses reports have lots of complex calculations in them, counts , sums and groups. My test server has the same code

Timing in mysql

Hi: I am using expect scripts to display huge number of tables in mysql, I wonder is there any command in mysql that display out the timestamp it takes to load the databases. Thanks - Before posting, please check: http://ww

Re: Q about replication & timing

On Mon, Nov 04, 2002 at 02:04:35PM -0500, Ray Zimmerman wrote: > I'm looking into options to improve performance of mysql in our app > and have a question about replication. I need the following > guarantee, which I believe is not possible with replication ... > > If a client successfully update

Q about replication & timing

I'm looking into options to improve performance of mysql in our app and have a question about replication. I need the following guarantee, which I believe is not possible with replication ... If a client successfully updates the master, any subsequent read from a slave must reflect that update.

Re: Getting timing from MySQL scripts

om the mysql prompt), >I do not get the same timing info. That's because when mysql runs in batch mode, it disables a lot of the interactive mode output. Run it with the -vvv option and you'll get the information you're looking for. > >I want to run some benchmark tests, but

Getting timing from MySQL scripts

Whenever I run a command from the MySQL prompt, The command executes and outputs the time to process the command. However, if I put the same command in a script file, and run it in batch mode from the shell prompt (or even use SOURCE from the mysql prompt), I do not get the same timing info. I

Connection timing problem?

Hi, I have installed MySQL and everything runs great. Most of the apps I'm running are perfectly fine except one problem: Through a webpage of mine I send a request to the database. Works great and I get a return no problem with the correct response. But when I ask it again right away to do anoth

how to spool timing of a query into a spool file

Hi this is a 2nd attempt. My first post never made it to the list. What I'm trying to do is to spool queries results into a spool file (via tee command). For some reason the timing information doesn't get there. When I run a query from mysql, the output is followed by a line with the

how to spool timing of a query into a spool file

Hi. this is a minor problem that is driving me nuts. I have a query that runs nicely and I want to save its timing information in a spool file. When I connect to mysql and run the query it adds the time elapsed after the data (9 rows in set 1.1 sec). But when I run the same query in the line

mysql timing out? HELP!!!!

Hi, I have a customer who has a html page containing two frames on server A. The content files for these frames are on server B. He wants to keep his URL which is directed to server A, but server B has mysql and php support so we have to do this to accomodate him. It is working (kind of) but th

Re: MySQL Timing out

;Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Chris Anderson" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, July 21, 2001 12:23 AM Subject: Re: MySQL Timing out > On Wed, Jul 18, 2001 at 10:12:03PM -0400, Chris Anderson wrote: > > > > I have an i

Re: MySQL Timing out

On Wed, Jul 18, 2001 at 10:12:03PM -0400, Chris Anderson wrote: > > I have an include file that includes my mysql connect > information. Its sole purpose is to login to mysql. Strangely on my > Win9x development system with apache, sometimes, almost randomly, > the connection will time out. Then i

MySQL Timing out

I have an include file that includes my mysql connect information. Its sole purpose is to login to mysql. Strangely on my Win9x development system with apache, sometimes, almost randomly, the connection will time out. Then if I press refresh it works prefectly. I am only connecting once per pag

MySQL Connection Timing out in PHP?

I have an include file that includes my mysql connect information. Its sole purpose is to login to mysql. Strangely on my Win9x development system with apache, sometimes, almost randomly, the connection will time out. Then if I press refresh it works prefectly. I am only connecting once per pa