Re: Need help about mysql order and index....
Okay is not a reply for myself :) is only for add a question... :) I read that mysql 4 will fix this, but mysql 4 is stable? I mean i'm on production, i'm not selling mysql :) I mean I have a big projet in test using mysql.. so if it crash it will be very bad for me... someone had test mysql 4? stable or not? :) Jean-Francois Dionne - Original Message - From: Jean-Francois Dionne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 7:25 PM Subject: Need help about mysql order and index Hi there, I hope someone will can help me... First, sorry for bad english :) i'm french First all I have those index in my table +---+---+-++ --+-++--++ -- + | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---+---+-++ --+-++--++ -- + | Stats | 0 | PRIMARY |1| ID | A | 4568748 | NULL | NULL| | | Stats | 1 | Port_ID |1| Port_ID | A | 1 | NULL | NULL| | | Stats | 1 | Timestamp |1| Timestamp | A | 49126 | NULL | NULL| | +---+---+-++ --+-++--++ -- + You have to know I have 4 500 000 in my db Okay I have this query: select Timestamp from Stats use index (Timestamp) where Timestamp = '2002-01-01' and Timestamp '2002-02-01' order by Timestamp limit 1; this one is jsut doing fine.. it take 0.00 sec to do it... but select Timestamp from Stats use index (Timestamp) where Timestamp = '2002-01-01' and Timestamp '2002-02-01' order by Timestamp desc limit 1; this one take sometime 10 sec to do I understand is the desc the prob.. because my index is in asc (collation=A) my question is... is there a way for maiking a index in desc? or maybe something else? Jean-Francois Dionne Yard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
information on mysql 4.0.2
I see people speaking about mysql 4.0.2... but where you get it? they write some thing about it on web page but 4.0.2 is not in the download list... maybe someone can say if mysql 4 is stable? I mean if I can use it without 100 crash in 1 hour :) Sorry for bad english :) Jean-Francois Dionne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: information on mysql 4.0.2
So it's better using 4.0.1 of 4.0.2? Jean-Francois Dionne - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Jean-Francois Dionne [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 8:12 PM Subject: Re: information on mysql 4.0.2 On Fri, Feb 15, 2002 at 08:03:19PM -0500, Jean-Francois Dionne wrote: I see people speaking about mysql 4.0.2... but where you get it? they write some thing about it on web page but 4.0.2 is not in the download list... It's from the MySQL source tree. See this url: http://www.mysql.com/doc/I/n/Installing_source_tree.html for instructions. maybe someone can say if mysql 4 is stable? I mean if I can use it without 100 crash in 1 hour :) Parts of it are. But parts are not, and that's what we're talking about. In my case, we're testing the new replication code in 4.0.2 to make sure it is stable. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 8 days, processed 278,746,500 queries (381/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need help about mysql order and index....
Hi there, I hope someone will can help me... First, sorry for bad english :) i'm french First all I have those index in my table +---+---+-++ --+-++--++-- + | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---+---+-++ --+-++--++-- + | Stats | 0 | PRIMARY |1| ID | A | 4568748 | NULL | NULL| | | Stats | 1 | Port_ID |1| Port_ID | A | 1 | NULL | NULL| | | Stats | 1 | Timestamp |1| Timestamp | A | 49126 | NULL | NULL| | +---+---+-++ --+-++--++-- + You have to know I have 4 500 000 in my db Okay I have this query: select Timestamp from Stats use index (Timestamp) where Timestamp = '2002-01-01' and Timestamp '2002-02-01' order by Timestamp limit 1; this one is jsut doing fine.. it take 0.00 sec to do it... but select Timestamp from Stats use index (Timestamp) where Timestamp = '2002-01-01' and Timestamp '2002-02-01' order by Timestamp desc limit 1; this one take sometime 10 sec to do I understand is the desc the prob.. because my index is in asc (collation=A) my question is... is there a way for maiking a index in desc? or maybe something else? Jean-Francois Dionne Yard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php