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 5

Re: Another replication question

ould be kicked out from the list. > > > > Jorg. > > > > 2010/12/23 杨涛涛 : > > > 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

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 > Dear All, > > My Mysql Table co

Re: Table cache not being updated

onitoring. Let time pass and see what happen. > Best regards. > -- > Wagner Bianchi > > 2010/12/22 杨涛涛 > > > 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

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 Adars

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 > MySQL, by design, cannot do that. > >

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: 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 20

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 > I have released MyQuery 3.4.1 today. MyQuery is a Windows based Ad-Hoc > query tool wit

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 > Hello, > > I am setting MySQL (5.0) replication over WA

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 > Hi All > > Maybe someone

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: yueliangdao

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 > Hi all > unfortunately some body truncate the 2 tables , in this data we

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 Tur

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....

le 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 Decem

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: 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