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

2014-07-07 Thread louis liu
don't use GTID is my suggestion :) 2014-07-07 7:42 GMT+08:00 娄帅 louis.hust...@gmail.com: 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

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 张志刚 zzgang2...@gmail.com: 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:

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 kitl...@gmail.com: *read how a index works technically* On Wed, Feb 12, 2014 at 12:48 PM, Zhigang Zhang zzgang2...@gmail.com wrote: I want to know 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 vegiv...@tuxera.be - Original Message - From: Rick James rja...@yahoo-inc.com If you have 14 partitions in each of 390 tables, and if you

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:

Re: drop partitions

2012-05-11 Thread louis liu
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 partitions Hi all last night we droped