Re: MySQL Replication Error

2012-12-04 Thread divesh kamra
Hi first check this thought application end or There is another way slave-skip-errors=1062 ---> in my.cnf and restart mysql On Sat, Dec 1, 2012 at 4:30 AM, Reindl Harald wrote: > > > Am 30.11.2012 23:52, schrieb Rick James: > > Possible causes: > > * Someone is writing to the Slave >

Re: MySQL dying?

2012-12-04 Thread hsv
2012/12/04 15:18 -0800, Karen Abgarian MySQL, like all other products, can be peachy or bitchy. Good ones, they also die.Wish I was kidding :-) Mind VHS & BetaMax? BetaMax had much better color--but VHS long outlasted it. -- MySQL General Mailing List For list archives

Re: replication problem

2012-12-04 Thread divesh kamra
HI share detail Slave_IO_Running: Yes/No Slave_SQL_Running: Yes/No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: On Tue, Dec 4, 2012 at 5:59 AM, Rick James wrote: > SHOW SLAVE STATUS\G > SHOW MASTER STATUS; > What directory are the bi

query running very slow, need a little help

2012-12-04 Thread Paul Nowosielski
Hi, I'm running this query: mysql> SELECT email FROM promoters where id NOT IN (SELECT promoter_id FROM credits WHERE success = 1 ) and active = 1; Empty set (31.89 sec) its returning an empty set and take over 30 seconds to return. mysql> describe promoters; +---+--

Re: query running very slow, need a little help

2012-12-04 Thread Akshay Suryavanshi
Hi, A subquery with IN clause is not a good idea. If you want to tune this query, try adding indexes on the tables accessed in the inner query "credits". A composite index on (success,promoter_id) would be sufficient, then the optimizer will use this index for the where clause and as a covering in

Re: MySQL dying?

2012-12-04 Thread Karen Abgarian
MySQL, like all other products, can be peachy or bitchy. Good ones, they also die.Wish I was kidding :-) On Dec 4, 2012, at 2:37 PM, Andrés Tello wrote: > Are u kidding? > > Mysql is dead easy and damn good... obviously it has its perks, but any > database engine has them... (I'm loo

Re: MySQL dying?

2012-12-04 Thread Andrés Tello
Are u kidding? Mysql is dead easy and damn good... obviously it has its perks, but any database engine has them... (I'm looking at you DB2)... There has been a lot of improvements lately, I "feel" that mysql is moving much more faster under oracle umbrella than when it was alone... Replication..

Re: MySQL dying?

2012-12-04 Thread Singer Wang
Lol! Good point Karen! On Tue, Dec 4, 2012 at 1:02 PM, Karen Abgarian wrote: > A touch of realism: we are all dying. For some, it may take a while, > hopefully. > > On 04.12.2012, at 9:53, Tim Pownall wrote: > > > Mysql is used by just about every web host and is one of the most common > > da

RE: MySQL dying?

2012-12-04 Thread Rick James
Oracle is investing a lot into improvements in MySQL and releasing most of it in the Community version. Meanwhile, MariaDB is a serious contender. It is a drop-in replacement for MySQL. And Percona's Xtradb (included in MariaDB) is a drop-in replacement for InnoDB. If Oracle did something

MySQL dying?

2012-12-04 Thread Anthony Pace
I have heard that due to Oracle taking over, the OS community is shifting to other type of DB's . Any thoughts? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL dying?

2012-12-04 Thread Karen Abgarian
A touch of realism: we are all dying. For some, it may take a while, hopefully. On 04.12.2012, at 9:53, Tim Pownall wrote: > Mysql is used by just about every web host and is one of the most common > database servers around the world. I do not have any intent to stop using > mysql unless the

Re: MySQL dying?

2012-12-04 Thread Tim Pownall
Mysql is used by just about every web host and is one of the most common database servers around the world. I do not have any intent to stop using mysql unless they start charging for it which I do not think will happen. Thanks, Tim Pownall Sr. Linux Systems Monitoring Hostgator.com LLC On Tue,