Re: MySQL Replication Error
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 > > that is why the option "read-only" exists for my.cnf > > > * The Slave was not in synch with the Master. > > * Schemas are different between Master and Slave > > should not happen if the slave is properly cloned > as a binary copy of the stopped master and secured > with "read-only" > > > > > > >
Re: MySQL dying?
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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: replication problem
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 binlogs in? > > > > -Original Message- > > From: Michael Dykman [mailto:mdyk...@gmail.com] > > Sent: Monday, December 03, 2012 8:53 AM > > To: trimur...@tulassi.com > > Cc: mysql@lists.mysql.com > > Subject: Re: replication problem > > > > Trimurthy, > > > > you will have to describe the method you are using to setup > > replication. The error message seems plain but an observer could not > > reasonably guess what caused it without more information. > > > > - michael dykman > > > > > > On Mon, Dec 3, 2012 at 7:24 AM, Trimurthy > > wrote: > > > hi list, i am trying to set up replication but i couldn't > > > complete because of the following error Could not find first log file > > > name in binary log index file can any one please help me. > > > > > > > > > > > > > > > > > > > > > > > > Normal > > > 0 > > > > > > > > > > > > > > > false > > > false > > > false > > > > > > EN-US > > > X-NONE > > > AR-SA > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Thanks & Kind Regards, > > > > > > TRIMURTHY > > > > > > > > -- > > - michael dykman > > - mdyk...@gmail.com > > > > May the Source be with you. > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/mysql > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > >
query running very slow, need a little help
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; +---+--+--+-+---++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+---++ | id| int(11) unsigned | NO | PRI | NULL | auto_increment | | company_name | varchar(40) | YES | | NULL || | first_name| varchar(40) | YES | | NULL || | last_name | varchar(40) | YES | | NULL || | address | varchar(40) | YES | | NULL || | zip | varchar(10) | YES | | NULL || | city | varchar(40) | YES | | NULL || | country | varchar(40) | YES | | NULL || | phone | varchar(20) | YES | | NULL || | email | varchar(100) | YES | UNI | NULL || | website | varchar(100) | YES | | NULL || | payments_id | varchar(10) | YES | MUL | NULL || | password | varchar(100) | YES | | NULL || | active| tinyint(1) | YES | MUL | NULL || | activation_key| varchar(50) | YES | | NULL || | new_email | varchar(100) | YES | | NULL || | new_email_activation_key | varchar(50) | YES | | NULL || | registered| timestamp| YES | | CURRENT_TIMESTAMP || | referral | int(10) unsigned | YES | | NULL || | whitelabel_beginner_modus | tinyint(1) | YES | | 1 || +---+--+--+-+---++ 20 rows in set (0.00 sec) mysql> describe credits; ++-+--+-+---++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+---++ | id | int(11) unsigned| NO | PRI | NULL | auto_increment | | type | tinyint(1) unsigned | NO | | NULL || | credits| int(11) | YES | | NULL || | success| tinyint(1) | YES | MUL | NULL || | profit | float | NO | | NULL || | price | float | NO | | NULL || | date | timestamp | NO | MUL | CURRENT_TIMESTAMP || | user_id| int(11) unsigned| NO | | NULL || | promoter_id| int(10) unsigned| YES | MUL | NULL || | referrer | varchar(10) | YES | | NULL || | domain_id | int(11) unsigned| NO | | NULL || | string | varchar(100)| YES | | NULL || | client_info| varchar(200)| YES | | NULL || | promoter_paid | tinyint(1) | YES | | NULL || | status | tinyint(4) | YES | | NULL || | seconds| int(11) | YES | | NULL || | transaction_id | varchar(16) | YES | | NULL || ++-+--+-+---++ 17 rows in set (0.00 sec) Any ideas as to why the wuery is taking so long?? With kind regards, Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: query running very slow, need a little help
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 index for column "promoter_id". This should improve performance by orders of magnitude. Still we would recommend to turn this subquery in a join, which will perform faster even if there are many records retrieved from the inner query. Hope this helps, let us know the results. Regards, Akshay S On Wed, Dec 5, 2012 at 10:24 AM, Paul Nowosielski wrote: > 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; > +---+-**-+--+-** > +---+-**---+ > | Field | Type | Null | Key | Default > | Extra | > +---+-**-+--+-** > +---+-**---+ > | id| int(11) unsigned | NO | PRI | NULL > | auto_increment | > | company_name | varchar(40) | YES | | NULL > || > | first_name| varchar(40) | YES | | NULL > || > | last_name | varchar(40) | YES | | NULL > || > | address | varchar(40) | YES | | NULL > || > | zip | varchar(10) | YES | | NULL > || > | city | varchar(40) | YES | | NULL > || > | country | varchar(40) | YES | | NULL > || > | phone | varchar(20) | YES | | NULL > || > | email | varchar(100) | YES | UNI | NULL > || > | website | varchar(100) | YES | | NULL > || > | payments_id | varchar(10) | YES | MUL | NULL > || > | password | varchar(100) | YES | | NULL > || > | active| tinyint(1) | YES | MUL | NULL > || > | activation_key| varchar(50) | YES | | NULL > || > | new_email | varchar(100) | YES | | NULL > || > | new_email_activation_key | varchar(50) | YES | | NULL > || > | registered| timestamp| YES | | > CURRENT_TIMESTAMP || > | referral | int(10) unsigned | YES | | NULL > || > | whitelabel_beginner_modus | tinyint(1) | YES | | 1 > || > +---+-**-+--+-** > +---+-**---+ > 20 rows in set (0.00 sec) > > mysql> describe credits; > ++**-+--+-+---** > ++ > | Field | Type| Null | Key | Default | > Extra | > ++**-+--+-+---** > ++ > | id | int(11) unsigned| NO | PRI | NULL | > auto_increment | > | type | tinyint(1) unsigned | NO | | NULL | >| > | credits| int(11) | YES | | NULL | >| > | success| tinyint(1) | YES | MUL | NULL | >| > | profit | float | NO | | NULL | >| > | price | float | NO | | NULL | >| > | date | timestamp | NO | MUL | CURRENT_TIMESTAMP | >| > | user_id| int(11) unsigned| NO | | NULL | >| > | promoter_id| int(10) unsigned| YES | MUL | NULL | >| > | referrer | varchar(10) | YES | | NULL | >| > | domain_id | int(11) unsigned| NO | | NULL | >| > | string | varchar(100)| YES | | NULL | >| > | client_info| varchar(200)| YES | | NULL | >| > | promoter_paid | tinyint(1) | YES | | NULL | >| > | status | tinyint(4) |
Re: MySQL dying?
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 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... omg, replicacion is DEAD easy! so easy, that usually you > doublecheck things just because you are unsure that is SO easy... > > Partitioning, views, storeprocedures, explain and analise are good enough... > it simply work... I never, ever had a database corruption (I'm looking at to > you Mssql!) ... > > I have tables with more the 5millon rows, noproblem, I have a table with more > than 40 millon rows... and of course I have troubles, but always, always been > resolved... > > Mysql is... wonderful, it just works... You want it to "work as a storage > with out integrity?", done.. with integrity? done, replicaion, encryption, > secure connections, partition... name your feature! > > > > > > > > > > On Tue, Dec 4, 2012 at 12:50 PM, Singer Wang wrote: > 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 > > > 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, Dec 4, 2012 at 11:45 AM, Anthony Pace > >wrote: > > > > > >> 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 > > >> > > >> > > > > > > > > > -- > > > > > > Thanks, > > > > > > Tim Pownall > > > GNU/Linux Systems Monitoring > > > 610-621-9712 > > > pownall...@gmail.com > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/mysql > > > > >
Re: MySQL dying?
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... omg, replicacion is DEAD easy! so easy, that usually you doublecheck things just because you are unsure that is SO easy... Partitioning, views, storeprocedures, explain and analise are good enough... it simply work... I never, ever had a database corruption (I'm looking at to you Mssql!) ... I have tables with more the 5millon rows, noproblem, I have a table with more than 40 millon rows... and of course I have troubles, but always, always been resolved... Mysql is... wonderful, it just works... You want it to "work as a storage with out integrity?", done.. with integrity? done, replicaion, encryption, secure connections, partition... name your feature! On Tue, Dec 4, 2012 at 12:50 PM, Singer Wang wrote: > 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 > > > 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, Dec 4, 2012 at 11:45 AM, Anthony Pace < > anthony.p...@utoronto.ca > > >wrote: > > > > > >> 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 > > >> > > >> > > > > > > > > > -- > > > > > > Thanks, > > > > > > Tim Pownall > > > GNU/Linux Systems Monitoring > > > 610-621-9712 > > > pownall...@gmail.com > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/mysql > > > > >
Re: MySQL dying?
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 > > 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, Dec 4, 2012 at 11:45 AM, Anthony Pace >wrote: > > > >> 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 > >> > >> > > > > > > -- > > > > Thanks, > > > > Tim Pownall > > GNU/Linux Systems Monitoring > > 610-621-9712 > > pownall...@gmail.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > >
RE: MySQL dying?
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 nasty, there are exit strategies that do not involve porting to some other RDBMS. I say "don't worry". > -Original Message- > From: Karen Abgarian [mailto:a...@apple.com] > Sent: Tuesday, December 04, 2012 10:03 AM > To: mysql. > Subject: Re: MySQL dying? > > 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 they start charging for it which I do not > think will happen. > > > > Thanks, > > > > Tim Pownall > > Sr. Linux Systems Monitoring > > Hostgator.com LLC > > > > On Tue, Dec 4, 2012 at 11:45 AM, Anthony Pace > wrote: > > > >> 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 > >> > >> > > > > > > -- > > > > Thanks, > > > > Tim Pownall > > GNU/Linux Systems Monitoring > > 610-621-9712 > > pownall...@gmail.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
MySQL dying?
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?
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 they start charging for it which I do not think will happen. > > Thanks, > > Tim Pownall > Sr. Linux Systems Monitoring > Hostgator.com LLC > > On Tue, Dec 4, 2012 at 11:45 AM, Anthony Pace wrote: > >> 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 >> >> > > > -- > > Thanks, > > Tim Pownall > GNU/Linux Systems Monitoring > 610-621-9712 > pownall...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MySQL dying?
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, Dec 4, 2012 at 11:45 AM, Anthony Pace wrote: > 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 > > -- Thanks, Tim Pownall GNU/Linux Systems Monitoring 610-621-9712 pownall...@gmail.com
