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]



Reply via email to