ng 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
| ALL | NULL | NULL |NULL | NULL | 122850 |
Using 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]
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
25 % of buffer pool size
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://
ishall http://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
