connection time is slow
[Could not convert from 'ks_c_5601-1987'] Hello. I'm using MySQL 4.1.2 on Linux(Fedora Core 2) and Window 2003 Server. When connect from Linux to Windows, or from Window to Linux connection time is very slow. ( it takes about 6 seconds) But Linux to Linux or Windows to Windows Fast. Anybody has an Idea? Thank you for advanced answer! == (ÁÖ)À¯ºñÄõÅͽº Æйи® °³¹ßÆÀ Çã Á¤ ¼ö ÁÖÀÓ email : [EMAIL PROTECTED] tel : 02-798-6822 fax : 02-749-9632 Web : http://www.ufamily.co.kr ¼¿ï½Ã ¿ë»ê±¸ ³²¿µµ¿ 104 û¼Ûºôµù 3Ãþ == ¿ï ÂÄ, ¿ï ¾¥ We win! This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain private, confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, employee or agent responsible for delivering this message, please contact the sender by reply e-mail and destroy all copies of the original e-mail message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
connection time is slow
Hello. I'm using MySQL 4.1.2 on Linux(Fedora Core 2) and Window 2003 Server. When connect from Linux to Windows, or from Window to Linux connection time is very slow. ( it takes about 6 seconds) But Linux to Linux or Windows to Windows Fast. Anybody has an Idea? Thank you for advanced answer! == () email : [EMAIL PROTECTED] tel : 02-798-6822 fax : 02-749-9632 Web : http://www.ufamily.co.kr 104 3 == , We win!
Re: connection time is slow
Hello. Sorry for lack of information. Any client applications or programming langueges do like that. PHP mysql_connect() function , MySQL's mysql command tool, etc. - Original Message - From: Frederick R. Doncillo [EMAIL PROTECTED] To: Heo, Jungsu [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 29, 2004 11:14 AM Subject: Re: connection time is slow Hello Jungsu, What are the tools you're using to connect? Any client applications? Fred. Heo, Jungsu wrote: Hello. I'm using MySQL 4.1.2 on Linux(Fedora Core 2) and Window 2003 Server. When connect from Linux to Windows, or from Window to Linux connection time is very slow. ( it takes about 6 seconds) But Linux to Linux or Windows to Windows Fast. Anybody has an Idea? Thank you for advanced answer! == () email : [EMAIL PROTECTED] tel : 02-798-6822 fax : 02-749-9632 Web : http://www.ufamily.co.kr 104 3 == , We win! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lost connection to MySQL server during query when try connect to MySQL
Hello, I got Lost connection to MySQL server during query from time to time when connecting to MySQL server. Using following PHP code, $this - conn = mysql_connect( $host, $c_user, $c_passwd) ; if( $this - conn == 0 ) raise_error( __FILE__, __LINE__, Can't connect2db : $host ) ; = trigger error and exit Thank you for advanced answer! ### = Some information on my system = MySQL Version : 4.0.15a OS : Redhat 9.0 glibC : glibc-2.3.2-27.9 mysql show variables like '%packet%' ; ++-+ | Variable_name | Value | ++-+ | max_allowed_packet | 1048576 | = it is just 1 Mb, but error occurs on connection. ++-+ $ uname -a Linux *..com 2.4.20-18.9 #1 Thu May 29 07:08:16 EDT 2003 i686 i686 i386 GNU/Linux /etc/my.cnf ## # [mysqld]# # log-slow-queries # # # # default-table-type=innodb# # set-variable = innodb_buffer_pool_size=200M# # set-variable = long_query_time=1 # = is this matter? Is this too short? ## ## Heo, Jungsu Mr. SimpleX Internet. http://www.simplexi.com Filter : sql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can I enlarge user table's User field ?
Hello there! mysql show columns from user like 'User' ; +---++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---++--+-+-+---+ | User | varchar(16) binary | | PRI | | | +---++--+-+-+---+ 1 row in set (0.00 sec) Can User field be VARCHAR(50) ? Thank you! ## Heo, Jungsu Mr. SimpleX Internet. http://www.simplexi.com Filter : sql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SET FOREIGN_KEY_CHECKS=0
Hello, Heikki! In my last suggestion, you replied : Jungsu, Jeremy, it can be considered as a bug that MySQL/InnoDB does not replicate the setting SET FOREIGN_KEY_CHECKS=0 I am working on fixing this bug in 4.0.x. (I suggested it MySQL 4.0.11.) but, set foreign_key_checks=0 still does not replicated in MySQL 4.0.12. When will it be fixed? Thank you ! ## Heo, Jungsu Mr. SimpleX Internet. http://www.simplexi.com Filter : sql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Altering table which has FOREIGN KEY constraints
Reznichenko, Thank you for your answer! What do you mean could not execute a query on those tables? Could you be more detailed? Ok. let me explain. When I was using MySQL 4.0.10, After I add columns with ALTER TABLE on foreign key referencing table so many times, when I execute SELECT * FROM child, MySQL session is deaded with Seg. fault. even if I execute drop table child. so I rebuilded entire InnoDB Table with back-up data. I don't have error log and test-bed at this time. I wanna know that this problem is fixed in MySQL 4.0.11. - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 10, 2003 10:32 PM Subject: re: Altering table which has FOREIGN KEY constraints On Saturday 08 March 2003 09:09, Heo Jungsu wrote: I have a question about altering table which has foreign key constraints. MySQL manual says that : In InnoDB versions 3.23.50 ALTER TABLE or CREATE INDEX should not be used in connection with tables which have foreign key constraints or which are referenced in foreign key constraints: .. (omitted) .. A CREATE INDEX statement is in MySQL processed as an ALTER TABLE, and these restrictions apply also to it. on http://www.mysql.com/doc/en/SEC457.html But, how abount InnoDB versions = 3.23.50? Version 4.0.11 still cannot alter referencing table and referenced table? It can and MySQL doesn't remove foreign key constraint. What's the safe query in below lits (MySQL 4.0.11) ? * alter referencing table * alter referenced table * create index on referencing table * create index on referenced table. They are all safe ... When I have used MySQL 4.0.10 If I alter referencing and referenced table several times, sometimes I could not execute a query on those tables even drop table (So I rebuilded entire InnoDB ;-( ) What do you mean could not execute a query on those tables? Could you be more detailed? -- 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
Altering table which has FOREIGN KEY constraints
Hello, there. I have a question about altering table which has foreign key constraints. MySQL manual says that : In InnoDB versions 3.23.50 ALTER TABLE or CREATE INDEX should not be used in connection with tables which have foreign key constraints or which are referenced in foreign key constraints: .. (omitted) .. A CREATE INDEX statement is in MySQL processed as an ALTER TABLE, and these restrictions apply also to it. on http://www.mysql.com/doc/en/SEC457.html But, how abount InnoDB versions = 3.23.50? Version 4.0.11 still cannot alter referencing table and referenced table? What's the safe query in below lits (MySQL 4.0.11) ? * alter referencing table * alter referenced table * create index on referencing table * create index on referenced table. When I have used MySQL 4.0.10 If I alter referencing and referenced table several times, sometimes I could not execute a query on those tables even drop table (So I rebuilded entire InnoDB ;-( ) Thank you for advanced answer! ## Heo, Jungsu Mr. SimpleX Internet. http://www.simplexi.com Filter : sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: foreign keys across databases?
You can do this. E.g.: FOREIGN KEY (parent_id) REFERENCES databasename.parent(id) and I'm already using this kind of foreign key. Try yourself ! - Original Message - From: Tor R. Skoglund (NextG) [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Sent: Monday, February 24, 2003 4:59 AM Subject: foreign keys across databases? This might be a stupid question, but is it possible to have a foreign key reference to a table.column in another database? E.g.: FOREIGN KEY (parent_id) REFERENCES databasename.parent(id) Probably not, but are there any other ways to enforce such relations? Best regards Tor Rune Skoglund [EMAIL PROTECTED] sql,query,queries,smallint - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 build Relay Replication system ?
Hello! I have a following system. Server A : a master for server B. MySQL 4.0.9 Server B : a slave for server A, a master for server C. MySQL 4.0.10 Server C : a slave for server B. MySQL 4.0.10 and I wanna that if update occurs on A, it forwarded to B and B forward it to C But I don't know how to. I had setted up all necessary options. Replication A-B works well. Replication B-C works well too. but A's update queries is not forwarded to C. I think the problem is that C does not read Relay log of B. so, I execute command SLAVE START SQL_THREAD on C. but A's update query does not relay to C. I found Relay_Master_Log_File in C's 'SHOW SLAVE STATUS' does not match Relay_Log_File in B's 'SHOW SLAVE STATUS' Here are some Replication related status. # Server A ( Master for B ) # mysql SHOW MASTER STATUS ; +---+--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +---+--+--+--+ | localhost-bin.001 | 1522 | repli_test | | +---+--+--+--+ # Server B ( Slave for A, Master for C ) # mysql SHOW SLAVE STATUS \G *** 1. row *** Master_Host: 203.xx.xx.147 Master_User: repl Master_Port: 3306 Connect_retry: 10 Master_Log_File: localhost-bin.001 Read_Master_Log_Pos: 1522 Relay_Log_File: test42-relay-bin.003 = ?? Relay_Log_Pos: 146 Relay_Master_Log_File: localhost-bin.001 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_do_db: Replicate_ignore_db: Last_errno: 0 Last_error: Skip_counter: 0 Exec_master_log_pos: 1522 Relay_log_space: 150 mysql SHOW MASTER STATUS ; ++--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | ++--+--+--+ | test42-bin.002 | 207 | repli_test | | ++--+--+--+ # C ( Slave for B ) # mysql SHOW SLAVE STATUS \G *** 1. row *** Master_Host: 203.xx.xx.42 Master_User: repl Master_Port: 3306 Connect_retry: 10 Master_Log_File: test42-bin.002 Read_Master_Log_Pos: 207 Relay_Log_File: localhost-relay-bin.002 Relay_Log_Pos: 383 Relay_Master_Log_File: test42-bin.002 = should be 'test42-relay-bin.003' ? Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_do_db: Replicate_ignore_db: Last_errno: 0 Last_error: Skip_counter: 0 Exec_master_log_pos: 207 Relay_log_space: 387 # end thank you for read ! Any suggestion will please me. ## Heo, Jungsu Mr. SimpleX Internet. http://www.simplexi.com Filter : sql - Before posting, please check: http://www.mysql.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-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: locking tables , mysql 3.23.41
hello. You can read lock whole database's tables like this : FLUSH TABLES WITH READ LOCK ; and unlock with UNLOCK TABLES ; - Original Message - From: Franz, Fa. PostDirekt MA [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 10:35 PM Subject: locking tables , mysql 3.23.41 Dear Ladies and Gentlemen, in order to backup databases or better the whole server file-based , I'd like to know , if there is a way to get a read-Lock for all tables in a database or even better for all tables in all databases. Something like: LOCK TABLES db_name.% READ; which I tried cause I'm fooolish but it didn't work :o) If not , is there a nice tool (best would be command-line) to do a full online-backup of all data on a server. Linux 2.4.10 , mysql 3.23.41 If I missed anything in the docs , just tell me where , please. Klaus Topaktuelle Consumer-Adressen anmieten www.consumeradressen.de Diese Mail ist von: Deutsche Post Direkt GmbH Beleglese Center Mannheim Klaus Franz Manager Abgleichsysteme Willy-Brandt-Platz 13 Tel. 06 21.129 56 436 68161 Mannheim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 build Relay Replication system ?
Hello! I have a following system. Server A : a master for server B. MySQL 4.0.9 Server B : a slave for server A, a master for server C. MySQL 4.0.10 Server C : a slave for server B. MySQL 4.0.10 and I wanna that if update occurs on A, it forwarded to B and B forward it to C But I don't know how to. I had setted up all necessary options. Replication A-B works well. Replication B-C works well too. but A's update queries is not forwarded to C. I think the problem is that C does not read Relay log of B. so, I execute command SLAVE START SQL_THREAD on C. but A's update query does not relay to C. I found Relay_Master_Log_File in C's 'SHOW SLAVE STATUS' does not match Relay_Log_File in B's 'SHOW SLAVE STATUS' Here are some Replication related status. # Server A ( Master for B ) # mysql SHOW MASTER STATUS ; +---+--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +---+--+--+--+ | localhost-bin.001 | 1522 | repli_test | | +---+--+--+--+ # Server B ( Slave for A, Master for C ) # mysql SHOW SLAVE STATUS \G *** 1. row *** Master_Host: 203.xx.xx.147 Master_User: repl Master_Port: 3306 Connect_retry: 10 Master_Log_File: localhost-bin.001 Read_Master_Log_Pos: 1522 Relay_Log_File: test42-relay-bin.003 = ?? Relay_Log_Pos: 146 Relay_Master_Log_File: localhost-bin.001 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_do_db: Replicate_ignore_db: Last_errno: 0 Last_error: Skip_counter: 0 Exec_master_log_pos: 1522 Relay_log_space: 150 mysql SHOW MASTER STATUS ; ++--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | ++--+--+--+ | test42-bin.002 | 207 | repli_test | | ++--+--+--+ # C ( Slave for B ) # mysql SHOW SLAVE STATUS \G *** 1. row *** Master_Host: 203.xx.xx.42 Master_User: repl Master_Port: 3306 Connect_retry: 10 Master_Log_File: test42-bin.002 Read_Master_Log_Pos: 207 Relay_Log_File: localhost-relay-bin.002 Relay_Log_Pos: 383 Relay_Master_Log_File: test42-bin.002 = should be 'test42-relay-bin.003' ? Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_do_db: Replicate_ignore_db: Last_errno: 0 Last_error: Skip_counter: 0 Exec_master_log_pos: 207 Relay_log_space: 387 # end thank you for read ! Any suggestion will please me. ## Heo, Jungsu Mr. SimpleX Internet. http://www.simplexi.com Filter : sql - Before posting, please check: http://www.mysql.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-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Different Table type between MASTER and SLAVE
Hello. I'm build a system aka of Shopping mall.(I think most of queies will be SELECT) For performance, MySQL will run on replication. I need TRANSACTIONs to manages orders and payment. So, Master's Table type is InnoDB. But I think that InnoDB is slower than MyISAM. (InnoDB's row level locking is very good. but, My system will query SELECT most cases) So, I decide that Master's table uses InnoDB Slave's table uses MyISAM. This has any problem? Any sugesstion will please me. Thank you for advanced answer! ## Heo, Jungsu Mr. SimpleX Internet. http://www.simplexi.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GROUP BY .. HAVING . bug or feature?
Hello. I have a following table. mysql SELECT * FROM group_test ; +--+--+--+ | a| b| c| +--+--+--+ |1 |1 |1 | |1 |1 |1 | |1 |1 |1 | |2 |2 |2 | |2 |2 |2 | |3 |3 |3 | +--+--+--+ 6 rows in set (0.00 sec) mysql SELECt a, COUNT(*) FROM group_test - GROUP BY a, b ; +--+--+ | a| COUNT(*) | +--+--+ |1 |3 | |2 |2 | |3 |1 | +--+--+ 3 rows in set (0.00 sec) But, when I use HAVING and IN() togather, MySQL returns no rows. mysql SELECt a, COUNT(*) FROM group_test - GROUP BY a, b - HAVING COUNT(*) IN ( 1, 2, 3 ) ; Empty set (0.00 sec) Other relational operators works well. I'm using MySQL 4.0.3 Thank you for advanced answer!. Have a nice weekend. ## Heo, Jungsu Mr. SimpleX Internet. http://www.simplexi.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange behavior of CASE .. WHEN ... THEN....
Hello, every one. I Found a bug about CASE .. WHEN .. THEN.. mysql SELECT VERSION() ; ++ | VERSION() | ++ | 4.0.3-beta | ++ 1 row in set (0.00 sec) mysql select CASE NULL WHEN NULL THEN 0 ELSE 1 END AS RESULT ; ++ | RESULT | ++ | 1 | ++ 1 row in set (0.00 sec) I think RESULT should be '0'. Am I wrong? IF() works finely. mysql SELECT IF( NULL IS NULL, 0 , 1 ) AS RESULT ; ++ | RESULT | ++ | 0 | ++ 1 row in set (0.00 sec) Is this a bug or a mistake of mine? Thanks! sql. ## Heo, Jungsu Mr. SimpleX Internet. http://www.simplexi.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: drop constraint in innodb
Last week, I posted a message related to this. Heikki (InnoDB Developer) said sorry, DROP CONSTRAINT is not implemented yet. - Original Message - From: kayamboo [EMAIL PROTECTED] To: list mysql [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 2:45 PM Subject: drop constraint in innodb sql, query Hi Folks ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES Syoyu_db( Code, Kana) ON DELETE CASCADE ; works fine. But how to drop the constraint or modify the constraint ? Simply changing ADD to DROP or MODIFY throws errors regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Performance Question.
Hello everyone.
I'm working on migrating Oracle to MySQL 4.0.3
MySQL works on Redhat 7.3 and Pentium 550Mhz with 256 Mb RAM.
Our application need Transactions, so I decided to use InnoDB.
But, InnoDB is slower than I expected.
-
mysql SELECT COUNT(*) FROM table_name ;
+--+
| COUNT(*) |
+--+
| 903097 |
+--+
1 row in set (8.07 sec)
-
8.07 sec. took to retrieve 903,097 rows. That's OK, faster than Oracle.
But, LIMITing records make problem.
-
mysql SELECT * FROM table_name LIMIT 10, 10 ;
..
..
10 rows in set (3.95 sec)
--
This result is normal one? Is there any way to improve perfermance?
I thought one way.
--
ROW = SELECT Primary key FROM table_name LIMIT 10, 10;
WHILE( ! no_more_row )
{
Fetch record WHERE Primary key = ROW.Primary key ;
}
--
This can help?
In Oracle
---
SQL SELECT A.* FROM ( SELECT rownum as rnum, B.* FROM table_name B ) A
2 where rnum = 10 and rownum = 10 ;
Elapsed: 00:00:01.20
Just 1.20 Sec. took.
Thank you for advanced Answer!
##
Heo, Jungsu Mr.
SimpleX Internet. http://www.simplexi.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:Re: Problem on ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY..
Hello, Heikki. Thank you very much for your reply!. I Found the problem. If I give FK name explicitly, ALTER TABLE FOREIGN KEY .. dose not works. Example 1 - give FK name explictly # mysql alter table CONS_CHILD ADD constraint foreign key CONS_CHILD_FK - ( A, B ) REFERENCES CONS_PARENT(A, B ) ; Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql show create table CONS_CHILD ; ++-- -+ | Table | Create Table | ++-- -+ | CONS_CHILD | CREATE TABLE `CONS_CHILD` ( `A` int(11) NOT NULL default '0', `B` int(11) NOT NULL default '0', KEY `A` (`A`,`B`) ) TYPE=InnoDB | ++-- -+ 1 row in set (0.00 sec) # Example 2 - do not give FK name # mysql alter table CONS_CHILD ADD constraint foreign key - ( A, B ) REFERENCES CONS_PARENT(A, B ) ; Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql show create table CONS_CHILD ; ++-- -+ | Table | Create Table | ++-- -+ | CONS_CHILD | CREATE TABLE `CONS_CHILD` ( `A` int(11) NOT NULL default '0', `B` int(11) NOT NULL default '0', KEY `A` (`A`,`B`), FOREIGN KEY (`A`, `B`) REFERENCES `scott.CONS_PARENT` (`A`, `B`) ) TYPE=InnoDB | ++-- -+ 1 row in set (0.00 sec) Another question. Is there any way to drop FK without DROP TABLE? i.e., is there ALTER TABLE .. DROP CONSTRAINT FOREIGN KEY..? Thanky for your advanced answer! - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 29, 2002 10:24 PM Subject: Re: Problem on ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY.. Jungsu, - Original Message - From: Heo, Jungsu [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, September 28, 2002 9:34 AM Subject: Problem on ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY.. Hello. I have a problem on ALTER TABLE ... ADD FOREIGN KEY. I'm using InnoDBs, and I wanna create Foreign Key after table has been created. But, 'ALTER TABLE .. ADD FOREIGN KEY does not work. Manual says : The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do anything And in my test, 'ALTER ADD FOREIGN KEY' does not create FK. mysql CREATE TABLE `CONS_PARENT` ( - `A` int(11) NOT NULL default '0', - `B` int(11) NOT NULL default '0', - UNIQUE KEY `A` (`A`,`B`) ) Type=InnoDB ; Query OK, 0 rows affected (0.02 sec) mysql CREATE TABLE `CONS_CHILD` ( - `A` int(11) NOT NULL default '0', - `B` int(11) NOT NULL default '0', - KEY `A` (`A`,`B`) - ) TYPE=InnoDB ; Query OK, 0 rows affected (0.05 sec) mysql ALTER TABLE CONS_CHILD ADD CONSTRAINT FOREIGN KEY CONS_CHILD_FK ( A , B ) REFERENCES CONS_PARENT ON DELETE CASCADE ; Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 # See Below! FK does not EXIST mysql SHOW CREATE TABLE CONS_CHILD ; ++-- -+ | Table | Create Table | ++-- -+ | CONS_CHILD | CREATE TABLE `CONS_CHILD` ( `A` int(11) NOT NULL default '0', `B` int(11) NOT NULL default '0', KEY `A` (`A`,`B`) ) TYPE=InnoDB | ++-- -+ 1 row in set (0.00 sec) the problem above is that the syntax of the ALTER TABLE is wrong for InnoDB. InnoDB uses the syntax of SQL-1992 with the restriction that InnoDB always requires that also the columns in the referenced table are always explicitly named. No name can be given to the foreign key
Problem on ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY..
Hello. I have a problem on ALTER TABLE ... ADD FOREIGN KEY. I'm using InnoDBs, and I wanna create Foreign Key after table has been created. But, 'ALTER TABLE .. ADD FOREIGN KEY does not work. Manual says : The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do anything And in my test, 'ALTER ADD FOREIGN KEY' does not create FK. mysql CREATE TABLE `CONS_PARENT` ( - `A` int(11) NOT NULL default '0', - `B` int(11) NOT NULL default '0', - UNIQUE KEY `A` (`A`,`B`) ) Type=InnoDB ; Query OK, 0 rows affected (0.02 sec) mysql CREATE TABLE `CONS_CHILD` ( - `A` int(11) NOT NULL default '0', - `B` int(11) NOT NULL default '0', - KEY `A` (`A`,`B`) - ) TYPE=InnoDB ; Query OK, 0 rows affected (0.05 sec) mysql ALTER TABLE CONS_CHILD ADD CONSTRAINT FOREIGN KEY CONS_CHILD_FK ( A , B ) REFERENCES CONS_PARENT ON DELETE CASCADE ; Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 # See Below! FK does not EXIST mysql SHOW CREATE TABLE CONS_CHILD ; ++-- -+ | Table | Create Table | ++-- -+ | CONS_CHILD | CREATE TABLE `CONS_CHILD` ( `A` int(11) NOT NULL default '0', `B` int(11) NOT NULL default '0', KEY `A` (`A`,`B`) ) TYPE=InnoDB | ++-- -+ 1 row in set (0.00 sec) Does any body know how can create FK after tables creates? Thank you. Have a nice weekend! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question again(Problem on ALTER TABLE .. ADD CONSTRAINT FOREIGN KEY...
Sorry, I missed PARENT's COLUMNs. Corrects. ALTER TABLE CONS_CHILD ADD FOREIGN KEY CONS_CHILD_FK ( A , B ) REFERENCES CONS_PARENT(A, B ) on delete cascade ; Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql SHOW CREATE TABLE CONS_CHILD ; ++-- -+ | Table | Create Table | ++-- -+ | CONS_CHILD | CREATE TABLE `CONS_CHILD` ( `A` int(11) NOT NULL default '0', `B` int(11) NOT NULL default '0', UNIQUE KEY `aa` (`A`,`B`) ) TYPE=InnoDB | ++-- -+ 1 row in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SSH tunnel MySQL traffic..
Hi~ I have trouble with ssh tunneling. I run this command as you told. [wertyu@inos ~]$ ssh -L 12345:localhost:3306 localhost Secure connection to localhost refused; reverting to insecure method. Using rsh. WARNING: Connection will not be encrypted. localhost: Connection refused what's the problem? should I run sshd deamon? if then, how to configure sshd deamon? Thank you for advanced answer! ps. I installed MySQL 4.0 SSL connection support. But I cannot find any MySQL Client which support SSL connection. although MySQL 4.0 support SSL connection, still ssh tunneling required? Thank you! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.
Why don't you try like this. F:\\devkunde\\SENDTNER\\ '\' is escape character. so you must use '\\' to insert '\'. Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SSL connection question Again!
Happy New Year! I'm Sorry if this question has been posted often. but i cannot find answer. I have installed openssl and MySQL 4.0.1 with --with-openssl --with-vio And... mysql SHOW VARIABLES LIKE '%ssl%' ; +---+---+ | Variable_name | Value | +---+---+ | have_openssl | YES | +---+---+ 1 row in set (0.10 sec) and I granted somebody with REQUIRE SSL. But He cannot connect to MySQL using mysql . mysql client does not support SSL connection? How can he/she connect to MySQL with SSL? about PHP and MySQL? I'm very pleased if give me any Information ! Thank you for advanced Answer! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Embedded MySQL terminate abnormally.
I installed Embedded MySQL( compiled --with-embedded-server) And I compiled source code from Manual. (I did not modify the source) compiled nicly, but I run the Embedded MySQL, Segmentation fault occured [wertyu@inos prog]$ ls Makefile mysqld* mysqld.c mysqld.c~ [wertyu@inos prog]$ ./mysqld Segmentation fault [wertyu@inos prog]$ here is output from GDB Program received signal SIGSEGV, Segmentation fault. 0x8051984 in vio_read () (gdb) bt #0 0x8051984 in vio_read () #1 0x807357d in net_clear () #2 0x804857f in simple_command () #3 0x80494f0 in mysql_close () #4 0x80481e8 in main (argc=1, argv=0xb594) at mysqld.c:54 #5 0x8230a51 in __libc_start_main (main=0x80481a0 main, argc=1, argv=0xb594, init=0x80480b4 _init, fini=0x82782d0 _fini, rtld_fini=0, stack_end=0xb58c) at ../sysdeps/generic/libc-start.c:78 (gdb) gcc version = 2.91.66 OS version = Redhat 6.0 Thank you for advanced answer! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SSL connection question.
I'm Sorry if this question has been posted often. but i cannot find answer. I have installed openssl and MySQL 4.0.1 with --with-openssl --with-vio And... mysql SHOW VARIABLES LIKE '%ssl%' ; +---+---+ | Variable_name | Value | +---+---+ | have_openssl | YES | +---+---+ 1 row in set (0.10 sec) and I granted somebody with REQUIRE SSL. But He cannot connect to MySQL using mysql . mysql client does not support SSL connection? How can he/she connect to MySQL with SSL? about PHP and MySQL? I'm very pleased if give me any Information ! Thank you for advanced Answer! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 : String comparison.
You should use binary attribute. mysql select binary fff= fff ; +-+ | binary fff= fff | +-+ | 0 | +-+ 1 row in set (0.28 sec) mysql select fff= fff ; +--+ | fff= fff | +--+ |1 | +--+ 1 row in set (0.00 sec) mysql select version() ; +---+ | version() | +---+ | 3.23.46 | +---+ 1 row in set (0.00 sec) when you create table... create table table_name ( a char(10) binary ... ) ; you can check white characters. Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
When will Stable version 4.0 be released ?
Hi! I'll be happy if I know that when Stable version 4.0 will be released. Thanks! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Some questions About DBMS.
(I'm sorry if my question does not fit to this mailing list) Hi~ there.! Is there A Book about implementing RDBMS? I just found Database System Implementation written by Ullman. looking for another Book if there is. Monty, What's the Best Resource(helping you) when you have started making MySQL? Umm. MySQL AB Has any plan to make MMDB or Embedded DBMS? (Last month's survey asked us 'bout Embedded DBMS) Thank you for Avanced Answer! Member OF http://database.sarang.net http://www.nnr.or.kr --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
unaunthenticated user?
Hi~~~ My SHOW PROCESSLIST's output | 22 | unauthenticated user | 10.169.xxx.xxx || Connect | | login | what 'unauthenticated user' means? who is he? anonymous user? Thank you for your advanced answer! database --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
