Re: How to get all known bugs on specified mysql version?

2014-07-06 Thread louis liu
don't use GTID is my suggestion :) 2014-07-07 7:42 GMT+08:00 娄帅 : > Hi, all, > > I want to use MySQL 5.6.18 in production, so i want to get all known bugs > on this version. Now i check the "bugfix" section in MySQL 5.6.19 and above > version. Am i doing the right thing? Or Do you have a better

Re: Multi-master to one slave

2014-02-24 Thread louis liu
you can use mysql transfer or MariaDB for this requirement 2014-02-25 12:03 GMT+08:00 张志刚 : > Does someone have best schema from multi-master to one slave excluding the > circular replication. > -- Phone: +86 1868061 Email & Gtalk: yloui...@gmail.com Personal Blog: http://www.vmcd.org

Re: LIKE sql optimization

2014-02-11 Thread louis liu
MySQL can't use index when '%' condition gives even oracle and you can try full-text search 2014-02-12 9:55 GMT+08:00 kitlenv : > *read how a index works technically* > > > On Wed, Feb 12, 2014 at 12:48 PM, Zhigang Zhang >wrote: > > > I want to know the reason, in my opinion, to scan the

Re: drop partitions

2012-05-14 Thread louis liu
not actually , first partition to have been dropped is no longer in use ,we dropped partition from old -> new 2012/5/14 Johan De Meersman > - Original Message - > > From: "Rick James" > > > > If you have 14 partitions in each of 390 tables, and if you have most > > of the tables '

Re: drop partitions

2012-05-11 Thread louis liu
pen_cache > table_definition_cache > How partitions in this table? How many tables in your system? > > > -Original Message- > > From: louis liu [mailto:yloui...@gmail.com] > > Sent: Friday, May 11, 2012 1:35 AM > > To: mysql@lists.mysql.com > > Subject: drop part

drop partitions

2012-05-11 Thread louis liu
Hi all last night we droped some partitions and we found that the first drop costs about 30mins and then it's about 3 seconds. when droping the partition all processes are shown waiting for opening table like: +-+-+---+---+-+---