Re: [Maria-developers] GSoC 2018 Student Self Introduction & Question

Hi Shuai! I think you can read MySQL source code, but you can't use any exist code of MySQL. You should use different code even new way to implement the same feature. Thanks, Lixun 2018-03-20 0:06 GMT+08:00 zhzhzoo zhang : > Hello everybody, > > I am a first year graduate

Re: [Maria-developers] GSoC Community Bonding

Hi Becca, Welcome to the MariaDB project! I'm very glad to be your mentor. I hope you can finish the job well, and have fun :-) Thanks, Lixun 2016-05-03 19:18 GMT+08:00 Rebecca Tucker <beccatu...@gmail.com>: > Hi Everyone, > > I am Becca and I will be working with Lixun

Re: [Maria-developers] The compile errors on Linux on Power

this problem: > http://lists.askmonty.org/pipermail/commits/2015-November/008648.html > > Regards, > Segrey > > > On Tue, Dec 01, 2015 at 09:14:55PM +0800, Lixun Peng wrote: > > Hi everyone, > > > > > > Recently I want to test MariaDB 10.1.9 on Linux on Po

[Maria-developers] The compile errors on Linux on Power

Hi everyone, Recently I want to test MariaDB 10.1.9 on Linux on Power8. *But GCC will report following errors:* [ 52%] Building CXX object > storage/innobase/CMakeFiles/innobase.dir/api/api0api.cc.o > In file included from > /root/mariadb-10.1.9/storage/innobase/include/ut0ut.h:36, >

Re: [Maria-developers] MariaDB multi-source replication testing at Booking.com

Hi Karoly, Can you share a 'pstack' result of Multi-Source target when OS/waits is high? And how about your options on my.cnf? In my mind, Multi-Source replication will not effect InnoDB. But if Source_1 and Source_2 will operating the same table, maybe cause some conflict on slave, then slave

Re: [Maria-developers] Flashback Feature patch review

Hi Sergei, Do you have a look this patch? We have used it in production environment. Thanks, Lixun On Sat, Apr 6, 2013 at 9:48 PM, Sergei Golubchik s...@askmonty.org wrote: Hi, Lixun! Great, thanks! I'll look at it as soon as possible. On Apr 06, Lixun Peng wrote: Hi all, I

Re: [Maria-developers] Implementing implicit primary key in mysql server

: CREATE TABLE `test_no_pk` ( `col1` varchar(32) DEFAULT NULL, `id` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 1 row in set (0.00 sec) row_id will be hidden. Thanks, Lixun On Wed, Jun 26, 2013 at 10:59 AM, Lixun Peng pengli...@gmail.com wrote: Hi

Re: [Maria-developers] Implementing implicit primary key in mysql server

DEFAULT CHARSET=utf8 1 row in set (0.00 sec) row_id will be hidden. Thanks, Lixun On Wed, Jun 26, 2013 at 10:59 AM, Lixun Peng pengli...@gmail.commailto: pengli...@gmail.com wrote: Hi Jeremy, Thank you for your suggestion. I also want to just add the PK field

Re: [Maria-developers] Implementing implicit primary key in mysql server

(__id) Regards, Jeremy On Wed, Jun 19, 2013 at 2:40 AM, Lixun Peng pengli...@gmail.com wrote: Hi Sergei, You are right, let users add primary key is best. But I can't let users who don't want to create primary key can't use our MySQL service. Amazon RDS also allow users to create

[Maria-developers] Implementing implicit primary key in mysql server

Hi, As we know, InnoDB has implicit primary key if a table hasn't defined a primary key. However MySQL server doesn't know this primary key, so this primary key will not apear in binlog. When we are using ROW format binlog for replication, if a table has no any indexes, that's a disaster. If a

Re: [Maria-developers] How to copy IO_CACHE into a string?

Hi, Anybody can help me to review it? Thank you! On Mon, Feb 25, 2013 at 2:17 PM, Lixun Peng pengli...@gmail.com wrote: Hi Guys, I want to copy the contents of the IO_CACHE into a string. But I'm not found a function can do it, but I found my_b_copy_to_file can do the similar thing, so I

Re: [Maria-developers] API Documentaion for Replication Features

Hi Monty, On Tue, Dec 25, 2012 at 8:21 PM, Michael Widenius michael.widen...@gmail.com wrote: Hi! Sorry that I missed this email before. cut Lixun I can try to implement it. Are you doing it? Please try to implemement it? You can look at the keycache code how we have done this before!

Re: [Maria-developers] API Documentaion for Replication Features

Hi Gordan, I think you can found the answer from doc : https://kb.askmonty.org/en/multi-source-replication/ like this: set @@default_master_connection=''; show status like 'Slave_running'; set @@default_master_connection='other_connection'; show status like 'Slave_running'; but some

Re: [Maria-developers] API Documentaion for Replication Features

Hi Monty, On Fri, Nov 30, 2012 at 4:01 PM, Michael Widenius mo...@askmonty.orgwrote: Hi! Lixun == Lixun Peng pengli...@gmail.com writes: Lixun Hi Gordan, Lixun I'm not changed the replicate-[do|ignore]-[table|database] functionality Lixun code, so I think it should work for all slave

Re: [Maria-developers] API Documentaion for Replication Features

Hi Gordan, I have tried to replicate from mysql5.5 to MariaDB 10.0 by multi-source replication feature, I have not found any problems, it runs well. Thanks, Lixun Sent from my iPhone On 2012-11-29, at 下午11:38, Gordan Bobic gor...@bobich.net wrote: On 11/29/2012 02:53 PM, Sergei Golubchik

Re: [Maria-developers] API Documentaion for Replication Features

to set them unambiguously in the config file. Any hints? Gordan On 11/29/2012 03:54 PM, Lixun Peng wrote: Hi Gordan, I have tried to replicate from mysql5.5 to MariaDB 10.0 by multi-source replication feature, I have not found any problems, it runs well. Thanks, Lixun Sent from