Re: Another replication question
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 Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 在 2010年12月23日 下午8:14,Johan De Meersman vegiv...@tuxera.be写道: 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.comjorgwyoung%2...@gmail.com jorgwyoung%2...@gmail.com jorgwyoung%252...@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 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.51cto.com My Msn: yueliangdao0...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL Replication Broken
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 can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0x418ac0a8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: (nil) New value of fp=0x38f18130 failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack tr ace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x3a4d2c13 = UPDATE t_items i, site_items_195_16 pc SET i.item_type = CASE pc.item_type WHEN '0' THEN 2 WHEN ' 1' THEN 2 WHEN '2' THEN 1 END, i.optional_field_6 = CASE pc.item_type WHEN '0' THEN '' WHEN '1' THEN 1 WHEN '2' THEN '' END , i.email = pc.email, i.optional_field_19 = pc.lang_id, i.optional_field_16 = pc.ip, i.optional_field_9 = (SELECT COUNT(*) FROM geodesic_auctions_bids ab WHERE ab.auction_id = i.item_id), i.title = pc.title, i.date = pc.date, i.description = pc.d escription, i.image = pc.image, i.price = pc.price, i.optional_field_8 = pc.deleted_type, i.optional_field_13 = pc.bloqued_ type WHERE i.item_id = pc.id AND i.item_id = 113347296 thd-thread_id=7 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. t is a temporal table. More strange was that Slave's failed with more or less 2 hours of difference. MySQL version is 5.0.x Any help is welcome, Thanks. -- Infrastructure Team OLX Inc. Buenos Aires - Argentina Phone : 54.11.4775.6696 Mobile : 54.911.50436059 Email: alejand...@olx.com
Select from the table being updated
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 be extremely useful to do that? If I want to copy a row and only do minor changes to a single column, I don't want to read the other huge column out to the client, only put write it back to the database again unchanged. Or in the above example, I could find the next value, like here: UPDATE t1 (c1, c2) VALUES ((SELECT MAX(c1) + 1 FROM t1 WHERE c2 = 5), 5); Is it planned at all to add that? Is it really so complicated to do it that it hasn't been done all those years? The MySQL bug tracker was unable to filter the bugs down to less than a few thousands, so I'm posting it here. -- Yves Goergen LonelyPixel nospam.l...@unclassified.de Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: [PHP-INSTALL] php - libmysqlclient question
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 you can take advantage of the latest features and fixes, but unless you're going back really far - like MySQL 3.23 - any modern client version should have no negative impact. Even in that case it may not, but that's a better question for either the php-db@ list or the MySQL General list (both CC'd for folks to add anything I may have forgotten). -- /Daniel P. Brown Network Infrastructure Manager Documentation, Webmaster Teams http://www.php.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
/etc/init.d/mysql start WITHOUT integrity check?
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 because sadly /etc/init.d/mysql reload does NOT re-load the config file (as one might hope), it is only to reload PRIVS (how useless is that since GRANT already does that). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Automate Scripts to make for managing Large Database Servers.
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 Paths or Hard Disks. 3. Performing Updates of Softwares. 4. Checking Servers Power Status. Please guide me some more tasks that need a proper attention. Thanks Regards Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
my.cnf file
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. I find only a folder in /var/lib/ i.e mysql folder that contains ibdata and database folder plus .sock and .err file. After some research i find default path of my.cnf is /etc/my.cnf, /etc/mysql/my.cnf, /var/lib/mysql/my.cnf. But couldn,t locate it as it is needed for changing data dirs. Please help. Thanks Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org