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 ha

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, Jung

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!

"Lost connection to MySQL server during query" when try connect to MySQL

# <= 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 ?

| | 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 a

SET FOREIGN_KEY_CHECKS=0

quot; 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://li

Re: Altering table which has FOREIGN KEY constraints

n 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: &g

Altering table which has FOREIGN KEY constraints

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 -

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, 20

How to build Relay Replication system ?

7;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

How to build Relay Replication system ?

7;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

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 tab

Different Table type between MASTER and SLAVE

w 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

GROUP BY .. HAVING . bug or feature?

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. ###

Strange behavior of CASE .. WHEN ... THEN....

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 archiv

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 constrain

InnoDB Performance Question.

-- 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

Re:Re: Problem on "ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY.."

ROTECTED]> 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 &g

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 CRE

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

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 pr

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-- --

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

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_o

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 |

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" ; +--+ | "

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-- --

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 "

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--