Re: Another replication question

be shame. He should be kicked out from the list. Jorg. 2010/12/23 杨涛涛 david.y...@actionsky.com: This way is very well, but it has to do lots of human work. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog

Re: MySQL upgrade from 5.0.51a to 5.1.53

Hi all, I did a upgrade from 5.0 to 5.1 yesterday. And I paste some of my steps on the following. 1. Use mysqldump to dump all the data to the disk. 2. Backup all the data including mysql system files to a safe place. 3. Remove all the file related to mysql. 4. Install the new

Re: 4 days to drop Index

Hi. I think you should upgrade your hardware and adjust your mysqld's parameters. Then your job will be fine. 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/23

Re: Table cache not being updated

time pass and see what happen. Best regards. -- Wagner Bianchi 2010/12/22 杨涛涛 david.y...@actionsky.com How did you adjust this variable? Stay it in my.cnf or just set it? David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http

Re: sub query to daily usage subtraction

Hi, I'm confusion with your issue. Can you show us your detailed wanted? 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/1 Mohan L l.mohan...@gmail.com Dear All,

Re: explain shows type = ALL for indexed column

Yeah. The subquery sometimes creates temporary tables, so the performance is worse than join. Just leaving it. 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/8 Aaron

Re: unfortunately truncate tables

I'm sorry to hear about you. 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/4 kranthi kiran kranthikiran@gmail.com Hi all unfortunately some body truncate the 2

Re: Database procedures

Hi Richards . Here are some of my codes. You can do some changes whatever you want. http://blog.chinaunix.net/u/29134/showart_1002486.html David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn:

Re: Table cache not being updated

How did you adjust this variable? Stay it in my.cnf or just set it? 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/11/24 Machiel Richards machi...@rdc.co.za Hi All

Re: Parameter(s) need to take care when setting replication over WAN

This is depending on your production environment. 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/4 Ryan Chan ryanchan...@gmail.com Hello, I am setting MySQL (5.0)

Re: MyQuery 3.4.1 Released

It's great! 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/11/29 Anders Karlsson and...@recordedfuture.com I have released MyQuery 3.4.1 today. MyQuery is a Windows

Re: SQLStats 1.1 available

I can not visit this page in china. http://karlssonondatabases.blogspot.com/2010/11/monitoring-mysql-sql-statement-way-it.html 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

Re: INSERT DELAYED and logging

Hi. I think if there are not some concurrency visitors, you should not use it. Otherwise, just put it. 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/1 Wagner Bianchi

Re: Another replication question

This way is very well, but it has to do lots of human work. 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/11/24 Rolando Edwards redwa...@logicworks.net MySQL, by

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 x.correy...@free.fr Hi everybody ! A have a discontinued AUTO_INCREMENT sequence when i insert data in a table

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 eric.ber...@gmail.com I don't think so. mysqldumpslow parses the log file on the

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 mdyk...@gmail.com 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

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

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

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

Re: Discontinued AUTO_INCREMENT problem....

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 wagnerbianch...@gmail.com To: 杨涛涛 david.y...@actionsky.com Cc: Xavier Correyeur x.correy...@free.fr; mysql@lists.mysql.com

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: 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 rajl...@rajshekhar.net In infinite wisdom

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) shawn.l.gr...@oracle.com On 12/3/2010 03:40,