Re[4]: Serious MySQL internal deadlock
Hello Sinisa, Sunday, February 04, 2001, 3:15:21 PM, you wrote: SM Peter Zaitsev writes: SM Hello Andreas, SM SM Thursday, February 01, 2001, 7:42:31 PM, you wrote: SM SM SM I must confirm the problem with table locks. Mysql realy may deadlock SM sometimes, and the funny thing is the solution to this case is to kill SM the oldest locked thread waiting this condition - afterwards SM everything resolves. So this may mean something like broadcast is lost SM sometimes (?) SM SM SM Hi! SM I guess we may sound to be obnoxious, but can you make a repeatable SM case out of it ?? Well. I wish I could - I was never able to repeate this, althought it appears again and again - on my 15 servers under mysql I usually see this about once per week, so it seems to be seldom one :) -- Best regards, Petermailto:[EMAIL PROTECTED] - 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
MySQL Memory Requirements...
Can someone please give me a rough estimate of how much RAM MySQL would require to run something like : A connection pool of around 50 connections 20,000 users every week re-using these 50 connections around 50 inserts per user (each row around 30 bytes) around 20 queries per user Installation on Linux is it possible to estimate RAM required for that information - is there anything else I could provide? thanks for your help Dan -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Monday, 5 February 2001 07:55 To: Vangipuram, Anand; [EMAIL PROTECTED] Subject: Re: System Requirements... It will run on most computers of today. Question is what system have you got/want, what are you going to use it for and what is the expected volume of information? - Original Message - From: "Vangipuram, Anand" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 0:31 Subject: System Requirements... What are the system requirements for installing mysql? Anand Vangipuram 414-566-6701 This message has been scanned for viruses with Trend Micro's Interscan VirusWall. - 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 - 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
SQL statement please help
Hi, I hope that someone can help me with a SQL statement. I dont know if this is the right place to ask the question, if not please redirect me. I have a table in my MySQL database named "data" with the following fields date: UNIX Timestamp Datasize : Int now i would like to do something like this select sum(datasize) from data group by ( this is the problem. I would like to be able to group on hours, 10 min, 30 min and so on, one at a time) Can someone help me completing the statement ? Yours Erik Aaskoven
another bug in substring_index in conjunction with UDF functions?
Description: My udf function and an equal udf function I found in the internet seem to work well as does substring_index. Only when I call them together I get a bug. As my function (quotet below) is so simple that it doubtly has a bug I guess substring_index has one. How-To-Repeat: mysql select substring_index("1.2.3.4/24","/",1) ; +-+ | substring_index("1.2.3.4/24","/",1) | +-+ | 1.2.3.4 | +-+ 1 row in set (0.00 sec) mysql select ewu_aton("1.2.3.4"); +-+ | ewu_aton("1.2.3.4") | +-+ |16909060 | +-+ 1 row in set (0.01 sec) mysql select ewu_aton( substring_index("1.2.3.4/24","/",1) ); +-+ | ewu_aton( substring_index("1.2.3.4/24","/",1) ) | +-+ | 3772388104 | +-+ 1 row in set (0.00 sec) Here the correct value should had been 16909060 (0x01020304), too! My Function: /* ** inet_aton() */ my_bool ewu_aton_init(UDF_INIT *initid, UDF_ARGS *args, char *message) { if (args-arg_count != 1 || args-arg_type[0] != STRING_RESULT) { strmov(message,"Wrong arguments to ewu_aton; Use the source!"); return 1; } initid-max_length=20; initid-maybe_null=0; return 0; } long long ewu_aton(UDF_INIT *initid, UDF_ARGS *args, char *is_null, char *error) { struct in_addrin; inet_aton(((char*) args-args[0]), in); *is_null=0; return htonl(in.s_addr); } Fix: I'd wish I'd have one :-) Submitter-Id: submitter ID Originator:Christian Hammers Organization: WESTEND GmbH MySQL support: none Synopsis: substring_index bug with udf function Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.30-gamma (Source distribution) Server: /usr/bin/mysqladmin Ver 8.13 Distrib 3.23.30-gamma, for pc-linux-gnu on i586 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.30-gamma and 3.21.30 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 5 days 17 hours 34 min 27 sec Threads: 3 Questions: 128800303 Slow queries: 1299 Opens: 260 Flush tables: 1 Open tables: 48 Queries per second avg: 260.062 Environment: Testet on two different i386 architecture machins running with two versions of Debian GNU/Linux (an old and the latest) System: Linux han 2.4.0-test12 #1 Fre Dez 22 15:58:55 CET 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/pgcc/lib/gcc-lib/i686-pc-linux-gnu/pgcc-2.95.2/specs gcc version pgcc-2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jan 19 09:25 /lib/libc.so.6 - libc-2.2.1.so -rwxr-xr-x1 root root 1078540 Jan 14 07:51 /lib/libc-2.2.1.so -rw-r--r--1 root root 2471916 Jan 14 07:53 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 14 07:53 /usr/lib/libc.so -rw-r--r--1 root root 2024202 Sep 6 15:18 /usr/lib/libc-client.a -rw-r--r--1 root root 665260 Sep 6 15:18 /usr/lib/libc-client.so -rw-r--r--1 root root 665260 Sep 6 15:18 /usr/lib/libc-client.so.4.7 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db-includes=/home/ch/debian/mysql/mysql-3.23.30/debian/db-3.2.3g/build_unix --with-berkeley-db-libs=/home/ch/debian/mysql/mysql-3.23.30/debian/db-3.2.3g/build_unix --enable-static --enable-shared --with-raid --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --without-readline --with-extra-charsets=all
amazingly slow
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 = M.RecordNumber AND YL2.Word = 'bob' AND YL2.RecordNumber = M.RecordNumber AND YL3.Word = 'john' AND YL3.RecordNumber = M.RecordNumber AND M.Price = 1000 LIMIT 0,50; wordindex is a table that contains all words present in maintable. For each word there is a link to maintable through RecordNumber. This query searches for all records in maintable that contain the three words and where it's price is more than 1000. This query takes more than 20 seconds! I hear from others that this query should be returned in a flash! maintable contains about 900,000 records. wordindex contains about 21,000,000 records All columns are indexed. Here are my parameters: key_buffer=256M table_cache=256 sort_buffer=1M record_buffer=2M join_buffer=4M max_sort_length=30 max_connections=300 I am really desperate. I've been trying everything. I've tried the OPTIMIZE TABLE commands, but this also doesn't help. Anyone out there who wants to save me and our company? Thanks a lot! Tim - 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
Design philosophy
Hi, Because of various political issues during the development of our web site, it has been suggested that the web server and php scripts should be connected to the database server via a shared 2Meg WAN connection. As I am rather green when it comes to setting up internet sites which use databases I would welcome the comments of some "power" users who have experience of setting up large web database sites. For example: * I presume it is essential to have as fast links as possible (100meg) between the two servers * It is normal design philosophy to have the php scripts on the web server which talk to the database server or is there some other way in which it could be done. What do Amazon do? Sorry if these are rather basic questions, but I would like the view of as many users as possible, and if possible the names of the sites which work on that principle. Thanks, David
Re: Multiple AND on many-many-table.
Does anybody know what is the fastest way to run a large multiple AND type query on a many-many table and the least memory hungry. Sir, what is a type query, and what in the world is a many-many table? For example if I have create table test (id int, value int); which has many-to-many on id, and value ? I want to do a select like select id from test where id in (select id from test where value in (1,2,3) and id in (select id from test where value in (4,6,7) and id in (select id from test where value in (1,6,25) Even if MySQL supported subqueries, this query would always return the empty set. I'm really unsure about what you're trying to do, but I think the following comes close. SELECT id FROM test WHERE value IN (1, 2, 3, 4, 6, 7, 25); So I must return users that qualify for at least one value in several lists, obviously this is somewhat easy with subselects... Without subselects I'm doing this, can anybody tell me of a better way? create table temp (id int not null, key (id)) type=heap; insert into temp select id from test where value in (1,2,3); insert into temp select id form test where value in (4,6,7); insert inot temp select id from test where value in (1,6,25); select id from temp, count(*) as numlines from temp group by id having numlines = 3; drop table temp; there will be anywhere between 1 and 10 of the above lists for this query so then I return the qulified useres by doing this on the heap table where the having part is equal to the number of lists that were checked. Obviously the temp table can get very large depending the query, currently this seems pretty fast, but I'm concerned that it will blow up on me as I get more id values anybody know a better way? A self join comes to mind but if there are many users and say 10 questions then the length of the self join result before the WHERE is userlines^10 which can be a very big number. - 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 Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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: Can anyone do this ?
Sir, in the first SQL statement, you could use HAVING cnt = (DAYOFYEAR(min)-DAYOFYEAR(max)) + 1 Of course, this won't work if min is in the year 2000 and max is in 2001. I think this will actually be easier to work out in your client, assuming you have a programmable client. Hi Bob, Many thanks for that. I was hoping (through absolute naiveity) not to have to go and calculate the number of days with the specified range. Unless, of course I could have mysql do this for me. Can anyone tell me how I could generate such a list. (ie something like: SELECT BETWEEN "2001-02-04" AND "2001-02-06" ? ) Thanks again, -- Frank Hi, I've been trying for a while now and I can't figure out how to do the following: In regular English, I wish to show all items for which I have allocations greater than one for all days encapsulated between the user input range. User Input: --- Date_from (ie. 2001-02-04) Date_to (ie. 2001-02-06) My Tables: -- Table1 +++ | id | name | +++ | 1 | Item1 | | 2 | Item2 | +++ Table2 ++-+---+ | date | no_of_items | table1_id | ++-+---+ | 2001-02-04 | 3 | 1 | | 2001-02-05 | 2 | 1 | | 2001-02-06 | 2 | 1 | | 2001-02-04 | 2 | 2 | | 2001-02-06 | 1 | 2 | ++-+---+ Basically my user says he/she needs a list of what items are available FROM a certain date TO a certain date. I therefor need to return all items which I have at least 1 of for EACH of the dates within my users range: I have tried using BETWEEN but it fails (ie. If my user says: from 2001-02-04 to 2001-02-06, using BETWEEN MySQL returns Item2 even though I do not have Item 2 listed for 2001-02-05. Here is where I'm at: mysql SELECT t1.*, t2.* - FROM Table1 t1, Table2 t2 - WHERE t2.date BETWEEN "2001-02-04" AND "2001-02-06" - AND t1.id=t2.table1_id - AND t2.no_of_Items =1; ++---++-+---+ | id | Item | date | no_of_items | table1_id | ++---++-+---+ | 1 | Item1 | 2001-02-04 | 3 | 1 | | 1 | Item1 | 2001-02-05 | 2 | 1 | | 1 | Item1 | 2001-02-06 | 2 | 1 | | 2 | Item2 | 2001-02-04 | 2 | 2 | | 2 | Item2 | 2001-02-06 | 1 | 2 | ++---++-+---+ What I need is a query which will generate the following result: ++---++-+---+ | id | Item | date | no_of_items | table1_id | ++---++-+---+ | 1 | Item1 | 2001-02-04 | 3 | 1 | | 1 | Item1 | 2001-02-05 | 2 | 1 | | 1 | Item1 | 2001-02-06 | 2 | 1 | ++---++-+---+ Forgive me if this is actually simple and/or I haven't explained clearly. Many thanks in advance for your help. -- Frank Sir, create a variable day_count with the count of days in the user-supplied range. Then set up the following temp table. CREATE TEMPORARY TABLE counts SELECT table1_id, Count(DISTINCT date_field) as cnt WHERE data_field BETWEEN min AND max GROUP BY id HAVING cnt = day_count; Now you have a table with the IDs of items that occur at least once each day in the user-supplied range. You don't need the DISTINCT if each item can only have one record per day. Now some inner joins should get the results you want. SELECT table1.*, table2.* FROM table1, table2, counts WHERE table1.id = table2.table1_id AND table1.id = counts.table1_id AND date_field BETWEEN min AND max; I haven't actually run this, which means that there's probably a mistake or three. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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 __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ Know
Re: amazingly slow
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://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
FULLTEXT mismatch for tables containing 1 row only
Hello Another possibly related FULLTEXT problem: in 3.23.32, if the table contains one row only, then a fulltext match occurs regardless of the pattern you search for: DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( id mediumint unsigned NOT NULL auto_increment, tag char(6) NOT NULL default '', value text NOT NULL default '', PRIMARY KEY (id), KEY kt(tag), KEY kv(value(15)), FULLTEXT KEY kvf(value) ) TYPE=MyISAM; INSERT INTO t1 (tag,value) VALUES ('foo','foobar'); SELECT * FROM t1 WHERE MATCH (value) AGAINST ('nonexistent'); DROP TABLE t1; If the table contains more than one row, then it works as expected (i.e. no match is found for 'nonexistent'). cheers -- TS - 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 and SQL_BIT type
Eric Fitzgerald writes: Let's try this one more time, just in case it got scimmed over :) Hello everyone. I'm hoping the developer of MyODBC hangs out on this list, but here goes. I browsed through the sources a bit, and I noticed several places where you are mapping SQL_BIT type to TinyINT. It appears this is only a one way mapping (software-odbc-mysql) and not the other way. What I would like is 1 of 2 things, either 1) A possible update to MyODBC where an option can be checked (similiar to large results etc..) that allows TinyINT columns to be "converted" to SQL_BIT when sent to the software or 2) Pointers on where in the sources the "translation" is done when coming from mysql. Reason I need these is I'm under the gun to "fully" integrate Visual FoxPro with MySQL (one data source, that whole thing) and the current Visual FoxPro tables use a LOT of bool fields. So if I can do a little translation on the fly, I can fake this, and make everyone happy :) Thanks in advance, Eric Fitzgerald Server Administrator AMN Television Marketing Hi! We have both myodbc and win32 mailing lists which are more appropriate for the above questions. If I knew the answer, I would have told you, but I don't .. ;-( Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: [ new install via script can not creat interrupt-thread]
Scott C Strecker writes: Description: When I try to run the install-db script I get an error stating that the script Can't create interrupt-thread. I can get the script to run as root. We are installing into /usr/local/mysql as per the instructions. The script suggest the command seen below. It gives the same error message. results - zigzag-182% ./bin/mysqld --skip-grant [1] 1054 zigzag-183% 010205 11:47:17 Can't create interrupt-thread (error 1, errno: 1) [1]Exit 1 ./bin/mysqld --skip-grant How-To-Repeat: Fix: Seems to work when logged in a root. Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis:interrupt-thread creation does not work Severity: Priority: Category: mysql Class: Release:mysql-3.23.32 (Official MySQL binary) Environment: System: IRIX zigzag 6.5 05190004 IP32 Some paths: /usr/sbin/perl /sbin/make /usr/freeware/bin/gmake /usr/freeware/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.8.1 Compilation info: CC='cc' CFLAGS='' CXX='CC' CXXFLAGS='' LDFLAGS='' LIBC: -r-xr-xr-t1 root sys 2244852 Jul 6 1998 /lib/libc.so.1 lrwxr-xr-x1 root sys 19 Jul 6 1998 /usr/lib/libc.so - ../../lib/libc.so.1 lrwxr-xr-x1 root sys 19 Jul 6 1998 /usr/lib/libc.so.1 - ../../lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --disable-shared Perl: This is perl, version 5.004_04 built for irix-n32 Hi! If you are talking about mysql_install_db, it should be run as a root. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
Installing MySQL 3.23.32 on Solaris 8 Intel
Hi, I attempted to install MySQL 3.23.32 on a Solaris 8 Intel. The version of cc I have is gcc 2.95.2. The version of tar I have is gnu tar 1.13. I encountered a problem while issuing this command : o ./configure --prefix=/usr/local/mysql The error message is : o checking return type of sprintf . configure: error can not run test programs while cross compiling According to the INSTALL file, this problem happens because my cc is not installed properly, or the version of gcc is not the recommended 2.95.2. However, as I've mentioned above, my gcc is of version 2.95.2. How can I solve the problem ? Regards, Lip Hong - 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
Real Time Data Base
Are "Heap Tables" possible solution for Real Time Data Base ? Is there other options in MySql world ? Thanks Paulo Roberto
Re: Arabic character set
we are setting up an Arabic web site using PHP with MySQL 3.23.22. Our problem is that we can not sort data correctly when retreiving it from Arabic text fields. This seems to be a character set problem. Has anyone any idea about using the Arabic character set with MySQL? Hi, This is an interesting issue I've just begun to investigate for a project where I plan to use mySQL to store text in different languages and charsets. Take a look at chapter 10.1 (What Languages Are Supported by mySQL?) on the mySQL manual, available online at: http://www.mysql.com/documentation/index.html http://www.mysql.com/Downloads/Manual/manual.pdf (this is the one I will refer) There are a number of things to check when using other than the default character set (ISO-8859-1 or Latin1), among them: mySQL version, character sets available and compiled, multi-byte support, client support and language specific features and bugs. I also found this info on section 4.7.3 (Typical configure Options) "By default, MySQL uses the ISO-8859-1 (Latin1) character set. To change the default set, use the --with-charset option: shell ./configure --with-charset=CHARSET CHARSET may be one of big5, cp1251, cp1257, czech, danish, dec8, dos, euc_kr, gb2312, gbk, german1, hebrew, hp8, hungarian, koi8_ru, koi8_ukr, latin1, latin2, sjis, swe7, tis620, ujis, usa7, or win1251ukr. See Section 10.1.1 [Character sets], page 328). If you want to convert characters between the server and the client, you should take a look at the SET OPTION CHARACTER SET command. (See Section 7.33 [SET OPTION], page 270). Warning: If you change character sets after having created any tables, you will have to run myisamchk -r -q on every table. Your indexes may be sorted incorrectly otherwise. (This can happen if you install MySQL, create some tables, then reconfigure MySQL to use a different character set and reinstall it.)". I'd would appreciate if anyone could share any comment or experience related to this issue. HTH, Lloren Sol Maresme Netcom, S.L. tel +34 937 411 047 fax +34 937 411 048 url http://www.maresme.net - 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: Fwd: MySQL problem
Have you create a startup script in /etc/rc.d? I believe you haven't created a startup script and you should type in ps -gax to see if mysql is running. On Tue, 06 Feb 2001, Vadim Selitskiy wrote: Hi How are you? No, I used rm command to delete, because rpm told that it is unable to remove mysql...rpm because it is not installed. I've tried to install mysql-server-3.23.32.rpm I've tried to install binary code during this weekend and again it was fine during first run and after I rebooted the server it showed the error message stated that "Can't connect mysql server through /tmp/mysql.sock" I've checked /tmp/mysql.sock and it is empty... At 04:32 PM 2/2/01 +1100, you wrote: -When you deleted the rpm version of mysql did you use the rpm command to dlete mysql? - What version of mysql are you trying to install? - Maybe, look at deleteing all the current mysql rpm with the rpm command and try it without the --no-deps option. - Or install a prevous version of mysql? -- Forwarded Message -- Subject: MySQL problem Date: Wed, 31 Jan 2001 23:01:22 -0500 From: Vadim Selitskiy [EMAIL PROTECTED] whereis mysql shows me two directories: /usr/lib/mysql, which is empty and /usr/share/mysql which has some documentation about mysql. Although it rpm program showed my dependecies problems I isntalled mysql server (that probably was my mistake), after I figured out that it doesn't work, I deleted /usr/local/mysql directory and installed binary version of the code. It didn't work either, so I've deleted it. Now, I think that I have to delete everything that named mysql and install it from scratch... Am I right? The problem is that I don't know what should I delete... I'm sorry, but I'm stupid in it and I don't have enough experience. Vadim Selitskiy Quality Engineer Organic, Inc 233 Broadway,14 floor NY NY 10279 (212)277-4769 - tel (212)277-4950 - fax - 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
Mysql/DBD Error
Could someone point me in the right direction with this problem please? I ran a perl script and this was the error message $ perl connect.pl install_driver(mysql) failed: Can't load '/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at connect.pl line 5 I read the documentation at http://www.mysql.com/doc/P/e/Perl_support_problems.html but i can not find libmysqlclient.so or libmysqlclient.so.10 anywhere on my system. can i just obtain a copy of these files and put them in place or will have to re compile? if i can obtain a copy of the files then where from? and do i need to make any other changes? Cheers Tom Turrisi
RE: Installing MySQL 3.23.32 on Solaris 8 Intel
Have you tried checking the Path info for your mysql account? Sometimes, the Path does no point to the correct gcc, I would test this withtwo commands: gcc -v or it is gcc -version (can't remember right now) which confirm what you said. AND type 'which gcc' to make sure your installation is pointed at the correct gcc. unfortunately I am rather new to this software package, and this is similar to a problem I had when I first started. -Original Message- From: Yeo Lip Hong [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 7:03 AM To: [EMAIL PROTECTED] Subject: Installing MySQL 3.23.32 on Solaris 8 Intel Hi, I attempted to install MySQL 3.23.32 on a Solaris 8 Intel. The version of cc I have is gcc 2.95.2. The version of tar I have is gnu tar 1.13. I encountered a problem while issuing this command : o ./configure --prefix=/usr/local/mysql The error message is : o checking return type of sprintf . configure: error can not run test programs while cross compiling According to the INSTALL file, this problem happens because my cc is not installed properly, or the version of gcc is not the recommended 2.95.2. However, as I've mentioned above, my gcc is of version 2.95.2. How can I solve the problem ? Regards, Lip Hong - 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
Re: amazingly slow
Tim, 1. i'd remove 1 Mb from your 513 Mb machine... maybe it's an very old edo simm or something. 2. you put an index on all requested fields (maintable.recordnumber and wordindex.word) ? I bet not. - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 12:04 PM Subject: amazingly slow 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 = M.RecordNumber AND YL2.Word = 'bob' AND YL2.RecordNumber = M.RecordNumber AND YL3.Word = 'john' AND YL3.RecordNumber = M.RecordNumber AND M.Price = 1000 LIMIT 0,50; wordindex is a table that contains all words present in maintable. For each word there is a link to maintable through RecordNumber. This query searches for all records in maintable that contain the three words and where it's price is more than 1000. This query takes more than 20 seconds! I hear from others that this query should be returned in a flash! maintable contains about 900,000 records. wordindex contains about 21,000,000 records All columns are indexed. Here are my parameters: key_buffer=256M table_cache=256 sort_buffer=1M record_buffer=2M join_buffer=4M max_sort_length=30 max_connections=300 I am really desperate. I've been trying everything. I've tried the OPTIMIZE TABLE commands, but this also doesn't help. Anyone out there who wants to save me and our company? Thanks a lot! Tim - 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
Re: amazingly slow
Dear Dave, Thanks for your reply. (The table actually works with word numbers, as the words are present in a hash table. I explained it the way I did because functionally it is the same. So the actual search is for WordNumber values instead of Word values.) I did the EXPLAIN as you suggested. Here is the output: mysql EXPLAIN SELECT B.* FROM maintable AS B , - wordindex AS YL1 , - wordindex AS YL2 , - wordindex AS YL3 WHERE - YL1.WordNumber = 123 AND - YL1.RecordNumber = B.RecordNumber AND - YL2.WordNumber = 345 AND - YL2.RecordNumber = B.RecordNumber AND - YL3.WordNumber = 678 AND - YL3.RecordNumber = B.RecordNumber AND - B.Price = 1000 - LIMIT 0,51; +-+--+---++---++ +--+ |table|type |possible_keys |key |key_len|ref |rows|Extra | +-+--+---++---++ +--+ |YL3 |ref |WordNumber,RecordNumber|WordNumber | 4 |??? | 1 | | |B|eq_ref|PRIMARY|PRIMARY | 4 |YL3.RecordNumber| 1 |where used| |YL2 |ref |WordNumber,RecordNumber|RecordNumber| 4 |B.RecordNumber | 23 |where used| |YL1 |ref |WordNumber,RecordNumber|RecordNumber| 4 |B.RecordNumber | 23 |where used| +-+--+---++---++ +--+ 4 rows in set (0.01 sec) This still does not tell me why 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://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
RE: Mysql/DBD Error
You need to install DBD mysql DBI, you can download these at cpan (www.cpan.com) or at the mysql website (www.mysql.com) the installation is fairly simple, you need to extract the source to a directory and then do: perl Makefile.pl make make test if the make test succeeds make install you should do this for both. Installing DBD BEFORE DBI is REQUIRED!! after that it should work fine :-) -Oorspronkelijk bericht- Van: Tom Turrisi [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 6 februari 2001 13:38 Aan: [EMAIL PROTECTED] Onderwerp: Mysql/DBD Error Could someone point me in the right direction with this problem please? I ran a perl script and this was the error message $ perl connect.pl install_driver(mysql) failed: Can't load '/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at connect.pl line 5 I read the documentation at http://www.mysql.com/doc/P/e/Perl_support_problems.html but i can not find libmysqlclient.so or libmysqlclient.so.10 anywhere on my system. can i just obtain a copy of these files and put them in place or will have to re compile? if i can obtain a copy of the files then where from? and do i need to make any other changes? Cheers Tom Turrisi - 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
Queries with Time=0 in mysql-slow.log
Description: We have a mysql-slow.log activated. We found many queries with a Time of 0. See here: # Time: 010206 13:54:51 # User@Host: xx[xx] @ xx.mobilcom.de [xx] # Time: 0 Lock_time: 0 Rows_sent: 18 select st_klasse,st_wert from stati group by st_klasse,st_wert order by st_klasse,st_wert; And the Result: cut here mysql select st_klasse,st_wert from stati group by st_klasse,st_wert order by st_klasse,st_wert; +---+--+ | st_klasse | st_wert | +---+--+ | | | | Abbruch | Boni Negativ | | Abbruch | Eingabe abgebrochen | | Abbruch | Storno lt. CallCenter Kiel | | Abbruch | Vertragsverhältnis abgelehnt | | datenaufnahme | abgebrochen | | datenaufnahme | läuft| | Eingabe Storniert | Eingabe abgebrochen | | Storniert | msisdn freigeben | | Surfstation | Eingetragen | | TEST | Beendet | | token | erzeugt | | token | unvollständig! | | workflow | Auftrag erledigt | | workflow | Auftrag genehmigt| | workflow | Auftrag storniert| | workflow | Auftrag wird geprüft | | workflow | Vertragsverhältnis abgelehnt | +---+--+ 18 rows in set (0.01 sec) mysql cut here... Watch the time 0.01 sec ... How-To-Repeat: I think activate mysql-slow.log in startscript or my.cnf. Make a select on a table and watch the mysql-slow.log File. Fix: I dont now. Submitter-Id: submitter ID Originator: Organization: MobilCom Communication GmbH MySQL support: none Synopsis: mysql-slow.log entries with time of zero. Severity: serious Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.32 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.32-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/mysql/mysql.sock Uptime: 1 day 2 hours 9 min 43 sec Threads: 1 Questions: 1141038 Slow queries: 12720 Opens: 5222 Flush tables: 1 Open tables: 512 Queries per second avg: 12.115 Environment: System: Linux wsh-101 2.4.1-pre11 #2 SMP Mon Jan 29 16:00:51 CET 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rwxr-xr-x 1 root root 4071014 Jan 17 19:22 /lib/libc.so.6 -rw-r--r-- 1 root root 19190032 Dez 30 13:22 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Dez 30 13:22 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --localstatedir=/var --with-unix-socket-path=/tmp/mysql.sock --with-mysqld-user=mysql --without-debug --with-extra-charsets=german1,dos Perl: This is perl, version 5.005_03 built for i586-linux - 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: Adding the offset to mysqlbinlog
[EMAIL PROTECTED] writes: Description: Sometimes, when you get a resync error, you need to skip a particular update and restart with the next bit. How-To-Repeat: Insert conflicting records and try to re-sync without deleting one. Fix: Apply this patch. Index: noris.38/sql/mysqlbinlog.cc --- noris.38/sql/mysqlbinlog.cc Wed, 24 Jan 2001 21:35:51 +0100 smurf (database_mysql/N/b/20_mysqlbinlo 1.12 664) +++ noris.39/sql/mysqlbinlog.cc Mon, 05 Feb 2001 22:00:12 +0100 smurf (database_mysql/N/b/20_mysqlbinlo 1.13 664) @@ -355,18 +355,25 @@ while(1) { char llbuff[21]; +my_off_t old_off = my_b_tell(file); + Log_event* ev = Log_event::read_log_event(file, 0); if (!ev) { if (file-error) die("\ Could not read entry at offset %s : Error in log format or read error", -llstr(my_b_tell(file),llbuff)); +llstr(old_off,llbuff)); // file-error == 0 means EOF, that's OK, we break in this case break; } if (rec_count = offset) +{ + if (!short_form) +printf("# at %s\n",llstr(old_off,llbuff)); + ev-print(stdout, short_form); +} rec_count++; delete ev; } Submitter-Id: submitter ID Originator: Matthias Urlichs Organization: MySQL support: licence Synopsis: mysqlbinlog doesn't print the offset Severity: non-critical Priority: medium Category: mysql Class: change-request Release:mysql-3.23.32 (noris network MySQL) Environment: System: Linux play.smurf.noris.de 2.4.0s-noris-t5-2 #58 SMP Wed Jul 19 10:24:19 CEST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.3/specs gcc version 2.95.3 19991030 (prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='-DTHREAD_SAFE_CLIENT -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jun 8 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4118299 Sep 20 1999 /lib/libc-2.1.2.so -rwxr-xr-x 1 root root 4123003 Jun 8 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 19203634 Jun 8 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jun 8 2000 /usr/lib/libc.so -rwxr-xr-x 1 root root 2042654 Oct 27 17:09 /usr/lib/libc-client.a Configure command: ./configure --prefix=/usr --with-debug --enable-shared --without-mit-threads --libexecdir=/usr/sbin --localstatedir=/var/mysql --enable-thread-safe-client --sysconfdir=/etc --datadir=/usr/share --enable-large-files --without-readline --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysql.socket --enable-strcoll '--with-comment=noris network MySQL' --with-docs --with-bench --without-berkeley-db --without-bench Hi! Thank you for your contribution. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
Error creating tables
Can anyone help? In this script is one bug but i can't find it :( create table top( Id int(11) DEFAULT '0' NOT NULL auto_increment, nadalnumeric, kuupaev DATE, usa1 text, usa2 text, usa3 text, usa4 text, usa5 text, usa6 text, usa7 text, usa8 text, usa9 text, usa10text, eesti1 text, eesti2 text, eesti3 text, eesti4 text, eesti5 text, tekstlongtext, PRIMARY KEY (id) ); - 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
cant connect to local mysql server
hi..could someone pls help me i had created mysql server before in my pc but this morning i discovered that i cant access my mysql server.this is what i typed: shell mysql this is what i got: ERROR 2002:Can't connect to local MySQL Server through socket '/tmp/mysql.sock'(111) what is it trying to say??? by the way, i wasn't logged on to the internet at that moment. Is that the reason why it fails to connect _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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
INDEX() / UNIQUE()
Is there any idea in using both a INDEX() and UNIQUE() index on the same table field ? - 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
Multiple defs of strtol.o (was RE: Mysql/DBD Error)
Please help me I'm going nuts... I installed mysql with the DBD adn everything on two machines running PB. One one (my home computer), everything is fine, on the other one (the server in my office), when I try to run something based on the DBD (such as the bench), I get: /System/Library/Frameworks/System.framework/Versions/B/System(strtol.o) definition of _strtol /Local/Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of _strtol PLEEEAAASE help me!!! Greg - 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
INSERT INTO 2 JOINED TABLES
As an example to my problem, I have 2 tables, T1 and T2. T1's fields are Common,T1Field1,T1Field2 (Common is the primary key and it is autoincrement) T2's fields are T2Field1,Common,T2Field2 (T2Field1 is the primary key) I created a view using "SELECT T1.T1Field1,T1.T1Field2,T2.T2Field1,T2.T2Field2 FROM T1 T2 WHERE T1.Common = T2.Common)". How do I create the INSERT SQL in this case? The Field "Common" is not yet filled, because it is autoincremented. So I cannot insert into table T2. Anyone can help me? Thank you. __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ - 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: amazingly slow
Dear Dave, Here is the output from vmstat 5: vmstat 5 procs memoryswap io system cpu r b w swpd free buff cache si sobibo incs us sy id 0 0 0 3936 2980 10568 218856 8 411 33 9 0 3 10 0 0 0 3936 3096 10580 218728 0 0 0 1 11130 0 1 99 0 0 0 3936 3092 10584 218728 0 0 0 1 10926 1 1 98 2 0 0 3936 1676 10564 220012 0 0 287 1 212 137 1 2 97 2 0 0 3936 2628 10480 219084 0 0 646 2 235 130 4 3 93 1 0 0 3936 1652 10488 219428 22 0 727 5 456 522 2 2 96 0 1 0 3936 1708 10480 218776 0 0 1042 4 438 433 0 2 97 1 0 0 3936 2724 10484 218216 28 0 1028 0 488 557 0 3 97 1 0 0 3936 3080 10484 217860 0 0 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 PROTECTED] writes: This still does not tell me why the query is amazingly slow. What else is happening on the system? what does, say, a vmstat 5 give? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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
Re: Mysql DBD Error
Hi Tom, I see from your error message that you have already installed DBI yes? Your problem is you need to add the mysql library to your ldconfig (Dynamic library list). I don't know what platform you are one, for my plaforms I edit /etc/ld.so.conf and add the line /usr/local/lib/mysql the run "ldconfig" check the man page for ldconfig. Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Tom Turrisi" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 7:51 AM Subject: Mysql DBD Error Could someone point me in the right direction with this problem please? I ran a perl script and this was the error message $ perl connect.pl install_driver(mysql) failed: Can't load '/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/mysql/mysq l.so' for module DBD::mysql: Shared object "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at connect.pl line 5 I read the documentation at http://www.mysql.com/doc/P/e/Perl_support_problems.html but i can not find libmysqlclient.so or libmysqlclient.so.10 anywhere on my system. can i just obtain a copy of these files and put them in place or will have to re compile? if i can obtain a copy of the files then where from? and do i need to make any other changes? Cheers Tom Turrisi - 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: amazingly slow
i've heard it said that every so often (eg every month) you need to rebuild indexes on tables, as over time they lose 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 numbers, as the words are present in a hash table. I explained it the way I did because functionally it is the same. So the actual search is for WordNumber values instead of Word values.) I did the EXPLAIN as you suggested. Here is the output: mysql EXPLAIN SELECT B.* FROM maintable AS B , - wordindex AS YL1 , - wordindex AS YL2 , - wordindex AS YL3 WHERE - YL1.WordNumber = 123 AND - YL1.RecordNumber = B.RecordNumber AND - YL2.WordNumber = 345 AND - YL2.RecordNumber = B.RecordNumber AND - YL3.WordNumber = 678 AND - YL3.RecordNumber = B.RecordNumber AND - B.Price = 1000 - LIMIT 0,51; +-+--+---++---++ +--+ |table|type |possible_keys |key |key_len|ref |rows|Extra | +-+--+---++---++ +--+ |YL3 |ref |WordNumber,RecordNumber|WordNumber | 4 |??? | 1 | | |B|eq_ref|PRIMARY|PRIMARY | 4 |YL3.RecordNumber| 1 |where used| |YL2 |ref |WordNumber,RecordNumber|RecordNumber| 4 |B.RecordNumber | 23 |where used| |YL1 |ref |WordNumber,RecordNumber|RecordNumber| 4 |B.RecordNumber | 23 |where used| +-+--+---++---++ +--+ 4 rows in set (0.01 sec) This still does not tell me why 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://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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 - 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
How many tables in a database?
How do you decide when a table should go into another database. For example, I have a database with about 12 tables and growing. I keep them in one database because I am doing joins that periodically involve all of the tables. Is this the right way to do it? Richard - 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
MySQL driver for DELPHI ?
I am a DELPHI developer and I need to know if exists a MySQL driver for DELPHI. Does MySQL have a driver for DELPHI??? If it does, please send me it... My e-mails: [EMAIL PROTECTED] [EMAIL PROTECTED] ... at least I´d like to know if it does or it doesn´t and where I can find it. __ Acesso fácil, rápido e ilimitado? Suporte 24hs? R$19,90? Só no AcessoBOL. http://www.bol.com.br/acessobol/ - 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: Multiple defs of strtol.o (was RE: Mysql/DBD Error)
Sorry I really wouldn't know this one :-) You might consider asking the question also on one of the website where the perlfreaks are. www.cpan.com or www.perlmonks.com. Personally I'd try installing the latest version of perl DBD DBI mysql, however I don't know the strtol.o file and it might be just a c library or something else in which case reinstalling won't do squad. Sorry I can't help ya. Kind regards, Ferry van Steen On Tue, 6 Feb 2001, Greg wrote: Please help me I'm going nuts... I installed mysql with the DBD adn everything on two machines running PB. One one (my home computer), everything is fine, on the other one (the server in my office), when I try to run something based on the DBD (such as the bench), I get: /System/Library/Frameworks/System.framework/Versions/B/System(strtol.o) definition of _strtol /Local/Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of _strtol PLEEEAAASE help me!!! Greg - 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
Problem with MySQL's installation
Hello, I'm trying to install MySQL without success. I have installed MySQl with the RPMs (server+client), everything works well, I do "mysql_install_db" and I launch the daemon "safe_mysql ". But when i tried to shutdown it, I've got an error whitch is : mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'roo@localhost' (using password: NO) What's wrong ? Thanks, Thomas - 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: Error creating tables
in manual: - DECIMAL[(M[,D])] [ZEROFILL] An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column: ``unpacked'' means the number is stored as a string, using one character for each digit of the value. The decimal point and, for negative numbers, the `-' sign, are not counted in M (but space for these are reserved). If D is 0, values will have no decimal point or fractional part. The maximum range of DECIMAL values is the same as for DOUBLE, but the actual range for a given DECIMAL column may be constrained by the choice of M and D. If D is left out it's set to 0. If M is left out it's set to 10. Note that in MySQL Version 3.22 the M argument had to includes the space needed for the sign and the decimal point. NUMERIC(M,D) [ZEROFILL] This is a synonym for DECIMAL. --- I suppose that M and D is not optional parameters for NUMERIC type. - Original Message - From: Esko Lehtme [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 4:36 PM Subject: Error creating tables Can anyone help? In this script is one bug but i can't find it :( create table top( Id int(11) DEFAULT '0' NOT NULL auto_increment, nadalnumeric, kuupaev DATE, usa1 text, usa2 text, usa3 text, usa4 text, usa5 text, usa6 text, usa7 text, usa8 text, usa9 text, usa10text, eesti1 text, eesti2 text, eesti3 text, eesti4 text, eesti5 text, tekstlongtext, PRIMARY KEY (id) ); - 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
Re: amazingly slow
Ren, Ok, here is a real representation of the tables involved: mysql EXPLAIN maintable; +---+-+--+-++--- -+ | Field | Type| Null | Key | Default| Extra | +---+-+--+-++--- -+ | RecordNumber | int(11) | | PRI | 0 | auto_increment | | Author| varchar(60) | | MUL || | | Titel | varchar(175)| | MUL || | | Description | varchar(100)| | || | | DescripRest | text| | | NULL | | | Price | bigint(20) unsigned | | MUL | 0 | | +---+-+--+-++--- -+ 20 rows in set (0.00 sec) mysql EXPLAIN hashindex; ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | WordNumber | int(11) | | PRI | 0 | auto_increment | | xWord | char(10) | | MUL | || ++--+--+-+-++ 2 rows in set (0.00 sec) mysql EXPLAIN wordindex; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | WordNumber | int(11) | | MUL | 0 | | | BookNumber | int(11) | | MUL | 0 | | ++-+--+-+-+---+ 2 rows in set (0.00 sec) So you see, the fields that are used in the query are indexed. And the queries still take more than 10 seconds each! Tim At 03:35 PM 6-2-2001 +0100, you wrote: Tim, Hmmm... so you are suggesting the format of the query might be the cause of this slow response. I find it hard to believe, unless you have a very big result set i believe the query should 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: amazingly slow Yep, all requested fields are indexed. At 02:25 PM 6-2-2001 +0100, you wrote: Tim, Just kidding about the 513 Mb you put an index on wordindex.word as well ? (it's not in the table description but you use it in your query...Not indexing this field means mysql searches whole table for values.. Then your P800 has a reasonable performance on such a big table :)) ) regards, rene - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: "Ren Tegel" [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 1:58 PM Subject: Re: amazingly slow Dear Ren, Thanks for your reply. Oops, the 513 was a typing mistake. And yes, all the requested fields are indexed. CREATE TABLE wordindex ( WordNumber int(11) NOT NULL, RecordNumber int(11) NOT NULL, KEY WordNumber (WordNumber), KEY RecordNumber (RecordNumber) ); CREATE TABLE books ( RecordNumber int(11) NOT NULL auto_increment, Field1 varchar(60) NOT NULL, Field2 varchar(60) NOT NULL, Field3 varchar(60) NOT NULL, Field4 varchar(60) NOT NULL, Field5 varchar(60) NOT NULL, Price bigint(20) unsigned NOT NULL, PRIMARY KEY (RecordNumber), KEY Price (Price) ); Any suggestions are very welcome. Tim At 01:51 PM 6-2-2001 +0100, you wrote: Tim, 1. i'd remove 1 Mb from your 513 Mb machine... maybe it's an very old edo simm or something. 2. you put an index on all requested fields (maintable.recordnumber and wordindex.word) ? I bet not. - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 12:04 PM Subject: amazingly slow 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 = M.RecordNumber AND YL2.Word = 'bob' AND YL2.RecordNumber = M.RecordNumber AND YL3.Word = 'john' AND YL3.RecordNumber = M.RecordNumber AND M.Price = 1000 LIMIT 0,50; wordindex is a table that contains all words present in maintable. For each word there is a link to maintable through RecordNumber. This query searches for all records in maintable that contain the three words and where it's price is more than 1000. This query takes more than 20 seconds! I hear from others that this query should be returned in a flash! maintable contains about 900,000 records. wordindex contains about 21,000,000 records All columns are indexed. Here are my parameters:
running mysql
Hi, I am a new user of Linux and mysql and i have installed suse7.0 on my pc to start working on mysql. (my pc is not connected to network). I had some problems running mysql because (i think) MySQL server was not running. I read some part of the manual and after running safe-mysqld i could start using mysql. After this i was enable to use database test and mysql but i am not allowed to create a new database. - There is another (and better) way to star the MySQL server? - How to change permissions to make possible to create new databases. I expect that someone could help me in this begginner doubts... Angelo Estrela [EMAIL PROTECTED] Gaia - Portugal - 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: amazingly slow
Dear Dan, Thanks for your reply. I've already done OPTIMIZE for all tables. I suppose that's the same as rebuilding the indices. Tim At 01:26 AM 7-2-2001 -0800, you wrote: i've heard it said that every so often (eg every month) you need to rebuild indexes on tables, as over time they lose 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 numbers, as the words are present in a hash table. I explained it the way I did because functionally it is the same. So the actual search is for WordNumber values instead of Word values.) I did the EXPLAIN as you suggested. Here is the output: mysql EXPLAIN SELECT B.* FROM maintable AS B , - wordindex AS YL1 , - wordindex AS YL2 , - wordindex AS YL3 WHERE - YL1.WordNumber = 123 AND - YL1.RecordNumber = B.RecordNumber AND - YL2.WordNumber = 345 AND - YL2.RecordNumber = B.RecordNumber AND - YL3.WordNumber = 678 AND - YL3.RecordNumber = B.RecordNumber AND - B.Price = 1000 - LIMIT 0,51; +-+--+---++---++ +--+ |table|type |possible_keys |key |key_len|ref |rows|Extra | +-+--+---++---++ +--+ |YL3 |ref |WordNumber,RecordNumber|WordNumber | 4 |??? | 1 | | |B|eq_ref|PRIMARY|PRIMARY | 4 |YL3.RecordNumber| 1 |where used| |YL2 |ref |WordNumber,RecordNumber|RecordNumber| 4 |B.RecordNumber | 23 |where used| |YL1 |ref |WordNumber,RecordNumber|RecordNumber| 4 |B.RecordNumber | 23 |where used| +-+--+---++---++ +--+ 4 rows in set (0.01 sec) This still does not tell me why 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://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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 - 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
Re: Simple question
On my linux distribution of Suse 7.0 kmysql was installed as part of the kde window manager. If you do a web search for kymsql you can find it there also. Joel Holtzman wrote: Thanks. WHere do I find this? Are the instructions in english? It's frustrating getting spanish/german sites since I can't understand what to do. It would be nice to be able to work via gui. But will I get permission errors if I don't use 'grant'? I have other gui's that give the same error. I download them to my windows 98 pc, and when I connect to the server, it won't let me in. Do you think I should do that first? Thanks for your time Joel - Original Message - From: kentj [EMAIL PROTECTED] To: Joel Holtzman [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 05, 2001 3:24 PM Subject: Re: Simple question A gui that works on the linux box is kmysql. Joel Holtzman wrote: Hello, I always wanted a gui interface to use on my win 98 pc to connect to mysql, and create/edit tables. However, i always get an access denied error, saying I'm not allowed to connect to the mysql server. However, via telnet, I am fine. The support for the software sucks, and all the other programs I have tried suck, don't work, or are in german. What gui interface is good to connect to a mysql server to create/edit db's/tables, and if you use it, how in the world do you connect? I can connect to the server via telnet. Just fine. But via the software, I get permission denied. Any way I can set it up on my server to allow such a connection out of telnet? Thanks Joel - 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: MySQL Memory Requirements...
What it looks like i'm going for is the following setup 30gb eide hdd celeron 700Mhz processor 256MB RAM red hat linux mysql apache/tomcat I'm a bit worried because the database is on the same server as the website. Will the machine fall over because it doesn't have enough ram/CPU power (for about 20k users per week as below)? any ball park comments eg no worries, close call, not a chance? thx dan -Original Message- From: Daniel Kirk [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 6 February 2001 09:38 To: [EMAIL PROTECTED] Subject: MySQL Memory Requirements... Can someone please give me a rough estimate of how much RAM MySQL would require to run something like : A connection pool of around 50 connections 20,000 users every week re-using these 50 connections around 50 inserts per user (each row around 30 bytes) around 20 queries per user Installation on Linux is it possible to estimate RAM required for that information - is there anything else I could provide? thanks for your help Dan -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Monday, 5 February 2001 07:55 To: Vangipuram, Anand; [EMAIL PROTECTED] Subject: Re: System Requirements... It will run on most computers of today. Question is what system have you got/want, what are you going to use it for and what is the expected volume of information? - Original Message - From: "Vangipuram, Anand" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 0:31 Subject: System Requirements... What are the system requirements for installing mysql? Anand Vangipuram 414-566-6701 This message has been scanned for viruses with Trend Micro's Interscan VirusWall. - 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 - 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
Re: Re[2]: Serious MySQL internal deadlock
Hi, well, the query is over a network. Single switch with two VLANs between the systems, network speed is *200MBit/s*. The php code structure executing was: ... prepare query ... mysql_connect(); mysql_query(); mysql_fetch_row(); mysql_close(); ... process and send data to browser ... The table the query executed on did have a total of about 25000 rows at that time. The query executing had to return exacty one row (max()). When the query thread did terminate all threads waiting for inserts did keep *hanging* either in state 'System lock' or state 'Opening table'. Thus: The whole database was *deadlocked* with only insert queries pending after a a data retrieval query thread did execute. In this state a regular shutdown of the database is *not* possible, you have to send SIGTERM to shut down mysql. Oh, the same thing did happen *again* today. The behaviour looks like in some cases mysql doesn't unlock after a data retrieval query or that pending inserts don't get properly restarted. As a hint the inserting daemons keep continously connected to mysql as long as the database is up, there are automatic reconnect attempts in case the database is not available. To finally assert that replication isn't involved I'm running this now with the slaves stopped. If it happens again I will try to set up code that is able to reproduce the problem on a test system (single database without replication there). On 06-Feb-2001 Sinisa Milivojevic wrote: Hi! First of all, please do not send us entire schema and your PHP scripts, as they make sense on your site only. Second, the above processlist does not show any deadlock. There is a query that is sending data, on which INSERT and UPDATE queries are waiting for. Judging by the above output I would also recommend you to increase table_cache and speed up connections if possible. If the above "Sending data" is done over network, you could turn compression on or make faster network. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team Andreas Steinmetz D.O.M. Datenverarbeitung GmbH - 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: Multiple AND on many-many-table.
Bob Hall wrote: I want to do a select like select id from test where id in (select id from test where value in (1,2,3) and id in (select id from test where value in (4,6,7) and id in (select id from test where value in (1,6,25) Even if MySQL supported subqueries, this query would always return the empty set. I'm really unsure about what you're trying to do, but I think the following comes close. SELECT id FROM test WHERE value IN (1, 2, 3, 4, 6, 7, 25); No the query I wrote would return the intersection of three lists of user ids where each list contained any users that had the values listed. Your query would return all user ID's who had any of the number listed which is not what I need... but thanks... - 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
DEfault passwords
Greetings. I just installed mySQL( mysql-3.23.29a-gamma-sun-solaris2.8-sparc) on a E150 using the script mySQL/configure.. One of the msg that was printed was to change the root password. however to change the root password you need to know the original password(s). What are the default password...? and can someone send me an example on changing the password...? thanks donnie - 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
binary bug in mysql 3.23.30-gamma
In the process of converting over to 3.23.30-gamma from 3.22 It appears that a table with field 'key varchar(16) binary' as a primary key. Whenever I write a record to this table and then do a select the value of the field seems to be zero. I do a 'select * from table where key=0x0' I get all the records that have ever been inserted. Anyone have any suggestions. - 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: MySQL driver for DELPHI ?
Paulo Serra wrote: I am a DELPHI developer and I need to know if exists a MySQL driver for DELPHI. Does MySQL have a driver for DELPHI??? If it does, please send me it... MySQL doesn't have a BDE driver. Actually, I don't know of many vendors doing that for windows applications... Ah, voc brasileiro. De qualquer maneira, voc pode usar MyODBC e usar o driver OBDC do Delphi. -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - 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[2]: Serious MySQL internal deadlock
Andreas Steinmetz writes: Hi, well, the query is over a network. Single switch with two VLANs between the systems, network speed is *200MBit/s*. The php code structure executing was: ... prepare query ... mysql_connect(); mysql_query(); mysql_fetch_row(); mysql_close(); ... process and send data to browser ... The table the query executed on did have a total of about 25000 rows at that time. The query executing had to return exacty one row (max()). When the query thread did terminate all threads waiting for inserts did keep *hanging* either in state 'System lock' or state 'Opening table'. Thus: The whole database was *deadlocked* with only insert queries pending after a a data retrieval query thread did execute. In this state a regular shutdown of the database is *not* possible, you have to send SIGTERM to shut down mysql. Oh, the same thing did happen *again* today. The behaviour looks like in some cases mysql doesn't unlock after a data retrieval query or that pending inserts don't get properly restarted. As a hint the inserting daemons keep continously connected to mysql as long as the database is up, there are automatic reconnect attempts in case the database is not available. To finally assert that replication isn't involved I'm running this now with the slaves stopped. If it happens again I will try to set up code that is able to reproduce the problem on a test system (single database without replication there). HI! Did INSERT queries changed their state after SELECT has finished sending data ?? What OS is that and is there anything in the error log file that might indicate some problems ?? If you are using Linux, there could be some problems with fast Ethernet cards in duplex mode. If that is a case, please try disabling duplexing (on hubs and switches). Also enable compression. And yes, we would be very much interested in repeatable test case. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: MySQL driver for DELPHI ?
It took me all of about 2 seconds to locate this; http://www.fichtner.net/delphi/mysql.delphi.phtml try hotbot it works great :p Paulo Serra wrote: I am a DELPHI developer and I need to know if exists a MySQL driver for DELPHI. Does MySQL have a driver for DELPHI??? If it does, please send me it... My e-mails: [EMAIL PROTECTED] [EMAIL PROTECTED] ... at least Id like to know if it does or it doesnt and where I can find it. __ Acesso fcil, rpido e ilimitado? Suporte 24hs? R$19,90? S no AcessoBOL. http://www.bol.com.br/acessobol/ - 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
NOTICE
HI PEOPLE: WHAT CAN I DO TO NOTE WHEN A NEW REGISTER IS INSERTED INTO A TABLE. THANKS , SEE YOU LATER. = there are too many more mindS to free __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ - 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: amazingly slow
Try this SELECT * FROM maintable AS M, wordindex AS YL WHERE YL.Word IN ('billy' , 'bob' , 'john' ) AND YL3.RecordNumber = M.RecordNumber AND M.Price = 1000 LIMIT 0,50; Your query is probably slow because you are cubing the size of the wordindex by invoking it three times -Original Message- From: Ren Tegel [SMTP:[EMAIL PROTECTED]] Sent: 06 February 2001 14:35 To: Tim Samshuijzen; [EMAIL PROTECTED] Subject: Re: amazingly slow Tim, Hmmm... so you are suggesting the format of the query might be the cause of this slow response. I find it hard to believe, unless you have a very big result set i believe the query should 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: amazingly slow Yep, all requested fields are indexed. At 02:25 PM 6-2-2001 +0100, you wrote: Tim, Just kidding about the 513 Mb you put an index on wordindex.word as well ? (it's not in the table description but you use it in your query...Not indexing this field means mysql searches whole table for values.. Then your P800 has a reasonable performance on such a big table :)) ) regards, rene - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: "Ren Tegel" [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 1:58 PM Subject: Re: amazingly slow Dear Ren, Thanks for your reply. Oops, the 513 was a typing mistake. And yes, all the requested fields are indexed. CREATE TABLE wordindex ( WordNumber int(11) NOT NULL, RecordNumber int(11) NOT NULL, KEY WordNumber (WordNumber), KEY RecordNumber (RecordNumber) ); CREATE TABLE books ( RecordNumber int(11) NOT NULL auto_increment, Field1 varchar(60) NOT NULL, Field2 varchar(60) NOT NULL, Field3 varchar(60) NOT NULL, Field4 varchar(60) NOT NULL, Field5 varchar(60) NOT NULL, Price bigint(20) unsigned NOT NULL, PRIMARY KEY (RecordNumber), KEY Price (Price) ); Any suggestions are very welcome. Tim At 01:51 PM 6-2-2001 +0100, you wrote: Tim, 1. i'd remove 1 Mb from your 513 Mb machine... maybe it's an very old edo simm or something. 2. you put an index on all requested fields (maintable.recordnumber and wordindex.word) ? I bet not. - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 12:04 PM Subject: amazingly slow 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 = M.RecordNumber AND YL2.Word = 'bob' AND YL2.RecordNumber = M.RecordNumber AND YL3.Word = 'john' AND YL3.RecordNumber = M.RecordNumber AND M.Price = 1000 LIMIT 0,50; wordindex is a table that contains all words present in maintable. For each word there is a link to maintable through RecordNumber. This query searches for all records in maintable that contain the three words and where it's price is more than 1000. This query takes more than 20 seconds! I hear from others that this query should be returned in a flash! maintable contains about 900,000 records. wordindex contains about 21,000,000 records All columns are indexed. Here are my parameters: key_buffer=256M table_cache=256 sort_buffer=1M record_buffer=2M join_buffer=4M max_sort_length=30 max_connections=300 I am really desperate. I've been trying everything. I've tried the OPTIMIZE TABLE commands, but this also doesn't help. Anyone out there who wants to save me and our company? Thanks a lot! Tim - 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual)
Max number of Joins
How many times can I join tables together? What about joining a table to itself? I checked the maillist archive/manual but cannot find a definite answer (searched on "max number of joins", "joins")...I'd though it would be in section 7.20 of the manual but it wasn't. Thanks. Bill - 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: MySQL Memory Requirements...
---Reply to mail from Daniel Kirk about MySQL Memory Requirements... What it looks like i'm going for is the following setup 30gb eide hdd celeron 700Mhz processor 256MB RAM red hat linux mysql apache/tomcat I'm a bit worried because the database is on the same server as the website. Will the machine fall over because it doesn't have enough ram/CPU power (for about 20k users per week as below)? any ball park comments eg no worries, close call, not a chance? I will be more worried about that EIDE 30Gb disk than about the rest. I would invest a little more money in a SCSI system. The diference in performance will be enormous, specially with many processes using the disk at the same time. Sincerely Rafael Martinez - 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: Port 3306
On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote: Date: Mon, 5 Feb 2001 13:11:51 -0800 From: [EMAIL PROTECTED] To: Gus Constan [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Port 3306 Add --skip-networking to your my.cnf file or pass it on the command line to safe_mysqld. This will stop ALL TCP connections to mySQL, so you'll have to use the server name "localhost" in your connection strings to force use of the unix socket. If your installation requires MIT-threads, this is not an option. Is there a speed advantage to unix socket vs. TCP/IP (I think the answer is yes, but have been wrong before). Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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[2]: Serious MySQL internal deadlock
Hi, the inserts did not change the state after the select finished. The network is running full duplex but the only problem I ever encountered with the cards was initalization on fast systems. I fixed this and posted it to the linux kernel mailing list (search for epic100). If the problem continues to appear with the slaves stopped I'll try to code a reproducable test case. The only thing that's visible is the following entry in the slow query log which matches the process list attached to my earlier mail. The funny thing is that this query will result in exactly one row and according to the log the this row was sent. The query time, however, of 277 seconds for a somewhat simple query makes me wonder... # Time: 010205 23:13:00 # User@Host: logreader[logreader] @ [10.1.1.4] # Time: 277 Lock_time: 0 Rows_sent: 1 use syslog; select max(swap_used+swap_free) from pcp where host='castor' and time='2001020423' and time'20010205231000'; On 06-Feb-2001 Sinisa Milivojevic wrote: Andreas Steinmetz writes: Hi, well, the query is over a network. Single switch with two VLANs between the systems, network speed is *200MBit/s*. The php code structure executing was: ... prepare query ... mysql_connect(); mysql_query(); mysql_fetch_row(); mysql_close(); ... process and send data to browser ... The table the query executed on did have a total of about 25000 rows at that time. The query executing had to return exacty one row (max()). When the query thread did terminate all threads waiting for inserts did keep *hanging* either in state 'System lock' or state 'Opening table'. Thus: The whole database was *deadlocked* with only insert queries pending after a a data retrieval query thread did execute. In this state a regular shutdown of the database is *not* possible, you have to send SIGTERM to shut down mysql. Oh, the same thing did happen *again* today. The behaviour looks like in some cases mysql doesn't unlock after a data retrieval query or that pending inserts don't get properly restarted. As a hint the inserting daemons keep continously connected to mysql as long as the database is up, there are automatic reconnect attempts in case the database is not available. To finally assert that replication isn't involved I'm running this now with the slaves stopped. If it happens again I will try to set up code that is able to reproduce the problem on a test system (single database without replication there). HI! Did INSERT queries changed their state after SELECT has finished sending data ?? What OS is that and is there anything in the error log file that might indicate some problems ?? If you are using Linux, there could be some problems with fast Ethernet cards in duplex mode. If that is a case, please try disabling duplexing (on hubs and switches). Also enable compression. And yes, we would be very much interested in repeatable test case. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team Andreas Steinmetz D.O.M. Datenverarbeitung GmbH - 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
Select a range from 0-9 or A-z
hi: Here is my SQL statement to select a range of number from 0-9 Is there a short cut to this? id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%' thank you seng - 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
Boolean Datatype
Im new to the list, apologies if this has been asked before. Im developing a backend for a personal site (www.russd.com) using mySQL. The site is hosted on NT4 and has myODBC installed, I have some database access working, but I'm looking for a way to implement boolean types. Using Access/SQL server I can simple do an insert using SQL like the following (from within ASP): INSERT INTO tblMyTable (booleanField) VALUES (" myBooleanVariant ");" Unfortunately, mySQL doesn't appear to have a boolean datatype and myODBC doesn't seem to convert True/False to 1/0. The best solution I have so far is to use a TINYINT and change the True/False values within my ASP code to 1/0. This isn't perfect howevere as its more code, more work for the server and far less readable. I also have to cast to boolean when I SELECT data from the mySQL database. Could anyone suggest a better way of implementing this, or am I missing something? I have done a Google search and searched the mySQL manual, but got nothing. Many thanks in advance of your efforts. Russ Davies - 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: Problem with MySQL's installation
Maybe you need to add the -p option so that it asks you for your password before you can shutdown - 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 and SQL_BIT type
woops, my fault :) I'll subscribe to the MyODBC list and see what I can find there, thanks :) - Original Message - From: "Sinisa Milivojevic" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 4:03 AM Subject: Re: MyODBC and SQL_BIT type Eric Fitzgerald writes: Let's try this one more time, just in case it got scimmed over :) Hello everyone. I'm hoping the developer of MyODBC hangs out on this list, but here goes. I browsed through the sources a bit, and I noticed several places where you are mapping SQL_BIT type to TinyINT. It appears this is only a one way mapping (software-odbc-mysql) and not the other way. What I would like is 1 of 2 things, either 1) A possible update to MyODBC where an option can be checked (similiar to large results etc..) that allows TinyINT columns to be "converted" to SQL_BIT when sent to the software or 2) Pointers on where in the sources the "translation" is done when coming from mysql. Reason I need these is I'm under the gun to "fully" integrate Visual FoxPro with MySQL (one data source, that whole thing) and the current Visual FoxPro tables use a LOT of bool fields. So if I can do a little translation on the fly, I can fake this, and make everyone happy :) Thanks in advance, Eric Fitzgerald Server Administrator AMN Television Marketing Hi! We have both myodbc and win32 mailing lists which are more appropriate for the above questions. If I knew the answer, I would have told you, but I don't .. ;-( Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
mysqld causes memory fault and restart on openbsd 2.8
Description: I have a perl script which gathers data and then performs multiple inserts into a mysql database via DBI and DBD::mysql. On a OBSD 2.7 box runing the same version of mysql, the script works just fine. However, when i run the exact script on the OBSD 2.8 box, mysqld periodically (randomly) restarts with the error message "memory fault" in the /var/mysql/server.err log. Any help would be greatly appreciated. Please repond to [EMAIL PROTECTED] Thank you, Don How-To-Repeat: Fails during multiple inserts or selects -- no clear failure point. Fix: If I run the updates in short bursts, and give mysql a chance to "cool off" then it seems to work -- but this does not solve my problem. Submitter-Id: Submitter-ID Organization: Don Carnage MySQL support: none Synopsis: mysqld memory faults on OBSD 2.8 Severity: non-critical Priority: low Category: mysql Class: support Release: mysql-3.22.32 (Source distribution) Environment: System: OpenBSD raptor 2.8 GENERIC#399 i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-unknown-openbsd2.8/2.95.3/specs gcc version 2.95.3 19991030 (prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes - 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: Port 3306
Unix sockets are about 30% faster than TCP connections on the local machine -- at least according to TCX's tests and some of my own. "William R. Mussatto" [EMAIL PROTECTED] wrote: On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote: Date: Mon, 5 Feb 2001 13:11:51 -0800 From: [EMAIL PROTECTED] To: Gus Constan [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Port 3306 Add --skip-networking to your my.cnf file or pass it on the command line to safe_mysqld. This will stop ALL TCP connections to mySQL, so you'll have to use the server name "localhost" in your connection strings to force use of the unix socket. If your installation requires MIT-threads, this is not an option. Is there a speed advantage to unix socket vs. TCP/IP (I think the answer is yes, but have been wrong before). Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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
Adding the offset to mysqlbinlog
Description: Sometimes, when you get a resync error, you need to skip a particular update and restart with the next bit. How-To-Repeat: Insert conflicting records and try to re-sync without deleting one. Fix: Apply this patch. Index: noris.38/sql/mysqlbinlog.cc --- noris.38/sql/mysqlbinlog.cc Wed, 24 Jan 2001 21:35:51 +0100 smurf (database_mysql/N/b/20_mysqlbinlo 1.12 664) +++ noris.39/sql/mysqlbinlog.cc Mon, 05 Feb 2001 22:00:12 +0100 smurf +(database_mysql/N/b/20_mysqlbinlo 1.13 664) @@ -355,18 +355,25 @@ while(1) { char llbuff[21]; +my_off_t old_off = my_b_tell(file); + Log_event* ev = Log_event::read_log_event(file, 0); if (!ev) { if (file-error) die("\ Could not read entry at offset %s : Error in log format or read error", - llstr(my_b_tell(file),llbuff)); + llstr(old_off,llbuff)); // file-error == 0 means EOF, that's OK, we break in this case break; } if (rec_count = offset) +{ + if (!short_form) +printf("# at %s\n",llstr(old_off,llbuff)); + ev-print(stdout, short_form); +} rec_count++; delete ev; } Applied. Thanks! Regards, Monty - 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: Select a range from 0-9 or A-z
-Original Message- From: Ung, Seng Sent: Tuesday, February 06, 2001 9:03 AM To: [EMAIL PROTECTED] Subject: Select a range from 0-9 or A-z hi: Here is my SQL statement to select a range of number from 0-9 Is there a short cut to this? id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%' thank you seng - 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 me !
Redhat comes with mysql already installed as a RPM usually. I had the same problem until I unstalled the RPM that came with Red Hat. A fix for this problem if you don't want to uninstall the original can be found at:http://www.mysql.com/doc/I/n/Installing_many_servers.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: Error creating tables
I copied and pasted your create table query into mysql and it created the table without a problem. I'm using 3.32.32. mysql describe top - ; +-+---+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-++ | Id | int(11) | | PRI | NULL| auto_increment | | nadal | decimal(10,0) | YES | | NULL|| | kuupaev | date | YES | | NULL|| | usa1| text | YES | | NULL|| | usa2| text | YES | | NULL|| | usa3| text | YES | | NULL|| | usa4| text | YES | | NULL|| | usa5| text | YES | | NULL|| | usa6| text | YES | | NULL|| | usa7| text | YES | | NULL|| | usa8| text | YES | | NULL|| | usa9| text | YES | | NULL|| | usa10 | text | YES | | NULL|| | eesti1 | text | YES | | NULL|| | eesti2 | text | YES | | NULL|| | eesti3 | text | YES | | NULL|| | eesti4 | text | YES | | NULL|| | eesti5 | text | YES | | NULL|| | tekst | longtext | YES | | NULL|| +-+---+--+-+-++ 19 rows in set (0.04 sec) -Original Message- From: Esko Lehtme [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 8:36 AM To: [EMAIL PROTECTED] Subject: Error creating tables Can anyone help? In this script is one bug but i can't find it :( create table top( Id int(11) DEFAULT '0' NOT NULL auto_increment, nadalnumeric, kuupaev DATE, usa1 text, usa2 text, usa3 text, usa4 text, usa5 text, usa6 text, usa7 text, usa8 text, usa9 text, usa10text, eesti1 text, eesti2 text, eesti3 text, eesti4 text, eesti5 text, tekstlongtext, PRIMARY KEY (id) ); - 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
Boolean Datatype
I am working with an NT4.0 platform, mySQL 3.23 and using ASP and myODBC to access my data. I was hoping to find a BOOLEAN data type within mySQL which would allow me to pass either 'True' or 'False' in - but it appears there isn't one? Using 'BOOL' as the column type appears to create a tinyint - taking ranges from (as usual) -127 to 127. This is a *real* inconvenience. I can of course change the data from a '1' or a '0' to True and False on the way in and out of the database, but this is alot of extra coding, extra work on the part of the script and makes the code a great deal more unreadable. I really wanted to try mySQL on my personal site - if it is good enough in a development environment I may then go on to reccomend it to my company, but this seems a bit awkward and I'm sure I would take criticism if I can't answer this question. I have searched Google and the mySQL manual for 'boolean datatype' and other similar searches. Is there a datatype or an easier workaround for this? Many thanks in advance, Russ Davies
Re: Select a range from 0-9 or A-z
"Ung, Seng" wrote: hi: Here is my SQL statement to select a range of number from 0-9 Is there a short cut to this? id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%' see REGEXP in the manual you want id regexp '^[0-9]' - 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: Insert into blob
Try using this function on your data before inserting into the database. http://www.php.net/manual/en/function.addslashes.php If that doesn't work show us what error you are getting. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 6:15 PM To: [EMAIL PROTECTED] Subject: Insert into blob Hi, I am having some problems inserting data into a blob field, everything works fine but if I use any HTML and try to insert it, it doesn`t work. So in short is there something I should be doing to allow HTML to go into a text blob? I am using PHP if that helps. TIA Ade - 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
Bad Handshake error ...
Serveur d'application JBossI got a problem with my connection to a Mysql Database. ( am programming with JSP, using a JDBC driver...) The problem is that I got an Error 500 when I am trying to connect to my database ... Actually, There is a "Bad Handshake" error ... I don't know what is it due to. Should I enlarge the connect_timeout variable or not ? How can I solve the problem please ? Thks a lot Camil
OBSD 2.8 Memory Fault
I have a Perl program that gathers data and inserts it into a Mysql database via DBI (DBD::mysql). The program performs multiple inserts, one right after the other. On my OBSD 2.7 box, everything works just fine -- but when I try to run the same script on my OBSD 2.8 box, it will run through a couple of thousand inserts and the mysql daemon will either stop responding (goes to 99% cpu and hangs) or it will drop and restart. The error that I'm getting in the logs is: mysqld started on Tue Feb 6 12:17:00 EST 2001 /usr/local/libexec/mysqld: ready for connections Memory fault mysqld restarted on Tue Feb 6 12:33:29 EST 2001 /usr/local/libexec/mysqld: ready for connections Memory fault mysqld restarted on Tue Feb 6 12:33:49 EST 2001 /usr/local/libexec/mysqld: ready for connections Memory fault mysqld restarted on Tue Feb 6 12:34:09 EST 2001 /usr/local/libexec/mysqld: ready for connections Memory fault Is this a known problem with OBSD 2.8 or am I missing something? Thanks, Sean - 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: Select a range from 0-9 or A-z
Try: select whatever from whatever where field like '[0-9]%' http://www.mysql.com/doc/P/a/Pattern_matching.html -Original Message- From: Ung, Seng [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 9:03 AM To: [EMAIL PROTECTED] Subject: Select a range from 0-9 or A-z hi: Here is my SQL statement to select a range of number from 0-9 Is there a short cut to this? id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%' thank you seng - 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
Re: DEfault passwords
i just answered my own question::: shell mysql -u root mysql mysql UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; mysql FLUSH PRIVILEGES; You can, in MySQL Version 3.22 and above, use the SET PASSWORD statement: shell mysql -u root mysql mysql SET PASSWORD FOR root=PASSWORD('new_password'); RTFM donnie On Tue, 6 Feb 2001, D.Lewis wrote: Greetings. I just installed mySQL( mysql-3.23.29a-gamma-sun-solaris2.8-sparc) on a E150 using the script mySQL/configure.. One of the msg that was printed was to change the root password. however to change the root password you need to know the original password(s). What are the default password...? and can someone send me an example on changing the password...? thanks donnie - 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
RE: Boolean Datatype
Why not try using ENUM? http://www.mysql.com/doc/E/N/ENUM.html You could setup your table like this: CREATE TABLE logInfo2 ( logID INT NOT NULL UNIQUE, ipAddress VARCHAR(20) NOT NULL DEFAULT 'None', boolVarsENUM ('T', 'F') DEFAULT 'F' ) SELECT ipAddress FROM logInfo2 WHERE boolVars = 'F'; -Original Message- From: russ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 9:10 AM To: [EMAIL PROTECTED] Subject: Boolean Datatype Im new to the list, apologies if this has been asked before. Im developing a backend for a personal site (www.russd.com) using mySQL. The site is hosted on NT4 and has myODBC installed, I have some database access working, but I'm looking for a way to implement boolean types. Using Access/SQL server I can simple do an insert using SQL like the following (from within ASP): INSERT INTO tblMyTable (booleanField) VALUES (" myBooleanVariant ");" Unfortunately, mySQL doesn't appear to have a boolean datatype and myODBC doesn't seem to convert True/False to 1/0. The best solution I have so far is to use a TINYINT and change the True/False values within my ASP code to 1/0. This isn't perfect howevere as its more code, more work for the server and far less readable. I also have to cast to boolean when I SELECT data from the mySQL database. Could anyone suggest a better way of implementing this, or am I missing something? I have done a Google search and searched the mySQL manual, but got nothing. Many thanks in advance of your efforts. Russ Davies - 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
RE: Select a range from 0-9 or A-z
Check out REGEXP in the manual. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Ung, Seng [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 11:03 To: [EMAIL PROTECTED] Subject: Select a range from 0-9 or A-z hi: Here is my SQL statement to select a range of number from 0-9 Is there a short cut to this? id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%' thank you seng - 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
binary bug in mysql 3.23.30-gamma
In the process of converting over to 3.23.30-gamma from 3.22 whenever I set the field to a binary field to a value it stores it in the database as zero. Does anyone have any suggestions. I am having a problem with the binary data type... Here is the log to demonstrate. - mysql create table crud (bin varchar(16) binary); Query OK, 0 rows affected (0.02 sec) mysql insert into crud (bin) values (0x1); Query OK, 1 row affected (0.00 sec) mysql insert into crud (bin) values (0x2); Query OK, 1 row affected (0.00 sec) mysql select * from crud where bin=0; +--+ | bin | +--+ | | | | +--+ 2 rows in set (0.00 sec) mysql select * from crud where bin=0x0; +--+ | bin | +--+ | | | | +--+ 2 rows in set (0.00 sec) mysql select * from crud where bin=0x1; Empty set (0.00 sec) mysql select * from crud where bin=0x2; Empty set (0.00 sec) -- - 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
--skip-locking on Redhat 6.1 Linux
Can/should MySQL be started *without* --skip-locking on Redhat 6.1 Linux? TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com - 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: Boolean Datatype
Thanks for the suggestion, but this would still mean converting the data type from within ASP (the 'True' type) down to a char ('T') would it not? It is more sensical than using 1/0 but still involves the same number of processes? Russ Davies - Original Message - From: "Oson, Chris M." [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 6:36 PM Subject: RE: Boolean Datatype Why not try using ENUM? http://www.mysql.com/doc/E/N/ENUM.html You could setup your table like this: CREATE TABLE logInfo2 ( logID INT NOT NULL UNIQUE, ipAddress VARCHAR(20) NOT NULL DEFAULT 'None', boolVarsENUM ('T', 'F') DEFAULT 'F' ) SELECT ipAddress FROM logInfo2 WHERE boolVars = 'F'; -Original Message- From: russ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 9:10 AM To: [EMAIL PROTECTED] Subject: Boolean Datatype Im new to the list, apologies if this has been asked before. Im developing a backend for a personal site (www.russd.com) using mySQL. The site is hosted on NT4 and has myODBC installed, I have some database access working, but I'm looking for a way to implement boolean types. Using Access/SQL server I can simple do an insert using SQL like the following (from within ASP): INSERT INTO tblMyTable (booleanField) VALUES (" myBooleanVariant ");" Unfortunately, mySQL doesn't appear to have a boolean datatype and myODBC doesn't seem to convert True/False to 1/0. The best solution I have so far is to use a TINYINT and change the True/False values within my ASP code to 1/0. This isn't perfect howevere as its more code, more work for the server and far less readable. I also have to cast to boolean when I SELECT data from the mySQL database. Could anyone suggest a better way of implementing this, or am I missing something? I have done a Google search and searched the mySQL manual, but got nothing. Many thanks in advance of your efforts. Russ Davies - 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
RE: Boolean Datatype
Maybe, but you could define a constant.. CONST TRUE "T" CONST FALSE "F" INSERT INTO logInfo2 (logID, ipAddress, boolVars) VALUES (null, '192.192.192.192', TRUE) -Original Message- From: Russ Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 11:44 AM To: Oson, Chris M.; [EMAIL PROTECTED] Subject: Re: Boolean Datatype Thanks for the suggestion, but this would still mean converting the data type from within ASP (the 'True' type) down to a char ('T') would it not? It is more sensical than using 1/0 but still involves the same number of processes? Russ Davies - Original Message - From: "Oson, Chris M." [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 6:36 PM Subject: RE: Boolean Datatype Why not try using ENUM? http://www.mysql.com/doc/E/N/ENUM.html You could setup your table like this: CREATE TABLE logInfo2 ( logID INT NOT NULL UNIQUE, ipAddress VARCHAR(20) NOT NULL DEFAULT 'None', boolVarsENUM ('T', 'F') DEFAULT 'F' ) SELECT ipAddress FROM logInfo2 WHERE boolVars = 'F'; -Original Message- From: russ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 9:10 AM To: [EMAIL PROTECTED] Subject: Boolean Datatype Im new to the list, apologies if this has been asked before. Im developing a backend for a personal site (www.russd.com) using mySQL. The site is hosted on NT4 and has myODBC installed, I have some database access working, but I'm looking for a way to implement boolean types. Using Access/SQL server I can simple do an insert using SQL like the following (from within ASP): INSERT INTO tblMyTable (booleanField) VALUES (" myBooleanVariant ");" Unfortunately, mySQL doesn't appear to have a boolean datatype and myODBC doesn't seem to convert True/False to 1/0. The best solution I have so far is to use a TINYINT and change the True/False values within my ASP code to 1/0. This isn't perfect howevere as its more code, more work for the server and far less readable. I also have to cast to boolean when I SELECT data from the mySQL database. Could anyone suggest a better way of implementing this, or am I missing something? I have done a Google search and searched the mySQL manual, but got nothing. Many thanks in advance of your efforts. Russ Davies - 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
saving images from mysql to file
How do I save an images to a unix file that is saved in mysql? I know how to view the image with PHP and I know how to write a file to unix. I just can't get the data from mysql into a format that will allow me to read it then write it. - 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
Porting 3.22.32 Problems to HPUX 10.20
Hi All, I'm trying to port MySQL 3.22.32 to HPUX 10.20 and am encountering some problems. I'm on an HPUX 10.20 box with GCC 2.95.2, the configure script works fine when I build I get: mysqld.cc: In function `void close_connections()': mysqld.cc:262: implicit declaration of function `int shutdown(...)' mysqld.cc: In function `void server_init()': mysqld.cc:581: implicit declaration of function `int setsockopt(...)' mysqld.cc: In function `void * handle_connections_sockets(void *)': mysqld.cc:1589: implicit declaration of function `int getsockname(...)' Now, I've already searched the archive for the mailing list but it was no help. I am using GNU make so that option is out. I have successfully built Apache + PHP 4 + mod_perl, Perl 5.005_03, Perl 5.6, and WU-FTPD with this version of GCC, so I'm pretty sure that the socket stuff is fine. And I can't use a pre-compiled binary of MySQL becuase I need to be able to replicate a specific environment from scratch. I have also tried using the build configuration options specified by the 3.23.32 build notes but that was also of no use. My HPUX box does not have DCE loaded, so building MySQL with DCE threads is not an option. I have removed all the DCE libraries from the system and even rebuilt GCC 2.95.2 just to be safe, but the problem persists. I suspect that a definition is/isn't set that shouldn't/should be set but I can't figure it out. My configure option is: ./configure --with-low-memory --prefix=/usr/local1/apps \ --disable-shared --without-mit-threads I have also tried "--with-mit-threads" but no difference. Can anyone give _any_ pointers on fixing the problem? At this point I'm *very* frustrated so any help is greatly appreciated. Thanks in advance for *any* help you can provide. John -- +I speak for myself.+ | John Jung ([EMAIL PROTECTED]) | Unigraphics Solutions | | Global Technical Access Center| 10824 Hope Street, Cypress Pointe | | Operating Systems Group | Cypress, California 90630 | +--(800) 955----+ - 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
PK, SK, FK . . . ?
Terribly simple question, but I'm fairly new at this. I'm building a database based off a model built in MS Access. The table that I'm currently working on appears to have two Primary Keys, although I'm assuming one of them must be secondary. How would I specify this in creating the table in MySQL? Would I need to create a composite key, etc.? Thanks. John Halladay BISYS - Commission Accounting Phone: 801.532.6660 x7973 Fax: 801.533.7879 www.ascensus.com Life LTC Annuities Variable Disability - 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: Boolean Datatype
"RD" == Russ Davies [EMAIL PROTECTED] writes: RD Thanks for the suggestion, but this would still mean converting the data RD type from within ASP (the 'True' type) down to a char ('T') would it not? then use ENUM('False','True') instead. Enum can have any string you want. I personally prefer to use the order False, True since then it also has the numeric values 0 and 1. CREATE TABLE logInfo2 ( logID INT NOT NULL UNIQUE, ipAddress VARCHAR(20) NOT NULL DEFAULT 'None', boolVarsENUM ('T', 'F') DEFAULT 'F' ) - 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: PK, SK, FK . . . ?
Hi, Do you mean that the table has two unique indices, or that the primary index has two columns? Either way, it is easy to define this in mysql: create table foo ( col1 varchar(20) not null, col2 int not null, col3 smallint not null, primary key(col1, col2), unique second_idx(col1, col3)); Hope this helps Quentin -Original Message- From: John Halladay [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 7 February 2001 09:36 To: MySQL List (E-mail) Subject: PK, SK, FK . . . ? Terribly simple question, but I'm fairly new at this. I'm building a database based off a model built in MS Access. The table that I'm currently working on appears to have two Primary Keys, although I'm assuming one of them must be secondary. How would I specify this in creating the table in MySQL? Would I need to create a composite key, etc.? Thanks. John Halladay BISYS - Commission Accounting Phone: 801.532.6660 x7973 Fax: 801.533.7879 www.ascensus.com Life LTC Annuities Variable Disability - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Boolean Datatype
Enum would allow me to have two values such as 'True' and 'False' ? The problem is when I pass in this SQL statement to mySQL: INSERT INTO tableName (fieldName) VALUES (True); -mySQL does not recognise the word True - it would need to be in quotes, which means changes in the code on the web server. It would mean passing in a string instead of a boolean. This is what I'm trying to avoid. True and False are not keywords in mySQL. Would there be any way I could perhaps make them so (giving them values of 1 and 0 respectively would solve my problem completely). Thanks in advance for your efforts, Russ Davies - Original Message - From: "Matt Friedman" [EMAIL PROTECTED] To: "Russ Davies" [EMAIL PROTECTED]; "MySQL List" [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 9:11 PM Subject: Re: Boolean Datatype Try using enum in mysql. That might help you out a bit. Matt Friedman Spry New Media http://www.sprynewmedia.com Lead Programmer/Partner email: [EMAIL PROTECTED] phone: 250 744 3655 fax: 250 370 0436 - Original Message - From: "Russ Davies" [EMAIL PROTECTED] To: "Oson, Chris M." [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 12:45 PM Subject: Re: Boolean Datatype I can't do that for 2 reasons : 1] 'True' and 'False' are reserved words in ASP 2] 'True' would then be a variant holding the value 'T' - which would mean I could not carry out logical comparisons with the two variants, evaluating things against True or False. I have to say after all the reccomendations I received for mySQL, I really am shocked to find there are no BOOLEAN values/datatypes. Unless I'm missing something (and Im happy to admit I probably am) this seems like a very serious and time consuming omission from the mySQL spec. If anyone is aware of a solution to this, please email me, I quite like mySQL but I think I'd probably move to another DBMS rather than spend a long time and get messy coding around this problem. Russ Davies - Original Message - From: "Oson, Chris M." [EMAIL PROTECTED] To: "Russ Davies" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 8:02 PM Subject: RE: Boolean Datatype Maybe, but you could define a constant.. CONST TRUE "T" CONST FALSE "F" INSERT INTO logInfo2 (logID, ipAddress, boolVars) VALUES (null, '192.192.192.192', TRUE) -Original Message- From: Russ Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 11:44 AM To: Oson, Chris M.; [EMAIL PROTECTED] Subject: Re: Boolean Datatype Thanks for the suggestion, but this would still mean converting the data type from within ASP (the 'True' type) down to a char ('T') would it not? It is more sensical than using 1/0 but still involves the same number of processes? Russ Davies - Original Message - From: "Oson, Chris M." [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 6:36 PM Subject: RE: Boolean Datatype Why not try using ENUM? http://www.mysql.com/doc/E/N/ENUM.html You could setup your table like this: CREATE TABLE logInfo2 ( logID INT NOT NULL UNIQUE, ipAddress VARCHAR(20) NOT NULL DEFAULT 'None', boolVarsENUM ('T', 'F') DEFAULT 'F' ) SELECT ipAddress FROM logInfo2 WHERE boolVars = 'F'; -Original Message- From: russ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 9:10 AM To: [EMAIL PROTECTED] Subject: Boolean Datatype Im new to the list, apologies if this has been asked before. Im developing a backend for a personal site (www.russd.com) using mySQL. The site is hosted on NT4 and has myODBC installed, I have some database access working, but I'm looking for a way to implement boolean types. Using Access/SQL server I can simple do an insert using SQL like the following (from within ASP): INSERT INTO tblMyTable (booleanField) VALUES (" myBooleanVariant ");" Unfortunately, mySQL doesn't appear to have a boolean datatype and myODBC doesn't seem to convert True/False to 1/0. The best solution I have so far is to use a TINYINT and change the True/False values within my ASP code to 1/0. This isn't perfect howevere as its more code, more work for the server and far less readable. I also have to cast to boolean when I SELECT data from the mySQL database. Could anyone suggest a better way of implementing this, or am I missing something? I have done a Google search and searched the mySQL manual, but got nothing. Many thanks in advance of your efforts. Russ Davies - Before posting, please check: http://www.mysql.com/manual.php (the
RE: Boolean Datatype
Couldn't you just do: boolVarsENUM ('True', 'False') DEFAULT 'False' -or- boolVarsENUM ('TRUE', 'FALSE') DEFAULT 'FALSE' unless I'm misunderstanding what you are saying about ASP. -Original Message- From: Russ Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 2:44 PM To: Oson, Chris M.; [EMAIL PROTECTED] Subject: Re: Boolean Datatype Thanks for the suggestion, but this would still mean converting the data type from within ASP (the 'True' type) down to a char ('T') would it not? It is more sensical than using 1/0 but still involves the same number of processes? Russ Davies - Original Message - From: "Oson, Chris M." [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 6:36 PM Subject: RE: Boolean Datatype Why not try using ENUM? http://www.mysql.com/doc/E/N/ENUM.html You could setup your table like this: CREATE TABLE logInfo2 ( logID INT NOT NULL UNIQUE, ipAddress VARCHAR(20) NOT NULL DEFAULT 'None', boolVarsENUM ('T', 'F') DEFAULT 'F' ) SELECT ipAddress FROM logInfo2 WHERE boolVars = 'F'; -Original Message- From: russ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 9:10 AM To: [EMAIL PROTECTED] Subject: Boolean Datatype Im new to the list, apologies if this has been asked before. Im developing a backend for a personal site (www.russd.com) using mySQL. The site is hosted on NT4 and has myODBC installed, I have some database access working, but I'm looking for a way to implement boolean types. Using Access/SQL server I can simple do an insert using SQL like the following (from within ASP): INSERT INTO tblMyTable (booleanField) VALUES (" myBooleanVariant ");" Unfortunately, mySQL doesn't appear to have a boolean datatype and myODBC doesn't seem to convert True/False to 1/0. The best solution I have so far is to use a TINYINT and change the True/False values within my ASP code to 1/0. This isn't perfect howevere as its more code, more work for the server and far less readable. I also have to cast to boolean when I SELECT data from the mySQL database. Could anyone suggest a better way of implementing this, or am I missing something? I have done a Google search and searched the mySQL manual, but got nothing. Many thanks in advance of your efforts. Russ Davies - 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 - 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: PK, SK, FK . . . ?
It's ok for a table to have 2 keys that COULD be the PIKE. only 1 of them can actually BE the PIKE, the other is a Candidate Key. (CK) As to whether you should make them both part of the PK, that's a different question. I usually avoid compound PK's unless there is NO OTHER WAY AROUND IT. Cal http://www.calevans.com -Original Message- From: John Halladay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 2:36 PM To: MySQL List (E-mail) Subject: PK, SK, FK . . . ? Terribly simple question, but I'm fairly new at this. I'm building a database based off a model built in MS Access. The table that I'm currently working on appears to have two Primary Keys, although I'm assuming one of them must be secondary. How would I specify this in creating the table in MySQL? Would I need to create a composite key, etc.? Thanks. John Halladay BISYS - Commission Accounting Phone: 801.532.6660 x7973 Fax: 801.533.7879 www.ascensus.com Life LTC Annuities Variable Disability - 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
Re: Boolean Datatype
When a True data type is passed in from ASP, the resultant SQL command will look like this : INSERT INTO tableName (fieldName) VALUES (True); Not this : INSERT INTO tableName (fieldName) VALUES ('True'); So produces an error as the value is not enclosed in quotes, which it would need to be for an ENUM data type? Russ Davies - Original Message - From: "Vivek Khera" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 9:09 PM Subject: Re: Boolean Datatype "RD" == Russ Davies [EMAIL PROTECTED] writes: RD Thanks for the suggestion, but this would still mean converting the data RD type from within ASP (the 'True' type) down to a char ('T') would it not? then use ENUM('False','True') instead. Enum can have any string you want. I personally prefer to use the order False, True since then it also has the numeric values 0 and 1. CREATE TABLE logInfo2 ( logID INT NOT NULL UNIQUE, ipAddress VARCHAR(20) NOT NULL DEFAULT 'None', boolVarsENUM ('T', 'F') DEFAULT 'F' ) - 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
Big Time
I have read that IBM has concluded that Linux is ready for the big time. That may be true for Linux but I would doubt that the same could be said for MySQL. For example the missing host.frm has been in threads in the archive for a long time, I have been bitten by the beast with no success yet in sight despite following the leads from kind folk on this list. Such simple problems as locating the database on a large capacity drive after installing MySQL from an RPM need to be addressed in a simple and reliable fashion. Trying to guess what values in which of the 16 parameters for safe_mysqld might make a difference is not simple. I suspect users could come up with their own pet problems. - 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: Boolean Datatype
I use True/False fields all the time from MS Access through myODBC. While I've not used ASP, it would seem that the functionality would be the same. If this is the case, then True is represented by -1 and False is represented by 0. Simply use the TINYINT that mySQL provides to store these two values. "Russ Davies" [EMAIL PROTECTED] wrote: I can't do that for 2 reasons : 1] 'True' and 'False' are reserved words in ASP 2] 'True' would then be a variant holding the value 'T' - which would mean I could not carry out logical comparisons with the two variants, evaluating things against True or False. I have to say after all the reccomendations I received for mySQL, I really am shocked to find there are no BOOLEAN values/datatypes. Unless I'm missing something (and Im happy to admit I probably am) this seems like a very serious and time consuming omission from the mySQL spec. If anyone is aware of a solution to this, please email me, I quite like mySQL but I think I'd probably move to another DBMS rather than spend a long time and get messy coding around this problem. Russ Davies - Original Message - From: "Oson, Chris M." [EMAIL PROTECTED] To: "Russ Davies" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 8:02 PM Subject: RE: Boolean Datatype Maybe, but you could define a constant.. CONST TRUE "T" CONST FALSE "F" INSERT INTO logInfo2 (logID, ipAddress, boolVars) VALUES (null, '192.192.192.192', TRUE) -Original Message- From: Russ Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 11:44 AM To: Oson, Chris M.; [EMAIL PROTECTED] Subject: Re: Boolean Datatype Thanks for the suggestion, but this would still mean converting the data type from within ASP (the 'True' type) down to a char ('T') would it not? It is more sensical than using 1/0 but still involves the same number of processes? Russ Davies - Original Message - From: "Oson, Chris M." [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 6:36 PM Subject: RE: Boolean Datatype Why not try using ENUM? http://www.mysql.com/doc/E/N/ENUM.html You could setup your table like this: CREATE TABLE logInfo2 ( logID INT NOT NULL UNIQUE, ipAddress VARCHAR(20) NOT NULL DEFAULT 'None', boolVarsENUM ('T', 'F') DEFAULT 'F' ) SELECT ipAddress FROM logInfo2 WHERE boolVars = 'F'; -Original Message- From: russ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 9:10 AM To: [EMAIL PROTECTED] Subject: Boolean Datatype Im new to the list, apologies if this has been asked before. Im developing a backend for a personal site (www.russd.com) using mySQL. The site is hosted on NT4 and has myODBC installed, I have some database access working, but I'm looking for a way to implement boolean types. Using Access/SQL server I can simple do an insert using SQL like the following (from within ASP): INSERT INTO tblMyTable (booleanField) VALUES (" myBooleanVariant ");" Unfortunately, mySQL doesn't appear to have a boolean datatype and myODBC doesn't seem to convert True/False to 1/0. The best solution I have so far is to use a TINYINT and change the True/False values within my ASP code to 1/0. This isn't perfect howevere as its more code, more work for the server and far less readable. I also have to cast to boolean when I SELECT data from the mySQL database. Could anyone suggest a better way of implementing this, or am I missing something? I have done a Google search and searched the mySQL manual, but got nothing. Many thanks in advance of your efforts. Russ Davies - 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: Boolean Datatype
http://www.mysql.com/doc/A/d/Adding_functions.html Could this help him out? Creating a User Defined Function? Gregg - Original Message - From: Russ Davies [EMAIL PROTECTED] To: Matt Friedman [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 3:42 PM Subject: Re: Boolean Datatype Enum would allow me to have two values such as 'True' and 'False' ? The problem is when I pass in this SQL statement to mySQL: INSERT INTO tableName (fieldName) VALUES (True); -mySQL does not recognise the word True - it would need to be in quotes, which means changes in the code on the web server. It would mean passing in a string instead of a boolean. This is what I'm trying to avoid. True and False are not keywords in mySQL. Would there be any way I could perhaps make them so (giving them values of 1 and 0 respectively would solve my problem completely). Thanks in advance for your efforts, Russ Davies - Original Message - From: "Matt Friedman" [EMAIL PROTECTED] To: "Russ Davies" [EMAIL PROTECTED]; "MySQL List" [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 9:11 PM Subject: Re: Boolean Datatype Try using enum in mysql. That might help you out a bit. Matt Friedman Spry New Media http://www.sprynewmedia.com Lead Programmer/Partner email: [EMAIL PROTECTED] phone: 250 744 3655 fax: 250 370 0436 - Original Message - From: "Russ Davies" [EMAIL PROTECTED] To: "Oson, Chris M." [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 12:45 PM Subject: Re: Boolean Datatype I can't do that for 2 reasons : 1] 'True' and 'False' are reserved words in ASP 2] 'True' would then be a variant holding the value 'T' - which would mean I could not carry out logical comparisons with the two variants, evaluating things against True or False. I have to say after all the reccomendations I received for mySQL, I really am shocked to find there are no BOOLEAN values/datatypes. Unless I'm missing something (and Im happy to admit I probably am) this seems like a very serious and time consuming omission from the mySQL spec. If anyone is aware of a solution to this, please email me, I quite like mySQL but I think I'd probably move to another DBMS rather than spend a long time and get messy coding around this problem. Russ Davies - Original Message - From: "Oson, Chris M." [EMAIL PROTECTED] To: "Russ Davies" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 8:02 PM Subject: RE: Boolean Datatype Maybe, but you could define a constant.. CONST TRUE "T" CONST FALSE "F" INSERT INTO logInfo2 (logID, ipAddress, boolVars) VALUES (null, '192.192.192.192', TRUE) -Original Message- From: Russ Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 11:44 AM To: Oson, Chris M.; [EMAIL PROTECTED] Subject: Re: Boolean Datatype Thanks for the suggestion, but this would still mean converting the data type from within ASP (the 'True' type) down to a char ('T') would it not? It is more sensical than using 1/0 but still involves the same number of processes? Russ Davies - Original Message - From: "Oson, Chris M." [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 6:36 PM Subject: RE: Boolean Datatype Why not try using ENUM? http://www.mysql.com/doc/E/N/ENUM.html You could setup your table like this: CREATE TABLE logInfo2 ( logID INT NOT NULL UNIQUE, ipAddress VARCHAR(20) NOT NULL DEFAULT 'None', boolVarsENUM ('T', 'F') DEFAULT 'F' ) SELECT ipAddress FROM logInfo2 WHERE boolVars = 'F'; -Original Message- From: russ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 9:10 AM To: [EMAIL PROTECTED] Subject: Boolean Datatype Im new to the list, apologies if this has been asked before. Im developing a backend for a personal site (www.russd.com) using mySQL. The site is hosted on NT4 and has myODBC installed, I have some database access working, but I'm looking for a way to implement boolean types. Using Access/SQL server I can simple do an insert using SQL like the following (from within ASP): INSERT INTO tblMyTable (booleanField) VALUES (" myBooleanVariant ");" Unfortunately, mySQL doesn't appear to have a boolean datatype and myODBC doesn't seem to convert True/False to 1/0. The best solution I have so far is to use a TINYINT and change the True/False values within my ASP code to 1/0. This isn't perfect howevere as its more code, more work for the server and far less readable. I also have to cast to boolean when I SELECT data from the mySQL database. Could anyone suggest a better way of implementing this, or am I
Re: Boolean Datatype
Let me add to this. I meant to say: He could create a function that would do it, and use it in his queries? Gregg - Original Message - From: Gregg Housh [EMAIL PROTECTED] To: Russ Davies [EMAIL PROTECTED]; Matt Friedman [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 3:56 PM Subject: Re: Boolean Datatype http://www.mysql.com/doc/A/d/Adding_functions.html Could this help him out? Creating a User Defined Function? Gregg - Original Message - From: Russ Davies [EMAIL PROTECTED] To: Matt Friedman [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 3:42 PM Subject: Re: Boolean Datatype Enum would allow me to have two values such as 'True' and 'False' ? The problem is when I pass in this SQL statement to mySQL: INSERT INTO tableName (fieldName) VALUES (True); -mySQL does not recognise the word True - it would need to be in quotes, which means changes in the code on the web server. It would mean passing in a string instead of a boolean. This is what I'm trying to avoid. True and False are not keywords in mySQL. Would there be any way I could perhaps make them so (giving them values of 1 and 0 respectively would solve my problem completely). Thanks in advance for your efforts, Russ Davies - Original Message - From: "Matt Friedman" [EMAIL PROTECTED] To: "Russ Davies" [EMAIL PROTECTED]; "MySQL List" [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 9:11 PM Subject: Re: Boolean Datatype Try using enum in mysql. That might help you out a bit. Matt Friedman Spry New Media http://www.sprynewmedia.com Lead Programmer/Partner email: [EMAIL PROTECTED] phone: 250 744 3655 fax: 250 370 0436 - Original Message - From: "Russ Davies" [EMAIL PROTECTED] To: "Oson, Chris M." [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 12:45 PM Subject: Re: Boolean Datatype I can't do that for 2 reasons : 1] 'True' and 'False' are reserved words in ASP 2] 'True' would then be a variant holding the value 'T' - which would mean I could not carry out logical comparisons with the two variants, evaluating things against True or False. I have to say after all the reccomendations I received for mySQL, I really am shocked to find there are no BOOLEAN values/datatypes. Unless I'm missing something (and Im happy to admit I probably am) this seems like a very serious and time consuming omission from the mySQL spec. If anyone is aware of a solution to this, please email me, I quite like mySQL but I think I'd probably move to another DBMS rather than spend a long time and get messy coding around this problem. Russ Davies - Original Message - From: "Oson, Chris M." [EMAIL PROTECTED] To: "Russ Davies" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 8:02 PM Subject: RE: Boolean Datatype Maybe, but you could define a constant.. CONST TRUE "T" CONST FALSE "F" INSERT INTO logInfo2 (logID, ipAddress, boolVars) VALUES (null, '192.192.192.192', TRUE) -Original Message- From: Russ Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 11:44 AM To: Oson, Chris M.; [EMAIL PROTECTED] Subject: Re: Boolean Datatype Thanks for the suggestion, but this would still mean converting the data type from within ASP (the 'True' type) down to a char ('T') would it not? It is more sensical than using 1/0 but still involves the same number of processes? Russ Davies - Original Message - From: "Oson, Chris M." [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 6:36 PM Subject: RE: Boolean Datatype Why not try using ENUM? http://www.mysql.com/doc/E/N/ENUM.html You could setup your table like this: CREATE TABLE logInfo2 ( logID INT NOT NULL UNIQUE, ipAddress VARCHAR(20) NOT NULL DEFAULT 'None', boolVarsENUM ('T', 'F') DEFAULT 'F' ) SELECT ipAddress FROM logInfo2 WHERE boolVars = 'F'; -Original Message- From: russ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 9:10 AM To: [EMAIL PROTECTED] Subject: Boolean Datatype Im new to the list, apologies if this has been asked before. Im developing a backend for a personal site (www.russd.com) using mySQL. The site is hosted on NT4 and has myODBC installed, I have some database access working, but I'm looking for a way to implement boolean types. Using Access/SQL server I can simple do an insert using SQL like the following (from within ASP): INSERT INTO tblMyTable (booleanField) VALUES (" myBooleanVariant ");" Unfortunately, mySQL doesn't appear to have a boolean datatype and myODBC doesn't seem to convert True/False to 1/0. The best solution I have
RE: creating tables from the shell
Hi, mysql -vvv samp_db create_member.sql should tell what commands mysql is executing. Regards Quentin -Original Message- From: Michael Tuminello [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 7 February 2001 10:05 To: [EMAIL PROTECTED] Subject: creating tables from the shell Hey - sorry for being too much of a pinhead to figure this out, but the server is really not giving me too many clues to work with. I'm trying to execute commands from the shell to create new tables (I'm walking through the new riders book). the book says % mysql samp_db create_member.sql for me, for whatever reason, mysql will not execute except from its root directory. so I'm doing % ./bin/mysql samp_db ./var/mysql/create_member.sql (the book also doesn't tell you where to put the executible scripts, so I stuck them in the data directory) can anyone tell me why this isn't working? it seems to execute (no error), but nothing happens. Also, can anyone tell me if there is a way to get the server to tell you a little more about why things don't work? I could use some help debugging, and the log entries are pithy, to say the least. thanks in advance- MT - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: creating tables from the shell
Thanks for the responses. Both those comments will no doubt help me out next time. this time around, pathetically enough, it was bad line breaks due to the fact I decompressed it on a mac and then uploaded it. how embarasskin. MT - 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
Mysql over NFS
I am trying to setup some sort of loadbalancing and more importantly fail-over-services for my mysql servers. I would like to have all the data stored on a RAID interface that will mirror the data and provide the data to two separate mysql daemons on two separate boxes. That way if one daemon or machine fails the other daemon can access the independent RAID. Is this possible and will two mysql daemons play nicely with each other when accessing data on a drive shared between the two computers? Essentially, can two mysql daemons play nicely with mysql data over a RAID or NFS? TIA, Nathan Cook [ [EMAIL PROTECTED] ] - 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: MS Access Checkbox equivalent format in MySQL
Take your pic - personally, I usually use a tinyint, and assign a 0 or 1 - I suspect the options you describe would work just as well. regards, P On Tue, 6 Feb 2001, John Halladay wrote: If I am using MS Access and linking to tables in MySQL through MyODBC, what is the equivalent format of a checkbox (Yes/No) in MySQL? Would it be ENUM('Yes','No') or ENUM('True','False')? All caps TRUE, YES, etc.? Thanks ahead of time for your input. John Halladay - 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
RE: Performance issues.
Woah! 800,000 visits a day!? Wow... try 80,000. -Original Message- From: Ryan Hadley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 5:25 PM To: [EMAIL PROTECTED] Subject: Performance issues. I'm not much of a db admin so I really don't know how to get better performance out of our database... but it seriously needs some speeding up. We have this huge dictionary... It's 272235 rows. We have to be able to search through it. We run about 800,000 visits a day. Right now we're doing a "WHERE keyWord LIKE 'word%'"... but the "LIKE"'s are killing the machine. We had to upgrade our memory to 512M. That helped a bit, now our machine doesn't just die. But it's still way to slow. The CPU is maxing out and we're hitting like 10-15% idle during slow periods and 0.0% idle during rush periods. What can we do? Besides of course firing me and getting a real db admin. :) - 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
RE: Performance issues.
Thanks for the quick response. The response time is slow... and the mysqld processes are what is hogging up the system. We do have indexes on the fields, but from what I understand, when you use a "LIKE" statement, it rarely uses an index. -Ryan -Original Message- From: Kent Hoover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 5:42 PM To: [EMAIL PROTECTED] Subject: Performance issues. Ryan: If your response time for this query is slow, it is likely that an INDEX will help you. (Read about CREATE INDEX in the MySQL manual. If you don't already have an INDEX on the keyWord column, create one. If you can induce your customer/users to type more characters, that would help. WHERE keyWord LIKE 'salomi%' is much better for you than WHERE keyWord LIKE 's%'. NOTE, that if your response time to this query is good, there could be something other than MySQL running on your machine that is sucking your CPU dry. You might be able to spot it by running 'top' 'ps -ef' or whatever command is available for your machine. Cheers, Kent Hoover - 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
Re: How many tables in a database?
How do you decide when a table should go into another database. For example, I have a database with about 12 tables and growing. I keep them in one database because I am doing joins that periodically involve all of the tables. Is this the right way to do it? Richard Richard, I'm not sure about right or wrong ways ... but I've got a system which creates two tables per day, keeps 60 days worth of data in the current database, and rolls tables off the end into a history database every night. The current database actually has about 150 tables in it (there are quite a few which stay in place). Realistically, the server won't support queries over 60 tables (and who's surprised?), so I've got scripts which do nightly summaries which get dropped into extra tables. It might sound a little clumsy, but having tried Perl scripts which prepare and select on 60 tables to answer a query, for performance reasons, summary tables are the way to go. Occasionally, the system *does* get queries on about 50% of the available tables, but the users are made aware that it won't be fast ! Hope this helps a little. Regards, Paul Wilson Senior Programmer, iinet Ltd - 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: Mysql over NFS
Nope... It's stated explicitly in the docs that this is a *Bad Idea* (with caps, even! *grin*). You'll need to look at other options - replication, possibly, either on to the same machine with your db on a different drive, or (probably preferable) onto a seperate box. regards, P On Tue, 6 Feb 2001, Nathan Cook wrote: I am trying to setup some sort of loadbalancing and more importantly fail-over-services for my mysql servers. I would like to have all the data stored on a RAID interface that will mirror the data and provide the data to two separate mysql daemons on two separate boxes. That way if one daemon or machine fails the other daemon can access the independent RAID. Is this possible and will two mysql daemons play nicely with each other when accessing data on a drive shared between the two computers? Essentially, can two mysql daemons play nicely with mysql data over a RAID or NFS? TIA, Nathan Cook [ [EMAIL PROTECTED] ] - 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
RE: MySQL Memory Requirements...
thanks for your advice vivek rafael. can anyone tell me why someone tried unsubscribing me from this list? Bit rude I thought, esp with no explanation. I don't mind being told if my questions are in the wrong place or anything like that. dan -Original Message- From: Vivek Khera [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 6 February 2001 08:39 To: [EMAIL PROTECTED] Subject: RE: MySQL Memory Requirements... "DK" == Daniel Kirk [EMAIL PROTECTED] writes: DK 30gb eide hdd DK Will the machine fall over because it doesn't have enough ram/CPU DK power (for about 20k users per week as below)? any ball park DK comments eg no worries, close call, not a chance? Your bottleneck on a database is almost never the CPU. It is almost always the disk. Get a faster disk. More RAM never hurts, either. - 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
Re: How many tables in a database?
Just a side note... you can do JOINs on tables from different databases on the same mySQL server eg SELECT t1.UserName FROM db1.table AS t1, db2.anothertable AS t2 WHERE t1.UserName = t2.UserName As for database layout... I would go with what makes the most sense... If having 84 tables in one database makes sense then do it... it wont really hurt performance until you start having hundreds of tables in one db. However, since you can do JOINs across databases (on same server) if it makes sense to split your tables into multiple dbs... the do it!! BTW the limit for number of tables in one database is roughly 10,000 depending on your OS (Linux running EXT2 among many others) - Original Message - From: "Richard Reina" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 05, 2001 7:40 AM Subject: How many tables in a database? How do you decide when a table should go into another database. For example, I have a database with about 12 tables and growing. I keep them in one database because I am doing joins that periodically involve all of the tables. Is this the right way to do it? Richard - 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