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

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

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

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

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: 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 'source batch-file

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

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

timing problem

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 be when

Re: timing problem

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 the data

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

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 the data

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, it

Re: timing problem

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 be when the server is loaded. Does this happen? If so what can I do about it, would putting the inserts into one big

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

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 can write

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 command in MYSQL command prompt so

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 include date/time for timing benchmarks

Re: Changing the Prompt for timing purposes

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 can write to.sorry about the basic questions but I'm a newbe. George __ Switch

RE: timing

. ;) -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 reports) that draw straight from the MYSQL database. They use only 1

RE: timing

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 FTPing a file

Re: timing

. 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 I have 2 Crystal Reports 8.5 (for the record I didn't make these reports

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 , about 4

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

RE: timing

. -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 1 table. I am calling

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 trying to do other

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

- 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 and print

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

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 time, making your

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:

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

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 updates

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

Re: Getting timing from MySQL scripts

), 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 I need precision greater than 1 sec

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

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

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 number

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

Re: MySQL Timing out

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 include file that includes my mysql connect information. Its sole purpose

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