I recently noticed that my MySQL server was getting about 3 connections every 2
seconds. Checking the error log I discovered that a user '[EMAIL PROTECTED]' was
trying to connect to the server over and over and over and failing each time. Curious
as to what this 'user' was trying to do, I allo
Thanks to everyone for their help, I actually managed to fix the problem by bypassing
MySQL's optimization using STRAIGHT_JOIN. Out of curiosity can anyone tell me why
MySQL failed so miserably at optimizing my query? (The two hour long query took 10s
with Straight_join).
mysql> explain select
cmt.place=y03m02_Acdt.place
AND y03m02_Acmt.charge_id=y03m02_Acdt.charge_id;
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 5:54 PM
To: [EMAIL PROTECTED]
Cc: Charles Vos
Subject: Re: Speed Up Insert Query Results
On 26 Jun 2003 at 17:45, Charles Vos w
Hello All,
Could somebody please enlighten me as to why it takes nearly 2 hours to put 8 rows
of data into my table?
The insert commands I use are:
insert into mytab2
select y03m02_Pt.person, y03m02_Acdt.place, y03m02_Acdt.charge_id, y03m02_Acdt.disch,
y03m02_Pt.age, y03m02_Pt.sex, y03m02_Pt
