Re: turn of column headings
In the last episode (Mar 05), Praveen Kallakuri said: hello there, i am a novice, so bear with this rather trivial question. how do i turn off the column-headers for select statements in mysql?? couldn't find any help with the online manual. -N, --skip-column-names Don't write column names in results. -- Dan Nelson [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: trying to install on RedHat 7.0 and need help
Go back to redhat.com and get the RPM that works, Or search the mysql list archives. This has been answered a hundred times ( No exageration. ) Charles L Hagen wrote: OK, here is the story. I have a PII Linux RedHat 7.0 server. I installed the Mysql package that comes with it and also the dependent applications as specified. I try to start the mysqld and it gives me an OK and then I status it and it says mysqld dead but subsys locked I am asking for two things First, after the RPM installation what am I supposed to do? Second, how do I get it to run and build my first database? The error message log file is printed out below: 010302 14:05:32 mysqld started 010302 14:05:32 Can't start server: Bind on TCP/IP port: Address already in use 010302 14:05:32 Do you already have another mysqld server running on port: 3306 ? 010302 14:05:32 Aborting 010302 14:05:32 mysqld ended 010302 14:21:51 mysqld started 010302 14:21:51 Can't start server: Bind on TCP/IP port: Address already in use 010302 14:21:51 Do you already have another mysqld server running on port: 3306 ? 010302 14:21:51 Aborting 010302 14:21:51 mysqld ended 010302 14:25:39 mysqld started 010302 14:25:39 Can't start server: Bind on TCP/IP port: Address already in use 010302 14:25:39 Do you already have another mysqld server running on port: 3306 ? 010302 14:25:39 Aborting 010302 16:43:15 mysqld started 010302 16:43:15 Can't start server: Bind on TCP/IP port: Address already in use 010302 16:43:15 Do you already have another mysqld server running on port: 3306 ? 010302 16:43:15 Aborting 010302 16:43:15 mysqld ended 010302 16:43:26 mysqld started 010302 16:43:26 Can't start server: Bind on TCP/IP port: Address already in use 010302 16:43:26 Do you already have another mysqld server running on port: 3306 ? 010302 16:43:26 Aborting 010302 16:43:26 mysqld ended 010302 16:49:19 mysqld started 010302 16:49:19 Can't start server: Bind on TCP/IP port: Address already in use 010302 16:49:19 Do you already have another mysqld server running on port: 3306? 010302 16:49:19 Aborting 010302 16:49:19 mysqld ended 010302 16:51:22 mysqld started 010302 16:51:22 Can't start server: Bind on TCP/IP port: Address already in use 010302 16:51:22 Do you already have another mysqld server running on port: 3306 ? 010302 16:51:22 Aborting 010302 16:51:22 mysqld ended 010302 16:59:38 mysqld started 010302 16:59:38 Can't start server: Bind on TCP/IP port: Address already in use 010302 16:59:38 Do you already have another mysqld server running on port: 3306 ? 010302 16:59:38 Aborting 010302 16:59:38 mysqld ended 010302 16:59:51 mysqld started 010302 16:59:51 Can't start server: Bind on TCP/IP port: Address already in use 010302 16:59:51 Do you already have another mysqld server running on port: 3306 ? 010302 16:59:51 mysqld ended 010302 17:00:06 mysqld started 010302 17:00:07 Can't start server: Bind on TCP/IP port: Address already in use 010302 17:00:07 Do you already have another mysqld server running on port: 3306 ? 010302 17:00:07 Aborting 010302 17:00:07 mysqld ended 010302 17:00:08 mysqld started 010302 17:00:08 Can't start server: Bind on TCP/IP port: Address already in use 010302 17:00:08 Do you already have another mysqld server running on port: 3306 ? 010302 17:00:08 Aborting 010302 17:00:08 mysqld ended 010302 17:00:47 mysqld started 010302 17:00:47 Can't start server: Bind on TCP/IP port: Address already in use 010302 17:00:47 Do you already have another mysqld server running on port: 3306? 010302 17:00:47 Aborting 010302 17:00:47 mysqld ended 010303 20:36:33 mysqld started 010303 20:36:34 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010303 20:36:34 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010303 20:36:34 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010303 20:36:34 mysqld ended 010303 20:36:41 mysqld started 010303 20:36:41 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010303 20:36:41 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010303 20:36:41 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010303 20:36:41 mysqld ended Fatal error: Can't change to run as user 'mysqld' ; Please check that the user exists! 010303 21:33:51 Aborting 010303 21:33:51 mysqld ended 010303 21:52:46 mysqld started 010303 21:52:46 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010303 21:52:46 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010303 21:52:46 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010303 21:52:46
can't start mysql
Dear, I use Red Head 6 with mysql, php3 and apache, past all of them are work well, but one day the our DNS had some problem, after solve the DNS problems, we found we cannot restart our mysql. The error message is "mysqld daemon ended". The host.err is as below: mysqld started on Wed Mar 7 00:46:55 CST 2001 010307 0:46:55 Can't start server: Bind on TCP/IP port: Address already in use 010307 0:46:55 Do you already have another mysqld server running on port: 3306 ? 010307 0:46:55 Aborting mysqld ended on Wed Mar 7 00:46:55 CST 2001 mysqld started on Wed Mar 7 00:51:59 CST 2001 010307 0:51:59 Can't start server: Bind on TCP/IP port: Address already in use 010307 0:51:59 Do you already have another mysqld server running on port: 3306 ? 010307 0:51:59 Aborting mysqld ended on Wed Mar 7 00:51:59 CST 2001 How can I check wheather my server have other mysql server running, but I only need to run ONE mysql, may you help me pls. Fox.
Tuning thread_cache_size variable
Hi all, I'm doing another bout of MySQL server tuning as the load on my server has nearly doubled due to recent projects, so I'm trying to squeeze some more performance out of it. Again, I'm looking at thread_cache_size, which I currently have set to 16. The manual says that "by examining the difference between Connections and Threads_created you can see how efficient the current thread cache is for you". I looked at the variables, and at that particular moment, they were at 44 and 67343 respectively. This works out that a new thread is being created roughly every 12 connections. This sounds bad to me, but is it really? I suppose the ideal figure would be zero new threads having to be created ever, as all new connections would use cached threads. So, I have a couple of questions that someone might be able to answer: * What is the definition of an efficient thread cache? * Should I be aiming to get my new threads per connections figure as low as possible? * What effect on memory usage would having a larger thread cache make? This is all on a RedHat Linux 6.2 server with 512Mb RAM and MySQL 3.23.32. Regards, Basil Hussain ([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
Sending data, but no data sent?
Description: Selecting for a number in a char table is REALLY slow. How-To-Repeat: Large table, main index on column 'id' varchar(100). mysql select id from ticketid where id = '15473'; Empty set (0.00 sec) mysql select id from ticketid where id = 15473; +--+ | id | +--+ | [EMAIL PROTECTED] | | [EMAIL PROTECTED] | | [EMAIL PROTECTED] | +--+ 3 rows in set (3 min 49.81 sec) mysql select id from ticketid where id = 15473 and id like '15473%'; +--+ | id | +--+ | [EMAIL PROTECTED] | | [EMAIL PROTECTED] | | [EMAIL PROTECTED] | +--+ 3 rows in set (4 min 6.83 sec) Say what ??? mysql explain select id,ticket,seq from ticketid where id = 15473 and id like '15473%'; +--+--+---+--+-+--++--+ | table| type | possible_keys | key | key_len | ref | rows | Extra| +--+--+---+--+-+--++--+ | ticketid | ALL | PRIMARY | NULL |NULL | NULL | 406867 | where used +--+--+---+--+-+--++--+ 1 row in set (0.09 sec) mysql explain select id,ticket,seq from ticketid where id like '15473%'; +--+---+---+-+-+--+--++ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+---+---+-+-+--+--++ | ticketid | range | PRIMARY | PRIMARY | 100 | NULL |2 | where used +--+---+---+-+-+--+--++ 1 row in set (0.06 sec) Fix: Does the SQL standard really require that you go through the table and evaluate its contents numerically? The 'like' operator should be able to use the index. Why doesn't it? Submitter-Id: submitter ID Originator:Matthias Urlichs Organization: noris network AG MySQL support: licence Synopsis: Bad use of index Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.34 (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/gmake /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 - 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: Question regarding query optimising with between
In the last episode (Mar 06), Christian Hammers said: I have a table with a normal multiple key on a datetime field called "end". I want to search for the number of records in some months. I know that there are none. Now "explain" tells me that a querey with a WHERE clause of end between '2001-01-01' and '2001-04-01' affects just one row whereas end '2001-01-01' affects all 705949 rows! Why this? I cannot find the docs that explain this speed enhancement. I'd even thought that a "" would be faster as it is just one check and the parser could say "every row" starting from index position X. The 'rows' column in the EXPLAIN output is just a guess based on the last results of ANALYZE TABLE. If you've added records, the guess could be off. It doesn't really matter anyway, since the select type is 'range; using index' for both queries, so they will be executed the same way by mysql. Full explain results: mysql explain select count(*) from radius0800 where ende between "2001-01-01" and "2001-04-01"; ++---+---+--+-+--+--+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | ++---+---+--+-+--+--+-+ | radius0800 | range | ende | ende | 4 | NULL |1 | where used; Using index | ++---+---+--+-+--+--+-+ 1 row in set (0.00 sec) mysql explain select count(*) from radius0800 where ende "2001-01-01"; ++---+---+--+-+--++-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | ++---+---+--+-+--++-+ | radius0800 | range | ende | ende | 4 | NULL | 705949 | where used; Using index | ++---+---+--+-+--++-+ 1 row in set (0.00 sec) -- Dan Nelson [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
Datatype for comment field
I try to create a new table and setup a datatype for comment column that has about 7000 characters long. How do I define it in Oracle? **Here's my SQL and the error I got. SQL create table test (comment varchar(7000)); ERROR --- Character field too long Thanks, David - 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
Mailing Lists.
Does anyone know any mailing lists like this one that is really good that are just about linux systems administration etc? Thanx! Mike Richards Network Administrator Harmony Integrated www.hi.ca
Re: Memory footprint
Simon Windsor wrote: Hi On two separate but identical servers I am runing MySql, 3.22, on Debian (2.2.16) kernel. Using top, one mysqld server uses 10MB whilst the other uses just 3MB. Both servers have identical configuaration files, the only difference is that server 1 is much busier. Can anyone explain why one server is 7MB bigger than the other. Simon -- Simon Windsor Hi, Have compared the number of simultaneous connections on both servers ? Each connection need some memory, this may explain the difference. Regards -- Joseph Bueno NetClub/Trader.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
Bug in 3.23.33? Or design decision?
Hi! I just upgraded from 3.22.26a to 3.23.33. We've got a database that has a table that has a column with the name: FullText. Unfortunately, now with 3.23.33, any queries that explicitly refer to this column/field return an SQL error. So far this has been tested with SELECT and UPDATE. Is this expected behavior? Or is this an actual bug? Eric A. Stewart - Network Administrator - [EMAIL PROTECTED] University of South Florida, Tampa Campus Library - Technology Work: http://www.lib.usf.edu/ | MS/MIS | ICQ# Play: http://cerebus.lib.usf.edu/ | Graduate Student | 31285736 SSI MD#100762 Mail not in plain text is annoying. - 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 WHERE statements?
Glenn Thimmes wrote: Hello everyone. I am in a real bind. I am trying to get a list of names from a table where for each name there are several specific entries. For example, the table looks like this: ContactID FactName Value for each ContactID, there may be several entries with different fact/values such as hair=red, eyes=blue, married=yes and so on. So if I want to get a list of all contactid who has 1 child and is married, I would think I should do this: SELECT * FROM contact INNER JOIN fact ON fact.contactid=contact.contactid WHERE (fact.factname='married' AND fact.value='yes') AND (fact.factname='children' AND fact.value='1') This will not work. As soon as I add the AND in the middle, it dies. If I use an OR it works, but that is not what I want. What can I do? Glenn Thimmes Software Engineer TransLux West 1651 N. 1000 W. Logan, UT 84321 435.716.8675 SELECT * FROM contact, fact as a, fact as b WHERE contact.contactid=a.contactid AND a.factname='married' AND a.value='yes' AND a.contactid=b.contactid AND b.factname='children' AND b.value='1' - 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: XML support under mySQL
On Tue, Feb 27, 2001 at 01:21:52AM +, Peter Skipworth wrote: How is this superior to SQL? It includes the letters "XML", which, apparantly, can do everything from butter your toast to giving you an orgasm like no other you've had before. Don't you just *love* buzzwords! Sorry...I had to say it =) And no, I'm not at all the cynical type...not I! XML won't even switch on my computer (well... at least not for me ;-) ). It wont wash my car. It wont feed the cat. It wont give me an orgasm of any kind. But I find it usefull to _store_ structured data... Which, afterall, and DBMS is all about. It's not about specifying an query in XML - this _may_ be an side-effect, but there certainly should be alternatives (like some extended SQL). Greetings, Florian Pflug PS: I don't _know_ if you are the cynical type, but you certainly _sound_ like the cynical type... ;-) - 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
Intermittent hang on UPDATE foo = foo + 1
Description: Sometimes the query below appears to hang on the table below. The problem seems worse on queries which come from a webserver, where persistent DB connections are used. : The online manual page hints at the same problem elsewhere: see Tomi Panula-Ontto's comment at http://www.mysql.com/doc/U/P/UPDATE.html UPDATE domain_sm SET age = age + 1, exit_time = NOW(), exit_env = '983895322:mxm5480.tc:mxm5480.tc:mxm5480.tc:mxm5480.tc:9' WHERE identity = 'mjo13684test11.tc' CREATE TABLE domain_sm ( identity varchar(63) DEFAULT '' NOT NULL, age int(11) DEFAULT '0' NOT NULL, state int(11) DEFAULT '0' NOT NULL, entry_time datetime, entry_env blob, exit_time datetime, exit_env blob, UNIQUE identity (identity,age), KEY state (state) ); Submitter-Id: submitter ID Originator:Martin Oldfield Organization: Martin Oldfield, AdamsNames Ltd. MySQL support: none Synopsis: UPDATE command can sometimes hang Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.22.32 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686 TCX Datakonsult AB, by Monty Server version 3.22.32-log Protocol version10 Connection ptolemy via TCP/IP TCP port3306 Uptime: 20 days 1 hour 24 min 22 sec Threads: 47 Questions: 5773313 Slow queries: 5671 Opens: 68799 Flush tables: 1 Open tables: 63 Environment: System: Linux joanna 2.2.17 #1 Thu Oct 19 16:36:18 BST 2000 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs gcc version 2.95.2 2220 (Debian GNU/Linux) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Configure command: ./configure --enable-shared --without-readline --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.sock --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc/mysql --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man Perl: This is perl, version 5.005_03 built for i386-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: Default values
Try giving a number instead of a string as a default for an int. Also, what do you mean by blank? If you pass '' as a value, it will become 0 when converted to an int. What happens if you omit the column completely on the insert? "MikeBlezien" wrote: Hello All, I've created a table(using MySQL 3.23.33), using default values: DROP TABLE IF EXISTS referral; CREATE TABLE referral ( refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL, refer_fname varchar(20) DEFAULT '' NOT NULL, refer_lname varchar(20) DEFAULT '' NOT NULL, refer_email varchar(40) DEFAULT '' NOT NULL, UNIQUE INDEX idx_refid (refer_id) ) TYPE=MYISAM; It creates the table, no problems. But for some reason, if the refer_id is left blank during an INSERT, it defaults to "0" and not 100 ?? is this because of the UNIQUE INDEX on this column?? If your wonder, the refer_id is assigned a random 5 digit number within the Perl program. I was just testing to see if it would assign the default value if no value was assigned during an insert. Any suggestion appreciated. Mickalo Thanks, Mike(mickalo)Blezien - 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
file insertion?
Hi, Is it possible to insert a file into the MySQL database? I want a table with certain entries such as name, address etc. but I also I a photo for each member. Is that possible? Thanks, Kev.
Re: Default values
On Tue, 6 Mar 2001 11:14:36 +0100, Fred van Engen [EMAIL PROTECTED] wrote: Thanks Fred, INSERT INTO referral VALUES (NULL, 'xxx.yyy', 'xxx.yyy', '[EMAIL PROTECTED]'); But an INSERT like this: This is where I was making the mistake! It works fine now. I was inserting an blank empty value instead of NULL! DUH!!... INSERT INTO referral VALUES ('', 'xxx.yyy', 'xxx.yyy', '[EMAIL PROTECTED]'); will probably use 0 for refer_id or give an error message. You do supply a value in this case, so no default wil be used. Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - 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.sock Error
My database was working fine then the server crashed and now I am getting this error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) I have checked and verified that the file exists: srwxrwxrwx 1 root root0 Jan 16 23:00 mysql.sock It seems to have 0 bytes but it is there. I have rebooted my server, and I am still getting the error. I don't want to lose what I have in my database is there anyway of fixing this, I have searched the documentation and the only thing on mysql.sock is how to protect it from being deleted. Any help on how to go about fixing this is greatly appreciated. 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
ODBC Driver documentation
Hi, I'm working in a project to simulate the database servers efficiency. The system consists in some modules, one of that is a protocol analyser (to spy the net). My problem, is that I need to work with Oracle servers, and I don't have the Oracle SQLNet protocol, so I decided to make an ODBC driver that operate as an spy, saving all the SQL sentences send by the client application, and then send it to the real ODBC Driver. This idea is very usefull, because, it could be used to work with all database engines that uses ODBC drivers ... MS ODBC -> Spy -> OracleODBC, MyODBC, ... | v XML file with the SQL statements Where can I find the ODBC API Documentation to create a new ODBC driver? and the JDBC API? Thanks, Fernando. - 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 Crash on ALTER TABLE
Running 3.23.33 on Windows 2000 Server. I have noticed that executing an ALTER TABLE works... but the next query on the alter table crashes MySQL and corrupts the table. If I FLUSH TABLES after an ALTER TABLE, it seems to reduce the occurance, but should this be required? [EMAIL PROTECTED] National Aeronautics and Space Administration -- S c i e n c e @ N A S A -- http://science.nasa.gov/ INFORM - the fast paced expansion of knowledge http://kids.msfc.nasa.gov/ INSPIRE - the future belongs to our children http://liftoff.msfc.nasa.gov/ INVOLVE - today's dreams, tomorrow's reality. - 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: troubles with joining list
Well yes, i had troubles with the list as well - i did not see any message on nor the mysql list nor the win32-mysql list... i figured i could be our is' mail server, so i offered to join the list with another e-mail account. I only got it confirmed after 24 hours... So there are networking problems going on, but I couldn't dare to tell where the problem is. As far as i noticed the list just continued this week-end. So, my guess is: some traffic jam on the internet. Maybe others experienced problems as well.. regards, rene - Original Message - From: "Network" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 11:06 AM Subject: troubles with joining list I don't see an address for the list owner so I'm mailing this here in hope of getting help. Why is the connection constantly resetting and not allowing me to join the list? This mail also serves as a test to see if I can post to the list without joining via [EMAIL PROTECTED] Mar 6 04:34:49 Imani sendmail[90483]: f269Hm190455: to=[EMAIL PROTECTED], ctladdr=[EMAIL PROTECTED] (1000/69), delay=00:17:01, xdelay=00:05:00, mailer=esmtp, pri=120439, relay=lists.mysql.com. [192.58.197.162], dsn=4.0.0, stat=Deferred: Connection reset by lists.mysql.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 - 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 values
On Tue, 6 Mar 2001, MikemickaloBlezien wrote: Try giving a number instead of a string as a default for an int. Not sure I follow, it is a number?? refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL, Your '100' is a string. Try something like this: refer_id int(10) UNSIGNED NOT NULL DEFAULT 100, Regards, Jan-Aage -- Mr. Jan-Aage Bruvoll Managing Director Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK Office/fax: +44 20 72408283 Mobile: +44 7740291600 - 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
Weird select with php
I'm attempting to do a select from my table, but the only odd thing is the customer wants the results to be completely random every time... is there anything like this?? $query = "SELECT * FROM members where Name like 'A%' ORDER BY random"; Matt "Trollboy" Wiseman www.shoggoth.net/trollboy/trollboy.jpg [EMAIL PROTECTED] "I wish the world had one throat!!" -Al Bundy - 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
kill bad query
If I have a connection that executes a bad query shouldn't I ALWAYS be able to kill it with "kill connect num"? I have a query that keeps getting stuck, (who knows what it is doing) but that State is "statistics" I can't ever kill it without taking down the server.. - 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 can't start
If it seems interesting for somebody, I find what a problem. I mean, I can neutralize problem. Mysql started to works after I boot system with kernel 2.2.3 (before I used 2.2.14). I think, impotant difference between its kernels are in system function sys_rt_sigsuspend. Any time, in kernel 2.2.3 it function isn't present and with this kernel mysql work correctly. Why mysql stopped to work on kernel 2.2.14 after 6 month, I can't understand. -Original Message- From: Sergey Yegorov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 10:10 AM To: [EMAIL PROTECTED] Subject: mysql can't start (sorry for my english, I am from Russia) I have a problem this MySQL on my linux (2.2.14) server. In some pretty day after reboot MySQL-server (3.22.25) stopped to answer on any exposure. I tried to do something and after all remove it completely and install again - nothing happens. I install MySQL on another server - it's work so funny. I upgrade MySQL to 3.23.33 - nothing happens. - 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 clIENT
MySQL-client-VERSION.i386.rpm The standard MySQL client programs. You probably always want to install this package. What is the MySQL Client used for?
sql date worries
Hi all, Im kind of strugling with a query for some time now and I need extra input: What is the desired answer from mysql: a date. what is the input: a week number What dat do I need: The date of the monday (week starts at sunday) in the weeknumber. something like: select date(week(10),1); But this doesn't work. Anyone any idea's? I'm blocked.. - 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
Bug with 'show databases|tables'
Description: I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14 all 'show' commands doesn't works. They display empty tables. How-To-Repeat: Install RedHat 7.0 on Intel platform, apply all updates from RedHat (up to March, 01 2001), compile kernel 2.2.17-14 from kernel-sources package, then compile MySQL from RPM supplied by www.mysql.com. Compiling went OK and MySQL can be installed. By we will always get such strange results for 'show' commands: $ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.33-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | | | | | +--+ 8 rows in set (0.00 sec) mysql use UNEXISTANT; ERROR 1049: Unknown database 'UNEXISTANT' mysql use mysql; Database changed mysql show tables; Empty set (0.00 sec) As we can see, there are AVAILABLE databases, but 'show databases' doesn't displays anything. We can make 'use' with correct names, can't with unexistant, but the tables in database can't be reached. BTW, I have found the dependence of number in line ('8 rows in set) above - it corresponds to number of entries in /var/lib/mysql/ directory: $ ls -a /var/lib/mysql/ . Phantom.log Phantom.tsk.ru.pid mysql.sock .. Phantom.tsk.ru.err mysql test There are total 8 files (with '.' and '..' entries). We can create one more file by peforming 'touch /var/lib/mysql/asdf' and here are new mysql report: mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | | | | | | | +--+ 9 rows in set (0.00 sec) Very strange, isn't it ?.. And what is more, I _have_ tried to undefine the HAVE_READDIR_R in config.h . The same results... I have tried to compile OLD MySQL (version 3.22.32), it works with absolutelly the same problems. Fix: I doesn't know how to correct this. I'll be very thankful if someone help me... Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: none MySQL support: none Synopsis: The bug with empty 'show databases' results. Linux RedHat 7.0 i386 Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.33 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.15 Distrib 3.23.33, 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.33-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 13 min 1 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.016 Environment: System: Linux Phantom.tsk.ru 2.2.17-14 #1 Tue Mar 6 03:05:11 TSK 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='egcs' CFLAGS=' -O6' CXX='egcs' CXXFLAGS=' -O6 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 11 Mar 5 17:37 /lib/libc.so.6 - libc-2.2.so -rwxr-xr-x1 root root 5155229 Jan 11 07:09 /lib/libc-2.2.so -rw-r--r--1 root root 24498288 Jan 11 06:35 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 11 06:35 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Mar 6 00:23 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-charset=koi8_ru --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db
Running a Query Append in Access 97 with a linked MySQL table
Hello I have uploaded a table from Access 97 to the MySQL database and apart from changing the name from "Mailing List" to " Mailing_List" it appears fine. Now that I am putting data into the linked MySQL table in a "live " environment I need the MySQL table to update the Access records and vica versa. When I try either way to run a Query Append I get as far as the fields and when I try to run the append the message says that the field "web_site" has an incorrect name. In my original table called the field "web sites" and MySQL has underscored it, but I am calling the field the same as MySQL calls it and it still wont recognise it. It does not work the other way either, from Access to the MySQL linked table, whatever I call the "web site" column it just has a problem with that column. Even if I delete the column it still wont append and update the data. Any ideas? Peter Worthington - 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
ODBC - Trouble once again
... i forgot i am not registered list user so please answer on priv thx
ODBC trouble - please help
I 've got problem with ODBC support for Microsoft Access Very ofeten i can't edit records because one error. ODBC driver says "there is another user editing same record in this time" This isn't true - because i work alone :-( Is anyone who can help me? Thanks Wojtek
Re: turn of column headings
You wrote: hello there, i am a novice, so bear with this rather trivial question. how do i turn off the column-headers for select statements in mysql?? couldn't find any help with the online manual. waiting. praveen If you're running the mysql client, try adding the command line switch -N. -- Paul *** Paul A. RubinPhone:(517) 432-3509 Department of Management Fax: (517) 432- The Eli Broad Graduate School of Management E-mail: [EMAIL PROTECTED] Michigan State Universityhttp://www.msu.edu/~rubin/ East Lansing, MI 48824-1122 (USA) *** Mathematicians are like Frenchmen: whenever you say something to them, they translate it into their own language, and at once it is something entirely different.J. W. v. GOETHE - 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: DBD::mysql
I haven't done what you are trying to do, but I suspect you will need at least the MySQL-shared libraries on your system. On Tuesday, March 6, 2001, at 06:57 AM, John Tsangaris wrote: Tried sending this once and it didn't go through. - I am trying to install DBD::mysql on a server which does not have mysql on it. ( The script will be accessing a mysql database on another server). The problem is, when I try to install dbd::mysql I am asked several questions.. one of which being: what is the path to mysql? I don't have a path to mysql as it is not installed and I don't want to install it. Is there a way to install DBD::mysql without having to install mysql? John ===END FORWARDED MESSAGE=== - 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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=- Michael A. Peters Abriasoft Senior Developer http://www.abriasoft.com/ (510) 623-9726x357 Fax: (510) 249-9125 - 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
Lost connection while doing query
Hello, I am running MYSQL 3.23.34 on NT. I have two processes running at the same time trying to access same database file. Process A : repeatedly doing - open, write one record, close. Process B : repeatedly doing - open, read, close. Both process stars and the process B will be aborted by MYSQL and the error message : Lost Connection while doing query. I have set max_connection = 256. Does anybody have any idea about the cause and how to fix it ? Thanks a lot. Perl. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.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
query with OR
I am having trouble getting this query to run faster: SELECT * FROM t1 WHERE col1 = 'text' OR col2 = 'text'; Here is the output of the explain for that query +---+--+---+--+-+--+--+- ---+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+--+- ---+ | users | ALL | col1,col2 | NULL |NULL | NULL | 1321 | where used | +---+--+---+--+-+--+--+- ---+ Here is the "show index from t1": +---++-+--+-+--- +-+--++-+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---++-+--+-+--- +-+--++-+ | users | 1 | col1_2 |1 | col1 | A | 124114 | NULL | NULL | | | users | 1 | col1_2 |2 | col2 | A | 124114 | NULL | NULL | | | users | 1 | col2 |1 | col2 | A | 124114 | NULL | NULL | | +---++-+--+-+--- +-+--++-+ If I split the query into two, ie: SELECT * FROM t1 WHERE col1 = 'text'; SELECT * FROM t1 WHERE col2 = 'text'; Both complete in no time at all, however the query with the OR takes a few seconds. How can I make the query take advantage of the indexes better? Thanks for the help! ryan - 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
desperate for help...
Ok, I've been battling this SELECT statement for the better part of the day. The SELECT statement is this: SELECT DISTINCT request.id AS requestid, request.date, request.type, request.status, faculty.f_name, faculty.l_name, action.id AS actionid, faculty.id AS facultyid FROM faculty, request, action WHERE request.id=action.request_id AND request.requested_by=faculty.id AND request.status=0; And the results are here: http://www.geology.ohio-state.edu/test/rfatest/rfaadmin.php?closed=Closed Now, if you look at the table, at the far left cell under RFA#, you'll notice that they are all the same (2). That is because there were 4 actions performed on RFA # 2. However, I only need for the column to be displayed once. When the user clicks under 'last action' then they can see all 4 actions. But for this table, I just need to show the data once. So, could any kind soul help me out? 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
winmysqladmin (fwd)
dear, I have installed mysql for windows NT. I installed the mysql is for support my PHP-NUKE. In PHP NUKE, there is file "nuke.sql" may be its content of the table of NUKE. So, my question is 1. how to made the table in winmysqladmin and entry the list (like field, type at table columns) 2. how to use this program, and what for it is (would you mind to explain it)? at last, I'm sorry if my english so bad and Thanks a lot Sincerely, noviar JK [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
INSERT question...
Hi-o! I was wondering if it's possible when inserting a value into a table that has an auto_increment field to have MySQL return the value of the auto_increment field right after doing the insert, w/out having to run a seperate query? For example if I had a table with two collums, ID and name. Where ID is an int field with auto_increment set, and is the primary key. and name is just a varchar. and did this: INSERT INTO some_table (name) VALUES("bob"); I'd like for the query to return the value for ID that was just assigned. Is there a way to do this all in one SQL statement? Thanks in advance! "Listen: We are here on Earth to fart around. Don't let anybody tell you any different!" - Kurt Vonnegut Josh Burroughs [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
Multi primary keys
Hi, I just discovered with mysql 3.22.32 that it is possible to make a table with more than one primary key. Shouldn't that be impossible? Thanks, Eric Frazier Consulting http://www.kwinternet.com/eric (250) 655 - 9513 - 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: Bug in 3.23.33? Or design decision?
fulltext is now a reserved word - either change the name of the field, or use quotes when refering to it. regards, P On Tue, 6 Mar 2001 [EMAIL PROTECTED] wrote: Hi! I just upgraded from 3.22.26a to 3.23.33. We've got a database that has a table that has a column with the name: FullText. Unfortunately, now with 3.23.33, any queries that explicitly refer to this column/field return an SQL error. So far this has been tested with SELECT and UPDATE. Is this expected behavior? Or is this an actual bug? Eric A. Stewart - Network Administrator - [EMAIL PROTECTED] University of South Florida, Tampa Campus Library - Technology Work: http://www.lib.usf.edu/ | MS/MIS | ICQ# Play: http://cerebus.lib.usf.edu/ | Graduate Student | 31285736 SSI MD#100762 Mail not in plain text is annoying. - 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: file insertion?
On 06-Mar-01 Kevin Connolly wrote: Hi, Is it possible to insert a file into the MySQL database? I want a table with certain entries such as name, address etc. but I also I a photo for each member. Is that possible? Thanks, Kev. Yes. Ok. Yes, LOAD_FILE(). Welcome. Regards, -- Don Read [EMAIL PROTECTED] -- If you are going to sin, sin against God, not the bureaucracy. God will forgive you but the bureaucrats won't. - 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 got signal 11
Hi, I'm using mysql-3.23.30 Linux binary downloaded directly from the mysql site, and after a while the server tanks and many copies of this are all over the error log: Number of processes running now: 0 010306 09:19:24 mysqld restarted /usr/local/mysql/bin/mysqld: ready for connections mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong frame pointer (ebp) is NULL, did you compile with -fomit-frame-pointer? Aborting backtrace I assume the binary is compiled with -fomit-frame-pointer. This problem seems repeatable, but only after several days. This server is used for three things: 1) Logging (using insert delayed), 2) a cache system (normal inserts), and 3) a set of fulltext tables (using replace delayed). The server has worked flawlessly for months over various mysql versions including this one. Only when the replace delayed (and selects) on the fulltext tables occurs, does this appear. Is there a binary of a debug version for Linux? I'd like to catch the server going down with more information. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - 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: mysqld got signal 11
Hi, OK, I now still have the same problem after upgrading to 3.23.33-pc-linux-gnu-i686 binary. After myisamchking all tables, this time it took just about one minute before crashing: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong Bogus stack limit or frame pointer, aborting backtrace Number of processes running now: 0 010306 15:13:38 mysqld restarted I'm off to compiling a debug version. :( Will send a real bug report if it dies again. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - 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: mysqld got signal 11
Hi, Ah, today's problems are from a bug that dates back a year or more. Streaming a large number of insert delayeds into a table that does not exist causes the crash. The table was not created correctly last night. Is there a web version of mysql code like PHP has http://lxr.php.net ? I'd like to browse through and see what I can find, but using vi is just not worth my time. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - 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
Antwort: Bug in 3.23.33? Or design decision?
On 06.03.2001 19:05:34 iso-8859-1 wrote: Is this expected behavior? Or is this an actual bug? I suppose this may be expected behavior, as FullText now is a reserved word in MySQL - 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: Bug with 'show databases|tables'
Description: I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14 all 'show' commands doesn't works. They display empty tables. How-To-Repeat: Install RedHat 7.0 on Intel platform, apply all updates from RedHat (up to March, 01 2001), compile kernel 2.2.17-14 from kernel-sources package, then compile MySQL from RPM supplied by www.mysql.com. The compiler shipped with Redhat 7.0 is broken (it is a beta GCC!). The compiler requirements are explained in the Manual. Rather use the binary RPM's supplied by MySQL team. Or downgrade to Redhat 6.2 if you want a stable system. I don't think 7.0 is ready for real production work. -- Richard Ellerbrock [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: ODBC trouble - please help
Ensure each table has a TIMESTAMP(14) and a PRIMARY KEY (recommend an AUTO_INCREMENT field). Pat... - Original Message - From: "Wojciech Spychaa" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 07, 2001 4:14 AM Subject: ODBC trouble - please help I 've got problem with ODBC support for Microsoft Access Very ofeten i can't edit records because one error. ODBC driver says "there is another user editing same record in this time" This isn't true - because i work alone :-( Is anyone who can help me? Thanks Wojtek - 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: Bug with 'show databases|tables'
Eugene Lineitzev wrote: Description: I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14 all 'show' commands doesn't works. They display empty tables. How-To-Repeat: Install RedHat 7.0 on Intel platform, apply all updates from RedHat (up to March, 01 2001), compile kernel 2.2.17-14 from kernel-sources package, then compile MySQL from RPM supplied by www.mysql.com. Compiling went OK and MySQL can be installed. By we will always get such strange results for 'show' commands: $ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.33-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | | | | | +--+ 8 rows in set (0.00 sec) mysql use UNEXISTANT; ERROR 1049: Unknown database 'UNEXISTANT' mysql use mysql; Database changed mysql show tables; Empty set (0.00 sec) As we can see, there are AVAILABLE databases, but 'show databases' doesn't displays anything. We can make 'use' with correct names, can't with unexistant, but the tables in database can't be reached. BTW, I have found the dependence of number in line ('8 rows in set) above - it corresponds to number of entries in /var/lib/mysql/ directory: $ ls -a /var/lib/mysql/ . Phantom.log Phantom.tsk.ru.pid mysql.sock .. Phantom.tsk.ru.err mysql test There are total 8 files (with '.' and '..' entries). We can create one more file by peforming 'touch /var/lib/mysql/asdf' and here are new mysql report: mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | | | | | | | +--+ 9 rows in set (0.00 sec) Very strange, isn't it ?.. And what is more, I _have_ tried to undefine the HAVE_READDIR_R in config.h . The same results... I have tried to compile OLD MySQL (version 3.22.32), it works with absolutelly the same problems. Fix: I doesn't know how to correct this. I'll be very thankful if someone help me... Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: none MySQL support: none Synopsis: The bug with empty 'show databases' results. Linux RedHat 7.0 i386 Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.33 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.15 Distrib 3.23.33, 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.33-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 13 min 1 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.016 Environment: System: Linux Phantom.tsk.ru 2.2.17-14 #1 Tue Mar 6 03:05:11 TSK 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='egcs' CFLAGS=' -O6' CXX='egcs' CXXFLAGS=' -O6 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 11 Mar 5 17:37 /lib/libc.so.6 - libc-2.2.so -rwxr-xr-x1 root root 5155229 Jan 11 07:09 /lib/libc-2.2.so -rw-r--r--1 root root 24498288 Jan 11 06:35 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 11 06:35 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Mar 6 00:23 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-charset=koi8_ru --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc
Re: Sending data, but no data sent?
[EMAIL PROTECTED] writes: Description: Selecting for a number in a char table is REALLY slow. How-To-Repeat: Large table, main index on column 'id' varchar(100). mysql select id from ticketid where id = '15473'; Empty set (0.00 sec) mysql select id from ticketid where id = 15473; +--+ | id | +--+ | [EMAIL PROTECTED] | | [EMAIL PROTECTED] | | [EMAIL PROTECTED] | +--+ 3 rows in set (3 min 49.81 sec) mysql select id from ticketid where id = 15473 and id like '15473%'; +--+ | id | +--+ | [EMAIL PROTECTED] | | [EMAIL PROTECTED] | | [EMAIL PROTECTED] | +--+ 3 rows in set (4 min 6.83 sec) Say what ??? mysql explain select id,ticket,seq from ticketid where id = 15473 and id like '15473%'; +--+--+---+--+-+--++--+ | table| type | possible_keys | key | key_len | ref | rows | Extra| +--+--+---+--+-+--++--+ | ticketid | ALL | PRIMARY | NULL |NULL | NULL | 406867 | where used +--+--+---+--+-+--++--+ 1 row in set (0.09 sec) mysql explain select id,ticket,seq from ticketid where id like '15473%'; +--+---+---+-+-+--+--++ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+---+---+-+-+--+--++ | ticketid | range | PRIMARY | PRIMARY | 100 | NULL |2 | where used +--+---+---+-+-+--+--++ 1 row in set (0.06 sec) Fix: Does the SQL standard really require that you go through the table and evaluate its contents numerically? The 'like' operator should be able to use the index. Why doesn't it? Submitter-Id: submitter ID Originator: Matthias Urlichs Organization: noris network AG MySQL support: licence Synopsis: Bad use of index Severity: serious Priority: medium Category: mysql Class: sw-bug Release:mysql-3.23.34 (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/gmake /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! First of all, where have you got 3.23.34 when it is not out ?? Second what type of column is id and what does PRIMARY KEY consist of. Third --with-debug is slower then without. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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
Beginner Help, can't get it started, but did in the past
Hello all, I hope someone can help. I have a fresh install of Red Hat 7.0, I installed mysql-3.23.22-6.i386.rpm and then mysql-server-3.23.22-6.i386.rpm. Supposedly the daemon is automatically starts, well it doesn't. I tried the mysql_install_db and it runs, but I don't think it makes the databases because when I try to start the daemon with safe_mysqld it says it tries to open the databases in /var/lib/mysql, shouldn't there be a data directory or something? I don't know, but it can't find them because the script immediately ends. The listing of the /var/lib/mysql is localhost.localdomain.err mysql/ mysql.sock= test/ Any help would be appreciated, I have a school project deadline coming up with JDBC and my problem is with this database more than the code. I would prefer to use mysql, but if I can't get it running, I might have to use MSAccess :-( Thanks in advance, Joe - 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: key lengths
BLOBS and TEXT columns used as indices require the length to be specifically enumerated. (Sec 7.26 of the manual) CREATE TABLE foo( id INT NOT NULL AUTO_INCREMENT, name BLOB NOT NULL, PRIMARY KEY(id), UNIQUE(name(500)) ); Pat... [EMAIL PROTECTED] - Original Message - From: "Mike Thompson" [EMAIL PROTECTED] To: "mysql" [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 1:51 PM Subject: key lengths How is key length for a table defined? It seems that the default is 255 bytes, but in the online docs it mentions 500 byte keys. I happen to have some very long case sensitive strings that I need to use as keys, but mysql complains when I try to create a table as such CREATE TABLE foo( id INT NOT NULL AUTO_INCREMENT, name BLOB NOT NULL, PRIMARY KEY(id), UNIQUE(name) ); Any thoughts? --m - 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: Antwort: Datatype for comment field
I would recommend the book MySQL by Paul Dubois to anybody that want to do some seriou work on MySQL . It is a really god book with everything explained. I am not earning money by recommending it nor have any financial ties with them. I am just a satisfied customer of that book From: [EMAIL PROTECTED] To: "Nguyen, David M" [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Antwort: Datatype for comment field Date: Wed, 7 Mar 2001 11:25:02 +0100 On 06.03.2001 18:43:32 Nguyen, David M wrote: I try to create a new table and setup a datatype for comment column that has about 7000 characters long. How do I define it in Oracle? That's the MySQL mailing list, you know No idea how to do stuff in Oracle. **Here's my SQL and the error I got. SQL create table test (comment varchar(7000)); ERROR --- Character field too long See this? v http://www.mysql.com/manual.php (the manual) It's in there how long a varchar can be. But before flaming starts: VarChar can take no more than 255 characters. - 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 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
Re: MySQL Crash on ALTER TABLE
Meyer, Patrick writes: Running 3.23.33 on Windows 2000 Server. I have noticed that executing an ALTER TABLE works... but the next query on the alter table crashes MySQL and corrupts the table. If I FLUSH TABLES after an ALTER TABLE, it seems to reduce the occurance, but should this be required? [EMAIL PROTECTED] National Aeronautics and Space Administration -- S c i e n c e @ N A S A -- http://science.nasa.gov/ INFORM - the fast paced expansion of knowledge http://kids.msfc.nasa.gov/ INSPIRE - the future belongs to our children http://liftoff.msfc.nasa.gov/ INVOLVE - today's dreams, tomorrow's reality. Hi! Can you please try to make a repeatable test case. It should consist of CREATE TABLE statement for the table, plus INSERT's to insert few rows, then ALTER TABLE and query that crashes MySQL. When you prepare it, please upload the file to our FTP server on support.mysql.com , directory /pub/mysql/Incoming and let us know a file name . Many thanks in advance. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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: mysqld got signal 11
You may have a corrupt library or mysqld. Signal 11 is a memory error (likely overwrite). I would try deleting and reinstalling mysqld from a fresh download. Pat... [EMAIL PROTECTED] - Original Message - From: "Steven Roussey" [EMAIL PROTECTED] To: "Mysql" [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 6:29 PM Subject: Re: mysqld got signal 11 Hi, OK, I now still have the same problem after upgrading to 3.23.33-pc-linux-gnu-i686 binary. After myisamchking all tables, this time it took just about one minute before crashing: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong Bogus stack limit or frame pointer, aborting backtrace Number of processes running now: 0 010306 15:13:38 mysqld restarted I'm off to compiling a debug version. :( Will send a real bug report if it dies again. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - 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: Sending data, but no data sent?
Hi, Sinisa Milivojevic: First of all, where have you got 3.23.34 when it is not out ?? It's the version in your current BitKeeper archive. Second what type of column is id and what does PRIMARY KEY consist of. explain ticketid; Field Type Null Key Default Extra id varchar(100) PRI ticket int(11) MUL 0 sender int(11) MUL 0 added int(11) YES NULL seqint(11) 0 extern char(1) YES NULL inhalt mediumtext YES NULL typsmallint(6) YES NULL d_data int(11) YES NULL show index from ticketid; TableNon_unique Key_name Seq_in_index Column_name Collation ticketid 0 PRIMARY 1 id A ticketid 1 ticket 1 ticket A ticketid 1 ticket 2 seq A ticketid 1 sender_i1 sender A Third --with-debug is slower then without. But not that much slower... -- Matthias Urlichs | noris network AG | http://smurf.noris.de/ - 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 problem with MySQL UDFs
Hi! I have a problem with UDF. For acceleration of spell check I needed in UDF function which be able to replace substrings based on regular expressions. Such PHP functions are ereg_replace and preg_replace. Trying to write UDF for MySQL I has confronted with a strange problem. At compilation in a separate executed file my function works correctly and gives out correct results. But when the same function I compile as UDF - I recive interesting effects. MySQL at performance UDF through times breaks off connection. And when the connection does not break off - than MySQL gives out wrong results. I already have despaired to force UDF to work. I use MySQL-3.23.33 on Slackware Linux with 2.4.2 kernel This is source: #ifdef STANDARD #include stdio.h #include string.h #else #include global.h #include my_sys.h #endif #include mysql.h #include m_ctype.h #include m_string.h #include regex.h #define NS 10 #ifdef HAVE_DLOPEN char* reg_replace(char* string, char* pattern, char* replace, int icase, int extended); extern "C" { my_bool ereg_replace_init(UDF_INIT *initid, UDF_ARGS *args, char *message); char* ereg_replace(UDF_INIT *initid, UDF_ARGS *args, char *result, unsigned long *length, char *is_null, char *error); my_bool eregi_replace_init(UDF_INIT *initid, UDF_ARGS *args, char *message); char* eregi_replace(UDF_INIT *initid, UDF_ARGS *args, char *result, unsigned long *length, char *is_null, char *error); } my_bool ereg_replace_init(UDF_INIT *initid, UDF_ARGS *args, char *message) { if (args-arg_count != 3 || args-arg_type[0] != STRING_RESULT || args-arg_type[1] != STRING_RESULT || args-arg_type[2] != STRING_RESULT ) { strcpy(message,"ereg_replace require 3 string arguments"); return 1; } return 0; } char *ereg_replace(UDF_INIT *initid, UDF_ARGS *args, char *result, unsigned long *length, char *is_null, char *error) { if (result = reg_replace(args-args[0], args-args[1], args-args[2], 0, 1)) { *length = strlen(result); return result; } else { *is_null = 1; return result; } } my_bool eregi_replace_init(UDF_INIT *initid, UDF_ARGS *args, char *message) { if (args-arg_count != 3 || args-arg_type[0] != STRING_RESULT || args-arg_type[1] != STRING_RESULT || args-arg_type[2] != STRING_RESULT ) { strcpy(message,"eregi_replace require 3 string arguments"); return 1; } return 0; } char *eregi_replace(UDF_INIT *initid, UDF_ARGS *args, char *result, unsigned long *length, char *is_null, char *error) { if (result = reg_replace(args-args[0], args-args[1], args-args[2], 1, 1)) { *length = strlen(result); return result; } else { *is_null = 1; return result; } } char* reg_replace(char* string, char* pattern, char* replace, int icase, int extended) { char *result; regex_t* re; regmatch_t* subs; char *buf, *nbuf, *walkbuf; const char *walk; int buf_len; int pos, tmp, string_len, new_l; int err, copts = 0; string_len = strlen(string); if (icase) copts = REG_ICASE; if (extended) copts |= REG_EXTENDED; re = (regex_t*) malloc(sizeof(regex_t)); subs = (regmatch_t*) malloc(sizeof(regmatch_t)*NS); err = regcomp(re, pattern, copts); if (err) { result = (char*) malloc(strlen(string) + 1); memcpy(result, string, strlen(string)+1); free(re); free(subs); return result; } buf_len = 2 * string_len + 1; buf = (char*) malloc(buf_len * sizeof(char)); if (!buf) { regfree(re); free(re); free(subs); return 0; } err = pos = 0; buf[0] = '\0'; while (!err) { err = regexec(re, string[pos], (size_t) NS, subs, (pos ? REG_NOTBOL : 0)); if (!err) { new_l = strlen(buf) + subs[0].rm_so; walk = replace; while (*walk) if ('\\' == *walk '0' = walk[1] '9' = walk[1] subs[walk[1] - '0'].rm_so -1 subs[walk[1] - '0'].rm_eo -1) { new_l += subs[walk[1] - '0'].rm_eo - subs[walk[1] - '0'].rm_so; walk += 2; } else { new_l++; walk++; } if (new_l + 1 buf_len) { buf_len = 1 + buf_len + 2 * new_l; nbuf = (char*) malloc(buf_len); memcpy (nbuf, buf, strlen(buf)+1); free(buf); buf = nbuf; } tmp = strlen(buf); buf[strlen(buf) + subs[0].rm_so + 1] = 0; memcpy(buf + strlen(buf), string[pos], subs[0].rm_so); walkbuf = buf[tmp + subs[0].rm_so]; walk = replace; while (*walk) if ('\\' == *walk '0' = walk[1] '9' = walk[1] subs[walk[1] - '0'].rm_so -1 subs[walk[1] - '0'].rm_eo -1) { tmp = subs[walk[1] - '0'].rm_eo - subs[walk[1] - '0'].rm_so; memcpy (walkbuf, string[pos + subs[walk[1] - '0'].rm_so], tmp); walkbuf += tmp; walk += 2; } else *walkbuf++ = *walk++; *walkbuf = '\0'; if (subs[0].rm_so == subs[0].rm_eo) { if (subs[0].rm_so + pos = string_len) break; new_l = strlen (buf) + 1; if (new_l + 1 buf_len) { buf_len = 1 + buf_len + 2 * new_l; nbuf = (char*) malloc(buf_len * sizeof(char)); memcpy
MyODBC - displaying EUC-JP characters
Hi, I have downloaded the latest version of MyODBC2.50.36NT and finished my setup. Now everything works fine if I display ASCII But if my table contains EUC-JP characters they dont get displayed properly. My SQL Server is running on RedHat Linux7.0 with Mysql3.23.33. I am using Access 2000 NT4.0. I got the following from MyODBC's readme file: If you are connecting to a server with a character set that isn't compiled into the MySQL client library (the defaults are: latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis ) then you need to install the mysql character definitions from the charsets directory into the c:\mysql\share\charsets. how do I do this, where do I find the charsets? Does ODBC look for charsets under c:\mysql\share\charsets always? Is there a way I can tell ODBC to perform the encoding always? Am I missing anything? Please help. -Thiru -o0o "There is no finish line, you can always learn" "You have to keep pressure on yourself, you have to work on your weaknesses". Thiru S/W Engineer, Service Dvlpment Group Infoseek,Japan http://www.infoseek.co.jp - 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: Bug with 'show databases|tables'
On Wednesday 07 March 2001 12:43, Richard Ellerbrock wrote: Description: I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14 all 'show' commands doesn't works. They display empty tables. How-To-Repeat: Install RedHat 7.0 on Intel platform, apply all updates from RedHat (up to March, 01 2001), compile kernel 2.2.17-14 from kernel-sources package, then compile MySQL from RPM supplied by www.mysql.com. The compiler shipped with Redhat 7.0 is broken (it is a beta GCC!). The compiler requirements are explained in the Manual. Rather use the binary RPM's supplied by MySQL team. Or downgrade to Redhat 6.2 if you want a stable system. I don't think 7.0 is ready for real production work. Based on any experience? We have been using it for more than 3 months with no problems with the binaries from mysql.com. As for compiling, the latest gcc rpm updates should do the job, last I heard, but I have not tried it since the binaries work just fine. -- Jean-Luc Fontaine - 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: Sending data, but no data sent?
Matthias Urlichs writes: Hi, Sinisa Milivojevic: First of all, where have you got 3.23.34 when it is not out ?? It's the version in your current BitKeeper archive. Second what type of column is id and what does PRIMARY KEY consist of. explain ticketid; Field Type Null Key Default Extra id varchar(100) PRI ticket int(11) MUL 0 sender int(11) MUL 0 added int(11) YES NULL seqint(11) 0 extern char(1) YES NULL inhalt mediumtext YES NULL typsmallint(6) YES NULL d_data int(11) YES NULL show index from ticketid; TableNon_unique Key_name Seq_in_index Column_name Collation ticketid 0 PRIMARY 1 id A ticketid 1 ticket 1 ticket A ticketid 1 ticket 2 seq A ticketid 1 sender_i1 sender A Third --with-debug is slower then without. But not that much slower... -- Matthias Urlichs | noris network AG | http://smurf.noris.de/ After taking a look at your table, the answer to your question is YES. varchar(100) is too large for index. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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: winmysqladmin
I seem to get integer size exceeded error windows popping up using winmysqladmin (1.0) against mysqld-opt (3.23.22). This is all on a WIN98 Second Edition box. Any clues? (sorry for the vagueness, it's occurring on a machine not within my immediate reach) Pat... - 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 to Oracle
Can anybody tell me what datatype exists in Oracle that is similar or could be used instead of BIGINT and TIMESTAMP. Also, what does the LIMIT # expression do in the select query. Can this be converted to be used in Oracle somehow? Thanks Totalise - the Users ISP -- To become a member and a shareholder - visit the site at www.totalise.co.uk giving the username mashood.ahmed --- InterMutual Healthcare from Totalise. Peace of mind at an affordable price. Visit http://www.intermutual.com/health/ - 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: mysqld got signal 11
Steven Roussey writes: Hi, Ah, today's problems are from a bug that dates back a year or more. Streaming a large number of insert delayeds into a table that does not exist causes the crash. The table was not created correctly last night. Is there a web version of mysql code like PHP has http://lxr.php.net ? I'd like to browse through and see what I can find, but using vi is just not worth my time. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e Hi! I have tried the above with 3.23.33 and was not able to reproduce it. You can browse through our sources with any editor. Just download source code tarball. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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
MySQL Connections
Hi, I am currently working on a project in which we are using MySQL to store data. The database server (basic installation) is installed on Windows NT version 4. We are currently doing some load testing on the software and have encountered some problems. The database server is hanging. Our intention is eventually to create a farm of application servers to host the system for scalability reasons. So, at the moment we want to find the limits of a single app server. 1. We have employed the Singleton pattern to control the connection to that database, which is a point of concern. Will the load testing strain the single connection thus hanging the Mysql Server? 2. Should each request create a new database connection or is this too slow and costly 3. Should connection pooling be considered and if so which app server do you recommend 4. Could antone tell me how many connections can be open at any one time? 5. Are there any know reasons why the database server should hang? 6. Are there any know reasons why a connection to the database should hang thus crippling the database server? Any comments or suggestion as to wh this is happening would be most useful. Cheers Daire Treanor. - 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
Version No
I just d/loaded and compiled the mysql-3.23.33.tar.gz from www.mysql.com. However, after make and make install, restarting mysql, if I type mysqld --version I get: mysqld Ver 3.23.22-beta for pc-linux-gnu on i686 Did they just not change the version number or is there something else I need to do? Cal http://www.calevans.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: Bug with 'show databases|tables'
Hi, I hope to be helpful for further investigation of the problem. On Wed, Mar 07, 2001 at 08:20:16AM +0700, Eugene Lineitzev wrote: Description: I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14 all 'show' commands doesn't works. They display empty tables. In my case error appeared in RedHat 6.2 with kernel 2.2.18. And on RedHat 7.0 sources from www.mysql.com compliled and work pretty well. How-To-Repeat: $ mysql mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | | | | | +--+ 8 rows in set (0.00 sec) mysql use UNEXISTANT; ERROR 1049: Unknown database 'UNEXISTANT' mysql use mysql; Database changed mysql show tables; Empty set (0.00 sec) As we can see, there are AVAILABLE databases, but 'show databases' doesn't displays anything. We can make 'use' with correct names, can't with unexistant, but the tables in database can't be reached. BTW, I have found the dependence of number in line ('8 rows in set) above - it corresponds to number of entries in /var/lib/mysql/ directory: $ ls -a /var/lib/mysql/ . Phantom.log Phantom.tsk.ru.pid mysql.sock .. Phantom.tsk.ru.err mysql test On my RH 6.2 there is another dependancy. show databases returns number of entries in the directory without . and .. Moreover, show tables returns very nice list of tables' names. All names are truncated in the first 4 characters (tables_priv - es_priv). Perhaps it's interesting to know that my data folder is /data. GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='egcs' CFLAGS=' -O6' CXX='egcs' CXXFLAGS=' -O6 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Another common moment is on RH 6.2 I compiled it with egcs and libstdc++ was not installed. On RH7.0 I compiled with gcc and libstdc++ was installed. It looks like we have problems with either egcs or libstdc and company. Hope it helps MySQL developers. Best regards, Lumberer. - 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: key lengths
Yes, I've tries that here is the error I get. Your MySQL connection id is 247 to server version: 3.23.33 mysql CREATE TABLE foo( - id INT NOT NULL AUTO_INCREMENT, - name BLOB NOT NULL, - PRIMARY KEY(id), - UNIQUE(name(500)) - ); ERROR 1089: Incorrect sub part key. The used key part isn't a string or the used length is longer than the key part Pat Sherrill wrote: BLOBS and TEXT columns used as indices require the length to be specifically enumerated. (Sec 7.26 of the manual) CREATE TABLE foo( id INT NOT NULL AUTO_INCREMENT, name BLOB NOT NULL, PRIMARY KEY(id), UNIQUE(name(500)) ); Pat... [EMAIL PROTECTED] - Original Message - From: "Mike Thompson" [EMAIL PROTECTED] To: "mysql" [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 1:51 PM Subject: key lengths How is key length for a table defined? It seems that the default is 255 bytes, but in the online docs it mentions 500 byte keys. I happen to have some very long case sensitive strings that I need to use as keys, but mysql complains when I try to create a table as such CREATE TABLE foo( id INT NOT NULL AUTO_INCREMENT, name BLOB NOT NULL, PRIMARY KEY(id), UNIQUE(name) ); Any thoughts? --m - 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 -- Michael R. ThompsonInstanton Corporation Sr. Software Developer 1250 Capital of Texas Highway South [EMAIL PROTECTED] Building 3 suite 200 328-1022x15Austin, TX 78746 - 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 question...
After doing an INSERT, you may do SELECT last_insert_id(); and it will return the last id the last INSERT command used. it doesn't matter if your MySQL server is very busy doing inserts, if you call 'SELECT last_insert_id()' right after the INSERT, you will get the correct value. last_insert_id() returns the last insert ID of that connection ID, so you will get the correct values. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.954.9133 -Original Message- From: Josh Burroughs [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 6:18 PM To: [EMAIL PROTECTED] Subject: INSERT question... Hi-o! I was wondering if it's possible when inserting a value into a table that has an auto_increment field to have MySQL return the value of the auto_increment field right after doing the insert, w/out having to run a seperate query? For example if I had a table with two collums, ID and name. Where ID is an int field with auto_increment set, and is the primary key. and name is just a varchar. and did this: INSERT INTO some_table (name) VALUES("bob"); I'd like for the query to return the value for ID that was just assigned. Is there a way to do this all in one SQL statement? Thanks in advance! "Listen: We are here on Earth to fart around. Don't let anybody tell you any different!" - Kurt Vonnegut Josh Burroughs [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: Join syntax
I don't know what you are trying to accomplish but here is the way I would build a table using ALL the data field from two tables. first is a straight join which will only build the records that have an equal in both tables. insert into tbla select distinct tblb.*, tblc.* from tblb, tblc where tblb.flda = tblc.flda the second will build records for every record in tblb and will include data from tblc when there is a corresponding record in tblc. When there is no corresponding record in tblc the tblc data fields will be set to null. insert into tbla select distinct tblb.*, tblc.* from tblb left join tblc on tblb.flda = tblc.flda hope this helps. Jack :-)= - Original Message - From: "Willie Klein" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 2:20 PM Subject: Join syntax Hi all: I think what I want to do is join tables in a select statement but I'm not having any luck. I'm using MySQL 3.22 PHP and apache on RH6.2 I have an application that has multiple tables that customers upload order data to. People who look at this data can see their orders from each table individually. Now they want to download their data from each of these tables into their own database. When I do a select on my test table like: Select * into outfile /home/temp/test.txt from apple where RepID = NYS I get a file that is 150K. When I do a select on 2 of my test tables(which are identical)like: Select * into outfile /home/temp/test.txt from apple as t1, bass as t2 where t1.RepID = 'NYS' and t2.RepID='NYS' I get a file that is 116MB with each record being repeated 866 times. When I do a left join it does about the same thing. I'm going to want to do this with more than 2 tables so is my approach to this wrong or just my syntax. I've read the manual page on join and (I admit it) I don't understand it. Thanks for your help willie - 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: Off Topic Perl Mysql modules install problem
Curtis Maurand wrote: Hello, I'm now lost. I cannot figure out what the make file is looking for. Anyone have any ideas? LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.9 6" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql-L/usr/lib/mysql -lmysqlclient -lm -lz -L/usr/lib/g cc-lib/i386-redhat-linux/2.96 -lgcc /usr/bin/ld: cannot find -lz collect2: ld returned 1 exit status make[1]: *** [../blib/arch/auto/DBD/mysql/mysql.so] Error 1 make[1]: Leaving directory `/home/curtis/Msql-Mysql-modules-1.2215/mysql' make: *** [subdirs] Error 2 You are missing libz.so and/or libz.a. You need to install these libs from your CD. - 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't start mysql
foxwoo wrote: Dear, I use Red Head 6 with mysql, php3 and apache, past all of them are work well, but one day the our DNS had some problem, after solve the DNS problems, we found we cannot restart our mysql. The error message is "mysqld daemon ended". The host.err is as below: mysqld started on Wed Mar 7 00:46:55 CST 2001 010307 0:46:55 Can't start server: Bind on TCP/IP port: Address already in use 010307 0:46:55 Do you already have another mysqld server running on port: 3306 ? 010307 0:46:55 Aborting mysqld ended on Wed Mar 7 00:46:55 CST 2001 mysqld started on Wed Mar 7 00:51:59 CST 2001 010307 0:51:59 Can't start server: Bind on TCP/IP port: Address already in use 010307 0:51:59 Do you already have another mysqld server running on port: 3306 ? 010307 0:51:59 Aborting mysqld ended on Wed Mar 7 00:51:59 CST 2001 How can I check wheather my server have other mysql server running, but I only need to run ONE mysql, may you help me pls. Fox. ps -ef | grep mysql This will show you all running commands that contain the string 'mysql'. Kill any running servers, and restart. - 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: Intermittent hang on UPDATE foo = foo + 1
[EMAIL PROTECTED] wrote: Description: Sometimes the query below appears to hang on the table below. The problem seems worse on queries which come from a webserver, where persistent DB connections are used. : The online manual page hints at the same problem elsewhere: see Tomi Panula-Ontto's comment at http://www.mysql.com/doc/U/P/UPDATE.html UPDATE domain_sm SET age = age + 1, exit_time = NOW(), exit_env = '983895322:mxm5480.tc:mxm5480.tc:mxm5480.tc:mxm5480.tc:9' WHERE identity = 'mjo13684test11.tc' CREATE TABLE domain_sm ( identity varchar(63) DEFAULT '' NOT NULL, age int(11) DEFAULT '0' NOT NULL, state int(11) DEFAULT '0' NOT NULL, entry_time datetime, entry_env blob, exit_time datetime, exit_env blob, UNIQUE identity (identity,age), KEY state (state) ); Submitter-Id: submitter ID Originator:Martin Oldfield Organization: Martin Oldfield, AdamsNames Ltd. MySQL support: none Synopsis: UPDATE command can sometimes hang Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.22.32 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686 TCX Datakonsult AB, by Monty Server version 3.22.32-log Protocol version10 Connection ptolemy via TCP/IP TCP port3306 Uptime: 20 days 1 hour 24 min 22 sec Threads: 47 Questions: 5773313 Slow queries: 5671 Opens: 68799 Flush tables: 1 Open tables: 63 Environment: System: Linux joanna 2.2.17 #1 Thu Oct 19 16:36:18 BST 2000 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs gcc version 2.95.2 2220 (Debian GNU/Linux) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Configure command: ./configure --enable-shared --without-readline --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.sock --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc/mysql --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man Perl: This is perl, version 5.005_03 built for i386-linux You are incrementing part of the key being used in the select. This can cause an endless loop in 3.22 versions. This is addressed in 3.23 versions, mut may still be an issue with yours. You can check the changelog to find where it was fixed. - 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: Beginner Help, can't get it started, but did in the past
Joseph Greenawalt wrote: Hello all, I hope someone can help. I have a fresh install of Red Hat 7.0, I installed mysql-3.23.22-6.i386.rpm and then mysql-server-3.23.22-6.i386.rpm. Supposedly the daemon is automatically starts, well it doesn't. I tried the mysql_install_db and it runs, but I don't think it makes the databases because when I try to start the daemon with safe_mysqld it says it tries to open the databases in /var/lib/mysql, shouldn't there be a data directory or something? I don't know, but it can't find them because the script immediately ends. The listing of the /var/lib/mysql is localhost.localdomain.err mysql/ mysql.sock= test/ Any help would be appreciated, I have a school project deadline coming up with JDBC and my problem is with this database more than the code. I would prefer to use mysql, but if I can't get it running, I might have to use MSAccess :-( Thanks in advance, Joe - If these are the RPMs on the CD, they are no good. Go to redhat.com or mysql.com and get working RPMs. - 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: Off Topic Perl Mysql modules install problem
its looking for the z compression library. To fix do this 1) perl Makefile.PL 2) cd mysql 3) vi Makefile 4) search for line LDLOADLIBS and add -lz to end 5) cd .. 6) make 7) make test 8) make install Robin -Original Message- From: Curtis Maurand [mailto:[EMAIL PROTECTED]] Sent: 06 March 2001 16:55 To: MySQL List Subject: Off Topic Perl Mysql modules install problem Hello, I'm now lost. I cannot figure out what the make file is looking for. Anyone have any ideas? LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux /2.9 6" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql-L/usr/lib/mysql -lmysqlclient -lm -lz -L/usr/lib/g cc-lib/i386-redhat-linux/2.96 -lgcc /usr/bin/ld: cannot find -lz collect2: ld returned 1 exit status make[1]: *** [../blib/arch/auto/DBD/mysql/mysql.so] Error 1 make[1]: Leaving directory `/home/curtis/Msql-Mysql-modules-1.2215/mysql' make: *** [subdirs] Error 2 - 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
Dying Server
Whenever my MySQL server (3.23.33) is under heavy load it restarts itself. Stopping whatever was connected to it at the time. In my .err log I've just got; 010307 00:12:32 mysqld started /usr/local/libexec/mysqld: ready for connections Killed 010307 00:16:56 mysqld restarted /usr/local/libexec/mysqld: ready for connections Killed 010307 00:20:51 mysqld restarted /usr/local/libexec/mysqld: ready for connections Killed etc. Any ideas? Thanks, Chris - 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
Plans for implementing user-/passwordauthentification against LDAP
Are there any plans for authentification of users in mysql against an LDAP directory insteed of the mysql user table? Or is there a patch known? -- Helmut Wirth [EMAIL PROTECTED] - bison GmbH phone +49 89 / 50 03 91-14 Ridlerstr. 11 fax +49 89 / 50 03 91-17 D-80339 Muenchen http://www.bison-soft.de/ - - 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: Running a Query Append in Access 97 with a linked MySQL table
At 16:56 06/03/2001 -0500, [EMAIL PROTECTED] wrote: Hi, If you are using Access as front end, when you build the update or append query you can use an expression like: My Name: [TableName]![ColumnName] You can do this manually or using the builder query of Access. Regards, Miguel Hello I have uploaded a table from Access 97 to the MySQL database and apart from changing the name from "Mailing List" to " Mailing_List" it appears fine. Now that I am putting data into the linked MySQL table in a "live " environment I need the MySQL table to update the Access records and vica versa. When I try either way to run a Query Append I get as far as the fields and when I try to run the append the message says that the field "web_site" has an incorrect name. In my original table called the field "web sites" and MySQL has underscored it, but I am calling the field the same as MySQL calls it and it still wont recognise it. It does not work the other way either, from Access to the MySQL linked table, whatever I call the "web site" column it just has a problem with that column. Even if I delete the column it still wont append and update the data. Any ideas? Peter Worthington - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development 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
myisamchk errors
I recently upgraded our database from 3.22.32 to 3.23.32 We run a ISAM check every night, to check for db problems. Ever since I did the change, I get a email from the cron daemon like this: /usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI /usr/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly Is there something I am not doing right? Is this output happening because these are MyISAM tables rather than ISAM like we used to use, and the myisamchk program has to run with the database shut down? Alternatively, is this something to do with the way the Perl modules are working? We use the Mysql modules? Any thoughts? I would like to try to remove the cause of these warnings. Thanks Don - 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: sql date worries
Hi all, Im kind of strugling with a query for some time now and I need extra input: What is the desired answer from mysql: a date. what is the input: a week number What dat do I need: The date of the monday (week starts at sunday) in the weeknumber. something like: select date(week(10),1); But this doesn't work. Anyone any idea's? I'm blocked.. Sir, to get a date in the specified week, you can use Date_add('2001-01-01', INTERVAL number WEEK) Check on my website for code that finds the date of a specific weekday, given any date in the week. http://users.starpower.net/rjhalljr. Click on MySQL on the sidebar, and select SQL. Look for the date topics. 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
Re: Version No
Sounds like it installed to a different directory than the previous version - try /usr/local/bin/mysqld --version or /usr/local/mysql/bin/mysqld --version It would be a good idea to remove any previous binaries to avoid confusion, as well. Cheers, P On Wed, 7 Mar 2001, Cal Evans wrote: I just d/loaded and compiled the mysql-3.23.33.tar.gz from www.mysql.com. However, after make and make install, restarting mysql, if I type mysqld --version I get: mysqld Ver 3.23.22-beta for pc-linux-gnu on i686 Did they just not change the version number or is there something else I need to do? Cal http://www.calevans.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 - 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: Sending data, but no data sent?
Matthias Urlichs writes: Hi, select * from ticketid where id like "123%" correctly uses the above index, but a more restrictive query, i.e. select * from ticketid where id like "123%" and id = 123 doesn't. This is _not_ the expected result. -- Matthias Urlichs | noris network AG | http://smurf.noris.de/ -- The decent moderation of today will be the least human of things tomorrow. At the time of the Spanish Inquisition, the opinion of good sense and of the good medium was certainly that people ought not to burn too large a number of heretics; extreme and unreasonable opinion obviously demanded that they burn none at all. -- Maurice Maeterlinck And what happens if you put quotes ??? ... id = '123'... Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, 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: Sending data, but no data sent?
Hi, Sinisa Milivojevic: And what happens if you put quotes ??? ... id = '123'... Then it works, of course. But the nice thing about the numeric select is that it also accepts values like 123x45 or 123-45-67 (but not 1234), which is why I wanted to use it. -- Matthias Urlichs | noris network AG | http://smurf.noris.de/ -- New York is the biggest boob town in America. All any of those hokum peddlers need to do in selling New Yorkers their phony` goods is to ask what they want, and they'll be sure to get it. -- Bat Masterson - 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
Configure issue
Hi, I have some problem running the ./configure command for version mysql-3.23.33 see below: checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. If you want to report this, use 'scripts/mysqlbug' and include at least the last 20 rows from config.log! I'm running this on the following: Solaris 2.8 release FCS ( Intel ) gcc -v Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) libm.a is there see below: find / -name libm.a -print /usr/lib/libp/libm.a /usr/lib/libm.a /usr/local/lib/libm.a LD_LIBRARY_PATH is set see below: echo $LD_LIBRARY_PATH /usr/lib /usr/local/lib /usr/openwin/lib /software/local/rvplayer5.0 /opt/ISLIodbc/2.11/lib /usr/java1.2.2/lib /usr/local/lib/glib /usr/local/lib/glib/include /opt/sfw/lib /opt/sfw/gnome/lib /opt/netscape /usr/lib/libp Any ideas why this stupid Config is not working? Any help would be appreciated. -- ** *** Phillip B. Bruce** *** http://pbbruce.home.mindspring.com ** *** [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
C API problem
dear Sir : MySQL 3.22 on my linux 486 PC seems work so good. when I compile a simple C API program which catched from the MySQL tutorial, it chokes at the end of compile process . the program is as follows: #include stdio.h #include mysql.h #define def_host_name NULL #define def_user_name NULL #define def_password NULL #define def_db_name NULL MYSQL *conn; int main(int argc,char *argv[]) { conn=mysql_init(NULL); mysql_real_connect( conn, def_host_name, def_user_name, def_password, def_db_name, 0, /*port defaut*/ NULL, /*socket default*/ 0);/*flag*/ mysql_close(conn); exit(0); } I compile as follows: gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \ -L/home/MySQL/MySQL/lib \ -lmysqlclient then I get : /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x14):undefined reference to 'open64' /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format': mf_format.o(.text+0x201):undefined reference to '__lxstat64' /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x21):undefined reference to 'fopen64' nothing left to do with the situation, I beg your help. anyway I'm a newcomer. thank you very much. please send message to [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: Long deletes
"MV" == Michael Villalba [EMAIL PROTECTED] writes: MV Thanks, Fred. The delete job has been running for 21 hours MV at this point, and now rather simple queries on other tables hang MV (e.g. SELECT COUNT(*) FROM other_table WHERE index=some_value). MV I'll let it run overnight to see what happens, but I'm not hopeful. This is a major issue for us as well. We have some tables that need periodic cleaning of old data and it can take hours upon hours to do that. What our workaround is, and it is IMHO, sub-optimal, is to use the LIMIT feature of DELETE in MySQL, and issue the delete in a loop until no more items are deleted. Something like this, in Perl: my $sth = $dbh-prepare("DELETE LOW_PRIORITY FROM playlog $clause LIMIT ?"); $sleeptime = 0; do { print "Sleeping... $sleeptime seconds\n"; sleep($sleeptime); my $stime = time; print scalar localtime $stime," (start delete)\n"; $sth-execute($limit); $affectedRows = $sth-rows(); my $etime = time; print scalar localtime $etime,": "; my $diff = $etime-$stime; print "Deleted $affectedRows rows... $diff seconds\n"; $sth-finish(); # sleep half the time it took to delete, if longer than 30 seconds. $sleeptime = $diff 30 ? int($diff/2) : 1; } until ($affectedRows $limit); Assuming $clause = 'WHERE .' is your match for rows to delete, this will delete things in batch size of $limit (I use 200 rows), and sleep between the deletes to let other threads do their thing with not too much delay. Ideally, MySQL would allow the delete to be concurrent with other operations. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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
DBI for Windows
Dear Sirs: Please can you tell me where I can get the Perl DBI interface for Windows ??? Ernesto - Este mensaje fue enviado a través de Qnet http://www.qnet.com.pe - 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
show databases|tables problem
I've been reading the thread about SHOW DATABASES and SHOW TABLES returning lists of blank entries or no results. Just out of curiosity, I upgraded my RedHat 6.2 machine from MySQL 3.23.32 to MySQL 3.23.33 and found that suddenly I had the problem too! However, then I remembered that I'd upgraded glibc in the meantime to deal with some other RPMs I installed that required a newer glibc. So I went back and recompiled 3.23.32 and installed it. Guess what? I still have the problem. glibc and glibc-common versions are 2.2-12 if that's relevant. Based on the preceding information, I'd guess it's not a MySQL problem per se. -- Paul DuBois, [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: Having a hard time installing MySQL
"DN" == Dan Nelson [EMAIL PROTECTED] writes: DN This looks like you used the binary package, right? That was built for DN FreeBSD 4.2, which has a different set of c++ libraries from 4.0. DN You'll have to either upgrade to 4.2, or build mysql from ports. I'd highly recommend upgrading to FreeBSD 4.2-STABLE so that you also get the very important C++ library/compiler fixes. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - 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: Bug with 'show databases|tables'
Canadian Lumberer wrote: Hi, I hope to be helpful for further investigation of the problem. On Wed, Mar 07, 2001 at 08:20:16AM +0700, Eugene Lineitzev wrote: Description: I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14 all 'show' commands doesn't works. They display empty tables. In my case error appeared in RedHat 6.2 with kernel 2.2.18. And on RedHat 7.0 sources from www.mysql.com compliled and work pretty well. How-To-Repeat: $ mysql mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | | | | | +--+ 8 rows in set (0.00 sec) mysql use UNEXISTANT; ERROR 1049: Unknown database 'UNEXISTANT' mysql use mysql; Database changed mysql show tables; Empty set (0.00 sec) As we can see, there are AVAILABLE databases, but 'show databases' doesn't displays anything. We can make 'use' with correct names, can't with unexistant, but the tables in database can't be reached. BTW, I have found the dependence of number in line ('8 rows in set) above - it corresponds to number of entries in /var/lib/mysql/ directory: $ ls -a /var/lib/mysql/ . Phantom.log Phantom.tsk.ru.pid mysql.sock .. Phantom.tsk.ru.err mysql test On my RH 6.2 there is another dependancy. show databases returns number of entries in the directory without . and .. Moreover, show tables returns very nice list of tables' names. All names are truncated in the first 4 characters (tables_priv - es_priv). Perhaps it's interesting to know that my data folder is /data. GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='egcs' CFLAGS=' -O6' CXX='egcs' CXXFLAGS=' -O6 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Another common moment is on RH 6.2 I compiled it with egcs and libstdc++ was not installed. If this helps my problems are on: Redhat 6.2 I've libstdc++-2.9.0-30 and it has the above bug on kernel 2.2.17 and 2.4.2 complie with gcc -v of gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release). SUSE 7.0 libstdc is not install - bug still apears gcc is gcc version 2.95.2 19991024, Kernel 2.2.16 greg On RH7.0 I compiled with gcc and libstdc++ was installed. It looks like we have problems with either egcs or libstdc and company. My experience does not suggest this but I am opne to any ideas ! Hope it helps MySQL developers. So do I Greg Best regards, Lumberer. - 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: kill bad query
Steve Ruby wrote: If I have a connection that executes a bad query shouldn't I ALWAYS be able to kill it with "kill connect num"? I have a query that keeps getting stuck, (who knows what it is doing) but that State is "statistics" I can't ever kill it without taking down the server.. PS.. this is using 3.23.33 on Linux.. I find that the query is very slow but will eventually complete, still, can I not kill a query that will lock tables for hours? - 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 to connect applets to MySQL server by using mm.mysql driver?
Hi, When I read the documents for MM.MySQL driver, I noticed that it is mentioned that MM.MySQL driver can be used to make connections to APPLETS. However, I could not find any further information and examples for this issue. Could you please send me some examples on how to use MM.MySQL driver to connect the applets to MySql server? Your help is appreciated. Nancy - 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 1030 at line 1: Got error 127 from table handler
I am using version 3.32.23 and I receive these errors frequently when using the mysql client using select statements. These messages are showing in the mysqld error log as a result: 010307 0:46:03 read_next: Got error 127 when reading table ./perf/webstats_apollo 010307 9:17:12 read_next: Got error 127 when reading table ./perf/webstats_apollo 010307 9:29:12 read_next: Got error 127 when reading table ./perf/webstats_apollo 010307 9:29:44 read_next: Got error 127 when reading table ./perf/webstats_apollo What causes them and how can I prevent them? 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
Re: myisamchk errors
Don Bowyer wrote: I recently upgraded our database from 3.22.32 to 3.23.32 We run a ISAM check every night, to check for db problems. Ever since I did the change, I get a email from the cron daemon like this: /usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI /usr/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly Is there something I am not doing right? Is this output happening because these are MyISAM tables rather than ISAM like we used to use, and the myisamchk program has to run with the database shut down? Alternatively, is this something to do with the way the Perl modules are working? We use the Mysql modules? Any thoughts? I would like to try to remove the cause of these warnings. Thanks Don - 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 Hi, If you want to run myisamchk while mysqld is running, you should run mysqld WITHOUT --skip-locking option. Check the manual for details: http://www.mysql.com/doc/C/r/Crash_recovery.html Regards -- Joseph Bueno NetClub/Trader.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: desperate for help...
It looks like the addition of the distinct verb should do the job if in fact your query only showed the fields on the display. From your Sql however you are selecting more fields than are displayed and some of those are different which distinct will still display. Chris Toth wrote: Ok, I've been battling this SELECT statement for the better part of the day. The SELECT statement is this: SELECT DISTINCT request.id AS requestid, request.date, request.type, request.status, faculty.f_name, faculty.l_name, action.id AS actionid, faculty.id AS facultyid FROM faculty, request, action WHERE request.id=action.request_id AND request.requested_by=faculty.id AND request.status=0; And the results are here: http://www.geology.ohio-state.edu/test/rfatest/rfaadmin.php?closed=Closed Now, if you look at the table, at the far left cell under RFA#, you'll notice that they are all the same (2). That is because there were 4 actions performed on RFA # 2. However, I only need for the column to be displayed once. When the user clicks under 'last action' then they can see all 4 actions. But for this table, I just need to show the data once. So, could any kind soul help me out? 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 - 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
Is a commercial license still required?
I am considering developing an application that relies on MySQL as for database functionality. The application would include MySQL client API calls and be linked with MySQL libraries. It would be distributed with the MySQL database. According to the license terms in MySQL 3.23.30 Reference Manual (section 3.1): "A license is required if: You link a part of the of MySQL that has a GPL Copyright to a program that is not free software (embedded usage of the MySQL server). In this case your application would also become GPL through the clause in the GPL license that acts as a virus. By licensing MySQL from us under a commercial license you will avoid this problem. You have a commercial application that ONLY works with MySQL and ships the application with the MySQL server. This is because we view this as linking even if it is done over the network. You have a distribution of MySQL and you don't provide the source code for your copy of the MySQL server, as defined in the GPL license." The statement, "You have a commercial application that ONLY works with MySQL and ships the application with the MySQL server. This is because we view this as linking even if it is done over the network." is troubling because it appears to violate the intent if not the terms of the GPL/LGPL licensing. I read this statement as saying that if you develop a commercial application that relies only on MySQL for its database functionality, then you have to get a commercial license for your product or else your product becomes GPL itself. How can this be since MySQL is GPL and its client libraries that are linked into the application are LGPL? The commercial application should be able to freely incorporate the LGPL libraries and still be distributed for profit like other applications that incorporate LGPL libraries. The fact that an application that is a MySQL client works only with MySQL database should not have any effect on licensing. This is no different than a commercial Linux application that incorporates the Linux LGPL libraries and works only with the GPL Linux Operating System. In this case the commercial Linux application can be distributed for profit, it does not require a "special" license and it does not become GPL. How is an application, which incorporates the LGPL MySQL libraries and relies on the GPL MySQL to run, different from the previously described Linux application? MySQL's license uses the GPL "virus" clause to justify its licensing. Doesn't the reference to the virus clause under the GPL license basically have to do with repackaging a GPL component into proprietary software. In other words, if an application wraps GPL components then the application itself becomes GPL. However, an application that is a client to the MySQL database is not wrapping but acting as a user to the GPL MySQL software in the same way that a Linux application acts as a user of the GPL Linux operating system software. The only linkage in both cases is through APIs in the LGPL libraries. I can't see the distinction. Any thoughts? Jeff
Re: file insertion?
On Tue, 6 Mar 2001, Kevin Connolly wrote: Date: Tue, 6 Mar 2001 18:15:17 - From: Kevin Connolly [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: file insertion? Hi, Is it possible to insert a file into the MySQL database? I want a table = with certain entries such as name, address etc. but I also I a photo for = each member. Is that possible? Thanks, Kev. First question, how large are the files containing the photo? This will determine what kind of blob(binary large object) you would use. Note, it this is the only variable size field in the table it will force all text fields over (2 bytes I think) to become varchar. If you add AND delete records this could lead to the need to run special tools to recover the space. Second, why not store the address of a file with the picture in the database rather than the picture itself. Particularly if this is to support a web project, the address is actually more useful since you can have the webserver get the picture rather than the database. In any event, passing a large amount of data from the database will hold open the connection longer. 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: Configure issue
Phillip Bruce wrote: Hi, I have some problem running the ./configure command for version mysql-3.23.33 see below: checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. If you want to report this, use 'scripts/mysqlbug' and include at least the last 20 rows from config.log! I'm running this on the following: Solaris 2.8 release FCS ( Intel ) gcc -v Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) libm.a is there see below: find / -name libm.a -print /usr/lib/libp/libm.a /usr/lib/libm.a /usr/local/lib/libm.a LD_LIBRARY_PATH is set see below: echo $LD_LIBRARY_PATH /usr/lib /usr/local/lib /usr/openwin/lib /software/local/rvplayer5.0 /opt/ISLIodbc/2.11/lib /usr/java1.2.2/lib /usr/local/lib/glib /usr/local/lib/glib/include /opt/sfw/lib /opt/sfw/gnome/lib /opt/netscape /usr/lib/libp Any ideas why this stupid Config is not working? Any help would be appreciated. -- ** *** Phillip B. Bruce** *** http://pbbruce.home.mindspring.com ** *** [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 If it has to do with a libraries problem try doing this $ ldconfig see if that works for you. heres a little bit about ldconfig command ldconfig(8) ldconfig(8) NAME ldconfig - determine run-time link bindings SYNOPSIS ldconfig[-DvnNX][-f conf] [-C cache] [-r root] directory ... ldconfig -l [-Dv] library ... ldconfig -p DESCRIPTION ldconfig creates the necessary links and cache (for use by the run-time linker, ld.so) to the most recent shared libraries found in the directories specified on the com- mand line, in the file /etc/ld.so.conf, and in the trusted directories (/usr/lib and /lib). ldconfig checks the header and file names of the libraries it encounters when determining which versions should have their links updated. ldconfig ignores symbolic links when scanning for libraries. ldconfig should normally be run by the super-user as it may require write permission on some root owned directo- ries and files. It is normally run automatically at bootup, from /etc/rc, or manually whenever new DLL's are installed. OPTIONS -D Debug mode. Implies -N and -X. -v Verbose mode. Print current version number, the name of each directory as it is scanned and any links that are created. -n Only process directories specified on the command line.Don't process the trusted directories (/usr/lib and /lib) nor those specified in /etc/ld.so.conf. Implies -N. -N Don't rebuild the cache. Unless -X is also speci- fied, links are still updated. -X Don't update links. Unless -N is also specified, the cache is still rebuilt. -f conf Use conf instead of /etc/ld.so.conf. -C cache Use cache instead of /etc/ld.so.cache. -r root Change to and use root as the root directory. -l Library mode. Manually link individual libraries. Intended for use by experts only. -p Print the lists of directories and candidate libraries stored in the current cache. EXAMPLES In the bootup file /etc/rc having the line /sbin/ldconfig -v will set up the correct links for the shared binaries and rebuild the cache. On the command line # /sbin/ldconfig -n /lib as root after the installation of a new DLL, will properly update the shared library symbolic links in /lib. FILES /lib/ld.so execution time linker/loader /etc/ld.so.conf File containing a list of colon, space, tab, newline, orcomma spearated directories in which to search for libraries.
Re: myisamchk errors
In the last episode (Mar 07), Don Bowyer said: I recently upgraded our database from 3.22.32 to 3.23.32 We run a ISAM check every night, to check for db problems. Ever since I did the change, I get a email from the cron daemon like this: /usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI /usr/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly The database is shut down when you do this, right? You should really never have to run myisamchk unless your server crashes a lot. If you don't want to shut down mysql to check tables, use the "CHECK TABLE" mysql command. -- Dan Nelson [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: DBI for Windows
If you are using a current "activestate" release it should be included, if not use their package manager. On Wed, 7 Mar 2001 [EMAIL PROTECTED] wrote: Date: Wed, 7 Mar 2001 15:59:36 GMT From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: DBI for Windows Dear Sirs: Please can you tell me where I can get the Perl DBI interface for Windows ??? Ernesto - Este mensaje fue enviado a través de Qnet http://www.qnet.com.pe - 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 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: Weird select with php
SELECT * FROM members where name like 'A%' ORDER BY RAND(); John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 6 Mar 2001, Matt "TrollBoy" Wiseman wrote: I'm attempting to do a select from my table, but the only odd thing is the customer wants the results to be completely random every time... is there anything like this?? $query = "SELECT * FROM members where Name like 'A%' ORDER BY random"; Matt "Trollboy" Wiseman www.shoggoth.net/trollboy/trollboy.jpg [EMAIL PROTECTED] "I wish the world had one throat!!" -Al Bundy - 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
Seeing errors/warnings (?) while running wwsympa.fcgi
Hello, After having gotten sympa to run (with a few warnings), tried running wwsympa.fcgi for configuration purposes. Unfortunately, kept getting a internal server error. While trying to see what was wrong, I typed "perl wwsympa.fcgi". I received these error/warnings before it outputed the html code which would be displayed on the web site. Would these error/warnings have anything to do with the internal server error or are they completely harmless? Thanks! [root@server1 cgi-bin]# perl wwsympa.fcgi Name "main::new_p" used only once: possible typo at wwsympa.cgi line 4089. Name "main::languages" used only once: possible typo at wwsympa.cgi line 1478. Name "main::bounce_status" used only once: possible typo at wwsympa.cgi line 3556. Name "main::sender" used only once: possible typo at wwsympa.cgi line 2499. Name "main::name_doc" used only once: possible typo at wwsympa.cgi line 6323. Name "main::slash" used only once: possible typo at wwsympa.cgi line 4794. Content-type: text/html Sincerely, Tom Cruickshank - 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: myisamchk errors
The reason we run the check scripts is because in the past we had all sorts of trouble not with the daemon crashing, but with clients (who have no technical skills) using Access ODBC to update tables, and somehow corrupting them. This way we catch the problems before the client does. Thanks though. I'll give it a go. Don On Wednesday 07 March 2001 17:16, Dan Nelson wrote: In the last episode (Mar 07), Don Bowyer said: I recently upgraded our database from 3.22.32 to 3.23.32 We run a ISAM check every night, to check for db problems. Ever since I did the change, I get a email from the cron daemon like this: /usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI /usr/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly The database is shut down when you do this, right? You should really never have to run myisamchk unless your server crashes a lot. If you don't want to shut down mysql to check tables, use the "CHECK TABLE" mysql command. -- Insidewire Services Inc. www.insidewire.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