Re: Smallest install of mySQL
Michelle de Beer wrote: This question might be a little OT. My question is, what is the smallest working install of mySQL? Can you install it in a PDA, like the Yopy, that uses linux as OS? http://www.yopy.com/english/products/specification.htm // Michelle sql, query Hi Michelle, MySQL has already been ported to the Sharp Zaurus (http://www.caulfei.demon.co.uk/zaurus/index.html); it should run on the yopy also. Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 See http://www.fsf.org/philosophy/no-word-attachments.html - 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:RE: Query Optimization
Dave Dutcher [EMAIL PROTECTED] wrote on 24.07.2002 21:35:03: Hi, I did some more research on my problem. (Sorry for not doing it before I posted the other message), and I think perhaps my question could be summarized into the following. Can I use an index to speed up a select max() or select min()? I read what the manual has to say about a query like this: SELECT MIN(key_part2),MAX(key_part2) FROM table_name where key_part1=10 However I want to do this: SELECT MAX(key_part1) FROM table_name where key_part1 10 also what I want to do is basically equivalent to this: SELECT key_part1 FROM table_name WHERE key_part1 10 ORDER BY key_part1 DESC LIMIT 1 In testing the second statement seems slower than the max() for some reason though. Is there anyway to get close to a O(logN) search time on these queries? Thanks again, Dave -Original Message- From: Dave Dutcher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 1:04 PM To: [EMAIL PROTECTED] Subject: Query Optimization I was wondering if somebody could give me any suggestions on how to optimize a query I am working on. This is my table: CREATE TABLE testdata ( Begin char(9) NOT NULL default '', End char(9) NOT NULL default '', UNIQUE KEY BeginEndIndex (Begin,End) ) TYPE=MyISAM; It is a table of ranges. i.e. 1-5, 7-11, 2-24000. None of the ranges overlap, and I'm trying to write a query to find a range that contains a specific number such as 500,000. So this is what I've written for a query: select Begin, End from testdata where begin = '00500' and end = '00500' On a table with 100,000 records the explain command tells me it is using the BeginEndIndex, it says the key length is 9, and that it has to look through about 27,000 records. I would like to be able to configure the query or indexes , so it will only have to look through a couple records if possible. MySQL is super fast at a query like this: select Begin from testdata where Begin = '00500'; So I had the idea of trying this: select max(Begin) from testdata where Begin = '00500'; I was hoping that it would do the same as the simple select, and then because it has a sorted index it wouldn't have to search the previous records to find the max, but explain still puts this at about 27,000 records. Has anyone else tried writing a query similar to this? Does anybody have any suggestions? Thanks in advance, Dave Hi Dave, IMHO you can speed up your queries if you convert your columns to (unsigned) int if possible. It should be much faster to compare two integers (4 bytes,2 assembler instructions) than comparing two strings (9 bytes,10 assembler instructions). Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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:myODBC BIGINT conversion
Dennis [EMAIL PROTECTED] wrote on 17.07.2002 20:37:50: sql query We have data stored as BIGINT in unix, and there are 32bit unsigned values but nothing larger. I would assume if we convert this to integer in win98 it would seem that values over 31bits would be wrong. Are there workarounds for this? Is this also an issue in later version of windows? DB Hi Dennis, why don't you use SQL_BIGINT together with __int64? I think this should give you the correct values and you can control the conversion to a 32 bit unsigned. Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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:UPDATE command..
Patrick J Okui [EMAIL PROTECTED] wrote on 16.07.2002 15:47:50: I have two collumns in my mysql database like this +--++ |id|domain | +--++ |user@domain1com |domain1.com | |[EMAIL PROTECTED] |domain1.com | |[EMAIL PROTECTED] |domain1.com | +--++ in a table users. How do I construct an sql update statement like update users set id =. where domain = domain1.com so that the id column becomes +--+ |id| +--+ |[EMAIL PROTECTED] | |[EMAIL PROTECTED] | |[EMAIL PROTECTED] | +--+ thanks. Patrick J Okui Hi Patrick, try UPDATE users SET id=REPLACE(id,'domain1','domain2') WHERE domain='domain1. com'; Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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:Numeric Type Inconsistency ?Bug
[EMAIL PROTECTED] wrote on 12.07.2002 12:58:00: MySQL, I'd have expected all three of the following to give the same result, but even if there's a type-conversion problem from INT, then I certainly wouldn't expect it to be different for 798.1 and 1e30 for example... mysql select 798 between 75.2 and 999.1; ++ | 798 between 75.2 and 999.1 | ++ | 1 | ++ 1 row in set (0.01 sec) mysql select 798 between 75.2 and 1e30; +---+ | 798 between 75.2 and 1e30 | +---+ | 0 | Really? +---+ 1 row in set (0.00 sec) mysql select 798.1 between 75.2 and 1e30; +-+ | 798.1 between 75.2 and 1e30 | +-+ | 1 | +-+ 1 row in set (0.00 sec) Any comments? Hi James, tested this against 3.23.45; it's reproducible. The problem appears if the upper range exceeds 0.92233e19 (signed bigint). But the manual states that this is NOT a bug: expr BETWEEN min AND max ... - If expr is an integer expression, an integer comparision is done. - Otherwise, a floating-point (real) comparision is done. ... Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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:help !
Brett Whittaker [EMAIL PROTECTED] wrote on 10.07.2002 18:28:54: I was trying to connect into an MYSQL database, and I keep getting the error message Can't connect to MySQL server on '10.10.10.250' (10054) but I know that the database is running and I can connect fine on the server itself! Any suggestions would be greatly appreciated. Hi Brett, try to connect using a telnet 10.10.10.250 3306. You should get some control characters and the version number of your server. If not check your network connection. Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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:rand() ... limit by .... my retrivals
toby - [EMAIL PROTECTED] wrote on 09.07.2002 11:35:40: Hi Toby, hi guys im trying to retrieve 5 record each page from my db my code iz : $query_nme = SELECT firstName, lastName, title, summary FROM ctnt_inf ^^ I think you should include id, to get the row id where ctnt_id ORDER BY RAND() LIMIT 5; $query_result_handle_nme = mysql_query ($query_nme) or die ('qry failed ! DA tbl must xixt in DA db specifyd bov '); echo(pfont align=RIGHT); for ($cnt=0; $cnt=5; ++$cnt ) { $row_nme = mysql_fetch_row ($query_result_handle_nme); echo (brbr); $tID = $row_id[0]; ^^ If you include id in the query this should read $row_nme[0] $tName = $row_nme[0]; ^^ If you include id in the query this should read $row_nme[1] You can retrieve the other fields by using an increasing index (i.e. $row_nme[2], $row_nme[3]...) echo ( $tID ); echo ( $tName ); } // echo (brbr); echo(/font/p); problem: it only displays firstName n nothing else though 5 random first names but i guess i'll ve to make seperate query fo each field in the table or will i thnx a million . toby . Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine
Ireneusz Piasecki [EMAIL PROTECTED] wrote on 08.07.2002 11:22:23: Hi friends. I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box, kernel 2.2.19. When i do ps -ax on shell, i see below 5807 ?Z 0:00 [mysqld defunct] this happens somtimes, but table are'nt coruppted. I have checked it. It is dangerous for my system, that server MySQL is sometimes defunct (zombie). I noticed, he is selfrepaired, sencond time when i make ps -ax, all is allright. server is running as usual (no zombie). Regards Irek. Hi Irek, do you have something in the logs (i.e. /var/lib/mysql/yourhostname.log) when this happens? Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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:Re: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine
Ireneusz Piasecki [EMAIL PROTECTED] wrote on 08.07.2002 11:59:08: Hi. No, the log serwer.err is clear. No errors. mysql serwer is running from may 2002 , before i have mysql 3.23.49. Sometimes he also was as zombie process. Now a have 3.23.51. The problem still exists, system working, so i don't know, it is dangerous sytuation ? regards, Irek. - Original Message - From: Oliver Six [EMAIL PROTECTED] To: [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Monday, July 08, 2002 11:38 AM Subject: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine Ireneusz Piasecki [EMAIL PROTECTED] wrote on 08.07.2002 11:22:23: Hi friends. I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box, kernel 2.2.19. When i do ps -ax on shell, i see below 5807 ?Z 0:00 [mysqld defunct] this happens somtimes, but table are'nt coruppted. I have checked it. It is dangerous for my system, that server MySQL is sometimes defunct (zombie). I noticed, he is selfrepaired, sencond time when i make ps -ax, all is allright. server is running as usual (no zombie). Regards Irek. Hi Irek, do you have something in the logs (i.e. /var/lib/mysql/yourhostname.log) when this happens? Bye Oliver -- Hi Irek, IMHO a zombie is never a good thing. Maybe the log is in another directory (depending on your compile options)? Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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:Re: Licensing--web site is schizophrenic
Victoria Reznichenko [EMAIL PROTECTED] wrote on 08.07.2002 12:01:01: Paul, Sunday, July 07, 2002, 11:05:18 PM, you wrote: PS At one place on the MySQL site I see: PS http://www.mysql.com/support/arrangements.html PS which says the client library is under the LGPL. PS At another place I see: PS http://www.mysql.com/doc/C/o/Copyright.html PS which says the entire codebase, including the client, is released under PS the GPL. PS Does this mean newer versions of MySQL client libraries are GPL'd? I'll PS be disappointed if this is true, because there are plenty of open source PS licenses which are incompatible with the GPL. This means that none of PS those other open source projects can use or include support for MySQL. PS Which is a shame. 3.23.XX API is under LGPL, 4.X API is under GPL instead of LGPL. For more question about licensing go to : [EMAIL PROTECTED] -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com Hi, does this mean that whenever I write a program in msc which makes use of the libmysql.dll in conjunction with MySQL 4.x I have to make this program GPL? Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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