turning off replication

to connect to barney because the values from CHANGE MASTER TO... are still there.. how do i completely clear this? so i don't have any problems when i bring barney back to life. Marc Dumontier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: performance on query with ORDER BY clause

://www.friendster.com -Original Message- From: Marc Dumontier [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 02, 2005 12:02 PM To: mysql@lists.mysql.com Subject: performance on query with ORDER BY clause Hi, I have a simple query with an ORDER BY clause, and it's taking forever to run on this table

performance on query with ORDER BY clause

innodb_log_file_size = 64M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 Any help would be appreciated, so far query has been running for 3000 seconds Marc Dumontier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

slow date query

where | ++--+---+--+-+--++-+ 1 row in set (0.00 sec) thanks, Marc Dumontier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: slow date query

Thanks, works like a charm. Marc Dathan Pattishall wrote: Well 1st of all Date_format doesn't allow the use of a key. Do this. SELECT .. WHERE DateLastRevised = '2004-12-07' AND DateLastRevisted '2004-12-08'; -Original Message- From: Marc Dumontier [mailto:[EMAIL PROTECTED] Sent