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: Table cache not being updated

The response of table_cahe's new values is not imedite. MySQL cache engine will putting new objects in cache on demand intead of to replace them. Configure new table_cahe value at my.cnf or your configuration file, restart mysqld e going on monitoring. Let time pass and see what happen. Best

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

4 days to drop Index

Dear all, Things becomes too lazy when it takes too much time. I am suffering from this problem when droping index of size 17.7 GB on a table of size 24.7 GB. This table have some more indexes of different sizes. It takes near about 4 days to drop the index. Can anyone Please guide me