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 anthony.p...@utoronto.cawrote: 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
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 anthony.p...@utoronto.cawrote: 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 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?
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 anthony.p...@utoronto.cawrote: 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
Re: MySQL dying?
Lol! Good point Karen! On Tue, Dec 4, 2012 at 1:02 PM, Karen Abgarian a...@apple.com 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?
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 w...@singerwang.com wrote: Lol! Good point Karen! On Tue, Dec 4, 2012 at 1:02 PM, Karen Abgarian a...@apple.com 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?
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 w...@singerwang.com wrote: Lol! Good point Karen! On Tue, Dec 4, 2012 at 1:02 PM, Karen Abgarian a...@apple.com 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: 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 paulnowosiel...@yahoo.com 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) | YES | | NULL | | | seconds|
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: 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 rja...@yahoo-inc.com 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 trimur...@tulassi.com 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
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: 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 h.rei...@thelounge.netwrote: 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