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
thatFirst 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 setupIReplicates 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, butwas wondering if a more elegant solution existed.'UPDATE
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>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 sechttp://lists.mysql.com/[EMAIL PROTECTED]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:
-- 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]