RE: index collate

Got it; Thanks! Zhigang -Original Message- From: Hartmut Holzgraefe [mailto:hart...@skysql.com] Sent: Thursday, September 11, 2014 1:44 PM To: mysql@lists.mysql.com Subject: Re: index collate On 09/11/2014 05:55 AM, Zhigang Zhang wrote: > The “CREATE INDEX Syntax” can not assig

index collate

I have a question. The “CREATE INDEX Syntax” can not assign a collation. What collation to use to create a index on a column? Thanks Zhigang.

Exec_Master_Log_Pos is smaller than it's correct value

Same as this bug report: http://bugs.mysql.com/bug.php?id=25713 Please tell me why? Regards Zhigang _ From: Zhigang Zhang [mailto:zzgang2...@gmail.com] Sent: Tuesday, March 18, 2014 4:04 PM To: 'mysql@lists.mysql.com' Subject: Exec_Master_Log_Pos is smaller

Exec_Master_Log_Pos is smaller than it's correct value

Hi I have a simple replication service, “show slave status” shows that the Exec_Master_Log_Pos is smaller than it’s correct value occasionally, why? Mysql version: 5.1.53 Regards, Zhigang

RE: How to make multiple master to single slave in mysql?

OK! Thank you very much! Zhigang. -Original Message- From: shawn l.green [mailto:shawn.l.gr...@oracle.com] Sent: Wednesday, February 26, 2014 11:57 AM To: mysql@lists.mysql.com Subject: Re: How to make multiple master to single slave in mysql? On 2/25/2014 9:55 PM, Zhigang Zhang

How to make multiple master to single slave in mysql?

How to make multiple master replicate to single slave in mysql? Tell me some approaches? Thanks Zhigang

Multi-master to one slave schema

Does someone have some schemas from multi-master to one slave excluding the circular replication. Please tell me. Thanks. Zhigang

Multi-master to one slave

Does someone have some schemas from multi-master to one slave excluding the circular replication. Please tell me. Thanks. Zhigang

Multi-master to one slave

Does someone have some schemas from multi-master to one slave excluding the circular replication. Please tell me. Thanks. Zhigang

Multi-master to one slave

Does someone have the best schema from multi-master to one slave excluding the circular replication. Please tell me. Thanks. Zhigang

RE: LIKE sql optimization

Done. Thand you very much! Zhigang _ From: Jesper Wisborg Krogh [mailto:my...@wisborg.dk] Sent: Wednesday, February 12, 2014 5:30 PM To: Morgan Tocker; Zhigang Zhang Cc: mysql@lists.mysql.com Subject: Re: LIKE sql optimization On 12/02/2014 13:16, Morgan Tocker wrote: Hi

RE: LIKE sql optimization

Thank you very much! Zhigang -Original Message- From: Morgan Tocker [mailto:morgan.toc...@oracle.com] Sent: Wednesday, February 12, 2014 10:16 AM To: Zhigang Zhang Cc: mysql@lists.mysql.com Subject: Re: LIKE sql optimization Hi Zhigang, On Feb 11, 2014, at 8:48 PM

RE: LIKE sql optimization

is not just a dumb copy of the whole field and you simply can't seek in the middle of it? http://en.wikipedia.org/wiki/B-tree http://mattfleming.com/node/192 Am 12.02.2014 02:48, schrieb Zhigang Zhang: > I want to know the reason, in my opinion, to scan the smaller index

RE: LIKE sql optimization

I want to know the reason, in my opinion, to scan the smaller index data has better performance than to scan the whole table data. zhigang _ From: Mathieu Desharnais [mailto:mdesharn...@diffusion.cc] Sent: Wednesday, February 12, 2014 9:41 AM To: Zhigang Zhang; mysql

LIKE sql optimization

For example: Select * from T where col like ‘%abcd’; The table T is myisam table and we created a index on col. As we known, this like sql does not use the index created on col, it confuse me, why? I think in mysiam engine, the index data is smaller, it can use index link list to op

RE: Query Plan Analyzer

By experience! -Original Message- From: Cabbar Duzayak [mailto:cab...@gmail.com] Sent: Thursday, November 22, 2012 3:13 PM To: mysql@lists.mysql.com Subject: Query Plan Analyzer Hi All, Is there a way of looking at how mysql builds the query plan and executes it for a given query? EXPLA

RE: About character_set_*

to:rja...@yahoo-inc.com] Sent: Wednesday, August 08, 2012 2:55 AM To: Zhigang Zhang; mysql@lists.mysql.com Subject: RE: About character_set_* The answer is long and involved... http://mysql.rjweb.org/doc.php/charcoll > -----Original Message- > From: Zhigang Zhang [mailto:zzgang2...@gmail.c

About character_set_*

Hello. As I know, when client send data to server, the encoding converting process is: character_set_client --> character_set_connection --> db table encoding. I think it is a short path than above way: character_set_client --> db table encoding. Why it is converted to "char

RE: How often the slave to pull data from master?

Hi > If there are additional events beyond that, it retrieves those in sequence after it writes the current statement into the relay logs. I have a question about this: Whether the slave is sent a signal whenever the master generates each event? -Original Message- From: Shawn Green

how often the slave to pull data from master?

hanks! Zhigang Zhang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

How often the slave to pull data from master?

aster? Thanks! Zhigang Zhang

hi all

Dear: A open source development community for unix-like systems. http://dev.unix-like.net Thanks.