Rich,
Thanks for the email. I created a multi-field index using the fields that
are in the query and the query only took 0.91 seconds. That's better than 9
minutes and definitely under 30 seconds.
Thanks.
Chris.
-Original Message-
From: Richard Davey [mailto:[EMAIL PROTECTED]
Sent: Tue
Why does it only use the one index?
Chris.
-Original Message-
From: Richard Davey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 09, 2004 11:00 AM
To: [EMAIL PROTECTED]
Subject: Re: Optimizing Queries
Hello Chris,
Tuesday, March 9, 2004, 4:38:00 PM, you wrote:
CF> I'm trying to deter
Hello,
I'm trying to determine the best way to optimize the query below. Right now
it is taking around 9mins and we need it to take no more than 30 seconds (we
can get it under 30s on MS SQL):
explain select count(distinct(phone)) as TOTAL
FROM speedlink
WHERE
county in('247','085','145','285',
It seems that each time we select into an OUTFILE that already exists
(re-use a name) the server crashes.
Anyone have any ideas if this is a setting or just a bug?
Thanks.
Chris.
nt: Monday, February 23, 2004 11:42 AM
To: Chris Fossenier; [EMAIL PROTECTED]
Subject: Re: MySQL versus MS SQL
Hi Chris,
Chris Fossenier wrote:
> This is a long post, my apologies.
Speaking for myself, I found the detail most helpful. Thanks!
See response at bottom.
...snip...
> QUER
Hello,
This is a long post, my apologies.
I have been working on migrating a database from MS SQL to MySQL for about 1
month now and am at a point where I can start running some tests to see how
they compare. I'll provide a little background to help you out.
The MS SQL database is 120million
ad with so
many records.
We'll see if this modification works for all 120million. So far it worked
for a 6mill sample.
Thanks.
Chris.
-Original Message-
From: Donny Simonton [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 3:04 PM
To: 'Dan Nelson'; 'Chris Fossenie
What is the best way to deal with white space in a mysql database?
What I'm talking about is trailing spaces in larger fields. We receive data
in fixed width format, so when you import it, you get a bunch of trailing
white spaces that take up space. Multiply these white spaces by 120million
recor
I am planning a server upgrade and would like to update MySQL in the
process. The preferred plan is to:
1. Upgrade the server Operating System.
2. Copy the MySQL files to the new storage system.
3. Install MySQL 4.0.18 and point it to the old MySQL directory
4. Start 4.0.18 and have no problems.
nothing over 20mill for records.
Chris.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 5:47 PM
To: Chris Fossenier
Cc: 'Peter Zaitsev'; 'MySQL List'
Subject: RE: Indexing Woes
These files will be created in the /tm
] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 5:13 PM
To: Chris Fossenier
Cc: 'Peter Zaitsev'; 'MySQL List'
Subject: RE: Indexing Woes
If I am reading your parameter correctly, MySQL will limit the size of
the temporary file created to 30GB. If the file exce
al Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 4:50 PM
To: Chris Fossenier
Cc: 'Peter Zaitsev'; 'MySQL List'
Subject: RE: Indexing Woes
Performing your indexing in one batch will create a temp table only once
as opposed t
on my system?
myisam_sort_buffer
- I have 8GB of RAM, what should I set this to?
- my machine is dedicated to MySQL
Thanks.
Chris.
-Original Message-
From: Peter Zaitsev [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 2:03 PM
To: Chris Fossenier
Cc: 'MySQL List
lto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 12:10 PM
To: Chris Fossenier
Cc: 'MySQL List'
Subject: Re: Indexing Woes
Yes a duplicate copy of the table is created and the Indexes are created
on that new table, the original table is dropped and the new table is
renamed.
Hello,
I had a question about indexing a while back and everyone screamed
"normalize"!!
Well...I've normalized much as I'm going to, and at most I have 3 indexes on
any one table. My database has 120 million records in it and the index
creation is taking a ridiculous amount of time. I can creat
Mike,
Thanks for the input. I also received this tip from Peter of the MySQL team.
We'll see if it works.
Chris.
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Monday, January 26, 2004 3:03 PM
To: Chris Fossenier
Cc: MySQL List
Subject: Re: Index Creation Bottle
We have a large database that consists of 1 table with 400 fields. I know,
the first thing you are thinking is normalize, it's not an option right now
and the database gets reloaded every 3 months. The table contains marketing
data so it is not as easy to normalize as an employee database, or helpd
17 matches
Mail list logo