where clause structures
try this: selectwhere WHATEVER LIKE 'whatever%' notice the '%' at the end not the beginning...hope this is what you wanted... lekker dag verder boet. - Original Message - From: Chris Knipe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 18, 2002 5:54 AM Subject: Re: where clause structures EEK Tables structures :P mysql describe CompanyDetails; +---+---+--+-+-+ + | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+ + | CompanyID | tinyint(4) unsigned | | PRI | NULL| auto_increment | | CompanyActive | enum('1','0') | | MUL | 0 | | | CompanySuspended | enum('0','1','2','3','4','5') | | MUL | 0 | | snip mysql describe CompanyDNSZones; +--+ ---+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+ ---+--+-+-++ | ZoneID | int(11) | | PRI | NULL| auto_increment | | CompanyID| smallint(6) | | MUL | 0 || | ZoneName | varchar(250) | | UNI | || | ZoneServices | set('HasMail','HasMailingList','HasBackupMail','IsMegaDNS','IsSecondary') | | MUL | || - Original Message - From: Chris Knipe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 17, 2002 11:44 PM Subject: where clause structures Lo everyone, I seem to be having a problem with the structuring of my query - more specifically, with the WHERE clause... mysql SELECT ZoneName - FROM CompanyDNSZones - LEFT JOIN CompanyDetails ON CompanyDetails.CompanyID=CompanyDNSZones.CompanyID - WHERE CompanyDetails.CompanySuspended='0' AND - CompanyDNSZones.ZoneName='megalan.co.za' AND - CompanyDNSZones.ZoneServices LIKE '%HasMail%' OR - CompanyDNSZones.ZoneServices LIKE '%HasMailingList%'; +-+ | ZoneName| +-+ | megalan.co.za | | lists.megalan.co.za | +-+ 2 rows in set (0.01 sec) How do I get it to only return the item specified in the WHERE clause? I explictly tell MySQL in my where clause to only return results where CompanyDNSZones.ZoneName='megalan.co.za', so where does it fall out returning lists.megalan.co.za as well? -- me PS: Just for interest takes, can LEFT / RIGHT / a combination of LEFT RIGHT joins be used to cross-reference three or more tables, or is it limited to 2 tables only? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Commit and rollback problem
Hi List! Hope you can help me with my problem... I am trying to incorporate commit and rollback in my sql statements... I have tried it in my web application which runs on weblogic and it work fine. However, when I migrated my web app to Tomcat, it failed to rollback when it encountered an error. Ive been using the same mysql driver for both. Is there a special configuration I need that is dependent on the server Im running? Other sql statements without the commit and rollback functionality.. works perfectly fine in TOmcat. I wonder what's wrong. I dunno where to address the problem... its it a mysql problem or server config. Thanks in advance. Get your own 800 number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
new command in 3.23.52 - innodb database schema dump
As in your instruction on 4 jul 2002 23:51:13 I added the SET NO_FOREIGN_KEY_CHECKS=1; after having installed 3.23.52 for WIN on my win2k system in the first line of my shema dump (obtained with MYSQLDUMP -opt); But wheh I lanch the command mysql database file.dump I received the following error: ERROR 1064 at line 1: You have an error in your SQL syntax near 'NO_FOREIGN_KEY_CHECKS=1' at line 1line 1 Which is my error ? Regards Massimo Petrini - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: where clause structures
Hi, - WHERE CompanyDetails.CompanySuspended='0' AND - CompanyDNSZones.ZoneName='megalan.co.za' AND - CompanyDNSZones.ZoneServices LIKE '%HasMail%' OR - CompanyDNSZones.ZoneServices LIKE '%HasMailingList%'; I explictly tell MySQL in my where clause to only return results where CompanyDNSZones.ZoneName='megalan.co.za', so where does it fall out returning lists.megalan.co.za as well? It's that OR that makes the mess. Try with: - WHERE CompanyDetails.CompanySuspended='0' AND - CompanyDNSZones.ZoneName='megalan.co.za' AND - (CompanyDNSZones.ZoneServices LIKE '%HasMail%' OR - CompanyDNSZones.ZoneServices LIKE '%HasMailingList%'); Regards, Sasa »mysql, select, database« - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
new command in 3.23.52 - innodb database schema dump
As in your instruction on 4 jul 2002 23:51:13 I added the SET NO_FOREIGN_KEY_CHECKS=1; after having installed 3.23.52 for WIN on my win2k system in the first line of my shema dump (obtained with MYSQLDUMP -opt); But wheh I lanch the command mysql database file.dump I received the following error: ERROR 1064 at line 1: You have an error in your SQL syntax near 'NO_FOREIGN_KEY_CHECKS=1' at line 1line 1 Which is my error ? Regards Massimo Petrini - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
COLDFUSION AND MYSQL
Hello everybody I'm just getting mad with coldfusion, installed on a redhat platform running mysql 2.1.0 Well, the problem occures when I try to create a data source, because I always get this ERROR MESSAGE: []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. So I was wondering if it's a problem of drivers. for example I may not have JDBC drivers installed on that redhat server???Is it possible???If so, can I install them?? thanx marco - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JOIN query with three tables.
Hi, this is probably a simple query but I tried all I can think of without finding a solution. I have three tables, CREATE TABLE Answer ( AnswerID INTEGER NOT NULL AUTO_INCREMENT, QuestionID INTEGER NOT NULL, Value DECIMAL(15,4) NOT NULL, AccountID INTEGER, PRIMARY KEY (AnswerID) ) TYPE=InnoDB; CREATE TABLE Account ( AccountID INTEGER NOT NULL AUTO_INCREMENT, PersonID INTEGER NOT NULL, AccountGroupID INTEGER NOT NULL, UserName VARCHAR(50) NOT NULL, Password VARCHAR(20) NOT NULL, PRIMARY KEY (AccountID) ) TYPE=InnoDB; DROP TABLE Person; CREATE TABLE Person ( PersonID INTEGER NOT NULL AUTO_INCREMENT, FirstName VARCHAR(255) NOT NULL, LastName VARCHAR(255) NOT NULL, PRIMARY KEY (PersonID) ) TYPE=InnoDB; Basicly, Answer can have an Account and an Account always has a Person. What would want is a query that produces a resultset where each row contains all fields from Answer + FirstName and LastName from Person for the AccountID that corresponds to the AccountID field in Answer. If an Answer does not have an AccountID I want NULL-values. Example: AnswerID | QuestionID | Value | AccountID | FirstName | LastName 1 | 4 | 10.5 | 45 | John | Persson 2 | 3 | 12.6 | NULL | NULL | NULL FirstName and LastName is NULL because AccountID is NULL Oh, and I can not use version 4+. Help greatly appreciated. /Nicolas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BUG in 4.0.1 - alpha
___ MySQL version 4.0.1-alpha on Win 2000 Server SP2 Rus ___ # mysql config file. # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking default-character-set=cp1251 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/mysql/ datadir = c:/mysql/data/ # Uncomment the following rows if you are using InnoDB tables # Create the directories ibdata and iblogs before to start the server. # If necessary, modify the size of the files innodb_data_file_path = ibdata1:50M innodb_data_home_dir = c:\mysql\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\mysql\ibdata 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:\mysql\ibdata innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable=lower_case_table_names =0 set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 # Uncomment the following row if you are using a Max server and you don't want the # InnoDb tables #skip-innodb [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.options history_length=20 database = test queries_root= c:\mysql\queries last_database_file= c:\mysql\lastdb ___ USE IBANK; DROP TABLE IF EXISTS IB_USERS; CREATE TABLE IB_USERS( USR VARCHAR(30) NOT NULL, PWD VARCHAR(30) NOT NULL, USERID NUMERIC(10) NOT NULL, ISLOCKED DATE, PRIMARY KEY(USR, PWD), UNIQUE(USERID)) TYPE=INNODB DROP TABLE IF EXISTS IB_USERSKEYS; CREATE TABLE IB_USERSKEYS( USERID NUMERIC(10) NOT NULL, STARTDATE DATE NOT NULL, MANAGERID NUMERIC(10) NOT NULL, KEYAC BLOB, KEYCH BLOB, PRIMARY KEY(USERID, STARTDATE), FOREIGN KEY(USERID) REFERENCES IB_USERS(USERID) ON DELETE NO ACTION) TYPE=INNODB ___ InnoDB: foreign constraint creation failed; InnoDB: internal error number 17 InnoDB: Assertion failure in thread 872 in file C:\build\innobase\dict\dict0crea .c line 1241 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] ___ So, I sent. Best regards, Alex Stepanenko ___ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JOIN query with three tables.
Nicolas, select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName from Answer a left join Account c on (a.AccountID = c.AccountID), Person p where c.PersonID = p.PersonID Best regards, Mikhail. - Original Message - From: Nicolas Ivering [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 19, 2002 10:35 AM Subject: JOIN query with three tables. Hi, this is probably a simple query but I tried all I can think of without finding a solution. I have three tables, CREATE TABLE Answer ( AnswerID INTEGER NOT NULL AUTO_INCREMENT, QuestionID INTEGER NOT NULL, Value DECIMAL(15,4) NOT NULL, AccountID INTEGER, PRIMARY KEY (AnswerID) ) TYPE=InnoDB; CREATE TABLE Account ( AccountID INTEGER NOT NULL AUTO_INCREMENT, PersonID INTEGER NOT NULL, AccountGroupID INTEGER NOT NULL, UserName VARCHAR(50) NOT NULL, Password VARCHAR(20) NOT NULL, PRIMARY KEY (AccountID) ) TYPE=InnoDB; DROP TABLE Person; CREATE TABLE Person ( PersonID INTEGER NOT NULL AUTO_INCREMENT, FirstName VARCHAR(255) NOT NULL, LastName VARCHAR(255) NOT NULL, PRIMARY KEY (PersonID) ) TYPE=InnoDB; Basicly, Answer can have an Account and an Account always has a Person. What would want is a query that produces a resultset where each row contains all fields from Answer + FirstName and LastName from Person for the AccountID that corresponds to the AccountID field in Answer. If an Answer does not have an AccountID I want NULL-values. Example: AnswerID | QuestionID | Value | AccountID | FirstName | LastName 1 | 4 | 10.5 | 45 | John | Persson 2 | 3 | 12.6 | NULL | NULL | NULL FirstName and LastName is NULL because AccountID is NULL Oh, and I can not use version 4+. Help greatly appreciated. /Nicolas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JOIN query with three tables.
Thanks for your reply. Unfortunately that query will not select rows where Answer.AccountID is NULL which is what I wanted. /Nicolas Mikhail Entaltsev wrote: Nicolas, select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName from Answer a left join Account c on (a.AccountID = c.AccountID), Person p where c.PersonID = p.PersonID Best regards, Mikhail. - Original Message - From: Nicolas Ivering [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 19, 2002 10:35 AM Subject: JOIN query with three tables. Hi, this is probably a simple query but I tried all I can think of without finding a solution. I have three tables, CREATE TABLE Answer ( AnswerID INTEGER NOT NULL AUTO_INCREMENT, QuestionID INTEGER NOT NULL, Value DECIMAL(15,4) NOT NULL, AccountID INTEGER, PRIMARY KEY (AnswerID) ) TYPE=InnoDB; CREATE TABLE Account ( AccountID INTEGER NOT NULL AUTO_INCREMENT, PersonID INTEGER NOT NULL, AccountGroupID INTEGER NOT NULL, UserName VARCHAR(50) NOT NULL, Password VARCHAR(20) NOT NULL, PRIMARY KEY (AccountID) ) TYPE=InnoDB; DROP TABLE Person; CREATE TABLE Person ( PersonID INTEGER NOT NULL AUTO_INCREMENT, FirstName VARCHAR(255) NOT NULL, LastName VARCHAR(255) NOT NULL, PRIMARY KEY (PersonID) ) TYPE=InnoDB; Basicly, Answer can have an Account and an Account always has a Person. What would want is a query that produces a resultset where each row contains all fields from Answer + FirstName and LastName from Person for the AccountID that corresponds to the AccountID field in Answer. If an Answer does not have an AccountID I want NULL-values. Example: AnswerID | QuestionID | Value | AccountID | FirstName | LastName 1 | 4 | 10.5 | 45 | John | Persson 2 | 3 | 12.6 | NULL | NULL | NULL FirstName and LastName is NULL because AccountID is NULL Oh, and I can not use version 4+. Help greatly appreciated. /Nicolas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Nicolas Serrador Ivering Greenmill Consulting AB Byängsgränd 20 SE-120 40 Årsta Sweden Office: +46 (0)8 664 7 664 Fax:+46 (0)8 664 7 864 Mobile: +46 (0)709 734237 Email: [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: JOIN query with three tables.
Nicolas, select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName from Answer a left join Account c on (a.AccountID = c.AccountID), Person p where c.PersonID = p.PersonID It won't work. Sorry. select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName from Answer a left join Account c on (a.AccountID = c.AccountID) left join Person p on (c.PersonID = p.PersonID) :) Best regards, Mikhail. - Original Message - From: Mikhail Entaltsev [EMAIL PROTECTED] To: Nicolas Ivering [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 19, 2002 10:46 AM Subject: Re: JOIN query with three tables. Nicolas, select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName from Answer a left join Account c on (a.AccountID = c.AccountID), Person p where c.PersonID = p.PersonID Best regards, Mikhail. - Original Message - From: Nicolas Ivering [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 19, 2002 10:35 AM Subject: JOIN query with three tables. Hi, this is probably a simple query but I tried all I can think of without finding a solution. I have three tables, CREATE TABLE Answer ( AnswerID INTEGER NOT NULL AUTO_INCREMENT, QuestionID INTEGER NOT NULL, Value DECIMAL(15,4) NOT NULL, AccountID INTEGER, PRIMARY KEY (AnswerID) ) TYPE=InnoDB; CREATE TABLE Account ( AccountID INTEGER NOT NULL AUTO_INCREMENT, PersonID INTEGER NOT NULL, AccountGroupID INTEGER NOT NULL, UserName VARCHAR(50) NOT NULL, Password VARCHAR(20) NOT NULL, PRIMARY KEY (AccountID) ) TYPE=InnoDB; DROP TABLE Person; CREATE TABLE Person ( PersonID INTEGER NOT NULL AUTO_INCREMENT, FirstName VARCHAR(255) NOT NULL, LastName VARCHAR(255) NOT NULL, PRIMARY KEY (PersonID) ) TYPE=InnoDB; Basicly, Answer can have an Account and an Account always has a Person. What would want is a query that produces a resultset where each row contains all fields from Answer + FirstName and LastName from Person for the AccountID that corresponds to the AccountID field in Answer. If an Answer does not have an AccountID I want NULL-values. Example: AnswerID | QuestionID | Value | AccountID | FirstName | LastName 1 | 4 | 10.5 | 45 | John | Persson 2 | 3 | 12.6 | NULL | NULL | NULL FirstName and LastName is NULL because AccountID is NULL Oh, and I can not use version 4+. Help greatly appreciated. /Nicolas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: COLDFUSION AND MYSQL
Hi marco In the administration page of coldfusion, usually something like: http://domainName/CFIDE/administrator/index.cfm?target=/CFIDE/administrator/welcome.cfm go to your data sources and click the edit button. THen click the show advance settings button. Make sure that the Allowed sql privelages are correct (ie. select, delete, update, etc). That is, if you give your coldfusion a datasource using the user name mySource you have to make sure that your sql database has a user mySource. Make sure that the user mySource has the correct privelages. That is, if you say that the user mySource can only have select privelages then you have to make sure that the coldfusion knows about it too and thus, you can't say that the user: mySource has drop or alter privelages. Hope this helps Desmond From: marco [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: COLDFUSION AND MYSQL Date: Mon, 19 Aug 2002 10:23:19 +0200 Hello everybody I'm just getting mad with coldfusion, installed on a redhat platform running mysql 2.1.0 Well, the problem occures when I try to create a data source, because I always get this ERROR MESSAGE: []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. So I was wondering if it's a problem of drivers. for example I may not have JDBC drivers installed on that redhat server???Is it possible???If so, can I install them?? thanx marco - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JOIN query with three tables.
It worked! Thank you, you just made my day. /Nicolas Mikhail Entaltsev wrote: Nicolas, select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName from Answer a left join Account c on (a.AccountID = c.AccountID), Person p where c.PersonID = p.PersonID It won't work. Sorry. select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName from Answer a left join Account c on (a.AccountID = c.AccountID) left join Person p on (c.PersonID = p.PersonID) :) Best regards, Mikhail. - Original Message - From: Mikhail Entaltsev To: Nicolas Ivering ; Sent: Monday, August 19, 2002 10:46 AM Subject: Re: JOIN query with three tables. Nicolas, select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName from Answer a left join Account c on (a.AccountID = c.AccountID), Person p where c.PersonID = p.PersonID Best regards, Mikhail. - Original Message - From: Nicolas Ivering To: Sent: Monday, August 19, 2002 10:35 AM Subject: JOIN query with three tables. Hi, this is probably a simple query but I tried all I can think of without finding a solution. I have three tables, CREATE TABLE Answer ( AnswerID INTEGER NOT NULL AUTO_INCREMENT, QuestionID INTEGER NOT NULL, Value DECIMAL(15,4) NOT NULL, AccountID INTEGER, PRIMARY KEY (AnswerID) ) TYPE=InnoDB; CREATE TABLE Account ( AccountID INTEGER NOT NULL AUTO_INCREMENT, PersonID INTEGER NOT NULL, AccountGroupID INTEGER NOT NULL, UserName VARCHAR(50) NOT NULL, Password VARCHAR(20) NOT NULL, PRIMARY KEY (AccountID) ) TYPE=InnoDB; DROP TABLE Person; CREATE TABLE Person ( PersonID INTEGER NOT NULL AUTO_INCREMENT, FirstName VARCHAR(255) NOT NULL, LastName VARCHAR(255) NOT NULL, PRIMARY KEY (PersonID) ) TYPE=InnoDB; Basicly, Answer can have an Account and an Account always has a Person. What would want is a query that produces a resultset where each row contains all fields from Answer + FirstName and LastName from Person for the AccountID that corresponds to the AccountID field in Answer. If an Answer does not have an AccountID I want NULL-values. Example: AnswerID | QuestionID | Value | AccountID | FirstName | LastName 1 | 4 | 10.5 | 45 | John | Persson 2 | 3 | 12.6 | NULL | NULL | NULL FirstName and LastName is NULL because AccountID is NULL Oh, and I can not use version 4+. Help greatly appreciated. /Nicolas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail To unsubscribe, e-mail 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 To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Nicolas Serrador Ivering Greenmill Consulting AB Byängsgränd 20 SE-120 40 Årsta Sweden Office: +46 (0)8 664 7 664 Fax:+46 (0)8 664 7 864 Mobile: +46 (0)709 734237 Email: [EMAIL PROTECTED] -- Nicolas Serrador Ivering Greenmill Consulting AB Byängsgränd 20 SE-120 40 Årsta Sweden Office: +46 (0)8 664 7 664 Fax:+46 (0)8 664 7 864 Mobile: +46 (0)709 734237 Email: [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: Manual availability
On Fri, 16 Aug 2002, Frank Shute wrote: I'm using 3.23.51 and I wondered if the manual was available as separate pages of html in a tarball. The manual as shipped is a single page and as this machine's dog slow and takes an age to jump from one part of the manual to another, I thought separate pages might improve matters. I can only find the manual for 4.0 at mysql.com in the format I desire. Frank, using the manual as a reference to lookup everyday problems I highly recommend mysql.info (one file!) together with pinfo 0.6.5 or whatever is latest. This lets you jump around in fractions of a second with a lynx style browser on the ascii screen. Regards, Thomas Spahni - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: new command in 3.23.52 - innodb database schema dump
- Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: Massimo Petrini [EMAIL PROTECTED] Sent: Monday, August 19, 2002 12:52 PM Subject: Re: new command in 3.23.52 - innodb database schema dump Massimo, it was changed to SET FOREIGN_KEY_CHECKS = 0; Please look at section 16 in the InnoDB Reference Manual. Regards, Heikki - Original Message - From: Massimo Petrini [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 19, 2002 10:40 AM Subject: new command in 3.23.52 - innodb database schema dump As in your instruction on 4 jul 2002 23:51:13 I added the SET NO_FOREIGN_KEY_CHECKS=1; after having installed 3.23.52 for WIN on my win2k system in the first line of my shema dump (obtained with MYSQLDUMP -opt); But wheh I lanch the command mysql database file.dump I received the following error: ERROR 1064 at line 1: You have an error in your SQL syntax near 'NO_FOREIGN_KEY_CHECKS=1' at line 1line 1 Which is my error ? Regards Massimo Petrini sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BUG in 4.0.1 - alpha
Aleksandr, thank you for the bug report. Please upgrade to 4.0.2. From http://www.innodb.com/bugfixes.html: February 10, 2002: If one defines a non-latin1 character set as the default character set, then definition of foreign key constraints may fail in an assertion failure in dict0crea.c, reporting an internal error 17. Fixed in 3.23.49 and 4.0.2. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: áÌÅËÓÁÎÄÒ óÔÅÐÁÎÅÎËÏ [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, August 19, 2002 11:47 AM Subject: BUG in 4.0.1 - alpha ___ MySQL version 4.0.1-alpha on Win 2000 Server SP2 Rus ___ # mysql config file. # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking default-character-set=cp1251 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/mysql/ datadir = c:/mysql/data/ # Uncomment the following rows if you are using InnoDB tables # Create the directories ibdata and iblogs before to start the server. # If necessary, modify the size of the files innodb_data_file_path = ibdata1:50M innodb_data_home_dir = c:\mysql\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\mysql\ibdata 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:\mysql\ibdata innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable=lower_case_table_names =0 set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 # Uncomment the following row if you are using a Max server and you don't want the # InnoDb tables #skip-innodb [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.options history_length=20 database = test queries_root= c:\mysql\queries last_database_file= c:\mysql\lastdb ___ USE IBANK; DROP TABLE IF EXISTS IB_USERS; CREATE TABLE IB_USERS( USR VARCHAR(30) NOT NULL, PWD VARCHAR(30) NOT NULL, USERID NUMERIC(10) NOT NULL, ISLOCKED DATE, PRIMARY KEY(USR, PWD), UNIQUE(USERID)) TYPE=INNODB DROP TABLE IF EXISTS IB_USERSKEYS; CREATE TABLE IB_USERSKEYS( USERID NUMERIC(10) NOT NULL, STARTDATE DATE NOT NULL, MANAGERID NUMERIC(10) NOT NULL, KEYAC BLOB, KEYCH BLOB, PRIMARY KEY(USERID, STARTDATE), FOREIGN KEY(USERID) REFERENCES IB_USERS(USERID) ON DELETE NO ACTION) TYPE=INNODB ___ InnoDB: foreign constraint creation failed; InnoDB: internal error number 17 InnoDB: Assertion failure in thread 872 in file C:\build\innobase\dict\dict0crea .c line 1241 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] ___ So, I sent. Best regards, Alex Stepanenko ___ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: new command in 3.23.52 - innodb database schema dump
Massimo, Monday, August 19, 2002, 10:40:50 AM, you wrote: MP As in your instruction on 4 jul 2002 23:51:13 I added the MP SET NO_FOREIGN_KEY_CHECKS=1; ^^^ Should be: SET FOREIGN_KEY_CHECKS = 0 MP after having installed 3.23.52 for WIN on my win2k system in the first line MP of my shema dump (obtained with MYSQLDUMP -opt); MP But wheh I lanch the command MP mysql database file.dump MP I received the following error: MP ERROR 1064 at line 1: You have an error in your SQL syntax near MP 'NO_FOREIGN_KEY_CHECKS=1' at line 1line 1 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how should I enter data into foreign key fields?
Kai, Sunday, August 18, 2002, 1:53:32 AM, you wrote: KV Just created a table with a column named client_nr that is a foreign key KV referencing to my Clients table: KV CREATE TABLE Contacts ( KV contact_nrint not null auto_increment, KV first_namechar(30), KV last_namechar(30), KV client_nr char (30), KV emailchar(30), KV tel_1char(5), KV tel_2char(30), KV mobilechar(30), KV faxchar(30), KV tel_homechar(30), KV foreign key (client_nr) references Clients (client_nr), KV primary key (contact_nr) KV ) KV I know how to enter values using insert into but I don't know how to enter KV the right key value from the Clients table. You just insert into Contacts.client_nr value that is present in the Clients.client_nr. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Re: BUG in 4.0.1 - alpha
áÌÅËÓÁÎÄÒ, Monday, August 19, 2002, 2:49:58 PM, you wrote: áó ___ áó MySQL version 4.0.1-alpha on Win 2000 Server SP2 Rus áó ___ áó # The MySQL server áó [mysqld] áó port=3306 áó #socket=MySQL áó skip-locking áó default-character-set=cp1251 [skip] áó InnoDB: foreign constraint creation failed; áó InnoDB: internal error number 17 áó InnoDB: Assertion failure in thread 872 in file áó C:\build\innobase\dict\dict0crea áó .c line 1241 áó InnoDB: We intentionally generate a memory trap. áó InnoDB: Send a detailed bug report to [EMAIL PROTECTED] Thanks for bug report. It's a known bug and it was fixed in 3.23.49: http://www.innodb.com/bugfixes.html 4.0.1 is about 8 months old and many bugs were fixed. I suggest you to upgrade to version 4.0.2 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Strange PHP + MySQL add / update issue with NULL values
Dan, Saturday, August 17, 2002, 7:55:53 PM, you wrote: DT I have a table where I have specified several columns which I have specified DT that NULL values are not allowed. DT I have created a PHP based create / update / delete page where users can DT update the table. DT I have an INSERT script that takes the user input and generates the DT following query statement. DT Insert: DT INSERT INTO table SET required_field = NULL DT I have set the required field to NULL which results in an error because DT naturally this is a required field. If I use an actual value the query runs DT fine and the row is added. DT Now I have another page that allows the user to update the existing rows. DT Update: DT UPDATE table SET required_field = NULL WHERE id = '2' DT This assumes that the user has cleared a required field and is attempting to DT enter NULL data for a required field. If I execute this directly in mysql DT the query fails (0 rows touched). DT If I execute this via PHP from the web page the row is updated but it passes DT instead of NULL so the row is updated. The query above is echoed right DT from the web page and pasted into MySQL. It's a known feature and it is described in the manual: If you try to store NULL into a column that doesn't take NULL values, MySQL Server will store 0 or '' (empty string) in it instead. (This behaviour can, however, be changed with the -DDONT_USE_DEFAULT_FIELDS compile option.) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Re: running mysqld
krzychu, Saturday, August 17, 2002, 5:49:35 PM, you wrote: k I have a problem when I trying to start mysqld (as a root, under RH 7.2). k Allegedly I don't have a rights to run this program... k What I have to do to run mysqld without rebooting system? You doesn't have permissions to run mysqld or you doesn't have permissions on the MySQL data dir? In any case just change permissions. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Re: Next working binary version ?
David, Tuesday, August 13, 2002, 4:48:20 PM, you wrote: DB I've just a tiny question. DB I used mysql 3.23.49 linux binary package but i've got some problems with DB it. DB I should upgrade quite shortly because 3.23.49 binary package is buggy DB ... ). DB We have load problems, memory eating ... DB But i can't use mysql 3.23.51 binary package. DB ( see Re: 3.23.51 bug ? ( was RE: Load problems with 3.23.51 )) DB My linux boxes have got gcc 2.96 and not patched glibc. DB So i can't compile my own mysql until i upgrade or downgrade gcc ... DB So, did someone have an idea of a date for a new mysql linux binary package DB version ? Hi, David! You can find new 3.23.52 binary packages at www.mysql.com Could you install new packages and check if loading problem occurs again? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A question about mm.mysql and the GPL
Hi: Firstly, I'd like to congratulate both MySQL AB and Mr. Mathews on making the JDBC driver an officialy supported download. I have a query though. Newer versions of the mm.mysql driver (now called connector/j) will be released *not* under the LGPL but under the GPL. Now if I am using the mysql database as a web site back end, the web site is totally independent of the database and cannot be considered a derived work of the mysql database. (keep in mind, the notion of derived work is *very* hazy under the GPL). But if the JDBC driver itself is GPL'ed and I am using the driver in my web site's jsp/servlet code, then it's concievable that the entire web site's contents and code become GPL'ed too. Of course, I wouldn't want to GPL by web site/code just because I am using a driver (keep in mind, using, *not* extending or customizing). Well, the question is, does in fact the use of the JDBC driver GPL my java server pages ? That is, does the entire web site become a derived work ? Any offical response from either Mr. Mathews of MySQL AB would be appreciated... Best regards, --j __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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: A question about mm.mysql and the GPL
I'm not from an official source but I would imagine the reason for the change of license is to be able to charge for a non-GPL version of the driver. With that in mind it wouldn't make much sence if you could use the driver with a non-GPL program without making the program GLP also (and thus avoiding the license fee). Best regards Nicolas j.random.programmer wrote: Hi: Firstly, I'd like to congratulate both MySQL AB and Mr. Mathews on making the JDBC driver an officialy supported download. I have a query though. Newer versions of the mm.mysql driver (now called connector/j) will be released *not* under the LGPL but under the GPL. Now if I am using the mysql database as a web site back end, the web site is totally independent of the database and cannot be considered a derived work of the mysql database. (keep in mind, the notion of derived work is *very* hazy under the GPL). But if the JDBC driver itself is GPL'ed and I am using the driver in my web site's jsp/servlet code, then it's concievable that the entire web site's contents and code become GPL'ed too. Of course, I wouldn't want to GPL by web site/code just because I am using a driver (keep in mind, using, *not* extending or customizing). Well, the question is, does in fact the use of the JDBC driver GPL my java server pages ? That is, does the entire web site become a derived work ? Any offical response from either Mr. Mathews of MySQL AB would be appreciated... Best regards, --j __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyCC
Does anyone know if there is there any work continuing to be done on MyCC or any other UI for MySQL? There are many things broken in MyCC and MySQL navigator, such as indexes and foreign keys. While I believe that it can be done with the command line, I would much rather do it with the GUI. Matt Hargraves - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: COLDFUSION AND MYSQL
First thing I would do is update your mysql. That version is very old and probably does not support a lot of stuff you are looking for. After that I would go and download the newest JDBC drivers from: http://www.mysql.com/downloads/api-jdbc.html -Nick marco said: Hello everybody I'm just getting mad with coldfusion, installed on a redhat platform running mysql 2.1.0 Well, the problem occures when I try to create a data source, because I always get this ERROR MESSAGE: []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. So I was wondering if it's a problem of drivers. for example I may not have JDBC drivers installed on that redhat server???Is it possible???If so, can I install them?? thanx marco - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Constraint Confusion
sql,query Following are two CREATE TABLE statements. The second one fails because of an error in the last line. Does anyone know why? Jim Bailey STATEMENT #1 CREATE TABLE IIM_InventoryItemMaster( IIM_InventoryItemMaster_ID MEDIUMINT(8) NOT NULL, IIM_ItemNm VARCHAR(64), IIM_ItemDescCD VARCHAR(1) DEFAULT 'U', IIM_GenderCD VARCHAR(1), IIM_ItemPN VARCHAR(36), IIM_Spec1Nm VARCHAR(48), IIM_Spec2Nm VARCHAR(48), IIM_RecordCreatedBY VARCHAR(24), IIM_RecordCreatedDT DATETIME, IIM_LastEditBY VARCHAR(24), IIM_LastEditDT DATETIME, PRIMARY KEY(IIM_InventoryItemMaster_ID), KEY(IIM_GenderCD), KEY(IIM_ITEMNm), KEY(IIM_ItemDescCD), key(IIM_ItemPN) ); STATEMENT #2 CREATE TABLE IID_InventoryItemDesc( IID_ItemDescCD VARCHAR(1) NOT NULL, IID_ItemDesc VARCHAR(24), IID_RecordCreatedBY VARCHAR(24), IID_RecordCreatedDT DATETIME, IID_LastEditBY VARCHAR(24), IID_LastEditDT DATETIME, PRIMARY KEY(IID_ItemDescCD), KEY (IID_ItemDesc), CONSTRAINT IIM_TO_IID FOREIGN KEY IIM_InventoryItemMaster (IIM_ItemDescCD) REFERENCES IIM_InventoryItemDesc( Primary key) MATCH FULL); _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Root logining problems!
I Have a problem with logining to MySQL with root. I am runnig Red Hat Linu 7.3 and I just have installed MySQL 3.23.49 frjm the rpm package, which I got with Red Hat Linux 7.3. So I read documentation an made as following: shell mysql_install_db I tryed thi one mysqladmin -u root drop test That what I got: 'Access denied for user: 'root@localhost' (Using password: NO)' I didn't changed any config files or anything else! And every time I am trying to connect MySQL server with root i got this message. But other users can connect to it freely. What shoul I do to connect to MySQL server with root to create the batabase? -- Best regards, Alex Mamcthenkov URL: http://www.leonid.maks.net/~alex/ ICQ UID: 1635188550 Tel: +357 25 340931 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Root logining problems!
Hello, I really hope that Red Hat hasn't changed the root default password to something else. Start mysqld with --skip-grant-tables parameter, then try your mysqladmin command you were trying to execute. If it works then, your grant tables are screwed up somehow.When you're running with --skip-grant-tables, change your root password to something you can use later. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** On Mon, 19 Aug 2002, Alex Mamtchenkov wrote: I Have a problem with logining to MySQL with root. I am runnig Red Hat Linu 7.3 and I just have installed MySQL 3.23.49 frjm the rpm package, which I got with Red Hat Linux 7.3. So I read documentation an made as following: shell mysql_install_db I tryed thi one mysqladmin -u root drop test That what I got: 'Access denied for user: 'root@localhost' (Using password: NO)' I didn't changed any config files or anything else! And every time I am trying to connect MySQL server with root i got this message. But other users can connect to it freely. What shoul I do to connect to MySQL server with root to create the batabase? -- Best regards, Alex Mamcthenkov URL: http://www.leonid.maks.net/~alex/ ICQ UID: 1635188550 Tel: +357 25 340931 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Help : 4.0.2-alpha slower than 3.23.51 :-(
Hi, I have tried to upgrade from MySQL 3.23.51 to 4.0.2-alpha (both source distribution, same environment, same compiler, same configuration file) and I was puzzled to see that my application became 5 to 10 times slower. Most queries in my application (at least the critical part) are write queries (UPDATEs, INSERTs, REPLACEs). I have isolated a simple example of a query which has become really slower - but other, bigger or more complex queries show the same slowdown. Just do the following under 3.23.51 : CREATE TABLE route_state_change ( date BIGINTUNSIGNED NOT NULL, date_end BIGINTUNSIGNED NOT NULL, duration BIGINTUNSIGNED NOT NULL, route_k BIGINTUNSIGNED NOT NULL, stateENUM ('down', 'up') NOT NULL, KEY date (date), KEY route(route_k, date_end), KEY state(state)); Then try the following query (with the mysql client) : INSERT route_state_change (date, route_k, state) VALUES (10297598884803,0x84F00F09383D4C11,'down'), (10297598884803,0xCE7E157EC14416A5,'down'), (10297598884803,0xD665AB1D45B0A608,'down'), (10297598884803,0xFD940CAC8CFD55A6,'down'), (10297598884803,0x3DDB9286093F33C6,'down'), (10297598884803,0xEC1D5ADC0D3C5DBB,'down'), (10297598884803,0x51CB867E525127CC,'down'), (10297598884803,0xCAA6EFB009DC2A02,'down'), (10297598884803,0xF649CFA95CEDA18C,'down'); (just a plain example from my app) In 3.23.51, it always takes 0.00 sec (even repeated several times). After switching to 4.0.2, it always takes 0.08 sec. Which seems huge given that we have a nearly empty table and the query is rather simple ! Here is the config file /etc/my.cnf : [client] port= 3306 socket = /tmp/mysql.sock [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking skip-innodb set-variable= key_buffer=512M set-variable= max_allowed_packet=1M set-variable= table_cache=1024 set-variable= sort_buffer=64M set-variable= join_buffer_size=32M set-variable= record_buffer=32M set-variable= thread_cache=8 set-variable= tmp_table_size=256M set-variable= max_heap_table_size=128M set-variable= myisam_sort_buffer_size=64M server-id = 1 [mysql] no-auto-rehash The environment is : System: Linux machine name 2.4.19 #3 SMP Fri Aug 9 15:18:06 CEST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/ccGCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.3 2.96-110) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jul 18 13:18 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1260480 Apr 15 15:44 /lib/libc-2.2.5.so -rw-r--r--1 root root 2310808 Apr 15 16:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 15 15:55 /usr/lib/libc.so Configure command: ./configure --localstatedir=/data/mysql --with-innodb Regards Antoine. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Displaying the real thread PIDs.
Dan Nelson wrote: You cannot send signals to individual threads. Signals are delivered to the process as a whole rather than to a thread. The only way to kill a thread is from within the application itself. Mysql provides the kill id command for this. Thanks for your reply. What could I do about hung mySQL threads? 'kill' fails to do anything, except marked the thread as killed but keeps it active. Also, when I kill the mySQL parent, I have to then SIGKILL all the hung threads thereafter. Is this normal? I've even seen an issue where no mySQL processes exist yet I cannot restart mySQL since an unknown process is holding port 3306. I then kill apache and some mySQL threads appear out of no where and require a SIGKILL. This doesn't have anything to do with this subject, but I'd like to share my findings. Note: These threads are NOT hung due to locking issues or the like. -reid - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: fromhost() in libwrap.so declared different from tcpd.h? Was: InnoDB on FreeBSD-Alpha problem
Hi Sinisa, No, this is actually quite correct for Linux, as tested so far. How would those functions know than which request is being processed? In multithreaded case argument is the only way. Don't rely on testing -- bug gets a free ride in this case on i386. Even if it works -- it may very well stop working when you put -O3 or smth. What are declarations for your FBSD and what FBSD version is that ?? Declarations in KR style -- w/out the arguments. That is incorrect from the standpoint of C++. But C has this exception encoded so it passes any usage of such functions. Correct with the argument or incorrect w/out as in MySQL. Definitions in libwrap.so are with argument struct request_info * as it should be. Version: FreeBSD-5.0-CURRENT, DEC Alpha DS7310. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: generating random integer id
Hi, If you are generating the id yourself a good strategy is to use UUID that are #34;guaranteed#34; to be #34;universally#34; unique. If you are developing for the Microsoft platform, there is an API functions that returns you a UUID and this number is guaranteed to be unique. If you are working in Java, you can download the source code of a UUID generator. Bye, --- Tom Gao lt;[EMAIL PROTECTED]gt; wrote: gt; hi guys, gt; gt; I'm trying to generate randomly a number as the gt; primary key the key is to gt; be an integer in mysql. So like auto_increment I can gt; insert values and the gt; pk can be generated automatically. gt; gt; could someone point me to the right direction gt; please gt; gt; thanks gt; Tom gt; gt; gt; gt; - gt; Before posting, please check: gt;http://www.mysql.com/manual.php (the manual) gt;http://lists.mysql.com/ (the list gt; archive) gt; gt; To request this thread, e-mail gt; lt;[EMAIL PROTECTED]gt; gt; To unsubscribe, e-mail gt; lt;[EMAIL PROTECTED]gt; gt; Trouble unsubscribing? Try: gt; http://lists.mysql.com/php/unsubscribe.php gt; __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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: Query problem
Change your query for: select red,green,blue from colorchanger INNER JOIN jobattributekit ON colorcode = value where attributekit = Color and jobnumber = 28200124RB4-001 and scenario=JN75K; Also remember that MySQL does not allow sub-queries. --- Amit Lonkar [EMAIL PROTECTED] wrote: Hi all Does mysql support simple joins? I am trying to run the following query:- select red,green,blue from colorchanger where colorcode = select value from jobattributekit where attributekit = Color and jobnumber = 28200124RB4-001 and scenario=JN75K; ColorChanger Table:- ColorCode ColorRedGreenBlue STBBLUE 58 110 165 JOBATTRIBUTEKIT Table:- Jobnumber AttributekitValueScenario 28200124RB4-001 Color STB JN75K The error that it gives is :- ERROR 1064: You have an error in your SQL syntax near 'select value from jobattr ibutekit where attributekit = Color and jobnumber = ' at line 1 Thanks Amit __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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 __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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: How do I uninstall mySQL?
how did you install them? rpm pkgs, source? Scott Dix wrote: mySQL, How do I uninstall mySQL? Scott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Root logining problems!
Alex, Monday, August 19, 2002, 3:38:07 PM, you wrote: AM I Have a problem with logining to MySQL with root. I am runnig Red Hat AM Linu 7.3 and I just have installed MySQL 3.23.49 frjm the rpm package, AM which I got with Red Hat Linux 7.3. AM So I read documentation an made as following: AM shell mysql_install_db AM I tryed thi one AM mysqladmin -u root drop test AM That what I got: AM 'Access denied for user: 'root@localhost' (Using password: NO)' AM I didn't changed any config files or anything else! And every time I am AM trying to connect MySQL server with root i got this message. AM But other users can connect to it freely. AM What shoul I do to connect to MySQL server with root to create the batabase? Alex, do you have MySQL server installed before? If so, old privilege tables are kept and mysql_install_db doesn't do anything. In this case you should use old password to login as a 'root'. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Transaction Question
Randy, Sunday, August 18, 2002, 10:57:54 AM, you wrote: RJ I am using innodb tables via mysql max RJ if i do a select * for update RJ and then do an update statement RJ will this unlock the record for another update or will it wait for me to do RJ a commit? It will wait for COMMIT/ROLLBACK. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MyCC
Matt, Monday, August 19, 2002, 3:03:07 PM, you wrote: MH Does anyone know if there is there any work continuing to be done on MyCC or MH any other UI for MySQL? There are many things broken in MyCC and MySQL MH navigator, such as indexes and foreign keys. While I believe that it can be MH done with the command line, I would much rather do it with the GUI. Matt, MyCC is under development, MySQLGUI - no. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Re: Re: 4.0.x bug with LONGTEXT?
Harald, Friday, August 16, 2002, 5:46:20 PM, you wrote: HF In article [EMAIL PROTECTED], HF Victoria Reznichenko [EMAIL PROTECTED] writes: Harald, Thursday, August 15, 2002, 4:02:44 PM, you wrote: [skip] HF According to the manual, LOAD_FILE returns NULL if the file is too HF large, but apparently this isn't the case here. In your case total text length is bigger than max_allowed_packet, that is why you've got len=0 HF Victoria, HF I agree that this must be the case, but it is contrary to what the HF manual says: HF `LOAD_FILE(file_name)' HF Reads the file and returns the file contents as a string. The file HF must be on the server, you must specify the full pathname to the HF file, and you must have the `FILE' privilege. The file must be HF readable by all and be smaller than `max_allowed_packet'. HF HF If the file doesn't exist or can't be read due to one of the above HF reasons, the function returns `NULL': ... HF The manual states clearly that _the file_ must be smaller than HF max_allowed_packet (which it is), *not* the total text length. Harald, LOAD_FILE() doesn't play any role in this query. You got NULL not because of LOAD_FILE(). Look: CREATE TABLE `tbl1` ( `id` tinyint(3) unsigned NOT NULL auto_increment, `txt1` longtext NOT NULL, `txt2` longtext NOT NULL, `total` longtext NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM INSERT INTO tbl1(txt1, txt2) VALUES (LOAD_FILE('/home/greta/mtest1.txt'), LOAD_FILE('/home/greta/mtest1.txt')); SELECT id, LENGTH(txt1), LENGTH(txt2), LENGTH(total) FROM tbl1; ++--+--+---+ | id | LENGTH(txt1) | LENGTH(txt2) | LENGTH(total) | ++--+--+---+ | 1 | 8390060 | 8390060 | 0 | ++--+--+---+ As you can see txt1 and txt2 contain text file ~ 8M UPDATE tbl1 SET total=CONCAT(txt1,txt2) WHERE id=1; SELECT id, LENGTH(txt1), LENGTH(txt2), LENGTH(total) FROM tbl1; ++--+--+---+ | id | LENGTH(txt1) | LENGTH(txt2) | LENGTH(total) | ++--+--+---+ | 1 | 8390060 | 8390060 | 0 | ++--+--+---+ The same result. MySQL inserts NULL in the total, because you can't store data more than max_allowed_packet. HF I think this behaviour is highly unintuitive - after all, I don't HF transfer more than max_allowed_packet bytes to the server. HF So I'd suggest that this should be documented in the manual. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RPM Installation Question
Excellent info... thanks... (a little late response, but there was no net access in the woods... :P) Thanks again! --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata RedHat Engineer - RHCE # 807302349405893 Cisco Certified - CCNA # CSCO10151622 [EMAIL PROTECTED] --- I love deadlines. I especially like the whooshing sound they make as they go flying by. -- Douglas Adams [1952-2001] -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 1:01 PM To: MYSQL-List (E-mail) Subject: RE: RPM Installation Question read the documentation in the my.cnf sections you can supply datadir=/usr/data/mysql (or whatever the data directory you choose) make sure mysql has permissions on the new directory a couple other things rely on this base directory too your socket file your pid file You can set these too in your /etc/my.cnf pid-file=/usr/data/mysql/mysql.pid socket=/tmp/mysql.sock or some such directories Your err files will write to the datadir you specify -Original Message- From: Jason Frisvold [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 11:25 AM To: [EMAIL PROTECTED] Subject: RPM Installation Question I was hoping to use the RPM distribution to install MySQL on my Linux machine. However, I notice that it sets the data directory to /var/lib/mysql ... This is unacceptable for my purposes... I know I can probably use a link to fix this, but I'd rather do it the right way... How do I tell mySQL where the data directory is? Is this a compiled option? Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata RedHat Engineer - RHCE # 807302349405893 Cisco Certified - CCNA # CSCO10151622 [EMAIL PROTECTED] --- Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world. -- Albert Einstein [1879-1955] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Displaying the real thread PIDs.
In the last episode (Aug 19), Reid Sutherland (mysql) said: Dan Nelson wrote: You cannot send signals to individual threads. Signals are delivered to the process as a whole rather than to a thread. The only way to kill a thread is from within the application itself. Mysql provides the kill id command for this. Thanks for your reply. What could I do about hung mySQL threads? 'kill' fails to do anything, except marked the thread as killed but keeps it active. Also, when I kill the mySQL parent, I have to then SIGKILL all the hung threads thereafter. Is this normal? Nope. Maybe you need to apply some OS patches. I assume since you're talking about threads as though they were processes, you're on Linux. Make sure you're running the latest glibc, and if it still happens, file a bugreport via your Linux distro's bug reporting tool. When you SIGKILL the main LinuxThreads process/thread, all associated processes/threads should be killed also. I've even seen an issue where no mySQL processes exist yet I cannot restart mySQL since an unknown process is holding port 3306. I then kill apache and some mySQL threads appear out of no where and require a SIGKILL. This doesn't have anything to do with this subject, but I'd like to share my findings. You can use the command lsof -i :3306 to display all processes with a socket open on port 3306. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to share a MyISAM table among different databases
Hi, folks! I would apreciate your opinion on my question: How to make a MyISAM table (or several tables) to be shared among different databases served by one MySQL server on Unix (Solaris)? It is OK if this table appears as a read/write table in one database only, other DBs access it read-only. My experience with tables, being hardlinked to the different directories (i.e. databases), is bad, as these tables soon become corrupted. However, I did not experiment with softlinks (ln -s). Any ideas? Thanks already, Dmitry. |Dmitry A. Kuznetsov, PhD | |Office of Information Technology | |Ludwig Institute for Cancer Research | |E-mail: [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
Query Question
Some ficticious data ID Data1 Data2 Data3 1 1 141 1 2 5 140 1 3 4 142 1 4 3 141 1 5 2 142 1 6 5 142 1 7 7 140 1 8 2 143 1 9 3 142 1 10 3 143 1 11 4 144 1 12 2 144 1 13 8 141 2 14 9 140 2 15 6 142 2 16 11 141 2 17 0 142 2 18 9 142 2 19 10 140 2 20 0 143 2 21 11 142 2 22 3 143 2 23 6 144 2 24 0 144 2 For my return I only want a single instance of Data1, so it will most likely need be GROUP BY Data1 I would like those records to include the group that does not contain a Data2 value of 141 There is also a WHERE clause on Data3 = 1 The return would include these values for Data1 7 5 2 4 Is there some way to do this with a single query? If this is unclear, let me know Luc Foisy Technical Magic - www.technical-magic.com 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 Phone: (613) 721-8850 Fax: (613) 596-5096 E-Mail: [EMAIL PROTECTED] Fulfilling the Promise of Technology - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbinlog - doesn't work on some log files
Hi, I tried using the mysqlbinlog from 3.23.52 MAX with no difference in the output at all from 4.0.2 It seems that whatever happened truely caused the log files to become corrupted So my next question would be, is there a way to repair the log files? What are the formating rules for the log files? It is frustrating to be able to look at my data in an editor, but not be able to restore it. Also it sounds like from Heikki Tuuri's response that he thought this could have been somehow caused by a replication related bug. Thanks, Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JOIN in an update query?
Is there any way I can do something like this other than create a little script to do it programatically? UPDATE interests_shipping_conditions_master SET interests_master_record_num = interests_master.record_num WHERE interests_shipping_conditions_master.interest_name = interests_master.interest_name; Is there any mechanism native to MySQL that I can use to do this kind of update? We are using v.3.23.49. Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query Question
I suppose I should have specified that I would not be able to filter by Data1 -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 11:52 AM To: Luc Foisy Subject: RE: Query Question select * from xxx where data2 141 and data3 = 1 and (data3 = 7 or data3 = 5 or data3 = 2 or data3 = 4) groupby data1 -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 10:32 AM To: MYSQL-List (E-mail) Subject: Query Question Some ficticious data IDData1 Data2 Data3 1 1 141 1 2 5 140 1 3 4 142 1 4 3 141 1 5 2 142 1 6 5 142 1 7 7 140 1 8 2 143 1 9 3 142 1 103 143 1 114 144 1 122 144 1 138 141 2 149 140 2 156 142 2 1611 141 2 170 142 2 189 142 2 1910 140 2 200 143 2 2111 142 2 223 143 2 236 144 2 240 144 2 For my return I only want a single instance of Data1, so it will most likely need be GROUP BY Data1 I would like those records to include the group that does not contain a Data2 value of 141 There is also a WHERE clause on Data3 = 1 The return would include these values for Data1 7 5 2 4 Is there some way to do this with a single query? If this is unclear, let me know Luc Foisy Technical Magic - www.technical-magic.com 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 Phone: (613) 721-8850 Fax: (613) 596-5096 E-Mail: [EMAIL PROTECTED] Fulfilling the Promise of Technology - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: High volume HEAP table
On Sunday 18 August 2002 04:17 pm, Rick Robinson wrote: Hi all, I'm testing using a HEAP table to maintain transient state in a high volume TP environment. So far, it looks promising, and I want to ask anyone about similar experiences and solicit some input. Some background: * I have one table; the row length is ~200 bytes and the table will typically never have more than 10,000 rows (more like 7,000 on average). * The table is accessed via one of two keys. I have an index on each. The EXPLAIN output indicates these are used. To the best of my knowledge HEAP tables can only have one index, it has to be primary. In other words, they're basically an in-memory hashtable accessible via SQL. Your application is pretty typical for session-state management. I doubt you'll have any problems, but I'd look into those keys. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Query Question
What have you tried? What did you get? Why is it not what you expected? Luc Foisy wrote: Some ficticious data ID Data1 Data2 Data3 1 1 141 1 2 5 140 1 3 4 142 1 4 3 141 1 5 2 142 1 6 5 142 1 7 7 140 1 8 2 143 1 9 3 142 1 10 3 143 1 11 4 144 1 12 2 144 1 13 8 141 2 14 9 140 2 15 6 142 2 16 11 141 2 17 0 142 2 18 9 142 2 19 10 140 2 20 0 143 2 21 11 142 2 22 3 143 2 23 6 144 2 24 0 144 2 For my return I only want a single instance of Data1, so it will most likely need be GROUP BY Data1 I would like those records to include the group that does not contain a Data2 value of 141 There is also a WHERE clause on Data3 = 1 The return would include these values for Data1 7 5 2 4 Is there some way to do this with a single query? If this is unclear, let me know Luc Foisy Technical Magic - www.technical-magic.com 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 Phone: (613) 721-8850 Fax: (613) 596-5096 E-Mail: [EMAIL PROTECTED] Fulfilling the Promise of Technology - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help : 4.0.2-alpha slower than 3.23.51 :-(
Antoine, Monday, August 19, 2002, 3:57:50 PM, you wrote: A I have tried to upgrade from MySQL 3.23.51 to 4.0.2-alpha (both source A distribution, same environment, same compiler, same configuration file) A and I was puzzled to see that my application became 5 to 10 times slower. A Most queries in my application (at least the critical part) are write A queries (UPDATEs, INSERTs, REPLACEs). I have isolated a simple example A of a query which has become really slower - but other, bigger or more A complex queries show the same slowdown. A Just do the following under 3.23.51 : A CREATE TABLE route_state_change ( A date BIGINTUNSIGNED NOT NULL, A date_end BIGINTUNSIGNED NOT NULL, A duration BIGINTUNSIGNED NOT NULL, A route_k BIGINTUNSIGNED NOT NULL, A stateENUM ('down', 'up') NOT NULL, A KEY date (date), A KEY route(route_k, date_end), A KEY state(state)); A Then try the following query (with the mysql client) : A INSERT route_state_change (date, route_k, state) VALUES A (10297598884803,0x84F00F09383D4C11,'down'), A (10297598884803,0xCE7E157EC14416A5,'down'), A (10297598884803,0xD665AB1D45B0A608,'down'), A (10297598884803,0xFD940CAC8CFD55A6,'down'), A (10297598884803,0x3DDB9286093F33C6,'down'), A (10297598884803,0xEC1D5ADC0D3C5DBB,'down'), A (10297598884803,0x51CB867E525127CC,'down'), A (10297598884803,0xCAA6EFB009DC2A02,'down'), A (10297598884803,0xF649CFA95CEDA18C,'down'); A (just a plain example from my app) A In 3.23.51, it always takes 0.00 sec (even repeated several times). A After switching to 4.0.2, it always takes 0.08 sec. Which seems huge given A that we have a nearly empty table and the query is rather simple ! I tested your example on 4.0.2, 3.23.51, 3.23.52 and got on all versions the same result 0.00-0.01 sec A Here is the config file /etc/my.cnf : A [client] A port= 3306 A socket = /tmp/mysql.sock A [mysqld] A port= 3306 A socket = /tmp/mysql.sock A skip-locking A skip-innodb A set-variable= key_buffer=512M A set-variable= max_allowed_packet=1M A set-variable= table_cache=1024 A set-variable= sort_buffer=64M A set-variable= join_buffer_size=32M A set-variable= record_buffer=32M A set-variable= thread_cache=8 A set-variable= tmp_table_size=256M A set-variable= max_heap_table_size=128M A set-variable= myisam_sort_buffer_size=64M A server-id = 1 Do you use so huge queries that you really need sort_buffer=64M and record_buffer=32M? Don't forget that record_buffer and sort_buffer are specified per-thread. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Re: JOIN in an update query?
Chris, Monday, August 19, 2002, 6:50:29 PM, you wrote: CB Is there any way I can do something like this other than CB create a little script to do it programatically? CB UPDATE interests_shipping_conditions_master SET CB interests_master_record_num = interests_master.record_num WHERE CB interests_shipping_conditions_master.interest_name = interests_master.interest_name; CB Is there any mechanism native to MySQL that I can use CB to do this kind of update? We are using v.3.23.49. On 3.23.49 - Nope. First multi-table update is implemented on 4.0.2 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Import Sybase Ase bcp text file with date type format fields
Hi, I have to import some data in Mysql from a Sybase bulk copy (bcp) text files, and I have some problems with date type format fields. The sybase db has datetime fields and in the dump file the date format is like this: Mar 3 1999 12:00:00:000AM I have created a table with the same structure but when I perform load data ... query command Mysql import only this '-00-00 00:00:00' zero value. Thanks in advance. Danilo Happy Mysql User - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Query Question
Why cant you filter on Data1? I meant select * from xxx where data2 141 and data3 = 1 and (data1 = 7 or data1 = 5 or data1 = 2 or data1 = 4) groupby data1 -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 10:51 AM To: MYSQL-List (E-mail) Subject: RE: Query Question I suppose I should have specified that I would not be able to filter by Data1 -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 11:52 AM To: Luc Foisy Subject: RE: Query Question select * from xxx where data2 141 and data3 = 1 and (data3 = 7 or data3 = 5 or data3 = 2 or data3 = 4) groupby data1 -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 10:32 AM To: MYSQL-List (E-mail) Subject: Query Question Some ficticious data IDData1 Data2 Data3 1 1 141 1 2 5 140 1 3 4 142 1 4 3 141 1 5 2 142 1 6 5 142 1 7 7 140 1 8 2 143 1 9 3 142 1 103 143 1 114 144 1 122 144 1 138 141 2 149 140 2 156 142 2 1611 141 2 170 142 2 189 142 2 1910 140 2 200 143 2 2111 142 2 223 143 2 236 144 2 240 144 2 For my return I only want a single instance of Data1, so it will most likely need be GROUP BY Data1 I would like those records to include the group that does not contain a Data2 value of 141 There is also a WHERE clause on Data3 = 1 The return would include these values for Data1 7 5 2 4 Is there some way to do this with a single query? If this is unclear, let me know Luc Foisy Technical Magic - www.technical-magic.com 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 Phone: (613) 721-8850 Fax: (613) 596-5096 E-Mail: [EMAIL PROTECTED] Fulfilling the Promise of Technology - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: A question about mm.mysql and the GPL
On Monday 19 August 2002 07:21 am, Nicolas Ivering wrote: Several things spring to mind here... 1st of all when you use JDBC, you're coding to the JDBC interface, not to any proprietary interface (IE, your application could just as well call a PostgreSQL JDBC driver and it would not need to be recompiled or even relinked). In that situation its a bit hard to see how the GPL could be construed to apply to your work. 2nd, even assuming the GPL DID apply to your work, it does NOT apply to output generated by the work. If it did then every graphic produced with GIMP would be GPL, and every byte of code emitted by gcc would have to be GPL as well! Clearly this is not the case, so your data is always 'safe'. 3rd the GPL really only deals with DISTRIBUTION of application. In other words if you gave someone the binary of your application, you might have to give them the source. Giving them the URL of a web server which runs GPL code does not in any way oblige you to distribute anything to anyone. This is a point many people miss. You can keep your GPL code hidden away from the world and then for all practical purposes the provisions of the GPL are powerless. Finally I'm not at all sure the notion of a derived work is 'hazy'. It may be complex, but it seems extraordinarily precisely defined by the license. If there's real money riding on it, hand it to a lawyer and get an opinion. If not, then don't worry about it. Now if I am using the mysql database as a web site back end, the web site is totally independent of the database and cannot be considered a derived work of the mysql database. (keep in mind, the notion of derived work is *very* hazy under the GPL). But if the JDBC driver itself is GPL'ed and I am using the driver in my web site's jsp/servlet code, then it's concievable that the entire web site's contents and code become GPL'ed too. Of course, I wouldn't want to GPL by web site/code just because I am using a driver (keep in mind, using, *not* extending or customizing). Well, the question is, does in fact the use of the JDBC driver GPL my java server pages ? That is, does the entire web site become a derived work ? Any offical response from either Mr. Mathews of MySQL AB would be appreciated... Best regards, --j __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
innodb locking behavior question
sql,query While working with record level locking on innodb tables we noted some behavior that has us a bit befuddled. The problem, in its simple form, is that I have two processes accessing the same table. Process A does the following: begin; select * from table1 for update limit 5; Now process B comes along and does: begin; select * from table1 for update limit 5; The behavior we are seeing, on both 3.23.49a and 3.23.52, is that process B gets blocked and eventually times out if process A doesn't commit or rollback. In other words it appears that process A has the whole table locked. What we were expecting was that process B would skip over the records locked by process A and get the next 5 records. Any thoughts on what's really going on here? Is there a (better?) way to do what we want? Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Query Question
On 19 Aug 2002, at 11:32, Luc Foisy wrote: IDData1 Data2 Data3 1 1 141 1 2 5 140 1 3 4 142 1 [snip] For my return I only want a single instance of Data1, so it will most likely need be GROUP BY Data1 I would like those records to include the group that does not contain a Data2 value of 141 There is also a WHERE clause on Data3 = 1 Maybe something like this? SELECT Data1 FROM table_name WHERE Data3 = 1 GROUP BY Data1 HAVING SUM(Data2 = 141) = 0; [Filter fodder: SQL] -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.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: Query Question
I wrote: Maybe something like this? SELECT Data1 FROM table_name WHERE Data3 = 1 GROUP BY Data1 HAVING SUM(Data2 = 141) = 0; Actually that doesn't make sense. I was thinking of the case where there's a left join involved. In your case, it should just be this: SELECT DISTINCT Data1 FROM table_name WHERE Data3 = 1 AND Data2 141; [Filter fodder: SQL] -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.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: Query Question
That would filter out the records containing 141 before it did the group by That would mean I could get a group that had 141 in it 4 3 141 1 9 3 142 1 103 143 1 So, here it would not event look at record 4, then it would return me a group that contains a Data1 value of 3, but I do not require that result because it's original group contains 141 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 11:58 AM To: Luc Foisy Cc: MYSQL-List (E-mail) Subject: Re: Query Question :ID Data1 Data2 Data3 :1 1 141 1 :2 5 140 1 :For my return I only want a single instance of Data1, so it will most likely need be GROUP BY Data1 : :I would like those records to include the group that does not contain a Data2 value of 141 : :There is also a WHERE clause on Data3 = 1 : :The return would include these values for Data1 : :7 :5 :2 :4 : Try this, if you haven't already SELECT ID, Data1 FROM sm_table WHERE Data1 != 141 GROUP by Data1; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Query Question
Because I don't know what Data1 is, thats the result I want to find -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 12:10 PM To: Luc Foisy; MYSQL-List (E-mail) Subject: RE: Query Question Why cant you filter on Data1? I meant select * from xxx where data2 141 and data3 = 1 and (data1 = 7 or data1 = 5 or data1 = 2 or data1 = 4) groupby data1 -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 10:51 AM To: MYSQL-List (E-mail) Subject: RE: Query Question I suppose I should have specified that I would not be able to filter by Data1 -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 11:52 AM To: Luc Foisy Subject: RE: Query Question select * from xxx where data2 141 and data3 = 1 and (data3 = 7 or data3 = 5 or data3 = 2 or data3 = 4) groupby data1 -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 10:32 AM To: MYSQL-List (E-mail) Subject: Query Question Some ficticious data ID Data1 Data2 Data3 1 1 141 1 2 5 140 1 3 4 142 1 4 3 141 1 5 2 142 1 6 5 142 1 7 7 140 1 8 2 143 1 9 3 142 1 10 3 143 1 11 4 144 1 12 2 144 1 13 8 141 2 14 9 140 2 15 6 142 2 16 11 141 2 17 0 142 2 18 9 142 2 19 10 140 2 20 0 143 2 21 11 142 2 22 3 143 2 23 6 144 2 24 0 144 2 For my return I only want a single instance of Data1, so it will most likely need be GROUP BY Data1 I would like those records to include the group that does not contain a Data2 value of 141 There is also a WHERE clause on Data3 = 1 The return would include these values for Data1 7 5 2 4 Is there some way to do this with a single query? If this is unclear, let me know Luc Foisy Technical Magic - www.technical-magic.com 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 Phone: (613) 721-8850 Fax: (613) 596-5096 E-Mail: [EMAIL PROTECTED] Fulfilling the Promise of Technology - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Transaction Question
Thanks for your reply, is it documented somewhere? Randy - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 19, 2002 10:07 AM Subject: Re: Transaction Question Randy, Sunday, August 18, 2002, 10:57:54 AM, you wrote: RJ I am using innodb tables via mysql max RJ if i do a select * for update RJ and then do an update statement RJ will this unlock the record for another update or will it wait for me to do RJ a commit? It will wait for COMMIT/ROLLBACK. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Query Question
Hi, You can try something like this : select (CASE WHEN Data2141 THEN Data1 END) from your_table where Data3=1 group by Data1; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Luc Foisy [EMAIL PROTECTED] To: MYSQL-List (E-mail) [EMAIL PROTECTED] Sent: Monday, August 19, 2002 6:32 PM Subject: Query Question Some ficticious data ID Data1 Data2 Data3 1 1 141 1 2 5 140 1 3 4 142 1 4 3 141 1 5 2 142 1 6 5 142 1 7 7 140 1 8 2 143 1 9 3 142 1 10 3 143 1 11 4 144 1 12 2 144 1 13 8 141 2 14 9 140 2 15 6 142 2 16 11 141 2 17 0 142 2 18 9 142 2 19 10 140 2 20 0 143 2 21 11 142 2 22 3 143 2 23 6 144 2 24 0 144 2 For my return I only want a single instance of Data1, so it will most likely need be GROUP BY Data1 I would like those records to include the group that does not contain a Data2 value of 141 There is also a WHERE clause on Data3 = 1 The return would include these values for Data1 7 5 2 4 Is there some way to do this with a single query? If this is unclear, let me know Luc Foisy Technical Magic - www.technical-magic.com 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 Phone: (613) 721-8850 Fax: (613) 596-5096 E-Mail: [EMAIL PROTECTED] Fulfilling the Promise of Technology - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Import Sybase Ase bcp text file with date type format fields
The mysql datetime will have to be '1999-03-03 12:00:00' or 1999030312 Maurizio Danilo wrote: Hi, I have to import some data in Mysql from a Sybase bulk copy (bcp) text files, and I have some problems with date type format fields. The sybase db has datetime fields and in the dump file the date format is like this: Mar 3 1999 12:00:00:000AM I have created a table with the same structure but when I perform load data ... query command Mysql import only this '-00-00 00:00:00' zero value. Thanks in advance. Danilo Happy Mysql User - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Query Question
I wrote: Actually that doesn't make sense. I was thinking of the case where there's a left join involved. In your case, it should just be this: SELECT DISTINCT Data1 FROM table_name WHERE Data3 = 1 AND Data2 141; Ignore that correction. It seems that what you want is indeed this: SELECT Data1 FROM table_name WHERE Data3 = 1 GROUP BY Data1 HAVING SUM(Data2 = 141) = 0; [Filter fodder: SQL] -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.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
getting started ....
i need help with getting started with mysql i am a java programmer but have not done any database stuff. i assume that mysql can be a good db to start with java database programming ie jdbc stuff. would you also say that mysql would be a good db to start and learn with jdbc ? can some one let me know some getting started java applications (with source code) that i could learn from, tweak them etc etc.. any other info, links etc would be greatly appreciated. thanks Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!! visit http://in.autos.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: How to share a MyISAM table among different databases
Hi. On Mon 2002-08-19 at 17:29:49 +0200, [EMAIL PROTECTED] wrote: Hi, folks! I would apreciate your opinion on my question: How to make a MyISAM table (or several tables) to be shared among different databases served by one MySQL server on Unix (Solaris)? It is OK if this table appears as a read/write table in one database only, other DBs access it read-only. My experience with tables, being hardlinked to the different directories (i.e. databases), is bad, as these tables soon become corrupted. However, I did not experiment with softlinks (ln -s). Any ideas? I think there is no reasonable way to do this. But what is your reason to try this? Usually I would put the common table within its own database and simply use this database in queries, like this: SELECT * FROM table1 as one, common.table2 as two WHERE one.whatever = two.whatever If that does not fit your case, please elaborate. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help : 4.0.2-alpha slower than 3.23.51 :-(
Do you use so huge queries that you really need sort_buffer=64M and record_buffer=32M? Don't forget that record_buffer and sort_buffer are specified per-thread. I don't know exactly which values I need, but when I generate statistical data from the tables it often spans a not-so-small dataset. Also, there is not much concurrency and I am not tight on memory (the box has 2 GB). Would it have something to do with the problem ? Regards Antoine. (keywords : sql,query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to share a MyISAM table among different databases
Hi! On Aug 19, Benjamin Pflugmann wrote: Hi. On Mon 2002-08-19 at 17:29:49 +0200, [EMAIL PROTECTED] wrote: Hi, folks! I would apreciate your opinion on my question: How to make a MyISAM table (or several tables) to be shared among different databases served by one MySQL server on Unix (Solaris)? It is OK if this table appears as a read/write table in one database only, other DBs access it read-only. Any ideas? I think there is no reasonable way to do this. But what is your reason to try this? Benjamin, it is possible with MERGE tables. And as MERGE tables support INSERTs ;)) may be this aliasing can even work with read/write access. One can edit .MRG file to add a proper path there. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: getting started ....
Try the sun site - www.javasoft.com I believe there are tutorials for JDBC. Cheers, Michael -Original Message- From: john greene [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 10:28 AM To: [EMAIL PROTECTED] Subject: getting started i need help with getting started with mysql i am a java programmer but have not done any database stuff. i assume that mysql can be a good db to start with java database programming ie jdbc stuff. would you also say that mysql would be a good db to start and learn with jdbc ? can some one let me know some getting started java applications (with source code) that i could learn from, tweak them etc etc.. any other info, links etc would be greatly appreciated. thanks Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!! visit http://in.autos.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Manual availability
On Mon, Aug 19, 2002 at 10:55:32AM +0200, Thomas Spahni wrote: On Fri, 16 Aug 2002, Frank Shute wrote: I'm using 3.23.51 and I wondered if the manual was available as separate pages of html in a tarball. The manual as shipped is a single page and as this machine's dog slow and takes an age to jump from one part of the manual to another, I thought separate pages might improve matters. I can only find the manual for 4.0 at mysql.com in the format I desire. Frank, using the manual as a reference to lookup everyday problems I highly recommend mysql.info (one file!) together with pinfo 0.6.5 or whatever is latest. This lets you jump around in fractions of a second with a lynx style browser on the ascii screen. Thanks Thomas, I didn't know that mysql came with an info file. Donna was kind enough to send me a really nice framed and broken down html manual for an old version which I prefer to info. Haven't come across pinfo before but I'll check it out. Anybody else interested in a framed and broken down version of the html manual? If there's any interest I'll mark it up for the latest 3.23 release and make it available if thats OK with the mysql AB folks, they're welcome to put it on www.mysql.com if they like. -- Frank *-*-*-*-*-*-*-*-*-*-* Boroughbridge. - PGP keyID: 0xC0B341A3 *-*-*-*-*-*-*-*-*-*-* If I had to quantify Iraq's threat, I would say (it is) zero. -- Scott Ritter, former UN weapons inspector. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB and disk geometry
You might want to lookup MySQL and RAID. MySQL does support a database RAID setup. This confused me early on because I kept thinking of disk based RAID, but this is database based RAID. I haven't used it yet, so I can't help you any more that that. Hope it helps a little. On Thursday, August 15, 2002, at 08:38 PM, [EMAIL PROTECTED] wrote: A problem I have with InnoDB tables, which forced me to use MyISAM tables in a recent project, is as follows: (I am running MySQL on Solaris, not that it matters much for this problem.) With MyISAM tables, I can easily get different databases to reside on separate physical drives. The base directory for database files is /var/mysql/ Then I mounted a drive at /var/mysql/db_a and another at /var/mysql/db_b for instance. Then databases by the names db_a and db_b reside on different physical drives. But with InnoDB, you specify a tablespace file(s) and then the database you create go into those files. I cant figure out any reasonable way to tie specific databases to specific drives, except by running a mysqld server for each drive I want a database on. For large databases, proper planning of disk geometry can have a significant effect on performance. I very much like InnoDB, but can't seem to get around this problem. Any insight would be greatly appreciated. sean peters [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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 4.0.2-alpha slower than 3.23.51 - record_buffer
Hi again, Do you use so huge queries that you really need sort_buffer=64M and record_buffer=32M? Don't forget that record_buffer and sort_buffer are specified per-thread. Well, some further input about this as I've just tried at home (MySQL 4.0.1-alpha-nt). You seem to be right : with record_buffer=2M, the query takes 0.01 sec ; with record_buffer=32M, it jumps to 0.16 sec ! Although there is no swapping, and the task manager shows no change in allocated memory. (sort_buffer on the other hand, doesn't do anything) I'll try to confirm this tomorrow at work However, it's a really strange and annoying behaviour. Nowhere in the documentation is stated something like that, and 3.23 was fine about it. Is it a bug ? Thanks, Antoine. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB and disk geometry
On Mon, Aug 19, 2002 at 02:54:02PM -0400, Brent Baisley wrote: You might want to lookup MySQL and RAID. MySQL does support a database RAID setup. If you change support to provide, I'd agree. We use MySQL on RAID systems all the time, so it certainly supports it. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 13 days, processed 268,437,036 queries (230/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: InnoDB and disk geometry
The raid function is not useful (that's to get around the 2GB filesize limit on certain OS). I think it's a misleading function (I think it should be called RAIF - Redundant Array of Inexpensive Files). I use RAID 1 (hardware) scsi and my load looks to be processor bound (believe it or not) with a dual processor machine. I think that unless you are using a load that requires a quad processor machine, scsi160 drives on a raid card are fast enough, and hence there is no requirement for separate disks. If you must have separate files, I can only assume that there is an undocumented way to create a database in a specified tablespace. -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 2:54 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: InnoDB and disk geometry You might want to lookup MySQL and RAID. MySQL does support a database RAID setup. This confused me early on because I kept thinking of disk based RAID, but this is database based RAID. I haven't used it yet, so I can't help you any more that that. Hope it helps a little. On Thursday, August 15, 2002, at 08:38 PM, [EMAIL PROTECTED] wrote: A problem I have with InnoDB tables, which forced me to use MyISAM tables in a recent project, is as follows: (I am running MySQL on Solaris, not that it matters much for this problem.) With MyISAM tables, I can easily get different databases to reside on separate physical drives. The base directory for database files is /var/mysql/ Then I mounted a drive at /var/mysql/db_a and another at /var/mysql/db_b for instance. Then databases by the names db_a and db_b reside on different physical drives. But with InnoDB, you specify a tablespace file(s) and then the database you create go into those files. I cant figure out any reasonable way to tie specific databases to specific drives, except by running a mysqld server for each drive I want a database on. For large databases, proper planning of disk geometry can have a significant effect on performance. I very much like InnoDB, but can't seem to get around this problem. Any insight would be greatly appreciated. sean peters [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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Query Question
Yes that's it, Thanks! Ignore that correction. It seems that what you want is indeed this: SELECT Data1 FROM table_name WHERE Data3 = 1 GROUP BY Data1 HAVING SUM(Data2 = 141) = 0; [Filter fodder: SQL] Luc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with mysql making my server extremly slow
Hi all, I manage a web server having a lot of http connections, using Apache/PHP/MySQL. When there are too many simultaneous connections (so, many MySQL requests), MySQL stops working efficiently and makes my load average increase a LOT (already seen it at 100 !). The only way to make it decrease is to stop MySQL (I am forced to killall -9 mysqld, since it's the faster way and I hardly can do much on the shell while the load is so high). I am using MySQL server 3.53.52 (last stable), and it's working perfectly when there is not too many SQL requests... but since it's a large website, the problem happens each day at 9pm and we just cannot go on like this. As the dedicated server (Linux Red Hat 7.2) is provided by a webhosting company, MySQL was already installed when I got root access (although it was 3.53.51), and I didn't change the my.cnf file (well, I tried but it wasn't working anymore...). Here is my my.cnf file : [magnet@ns3286 dev]$ cat /etc/my.cnf [mysqld] set-variable = connect_timeout=20 set-variable = max_connections=100 [magnet@ns3286 dev]$ (yes I know it's short, tried to put a basic one but my tables weren't read anymore...). Well, I guess my problem is quite common, even if I didn't find any way to fix it on the MySQL website! I'm sure there are some MySQL experts around there able to help me without telling me to RTFM, since I did so (or tried, since IMHO this manual is far from ergonomic). If someone is willing to help me, and needs some information not listed there, just ask me, I will answer asap... Thank you for your help, it is greatly appreciated! -- Magnet - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 comes with linux ?
red hat linux implementations by default would have the mysql database ? ie if i install the server version of redhat linux then i get mysql database as well. right ? any tips whemn using/configuring/installing mysql database with redhat linux. Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!! visit http://in.autos.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: mysql comes with linux ?
I wasn't aware of this. I thought the Red Hat database was PostgreSQL. --Walt Weaver Bozeman, Montana -Original Message- From: john greene [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 2:32 PM To: [EMAIL PROTECTED] Subject: mysql comes with linux ? red hat linux implementations by default would have the mysql database ? ie if i install the server version of redhat linux then i get mysql database as well. right ? any tips whemn using/configuring/installing mysql database with redhat linux. Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!! visit http://in.autos.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to create a sequence for an id field
I have a SQL statement to create a PostgreSQL table that include a line 'id serial' This line creates a integer field with a sequence atached to it to create an autonumber Is there a way to create a SQL statement to accomplish this that would work with both MySQL and PostgreSQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 comes with linux ?
I don't know if it is installed by default or not (in most distros it is not), but checking is easy enough: When you get to the point of selecting packages, click on the choose individual packages button or radio box (it's been a while since I have done a RH installation) and select MySQL and related packages you want. As for configuration tips, maybe this makes me a Linux weenie, but I just think Webmin is the bee's knees. Makes MySQL configuration so simple. Good luck! -Original Message- From: john greene [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 4:32 PM To: [EMAIL PROTECTED] Subject: mysql comes with linux ? red hat linux implementations by default would have the mysql database ? ie if i install the server version of redhat linux then i get mysql database as well. right ? any tips whemn using/configuring/installing mysql database with redhat linux. Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!! visit http://in.autos.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 comes with linux ?
I believe it has both. Mandrake I know has both. -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 1:40 PM To: [EMAIL PROTECTED] Subject: RE: mysql comes with linux ? I wasn't aware of this. I thought the Red Hat database was PostgreSQL. --Walt Weaver Bozeman, Montana -Original Message- From: john greene [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 2:32 PM To: [EMAIL PROTECTED] Subject: mysql comes with linux ? red hat linux implementations by default would have the mysql database ? ie if i install the server version of redhat linux then i get mysql database as well. right ? any tips whemn using/configuring/installing mysql database with redhat linux. Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!! visit http://in.autos.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 comes with linux ?
Redhat (at least 7.3) comes with MySQL. If select the default install for server, it will NOT install MySQL. You must check the box to Select individual packages, and check off the MySQL binaries. Of course, you can always install them After the installation from the CD's but you might have to work out a few dependancies, especially if you are linking to a websever with php or perl. Roger -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 04:40 PM To: [EMAIL PROTECTED] Subject: RE: mysql comes with linux ? I wasn't aware of this. I thought the Red Hat database was PostgreSQL. --Walt Weaver Bozeman, Montana -Original Message- From: john greene [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 2:32 PM To: [EMAIL PROTECTED] Subject: mysql comes with linux ? red hat linux implementations by default would have the mysql database ? ie if i install the server version of redhat linux then i get mysql database as well. right ? any tips whemn using/configuring/installing mysql database with redhat linux. Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!! visit http://in.autos.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 comes with linux ?
The Red Hat Database is PostgreSQL, but I don't think it comes with RH. Isn't it a seperate (and rather costly) add-on? -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 4:40 PM To: [EMAIL PROTECTED] Subject: RE: mysql comes with linux ? I wasn't aware of this. I thought the Red Hat database was PostgreSQL. --Walt Weaver Bozeman, Montana -Original Message- From: john greene [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 2:32 PM To: [EMAIL PROTECTED] Subject: mysql comes with linux ? red hat linux implementations by default would have the mysql database ? ie if i install the server version of redhat linux then i get mysql database as well. right ? any tips whemn using/configuring/installing mysql database with redhat linux. Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!! visit http://in.autos.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 comes with linux ?
Assuming intel and putting the CD in /dev/cdrom as root... On Redhat 7.3... (Install whatever way you want first) Put in CD#3 (label is Red_Hat_Linux_i3) mount /dev/cdrom /mnt/cdrom cd /mnt/cdrom/RedHat/RPMS rpm -Uvh mysql* chkconfig mysqld on /etc/init.d/mysqld start MySQL 3.23.49 should now be running. This is from memory.. so forgive an typos. The data directory and such are defined in /etc/my.cnf. By default RH makes the data directory /var/lib/mysql. The socket reference will be in that directory also. You can easily change the data to a volume you can backup/grow. I would suggest leaving the socket reference as it seems to be static in the rpm build. You can always check me on that by install the source RPM (which will put the distr in /usr/src/redhat/SOURCES) and recompiling. John Gruber RHCE -Original Message- From: Roger Davis [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 3:54 PM To: [EMAIL PROTECTED] Subject: RE: mysql comes with linux ? Redhat (at least 7.3) comes with MySQL. If select the default install for server, it will NOT install MySQL. You must check the box to Select individual packages, and check off the MySQL binaries. Of course, you can always install them After the installation from the CD's but you might have to work out a few dependancies, especially if you are linking to a websever with php or perl. Roger -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 04:40 PM To: [EMAIL PROTECTED] Subject: RE: mysql comes with linux ? I wasn't aware of this. I thought the Red Hat database was PostgreSQL. --Walt Weaver Bozeman, Montana -Original Message- From: john greene [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 2:32 PM To: [EMAIL PROTECTED] Subject: mysql comes with linux ? red hat linux implementations by default would have the mysql database ? ie if i install the server version of redhat linux then i get mysql database as well. right ? any tips whemn using/configuring/installing mysql database with redhat linux. Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!! visit http://in.autos.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: High volume HEAP table
HEAP tables can have more than one index, but indexes only match = and != -- so you can't use , , etc... Also, comparisons only match the entire index, not the left-most prefix like MyISAM tables. There are a few other quirks, also: http://www.mysql.com/doc/en/HEAP.html --jeff On Sunday 18 August 2002 04:17 pm, Rick Robinson wrote: Hi all, I'm testing using a HEAP table to maintain transient state in a high volume TP environment. So far, it looks promising, and I want to ask anyone about similar experiences and solicit some input. Some background: * I have one table; the row length is ~200 bytes and the table will typically never have more than 10,000 rows (more like 7,000 on average). * The table is accessed via one of two keys. I have an index on each. The EXPLAIN output indicates these are used. To the best of my knowledge HEAP tables can only have one index, it has to be primary. In other words, they're basically an in-memory hashtable accessible via SQL. Your application is pretty typical for session-state management. I doubt you'll have any problems, but I'd look into those keys. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MySQL tutorials, users passwords, interface.
HI, I am just starting out with MySQL, using Tomcat as standalone on a Win2000 machine and java servlets. Could anybody: 1) Recomend a good book which covers the basics of MySQL, /or any good tutorials on the web? 2) Tell me how to set up usernames and passwords for MySQL. 3) Recomend an easy to use interface for MySQL (can I use phpMyAdmin if I'm not using PHP?). Many thanks, Gavin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 tutorials, users passwords, interface.
Could anybody: 1) Recomend a good book which covers the basics of MySQL, /or any good tutorials on the web? The mysql documentation is very good, I use http://www.mysql.com/doc/en/index.html as my home page, but you really have to know what to look for in order to find it. It's been so long since I've looked for a good starting out tutorial to figure out how to use mySQL that I regret to say I don't have any idea on that. Although, that said, following the mySQL documentation from the beginning chapter by chapter has alot of very good information for getting started. 2) Tell me how to set up usernames and passwords for MySQL. Hmm... start here. http://www.mysql.com/doc/en/Default_privileges.html This will have you setup your main (root) user, from there you may want to check out granting and revoking priveleges. (http://www.mysql.com/doc/en/GRANT.html) 3) Recomend an easy to use interface for MySQL (can I use phpMyAdmin if I'm not using PHP?). phpMyAdmin is great, but it certainly requires that you have php installed and running. (Although this doesn't mean you have to use php for anything else.) One windows program that I've used in the past and tends to get reasonably good reviews is mySQLFront available from http://www.anse.de/mysqlfront/. I generally don't recommend using GUI tools for anything that a person doesn't understand. They are easier to use, but that also makes it easier to really screw things up also. JayD - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
High Availability and MySql Replication
Hi, I was hoping someone here might know the best way to setup a mySQL replication environment where master-slave can be flipped to slave-master. NOTE: I am NOT looking for a master=3Dmaster bi-directional updating solution. This is a solution for HA, so when the master dies the slave becomes the master and when the old master returns, it becomes the slave to the new master. The docs are a little unclear on the details and don't indicate everything. It does say it can be done by setting the log-bin in the my.cnf on the slave, and so the slave is ready to become a master when issued a SLAVE STOP; RESET MASTER and CHANGE MASTER TO on the other slave. I have also check archives and could not find any answers. So here are my questions: 1. Are two different my.cnf files used? One when a machine is used as a slave and there when it is a master? The server-id is the same regardless if the server is a master or a slave? 2. Or are each machine setup to be the master of the other? Meaning they have both master and slave info in the my.cnf. 3. A question in regards to the documentation instructions, is the STOP SLAVE only done on the slave (getting ready to become a master) and the RESET MASTER and CHANGE MASTER TO done on the old master? Any help is great appreciated. Thanks!! ~Vicky - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Commit and rollback problem and mm.mysql
Hi. Thanks for the reply... I curious with what you mean by mysql not supporting commit and rollback coz I found this in the site : http://www.mysql.com/documentation/mysql/bychapter/manual_Refere nce.html#COMMIT Actually, Ive already tested it in my app under weblogic(and worked). I was just wondering why when I ported it to tomcat, it didnt seem to work. Im looking at mm.mysql driver. I was wondering if the mm.mysql driver uses a different config when used with weblogic or tomcat. Hope u can help. TIA Get your own 800 number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag On Mon, 19 Aug 2002, suresh ([EMAIL PROTECTED]) wrote: Hi Actually I am not an expert with mysql. I myself is a newbie to mysql But as for I know there is no use of your commit and rollback since mysql does not support both. But the usage in your servlet or jsp coding will not throw any run time or compile time error if you include con.setAutoCommit(true) or rollback. I am not sure whether you are using innoDB where the case is different If you do not use InnoDB try to use Lock and Unlock with Tomcat. It will work for you. first lock the tables where you are going to write or update with WRITE also lock the tables which you will be just referring as READ do your task then unlock. Unlock is automatic if you just close the connection to the dB Hope this helps you. Cheers At 03:15 ßO 02/08/19 -0400, you wrote: Hi List! Hope you can help me with my problem... I am trying to incorporate commit and rollback in my sql statements... I have tried it in my web application which runs on weblogic and it work fine. However, when I migrated my web app to Tomcat, it failed to rollback when it encountered an error. Ive been using the same mysql driver for both. Is there a special configuration I need that is dependent on the server Im running? Other sql statements without the commit and rollback functionality.. works perfectly fine in TOmcat. I wonder what's wrong. I dunno where to address the problem... its it a mysql problem or server config. Thanks in advance. Get your own 800 number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail mysql- [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [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
Count(*) using a join?
I need to do a join with a count...but for some reason I can¹t figure out how to do it using MySQL. I¹m hoping that this pseudo code can help you give me an answer: select f.count(*), s.name from first f, second s where f.id = s.id How do I get a sql result like: CountName --- 12343Test I¹ve attempting adding the group by function as documented, but MySQL has some demands I don¹t understand. Thank you in advance! Mark
Re: Count(*) using a join?
Hi, Try: SELECT f.count(*), s.name FROM first f,second s WHERE f.id = s.id GROUP BY s.name; Regards, Jocelyn - Original Message - From: Mark S Lowe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 3:02 AM Subject: Count(*) using a join? I need to do a join with a count...but for some reason I can¹t figure out how to do it using MySQL. I¹m hoping that this pseudo code can help you give me an answer: select f.count(*), s.name from first f, second s where f.id = s.id How do I get a sql result like: CountName --- 12343Test I¹ve attempting adding the group by function as documented, but MySQL has some demands I don¹t understand. Thank you in advance! Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql 4.0.2 problems
Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My problem is that when I go to connect to it I get the error: error while loading shared libraries: libmysqlclient.so.11: cannot open shared object file: No such file or directory Actually (just fixed it). All I had to do was and a soft link the the /lib directory. Anyone know if this is normal or not? -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.0.2 problems
Add the mysql lib path on /etc/ld.so.conf and type ldconfig. :) = Thanks, Louie Miranda... WebUrl: http://axis0.endofinternet.org Email: [EMAIL PROTECTED] - [EMAIL PROTECTED] - Original Message - From: Nick Stuart [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 12:23 PM Subject: mysql 4.0.2 problems Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My problem is that when I go to connect to it I get the error: error while loading shared libraries: libmysqlclient.so.11: cannot open shared object file: No such file or directory Actually (just fixed it). All I had to do was and a soft link the the /lib directory. Anyone know if this is normal or not? -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
(FROM THE OPEN OFFICE Mailing List) OOo...the Vision thing
On 2002.08.20 01:09 Ruben Safir wrote: Of course. Monty would *love* you to get MySQL officially into OpenOffice, and thereby secure a *huge* automatic userbase for MySQL... I doubt your installbase is a quarter of Monty's, and Monty doesn't need more users Everyone with a FS system uses it. pity that it can't actually do what people will need from here and into the future, let along scale up to department sized loads, etc. It runs Slashdot - Gee how is that. It ran my Medical School Clinic with over 60 million records, read and wrting constantly, out of the box with almost no changes. I ran an industrial plant with it and their labeling system. And if you want to then migrate to a more powerful database server, such as Oracle, DB2, Sybase, Yeah - Oracle is a Dream -- NOT Do you want is small and light or a monster like Oralce which avises a recompile of the kernel for more shared memory segments prior to install expect them to be massively inefficient until you re-write your application. Like one line in DBI, give or take a correction for non-complient SQL in Oracle Good. It's called ODBC, JDBC, etc, same as the rest of us without native drivers at present have. This just scuks. Both those methods are more inefficent than anything else I can think of. ODBC is a complete non-starter. It's FAT, a resource and network hog, inflexible and flatout insecure. Other than that, it's fine. The majority of people who need a database on a website don't need transactions, subselects, an system optimised for scalability, etc. They need a database which does the job for their website. MORE IMPORTANTLY - The zillions of secretaries using ACCESS don't need it. This is called playing both ends against the facts and the truth. As I said, this is NOT open for debate. No MYSQL support and the product is a non-starter. MySQL is *not* going to be packaged along with OOo. There are enough *experienced* DBA's around to be able to explain to you in *depth* Your TALKING to one and you just don't get it. DBA's don't install ACCESS into their practices. It comes preinstalled with the BOX and the secretary makes the decision. YEESH I guess you haven't noticed this trend. -- __ Brooklyn Linux Solutions __ http://www.mrbrklyn.com - Consulting http://www.nylxs.com/radio - Free Software Radio Show and Archives http://www.brooklynonline.com - For the love of Brooklyn http://www.nylxs.com - Leadership Development in Free Software http://www.nyfairuse.org - The foundation of Democracy http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net http://www2.mrbrklyn.com/mp3/dr.mp3 - Imagine my surprise when I saw you... http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn 1-718-382-5752 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- __ Brooklyn Linux Solutions __ http://www.mrbrklyn.com - Consulting http://www.nylxs.com/radio - Free Software Radio Show and Archives http://www.brooklynonline.com - For the love of Brooklyn http://www.nylxs.com - Leadership Development in Free Software http://www.nyfairuse.org - The foundation of Democracy http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net http://www2.mrbrklyn.com/mp3/dr.mp3 - Imagine my surprise when I saw you... http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn 1-718-382-5752 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Transaction Question
Here is an insert from the innodb reference manual Suppose you use a consistent read to read the table PARENT and indeed see the parent of the child in the table. Can you now safely add the child row to table CHILD? No, because it may happen that meanwhile some other user has deleted the parent row from the table PARENT, and you are not aware of that. The solution is to perform the SELECT in a locking mode, LOCK IN SHARE MODE. SELECT * FROM PARENT WHERE NAME = 'Jones' LOCK IN SHARE MODE; Performing a read in share mode means that we read the latest available data, and set a shared mode lock on the rows we read. If the latest data belongs to a yet uncommitted transaction of another user, we will wait until that transaction commits. A shared mode lock prevents others from updating or deleting the row we have read. After we see that the above query returns the parent 'Jones', we can safely add his child to table CHILD, and commit our transaction. This example shows how to implement referential integrity in your application code. This means that if we update a record and have not committed it and another user uses the above select statement, it will wait until the first update statement is committed before reading Thanks Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php