Re: multiple ORs

[Paul DuBois]

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]