mysql repl

2005-07-05 Thread MaFai
,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 349

about replication

2003-06-11 Thread MaFai
oblem?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]

about the MySql tools

2003-06-18 Thread MaFai
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 --

specified function mysql

2003-06-22 Thread MaFai
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 --

Foreign Key Concept

2003-06-24 Thread MaFai
ferences p_program_type(tno) ) TYPE=INNODB; Best regards. MaFai [EMAIL PROTECTED] 2003-06-24 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

about desc command

2003-06-24 Thread MaFai
egards. 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

2003-06-24 Thread MaFai
but in the default 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 unsubscrib

How to drop unique key

2003-06-30 Thread MaFai
e key' in alter 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

about replication concept

2003-07-03 Thread MaFai
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]

Replication Problem

2003-07-27 Thread MaFai
lave status\G *** 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-

When mysql ruinned by Disaster

2003-07-29 Thread MaFai
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/[

Checking the mysql status

2003-08-14 Thread MaFai
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 To

performance with 10 million entries

2005-01-25 Thread MaFai
-+ | count(*) | +--+ | 18733998 | +--+ 1 row in set (2 min 49.60 sec) mysql> select count(*) from WAVE_RECORD where server_name='gz_inc01'; +--+ | count(*) | +--+ | 550421 | +--+ 1 row in set (14 min 47.11 sec) Best regards. MaFai

Re: Re: performance with 10 million entries

2005-01-25 Thread MaFai
n spliting table, hope this help.           At 2005-01-26, 15:32:29 you wrote: on 1/25/05 11:10 PM, MaFai at [EMAIL PROTECTED] wrote:  

Replication Performance

2004-06-30 Thread MaFai
. MaFai [EMAIL PROTECTED] 2004-07-01

Re: RE: Replication Performance

2004-07-02 Thread MaFai
ing logged 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 maste

Upgrade 3.23 to 4.1.x

2004-07-13 Thread MaFai
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 PROT

Re: RE: Upgrade 3.23 to 4.1.x

2004-07-20 Thread MaFai
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

Fw: Confirm 2 question in replication.

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

flush table with read lock

2004-07-26 Thread MaFai
k due to time out? Any idea appreciated. Best regards. MaFai [EMAIL PROTECTED] 2004-07-27

Re: Re: flush table with read lock

2004-07-26 Thread MaFai
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

Fw: Create index hange and crush replication

2004-09-19 Thread MaFai
  Best regards.      MaFai  

Huge Innodb file

2004-09-24 Thread MaFai
55:38 Aborting 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]

If the mysql crash,how can I trace the log

2003-08-27 Thread MaFai
sg.It 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]

Heap table in replication,bug?

2003-11-02 Thread MaFai
ul doesn't 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]

Re: Re: Heap table in replication,bug?

2003-11-03 Thread MaFai
Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 day 5 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-

Slow Query

2003-11-03 Thread MaFai
iated. 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]

Slow query log setting

2003-11-05 Thread MaFai
. 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

Want to monitor the replication of slave

2003-11-09 Thread MaFai
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

Replication A->B->C

2004-05-18 Thread MaFai
r log file existing. Any idea apprecated. Best regards. MaFai [EMAIL PROTECTED] 2004-05-19