If your data is properly Normalized, then this is the best way. Saqib Ali --------- http://www.xml-dev.com
On Fri, 18 Jul 2003, 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? > > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
