mysql repl

,due to the duplicated entry. Do any one try to lock innodb tables to make the snap shot? Since shutdown the master db would take great effect,we don't hope so. Best regards. MaFai [EMAIL PROTECTED] 2005-07-06 34955929

performance with 10 million entries

='gz_inc01'; +--+ | count(*) | +--+ | 550421 | +--+ 1 row in set (14 min 47.11 sec) Best regards. MaFai [EMAIL PROTECTED] 2005-01-26 34955929 -- MySQL General Mailing List For list archives: http

Re: Re: performance with 10 million entries

Fax:313.557.5052 [EMAIL PROTECTED] Novato,CAU.S.A. = = = = = = = = = = = = = = = = = = = = = = Best regards. MaFai [EMAIL PROTECTED] 2005-01-26

Huge Innodb file

Best regards. MaFai [EMAIL PROTECTED] 2004-09-24 34955929 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

flush table with read lock

. Best regards. MaFai [EMAIL PROTECTED] 2004-07-27

Re: Re: flush table with read lock

Dear Paul DuBois: Good,it can use make a hot backup by this lock. or make a snapshot for replication. Thx At 2004-07-27, 10:13:43 you wrote: At 9:52 +0800 7/27/04, MaFai wrote: Dear, [EMAIL PROTECTED], Does flush table with read lock timeout? No, but the lock

Re: RE: Upgrade 3.23 to 4.1.x

Dear Victor Pendleton: It contains both isam innodb tables. At 2004-07-14, 12:29:39 you wrote: What table types are you currently using? -Original Message- From: MaFai To: [EMAIL PROTECTED] Sent: 7/13/04 10:09 PM Subject: Upgrade 3.23 to 4.1.x Dear all: Do any

Fw: Confirm 2 question in replication.

. MaFai [EMAIL PROTECTED] 2004-07-20 = = = = = = = = = = = = = = = = = = = = Best regards. MaFai [EMAIL PROTECTED] 2004-07-20

Upgrade 3.23 to 4.1.x

Dear all: Do any one try to upgrade the mysql from 3.23 to 4.1? In doc,mysql doesn't recommend update the mysql from diff series.Do any one try it successfully? Do I just need to copy the datafile to the new mysql ? Best regards. MaFai [EMAIL PROTECTED

Re: RE: Replication Performance

anywhere? -Original Message- From: MaFai To: [EMAIL PROTECTED] Sent: 6/30/04 10:34 PM Subject: Replication Performance Dear, [EMAIL PROTECTED], We have set up 1 master and 4 slave as replication. Sometime,the slave need 4~10 minutes to synchronize the data with master database

Replication Performance

. MaFai [EMAIL PROTECTED] 2004-07-01

Replication A-B-C

. Any idea apprecated. Best regards. MaFai [EMAIL PROTECTED] 2004-05-19

Want to monitor the replication of slave

Hello, mysql, I want to monitor the replication of slave. chk.sql content: show slave status $mysql -uroot -p chk.sql result But nothing happend. I want to know,how can I monitor the slave mysql. Any idea appreciated. Best regards. MaFai [EMAIL PROTECTED

Slow query log setting

. But there is no log in /var/log/mysqlslow.log,why? any idea appreciated. Mysql Version 4.0.12. Best regards. MaFai [EMAIL PROTECTED] 2003-11-06 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Re: Heap table in replication,bug?

hours 9 min 2 sec Threads: 4 Questions: 1005973 Slow queries: 22 Opens: 102 Flush tables: 1 Open tables: 78 Queries per second avg: 9.586 Thank u in advance === At 2003-11-03, 14:51:00 you wrote: === MaFai [EMAIL PROTECTED] wrote: Hello, mysql, The replication running

Slow Query

. Best regards. MaFai [EMAIL PROTECTED] 2003-11-04 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Heap table in replication,bug?

mention this. Any idea apprecated. Env:Mysql 4.0,Linux Red Hat7,256mb ram. Best regards. MaFai [EMAIL PROTECTED] 2003-11-03 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

If the mysql crash,how can I trace the log

just contains the shutdown start up log. Any idea? Best regards. MaFai [EMAIL PROTECTED] 2003-08-27 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Checking the mysql status

Hello, mysql, I want to write a shell script to check the slave synchronize with master failed or sucessfully. Any idea to implement this? Best regards. MaFai [EMAIL PROTECTED] 2003-08-11 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

When mysql ruinned by Disaster

address would change too.It seems hard to slove this,if I doesn't reset the dns. Any idea would be applicated. Best regards. MaFai [EMAIL PROTECTED] 2003-07-29 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Replication Problem

*** 1. row *** Master_Host: 192.168.80.18 Master_User: mafai Master_Port: 3306 Connect_retry: 60 Master_Log_File: paytv01-bin.012 Read_Master_Log_Pos: 37468899 Relay_Log_File: paytv02-relay-bin.001

about replication concept

for the data in 2 db not sync, if so how to re-synchronize them ? Best regards. MaFai [EMAIL PROTECTED] 2003-07-04 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to drop unique key

command I attempt to type 'alter table p_asset drop index asset_name',but it doesn't functional. alter table p_asset drop unique key( asset_name),obviously it wouldn't take effect. How can I drop the unique in p_asset table? Best regards. MaFai [EMAIL PROTECTED] 2003-06-30 -- MySQL General

about desc command

. MaFai [EMAIL PROTECTED] 2003-06-25 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

datetime column dummy question

value charter,no relative information can be found. I also know this question is stupid,but hope you help. Best regards. MaFai [EMAIL PROTECTED] 2003-06-25 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

specified function mysql

Hello, mysql, I'm just wondering is there a function instead of update to overwrite data that has expired?? Or can mysql automatically deletes records or rows that has expires just like cookies delete themselves after expiring. Best regards. MaFai [EMAIL PROTECTED] 2003-06-23 -- MySQL

about the MySql tools

Hello, mysql, Do any sql tools support MySql like Oracle (PL/SQL) Development Tools ? Oracle (PL/SQL) Development Tools is really imporve the efficient of development,but it doesn't support MySql. Do any other tools instead of it? Best regards. MaFai [EMAIL PROTECTED] 2003-06-18 -- MySQL

about replication

?Any idea appreciate. Best regards. MaFai [EMAIL PROTECTED] 2003-06-12 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]