Paul, Does this optimize the query? I thought both of the queries will have the same relational algebra representation. Am I wrong?
Thanks. Saqib Ali --------- http://www.xml-dev.com On Fri, 18 Jul 2003, Paul DuBois wrote: > At 15:42 -0400 7/18/03, Chris Edwards wrote: > >Hi > > > >This has probably come up before... > > > >Using version 3.23.54 > > > >I have multiple OR logic in the where clause. > > > >where id = 1 or id = 2 or id = 3.... > > > >The list is finite, at about 20 ids. > > > >I know i can say where != if the the OR count is more than half the list > >items > > > >Is there any other way to provide optimization for this? > > WHERE id IN(1,2,3,...) > > NULL cannot be in the value list. > > > >Thanks. > > > >-- > >Chris Edwards > >Web Application Developer > >Outer Banks Internet, Inc. > >252-441-6698 > >[EMAIL PROTECTED] > >http://www.OuterBanksInternet.com > > > >----- Original Message ----- > >From: "James" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Friday, July 18, 2003 2:07 PM > >Subject: Replication Problem > > > > > >> First off, this is the first time I have done replication in MySQL so the > >> problem very well may be my fault. I run a simple master / slave setup > >that > >> Replicates one database. Replication works for a day or two then for > >> reasons unknown to me I see this on show slave status, "Last_error: error > >> 'Server shutdown in progress'..." but Uptime on the Master and Slave both > >> show dates that are older than when the error occurred. > >> > >> This problem has been occurring for ~ 2 weeks. 3 days ago I moved the > >> Slave into the same rack as the master so they would be on the same > >> subnet/switch, but the problem still exists. > >> > >> I could implement a perl script to just check the replication status, and > >> take necessary action to restart the slave if the SQL thread is down, but > >I > >> was wondering if a more elegant solution existed. > >> > >> Thanks > >> James > >> > >> > >> ([EMAIL PROTECTED]) [(none)]> show slave status\G > >> *************************** 1. row *************************** > >> Master_Host: Replaced > >> Master_User: Replaced > >> Master_Port: Replaced > >> Connect_retry: 60 > >> Master_Log_File: MASTER-bin.010 > >> Read_Master_Log_Pos: 131845183 > >> Relay_Log_File: SLAVE001-relay-bin.004 > >> Relay_Log_Pos: 257067861 > >> Relay_Master_Log_File: MASTER-bin.010 > >> Slave_IO_Running: Yes > >> Slave_SQL_Running: No > >> Replicate_do_db: MASTER > >> Replicate_ignore_db: > >> Last_errno: 1053 > >> Last_error: error 'Server shutdown in progress' on query > >'UPDATE > >> LOW_PRIORITY thread SET views=views+1 WHERE threadid='154039'' > >> Skip_counter: 0 > >> Exec_master_log_pos: 108378574 > >> Relay_log_space: 280534474 > >> 1 row in set (0.00 sec) > >> ([EMAIL PROTECTED]) [(none)]> select now(); > >> +---------------------+ > >> | now() | > >> +---------------------+ > >> | 2003-07-18 10:11:27 | > >> +---------------------+ > >> 1 row in set (0.02 sec) > >> ([EMAIL PROTECTED]) [(none)]> start slave; > >> Query OK, 0 rows affected (36.25 sec) > >> ([EMAIL PROTECTED]) [(none)]> status; > >> -------------- > >> mysql Ver 12.18 Distrib 4.0.12, for unknown-freebsd4.8 (i386) > >> > >> Connection id: 5239 > >> Current database: > >> Current user: [EMAIL PROTECTED] > >> SSL: Not in use > >> Current pager: /usr/bin/less > >> Using outfile: '' > >> Server version: 4.0.13 > >> Protocol version: 10 > >> Connection: Localhost via UNIX socket > >> Client characterset: latin1 > >> Server characterset: latin1 > >> UNIX socket: /tmp/replication.sock > >> Uptime: 3 days 15 hours 26 min 43 sec > >> > >> > >> Then on my master. > >> > >> ([EMAIL PROTECTED]) [(none)]> status; > >> -------------- > >> mysql Ver 12.20 Distrib 4.0.13, for unknown-freebsd4.8 (i386) > >> > >> Connection id: 71764 > >> Current database: > >> Current user: [EMAIL PROTECTED] > >> SSL: Not in use > >> Current pager: more > >> Using outfile: '' > >> Server version: 4.0.13-log > >> Protocol version: 10 > >> Connection: Localhost via UNIX socket > >> Client characterset: latin1 > >> Server characterset: latin1 > >> UNIX socket: /tmp/mysql.sock > >> Uptime: 16 days 19 hours 7 min 47 sec > > > > >> Threads: 92 Questions: 53552863 Slow queries: 698 Opens: 83017 Flush > >> tables: 1 Open tables: 64 Queries per second avg: 36.901 > >> -------------- > >> > >> ([EMAIL PROTECTED]) [(none)]> select now(); > >> +---------------------+ > >> | now() | > >> +---------------------+ > >> | 2003-07-18 10:16:26 | > >> +---------------------+ > >> 1 row in set (0.00 sec) > >> > >> > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: > >http://lists.mysql.com/[EMAIL PROTECTED] > >> > > > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > Paul DuBois, Senior Technical Writer > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > Are you MySQL certified? http://www.mysql.com/certification/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]