, January 25, 2003 5:15 PM
Subject: Re: How to speed things up in MySQL ?
Sounds weird. Can you e-mail us a 'mysqldump' of the table defination with
the data?
Thanks,
Bhavin.
- Original Message -
From: Thomas Kvamme [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 25
Just to toss something into the fray: I had a similar problem, where
any query was taking a very long time to run. I never did discover what
the problem was but suddenly, one day later the problem was gone. I had
rebooted my server twice in the mean time with no resolve. There is
quite a bit
Hi.
On Sun 2003-01-26 at 00:26:32 +0100, [EMAIL PROTECTED] wrote:
Here is the table definition as requested.
I'm sorry I could take a full dump... Each record consist of approx 600 KB
(just as in the Paradox table) so the file would be very big. (200 MB).
Well, you should have told us that
Zak Greant wrote:
I am coming in a bit late on this - however, did you send in a copy of
the table structure?
It sounds like you don't have indexes on the tables.
--zak
On Sun, Jan 26, 2003 at 12:59:31AM +0100, Thomas Kvamme wrote:
Hi again,
Just did another test which I find very
Benjamin Pflugmann [EMAIL PROTECTED] wrote:
Hi.
Hi Benjamin :-)
On Sun 2003-01-26 at 00:26:32 +0100, [EMAIL PROTECTED] wrote:
Here is the table definition as requested.
I'm sorry I could take a full dump... Each record consist of approx 600
KB
(just as in the Paradox table) so the
Hi.
On Sun 2003-01-26 at 15:22:06 +0100, [EMAIL PROTECTED] wrote:
Benjamin Pflugmann [EMAIL PROTECTED] wrote:
[...]
Why does MySQL needs to scan the Entire Table (all 200 MB) when I only have
selected ID ProductionYear in the SELECT statement ??
Because you have a table with variable-width
Hi!
I guess the reason for this is that the I have a some blob fields whitch are
all used.. (each record consist of approx 600 KB...)
Yes, it's the reason.
600K per record...
But since I donesn't include any of the blob fields in the SELECT statement
I can't see no reason why MySQL should
[...]
Why does MySQL needs to scan the Entire Table (all 200 MB) when I only
have
selected ID ProductionYear in the SELECT statement ??
Because you have a table with variable-width records and there is no
way to easily find out where a field of a record is stored without
reading all.
Sergei Golubchik [EMAIL PROTECTED] wrote:
Because MyISAM always reads the record as a whole, it cannot read only
selected fields.
You can convert your table to InnoDB table type - as InnoDB *can* read
only selected fields.
Actually, it's useful optimization to store big, rarely selected
I guess the reason for this is that the I have a some blob fields
whitch are
all used.. (each record consist of approx 600 KB...)
There it is. MySQL's MyISAM will get the whole record even if it only
needs a part. You can try InnoDB as it does it differently.
[At some point I may try and add
Steven Roussey wrote:
I guess the reason for this is that the I have a some blob fields
whitch are
all used.. (each record consist of approx 600 KB...)
There it is. MySQL's MyISAM will get the whole record even if it only
needs a part. You can try InnoDB as it does it differently.
Hi
Hello,
While reading this you may think this is off-topic... but please read on..
I'll get on-topic in the end :-))
First of all I have Web Server on which I have a Paradox table with 320
records.
I also have a CGI Script (or program if you like) I made in Borland Delphi
which I use to access
Sounds weird. Can you e-mail us a 'mysqldump' of the table defination with
the data?
Thanks,
Bhavin.
- Original Message -
From: Thomas Kvamme [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 25, 2003 7:36 AM
Subject: How to speed things up in MySQL ?
Hello,
While
Hi.
On Sat 2003-01-25 at 13:36:01 +0100, [EMAIL PROTECTED] wrote:
[...]
mysql select count(id) as Films, ProductionYear from DVD
- group by ProductionYear
- order by ProductionYear desc;
[...]
39 rows in set (13.32 sec)
mysql
***
How is this
Subject: Re: How to speed things up in MySQL ?
Sounds weird. Can you e-mail us a 'mysqldump' of the table defination with
the data?
Thanks,
Bhavin.
- Original Message -
From: Thomas Kvamme [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 25, 2003 7:36 AM
Subject: How
BY on the same table in MySQL takes 13 seconds... still can't belive
it.
--
Thomas
- Original Message -
From: Bhavin Vyas [EMAIL PROTECTED]
To: Thomas Kvamme [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, January 25, 2003 5:15 PM
Subject: Re: How to speed things up in MySQL
AM
Subject: How to speed things up in MySQL ?
Hello,
While reading this you may think this is off-topic... but please read on..
I'll get on-topic in the end :-))
First of all I have Web Server on which I have a Paradox table with 320
records.
I also have a CGI Script (or program if you
17 matches
Mail list logo