building mysql 5.5.8 with default charset

Hello, is it a bug or a feature that if building mysql 5.5.8 from source with the options 'cmake . -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci' the charset in include/config.h remains latin1: #define MYSQL_DEFAULT_CHARSET_NAME "latin1" #define MYSQL_DEFAULT_COLLATION_NAME "latin

Re: MySQL restore failing

Hi, I think you didn't run mysql_upgrade script. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 2010/12/3 Shawn Green (MySQL) > On 12/3/2010 03:40, Machiel Richards wrote: > >

Re: MySql - crashes daily

Hi. Can you show me some of your critical system logs? David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 2010/12/7 Raj Shekhar > In infinite wisdom Basil Daoust wrote: > > >

Re: Negative connection/thread IDs in mysqld.log?

Hi, The negative IDs is fine. You should read the document for the data type section, especially INT. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 2010/12/15 Atle Veka

Re: Discontinued AUTO_INCREMENT problem....

Hi. This is a good point for this issue. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 2010/12/21 partha sarathy > Hi, > > There is one variable called innodb_autoinc_lock

Re: Trigger?

I think if you built a trigger to update value of foo's column after, this trigger will not be compiled cause it will execute two transactions on the same one. Try it... Best regards. -- Wagner Bianchi 2010/12/21 Jerry Schwartz > Aha! That was the clue I needed. Thank you so much. > > > > So,

Corrupted TRG file?

Version 5.1.31 Community (Win32) I created a trigger named TC_Products_Date_Trigger on the table TC_Products. I typed in SHOW CREATE TRIGGER tc_products_date_trigger; and this came back at me: ERROR 1602 (HY000): Corrupted TRG file for table `subtable_usa`.`tc_products` I a

Download, configure, compile, and install MySQL 5.5.8 from source code on Linux

Download, configure, compile, and install MySQL 5.5.8 from source code on Linux thanks.

RE: Trigger?

Aha! That was the clue I needed. Thank you so much. So, to make sure I understand: A “BEFORE” trigger is executed **between** the time that the record is assembled and the time that the action occurs. That’s why the constraints on the field value were being applied before my trigger was t

RE: Trigger?

Here's my latest attempt: localhost >CREATE TRIGGER makefoo BEFORE INSERT ON testtrigger -> FOR EACH ROW -> SET NEW.foo = IFNULL(NEW.foo, 'ok') -> | Query OK, 0 rows affected (0.00 sec) As you can see, the trigger syntax is correct; but it doesn't do what I want. localhost >INSERT IN

Re: Discontinued AUTO_INCREMENT problem....

Hi, There is one variable called innodb_autoinc_lock_mode. If the value is 0, this issue wont come. You might set it to 1 or 2. -Partha www.mafiree.com - Original Message From: Wagner Bianchi To: 杨涛涛 Cc: Xavier Correyeur ; mysql@lists.mysql.com Sent: Tue, 21 December, 2010 3:28:00

Re: max allowed packets on Mac

你出现的太频繁了，兄弟 You post too frequently in the list. 杨涛涛 编写： >I agree with michael dykman. >杨涛 >我博客1:http://yueliangdao0608.cublog.cn >My 我博客2:http://yueliangdao0608.blog.51cto.com > > >2010/12/18 Michael Dykman > >> I'm not nuts about deploying MySQL on macs, but I think you need to >> assume roo

Re: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

Maybe you should give a password to MySQL's root. And I think this note will disappear. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 2010/12/17 Yves Goergen > On 14.12.2010

Re: Discontinued AUTO_INCREMENT problem....

Too curious...could you share a SHOW CREATE TABLE from this table as requested before? Best regards. -- Wagner Bianchi 2010/12/21 杨涛涛 > Hi. > You can show us your show create table statement as well. > > > 杨涛 > 我博客1:http://yueliangdao0608.cublog.cn > My 我博客2:http://yueliangdao0608.blog.51cto

Re: MySQL Parallel Inserts

Hi. MySQL do the sql parse in the single way, just one thread. So if there are parallel insert statement, it will not faster than before. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com 2010/12/17 Andy > Shaw

Re: Kill DELETE Query

Yeah. The "Delete from tablename " will remove the record one by one. So you can cancel it whenever you don't need to continue. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com 2010/12/17 Willy Mularto > Thanks

Re: max allowed packets on Mac

I agree with michael dykman. 杨涛 我博客1:http://yueliangdao0608.cublog.cn My 我博客2:http://yueliangdao0608.blog.51cto.com 2010/12/18 Michael Dykman > I'm not nuts about deploying MySQL on macs, but I think you need to > assume root. As your mac admin user, try > $ sudo su - > and give your admin pas

Re: mysqldumpslow

Yeah, It can only parse the local file. If you expect to parse the remote one, just download it,haha. 杨涛 我博客1:http://yueliangdao0608.cublog.cn My 我博客2:http://yueliangdao0608.blog.51cto.com 2010/12/19 Eric Bergen > I don't think so. mysqldumpslow parses the log file on the local server. > > On

Re: Discontinued AUTO_INCREMENT problem....

Hi. You can show us your show create table statement as well. 杨涛 我博客1:http://yueliangdao0608.cublog.cn My 我博客2:http://yueliangdao0608.blog.51cto.com 2010/12/20 Xavier Correyeur > Hi everybody ! > > A have a discontinued AUTO_INCREMENT sequence when i insert data in a table > with a 100 (or