to any reactions
Best regards,
Tim Samshuijzen
Software database engineer
mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I have two tables:
CREATE TABLE categories (
CategoryNumber int(11) NOT NULL,
ItemNumber int(11) NOT NULL,
KEY CategoryNumber (CategoryNumber),
KEY ItemNumber (ItemNumber)
);
CREATE TABLE items (
ItemNumber int(11) NOT NULL auto_increment,
Description varchar(100)
Hello, I don't understand why my queries are so incredibly slow.
We have MySQL on a 800MHz Linux machine with 513Mb.
Most queries look like this:
SELECT B.* FROM maintable AS M, wordindex AS YL1,
wordindex AS YL2, wordindex AS YL3
WHERE
YL1.Word = 'billy' AND
YL1.RecordNumber =
the query is amazingly slow.
Tim
At 10:52 AM 6-2-2001 +, you wrote:
Tim Samshuijzen [EMAIL PROTECTED] writes:
Anyone out there who wants to save me and our company?
You missed the important first step: EXPLAIN the query.
--
Dave Hodgkinson, http
308 2 297 380 34 16
50
1 0 0 3936 3072 10484 217860 0 0 0 0 10310 67 33
0
0 0 0 3936 4064 10500 218392 0 0 565 1 411 558 10 5
84
Does this make any sense to you?
Tim
At 12:17 PM 6-2-2001 +, you wrote:
Tim Samshuijzen [EMAIL
complete within short time.
can you send the output of DESCRIBE db.tablename of all used tables?
regards,
rene
- Original Message -
From: "Tim Samshuijzen" [EMAIL PROTECTED]
To: "Ren Tegel" [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 3:07 PM
Subject: Re: amazin
their performance enhancement.
could that be true?
dan
-Original Message-
From: Tim Samshuijzen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 6 February 2001 04:50
To: [EMAIL PROTECTED]
Subject: Re: amazingly slow
Dear Dave,
Thanks for your reply.
(The table actually works with word
: error in loading shared libraries:
libmysqlclient.so.6: invalid ELF header
I hope you can help me with this information.
Thanks,
Tim Samshuijzen
At 22:21 3-2-2001 -0200, you wrote:
I suppose your operational system is Windows... Or is it Linux? Regarding
Windows at least, and I believe Linux also
Hey Rop,
wist je wel dat ik het was (Tim van Rockingstone).
wat toevallig dat je zat mee te kijken. (beetje laat of niet?)
bedankt voor de tip.
Tim Samshuijzen.
(Sorry for the Dutch everyone)
At 02:49 4-2-2001 +0100, you wrote:
On Sat, Feb 03, 2001 at 11:13:14PM -0200, Fbio Ottolini wrote
dangerous this is, but it works!
I will keep it this way untill someone here can recompile the libraries.
Thanks!
Tim Samshuijzen
At 21:02 3-2-2001 -0500, you wrote:
The mysql version compiled into your web server uses shared libraries and
your current version (upgrade) apparently is a statically
;
}
then do the following:
SELECT * FROM item ORDER BY id LIMIT $count,$limit;
Tim Samshuijzen
At 09:03 31-1-2001 -0600, you wrote:
Remco van den Berg wrote:
On Wed, Jan 31, 2001 at 08:00:23AM -0600, The Tilghman wrote:
Try sorting in DESCending order.
SELECT * FROM item ORDER BY id DESC
Hello,
I have just deleted thousands of records but the file
is still the same size as before. How do I make the
file compact? i.e. how do I get rid of all the "empty
spaces" in the table?
Tim Samshuijzen
-
Befo
ear future.
Could anyone give me advice on how to increase performance?
Any help is much appreciated.
Thanks!
Tim Samshuijzen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
ear future.
Could anyone give me advice on how to increase performance?
Any help is much appreciated.
Thanks!
Tim Samshuijzen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
14 matches
Mail list logo
