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]

Reply via email to