Re: addition for manual section 24.5.1
On Mon, Jul 30, 2001 at 10:51:22AM +0200, Werner Stuerenburg wrote: I don't know where to send this to, so someone who knows please forward it to the appropriate address. I've submitted a doc patch to include that information. Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.29: up 58 days, processed 520,838,803 queries (102/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Permissions Problems
Hi, Can anyone explain why this is happening? root@www:/# mysql -u dgadmin -h www.4cdg.com -p cdgcatalog Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) remove the space between -p and the password. Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How do I find out more about a bug in an earlier version of MySQL?
Hello How can I find out more information about a MySQL bug fixed in release 3.23.9 and described in the change notes as 'Fixed problem with 8-bit characters as separators in LOAD DATA INFILE.'? [I wish to LOAD DATA INFILE using 0xBF as the FIELD TERMINATOR and 0xC6 as the LINE TERMINATOR but the web-server I must use has MySQL release 2.22.? Unfortunately the 4D (Macintosh) database my client is exporting the data from does not seem to support standard character escaping of the field (ie. \t and \n etc.) hence the need to use some special characters as separators.] Regards James Robertson mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL daemon and inetd
Hi, Friday, August 10, 2001, 8:05:41 PM, David Harrison [EMAIL PROTECTED] wrote: DH You can't use inetd, but if you have a machine with System V type run DH levels, the file support-files/mysql.server can be placed in DH /etc/rc.d/init.d or whatever your flavor of UNIX uses, with appropriate DH links to that file from the appropriate run level directories. DH If you are running the daemon as somebody other than root, be sure to DH install a configuration file my.cnf somewhere appropriate with the line: DH user = some_login DH in the [msqld] section. You will, of course, substitute for DH some_login. DH Without System V type run levels, you will need to edit some file such DH as /etc/rc.local to start the daemon. I nave no problem in running mysqld. But my Linux machine have only 32 Mb of RAM. I just like to make mysqld load *on demand*. I already configured Apache to run via inetd and plan to do that to any service I'll decide to enable (telnet/ftp/...) Tried that with mysqld. I didn't figure out what is the problem. Should be possible since mysqld works like other inetd daemons: binds to port and listens for connections. Does anybody tried that too? Drop me a line. Well, and I wonder why there are three mysqld processes in top display even when there is no connections at all. Is this normal? Please CC me. I'm not on the list. -- Best regards, VDAmailto:[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: MySQL daemon and inetd
VDA wrote: Hi, Friday, August 10, 2001, 8:05:41 PM, David Harrison [EMAIL PROTECTED] wrote: DH You can't use inetd, but if you have a machine with System V type run DH levels, the file support-files/mysql.server can be placed in DH /etc/rc.d/init.d or whatever your flavor of UNIX uses, with appropriate DH links to that file from the appropriate run level directories. DH If you are running the daemon as somebody other than root, be sure to DH install a configuration file my.cnf somewhere appropriate with the line: DH user = some_login DH in the [msqld] section. You will, of course, substitute for DH some_login. DH Without System V type run levels, you will need to edit some file such DH as /etc/rc.local to start the daemon. I nave no problem in running mysqld. But my Linux machine have only 32 Mb of RAM. I just like to make mysqld load *on demand*. I already configured Apache to run via inetd and plan to do that to any service I'll decide to enable (telnet/ftp/...) According to Apache documentation this mode is considered as deprecated and may be dropped in future release. Tried that with mysqld. I didn't figure out what is the problem. Should be possible since mysqld works like other inetd daemons: binds to port and listens for connections. Does anybody tried that too? Drop me a line. mysqld cannot be run with inetd. If you want to use mysqld, just start it at boot, if it not used, it will just be swapped out to disk and swapped in when necessary. So, it will not use your RAM needlessly. Well, and I wonder why there are three mysqld processes in top display even when there is no connections at all. Is this normal? Yes These are not processes but threads. ps/top on Linux don't make a difference between a thread and a process. Please CC me. I'm not on the list. -- Best regards, VDAmailto:[EMAIL PROTECTED] Regards -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
php/mysql user auth question
ok...here's the deal. I have successfully developed a script to verify user authenticity. however, i need to verify what the User Type is for purposes of redirection to a certian page. ++-+---+--+ | ID | BearID | SSN | UserType | ++-+---+--+ | 1 | Kristin_L_Barber| 2 | Student | | 2 | Christina_Barbosa | 3 | Student | | 3 | David_Beran | 4 | Student | | 4 | Sam_Bernal | 5 | Student | | 5 | Christie_Biggs | 6 | Student | | 6 | Teresa_Bland| 7 | Student | | 7 | Tiffany_Boshers | 8 | Student | | 8 | Kathy_Bowen | 9 | Student | | 9 | Aaron_Boyk | 11120 | Student | | 10 | Emily_Calvert | 11121 | Student | This is a sample of my table. how would i go about checking the user type after I have verified that the user exists in the table? I tried this query: // Determine User Type For Redirection $redirect = SELECT UserType FROM User WHERE BearID = '$PHP_AUTH_USER' AND SSN = '$PHP_AUTH_PW'; // Execute query to set User Type variable $type = mysql_query( $redirect ) or die ( 'Unable to execute query.' ); what do I need to do from here? Any suggestions? Thanx, Kit _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lost bin-log(s) following logrotate affecting recovery, replication
Environment: Red Hat 7.1
mysqld 3.23.36-log
/etc/my.cnf as follows:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-bin=/bu/mysql/online-log/iServ2
log-bin-index=/bu/mysql/online-log/iServ2.index
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
/etc/logrotate.d/mysqld (as distributed) follows:
=
/var/log/mysqld.log {
missingok
create 0640 mysql mysql
prerotate
[ -e /var/lock/subsys/mysqld ] \
/bin/kill -HUP `/bin/cat /var/run/mysqld/mysqld.pid` || /bin/true
endscript
postrotate
[ -e /var/lock/subsys/mysqld ] \
/bin/kill -HUP `/bin/cat /var/run/mysqld/mysqld.pid` || /bin/true
endscript
}
Problem Synopsis:
==
1. /etc/logrotate.d/mysql executes a kill -HUP mysqld.pid during pre
and postrotate operations.
2. -HUP causes mysqld to discard all existing bin-logs (DISASTER) and start
a new one.
3. This destroys recovery strategies built on bin-logs.
It also (as far as I can tell) will cause replication to loose logs
and integrity.
Note: This is a pretty big hole !!!
To Simulate:
=
1. Configure bin-log(s)
2. List bin-log(s)
3. kill -HUP mysqld.pid
4. Bin-log(s) from 2. will have been purged and a new log started (as if
reset master was performed).
Note: For recovery and replication to work correctly existing
bin-log(s) must be left in tact.
Any help will be appreciated.
Please advise,
Joel Fowler
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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/mysql user auth question
On Tue, 14 Aug 2001, Kit Kerbel wrote: This is a sample of my table. how would i go about checking the user type after I have verified that the user exists in the table? I tried this query: // Determine User Type For Redirection $redirect = SELECT UserType FROM User WHERE BearID = '$PHP_AUTH_USER' AND SSN = '$PHP_AUTH_PW'; // Execute query to set User Type variable $type = mysql_query( $redirect ) or die ( 'Unable to execute query.' ); what do I need to do from here? Any suggestions? I believe this would be better suited in a PHP related mailing list anyways : $result = mysql_query( $redirect ) or die ( 'Unable to execute query.' ); $row = mysql_fetch_array($result) or die ( 'No rows found.'); if ($row[UserType] == Student) // redirect for student else // redirect for others for mysql, check : http://www.php.net/manual/en/ref.mysql.php http://www.php.net/manual/en/function.mysql-fetch-array.php and for the redirect : http://www.php.net/manual/en/function.header.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
Problems with MYSQL-D-MAx for win 98 DROP TABLE
If you create a Berkeley-DB table (es. CREATE TABLE TEST TYPE BDB) is not possible delete it after. The command DELETE TABLE TEST responds Table unknown. Thank You Luciano - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 problem
Look at this MS SQL: Declare @BF char(10) Declare @BL char(10) SET ROWCOUNT 1 Select @BF=Date From Results Where GameID=1 Order by Date ASC Select @BL=Date From Results Where GameID=1 Order by Date DESC Select @BF As BF, @BL As BL -- Now wonna to implement above to mySQL: I used temprary table (is there any other way?) CREATE TEMPORARY TABLE tmp(BF char(10) not null, BL char(10) not null); INSERT INTO tmp (BF) SELECT Date From Results Where GameID=1 Order by Date ASC LIMIT 1; INSERT INTO tmp (BL) SELECT Date From Results Where GameID=1 Order by Date DESC LIMIT 1; SELECT * from tmp; DROP TABLE tmp; -- problem is INSERT INTO creates a new record every time...I tried to use UPDATE in instead the second INSERT: UPDATE tmp SET BL = (SELECT Date From Results Where GameID=1 Order by Date DESC LIMIT 1); But there is error in the syntax Questions: is there only TEMPORARY TABLE way for make it? What is wrong with this UPDATE? Cheers, Mariusz Muszalski - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Delayed
Subject : Database Hello all, We have various routines which Insert in to tables. And in some cases there are alot of rows involved, which understandably can take some time. I just want to check that my understanding of the INSERT DELAYED option is correct. When using DELAYED, are all rows 'mass' inserted once the query has finished, rather than one row being inserted at a time ? Thanks Ben Smith. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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++ 1.7.9 static lib for Mac OS X
Hi1 I have built MySQL++ lib on OS X and have uploaded static version of the library for Mac OS X on MySQL++ page. OS X users just have to install manually that library and include files and can start using it. Library is built with GNU 2.95.2 and is therefore useable only with that compiler and libstdc++ that comes with it. Beside the above, OS X users will also have to make a symlink from iostream.h to ostream.h. Library and examples has been built manually, as current libtool's are still not good enough for the normal automated build of MySQL++. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
auto_increment vs. heap tables
Hello, I am currently changing a simple PHP4-based application from PostgreSQL 7.1 to MySQL 3.23. I have some tables in the database which I would like to create as TYPE=HEAP in MySQL. Because I have read the MySQL manual (applause here, please!) I know that auto_increment cannot be used there. This hurts me a lot, and given that MySQL doesn't support sequences, it nearly prohibits the usage of heap tables in my application. However, I am still not giving up, so here's the question: how difficult would it be to get rid of that restriction for auto_increment in heap tables? The ideal answer I am hoping for is 'yeah, that's easy - wait for 3.23.42' or 'try this patch and let us know if it works for you'. Thanks in advance for any response. Leos Bitto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 problem
Hi, You are trying to use nested select for that update wich MySQL do not support insted use : update table set field = value from table inner join table where bla = bla Sincerely, Yosi Oren VP,RD manager Tel : +972 4 908 2180 ext 217 Fax : +972 4 908 2181 Mobile : +972 54 533190 E-mail: [EMAIL PROTECTED] Web : www.spiralsolutions.com -Original Message- From: Mariusz Muszalski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 12:44 PM To: [EMAIL PROTECTED] Subject: INSERT problem Look at this MS SQL: Declare @BF char(10) Declare @BL char(10) SET ROWCOUNT 1 Select @BF=Date From Results Where GameID=1 Order by Date ASC Select @BL=Date From Results Where GameID=1 Order by Date DESC Select @BF As BF, @BL As BL -- Now wonna to implement above to mySQL: I used temprary table (is there any other way?) CREATE TEMPORARY TABLE tmp(BF char(10) not null, BL char(10) not null); INSERT INTO tmp (BF) SELECT Date From Results Where GameID=1 Order by Date ASC LIMIT 1; INSERT INTO tmp (BL) SELECT Date From Results Where GameID=1 Order by Date DESC LIMIT 1; SELECT * from tmp; DROP TABLE tmp; -- problem is INSERT INTO creates a new record every time...I tried to use UPDATE in instead the second INSERT: UPDATE tmp SET BL = (SELECT Date From Results Where GameID=1 Order by Date DESC LIMIT 1); But there is error in the syntax Questions: is there only TEMPORARY TABLE way for make it? What is wrong with this UPDATE? Cheers, Mariusz Muszalski - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Info about Table and Indizes
Hi List! I got some questions about tables: - How do I get the creation date of a certain table? - Is there a SQL-statemanet to delete tables that have a certain age? - If I delete a table do all the indizes created on that table get dropped automatically? Thanks in advance for your answers, Benjamin Boksa -- Benjamin Boksa [EMAIL PROTECTED] side by site GmbH Co. KG Druckgestaltung Webdesign Barbarastr. 3-9 (Block 6) D-50735 Koeln Telefon: +49 221 2790964 Telefax: +49 221 2790965 http://www.sidebysite.de/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: deleing exactly the same rows from a table?
Hi, I am curious if there is a way to delete exactly the same rows from a table with one query? Or must I do select and delete one query at a time? I accidentally parse an html file twice, and I want to keep the rows that are distinct. Thanks for your help, -Jon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
adding types
Hi, How can I add a new type to MySQL ? Thanks. --- Sylvain BARTHELEMY http://www.tac-financial.com | http://barth.netliberte.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problems with MYSQL-D-MAx for win 98 DROP TABLE
Luciano Pulvirenti writes: If you create a Berkeley-DB table (es. CREATE TABLE TEST TYPE BDB) is not possible delete it after. The command DELETE TABLE TEST responds Table unknown. Thank You Luciano Your CREATE statement is a bit dubious, so check that there is such a table at all. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SAK kills daemons. It shouldn't.
Hello mysql mailing list readers, Secure Attention Key is supposed to kill all processes on current console. Usually init respawns new getty. This way I can be sure that login prompt I see is not mimicked by password collecting program. I like this idea a lot. I noticed that when I press Secure Attention Key on virtual console #1 on my Linux box, some daemons die horribly (SIGKILLed) (including mysqld) and some are unaffected. This does not happen on other consoles. I suppose dying daemons did not detach fully from controlling tty. And since they were launched from virtual console 1 upon system startup, SAK killed them. My mysqld is started by this command: su mysql -c /usr/sbin/mysqld --socket=/tmp/mysql.sock --skip-networking 21 | logger Daemons dying upon SAK: syslogd mysqld top* logger* Daemons surviving SAK: klogd gpm dhcpcd * these are not daemons, but I intend them to run continuously. logger directs mysqld output to syslog, and I keep top on console #10: su user0 -c top s /dev/tty10 /dev/tty10 Does anybody knows a way to write a helper script to detach misbehaving daemons from tty on startup? -- Best regards, VDA mailto:[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
SAK kills daemons. It shouldn't. #2
Hello mysql mailing list readers, Daemons surviving SAK: klogd gpm dhcpcd inetd: Me too! And I don't let you SIGKILL my children! automount: I'm at least as tough as inetd!! Also I see '?' in TTY column in 'ps -AH e' output for all these daemons (both dying and surviving), so ps does not provide any hint... -- Best regards, VDAmailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL bug with if and datetime fields
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MYSQL bug with if and datetime fields Description: In queries where datetime field is in "WHERE" condition, the same field in "IF" statement causes incorrect query result. How-To-Repeat: #--- - mysql select * from test ; +--+-+ | id | dt | +--+-+ |1 | 2001-08-14 00:00:00 | |2 | 2001-08-15 00:00:00 | |3 | 2001-08-16 00:00:00 | +--+-+ 3 rows in set (0.00 sec) mysql select * from test where dt='2001-08-14 00:00:00' and dt = if(id=1,'2001-08-14 00:00:00','1999-08-15'); Empty set (0.95 sec) mysql select * from test where dt='2001-08-14' and dt = if(id=1,'2001-08-14 00:00:00','1999-08-15'); Empty set (0.01 sec) #--- Fix: #--- mysql select * from test where dt like '2001-08-14 00:00:00' and dt = if(id=1,'2001-08-14 00:00:00','1999-08-15'); +--+-+ | id | dt | +--+-+ |1 | 2001-08-14 00:00:00 | +--+-+ 1 row in set (0.76 sec) #--- - Submitter-Id: submitter ID Originator:Arturs Aboltins Organization: (Private) MySQL support: [none] Synopsis: Buf with DATETIME fields and IF. Severity: [ serious ] Priority: [ medium ] Category: mysql Class: [ sw-bug ] Release: mysql-3.23.36 (Binary distribution from RedHat 7.1) Environment: i686, Linux, System: Linux aaboltin.telekom.lv 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 bug with if and datetime fields
Arturs Aboltins writes: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MYSQL bug with if and datetime fields Description: In queries where datetime field is in WHERE condition, the same field in IF statement causes incorrect query result. How-To-Repeat: #--- - mysql select * from test ; +--+-+ | id | dt | +--+-+ |1 | 2001-08-14 00:00:00 | |2 | 2001-08-15 00:00:00 | |3 | 2001-08-16 00:00:00 | +--+-+ 3 rows in set (0.00 sec) mysql select * from test where dt='2001-08-14 00:00:00' and dt = if(id=1,'2001-08-14 00:00:00','1999-08-15'); Empty set (0.95 sec) Please try the above with 3.23.41. I think that it was fixed meanwhile. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Incorrect index selection when potential index is compound
Hi! Eric == Eric DeCosta [EMAIL PROTECTED] writes: Description: Eric Index analysis and optimization is choosing wrong index when a Eric table involved in a JOIN is compound. MySQL should still be using Eric the first part of the GECK_STATE PRIMARY key (geck_id) since it is the column being Eric used to JOIN on the GECK table. How-To-Repeat: Eric You should already have edecosta.mathworks.com.gz on your ftp site. If not, contact me Eric and I will up-load again. cut Exactly what commands did you do between the two EXPLAIN ? It looks like your did more than just modify GEEK_STATE, as the number of rows from COMPONENT also changes between the queries: EXPLAIN1 Eric | COMPONENT | ref| PRIMARY,component | component | 32 | const |1 | where used; Using temporary; Using filesort | EXPLAIN2 Eric | COMPONENT | ref| PRIMARY,component | component| 32 | const |7 | where used; Using temporary; Using filesort | If we take a closer look at the explain results: +++-+---+-++--+-+ | table | type | possible_keys | key | key_len | ref || rows | Extra | +++-+---+-++--+-+ | COMPONENT | ref| PRIMARY,component | component | 32 | const ||1 | where used; Using temporary; Using filesort | | STATUS | ALL| PRIMARY,status | NULL |NULL | NULL || 18 | where used | | GECK_STATE | ref| PRIMARY,owner,status_id | status_id | 1 | |STATUS.status_id | 5567 | | | U1 | eq_ref | PRIMARY | PRIMARY | 2 | |GECK_STATE.owner |1 | where used | | GECK | eq_ref | PRIMARY,component_id| PRIMARY | 4 | |GECK_STATE.geck_id |1 | where used | +++-+---+-++--+-+ and: +++-+--+-++--+-+ | table | type | possible_keys | key | key_len | ref | | rows | Extra | +++-+--+-++--+-+ | COMPONENT | ref| PRIMARY,component | component| 32 | const | |7 | where used; Using temporary; Using filesort | | GECK | ref| PRIMARY,component_id| component_id | 2 | |COMPONENT.component_id | 436 | | | GECK_STATE | eq_ref | PRIMARY,owner,status_id | PRIMARY | 4 | |GECK.geck_id |1 | | | STATUS | eq_ref | PRIMARY,status | PRIMARY | 1 | |GECK_STATE.status_id |1 | where used | | U1 | eq_ref | PRIMARY | PRIMARY | 2 | |GECK_STATE.owner |1 | where used | +++-+--+-++--+-+ you can see that the tables comes in different order for the two queries. As in the first case, GECK_STATE is used before GECK, MySQL can't use the PRIMARY KEY index to find the rows in GECK_STATE. The problem here is not how the keys are used, but why the table-join optimizer produces a different order for the tables. The join optimizer tries to optimize the products of the 'rows' columns. The question is why the first query goes wrong. One reason is probably that as you had a in the first case a key on 'geck_id', required_by' , MySQL couldn't know accurately enough how many rows would be matched by only 'geck_id'. You could have supplied MySQL with this information by doing 'analyze table GEEK_STATE'. Did you try to do that ? You can also force the optimizer to use the table in a specific order, when the estimated numbers of rows are not good close enough to the truth. In this case you could say: in the FROM clause: FROM GECK STRAIGHT_JOIN GECK_STATE, USER U1, COMPONENT, STATUS which would force MySQL to put GECK before GECK_STATE in the table, which could help you to get a better responce time. To be able to know exactly where things went wrong, I would need access to all the
Re: mysqld forgets location of datadir
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Rene Churchill writes: I'm having a problem with mysql forgetting the location of it's datadir. After the server has been running for some time, it looses track and starts throwing errors when I attempt to select a database. Killing mysqld and letting safe_mysqld restart it fixes the problem for a while, but having to do it 10 times a day is a bit much. I've recompiled the server with the datadir set via ./configure instead of the command line of safe_mysqld. That seems to have reduced but not eliminated the frequency of the problem. This could also be a side effect of less traffic on the weekends. mysqld - 3.23.29 gcc - 2.95.2 OS - MaxOS 10.0, Darwin 1.3.7 Apache - 1.3.19 PHP - 4.0.x? I'm currently waiting for it to start throwing these errors again before I can do a mysqladmin variables and extended-status. These will be submitted via support.mysql.com Has anybody else seen this kind of behavior? Any suggestions on how to debug it? We have seen this problem before on BSDI. In this case the problem was that when we executed the system call 'realpath', the system sometimes changed the current directory 'under our feets. Could you try by recompiling MySQL and setting the option -DHAVE_BROKEN_REALPATH to the CFLAGS environment variable ? CFLAGS=-DHAVE_BROKEN_REALPATH ./configure 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
Performance with large numbers of connections
I am running a mysql server on a stand-alone host that is queried by a web server. I am currently seeing an average of 33 queries per second, although this is often a lot higher. The problem is, when large numbers of connections start to arrive, the machine load gets very high - but MySQL doesn't use all of the available memory. My settings are as follows: Machine: PIII-600 Memory: 512MB Disk: 30GB Kernel: 2.4.2-2 (Redhat 7.1 vanilla install) MySQL: 3.23.39-1 (RPM from mysql.com ftp server) mysql.cnf: max_connections=400 back_log=20 key_buffer=128M table_cache=256 max_allowed_packet=1M myisam_sort_buffer_size=64M thread_cache=16 The queries sent from the web server - using DBI/DBD are almost all very simple ones - usually single table, single-row selects keyed on an indexed column. Even under heavy load, the machine shows over 200MB of the 512MB memory free, yet the load figure is often up at 5 or 10. Is there anything I should be looking at changing? This is an obvious case for replication, and I'll be doing that soon anyway - I'd just like to know if I can increase performance on this machine at all. current status: +--+---+ | Aborted_clients | 1 | | Aborted_connects | 0 | | Bytes_received | 32784777 | | Bytes_sent | 245072296 | | Connections | 3893 | | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 2361 | | Created_tmp_files| 10| | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 273 | | Handler_read_first | 440 | | Handler_read_key | 7061350 | | Handler_read_next| 50967714 | | Handler_read_prev| 12778 | | Handler_read_rnd | 722971| | Handler_read_rnd_next| 455943118 | | Handler_update | 82700 | | Handler_write| 1353355 | | Key_blocks_used | 5074 | | Key_read_requests| 23130416 | | Key_reads| 5053 | | Key_write_requests | 3206 | | Key_writes | 3010 | | Max_used_connections | 27| | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 85| | Open_files | 118 | | Open_streams | 0 | | Opened_tables| 95| | Questions| 520808| | Select_full_join | 2 | | Select_full_range_join | 0 | | Select_range | 4 | | Select_range_check | 0 | | Select_scan | 133411| | Slave_running| OFF | | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 35| | Sort_merge_passes| 5 | | Sort_range | 13445 | | Sort_rows| 986289| | Sort_scan| 45793 | | Table_locks_immediate| 523411| | Table_locks_waited | 374 | | Threads_cached | 5 | | Threads_created | 28| | Threads_connected| 22| | Threads_running | 3 | | Uptime | 15452 | +--+---+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[planejamentonet] Promoções Planejamento Net
Re: MySQL daemon and inetd
I nave no problem in running mysqld. But my Linux machine have only 32 Mb of RAM. I just like to make mysqld load *on demand*. Just for reference, most modern *nix variants will handle this situation properly. If MySQL isn't doing anything, its memory space will get swapped out to disk and not swapped back in until it is needed. -- Michael T. Babcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Copy of databse on my PC....
Michael T. Babcock writes: Thank you for your technical question to the MySQL team. Unfortunately, our developers are not able to answer this type of inquiry if you have not purchased a technical support contract. I'd like to know if this is now official MySQL policy (filling the list with this letter repeatedly). If so, I'm unsubscribing ... -- Michael T. Babcock CTO, FibreSpeed Please excuse our colleague Tonu. He thaught that he was reading a support list. He has already appologized to you, and so do I ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with mysqld
Hello, I am new to mysql. I install windows version MySQL. I want to initial mysql with command mysqld, I get an error message as can't initialize innoDB as 'innodb_data_file_path' is not set. Could you please help me how to solve this problem? Thanks Henry
Re: SELECT MIN(field) takes minutes on a large table!
Hi Heitzso, Thanks for your suggestion, and in the absence of feedback from anybody else I suspect you're probably right. The system this thing is running on is a vastly outdated P150 with 128MB. I was hoping that I could do a little trick with the tables to optimize the queries a little more and get just that bit more life out of an old system, but I guess with a table this size I'm just hitting a hardware related wall and the only thing to do is fork out some cash on a new 1.2GHz system or something :( ... Unless anybody has any other ideas? Cheerio, d - Original Message - From: Heitzso [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 14, 2001 3:03 AM Subject: Re: SELECT MIN(field) takes minutes on a large table! I apologize in advance for jumping in with a hardware suggestion, but I just joined the list to sort out some similar questions. Our production sql server (Microsoft's) is sitting on a box that's now outdated w/ 2 200mhz processors and maybe .5G of RAM. A query that takes 30 seconds on that box takes 10-11 seconds on my desktop 1mhz 1G system (both Win systems). I've been arguing that hardware is cheap nowadays (just upgraded memory of my personal workstation to 1.5G for $320) and that sometimes that's the easier route. I ack that the elegant software solution is a good thing and we need to know how to optimize index/query etc. and that you cannot always throw hardware at a problem, but wanted to toss that out as a possible reasonable short term solution for Dan. BTW, mysql runs the same query on that 1G desktop in 7 seconds or 3 seconds faster than Microsoft's SQL Server. Heitzso Dan Makovec wrote: Hi folks, Wondering if anybody can help me with this one. I've got a table with 6.2 million rows in it, and MySQL seems to be straining a bit with it. It's a basic table storing stock trading prices: ++-+--+-++---+ | Field | Type| Null | Key | Default| Extra | ++-+--+-++---+ | date | date| | PRI | -00-00 | | | symbol | char(10)| | PRI || | | open | float(10,2) | | | 0.00 | | | close | float(10,2) | | | 0.00 | | | high | float(10,2) | | | 0.00 | | | low| float(10,2) | | | 0.00 | | | volume | int(11) | | | 0 | | ++-+--+-++---+ 7 rows in set (0.03 sec) Creation command: CREATE TABLE stockmarket ( date date NOT NULL default '-00-00', symbol char(10) NOT NULL default '', open float(10,2) NOT NULL default '0.00', close float(10,2) NOT NULL default '0.00', high float(10,2) NOT NULL default '0.00', low float(10,2) NOT NULL default '0.00', volume int(11) NOT NULL default '0', PRIMARY KEY (date,symbol), KEY symbol_date_index (symbol(4),date), KEY date_index (date) ) TYPE=MyISAM PACK_KEYS=1; I've put an index on date and symbol combined, and tried putting one on just date. I try to run the following query: select min(date) from stockmarket where symbol='abc' The query returns me an answer in 30 seconds. Is there a way I can optimize the table, or approach from a new query direction, to dramatically improve search times? TIA for your help. Cheerio, d. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Permissions Problems
You are connecting TO host www.4cdg.com, but the permission table entry list the hosts you connect FROM. You need to grant privileges to the user and machine you connect FROM. Butch Evans wrote: Can anyone explain why this is happening? root@www:/# mysql -u dgadmin -h www.4cdg.com -p cdgcatalog Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Here is the permissions table: mysql select host,db,user from db where db like cdgcatalog; +--++--+ | host | db | user | +--++--+ | www.4cdg.com | cdgcatalog | dgadmin | | www.4cdg.com | cdgcatalog | dgpublic | +--++--+ 2 rows in set (0.00 sec) -- Gerald L. Clark [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: Lost bin-log(s) following logrotate affecting recovery, replication
This really is not a MySQL issue, but a Red Hat issue.
Don't logrotate the MySQL bin logs.
Joel Fowler wrote:
Environment: Red Hat 7.1
mysqld 3.23.36-log
/etc/my.cnf as follows:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-bin=/bu/mysql/online-log/iServ2
log-bin-index=/bu/mysql/online-log/iServ2.index
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
/etc/logrotate.d/mysqld (as distributed) follows:
=
/var/log/mysqld.log {
missingok
create 0640 mysql mysql
prerotate
[ -e /var/lock/subsys/mysqld ] \
/bin/kill -HUP `/bin/cat /var/run/mysqld/mysqld.pid` || /bin/true
endscript
postrotate
[ -e /var/lock/subsys/mysqld ] \
/bin/kill -HUP `/bin/cat /var/run/mysqld/mysqld.pid` || /bin/true
endscript
}
Problem Synopsis:
==
1. /etc/logrotate.d/mysql executes a kill -HUP mysqld.pid during pre
and postrotate operations.
2. -HUP causes mysqld to discard all existing bin-logs (DISASTER) and
start a new one.
3. This destroys recovery strategies built on bin-logs.
It also (as far as I can tell) will cause replication to loose logs
and integrity.
Note: This is a pretty big hole !!!
To Simulate:
=
1. Configure bin-log(s)
2. List bin-log(s)
3. kill -HUP mysqld.pid
4. Bin-log(s) from 2. will have been purged and a new log started (as if
reset master was performed).
Note: For recovery and replication to work correctly existing
bin-log(s) must be left in tact.
Any help will be appreciated.
Please advise,
Joel Fowler
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[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: locking tables.
To avoid the Fatal Embrace where two users each lock a table, and then attempt to read the table the other locked, you must lock all table you intend to use for the duration of the lock. The manual clearly states that a subsequent lock or unlock command will first unlock all the tables you currently have locked. lazybrain wrote: Hello. Im wondering whats up with lock tables in mysql. i need to lock one table but also insert into another table that does not have to be locked. why does it need to lock both tables? this is pointless to me if one table does not need to be locked. Also, from the mysql documentation : If a thread obtains a WRITE lock on a table, then only the thread holding the lock can READ from or WRITE to the table. Other threads are blocked this is not true. if you have a write lock, any other connections can read from that table just not write to it. The documentation does not mention much about unlock tables either if you do unlock table beer_table does it unlock all over tables that are lock or just that one?? can someone give me some insight as to how this really works please. is there any plans to make it so you can lock one table and do whatever you want to tables that are not locked without locking them? it makes sense to me. Also in the docs its says not to use lock tables with insert delayed. but i found somewhere else on mysql.com/docs that it says you can. that is a big conflicting. thanks to anyone how sheds light on this. peace - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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: INSERT problem
MySQL does not support multi table updates yet either. Yosi Oren wrote: Hi, You are trying to use nested select for that update wich MySQL do not support insted use : update table set field = value from table inner join table where bla = bla . Sincerely, Yosi Oren VP,RD manager Tel : +972 4 908 2180 ext 217 Fax : +972 4 908 2181 Mobile : +972 54 533190 E-mail: [EMAIL PROTECTED] Web : www.spiralsolutions.com -Original Message- From: Mariusz Muszalski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 12:44 PM To: [EMAIL PROTECTED] Subject: INSERT problem Look at this MS SQL: Declare @BF char(10) Declare @BL char(10) SET ROWCOUNT 1 Select @BF=Date From Results Where GameID=1 Order by Date ASC Select @BL=Date From Results Where GameID=1 Order by Date DESC Select @BF As BF, @BL As BL -- Now wonna to implement above to mySQL: I used temprary table (is there any other way?) CREATE TEMPORARY TABLE tmp(BF char(10) not null, BL char(10) not null); INSERT INTO tmp (BF) SELECT Date From Results Where GameID=1 Order by Date ASC LIMIT 1; INSERT INTO tmp (BL) SELECT Date From Results Where GameID=1 Order by Date DESC LIMIT 1; SELECT * from tmp; DROP TABLE tmp; -- problem is INSERT INTO creates a new record every time...I tried to use UPDATE in instead the second INSERT: UPDATE tmp SET BL = (SELECT Date From Results Where GameID=1 Order by Date DESC LIMIT 1); But there is error in the syntax Questions: is there only TEMPORARY TABLE way for make it? What is wrong with this UPDATE? Cheers, Mariusz Muszalski - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- Gerald L. Clark [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
SORRY: I was wrong
Now again I want to tell sorry to everyone who was shoked by my letter which told that we do not give answers without money. The truth is that MySQL developers have about 20 different mailing lists to read in priority order. We have mailing list for people who pay for support and their mails get answered before anything else. Unfortunately we receive a lot of spam to this list plus many people just ask us for free support. This makes our work harder in many aspects. For example I receive e-mails related to some patterns directly to my cellular phone as SMS message. If signal/noise ratio is bad, I drop this list from such service to keep others running. There are also other reasons The mistake was that I forget that I am not anymore reading support list. I sent out two those our standard replies accordnig to our internal policy before I realized what I am doing. I want to apologize in public for doing such mistake. This is NOT MySQL policy and never will be. MySQL public list remains open, free and there will be developers answering part time of their workday. Please forgive me. On 14 Aug 2001 15:53:49 +0300, Sinisa Milivojevic wrote: Michael T. Babcock writes: Thank you for your technical question to the MySQL team. Unfortunately, our developers are not able to answer this type of inquiry if you have not purchased a technical support contract. I'd like to know if this is now official MySQL policy (filling the list with this letter repeatedly). If so, I'm unsubscribing ... -- Michael T. Babcock CTO, FibreSpeed Please excuse our colleague Tonu. He thaught that he was reading a support list. He has already appologized to you, and so do I ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
configure - missing termcap and curses libraries - solution
I noticed from the archives that some people had problems configuring the MySQL source. They were getting the same error message as I was getting, about termcap and curses libraries being missing, but nobody seemed to work out exactly what was wrong or what needed installing. On Linux Mandrake 8.0, I have found that installing the RPM libncurses5-devel from the distribution CD seems to do the trick. This particular problem is not caused by gcc version 2.96 after all. Hope that helps! John. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
IF clause
How to translate this to mySQL:
--
IF NOT EXISTS
(
Select Number From Results Where GameID=1
)
begin
INSERT INTO Results
(
GameID,
Date,
Number
)
VALUES
(
1,
@Date,
@Number
)
end
--
I can figure if there exist any records in results table:
Select @n:= Count(Number) From Results Where GameID=1;
But there is no way to do following:
If ( @n 0 )
{
INSERT INTO Results
(
GameID,
Date,
Number
)
VALUES
(
1,
@Date,
@Number
)
}
Cheers,
Mariusz Muszalski
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication housekeeping
I've got a fairly simple MySQL system here using replication, one master and one slave. Looking at the system the other day and the database logs are sure building up. Is there any standard way (best practice) - preferably automated - to keep these under control? If not, I've have a go at doing my own Thanks Bob Cross * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BIT data type?
I have an application that requires the storage of various flags (by
flag, I mean a variable that is either 1 or 0).
What's a good way of doing this? I've thought about two ways:
Method 1: Make a TINYINT column for each flag
I can use TINYINT NOT NULL datatype for storing each flag. The
disadvantage is that I use 8 bits when 1 bit would have sufficed.
Method 2: Make a single SET column for all the flags
I can use a SET for storing all the flags. But the disadvantage is that
the programming syntax gets a bit more complicated. e.g. instead of being
able to do:
SELECT * FROM fanfics WHERE unfinished = 0
I would have to do:
SELECT * FROM fanfics WHERE FIND_IN_SET('unfinished', flags) = 0
Does anyone have other suggestions?
Another concern that I have is the time required to add a new flag. If I
have a large table, adding a new column to the table can be quite time
consuming. (I'm guessing if I use the SET method, adding a new flag would
be instantaneous unless the number of flags was divisible by 8, requiring
the SET to expand by one byte.)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
compile problem
Hello mysql,
I'm trying to install mysql from source in a redhat 7.1 machine but
got the following errors(under section 'compile status'). I tried the
same in my redhat 7.0 without any problem. Please give me some ideas
on the following matters:
1. Should I update the gcc compiler using the update rpm from the
redhat site ?
2. If I want to use 2.95.3, which files should I have to install ?
Thanks in advance for any help/comment given.
Best Regards.
Kenneth
=== compile status ==
# ./configure --prefix=/usr/local/mysql
loading cache ./config.cache
checking host system type... i686-pc-linux-gnuoldld
checking target system type... i686-pc-linux-gnuoldld
checking build system type... i686-pc-linux-gnuoldld
checking for a BSD compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... yes
checking for working aclocal... missing
checking for working autoconf... missing
checking for working automake... missing
checking for working autoheader... missing
checking for working makeinfo... missing
checking whether to enable maintainer-specific portions of Makefiles... no
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... (cached) yes
checking for gawk... gawk
checking for gcc... no
checking for cc... no
configure: error: no acceptable cc found in $PATH
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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+mm.mysql
Hi, I'm trying to connect to a mysql database from linux using the driver mm.mysql-2.0.2-bin.jar. The connect is successfull, but when I want to retrieve some records from the database, I get the message error reading communication packets. Do someone has an idea, what it can be? Thanks and best regards, Sibel. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysqld
Henry, if you do not want to use transactional InnoDB tables, add skip-innodb to your my.cnf or my.ini file. If you want to use InnoDB tables, follow the instructions: To use InnoDB tables you must specify configuration parameters in the MySQL configuration file in the [mysqld] section of the configuration file `my.cnf'. Suppose you have a Windows NT machine with 128 MB RAM and a single 10 GB hard disk. Below is an example of possible configuration parameters in `my.cnf' or 'my.ini' for InnoDB: [mysqld] # You can write your other MySQL server options here # ... # innodb_data_home_dir = c:\ibdata innodb_data_file_path = ibdata1:2000M;ibdata2:2000M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Note that data files must always be 4G, and 2G on some file systems! InnoDB does not create directories: you have to create them yourself. Regards, Heikki http://www.innodb.com Copied message: . Hello, I am new to mysql. I install windows version MySQL. I want to initial = mysql with command mysqld, I get an error message as can't initialize = innoDB as 'innodb_data_file_path' is not set. Could you please help me = how to solve this problem? Thanks Henry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 causing severe load problems on Dual-Athlon server?
Update -- The problem I described happened again, and this time I was able to get the mysqladmin processlist done. Here are the results from that. Can you help me find my problem based on this information? Thank you!! Here is the top header: 11:09am up 4 days, 20:15, 1 user, load average: 101.55, 49.58, 20.18 [root@dagger /root]# mysqladmin processlist -p Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' [root@dagger /root]# mysqladmin processlist -p Enter password: ++---+---+---+-+--++ --+ | Id | User | Host | db| Command | Time | State | Inf o | ++---+---+---+-+--++ --+ | 649586 | amdmb | localhost | forum | Quit| 48 || | | 649594 | amdmb | localhost | dotbanner | Query | 4| Locked | upd ate advertisers set Shown=6613775 where UserName=TCComputers | | 649597 | amdmb | localhost | forum | Query | 36 | cleaning up| SEL ECT * FROM thread WHERE forumid 15 ORDER BY lastpost DESC LIMIT 10 | | 649598 | amdmb | localhost | dotbanner | Query | 8| Locked | sel ect * from advertisers where UserName=Iwill | | 649601 | amdmb | localhost | forum | Sleep | 36 || | | 649609 | amdmb | localhost | Amdmb | Init DB | 1| cleaning up| | | 649614 | amdmb | localhost | forum | Query | 0| Opening tables | SEL ECT forumid,canview,canpostnew FROM forumpermission WHERE usergroupid='1' | | 649629 | amdmb | localhost | forum | Query | 4|| | | 649630 | amdmb | localhost | dotbanner | Query | 4| Locked | sel ect * from advertisers where UserName=DualAthloncom | | 649642 | amdmb | localhost | forum | Query | 36 | cleaning up| UPD ATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='53042' | | 649644 | amdmb | localhost | forum | Query | 68 | cleaning up| SEL ECT COUNT(*) AS threads FROM thread WHERE thread.forumid='19' AND thread.visible =1 AND lastpost | | 649649 | amdmb | localhost | dotbanner | Query | 80 | cleaning up| upd ate advertisers set Shown=6613772 where UserName=TCComputers | | 649658 | amdmb | localhost | dotbanner | Query | 8| Locked | upd ate advertisers set Shown=6613774 where UserName=TCComputers | | 649663 | amdmb | localhost | forum | Query | 36 | cleaning up| UPD ATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='51192' | | 649664 | amdmb | localhost | dotbanner | Quit| 72 || | | 649666 | amdmb | localhost | forum | Query | 67 || | | 649667 | amdmb | localhost | forum | Query | 68 || | | 649673 | amdmb | localhost | dotbanner | Query | 0| Locked | sel ect * from advertisers where UserName=DualAthloncom | | 649678 | amdmb | localhost | Amdmb | Quit| 53 | cleaning up| | | 649685 | amdmb | localhost | forum | Quit| 28 || | | 649690 | amdmb | localhost | dotbanner | Query | 8| Locked | sel ect UserName, Weight from advertisers where (Display_Zone like %left_125_125% OR Display_Zone = | | 649694 | amdmb | localhost | dotbanner | Query | 45 | cleaning up| sel ect UserName, Weight from advertisers where (Display_Zone like %VantecHome% OR Display_Zone = | | 649695 | amdmb | localhost | forum | Quit| 4|| | | 649706 | amdmb | localhost | dotbanner | Query | 4| Locked | sel ect UserName, Weight from advertisers where (Display_Zone like %VantecHome% OR Display_Zone = | | 649709 | amdmb | localhost | forum | Query | 0| Opening tables | SEL ECT * FROM usergroup WHERE usergroupid=1 | | 649711 | amdmb | localhost | dotbanner | Query | 0| Locked | sel ect * from advertisers where UserName=TCComputers | | 649712 | amdmb | localhost | forum | Quit| 28 || | | 649713 | amdmb | localhost | dotbanner | Query | 55 | cleaning up| sel ect * from advertisers where UserName=Iwill | | 649715 | amdmb | localhost | dotbanner | Query | 3| cleaning up| sel ect UserName, Weight from
Best Practice for mysqlhotcopy?
I have a user on my system with a normal shell account, and a normal MySQL account that owns a database. How can this unpriviledged user back up his database using mysqlhotcopy? I've run into two problems: 1. He has to login as the MySQL root user in order to be able to execute FLUSH TABLES. 2. The MySQL data files for that database are not readable by him. I've tried to chgrp those files to his group and chmod g+r them, which allows him to read those files. But, they spontaneously revert back to the mysql group for some reason! (Why?) And new tables created in his database have the group of mysql. Can I get around the problems from #1 and #2 somehow? I realize that I could just use mysqldump to back up the tables, but this takes a lot longer since my database has over 70 MB of data in it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
WinMySQLAdmin 1.0
Having trouble with e-mail servers this morning and not sure if my subscription request made it. If this has been reported already or is the incorrect mailing list for this issue, please excuse and point me in the right direction. Had a internet connection failure last night and due to what appears like it could be a bug in YATS32, it set the clock on my server ahead by about 3500 seconds every hour, putting my real time clock into na-na land. The server thought it was Aug 17th. This server also happens to run the mySQL server. I corrected the internet connection problem and rebooted the machine. It got hold of the time host and everything is back to normal except that now I have dozens and dozens of system message windows from WinMySQLAdmin 1.0 saying: '4294683874' in not a valid integer value. Where the number is a constantly decreasing value. A new message is created every server query interval time, which by default is ten seconds. It seems that WinMySQL Admin doesn't like calculating server up time backwards and it never corrects itself. Needless to say this results in a lot of system message dialog boxes marching across the screen if one doesn't sit there and dismiss them as they pop up! :\ I set the server query interval to 5000 seconds and I'm hoping that it will correct itself when Friday rolls around. If anyone knows any magic registry manipulation I could safely do to correct this before Friday, I'd appreciate any pointers to FAQ entries or whatever. Thanks in advance, Dan Haynes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 causing severe load problems on Dual-Athlon server?
- Original Message - From: Ryan Shrout [EMAIL PROTECTED] To: Tonu Samuel [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, August 14, 2001 5:21 PM Subject: Re: Mysql causing severe load problems on Dual-Athlon server? Update -- The problem I described happened again, and this time I was able to get the mysqladmin processlist done. Here are the results from that. Can you help me find my problem based on this information? Thank you!! Here is the top header: 11:09am up 4 days, 20:15, 1 user, load average: 101.55, 49.58, 20.18 [root@dagger /root]# mysqladmin processlist -p Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' [root@dagger /root]# mysqladmin processlist -p Enter password: ++---+---+---+-+--++ -- -- --+ | Id | User | Host | db| Command | Time | State | Inf o | ++---+---+---+-+--++ -- -- --+ | 649586 | amdmb | localhost | forum | Quit| 48 | | | | 649594 | amdmb | localhost | dotbanner | Query | 4| Locked | upd ate advertisers set Shown=6613775 where UserName=TCComputers | | 649597 | amdmb | localhost | forum | Query | 36 | cleaning up | SEL ECT * FROM thread WHERE forumid 15 ORDER BY lastpost DESC LIMIT 10 | | 649598 | amdmb | localhost | dotbanner | Query | 8| Locked | sel ect * from advertisers where UserName=Iwill | | 649601 | amdmb | localhost | forum | Sleep | 36 | | | | 649609 | amdmb | localhost | Amdmb | Init DB | 1| cleaning up | | | 649614 | amdmb | localhost | forum | Query | 0| Opening tables | SEL ECT forumid,canview,canpostnew FROM forumpermission WHERE usergroupid='1' | | 649629 | amdmb | localhost | forum | Query | 4| | | | 649630 | amdmb | localhost | dotbanner | Query | 4| Locked | sel ect * from advertisers where UserName=DualAthloncom | | 649642 | amdmb | localhost | forum | Query | 36 | cleaning up | UPD ATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='53042' | | 649644 | amdmb | localhost | forum | Query | 68 | cleaning up | SEL ECT COUNT(*) AS threads FROM thread WHERE thread.forumid='19' AND thread.visible =1 AND lastpost | | 649649 | amdmb | localhost | dotbanner | Query | 80 | cleaning up | upd ate advertisers set Shown=6613772 where UserName=TCComputers | | 649658 | amdmb | localhost | dotbanner | Query | 8| Locked | upd ate advertisers set Shown=6613774 where UserName=TCComputers | | 649663 | amdmb | localhost | forum | Query | 36 | cleaning up | UPD ATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='51192' | | 649664 | amdmb | localhost | dotbanner | Quit| 72 | | | | 649666 | amdmb | localhost | forum | Query | 67 | | | | 649667 | amdmb | localhost | forum | Query | 68 | | | | 649673 | amdmb | localhost | dotbanner | Query | 0| Locked | sel ect * from advertisers where UserName=DualAthloncom | | 649678 | amdmb | localhost | Amdmb | Quit| 53 | cleaning up | | | 649685 | amdmb | localhost | forum | Quit| 28 | | | | 649690 | amdmb | localhost | dotbanner | Query | 8| Locked | sel ect UserName, Weight from advertisers where (Display_Zone like %left_125_125% OR Display_Zone = | | 649694 | amdmb | localhost | dotbanner | Query | 45 | cleaning up | sel ect UserName, Weight from advertisers where (Display_Zone like %VantecHome% OR Display_Zone = | | 649695 | amdmb | localhost | forum | Quit| 4| | | | 649706 | amdmb | localhost | dotbanner | Query | 4| Locked | sel ect UserName, Weight from advertisers where (Display_Zone like %VantecHome% OR Display_Zone = | | 649709 | amdmb | localhost | forum | Query | 0| Opening tables | SEL ECT * FROM usergroup WHERE usergroupid=1 | | 649711 | amdmb | localhost | dotbanner | Query | 0| Locked | sel ect * from advertisers where UserName=TCComputers | | 649712 | amdmb | localhost | forum | Quit| 28 | | | | 649713 | amdmb | localhost | dotbanner | Query | 55 | cleaning up | sel ect * from advertisers where UserName=Iwill
Re: Mysql causing severe load problems on Dual-Athlon server?
This is happening to me also! I have a Dual P-III, 550, 896MB RAM. Suddenly mysql says it has insert max_connections here connections busy most of them LOCKED, and then suddenly they start working on all of them at the same time. This creates a load average similar to max_connections. Is this a problem related to Linux, or is it a MySQL feature ? //Johan - Original Message - From: Johan Wahlström [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 14, 2001 5:48 PM Subject: Re: Mysql causing severe load problems on Dual-Athlon server? - Original Message - From: Ryan Shrout [EMAIL PROTECTED] To: Tonu Samuel [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, August 14, 2001 5:21 PM Subject: Re: Mysql causing severe load problems on Dual-Athlon server? Update -- The problem I described happened again, and this time I was able to get the mysqladmin processlist done. Here are the results from that. Can you help me find my problem based on this information? Thank you!! Here is the top header: 11:09am up 4 days, 20:15, 1 user, load average: 101.55, 49.58, 20.18 [root@dagger /root]# mysqladmin processlist -p Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' [root@dagger /root]# mysqladmin processlist -p Enter password: ++---+---+---+-+--++ -- -- --+ | Id | User | Host | db| Command | Time | State | Inf o | ++---+---+---+-+--++ -- -- --+ | 649586 | amdmb | localhost | forum | Quit| 48 | | | | 649594 | amdmb | localhost | dotbanner | Query | 4| Locked | upd ate advertisers set Shown=6613775 where UserName=TCComputers | | 649597 | amdmb | localhost | forum | Query | 36 | cleaning up | SEL ECT * FROM thread WHERE forumid 15 ORDER BY lastpost DESC LIMIT 10 | | 649598 | amdmb | localhost | dotbanner | Query | 8| Locked | sel ect * from advertisers where UserName=Iwill | | 649601 | amdmb | localhost | forum | Sleep | 36 | | | | 649609 | amdmb | localhost | Amdmb | Init DB | 1| cleaning up | | | 649614 | amdmb | localhost | forum | Query | 0| Opening tables | SEL ECT forumid,canview,canpostnew FROM forumpermission WHERE usergroupid='1' | | 649629 | amdmb | localhost | forum | Query | 4| | | | 649630 | amdmb | localhost | dotbanner | Query | 4| Locked | sel ect * from advertisers where UserName=DualAthloncom | | 649642 | amdmb | localhost | forum | Query | 36 | cleaning up | OR Display_Zone = | | 649694 | amdmb | localhost | dotbanner | Query | 45 | cleaning up | sel ect UserName, Weight from advertisers where (Display_Zone like %VantecHome% OR Display_Zone = | | 649695 | amdmb | localhost | forum | Quit| 4| | set-variable = table_cache=128 set-variable = record_buffer=2M set-variable = net_buffer=2M [myisamchk] set-variable = key_buffer_size=32M set-variable = sort_buffer_size=128M tmpdir=/mnt/mysql/tmp [tonu@x153 tonu]$ I am sure that this is not your problem currently but this is neccessary anyway. To solve your problem, please run mysqladmin processlist while this bad things is going on and post output of it here together with table structures which you can get with mysqldump --no-data dbname And one thing what I suggest to try - get really latest linux-ac kernel. There is a some possibility that you problem is solved in 2.4.7-pre8 or latest. There were some important bugs related to IO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 causing severe load problems on Dual-Athlon server?
This just happened a second time today... that is the most frequent yet. Please, you have got to help me on this! Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Message - From: Ryan Shrout [EMAIL PROTECTED] To: Tonu Samuel [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, August 14, 2001 11:21 AM Subject: Re: Mysql causing severe load problems on Dual-Athlon server? Update -- The problem I described happened again, and this time I was able to get the mysqladmin processlist done. Here are the results from that. Can you help me find my problem based on this information? Thank you!! Here is the top header: 11:09am up 4 days, 20:15, 1 user, load average: 101.55, 49.58, 20.18 [root@dagger /root]# mysqladmin processlist -p Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' [root@dagger /root]# mysqladmin processlist -p Enter password: ++---+---+---+-+--++ -- -- --+ | Id | User | Host | db| Command | Time | State | Inf o | ++---+---+---+-+--++ -- -- --+ | 649586 | amdmb | localhost | forum | Quit| 48 | | | | 649594 | amdmb | localhost | dotbanner | Query | 4| Locked | upd ate advertisers set Shown=6613775 where UserName=TCComputers | | 649597 | amdmb | localhost | forum | Query | 36 | cleaning up | SEL ECT * FROM thread WHERE forumid 15 ORDER BY lastpost DESC LIMIT 10 | | 649598 | amdmb | localhost | dotbanner | Query | 8| Locked | sel ect * from advertisers where UserName=Iwill | | 649601 | amdmb | localhost | forum | Sleep | 36 | | | | 649609 | amdmb | localhost | Amdmb | Init DB | 1| cleaning up | | | 649614 | amdmb | localhost | forum | Query | 0| Opening tables | SEL ECT forumid,canview,canpostnew FROM forumpermission WHERE usergroupid='1' | | 649629 | amdmb | localhost | forum | Query | 4| | | | 649630 | amdmb | localhost | dotbanner | Query | 4| Locked | sel ect * from advertisers where UserName=DualAthloncom | | 649642 | amdmb | localhost | forum | Query | 36 | cleaning up | UPD ATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='53042' | | 649644 | amdmb | localhost | forum | Query | 68 | cleaning up | SEL ECT COUNT(*) AS threads FROM thread WHERE thread.forumid='19' AND thread.visible =1 AND lastpost | | 649649 | amdmb | localhost | dotbanner | Query | 80 | cleaning up | upd ate advertisers set Shown=6613772 where UserName=TCComputers | | 649658 | amdmb | localhost | dotbanner | Query | 8| Locked | upd ate advertisers set Shown=6613774 where UserName=TCComputers | | 649663 | amdmb | localhost | forum | Query | 36 | cleaning up | UPD ATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='51192' | | 649664 | amdmb | localhost | dotbanner | Quit| 72 | | | | 649666 | amdmb | localhost | forum | Query | 67 | | | | 649667 | amdmb | localhost | forum | Query | 68 | | | | 649673 | amdmb | localhost | dotbanner | Query | 0| Locked | sel ect * from advertisers where UserName=DualAthloncom | | 649678 | amdmb | localhost | Amdmb | Quit| 53 | cleaning up | | | 649685 | amdmb | localhost | forum | Quit| 28 | | | | 649690 | amdmb | localhost | dotbanner | Query | 8| Locked | sel ect UserName, Weight from advertisers where (Display_Zone like %left_125_125% OR Display_Zone = | | 649694 | amdmb | localhost | dotbanner | Query | 45 | cleaning up | sel ect UserName, Weight from advertisers where (Display_Zone like %VantecHome% OR Display_Zone = | | 649695 | amdmb | localhost | forum | Quit| 4| | | | 649706 | amdmb | localhost | dotbanner | Query | 4| Locked | sel ect UserName, Weight from advertisers where (Display_Zone like %VantecHome% OR Display_Zone = | | 649709 | amdmb | localhost | forum | Query | 0| Opening tables | SEL ECT * FROM usergroup WHERE usergroupid=1 | | 649711 | amdmb | localhost | dotbanner | Query | 0| Locked | sel ect * from advertisers where UserName=TCComputers | | 649712 | amdmb | localhost |
mysql 3.23.41 errors during compile
Anybody seen this before: gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/export/home6/temp/mysql-3.23.41/include -DHAVE_RWLOCK_T -o mysqlbinlog mysqlbinlog.o mini_client.o net_serv.o mini_client_errors.o violite.o password.o ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0xc): undefined reference to `__cxa_pure_virtual' mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x1c): undefined reference to `__cxa_pure_virtual' collect2: ld returned 1 exit status make[3]: *** [mysqlbinlog] Error 1 make[3]: Leaving directory `/export/home6/temp/mysql-3.23.41/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/export/home6/temp/mysql-3.23.41/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/export/home6/temp/mysql-3.23.41' make: *** [all-recursive-am] Error 2 my config: ./configure --enable-static --enable-assembler --disable-shared --with-libwrap --without-debug --with-mysqld-ldflags=-all-static-lgcc --without-docs --without-bench --with-charset=latin1 --with-berkeley-db --with-innodb --with-mysqld-user=mysql C flags: CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.0/specs Configured with: ../configure --disable-nls --disable-libgcj --enable-languages=c++,f77,objc Thread model: posix gcc version 3.0 OS: Solaris 8 Could use some help getting this to compile, -Thanks Mark
Re: MYSQL bug with if and datetime fields
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Arturs Aboltins writes: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MYSQL bug with if and datetime fields Description: In queries where datetime field is in WHERE condition, the same field in IF statement causes incorrect query result. How-To-Repeat: mysql select * from test ; +--+-+ | id | dt | +--+-+ |1 | 2001-08-14 00:00:00 | |2 | 2001-08-15 00:00:00 | |3 | 2001-08-16 00:00:00 | +--+-+ 3 rows in set (0.00 sec) mysql select * from test where dt='2001-08-14 00:00:00' and dt = if(id=1,'2001-08-14 00:00:00','1999-08-15'); Empty set (0.95 sec) Sinisa Please try the above with 3.23.41. I think that it was fixed Sinisa meanwhile. cut The reason the above is failing is that the WHERE is optimized to: t1.dt = 2001081400 and 2001081400 = if((t1.id = 1),'2001-08-14 00:00:00','1999-08-15') Because 'if' returns a string in this case, the later query doesn't match :( I will try to disable this with optimization for datetime in the future. In the mean time, you can fid this by either doing: select * from test where dt=2001081400 and dt=if(id=1,2001081400,1999081500); or: select * from test where dt='2001-08-14 00:00:00' and concat(dt) = if(id=1,'2001-08-14 00:00:00','1999-08-15'); The extra concat() will disable this optimization. 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
SELECT .. OR from multiple tables
I've got two tables, Current and Temporary, Current has a row with login='keric', Temporary doesn't. The following query: mysql select * from Current, Temporary where Current.login='username' or Temporary.login='username' - \g Empty set (0.01 sec) obviously doesn't work. I want to know if that row exists in either table in one SQL call. Maybe it's just me today.. Anyone? -- Eric Anderson Online Net-Entertainment, Inc CyberIron Bodybuilding ICQ 3849549 http://www.on-e.comhttp://www.cyberiron.com [EMAIL PROTECTED]San Diego, CA[EMAIL PROTECTED] ..and then my doctor said my nose wouldn't bleed so much if I just kept my finger outta there! -- Ralph Wiggum You've got the brain and talent to do anything you want, and when you do, I'll be right there to borrow money from you! -- Bart Simpson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Float Issue
Hi,
There seems to be a round-off problem with FLOAT.
Here's a scenario to replicate it...
--
$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1149 to server version: 3.23.41
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql CREATE TABLE crap (blah float(10,2) DEFAULT '0.00' NOT NULL, blah2
double(10,2));
Query OK, 0 rows affected (0.00 sec)
mysql insert into crap VALUES ('211710.10','211710.10');
Query OK, 1 row affected (0.00 sec)
mysql select * from crap;
+---+---+
| blah | blah2 |
+---+---+
| 211710.09 | 211710.10 |
+---+---+
1 row in set (0.00 sec)
mysql /q
--
Everything works with DOUBLE fine as you can see.
Just thought i'd bring it to someone's attention. FLOAT seems to work with
smaller numbers but when the values start getting big, this sort of thing
starts happening.
Thanks
Dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 blew it big time... locked myself out of mysql
I used mysqladmin to create a database and set the grant properties to root@localhost with the password, but now am unable to use mysql at all. How can I rectify this problem? When I try to access mysql I get 'Access denied for user root@localhost'. I have tried, from the command line, with -uroot -ppassword and get the same results. Please help ASAP. I have always been able to connect as root with just 'mysql' at the prompt. -- Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712-1138 There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corp., 1977 (-- Then why do I have nine? Somebody help me!) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 causing severe load problems on Dual-Athlon server?
Sorry, but this system has quad 15K RPM SCSI hard drives running RAID 0+1. I don't think hdparm applies to that. Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Message - From: Werner Stuerenburg [EMAIL PROTECTED] To: Ryan Shrout [EMAIL PROTECTED] Sent: Tuesday, August 14, 2001 1:13 PM Subject: Re: Mysql causing severe load problems on Dual-Athlon server? Ryan Shrout schrieb am Dienstag, 14. August 2001, 18:45:00: This just happened a second time today... that is the most frequent yet. Please, you have got to help me on this! I had similar problems, which are gone now. I was helped with http://linux.oreillynet.com/pub/a/linux/2000/06/29/hdparm.html -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SELECT .. OR from multiple tables
How about a UNION query...? -Original Message- From: Eric Anderson [mailto:[EMAIL PROTECTED]] Sent: Tue, 14 August 2001 18:56 To: [EMAIL PROTECTED] Subject: SELECT .. OR from multiple tables I've got two tables, Current and Temporary, Current has a row with login='keric', Temporary doesn't. The following query: mysql select * from Current, Temporary where Current.login='username' or Temporary.login='username' - \g Empty set (0.01 sec) obviously doesn't work. I want to know if that row exists in either table in one SQL call. Maybe it's just me today.. Anyone? -- Eric Anderson Online Net-Entertainment, Inc CyberIron Bodybuilding ICQ 3849549 http://www.on-e.comhttp://www.cyberiron.com [EMAIL PROTECTED]San Diego, CA[EMAIL PROTECTED] ..and then my doctor said my nose wouldn't bleed so much if I just kept my finger outta there! -- Ralph Wiggum You've got the brain and talent to do anything you want, and when you do, I'll be right there to borrow money from you! -- Bart Simpson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 causing severe load problems on Dual-Athlon server?
Actually, I ran this test: [root@dagger /root]# hdparm -Tt /dev/sda /dev/sda: Timing buffer-cache reads: 128 MB in 0.93 seconds =137.63 MB/sec Timing buffered disk reads: 64 MB in 13.92 seconds = 4.60 MB/sec And that does seem pretty bad, doesn't it? Is there optimization for SDA like there is HDA? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Message - From: Werner Stuerenburg [EMAIL PROTECTED] To: Ryan Shrout [EMAIL PROTECTED] Sent: Tuesday, August 14, 2001 1:13 PM Subject: Re: Mysql causing severe load problems on Dual-Athlon server? Ryan Shrout schrieb am Dienstag, 14. August 2001, 18:45:00: This just happened a second time today... that is the most frequent yet. Please, you have got to help me on this! I had similar problems, which are gone now. I was helped with http://linux.oreillynet.com/pub/a/linux/2000/06/29/hdparm.html -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SELECT .. OR from multiple tables
Your query will work in every case, EXCEPT when either Current or Temporary has 0 rows, because then there's nothing to join. I'm not sure if doing a join is a clean way of doing this though. If you know that Current will never be empty (but temporary might be), then this query would work: SELECT * FROM current LEFT JOIN temporary ON 1=1 WHERE current.login = 'keric' OR temporary.login = 'keric' That won't work if Current is empty. There's got to be a better way of doing this though... anyone else want to take a crack at this problem? On Tue, 14 Aug 2001, Eric Anderson wrote: I've got two tables, Current and Temporary, Current has a row with login='keric', Temporary doesn't. The following query: mysql select * from Current, Temporary where Current.login='username' or Temporary.login='username' - \g Empty set (0.01 sec) obviously doesn't work. I want to know if that row exists in either table in one SQL call. Maybe it's just me today.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Float Issue
Dave Jolly wrote:
Hi,
There seems to be a round-off problem with FLOAT.
Here's a scenario to replicate it...
--
$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1149 to server version: 3.23.41
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql CREATE TABLE crap (blah float(10,2) DEFAULT '0.00' NOT NULL, blah2
double(10,2));
Query OK, 0 rows affected (0.00 sec)
mysql insert into crap VALUES ('211710.10','211710.10');
Query OK, 1 row affected (0.00 sec)
mysql select * from crap;
+---+---+
| blah | blah2 |
+---+---+
| 211710.09 | 211710.10 |
+---+---+
1 row in set (0.00 sec)
mysql /q
--
Everything works with DOUBLE fine as you can see.
Just thought i'd bring it to someone's attention. FLOAT seems to work with
smaller numbers but when the values start getting big, this sort of thing
starts happening.
Thanks
Dave
Hi,
What you see is just normal.
FLOAT are internally stored as 32 bits floating point values.
They are by nature limited to 6 or 7 significant digits.
DOUBLE are 64 bits and have around 16 significant digits.
If even 16 digits is not enough, you should look at DECIMAL type.
Regards
--
Joseph Bueno
NetClub/Trader.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SELECT .. OR from multiple tables
Your query will work in every case, EXCEPT when either Current or Temporary has 0 rows, because then there's nothing to join. I'm not sure if doing a join is a clean way of doing this though. If you know that Current will never be empty (but temporary might be), then this query would work: SELECT * FROM current LEFT JOIN temporary ON 1=1 WHERE current.login = 'keric' OR temporary.login = 'keric' That won't work if Current is empty. There's got to be a better way of doing this though... anyone else want to take a crack at this problem? Sorry, the most likely scenario is that neither table has the value, but either Current or Temporary could have it, though not both at the same time. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: I blew it big time... locked myself out of mysql
On Tue, Aug 14, 2001 at 10:14:58AM -0700, [EMAIL PROTECTED] wrote: I used mysqladmin to create a database and set the grant properties to root@localhost with the password, but now am unable to use mysql at all. How can I rectify this problem? When I try to access mysql I get 'Access denied for user root@localhost'. I have tried, from the command line, with -uroot -ppassword and get the same results. Please help ASAP. I have always been able to connect as root with just 'mysql' at the prompt. Start mysqld with the --skip-grant-tables option, as described in the manual. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.29: up 59 days, processed 524,505,815 queries (102/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.41 has invalid asm constrainst
Description: mysql 3.23.41 doesn't build properly on IA32 with assembly and innobase enabled. 3.23.40 didn't have this problem Configure statement in spec file (%configure is a standard rpm macro, specifying CFLAGS and CXXFLAGS and various prefixes) %configure --without-debug \ --without-readline \ --enable-shared \ --with-extra-charsets=complex \ --with-bench \ --localstatedir=/var/lib/mysql \ --with-unix-socket-path=/var/lib/mysql/mysql.sock \ --with-mysqld-user=mysql \ --with-extra-charsets=all \ --with-innodb \ --enable-assembler \ --with-berkeley-db --enable-large-files=yes --enable-largefile=yes \ --with-thread-safe-client results in: gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-DDBUG_OFF -O3 -DDBUG_OFF -O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS= 64 -D_LARGEFILE_SOURCE -DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c sync0sync.c: In function `sync_gnuc_intelx86_test_and_set': sync0sync.c:187: impossible register constraint in `asm' sync0sync.c:187: impossible register constraint in `asm' sync0sync.c:187: impossible register constraint in `asm' sync0sync.c: In function `sync_gnuc_intelx86_reset': sync0sync.c:202: impossible register constraint in `asm' sync0sync.c:202: impossible register constraint in `asm' sync0sync.c:202: impossible register constraint in `asm' make[4]: *** [sync0sync.o] Error 1 make[4]: Leaving directory `/tmp/32683-i386/BUILD/mysql-3.23.41/innobase/sync' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/tmp/32683-i386/BUILD/mysql-3.23.41/innobase' Submitter-Id: submitter ID Originator: Organization: Trond Eivind Glomsrød Red Hat, Inc. MySQL support: none Synopsis: assembly/innobase combo doesn't compile Severity: non-critical Priority: medium Category: mysql Class: sw-bug Environment: System: Linux halden 2.4.7-0.12.1smp #1 SMP Fri Aug 10 13:46:13 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-96) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 aug 10 15:21 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1276424 jul 26 20:01 /lib/libc-2.2.4.so -rw-r--r--1 root root 26985282 aug 10 07:10 /usr/lib/libc.a -rw-r--r--1 root root 178 aug 10 07:10 /usr/lib/libc.so lrwxrwxrwx1 root root 10 aug 7 17:04 /usr/lib/libc-client.a - c-client.a Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --with-innodb --enable-assembler --with-berkeley-db --enable-large-files=yes --enable-largefile=yes --with-thread-safe-client - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Lost bin-log(s) following logrotate affecting recovery, replication
I don't recall ever losing a log.
Are you sure logrotate isn't renaming it?
Joel Fowler wrote:
I agree that Red Hat has an issue with safe_mysqld and logrotate.
However, in my opinion MySQL has a much more serious problem.
In a logging system there shouldn't be any subtle ways to drop records
let alone entire logs.
Kill -HUP mysqld.pid is exactly that -- a very poor design leading to
a big trap - one which Red Hat just happened to fall in.
Joel Fowler
At 08:36 AM 8/14/01 -0500, Gerald Clark wrote:
This really is not a MySQL issue, but a Red Hat issue.
Don't logrotate the MySQL bin logs.
Joel Fowler wrote:
Environment: Red Hat 7.1
mysqld 3.23.36-log
/etc/my.cnf as follows:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-bin=/bu/mysql/online-log/iServ2
log-bin-index=/bu/mysql/online-log/iServ2.index
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
/etc/logrotate.d/mysqld (as distributed) follows:
=
/var/log/mysqld.log {
missingok
create 0640 mysql mysql
prerotate
[ -e /var/lock/subsys/mysqld ] \
/bin/kill -HUP `/bin/cat /var/run/mysqld/mysqld.pid` ||
/bin/true
endscript
postrotate
[ -e /var/lock/subsys/mysqld ] \
/bin/kill -HUP `/bin/cat /var/run/mysqld/mysqld.pid` ||
/bin/true
endscript
}
Problem Synopsis:
==
1. /etc/logrotate.d/mysql executes a kill -HUP mysqld.pid during
pre and postrotate operations.
2. -HUP causes mysqld to discard all existing bin-logs (DISASTER) and
start a new one.
3. This destroys recovery strategies built on bin-logs.
It also (as far as I can tell) will cause replication to loose
logs and integrity.
Note: This is a pretty big hole !!!
To Simulate:
=
1. Configure bin-log(s)
2. List bin-log(s)
3. kill -HUP mysqld.pid
4. Bin-log(s) from 2. will have been purged and a new log started (as
if reset master was performed).
Note: For recovery and replication to work correctly existing
bin-log(s) must be left in tact.
Any help will be appreciated.
Please advise,
Joel Fowler
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
--
Gerald L. Clark
[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: Local Sockets vs TCP
These scripts should not be creating their own sockets. The should be connecting to the one socket that the mysql server creates. Hans Zaunere wrote: We have had a MySQL/Apache/Perl combo running fairly smoothly. However the other day MySQL seemingly went crazy, and brought the rest of the system down; no sockets were available, even to ssh into. After a few minutes, enough sockets were available to ssh into, however MySQL seemed to far gone, and had to be restarted. I have a feeling it is due to the scripts we are running (mod_perl via apache and regular perl, via local cronjobs) and the way they are written. All the scripts connect to MySQL via local UNIX domain sockets, thus creating a /tmp/mysql.sock for each invocation. Is this the best way to do it, or should TCP/IP sockets be used, by connecting to the full hostname, versus connecting to localhost, which seems to use local sockets. I know the local sockets are generally considered faster, however I have also heard that the Linux kernel does not handle a lot of local sockets well. Would a combination of local and IP sockets be used, or strictly IP, since strictly local sockets seems to bring the system to the edge. As much information, links, comparasions, benchmarks, data on the subject would be greatly appreciated. Don't hesitate to contact me for additional questions/info. Thank you, Hans Zaunere [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 attachment.txt Content-Type: text/plain -- Gerald L. Clark [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: Local Sockets vs TCP
Ok. I didn't write these scripts, as they were in place when I arrived at this position, however from looking through them, it appears the actual connection to MySQL happens with something like: my $dbh = connect(DBI:mysql:database:localhost, user, password); The above is a perl line. So you are saying that the script should just open() /tmp/mysql.sock and read and write to it like any other file? And, if I am following, replacing the above localhost with the actual hostname of the machine would create a TCP/IP socket/connection to the server, which is the same as if I had to connect remotely? The above perl line is called from local scripts, executing from the perl interpreter via cron, and also in mod_perl scripts, running from Apache. These are essentially the same, correct? Thank you Hans Zaunere [EMAIL PROTECTED] Gerald Clark wrote: These scripts should not be creating their own sockets. The should be connecting to the one socket that the mysql server creates. Hans Zaunere wrote: We have had a MySQL/Apache/Perl combo running fairly smoothly. However the other day MySQL seemingly went crazy, and brought the rest of the system down; no sockets were available, even to ssh into. After a few minutes, enough sockets were available to ssh into, however MySQL seemed to far gone, and had to be restarted. I have a feeling it is due to the scripts we are running (mod_perl via apache and regular perl, via local cronjobs) and the way they are written. All the scripts connect to MySQL via local UNIX domain sockets, thus creating a /tmp/mysql.sock for each invocation. Is this the best way to do it, or should TCP/IP sockets be used, by connecting to the full hostname, versus connecting to localhost, which seems to use local sockets. I know the local sockets are generally considered faster, however I have also heard that the Linux kernel does not handle a lot of local sockets well. Would a combination of local and IP sockets be used, or strictly IP, since strictly local sockets seems to bring the system to the edge. As much information, links, comparasions, benchmarks, data on the subject would be greatly appreciated. Don't hesitate to contact me for additional questions/info. Thank you, Hans Zaunere [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 attachment.txt Content-Type: text/plain -- Gerald L. Clark [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
encrypt/decrypt question
Hi all, I am very new to the encrypt and decrypt data process and would like to know how do I able to encrypt a string and store to MySQL and retrieve the data and decrypt it at the later time. I understood it sorts of contradict the point of security but I just want to use it to cover the data such that the non-technical user can see the data is there but they couldn't understand them by just reading it. It may be a dump question but I would be greatly appreciated for any suggestion or help. Regards, Michael
Re: Lost bin-log(s) following logrotate affecting recovery, replication
I've also reported this problem to Red Hat' Bugzilla as I understand
they're responsible for the /etc/logrotate.d/mysql script. It's Bugzilla
[Bug 51711] Changed - MySQL looses bin-logs during logrotate.
Joel Fowler
===
At 01:16 PM 8/14/01 -0500, Gerald Clark wrote:
I don't recall ever losing a log.
Are you sure logrotate isn't renaming it?
Joel Fowler wrote:
I agree that Red Hat has an issue with safe_mysqld and logrotate.
However, in my opinion MySQL has a much more serious problem.
In a logging system there shouldn't be any subtle ways to drop records
let alone entire logs.
Kill -HUP mysqld.pid is exactly that -- a very poor design leading to a
big trap - one which Red Hat just happened to fall in.
Joel Fowler
At 08:36 AM 8/14/01 -0500, Gerald Clark wrote:
This really is not a MySQL issue, but a Red Hat issue.
Don't logrotate the MySQL bin logs.
Joel Fowler wrote:
Environment: Red Hat 7.1
mysqld 3.23.36-log
/etc/my.cnf as follows:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-bin=/bu/mysql/online-log/iServ2
log-bin-index=/bu/mysql/online-log/iServ2.index
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
/etc/logrotate.d/mysqld (as distributed) follows:
=
/var/log/mysqld.log {
missingok
create 0640 mysql mysql
prerotate
[ -e /var/lock/subsys/mysqld ] \
/bin/kill -HUP `/bin/cat /var/run/mysqld/mysqld.pid` || /bin/true
endscript
postrotate
[ -e /var/lock/subsys/mysqld ] \
/bin/kill -HUP `/bin/cat /var/run/mysqld/mysqld.pid` || /bin/true
endscript
}
Problem Synopsis:
==
1. /etc/logrotate.d/mysql executes a kill -HUP mysqld.pid during
pre and postrotate operations.
2. -HUP causes mysqld to discard all existing bin-logs (DISASTER) and
start a new one.
3. This destroys recovery strategies built on bin-logs.
It also (as far as I can tell) will cause replication to loose
logs and integrity.
Note: This is a pretty big hole !!!
To Simulate:
=
1. Configure bin-log(s)
2. List bin-log(s)
3. kill -HUP mysqld.pid
4. Bin-log(s) from 2. will have been purged and a new log started (as
if reset master was performed).
Note: For recovery and replication to work correctly existing
bin-log(s) must be left in tact.
Any help will be appreciated.
Please advise,
Joel Fowler
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-- Gerald L. Clark
[EMAIL PROTECTED]
--
Gerald L. Clark
[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
REAL MONEY
REAL MONEY Subject: Fw: .AS SEEN ON NATIONAL TV Subject:REAL MONEY Dear Friend Future Millionaire: AS SEEN ON NATIONAL TV: Make over a half million dollars every 4 to 5 months from your home for an investment of only $25 U.S. Dollars one time expense. THANK'S TO THE COMPUTER AGE AND THE INTERNET! == BE A MILLIONAIRE LIKE OTHERS WITHIN A YEAR!!! This is the letter you have been hearing about on the news lately. Due to the popularity of this letter a national weekly news program recently devoted an entire show to this program described below. The show also investigated whether it can really make people money and whether the program was legal. Their findings proved once and for all that there are absolutely NO Laws prohibiting anyone's participation in the program and if people can - follow the simple instructions, they are bound to make some mega bucks with only $25 out of pocket cost''. DUE TO THE RECENT INCREASE OF PUBLICITY and POPULARITY, THIS PROGRAM IS CURRENTLY WORKING BETTER THAN EVER. This is what Pam Hedland of Fort Lee, New Jersey had to say: Thanks to this profitable opportunity. I was approached many times before, but each time I passed on it. I am so glad I finally joined just to see what one could expect in return for the minimal effort and money required. To my astonishment, I received total of $610,470.00 in 21 weeks, with money still coming in. === Another testimonial: This program has been around for a long time but I never believed in it. But one day when I received this again, in the mail I decided to gamble my $25 on it. I followed the simple instructions and Walla . 3 weeks later the money started to come in. First month I only made $240.00 but the next 2 months after that I made a total of $290,000.00. So far, in the past 8 months, I have made over $710,000.00 and I am playing it again. The key to success in this program is to follow the simple steps and NOT change anything.'' More testimonials later but first, $ PRINT THIS NOW FOR YOUR FUTUREREFERENCE $ If you would like to make at least $500,000 every 4 to 5 months easily and comfortably, please read the following...THEN READ IT AGAIN and AGAIN!!! $$ FOLLOW THE SIMPLE INSTRUCTION BELOW AND YOUR FINANCIAL DREAMS WILL COME TRUE, GUARANTEED! INSTRUCTIONS: Order all 5 reports shown on the list below: For each report, send $5 CASH, THE NAME NUMBER OF THE REPORT YOU ARE ORDERING and YOUR E-MAIL ADDRESS to the person whose name appears ON THAT LIST next to the report. MAKE SURE YOUR RETURN ADDRESS IS ON YOUR ENVELOPE TOP LEFT CORNER in case of any mail problems. Make sure you order each of the 5 reports. You will need all 5 reports so that you can save them on your computer and resell them. YOUR TOTAL COST $5 X 5=$25.00. Within a few days you will receive, via e-mail, each of the 5 reports from these 5 different individuals. Save them on your computer so they will be accessible for you to send to the 1,000's of people who will order them from you. Also make a floppy of these reports and keep it on your desk incase something happen to your computer. IMPORTANT - DO NOT alter the names of the people who are listed next to each report, or their sequence on the list, in any way other than what is instructed below in steps '' 1 through 6 '' or you will loose out on majority of your profits. Once you understand the way this works, you will also see how it does not work if you change it. Remember, this method has been tested, and if you alter, it will NOT work !!! People have tried to put their friends/relatives names on all five thinking they could get all the money. But it does not work this way. So Do Not try to change anything other than what is instructed. If you do, it will not work for you. Remember, honesty reaps the reward!!! 1. After you have ordered all 5 reports, take this advertisement and REMOVE the name address of the person in REPORT # 5. This person has made it through the cycle and is no doubt counting their fortune. 2. Move the name address in REPORT # 4 down TO REPORT # 5. 3. Move the name address in REPORT # 3 down TO REPORT # 4. 4. Move the name address in REPORT # 2 down TO REPORT # 3. 5. Move the name address in REPORT # 1 down TO REPORT # 2 6. Insert YOUR name address in the REPORT # 1 Position. PLEASE MAKE SURE you copy every name address ACCURATELY! == Take this entire letter, with the modified list of names, and save it on your computer. DO NOT MAKE ANY OTHER CHANGES. Save this on a disk as well just in case if you loose any data. To assist you with marketing your business on the
Re: encrypt/decrypt question
Michael,
I just did something like this, and used the ENCODE/DECODE. Works well.
Basically you want to assign a special key for the encoding/decoding of the
data you want to encode/decode. The column type should be either a BLOB or
TINYBOLD, as it's stored in a binary format, depend on the size of the data
being encoded.
To encode the data, you do something like this.
The $key would equal a special value to encode then decode it back, without the
$key, it will not be able to decode the encoded data. Like a password to
encode/decode.
INSERT INTO table_name VALUE
('foo','bar','foobar',ENCODE($data_to_encode,$key),'other_data');
Then to retrieve the encoded data,
SELECT DECODE(col_name_with_encode_data,$key) FROM table_name WHERE something
= 'A_Value';
This is a very simplistic example, but should give you some ideas on how it can
work.
Hope this helps,
On Tue, 14 Aug 2001 11:29:07 -0700, Michael Tam [EMAIL PROTECTED] wrote:
Hi all,
I am very new to the encrypt and decrypt data process and would like to know how
do I able to encrypt a string and store to MySQL and retrieve the data and decrypt it
at the later time.
I understood it sorts of contradict the point of security but I just want to use
it to cover the data such that the non-technical user can see the data is there but
they couldn't understand them by just reading it.
It may be a dump question but I would be greatly appreciated for any suggestion
or help.
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I blew it big time... locked myself out of mysql
Thanks for all the replies, I have followed the instructions in the manual and am still getting an error, here is the message: --- simrad_4# safe_mysqld --skip-grant-tables [1] 57953 simrad_4# Starting mysqld daemon with databases from /var/db/mysql simrad_4# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.38 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql grant all privileges on *.* to root@localhost identified by 'xx'; ERROR 1047: Unknown command I have tried a number of variations on the grant statement above but they all fail with the same message. More suggestions? -- Chip Hans Zaunere [EMAIL PROTECTED] on 08/14/2001 07:37:55 PM Internet mail from: To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: I blew it big time... locked myself out of mysql This link, http://www.mysql.com/doc/P/r/Problems.html is a life-saver. Check out A.9 for your specific problem. Hans [EMAIL PROTECTED] wrote: I used mysqladmin to create a database and set the grant properties to root@localhost with the password, but now am unable to use mysql at all. How can I rectify this problem? When I try to access mysql I get 'Access denied for user root@localhost'. I have tried, from the command line, with -uroot -ppassword and get the same results. Please help ASAP. I have always been able to connect as root with just 'mysql' at the prompt. -- Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712-1138 There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corp., 1977 (-- Then why do I have nine? Somebody help me!) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php (See attached file: hz11.vcf) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: encrypt/decrypt question
If all you're looking for is a trivial hiding of the data, then I'd suggest doing a rot13 on the string. I highly doubt there is a native SQL function that does this, so you'll need to write your own function in whatever interface you're using. Perl/PHP/whatever. Rot13 is a simple rotation of the ASCII alphabet by 13 places. i.e. A becomes N, B becomes O, C becomes P, etc. The set wraps so that N becomes A, O becomes B, etc. It's nice because the encrypt and decrypt functions are exactly the same. Rene At 11:29 AM 8/14/01, you wrote: Hi all, I am very new to the encrypt and decrypt data process and would like to know how do I able to encrypt a string and store to MySQL and retrieve the data and decrypt it at the later time. I understood it sorts of contradict the point of security but I just want to use it to cover the data such that the non-technical user can see the data is there but they couldn't understand them by just reading it. It may be a dump question but I would be greatly appreciated for any suggestion or help. Regards, Michael -- René Churchill [EMAIL PROTECTED] Vermont Web Wizard, LLC802-244-5151 Specializing in Web Programming802-244-5512 (fax) http://www.vtwebwizard.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost bin-log(s) following logrotate affecting recovery, replication
Joel Fowler [EMAIL PROTECTED] writes: I've also reported this problem to Red Hat' Bugzilla as I understand they're responsible for the /etc/logrotate.d/mysql script. It's Bugzilla [Bug 51711] Changed - MySQL looses bin-logs during logrotate. 3.23.41-1 uses a new method for flushing logs prior to logrotate -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: program using mysql_real_open gets error when rexec'd on 3.23.39
I have resolved this problem. The program doing the mysql_real_open had been compiled with the thread library by a cc -Kthread ... compile. When the -Kthread option was removed the problem went away. - Original Message - From: Steve Rickard [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Tuesday, August 14, 2001 9:08 AM Subject: program using mysql_real_open gets error when rexec'd on 3.23.39 I have two servers running mysql on UnixWare 7.1.1. The 1st (uwdev1) is on level 3.22.25 and has been running for more than a year with no problems at all. The 2nd (sqlsrv1) is new and is running 3.23.39. The same databses are on each server. Eventually all mysql databases will be on the sqlsrv1 system. I have a program (mappermysql) that uses the mysql API to send SQL statements to mysql. This program is normally rexec'd from another application. Here is the problem: 1. When mappermysql is executed directly from the command line, it works in all cases. 2. When mappermysql is rexec'd and the target mysql host is uwdev1 (running 3.22.25), it works in all cases. 3. When mappermysql is rexec'd and the target mysql host is sqlsrv1 (running 3.23.39) it always fails on mysql_real_open with the error: ERROR: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (4) The code that fails is if (!mysql_real_connect(mysql, localhost, root, NULL, database, 0, NULL, 0)) I assume that the (4) is the errno value, which in UnixWare is interupted system call. The only difference between rexecing mappermysql and not is that the rexec'd one has a user of inetd. This causes no problem on the earlier level. This seems to be a permissions problem, but I have not been able to figure it out. Any help will be greatly appreciated. Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Local Sockets vs TCP
Connect() does that for you. The mysql library handles the communication to the server. You just use the supplied functions. Are you sure it was sockets you were running out of? Hans Zaunere wrote: Ok. I didn't write these scripts, as they were in place when I arrived at this position, however from looking through them, it appears the actual connection to MySQL happens with something like: my $dbh = connect(DBI:mysql:database:localhost, user, password); The above is a perl line. So you are saying that the script should just open() /tmp/mysql.sock and read and write to it like any other file? And, if I am following, replacing the above localhost with the actual hostname of the machine would create a TCP/IP socket/connection to the server, which is the same as if I had to connect remotely? The above perl line is called from local scripts, executing from the perl interpreter via cron, and also in mod_perl scripts, running from Apache. These are essentially the same, correct? Thank you Hans Zaunere [EMAIL PROTECTED] Gerald Clark wrote: These scripts should not be creating their own sockets. The should be connecting to the one socket that the mysql server creates. Hans Zaunere wrote: We have had a MySQL/Apache/Perl combo running fairly smoothly. However the other day MySQL seemingly went crazy, and brought the rest of the system down; no sockets were available, even to ssh into. After a few minutes, enough sockets were available to ssh into, however MySQL seemed to far gone, and had to be restarted. I have a feeling it is due to the scripts we are running (mod_perl via apache and regular perl, via local cronjobs) and the way they are written. All the scripts connect to MySQL via local UNIX domain sockets, thus creating a /tmp/mysql.sock for each invocation. Is this the best way to do it, or should TCP/IP sockets be used, by connecting to the full hostname, versus connecting to localhost, which seems to use local sockets. I know the local sockets are generally considered faster, however I have also heard that the Linux kernel does not handle a lot of local sockets well. Would a combination of local and IP sockets be used, or strictly IP, since strictly local sockets seems to bring the system to the edge. As much information, links, comparasions, benchmarks, data on the subject would be greatly appreciated. Don't hesitate to contact me for additional questions/info. Thank you, Hans Zaunere [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 attachment.txt Content-Type: text/plain -- Gerald L. Clark [EMAIL PROTECTED] -- Gerald L. Clark [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: I blew it big time... locked myself out of mysql
On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL PROTECTED] wrote: Thanks for all the replies, I have followed the instructions in the manual and am still getting an error, here is the message: --- simrad_4# safe_mysqld --skip-grant-tables [1] 57953 simrad_4# Starting mysqld daemon with databases from /var/db/mysql simrad_4# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.38 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql grant all privileges on *.* to root@localhost identified by 'xx'; ERROR 1047: Unknown command that should be: grant all on *.* to root@localhost identified by 'xx' with grant option; Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Urgent:MySql problem
What is your /etc/my.cnf? Do you see mysql daemon running? (use ps -ef) Maybe it is under /tmp/mysql.sock. You need to change the configuration and restart server. Shu At 01:28 PM 6/1/2006 +0530, sachin wrote: Hello, I am working on RH Linux 7.0 MySql is not working at all. My MySql files are under /usr/bin. It gives the following error on running any mysql command Can't connect to localMySql server through socket 'var/lib/mysql/mysql.sock'(111) Please Help me. Thank You Sachin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem rpm installation of MySQL
At 12:33 AM 8/14/2001 -0400, Trond Eivind Glomsrød wrote: Shu Xiao [EMAIL PROTECTED] writes: Hi, I have problem starting MySQL on Redhat7.1. After installed Redhat7.1 which include MySQL rpm installation, I saw the file named mysqld under /etc/init.d . I set up symlink to it under /etc/rc3.d and etc/rc5.d. I intended to start MySQL while Linux booting. But I failed to start it. Checking /var/log/mysql.log I saw the follling: 010813 21:03:15 mysqld started 010813 21:03:15 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010813 21:03:15 mysqld ended And here is the configuration file /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid I even manual run /etc/init.d/mysqld start and still got the same error. Anybody can point out what wrong here? I do see the host.frm under /var/lib/mysql/mysql. But why it always failed to find it? For some reason (probably a manual mysql_install_db, which is bad and unnecesarry), the database user don't have write access. chown -R mysql.mysql /var/lib/mysql should solve the problem. Thanks. It works after I did chown -R mysql.mysql /var/lib/mysql. BTW, if I want to upgrade to new rpm version, what should I do. The RPM program will take care of upgrading itself? Shu -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem rpm installation of MySQL
Shu Xiao [EMAIL PROTECTED] writes: BTW, if I want to upgrade to new rpm version, what should I do. The RPM program will take care of upgrading itself? If you get the new version of mysql in rpm format (eg. from Rawhide), 'rpm -Uvh mysql*rpm' should take care of it. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
nested if statements allowed?
I am trying to do a nested if, but it appears to break my query... Here is a sample of what I am trying to, basically validating email addresses out of a db: select IF( (LENGTH( emailaddr ) = 1 || NOT LOCATE( \@,emailaddr ) || LOCATE( ,emailaddr ), (IF address.ts = 2001081300, CONCAT( login, \@blah.com ), CONCAT( login, \@crap.com )), emailaddr AS email FROM logintable WHERE eid = $id; Basically, I check to see if the email address is not null and greater than 1 character in length, if there is an @ sign in it, and that there aren't any spaces in it. If it fails those three tests, I check the timestamp of a record, and append one of two different domains to the login. This worked before with just the concat ... blah.com line as expr2 of the if statement, but when I try to make expr2 an if statement itself, it breaks. Can anyone tell me if nested ifs aren't allowed, or is my syntax just flat out wrong? Thanks in Advance, Eric __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Local Sockets vs TCP
Connect() does that for you. The mysql library handles the communication to the server. You just use the supplied functions. Are you sure it was sockets you were running out of? Well the supplied functions have been used. How could I confirm that the system was in fact running out of sockets or file descriptors. Do you know of any Linux kernel specific issues that hinder the use of a lot of local UNIX sockets. Any references/studies of the Linux kernel's problems with this sort of thing. Would it be better to just switch to TCP/IP sockets? Thank you, Hans Zaunere [EMAIL PROTECTED] Hans Zaunere wrote: Ok. I didn't write these scripts, as they were in place when I arrived at this position, however from looking through them, it appears the actual connection to MySQL happens with something like: my $dbh = connect(DBI:mysql:database:localhost, user, password); The above is a perl line. So you are saying that the script should just open() /tmp/mysql.sock and read and write to it like any other file? And, if I am following, replacing the above localhost with the actual hostname of the machine would create a TCP/IP socket/connection to the server, which is the same as if I had to connect remotely? The above perl line is called from local scripts, executing from the perl interpreter via cron, and also in mod_perl scripts, running from Apache. These are essentially the same, correct? Thank you Hans Zaunere [EMAIL PROTECTED] Gerald Clark wrote: These scripts should not be creating their own sockets. The should be connecting to the one socket that the mysql server creates. Hans Zaunere wrote: We have had a MySQL/Apache/Perl combo running fairly smoothly. However the other day MySQL seemingly went crazy, and brought the rest of the system down; no sockets were available, even to ssh into. After a few minutes, enough sockets were available to ssh into, however MySQL seemed to far gone, and had to be restarted. I have a feeling it is due to the scripts we are running (mod_perl via apache and regular perl, via local cronjobs) and the way they are written. All the scripts connect to MySQL via local UNIX domain sockets, thus creating a /tmp/mysql.sock for each invocation. Is this the best way to do it, or should TCP/IP sockets be used, by connecting to the full hostname, versus connecting to localhost, which seems to use local sockets. I know the local sockets are generally considered faster, however I have also heard that the Linux kernel does not handle a lot of local sockets well. Would a combination of local and IP sockets be used, or strictly IP, since strictly local sockets seems to bring the system to the edge. As much information, links, comparasions, benchmarks, data on the subject would be greatly appreciated. Don't hesitate to contact me for additional questions/info. Thank you, Hans Zaunere [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 attachment.txt Content-Type: text/plain -- Gerald L. Clark [EMAIL PROTECTED] -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql only stores one word?
Hey im pretty new to mysql, but I made a basic html form and used php to post it to my mysql database. It goes in fine, but it only carries the first word in each input box. So say for description I put in My little white dog it only stores My in the database. Would appreciate any insight you may have! Thanks.
Re: I blew it big time... locked myself out of mysql
[EMAIL PROTECTED]@bellsouth.net on 08/14/2001 10:03:13 PM Internet mail from: Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: I blew it big time... locked myself out of mysql On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL PROTECTED] wrote: Thanks for all the replies, I have followed the instructions in the manual and am still getting an error, here is the message: --- simrad_4# safe_mysqld --skip-grant-tables [1] 57953 simrad_4# Starting mysqld daemon with databases from /var/db/mysql simrad_4# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.38 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql grant all privileges on *.* to root@localhost identified by 'xx'; ERROR 1047: Unknown command that should be: grant all on *.* to root@localhost identified by 'xx' with grant option; Turns out I get the same error message when I try the command that way too. -- Chip Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems compiling mysql on linux 7.0
Title: Blank
I am getting this error when trying to install mysql
# ./configure --with-low-memory --prefix=/usr/local/mysql loading
cache ./config.cachechecking host system type...
i586-pc-linux-gnuchecking target system type...
i586-pc-linux-gnuchecking build system type... i586-pc-linux-gnuchecking
for a BSD compatible install... (cached) /usr/bin/install -cchecking whether
build environment is sane... yeschecking whether make sets ${MAKE}...
(cached) yeschecking for working aclocal... missingchecking for working
autoconf... foundchecking for working automake... missingchecking for
working autoheader... foundchecking for working makeinfo...
foundchecking whether to enable maintainer-specific portions of Makefiles...
nochecking whether build environment is sane... yeschecking whether make
sets ${MAKE}... (cached) yeschecking for gawk... (cached) gawkchecking
for gcc... (cached) gccchecking whether the C compiler (gcc )
works... yeschecking whether the C compiler (gcc ) is
.
checking for tcgetattr... yeschecking whether stat file-mode macros are
broken... nochecking return type of signal handlers... voidchecking for
type of signal functions... posixchecking whether programs are able to
redeclare getpw functions... yeschecking for TIOCGWINSZ in sys/ioctl.h...
yeschecking for FIONREAD in sys/ioctl.h... yeschecking for TIOCSTAT in
sys/ioctl.h... nochecking if struct dirent has a d_ino member...
yeschecking whether signal handlers are of type void... yeschecking for
tgetent in -lncurses... nochecking for tgetent in -lcurses... nochecking
for tgetent in -ltermcap... nochecking for termcap functions library...
configure: error: No curses/termcap library found
I can't seem to get it to compile. Still a newbie at this.
Vien HuynhleClearsail Communications
RE: SELECT .. OR from multiple tables
On Tue, 14 Aug 2001, Bruce Stewart wrote: How about a UNION query...? Too bad MySQL doesn't support them yet ;) -dave /*== www.urth.org We await the New Sun ==*/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: encrypt/decrypt question
I am very new to the encrypt and decrypt data process and would like to know how do I able to encrypt a string and store to MySQL and retrieve the data and decrypt it at the later time. Grab a copy of mcrypt (search http://freshmeat.net/ for it) and read the docs for it -- its a good idea to do the encryption / decryption inside the application rather than on the database server if it will be done over a network. -- Michael T. Babcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems compiling mysql on linux 7.0
Title: Blank
I am getting this error when trying to install mysql
# ./configure --with-low-memory --prefix=/usr/local/mysql loading
cache ./config.cachechecking host system type...
i586-pc-linux-gnuchecking target system type...
i586-pc-linux-gnuchecking build system type... i586-pc-linux-gnuchecking
for a BSD compatible install... (cached) /usr/bin/install -cchecking whether
build environment is sane... yeschecking whether make sets ${MAKE}...
(cached) yeschecking for working aclocal... missingchecking for working
autoconf... foundchecking for working automake... missingchecking for
working autoheader... foundchecking for working makeinfo...
foundchecking whether to enable maintainer-specific portions of Makefiles...
nochecking whether build environment is sane... yeschecking whether make
sets ${MAKE}... (cached) yeschecking for gawk... (cached) gawkchecking
for gcc... (cached) gccchecking whether the C compiler (gcc )
works... yeschecking whether the C compiler (gcc ) is
.
checking for tcgetattr... yeschecking whether stat file-mode macros are
broken... nochecking return type of signal handlers... voidchecking for
type of signal functions... posixchecking whether programs are able to
redeclare getpw functions... yeschecking for TIOCGWINSZ in sys/ioctl.h...
yeschecking for FIONREAD in sys/ioctl.h... yeschecking for TIOCSTAT in
sys/ioctl.h... nochecking if struct dirent has a d_ino member...
yeschecking whether signal handlers are of type void... yeschecking for
tgetent in -lncurses... nochecking for tgetent in -lcurses... nochecking
for tgetent in -ltermcap... nochecking for termcap functions library...
configure: error: No curses/termcap library found
I can't seem to get it to compile. Still a newbie at this.
Vien HuynhleClearsail Communications
Replication
Hello, My ISP provides me with a MySQL database. I have installed MyODBC and MySQL on my Windows2000 machine. Can you tell me if its possible to replicate the database to my own computer, make changes and these be replicated back to the database hosted by my ISP ? Thanks for any help Neil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 only stores one word?
post some code. Make sure you're using quotes in the right places. Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com On Tue, 14 Aug 2001 13:39:48 -0700 Nate Sanden [EMAIL PROTECTED] wrote: Hey im pretty new to mysql, but I made a basic html form and used php to post it to my mysql database. It goes in fine, but it only carries the first word in each input box. So say for description I put in My little white dog it only stores My in the database. Would appreciate any insight you may have! Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql only stores one word?
On Tue, 14 Aug 2001 13:39:48 -0700, Nate Sanden [EMAIL PROTECTED] wrote: Hey im pretty new to mysql, but I made a basic html form and used php to post it to my mysql database. It goes in fine, but it only carries the first word in each input box. So say for description I put in My little white dog it only stores My in the database. Would appreciate any insight you may have! Thanks. what type of column are you using in your table, the data type, CHAR, VARCHAR, TEXT,..etc.. ?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Design/Permissions Question
I'm relatively new to MySQL and am drawing up some ideas for writing a support/trouble tracking database for my company. I envisioned a single database with seperate tables for various data I would be storing (IP/Connection info table, Machine Inventory Table, etc). Each table would have data for all the clients, and each client would have their own login (via web/php) to view their information. However, it doesn't seem that I can restrict a given mysql user to access only those rows of data that are relevant to their company. It seems that I can only restrict user access to certain tables, which would seem that I would have to have a seperate table per client/company. This doesn't seem to be an ideal way of storing the data I would be collecting though. Is there some other means of restricting access in the desired way or am I being too ambitious in my goals of having the client data accessible via a per user/login basis? Thanks for your time. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems compiling mysql on linux 7.0
Which Linux 7.0 are you using? I'll assume you're talking about Redhat. So why don't you just download the mysql rpm and install it instead of doing it from source? Good luck, Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Local Sockets vs TCP
At 16:41 Uhr -0400 14.8.2001, Hans Zaunere wrote: sort of thing. Would it be better to just switch to TCP/IP sockets? my $dbh = connect(DBI:mysql:database:localhost, user, password); Well it seems like you ARE using INET TCP/IP sockets, since there is 'localhost' there (which goes over the loopback device). Not sure however if this syntax for specifying the host is correct, it's not mentioned this way in man DBD::mysql. And if you were running out of INET sockets so you couldn't connect with ssh anymore, it MUST have used INET sockets, doesn't it?... So try to strip this :localhost off. You could also use some persistent connection mechanism so that the script doesn't reconnect on each request. chj - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: I blew it big time... locked myself out of mysql
Werner Stuerenburg [EMAIL PROTECTED] on 08/14/2001 11:55:37 PM Internet mail from: Please respond to Werner Stuerenburg [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Re: I blew it big time... locked myself out of mysql I think it is grant all on *.* to 'root'@'localhost' identified by 'xx' with grant - Here's what I tried - what could possibly be wrong with this? mysql grant all on *.* to 'root'@'localhost' - identified by 'xx' - with grant option; ERROR 1047: Unknown command mysql grant all on * to 'root'@'localhost' - identified by 'xx' - with grant option; ERROR 1047: Unknown command Still not working. -- chip -- [EMAIL PROTECTED] schrieb am Dienstag, 14. August 2001, 22:54:48: [EMAIL PROTECTED]@bellsouth.net on 08/14/2001 10:03:13 PM Internet mail from: Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: I blew it big time... locked myself out of mysql On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL PROTECTED] wrote: Thanks for all the replies, I have followed the instructions in the manual and am still getting an error, here is the message: --- simrad_4# safe_mysqld --skip-grant-tables [1] 57953 simrad_4# Starting mysqld daemon with databases from /var/db/mysql simrad_4# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.38 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql grant all privileges on *.* to root@localhost identified by 'xx'; ERROR 1047: Unknown command that should be: grant all on *.* to root@localhost identified by 'xx' with grant option; Turns out I get the same error message when I try the command that way too. -- Chip Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Lots of spawning Mysql processes and one that won't die?
Dunno if this will help or not, I'll just throw it out for consideration. I'm just learning PHP, Javascript etc. and tend to make a lot of mistakes in my scripts at this point. When I write a script that executes a binary on the Apache server (NT 4.0 SP6a) and it goes off into na-na land, I terminate the page loading under netscape with the esc key. This leaves dead Apache child processes in the background, one for each page load that is canceled. Any possibility you've got some scripts running/barfing when you start up mySQL? Regards, Dan Haynes -Original Message- From: Ryan Shrout [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 4:36 PM To: [EMAIL PROTECTED] Subject: Lots of spawning Mysql processes and one that won't die? Earlier I told you all about the mysqld problem I had with my dual-athlon server. Well, more hunting and I find this: 6:26pm up 4:55, 1 user, load average: 3.05, 28.62, 26.85 106 processes: 103 sleeping, 3 running, 0 zombie, 0 stopped CPU0 states: 28.4% user, 4.3% system, 0.0% nice, 66.2% idle CPU1 states: 79.3% user, 1.3% system, 0.0% nice, 18.2% idle Mem: 1026964K av, 699636K used, 327328K free, 56K shrd, 67576K buff Swap: 2048248K av, 17980K used, 2030268K free 463444K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 24424 mysql 18 0 6116 6116 2196 R99.9 0.5 4:05 mysqld 19915 apache 8 0 7316 6280 3976 S 0.5 0.6 0:02 httpd 25881 root 11 0 1124 1124 840 R 0.5 0.1 0:00 top 888 apache 9 0 6476 5028 2812 S 0.3 0.4 0:36 httpd 20001 apache 9 0 7460 6424 3972 S 0.3 0.6 0:03 httpd 20276 apache 9 0 7264 6232 3976 S 0.3 0.6 0:02 httpd 24316 apache 8 0 5500 4460 3860 S 0.3 0.4 0:00 httpd 24371 apache 8 0 6072 5032 3900 S 0.3 0.4 0:00 httpd 24441 apache 9 0 5440 4400 3844 S 0.3 0.4 0:00 httpd 24458 apache 8 0 5868 4828 3852 S 0.3 0.4 0:00 httpd 24490 apache 8 0 5496 4456 3852 S 0.3 0.4 0:00 httpd 24459 apache 8 0 5520 4456 3856 S 0.1 0.4 0:00 httpd 24484 apache 8 0 5784 4672 3832 S 0.1 0.4 0:00 httpd 24502 apache 8 0 5496 4432 3860 S 0.1 0.4 0:00 httpd This is after a mysqld restart -- It restarted, but didn't work because this single mysqld process wouldn't die. I even tried to kill it kill 24424 and it still wouldn't go away -- not letting me restart mysqld. What is going on here? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Permissions Problems
On Tue, 14 Aug 2001, Gerald Clark wrote: You are connecting TO host www.4cdg.com, but the permission table entry list the hosts you connect FROM. Actually, it is just one host...I am running on FreeBSD and I have to specify the hostname on the command line. You need to grant privileges to the user and machine you connect FROM. This is explained above. I did get it working today. I had done everything EXCEPT reload the grant tables after I created the users (right out of the documentation). Thanks to all for your assistance. -- Butch Evans http://www.ChristInVerse.com/ http://www.HeIsComingSoon.com/ (in the works) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Float Issue
.1 can not be represented exactly on a binary machine. there must be an
approximation stored in the fractional bits of the floating point
representation. there are more fractional bits in a double than in a float.
so the approximation is better. see the user manual for exact sizes.
At 12:51 PM 8/14/01 -0400, you wrote:
Hi,
There seems to be a round-off problem with FLOAT.
Here's a scenario to replicate it...
--
$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1149 to server version: 3.23.41
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql CREATE TABLE crap (blah float(10,2) DEFAULT '0.00' NOT NULL, blah2
double(10,2));
Query OK, 0 rows affected (0.00 sec)
mysql insert into crap VALUES ('211710.10','211710.10');
Query OK, 1 row affected (0.00 sec)
mysql select * from crap;
+---+---+
| blah | blah2 |
+---+---+
| 211710.09 | 211710.10 |
+---+---+
1 row in set (0.00 sec)
mysql /q
--
Everything works with DOUBLE fine as you can see.
Just thought i'd bring it to someone's attention. FLOAT seems to work with
smaller numbers but when the values start getting big, this sort of thing
starts happening.
Thanks
Dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
tom marlin
[EMAIL PROTECTED]
fax / voice mail: 714 507 3802 ext 4881
My mind wanders a lot; sometimes it leaves completely.
- Duncan Hill
Re: I blew it big time... locked myself out of mysql
On Tue, 14 Aug 2001 [EMAIL PROTECTED] wrote: I used mysqladmin to create a database and set the grant properties to root@localhost with the password, but now am unable to use mysql at all. How can I rectify this problem? When I try to access mysql I get 'Access denied for user root@localhost'. I have tried, from the command line, with -uroot -ppassword and get the same results. Please help ASAP. I have always been able to connect as root with just 'mysql' at the prompt. http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Resetting_permissions -- Butch Evans http://www.ChristInVerse.com/ http://www.HeIsComingSoon.com/ (in the works) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
On Tue, Aug 14, 2001 at 10:11:30PM +0100, Neil Tompkins wrote: Hello, My ISP provides me with a MySQL database. I have installed MyODBC and MySQL on my Windows2000 machine. Can you tell me if its possible to replicate the database to my own computer, make changes and these be replicated back to the database hosted by my ISP ? Have you read the replication documentation in the manual yet? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.29: up 59 days, processed 526,127,607 queries (102/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
development tools
SORRY FOR ANY CROSS POSTING Dear All, I have a plan to build a database application using mysql as it database engine What is the best development tools if I using a Microsoft NT environment. I'll be happy if you share your experience Regards Christian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: development tools
Naturally, the answer is: it depends. What is your application supposed to do? What languages are you versed in? Does your data need to be accessible via the web? At the very least, you will be needing the ODBC driver for MySQL, MyODBC. It's available from the MySQL web site. Other than that, keep in mind that it's an ADO world and you should be just fine when creating Windows applications with MySQL. Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Original Message - From: Christian Hermanus [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 14, 2001 6:07 PM Subject: development tools SORRY FOR ANY CROSS POSTING Dear All, I have a plan to build a database application using mysql as it database engine What is the best development tools if I using a Microsoft NT environment. I'll be happy if you share your experience Regards Christian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
