Re: Microsoft Visual C++ 6.0 API
Hi First of all let me say that the API is consistent cross-platforms i.e. there is no difference between Windows and *NIX At 16:56 21/01/2001 -0500, Don Hargroves wrote: Where can I get an example(s) of Microsoft Visual C++ 6.0 API to MySQL running under Linux 6.2? I suppose you mean Red Hat Linux V6.2, since the Linux Kernel version number has only just reached 2.4 In addition to a C++ source file examples(s), where do I get the #include headers file(s) and the library file(s) ? Try usr/include/mysql and usr/lib/mysql. or on Windows X:\mysql\include or X:\mysql\lib, seems like a good place to start Any comments about header / linker options / settings would be greatly appreciated also. For which platform, Linux or Windows? Thanks in advance, Don Hargroves - 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 Regards John MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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
explain select question
Hi all, I've been working on optimizing my query but no success. Concerning the type of query shown by "explain select", about join type "ALL" in the manual is written: "This is normally not good if the table is the first table not marked const, and usually very bad in all other cases." So, I added indexes on all columns involved in join but "explain select" still shows the same result. Am I missing something or this is inevitable and can't be optimized. Below are some snippets. mysql describe firm; ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | fikey | smallint(5) unsigned | | MUL | 0 | auto_increment | | finame | varchar(60) binary | | MUL | || | ficity | varchar(30) | | MUL | || | fiaddress | varchar(60) | YES | | NULL || | fiphone| varchar(60) | YES | | NULL || | fiuserid | smallint(5) unsigned | | MUL | 0 || ++--+--+-+-++ 6 rows in set (0.01 sec) mysql describe product; ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | prkey | smallint(5) unsigned | | MUL | 0 | auto_increment | | prfikey| smallint(5) unsigned | | MUL | 0 || | pritem | varchar(100) | | MUL | || | prproducer | varchar(80) | YES | | NULL || ++--+--+-+-++ 4 rows in set (0.00 sec) mysql describe users; +--+--+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-++ | userid | smallint(5) unsigned | | MUL | 0 | auto_increment | | username | varchar(20) | YES | | NULL || | userpass | varchar(20) | YES | | NULL || +--+--+--+-+-++ 3 rows in set (0.00 sec) mysql explain select finame, pritem, username from firm, product, users where fiuserid=userid and fikey=prfikey; +-+--++--+-+--+--+--+ | table | type | possible_keys | key | key_len | ref | rows | Extra| +-+--++--+-+--+--+--+ | firm| ALL | fikey,fiuserid | NULL |NULL | NULL | 11 | | | product | ALL | prfikey| NULL |NULL | NULL | 25 | range checked for each record (index map: 2) | | users | ALL | userid | NULL |NULL | NULL | 96 | range checked for each record (index map: 1) | +-+--++--+-+--+--+--+ 3 rows in set (0.00 sec) I have the indexes, tried STRAIGHT_JOIN and *all* permutations of tables in FROM clause possible, but still the same result. It is said in the manual that the query will examine 11*25*96 rows to get the result set. I must optimize this, otherwise when records in these three tables grow, it will take too much time to execute. Thanks in advance, Dimitar - 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 constantly crash on BLOB insertions...
hi, the fatal "MySQL gone away..." error remains outstanding even after i upgraded 3.22.25 to 3.23.31 just now. i also run mysql_convert_table_format with my database, which should have converted all tables to MyISAM format. does anybody have good idea of working around this? i cannot go on any more!!! s.o.ss.o.ss.o.s thanks. peter - Original Message - From: Huang-Ming To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, January 22, 2001 9:33 AM Subject: MySQL constantly crash on BLOB insertions... hi sirs, i met a serious bug on inserting a 900+KB data into a LONGBLOB column. the error shows "MySQL server has gone away on executingSQL= INSERT INTO ebody(rtime,body,size,subj,pri,froms,tos,ccs,bccs,nattach,msgid) VALUES(date_add(curdate(),interval curtime() hour_second),?,?,?,?,?,?,?,?,?,?) " it seems occurring only on insertions of "big data", eg. data500KB. but when the error occurs, it still has NO problem to insert smaller data, eg. 100KB- data. so the fault might happen only to big data insertion. i'm using MySQL 3.22.25. this is schema of table 'ebody': (it has 75 rows now) create table ebody( bid integer auto_increment not null, msgid varchar(80) not null, bodylongtext, length integer, subjvarchar(128), pri tinyint, rtime datetime, froms varchar(80), tos text, ccs text, bccstext, nattach tinyint, # KEY i_msgid (msgid(8)), PRIMARY KEY (bid) ); for your easier insepction, i also attach log message of my application which is a Perl5 script and is NOT running under mod_perl. at your earliest convenience, please advise me on how to go on inserting big data to this table. eg., should i need to upgrade to 2.23.31 for this problem. thanks a lot. Peter Pan
Re: explain select question
Dimitar Boiadjiev wrote: Hi all, I've been working on optimizing my query but no success. Concerning the type of query shown by "explain select", about join type "ALL" in the manual is written: "This is normally not good if the table is the first table not marked const, and usually very bad in all other cases." So, I added indexes on all columns involved in join but "explain select" still shows the same result. Am I missing something or this is inevitable and can't be optimized. Below are some snippets. +-+--++--+-+--+--+--+ | table | type | possible_keys | key | key_len | ref | rows | Extra| +-+--++--+-+--+--+--+ | firm| ALL | fikey,fiuserid | NULL |NULL | NULL | 11 | | | product | ALL | prfikey| NULL |NULL | NULL | 25 | range checked for each record (index map: 2) | | users | ALL | userid | NULL |NULL | NULL | 96 | range checked for each record (index map: 1) | +-+--++--+-+--+--+--+ 3 rows in set (0.00 sec) If there are so small quantity of rows in table then full scan is faster than using indexes. I do not remember exact amount but maybe it was 300 rows in table below what MySQL doesn't use indexes. Indexes get used if there are more rows in table. This is normal and feature and good :) -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installing Mysql on a cobalt raq4
If you want to install MySQL on a RaQ4 go to the Cobalt web site at http://pkg.nl.cobalt.com. You will find a special .pkg file the will install in just a few minutes. The big "BUT!" - you have to clear out ALL traces of any previous MySQL installation. We got our hosting operation to reload the entire Cobalt operating system as standard from scratch to ensure we were clean. Then it worked. Jim
Mysql and Lotus
Hi, I am using Mysql version 3.22.32 and MyODBC version 2.50.3300 to connect to a Lotus Approach 97 front-end. I have been having some problems with boolean values. Is there anybody out there that has used Mysql with Lotus Approach, you may be able to offer me some help. Regards --- Faizal Mangera Systems Department CarnaudMetalbox Engineering Shipley West Yorkshire BD17 7AY Tel: 01274 846386 Fax: 01274 846201 [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the confidential use of the above named recipient. If you are not the intended recipient or person responsible for delivering it to the intended recipient, you have received this communication in error and must not distribute or copy it. Please accept the sender's apologies, notify the sender immediately by return e-mail and delete this communication. Thank you. - 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
Help with Dates
I have a script that saves a date in to a mySQL database. The date I want to be saved is 14 days from the current date. So for example today's date is January 22, 2001, the date I want saved is February 5, 2001. However when I add 14 days onto the day part part of the day I get January 36, 2001 and the mySQL database allows that to be saved!! Not very efficient. Anyhow how can I correct the problem above without going into and extensive programming to check the month, the number of days in the month etc., other programming langauges do the date check internally, does either mySQL or Perl do it in anyway? Thanks, Mike - 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
Veeery slow.
Hi. I'm running a mysql database, to which queries seem to take way too much time. The database contains just two tables, each with approx 10.000 rows. Simple select() calls to these can take more than a minute. Can this be right? My platform is a RedHat 6.1, running MySQL-3.22.32-1. Should I upgrade to RH 7.0 and MySQL-3.23-32? -- Torkil Grindstein Mail: [EMAIL PROTECTED] System Architect Web: http://www.fast.no Fast Search Transfer ASAPhone: +47 21 60 11 90 Grnnegata 80, Pb 571 Fax: +47 77 69 66 89 NO-9261 Troms, NORWAYMob: +47 98 06 61 38 Try FAST Search: http://www.alltheweb.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
MySQL on Netware - Again!
Hello Folks! Again someone is asking for MySQL on Netware. Sorry if you guys are tired of this... but Netware is all over... I ve checked the list archives, found some threads about this topic. Developers seem to be disapointed with lack of support from Novell, dev tools, etc. We have a couple of test servers running MySQL on FreeBSD and Linux - just fine - as you guess. But in some places, running on Netware would be just better. We are now starting a small "project" to see how far we go with Netware + Apache + MySQL + PHP . We have some tools (CodeWarrior), some time, some test machines. And I dont think Novell Dev Support is that bad. I would appreciate if someone could exchange some info related to this - someone ever tried? Thanks, Diego D. Diego Deboni Rossetto - [EMAIL PROTECTED] MCNE Intranet / Internet Qualityware Info Ltda R. Cons. Laurindo, 825 cj 412 80060-100 Curitiba - PR Brasil 55-41-232-112 - 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: order by ( bug or undocumented feature )
Mark Papadakis writes:
Hi all,
I was wondering what's wrong with a query like this:
select itemlist , sum(field1), count(*) as cnt from table where where conditions
group by id having cnt=2 order by field_x, field_y desc limit 10
I am expecting to get the requested rows order by field_x. Those with same value (
as in field_x=5 ) should be additionaly ordered by field_y. So for example I 'd get:
field_x, field_y
52
52
51
50
45
38
and so on.
Am I missing the point of order by here? If so, what is the best way/fastest way to
achieve the required results set?
Please, reply directly to me ( [EMAIL PROTECTED] ) if possible.
Thank you,
Mark Papadakis
RD Director - Web Division
Phaistos Networks, S.A. - http://www.phaistosnetworks.gr
[EMAIL PROTECTED] T:+30-892-23855 F:+30-892-22670
- A DOL Digital Company
Hi!
Your problem is quite simple.
Columns not listed in select_list , but used in order by and / or
group by, are silently added to the select_list.
In your case this happens with id field.
This is perfectly in accordance with ANSI SQL standards.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unexplained high-loads on FreeBSD
Does a downgrade to MySQL 3.22.x help ? (seems less work to me, but I'l
investigate the other possibilities anyway).
Sinisa Milivojevic wrote:
Herald van der Breggen writes:
Hello Noor,
I am struggling with a similar problem on a linux based system. It's a
Netfinity 4500R, dual pentium, RAID-5 with a rather new ServeRaid-4L
scsi controler.
On certain moments, mostly in the peak hours, mysql suddenly behaves
weird and the load increases very very quick. The swap used is also
increasing very quick (was that also the case on your system ?).
We use mysql in combination with Apache::Session which uses GET_LOCK. We
saw that no lock could be obtained, which could be the cause for an
increase og threads being used.
At the moment the wevserver and mysql server are restarted automically
when the number of threads is higher than 60 (by a cron job), which is a
clumbsy solution of course
I have seen this problem with 3.23.29-beta, 3.23.30-gamma and 3.23.31.
I consider downgrading to 3.22.x :-/
Herald
Hi!
The above is an already reported problem that occurs only on SMP Linux
on the high load.
A solution is to try kernel 2.4, glibc 2.2 (when stable) and to build
properly MySQL on that setup.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: A report generator MySQL
I am writing a database to store student academic records at my local high school. I wish to generate attractively published reports home to parents. Does anybody know of a method or product that will produce elegantly formatted reports from MySQL? StarOffice can create reports from MySQL databases and it's free. Adam Stein -- Adam Stein @ Xerox Corporation Email: [EMAIL PROTECTED] Disclaimer: All views expressed here have been proved to be my own. [http://www.csh.rit.edu/~adam/] - 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: Unexplained high-loads on FreeBSD
Hi Sinisa
Is the FreeBSD problem previously submitted by me known to you?
Noor
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 3:32 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Unexplained high-loads on FreeBSD
Herald van der Breggen writes:
Hello Noor,
I am struggling with a similar problem on a linux based system. It's
a
Netfinity 4500R, dual pentium, RAID-5 with a rather new ServeRaid-4L
scsi controler.
On certain moments, mostly in the peak hours, mysql suddenly behaves
weird and the load increases very very quick. The swap used is also
increasing very quick (was that also the case on your system ?).
We use mysql in combination with Apache::Session which uses GET_LOCK.
We
saw that no lock could be obtained, which could be the cause for an
increase og threads being used.
At the moment the wevserver and mysql server are restarted
automically
when the number of threads is higher than 60 (by a cron job), which
is a
clumbsy solution of course
I have seen this problem with 3.23.29-beta, 3.23.30-gamma and
3.23.31.
I consider downgrading to 3.22.x :-/
Herald
Hi!
The above is an already reported problem that occurs only on SMP Linux
on the high load.
A solution is to try kernel 2.4, glibc 2.2 (when stable) and to build
properly MySQL on that setup.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with Dates
Yes, mysql can do date arithmetic. Read up on date_add and date_sub functions in the manual. -- Richard Ellerbrock [EMAIL PROTECTED] Mike Podlesny [EMAIL PROTECTED] 2001/01/22 03:01:10 I have a script that saves a date in to a mySQL database. The date I want to be saved is 14 days from the current date. So for example today's date is January 22, 2001, the date I want saved is February 5, 2001. However when I add 14 days onto the day part part of the day I get January 36, 2001 and the mySQL database allows that to be saved!! Not very efficient. Anyhow how can I correct the problem above without going into and extensive programming to check the month, the number of days in the month etc., other programming langauges do the date check internally, does either mySQL or Perl do it in anyway? Thanks, Mike - 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: Replication with three servers - How to do this ?
Amiph wrote: Hi ! Ok. I've made correctly replication with two servers in a two-way replication. Both servers are master/slave. But I would like to know if is it possible to make three servers to replicate and receive the updates from each others like this: a sends updates to b and c a receives updates from b and c b sends updates to a and c b receives updates from a and c c sends updates to a and b c receives updates from a and b Anyone have got an idea ? I've got another question. How to use the log made with --log-slave-updates to transmit updates in another database ? Thanks Jimmy Aside from the fact that the replication is not really supposed to be two-way, doing it the way you suggest would set up two counter-rotating replication whirlwinds. Set up a bidirectional from a to b, and another from a to c. Updates to c will go to a, and out to b. Updates on b will go to a, and out to c. Updates on a will go to both b and c. It is not ballanced. so recovery after a hardware failure will be more difficult. - 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 on Netware - Again!
I have replied to this before and you would have found it in the archives too. Novell lacks a thread library! If you can port a thread library or write your own, you maybe able to get it to work. The thread library is the key to making MySQL work. If you have that, you are 95% there! -- Richard Ellerbrock [EMAIL PROTECTED] Diego Deboni Rossetto [EMAIL PROTECTED] 2001/01/22 03:23:19 Hello Folks! Again someone is asking for MySQL on Netware. Sorry if you guys are tired of this... but Netware is all over... I ve checked the list archives, found some threads about this topic. Developers seem to be disapointed with lack of support from Novell, dev tools, etc. We have a couple of test servers running MySQL on FreeBSD and Linux - just fine - as you guess. But in some places, running on Netware would be just better. We are now starting a small "project" to see how far we go with Netware + Apache + MySQL + PHP . We have some tools (CodeWarrior), some time, some test machines. And I dont think Novell Dev Support is that bad. I would appreciate if someone could exchange some info related to this - someone ever tried? Thanks, Diego D. Diego Deboni Rossetto - [EMAIL PROTECTED] MCNE Intranet / Internet Qualityware Info Ltda R. Cons. Laurindo, 825 cj 412 80060-100 Curitiba - PR Brasil 55-41-232-112 - 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: Unexplained high-loads on FreeBSD
Noor Dawod writes:
Hi Sinisa
Is the FreeBSD problem previously submitted by me known to you?
Noor
Ken Manzel has submitted many valuable messages to this mailing list
concerning many important patches for FreeBSD 4.* threads.
He has even provided names of files and dates when they were released.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Win NT/2000 mySQL question
Hello, Hope this list is right for a newbie question. I would like using mySQL as an ODBC-database on a Win NT Server with MIS, ... That means, I am having a Website developed with ASP/SQL-Server, and I just would like changing the databaseserver (SQL-server out, mySQL in ) The ASP-clientside SQL-queries are just standard SQL - nothing SQL-server specific. Also there are a few Visual Basic-SQLclients accessing the database. All is working similar as an editorial system. Cause I didn't work with mySQL till now, I'm having a few questions: 1. Could it work ? Is it possible running mySQL as an ODBC-database ? Are there any tutorials out ? 2. If yes - could there be any incompatible probs with the ASP-SQLqueries ? 3. Any problems with ASP as a Scripting language ? Any probs with MIS (Information Server) ? 4. Is it possible processing queries multithreaded ? 5. Any experiences with Access as a mySQL-client via ODBC for databaseadministration ? thanks, Marc Hafner
Re: Unexplained high-loads on FreeBSD
Sinisa Milivojevic wrote: Hi! The above is an already reported problem that occurs only on SMP Linux on the high load. A solution is to try kernel 2.4, glibc 2.2 (when stable) and to build properly MySQL on that setup. Regards, Sinisa Do you know whether the problem is related to glibc 2.1, or to the 2.2 kernel or to both ? With other words : do I really need the 2.4 kernel, which will be al lot of work, since a lot has changed (firewalling for example !). Herald - 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 constantly crash on BLOB insertions...
hi Tim, thanks for the prompt response which is hard to be seen with Oracle and Microsoft. sorry, i should have had studied hard the manual a year ago. regarding the error, however, would the error message be better to tell users to adjust relevant configuration than only to say "MySQL gone away"? it's misleading to some serious fault in MySQL which actually is not therein, isn't it? thanks anyway. peter - Original Message - From: Thimble Smith [EMAIL PROTECTED] To: Huang-Ming [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 22, 2001 7:04 PM Subject: Re: MySQL constantly crash on BLOB insertions... On Mon, Jan 22, 2001 at 12:33:46PM +0200, Thimble Smith wrote: I can repeat this problem; I'm looking into it and we'll hopefully have a patch for it shortly. Well, the problem is simply that max_allowed_packet needs to be increased. Check the manual entry. http://mysql.tonnikala.org/doc/S/H/SHOW_VARIABLES.html Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland (for a few weeks) ___/ www.mysql.com
Re: Access denied ... /mysql.sock Problem
Laurie Savage wrote: I am unable to connect to MySQL either as root or user unless I issue a "mysqld --socket=/var/lib/mysql/mysql.sock - u root" command. This is good for all users as long as the machine is booted. I have checked Ksysv and mysql is enabled at startup. I have copied/renamed the myxxx.conf files into /etc and ~user directories and edited them to contain a pointer to the sock file. I have also edited the mysql startup script to contain the line "socket=/var/lib/mysql/mysql.sock" No luck, what am I missing here? It is /etc/my.cnf not myxxx.conf. if your socket is in /var/lib/mysql, then /var/lib/mysql needs to have permissions set to 775. I put my socket elsewhere ( NOT in /tmp ). - 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 do I know if a record exsist?
Hi,
I'm using Perl to maintain a database. I'd like to search for a record
in a database and if it does not exist, add it. Otherwise, just update
the fields. In my script, I have:
$sqlCmd = $dbh-prepare("SELECT PortName FROM Ports where PortName =
'$port' ");
$sqlCmd-execute();
Where '$port' is a scaler variable.
If the record exists, I suppose I can do an INSERT. If not, I'll do an
UPDATE. I can't seem to find the code/function to check for this simple
test.
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: Win NT/2000 mySQL question
Hi Marc, All your questions could be answered at: http://www.scibit.com/MySQLX try the Sample Website Hello, Hope this list is right for a newbie question. I would like using mySQL as an ODBC-database on a Win NT Server with MIS, ... That means, I am having a Website developed with ASP/SQL-Server, and I just would like changing the databaseserver (SQL-server out, mySQL in ) The ASP-clientside SQL-queries are just standard SQL - nothing SQL-server specific. Also there are a few Visual Basic-SQLclients accessing the database. All is working similar as an editorial system. Cause I didn't work with mySQL till now, I'm having a few questions: 1. Could it work ? Is it possible running mySQL as an ODBC-database ? Are there any tutorials out ? 2. If yes - could there be any incompatible probs with the ASP-SQLqueries ? 3. Any problems with ASP as a Scripting language ? Any probs with MIS (Information Server) ? 4. Is it possible processing queries multithreaded ? 5. Any experiences with Access as a mySQL-client via ODBC for databaseadministration ? thanks, Marc Hafner - 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: Unexplained high-loads on FreeBSD
Hi Sinisa and everyone,
I have a question for Noor, after updating freeBSD-stable last
week, I assume you did a "make world", but did did you recomiple
MySQL under that update? The compiler itself was broken on the older
FreeBSD and was not fixed till the 12th of Jan (except by patches on
the mailing list!). Also my setting with memory and such are VERY
conservative. We are mostly using the MySQL defaults. I will be
increasing this soon. Our current servers run about 9 queries per
second. (They are quiet at night).
Solaris threads may be an excellent OS, however it is too expensive
for our market. I have found FreeBSD groups to be very responsive to
threads issues, with patches being issued as soon as a repeatable
test case is identified.
All of this does not mean that there may not also be a problem with
MySQL, that would be common to all platforms, however in my
experience, most of these sorts of issues were threads related.
Hope this helps. Ken
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "Sinisa Milivojevic" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, January 22, 2001 9:25 AM
Subject: RE: Unexplained high-loads on FreeBSD
Noor Dawod writes:
Hi Sinisa
Is the FreeBSD problem previously submitted by me known to you?
Noor
Ken Manzel has submitted many valuable messages to this mailing list
concerning many important patches for FreeBSD 4.* threads.
He has even provided names of files and dates when they were
released.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
announcement: mssql2mysql database converter
mssql2mysql converts Microsoft SQL Server databases to MySQL mssql2mysql is VB/VBA code (you need VB6 or a VBA6 capable program such as Excel 2000 or Word 2000 to run it) mssql2mysql is free (GPL) for more informations see: http://www.kofler.cc/mysql/ Michael Kofler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How do I know if a record exsist?
Don wrote:
Hi,
I'm using Perl to maintain a database. I'd like to search for a record
in a database and if it does not exist, add it. Otherwise, just update
the fields. In my script, I have:
$sqlCmd = $dbh-prepare("SELECT PortName FROM Ports where PortName =
'$port' ");
$sqlCmd-execute();
$rc = $sqlCmd-execute().
$rc is the return code.
Where '$port' is a scaler variable.
If the record exists, I suppose I can do an INSERT. If not, I'll do an
UPDATE. I can't seem to find the code/function to check for this simple
test.
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: INSTALLATION QUESTION on Cobalt Raq3
"l" == lkeeton [EMAIL PROTECTED] writes: l First does anybody know the website address for that searchable l site that allows you to search on mysql archive emails. I would l appreciate if I could get that. I also am looking for opinions on Does anyone read the footers on the messages they get from the mailing list or are they just wasting electrons on my box? - 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
Full-Text Query
Good Day All,
This will work...
mysql SELECT storyID, title, summary, MATCH summary AGAINST (LCASE('news'))
AS probability
- FROM newsStories WHERE MATCH summary AGAINST (LCASE('news')) 0
LIMIT 0, 5;
But this will not...
mysql SELECT COUNT(*), MATCH summary AGAINST (LCASE('news')) AS probability
- FROM newsStories WHERE MATCH summary AGAINST (LCASE('news')) 0;
ERROR 1140: Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP
columns is illegal if there is no GROUP BY clause
I have two questions;
1)
What I'm trying to do is get a number of records that will match this
criteria. Has anyone
run into this same problem before?
2)
It seems that full-text searches only work on whole words. Is this correct.
For example, if summary = "The Blackhawks won 5-4 in a wild hockey game",
then the following query didn't return anything...
mysql SELECT storyID, title, summary, MATCH summary AGAINST
(LCASE('hawks')) AS probability
- FROM newsStories WHERE MATCH summary AGAINST (LCASE('hawks')) 0
LIMIT 0, 5;
Maybe if I tried regular expressions??
Cheers,
Chris Oson
-
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 and Lotus
Hi, Thought I'd try sending the message again, maybe you all missed the first time. I am using Mysql version 3.22.32 and MyODBC version 2.50.3300 to connect to a Lotus Approach 97 front-end. I have been having some problems with boolean values. Is there anybody out there that has used Mysql with Lotus Approach, you may be able to offer me some help. Regards --- Faizal Mangera Systems Department CarnaudMetalbox Engineering Shipley West Yorkshire BD17 7AY Tel: 01274 846386 Fax: 01274 846201 [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the confidential use of the above named recipient. If you are not the intended recipient or person responsible for delivering it to the intended recipient, you have received this communication in error and must not distribute or copy it. Please accept the sender's apologies, notify the sender immediately by return e-mail and delete this communication. Thank you. - 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: Unexplained high-loads on FreeBSD
Hi Noor, Here is my my.cnf file, it has almost nothing in it. [mysqld] port=3306 set-variable = max_allowed_packet=1M log-update [mysql.server] user=mysqladm [mysqldump] And Here are some stats for you, it sounds like our servers are very close. I am using DELL 2400's with 2 processors. I do NOT have SMP enabled on FreeBSD yet. Although I have a new test server I am just setting up that does have SMP on it. Nor do I have apache running on the same server. I find the CPU load to be very low. Are you running SMP? Have you modified the GENERIC kernel? There must be something different between our two systems, maybe we could take this discussion private find the answers then just post our results to the list. mysqladmin -uken -p status Enter password: Uptime: 350099 Threads: 55 Questions: 3161869 Slow queries: 1 Opens: 17814 Flush tables: 1 Open tables: 64 Queries per second avg: 9.031 PID USERNAME PRI NICE SIZERES STATETIME WCPUCPU COMMAND 11507 sysadm28 0 1880K 1056K RUN 0:00 1.45% 0.73% top 3346 mysqladm 2 0 20884K 16932K poll 130:06 0.00% 0.00% mysqld 117 root 2 -12 1256K 716K select 0:16 0.00% 0.00% ntpd 167 root 2 0 2496K 1240K select 0:02 0.00% 0.00% sendmail 164 root 10 0 952K 560K nanslp 0:01 0.00% 0.00% cron 114 root 2 0 916K 532K select 0:01 0.00% 0.00% syslogd 171 root 2 0 2092K 848K select 0:00 0.00% 0.00% sshd 256 root 3 0 1332K 812K ttyin0:00 0.00% 0.00% csh 11495 sysadm18 0 1328K 808K pause0:00 0.00% 0.00% tcsh 206 root 10 0 632K 232K wait 0:00 0.00% 0.00% sh 11410 sysadm 3 0 1328K 808K ttyin0:00 0.00% 0.00% tcsh 11494 root 2 0 2136K 1316K select 0:00 0.00% 0.00% telnetd 162 root 2 0 1032K 592K select 0:00 0.00% 0.00% inetd 11409 root 2 0 2136K 1316K select 0:00 0.00% 0.00% telnetd - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Noor Dawod" [EMAIL PROTECTED] To: "Ken Menzel" [EMAIL PROTECTED]; "Sinisa Milivojevic" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 22, 2001 11:49 AM Subject: RE: Unexplained high-loads on FreeBSD Hi Ken, After making the world last week, I've updated sources for Apache, MySQL, PHP and mod_ssl. Afterwards, recompiled all of them, stopped previous instances, installed them again and then started all of them. So yes, I did recompile MySQL. Regarding the conservative configuration settings, this is as you said the default values. Our server has between 5-20 queries per second (almost quiet at night), so our servers are almost alike. What do you suggest for the values of the variables in my.cnf? TIA Noor -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 6:09 PM To: Sinisa Milivojevic; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Unexplained high-loads on FreeBSD Hi Sinisa and everyone, I have a question for Noor, after updating freeBSD-stable last week, I assume you did a "make world", but did did you recomiple MySQL under that update? The compiler itself was broken on the older FreeBSD and was not fixed till the 12th of Jan (except by patches on the mailing list!). Also my setting with memory and such are VERY conservative. We are mostly using the MySQL defaults. I will be increasing this soon. Our current servers run about 9 queries per second. (They are quiet at night). Solaris threads may be an excellent OS, however it is too expensive for our market. I have found FreeBSD groups to be very responsive to threads issues, with patches being issued as soon as a repeatable test case is identified. All of this does not mean that there may not also be a problem with MySQL, that would be common to all platforms, however in my experience, most of these sorts of issues were threads related. Hope this helps. Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Sinisa Milivojevic" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 22, 2001 9:25 AM Subject: RE: Unexplained high-loads on FreeBSD Noor Dawod writes: Hi Sinisa Is the FreeBSD problem previously submitted by me known to you? Noor Ken Manzel has submitted many valuable messages to this mailing list concerning many important patches for FreeBSD 4.* threads. He has even provided names of files and dates when they were released. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_
Re: Error in UPDATE syntax?
Don wrote:
Hi,
I'm looking at the docs for the UPDATE syntax right now!
Here is my code (in Perl):
$sqlCmd = $dbh-prepare("UPDATE Ports SET Country = $country,
TransPort = $transPort,
Suspended = $suspended,
Transit = $transit,
Tranship = $tranship,
CargoDisp = $disposition
WHERE PortName = $port");
When I issue an: $sqlCmd-execute() or die "Can't execute statement:
$DBI::errstr";
I get the following error message:
DBD::mysql::st execute failed: Unknown column 'GERMANY' in 'field list'
at myprog.pl line 164. Can't execute statement: Unknown column
'GERMANY' in 'field list' at myprog.pl
line 164.
Ports is my table. "GERMANY" is actually the contents of the scaler
array $country, so why is it giving me an unknown column error?
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
Try single quoting the scalar eg ("UPDATE Ports SET Country =
'$country', etc etc")
Stuart
-
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 -- using mysql_ping()
If a connection has been closed by the mySQL server, like in a timeout condition, does the API function mysql_ping() awake the connection again if the reconnect flag was set, or will it just return a lost server error? In other words, if I'm testing to see if a long-unused connection is dead before I close it by calling mysql_ping(), am I then forced to call mysql_close() or can I assume the connection is closed and lost and just free up the memory I've used for the connection? If I call mysql_close() on a connection that's already closed, will it just return quietly or will it segfault? - 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 vs Oracle
Ann Ricchiazzi wrote: Dear mySQL Users, I am trying to choose between mySQL and Oracle for a Linux server. My specific questions are: 1) Will mySQL handle 3000 hits/day well? 2) Does mySQL handle multi-media file formats? For example, if I want to store audio clips, or Flash movie clips, or PowerPoint presentations, can I do so? We make the decision this decision at 3:00 today. Your advice will be most helpful. Thanks, Ann 1) is VERY dependant on how many of the hits access the database how many read/write querires.. etc etc.. To answer the question of load you should try to get it down to queries/minute at least.. It also depends on hardware, optimization of queries, etc etc. 2) Yes, you can put anything you want into a mysql database, mysql doesn't know the difference bewteen Falsh and PowerPoint but it doesn't care if you put them in there. - 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 vs Oracle
On Mon, 22 Jan 2001 10:49:28 -0800, Ann Ricchiazzi ([EMAIL PROTECTED]) wrote: Dear mySQL Users, I am trying to choose between mySQL and Oracle for a Linux server. My specific questions are: 1) Will mySQL handle 3000 hits/day well? I'm on a site that does 90,000 database-heavy pages a day and it's doing great. 2) Does mySQL handle multi-media file formats? For example, if I want to store audio clips, or Flash movie clips, or PowerPoint presentations, can I do so? sure, but it's usually easier to keep them on a filesystem, and just put the filename in the database. - Mark - 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 vs Oracle
Hello Ann, The answer to you question depends on how you plan to use the database (i.e. financial trancactions, serving data on the web etc.) as well as financial considerations. MySQL is free and Oracle is expensive. Here are some questions you should answer: 1.) Do you need full Transaction support (commit roll-back)? 2.) Do you need subselect and union queries? 3.) Do you need Triggers and Stored Procedures? 4.) Do you absolutely need Foreign Key support? If you anwered YES to any of the above go with Oracle, Sybase, Frontbase, Openbase etc. otherwise, MySQL is an excellent choice. MySQL is very fast and probably faster than Oracle in most cases but I have no documented proof (Oracle doesn't like having their benchmarks published). I know this isn't a definite answer and you are on a tight deadline. Hope this helps just the same. ___ Scott A. Gerhardt P.Geo. Gerhardt Information Technologies [EMAIL PROTECTED] ___ I am trying to choose between mySQL and Oracle for a Linux server. My specific questions are: 1) Will mySQL handle 3000 hits/day well? 2) Does mySQL handle multi-media file formats? For example, if I want to store audio clips, or Flash movie clips, or PowerPoint presentations, can I do so? We make the decision this decision at 3:00 today. Your advice will be most helpful. Thanks, Ann - 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
select HELP from HERE where HELP_NEEDED = TRUE !
hi, i have a web serverrunning redhat linux 7 i installed mysql 3.23.30 two weeks ago and it has begun to cause problems i get a "lost connection during query" every half a minute, basicly my web site is dead i tried instaling the 3.23.32 ( stable you call it! ) and i get the same response i'm in desparate need for help... !!! H E L P ! ! ! 10q amir [EMAIL PROTECTED]
Re: Win NT/2000 mySQL question
Thanks Jacques Christopher, you are telling on your site (compliment, really nice work), that your MySQLX-component is quicker then ODBC. Any benchmarking about it ? Also - does your component support ADO-objects ? - specially Recordsets .. or do you have something similar ? How can you access mySQL with Mascon ? Only via this ActiveX or also with ODBC ? Back to Win NT: On the WinNT-Server I only will run mySQL accessing via an ODBC networkconnection. Are there any disadvantages running mySQL on NT, not Linux - Linuxfans keep cool !;) .. I mean just for this kind of application Or - what is recommended ? Running IIS and mySQL on one Server ? Should I know anything else ??? ;) cu, MArc -Ursprngliche Nachricht- Von: Jacques Venter [EMAIL PROTECTED] An: Juergen Haefner [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Datum: Montag, 22. Januar 2001 15:52 Betreff: RE: Win NT/2000 mySQL question Hi Marc, All your questions could be answered at: http://www.scibit.com/MySQLX try the Sample Website Hello, Hope this list is right for a newbie question. I would like using mySQL as an ODBC-database on a Win NT Server with MIS, ... That means, I am having a Website developed with ASP/SQL-Server, and I just would like changing the databaseserver (SQL-server out, mySQL in ) The ASP-clientside SQL-queries are just standard SQL - nothing SQL-server specific. Also there are a few Visual Basic-SQLclients accessing the database. All is working similar as an editorial system. Cause I didn't work with mySQL till now, I'm having a few questions: 1. Could it work ? Is it possible running mySQL as an ODBC-database ? Are there any tutorials out ? 2. If yes - could there be any incompatible probs with the ASP-SQLqueries ? 3. Any problems with ASP as a Scripting language ? Any probs with MIS (Information Server) ? 4. Is it possible processing queries multithreaded ? 5. Any experiences with Access as a mySQL-client via ODBC for databaseadministration ? thanks, Marc Hafner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL vs Oracle
"AR" == Ann Ricchiazzi [EMAIL PROTECTED] writes: AR I am trying to choose between mySQL and Oracle for a Linux server. My AR specific questions are: AR 1) Will mySQL handle 3000 hits/day well? You need to define what a "hit" is. Is it a simple select on the primary key of a single table or a multi-table join without indexes? How are your "hits" distributed over the duration of the day? Also, how big are you expecting your data tables to be? I'd venture to say that yes, MySQL can handle 3000 queries per day, but it is hard to say without knowing what your load expectations are. AR 2) Does mySQL handle multi-media file formats? For example, if I want to AR store audio clips, or Flash movie clips, or PowerPoint presentations, AR can I do so? MySQL can store binary objects. You probably don't want to do that for these things but instead store a pointer to a URL or filesystem location. The file system access would be much faster than cramming the data down the database socket connection. AR We make the decision this decision at 3:00 today. Your advice will be AR most helpful. Luckily you're on the west coast. It is already 3:30 here. ;-) - 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
DbTools question/feature suggestion (EXCEL)
Hi folks I have downloaded DB tools and took a quick look at it and it seemed to me that exporting from excel table can only be done by creating some new table for that purpose in the db. But what do I want to do? I`d like to copy the contents of excel file to an existing table into fields that I will have the chance to set myself. If it isnt possible right now or even if it was, I have some feature suggestion to the creator of Dbtools: * there should be possibility to tell the program that "I want to the text from the full first row to be written to the mytable col1 and then starting from the row number 5 add column A information to mytable col3 and column B to col4 AND column C to col5" and so on. * And then could be the following feature as well: "Take some substring from some excel column X and write it to the db table to mycol and take another substring from the excel column X and write this to another column in the database table". It would be really great to have these features as well, this would make things much easier. So if possible, I would appreciate it. Or does anyone know of any other free tools that could handle it? Thanks Siim Einfeldt [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
Running mysql_install_db will not create grant tables
Description: httpd5%14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_fstat 14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_stat 14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: __cf_fprintf 14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_lstat 14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: __cf_printf 14664:./bin/my_print_defaults: /sbin/loader: Fatal Error: this executable has unresolvable symbols Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables %DECthreads bugcheck (version V3.18-042), terminating execution. % Reason: stkGet: (4) nxm_stack_create (0,5251072,16384,8192) % Running on OSF1 V4.0(1091) on , 512Mb; 1 CPUs, pid 10588 Installation of grant tables failed! Starting mysqld daemon with databases from /usr/local/mysql-3.23.31-dec-osf5.1-alphaev6/data 010122 13:05:31 mysqld ended How-To-Repeat: Run scripts/mysql_install_db Fix: Submitter-Id: Derek P. Chang Originator:system PRIVILEGED account Organization: Scripps Institute of Oceanography - CRD MySQL support: [none | licence | email support | extended email support ] Synopsis: Won't create grant tables using mysql_install_db Severity: Priority: Category: mysql Class: Release: mysql-3.23.31 (Official MySQL binary) Environment: System: OSF1 ecpc.ucsd.edu V4.0 1091 alpha Machine: alpha Some paths: /meteora/local/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='cc -pthread' CFLAGS='-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all' CXX='cxx -pthread' CXXFLAGS='-O4 -ansi_alias -fast -inline speed -speculate all -noexceptions -nortti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root system17 Jan 13 1999 /lib/libc.a - ../ccs/lib/libc.a lrwxrwxrwx 1 root system17 Jan 13 1999 /usr/lib/libc.a - ../ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-prefix=/usr/local/mysql --with-mysqld-ldflags=-all-static --disable-shared '--with-named-thread-libs=-lpthread -lmach -lexc -lc' --disable-shared Perl: This is perl, version 5.001 - 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
Sorry, I just a bug without attaching my email address.
Description: 23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_fstat 23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_stat 23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: __cf_fprintf 23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_lstat 23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: __cf_printf 23655:./bin/my_print_defaults: /sbin/loader: Fatal Error: this executable has unresolvable symbols 18295:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: __cf_fprintf 18295:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: __cf_printf 18295:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: _F64_stat 18295:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: _F64_fstat 18295:./bin/resolveip: /sbin/loader: Fatal Error: this executable has unresolvable symbols 22436:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: __cf_fprintf 22436:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: __cf_printf 22436:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: _F64_stat 22436:./bin/resolveip: /sbin/loader: Error: Unresolved symbol in ./bin/resolveip: _F64_fstat 22436:./bin/resolveip: /sbin/loader: Fatal Error: this executable has unresolvable symbols WARNING: The host 'ecpc.ucsd.edu' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables %DECthreads bugcheck (version V3.18-042), terminating execution. % Reason: stkGet: (4) nxm_stack_create (0,5251072,16384,8192) % Running on OSF1 V4.0(1091) on , 512Mb; 1 CPUs, pid 10588 Installation of grant tables failed! How-To-Repeat: Run scripts/mysql_install_db Fix: Submitter-Id: Derek Chang Originator:system PRIVILEGED account Organization: Scripps Institute of Oceanography - CRD MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.31 (Official MySQL binary) Environment: System: OSF1 ecpc.ucsd.edu V4.0 1091 alpha Machine: alpha Some paths: /meteora/local/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='cc -pthread' CFLAGS='-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all' CXX='cxx -pthread' CXXFLAGS='-O4 -ansi_alias -fast -inline speed -speculate all -noexceptions -nortti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root system17 Jan 13 1999 /lib/libc.a - ../ccs/lib/libc.a lrwxrwxrwx 1 root system17 Jan 13 1999 /usr/lib/libc.a - ../ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-prefix=/usr/local/mysql --with-mysqld-ldflags=-all-static --disable-shared '--with-named-thread-libs=-lpthread -lmach -lexc -lc' --disable-shared Perl: This is perl, version 5.001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error in UPDATE syntax?
On Mon, 22 Jan 2001, Don wrote:
Hi,
I'm looking at the docs for the UPDATE syntax right now!
Here is my code (in Perl):
$sqlCmd = $dbh-prepare("UPDATE Ports SET Country = $country,
TransPort = $transPort,
Suspended = $suspended,
Transit = $transit,
Tranship = $tranship,
CargoDisp = $disposition
WHERE PortName = $port");
You need to use single quotes around your variables.
Ports is my table. "GERMANY" is actually the contents of the scaler
array $country, so why is it giving me an unknown column error?
$country being an array explains your problem. if $country sends the value
"USA GERMANY", mysql wont know what's going on because you're not limiting
your values.
update tablename set field = '$value';
is more correct. I suggest using debug functions that tells you what
you're trying to do so that you can try the same command in your
database. this way it's easier to see what might be wrong.
Hope this helps.
Atle
-
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 constantly crash on BLOB insertions...
"Huang-Ming" == Huang-Ming [EMAIL PROTECTED] writes: Huang-Ming hi Tim, Huang-Ming thanks for the prompt response which is hard to be seen with Oracle and Microsoft. Huang-Ming sorry, i should have had studied hard the manual a year ago. regarding the error, however, would the error message be better to tell users to adjust relevant configuration than only to say "MySQL gone away"? it's misleading to some serious fault in MySQL which actually is not therein, isn't it? The reason is that to guard against wrong usage and faulty connections, MySQL will abort any transactions that doesn't follow the protocol it enforces. In this case MySQL notices a packet that is much bigger than the maximum allowed packet size and it can't know if the packet is valid or is from someone that is trying to use mysqld in a way that the MySQL maintainer haven't approved of. Just to be safe, mysqld will in this case abort the connections and the client will get the 'MySQL gone away' error. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL vs Oracle
er, what? did i miss something? heh. -tcl. On Mon, 22 Jan 2001, Nathan Cook wrote: Note: As of version 3.2.3gamma Mysql Supports Sub-Selects. .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. Systems Network Administrator :: Programmer [ phone - 208.343.3110 ][ pager - 208.387.9983 ] - Original Message - From: "Scott Gerhardt" [EMAIL PROTECTED] To: "Ann Ricchiazzi" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 22, 2001 12:10 PM Subject: RE: mySQL vs Oracle Hello Ann, The answer to you question depends on how you plan to use the database (i.e. financial trancactions, serving data on the web etc.) as well as financial considerations. MySQL is free and Oracle is expensive. Here are some questions you should answer: 1.) Do you need full Transaction support (commit roll-back)? 2.) Do you need subselect and union queries? 3.) Do you need Triggers and Stored Procedures? 4.) Do you absolutely need Foreign Key support? If you anwered YES to any of the above go with Oracle, Sybase, Frontbase, Openbase etc. otherwise, MySQL is an excellent choice. MySQL is very fast and probably faster than Oracle in most cases but I have no documented proof (Oracle doesn't like having their benchmarks published). I know this isn't a definite answer and you are on a tight deadline. Hope this helps just the same. ___ Scott A. Gerhardt P.Geo. Gerhardt Information Technologies [EMAIL PROTECTED] ___ I am trying to choose between mySQL and Oracle for a Linux server. My specific questions are: 1) Will mySQL handle 3000 hits/day well? 2) Does mySQL handle multi-media file formats? For example, if I want to store audio clips, or Flash movie clips, or PowerPoint presentations, can I do so? We make the decision this decision at 3:00 today. Your advice will be most helpful. Thanks, Ann - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL constantly crash on BLOB insertions...
Hi. On Mon, Jan 22, 2001 at 11:37:23PM +0200, [EMAIL PROTECTED] wrote: "Huang-Ming" == Huang-Ming [EMAIL PROTECTED] writes: Huang-Ming hi Tim, Huang-Ming thanks for the prompt response which is hard to be seen with Oracle and Microsoft. Huang-Ming sorry, i should have had studied hard the manual a year ago. regarding the error, however, would the error message be better to tell users to adjust relevant configuration than only to say "MySQL gone away"? it's misleading to some serious fault in MySQL which actually is not therein, isn't it? The reason is that to guard against wrong usage and faulty connections, MySQL will abort any transactions that doesn't follow the protocol it enforces. In this case MySQL notices a packet that is much bigger than the maximum allowed packet size and it can't know if the packet is valid or is from someone that is trying to use mysqld in a way that the MySQL maintainer haven't approved of. Just to be safe, mysqld will in this case abort the connections and the client will get the 'MySQL gone away' error. Given that, a cleaner(?) way would IMHO be, that the server sends (hm. within connection approvement, if there already exists one?) the status of that variable to the client. Then the client library could check the size itself and issue itself the appropriate error. Or at least add a note that you might have hit the limit and what the current limit is. I assume there are reasons why the current implementation differs. But anyhow, the fact that even an developer *grin to Tim* considered this behaviour a possible bug, shows that it is too non-intuitive. Sorry, but my knowledge about the internals are too bad in order to make a more constructive proposal what to change. Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: select performance
Hi. I am not sure what you compare against, because the description of the second test script is not clear to me in the given context. Anyhow, the difference probably comes from the fact, that MySQL has to use indexes to find the row which matches to the id and has to access about log(65000) =~ 16 index entries (_not_ index blocks. the number of blocks depends also on other factors). The offset method only works reasonably, if you don't have (many) holes in the ids. Assume a worst case, were you have one id=1 and the following ids continue at 20. MySQL will use only 65000 records, whereas the offset method has to use space for 265000. You see? There are some more arguments about that, but it should answer your question regarding number of blocks read in. Bye, Benjamin. On Sun, Jan 21, 2001 at 08:33:49PM -0800, [EMAIL PROTECTED] wrote: Hi, I am trying to benchmark mysql's performance for fetching a random record. To do so, I have setup the following configuration: Linux, 14 2G tables, each populated with 65000 records of fixed 32k size, type mediumblob. My test randomly generates a table/id pair and selects the record. I then compare this to a different script that randomly generates a table/offset pair, seeks to the offset and reads 32k worth of data directly from the table. I have run my tests with a warm mysql key cache (mysqladmin ext shows all key blocks in the cache). Between each test, I do a 1G read of a different file to /dev/null in order to clear the system's buffer cache. When I compare the number of blocks read from the disk (via vmstat/iostat), that number is about 1.5 to twice as much for the mysqld test vs. the random read test. Does anyone have an idea of why this is the case? Why would mysqld read in almost double the amount of data? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1040: Too many connections
Hi! "Filippo" == Filippo Carletti [EMAIL PROTECTED] writes: Sometimes something bad happens in a server and it is hard to figure out what is going on because we can not get in. I'd like to suggest a change Filippo for MySQL 4 protocol, such that a connection from localhost can still get through even if there are too many connections. It is already there - max_connections limit is actually for the user Filippo without process_priv. For the user with process_priv, the limit is max_connections Filippo + 1. The trick is not to connect as root for your regular connections. Filippo There must be a problem, then. Filippo It happens to me, often, that I cannot obtain a proc or ext with mysqladmin Filippo as root. Filippo All accesses are through an unpriv username, I have max_connections=1000 and Filippo a Filippo ps ax | grep mysqld | wc -l gives me a value lower than 1000, so there must Filippo be room for one more connection. Filippo Filippo What error do you get? Are you sure that your other users dosn't have the 'PROCESS_PRIV' privilege? Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql opening tables
Hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello monty, Peter After I got mysql/system crash I often see the following after I Peter bring mysql up again: Peter ruby:~ # w Peter 9:37pm up 7:35, 1 user, load average: 0.01, 0.04, 0.06 Peter USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT Peter root pts/0mail.local9:37pm 0.00s 0.07s 0.02s w cut Peter ruby:/spylog/layers # tail -1 /spylog/db/ruby.err | grep 45/g06hits Peter 010122 15:20:46 Warning: Checking table: './st45/g06hits' Peter 010122 15:20:46 Warning: Recovering table: './st45/g06hits' Peter mysqladmin debug reports no table locks active Peter I saw this many times on different machines and this sequince never Peter resolves itself ( the locks never disapears). Always the only way to Peter fix this is to kill one of the queries. I killed query #16 and Peter situation momentaly fixed: cut Can you kill any thread when this happens to resolve the problem? Looks very strange; There is probably some broadcast that is missing after a table is repaired. I shall try to simulate this. It shouldn't be that hard. Peter The log also shows the table was repaired long ago: Peter 010122 15:16:35 Warning: Checking table: './st31/g07pages' Peter 010122 15:16:36 Warning: Recovering table: './st31/g07pages' Peter Hope this will somehow point the problem :) Peter P.S You anyway write two messages to a log file then a table is Peter automatically repaired. I think there might be a good idea to add Peter third message indicating the table was fixed successfully. I will do that. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Startup of mysqld in scripts/mysql_install_db causes SEGV
Description: I have compiled MySQL 3.23.32 on Slackware 7.1 with BerkeleyDB support. Configure, make and make install work fine without any errors, however as soon as I run scripts/mysql_install_db it fails: Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables scripts/mysql_install_db: line 1: 28667 Segmentation fault /usr/local/mysql/libexec/mysqld --bootstrap --skip-grant-tables --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var Installation of grant tables failed! gdb tells me: [New Thread 1024 (runnable)] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 1024 (runnable)] 0x0 in ?? () (gdb) bt #0 0x0 in ?? () #1 0x401e39e8 in ?? () #2 0x401dd50a in ?? () #3 0x401c795f in ?? () #4 0x401c7b14 in ?? () #5 0x401c7d7c in ?? () #6 0x4019b82c in getservbyname_r () from /lib/libc.so.6 #7 0x4019b6a4 in getservbyname () from /lib/libc.so.6 #8 0x80c43af in set_ports () #9 0x80c4602 in server_init () #10 0x80c539f in main () #11 0x400f4577 in __libc_start_main () from /lib/libc.so.6 How-To-Repeat: Compile MySQL 3.23.32 with default options (except for BerkeleyDB support) under Slackware 7.1 on a Athlon TBird 750, I assume. Fix: Wish I knew. Submitter-Id: submitter ID Originator:Rob Kaper Organization: Rob Kaper | [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] | http://capsi.com/ - telnet://chat.capsi.com:2300/ | 'What? In riddles?' said Gandalf. 'No! For I was talking aloud | to myself. A habit of the old: they choose the wisest person | present to speak to; the long explanations needed by the young | are wearying.' - "Lord of the Rings", JRR Tolkien MySQL support: [none | licence | email support | extended email support ] Synopsis: Startup of mysqld in scripts/mysql_install_db causes SEGV Severity: Priority: Category: mysql Class: Release: mysql-3.23.32 (Source distribution) Environment: System: Linux ezri 2.2.16 #22 Fri Jun 16 16:51:24 PDT 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/i386-slackware-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Nov 1 22:25 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 1013224 Mar 21 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20266642 Mar 20 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Mar 20 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --with-berkeley-db=/usr/local/BerkeleyDB.3.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
RE: SELECT FROM TABLE WHERE ?
Select * from singlemalts order by rating limit 1; Now, you have to share your samples with the rest of us! :) Cal http://www.calevans.com -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 21, 2001 12:49 PM To: [EMAIL PROTECTED] Subject: SELECT FROM TABLE WHERE ? I've tried the manual (and the Oreily MySQL book) and played around with MAX() and GREATEST() but could not figure it out. |ID |NAME |RATING | |213|McCallen 12| 9 | |214|Glenmorangie | 8 | |225|Glenlevit | 7 | How do I select the one with highest rating without knowing what the highest rating is. SELECT ID, NAME, RATING FROM SINGLEMALTS WHERE RATING - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SELECT FROM TABLE WHERE ?
select max(rating) from singlemalts will give you the highest value or select * from singlemalts order by rating desc will give all the rows ordered by rating and the first row will have the highest value Richard Reina wrote: I've tried the manual (and the Oreily MySQL book) and played around with MAX() and GREATEST() but could not figure it out. |ID |NAME |RATING | |213 |McCallen 12| 9 | |214 |Glenmorangie | 8 | |225 |Glenlevit | 7 | How do I select the one with highest rating without knowing what the highest rating is. SELECT ID, NAME, RATING FROM SINGLEMALTS WHERE RATING - 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: AW: mySQL vs Oracle
Sorry, but our mailserver is down again (Exchange ;), so I had to read via web and search my list-archiv for your mailadress. We tested the system on a Dual-P3-800Mhz-1GB while developing. Now it's running on a E4500 with 6x400Mhz and 8 Slaves (P3-800). Our site generates currently 1,5-2 Million PI's per day with rather many queries to the db's. At the moment we store only european stockdata but in february (I hope) we will add US-Stocks (about 2 times as much additional inserts). I'm confident that mysql will keep running easily. We will see ;) The main problem is I/O. We had to outsource some tables to extra discarrays to take some load from the machine. Regards On Mon, 22 Jan 2001, Christian Rabe wrote: we use mysql here for our whole site. there are up to 500 inserts/second alone from the stockdata-feed and thats only part of our site and about 200-300 selects/second per machine. in combination with replication (3.23.xx) you can near to limitlessly scale (if you have limitless money for slave-machines). we tried oracle and it was far too slow for us. mysql made our test about 30 times faster. That's some serious throughput - what kind of hardware? - 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
bdb table stability / what to watch out for?
in the mysql manual, i noticed: "Even though Berkeley DB is in itself very tested and reliable, the MySQL interface is still considered beta quality. We are actively improving and optimizing it to get it stable very soon." a team i'm in is considering trying bdb tables for some things for a queue table of sorts. seeing if the row-level granularity of bdb tables or transaction support can help us. i'm wondering what is yet considered unstable about bdb tables, or what we should watch out for or test if we try using it under a good amount of load. i saw the note about deleting tables when not in auto commit mode. anything else that is a known or unconfirmed but possible issue that we could possibly help test out? comments more than welcome! -tcl. - 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
aborted connections?
we're seeing a lot of errors like these in our error log files from mysql: 010122 17:38:52 Aborted connection 177373 to db: 'XXX' user: 'YYY' host: `ZZZ' (Got an error reading communication packets) i haven't investigated too too much about this yet, but i was wondering what common problems this error might be associated with. i'll keep looking through the manual, but suggestions would of course be wonderful. the connections are over ethernet/tcp, and the eth interfaces on the mysql server are showing 0 errors after months of uptime, so i'm guessing it's not a tcp/ip issue, as the wording of that error might suggest. -tcl. - 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/UPDATE and MyISAM table
Hi. In the MyISAM table without any deleted rows, I read in the documentation that INSERT and SELECT can occur concurrently. What about UPDATE? I presume update will issue exclusive lock to the table unlike insert, but I wanted to know for sure. Also, after deleting some rows in the table, if I do the OPTIMIZE TABLE, does the concurrent INSERT/SELECT property return? Best regards, Nat - 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/UPDATE and MyISAM table
At 12:00 PM +0900 1/23/01, Nat Sakimura wrote: ?Hi. In the MyISAM table without any deleted rows, I read in the documentation that INSERT and SELECT can occur concurrently. What about UPDATE? I presume update will issue exclusive lock to the table unlike insert, but I wanted to know for sure. In a table with no deleted rows, INSERTS happen by adding the row to the end of the table. An UPDATE won't necessarily be able to replace the row in-place (the new data may be longer than the old), so you won't be able to perform concurrent SELECTS along with the UPDATE. Also, after deleting some rows in the table, if I do the OPTIMIZE TABLE, does the concurrent INSERT/SELECT property return? Yep. -- 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: HELP! Newbie can't get MySQL to start at boot time
* Paul DuBois [EMAIL PROTECTED] [010122 21:03]: Is there a newbie resource somewhere for Those-Too-Stupid-to-Live? Did you run mysql_install_db ? Yes. Several times. :-) The database files are created in /var/mysql. There may be some confusion in this port as to where the datbase etc. files belong. Sometimes it looks in /var/mysql, sometimes in /usr/pkg/var/mysql. Thanks, Dave Chapman -- Dave Chapman |"tar is not a plaything" [EMAIL PROTECTED]|[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
Problem with make test on Msql-Mysql-modules-1.2215 with MySQL-3.23
To whom it may concern, I get this error when I run make test. Details Perl-5.003_03 MySQL-3.23.32 SCO UnixWare 7.1.1 Developement System that comes with UW 7.1.1 libz 1.1.3 What is this sysbol __llasgdivu that is referenced in libmysqlclient.so.10 used or does it come from? Does any one else have this problem? PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/local/lib/perl5/5.00503/i386-svr5 -I/usr/local/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load '../blib/arch/auto/ DBD/mysql/mysql.so' for module DBD::mysql: dynamic linker: /usr/bin/perl: relocation error: symbol not found: __llasgdivu; referenced from: /usr/local/mysql/lib/mysql/libmysqlclient.so.10 at /usr/local/lib/perl5/5.00503/i386-svr5/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4-5 Thanks, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 3748 Valley Forge Road, Magna Utah 84044 Office 801-250-0795 FAX 801-250-7975 - 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 opening tables
Hello Michael, Tuesday, January 23, 2001, 2:02:33 AM, you wrote: Peter I saw this many times on different machines and this sequince never Peter resolves itself ( the locks never disapears). Always the only way to Peter fix this is to kill one of the queries. I killed query #16 and Peter situation momentaly fixed: MW cut MW Can you kill any thread when this happens to resolve the problem? Yes. In thin case I always kill the oldest of Locked queries and problem fixes MW Looks very strange; There is probably some broadcast that is missing MW after a table is repaired. I shall try to simulate this. It MW shouldn't be that hard. The other strange thing is - not all tables are locked - some queries are running without any problems and some got stuck. MW I will do that. Thank you. -- Best regards, Petermailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL in red hat 7.0
I tried RedHat, but had the same problem getting apache and php and mysql to talk to each other. I decided to try Mandrake 7.2 and it did all the work for me. Murdmath - Original Message - From: "Luis" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 22, 2001 7:55 AM Subject: Re: PHP and MySQL in red hat 7.0 [EMAIL PROTECTED] wrote: Thanks Matt. MySQL is finally working. But the problem now is that PHP is not recognizing its MySQL functions. The error I am getting is: Fatal error: Call to undefined function: mysql_pconnect() in /var/www/html/Willy/MySQL/test1.php on line 28 Well, the php_mysql RPM has been installed along with mod_php4.rpm. PHP can recognize its own functions but not those of MySQL. I checked for the RPMs to be installed and I have installed all the php RPMs ( including php-mysql RPM). despite doing all that I get this error. MySQL is running perfect as I get the status when I type "mysqladmin -u=root status". Please help me. This is very urgent for me. Thank You. Willy -- From: Matt Wagner[SMTP:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 4:29 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: socket problem in red hat. [EMAIL PROTECTED] writes: Hi there, I am setting up a lab on MySQL and I am not able to. Its a red hat 7.0 server and has PHP installed and working with apache. I installed MySQL from the very RPMs Red Hat provided. Whenever I try to start the server, I get the error message: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (111) Well the file /var/lib/mysql/mysql.sock exists on the computer. I can't understand what this socket problem is and I went through all documentation and couldn't find a solution to this. Can you please provide a solution to this at the earliest. I have students piling on my head and I have already skipped my deadline of setting the server up. Hi! We have seen this problem (although I have not personally investigated) with many RH7+default_mysql. The quick and easy solution (until I figure out further) is to download the MySQL RPMs from: http://www.mysql.com/downloads/mysql-3.23.html Uninstall the standard RedHat 7.0 MySQL RPMs, then reinstall ours. Like I said, I'm not sure what RedHat is doing wrong with their MySQL RPMs... But I have seen this numerous times with regard to their supplied RPMs. Something is amiss. I will investigate more. Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA ___/ Developer - 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 I had the same problem with setting up php , mysql, and apache. I also notice that the rpm that redhat cd come with does not work . You have to download the tar or the rpm from the site. If you dont mind me asking, how did you set up the apache server to work with php plus if you find any doc on setting up php and mysql let me know. Thank you . Luis - 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: aborted connections?
Read the archives. The detailed story can be found there. Use newest MySQL and newest PHP CVS. These errors will go away. Maciek -Original Message- From: tc lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 3:56 AM To: [EMAIL PROTECTED] Subject: aborted connections? we're seeing a lot of errors like these in our error log files from mysql: 010122 17:38:52 Aborted connection 177373 to db: 'XXX' user: 'YYY' host: `ZZZ' (Got an error reading communication packets) i haven't investigated too too much about this yet, but i was wondering what common problems this error might be associated with. i'll keep looking through the manual, but suggestions would of course be wonderful. the connections are over ethernet/tcp, and the eth interfaces on the mysql server are showing 0 errors after months of uptime, so i'm guessing it's not a tcp/ip issue, as the wording of that error might suggest. -tcl. - 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: Win NT/2000 mySQL question
Hi Marc, Thanks Jacques Christopher, you are telling on your site (compliment, really nice work), that your MySQLX-component is quicker then ODBC. Any benchmarking about it ? Yes, although not prominent, we've had this on your site for a while: http://www.scibit.com/Products/Software/VCL/benchmark.gif This was done almost a year ago using a (winnt) MySQL table with 40 fields and 10 000 records, giving a comparison on the most used functions on a table, scrolling, posting, deleting, inserting, etc. You would be interested in the first (Blue) and last (Aqua) bars. * The Blue bar is our MySQLDataset Delphi component (http://www.scibit.com/MYSQLCOMPONENTS) using ONLY the (MySQL AB provided) libmysql.dll (straight to the server). * The Brown bar is our MySQLDataset component accessing the MySQL server in cached-updates mode. * The Yellow bar is accessing the same table created in MSAccess. * The Aqua bar is accessing the MySQL server using the standard MyODBC driver. The MySQLDataset component is used as the foundation for MySQLX (http://www.scibit.com/MySQLX) as well as Mascon (http://www.scibit.com/Mascon) Also - does your component support ADO-objects ? - specially Recordsets .. or do you have something similar ? Yes, the most important ADO calls are all available as seen in the OnLine Help File, ex. Connection, Recordset, Fields, etc. As you can see in the Help many more properties and methods are also available giving you full control and access to your MySQL server(s). It is multithreaded and able to access different databases on the server simultaneously. How can you access mySQL with Mascon ? Only via this ActiveX or also with ODBC ? Mascon is a standalone MySQL tool, to access any MySQL server (v3.21.x to v3.23.x). You ONLY need Mascon.exe and the accompanying libmysql.dll (MySQL AB developed). Mascon has no built-in support for either Active X or ODBC. Back to Win NT: On the WinNT-Server I only will run mySQL accessing via an ODBC networkconnection. Are there any disadvantages running mySQL on NT, not Linux - Linuxfans keep cool !;) .. I mean just for this kind of application We've not found any major advantages or disadvantages (we run both) that is NOT dependent on your scenario, Linux is by default more stable (nothing to do with MySQL) than NT and given the same hardware it is also faster (because of general less overhead), it is also much cheaper to maintain/upgrade (given a default installation and ignoring training and learning curves). Win2K has many more default features in the IIS and is easier/faster to manage/setup/config on a global (multiple server) scale. This is of course expected from an all in one package, while you will get many more features and functionality from your Linux box if tweaked, patched and installed with everything available (to manage this afterwards could be a challenge). Again everybody keep cool, this is just one guy's (my) opinion and is only valid for me at this point in time. Or - what is recommended ? Running IIS and mySQL on one Server ? Depends on the load the hardware is going to handle (number of hits, LAN/Internet speeds, etc). Difficult to answer; You can always start of with this config, then move the MySQL (which is probably going to do more work) to a Linux box later. Regards Jacques - 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
