Re: Another replication question

2010-12-29 Thread Sharl.Jimh.Tsin
really really a little noisy. 这下犯众怒了吧,招人烦了~ 囧 Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/12/29 杨涛涛 david.y...@actionsky.com: Ok, I'll not post any more!  Just reading! David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My

MySQL Replication Broken

2010-12-29 Thread Alejandro Bednarik
Hi all, We have a pool of 8 MySQL servers where the first one is the master and the others 7 are slave. Yesterday we have a hard time where the server begin with too many lag ( 1 hour ) and then slaves start to fail with messages like this one thd=0x38f18130 Attempting backtrace. You

Select from the table being updated

2010-12-29 Thread Yves Goergen
Hi, why doesn't MySQL support selecting from the table being updated? The following and any variations of it doesn't work: UPDATE t1 (c1) VALUES (SELECT MAX(c1) FROM t1); This restriction is documented here: http://dev.mysql.com/doc/refman/5.5/en/update.html (at the very bottom) Wouldn't it

Re: [PHP-INSTALL] php - libmysqlclient question

2010-12-29 Thread Daniel Brown
On Wed, Dec 29, 2010 at 04:57, Hajo Locke hajo.lo...@gmx.de wrote: Hello, i want to talk from php to different mysql-servers with different versions. is it a recommend way to compile php always against newest libmysqlclient or not so important? You should use the newest stable version so

/etc/init.d/mysql start WITHOUT integrity check?

2010-12-29 Thread Daevid Vincent
Is there a way to /etc/init.d/mysql start WITHOUT doing an integrity check? Can I pass in a command line parameter or set something in the my.cnf file? Our DB is a Billion rows (with a B) and that check can take HOURS. All we want to do is restart the server to put another slave online

Automate Scripts to make for managing Large Database Servers.

2010-12-29 Thread Adarsh Sharma
Dear all, I am working on some common tasks that need to be performed on regular intervals in a large Database Servers. I find below lists of tasks that need to be performed and Please tell me if i missed some. 1. Tacking Daily, Weekly Backups. 2. Finding Space Occupied and Remaining in Data

my.cnf file

2010-12-29 Thread Adarsh Sharma
Dear all, I am able to install Mysql-5.1.4 o a Linux Machine without any error. All is working fine. But I am searching a file my.cnf which is most important and is used in mysql but cannot able to find it. I install mysql by yum install mysql-server and yum install mysql-client commands.