Re: Another replication question

2010-12-23 Thread Jorg W Young
This guy has been saying nothing meaningful on this list, but advertise his blog everywhere. Just 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

Re: Another replication question

2010-12-23 Thread Johan De Meersman
Glad to hear I'm not the only one annoyed :-) I've plonked him in the meantime. 2010/12/23 Jorg W Young jorgwyoung...@gmail.com jorgwyoung%2...@gmail.com This guy has been saying nothing meaningful on this list, but advertise his blog everywhere. Just be shame. He should be kicked out from

Error while running Mysql

2010-12-23 Thread Adarsh Sharma
Dear all, I am able o successfully build Mysql 5.5.8 from its source code on CentOS but when I issued the following command , it doesn't shows the mysql prompt, there is no error in log file. [r...@ws-test mysql-5.5.8]# bin/mysql -p Enter password: Welcome to the MySQL monitor. Commands

Re: Error while running Mysql

2010-12-23 Thread Johan De Meersman
Probably one for the guys with the compilers, but have you tried running it with dtrace and seeing where it explodes ? On Thu, Dec 23, 2010 at 1:38 PM, Adarsh Sharma adarsh.sha...@orkash.comwrote: Dear all, I am able o successfully build Mysql 5.5.8 from its source code on CentOS but when I

Re: Error while running Mysql

2010-12-23 Thread Glyn Astill
I've no idea of the status of dtrace on linux, as I've never tried, but failing that you could run it through gdb to get some insight into the issue. --- On Thu, 23/12/10, Johan De Meersman vegiv...@tuxera.be wrote: From: Johan De Meersman vegiv...@tuxera.be Subject: Re: Error while running

Re: Error while running Mysql

2010-12-23 Thread Ananda Kumar
have u over allocated RAM/ process regards anandkl On Thu, Dec 23, 2010 at 6:15 PM, Glyn Astill glynast...@yahoo.co.uk wrote: I've no idea of the status of dtrace on linux, as I've never tried, but failing that you could run it through gdb to get some insight into the issue. --- On Thu,

Re: Error while running Mysql

2010-12-23 Thread Joerg Bruehe
Hi! Johan De Meersman wrote: Probably one for the guys with the compilers, but have you tried running it with dtrace and seeing where it explodes ? TTBOMK, dtrace is a Solaris tool, and I haven't heard about it being available on CentOS. I assume this is a typo, and Johan meant strace. I

Re: Error while running Mysql

2010-12-23 Thread Krishna Chandra Prajapati
HI Adarsh, Try memtester command #memtester 5 1 It' a linux tool to check ram for errors. http://krishna-mysql.blogspot.com/2010/12/faulty-physical-ram.html Krishna On Thu, Dec 23, 2010 at 6:08 PM, Adarsh Sharma adarsh.sha...@orkash.comwrote: Dear all, I am able o successfully build

Re: INSERT DELAYED and logging

2010-12-23 Thread Alejandro Bednarik
杨涛涛 *Stop top posting.* * * *thanks.* * * On Thu, Dec 23, 2010 at 12:16 AM, 杨涛涛 david.y...@actionsky.com wrote: 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

How to Install Mysql

2010-12-23 Thread Adarsh Sharma
Dear all, Yesterday I am trying to build Mysql-5.5.8 from source code and don't know why I am failing at the last step. I am able to successfully build Mysql 5.5.8 from its source code on CentOS but when I issued the following command , it doesn't shows the mysql prompt, there is no error

Re: 4 days to drop Index

2010-12-23 Thread 杨涛涛
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

2010-12-23 Thread 杨涛涛
Yeah, Just entering the mysql command line client, typing the keyword 'status' , you'll get the absolute value. 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/22

Re: sub query to daily usage subtraction

2010-12-23 Thread 杨涛涛
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,