crashed tables after copy

g the data around any time soon, I do need to set up a slave and don't want to screw anything up. I normally rsync or tar up the data on the master as LOAD DATA FROM MASTER has not proven reliable over WAN for me. -- Brian Moon, dealnews.com, Inc. dealnews.com News on computer hardware barga

relay-bin on master?

I am getting relay-bin logs on my master server. They are all empty except for one line that reads: þbin I have no slave settings in my my.cnf file. Any idea where these are coming from and how to turn them off? Brian Moon dealnews.com -- MySQL General Mailing List For list archives: http

Re: SQL JOIN Challenge - Help Please

order_id from transaction_log where order_id not in ({id list}) The list could be pretty big I guess. Brian. - Original Message - From: "Paul Maine" <[EMAIL PROTECTED]> To: "Brian Moon" <[EMAIL PROTECTED]>; "MySQL MySQL" <[EMAIL PROTECTED]> S

Re: SQL JOIN Challenge - Help Please

If I read right, this is a pretty basic join so I am assuming that you have never done a join in your life. select distinct order.order_id from order inner join transaction_log on order.order_id=transaction_log.order_id and transaction_log.event_log_id <> 3 Brian. -

Re: Performance issue: slow inserts

InnoDB are "supposed" to be faster at Inserts and updates than MyISAM. However, my dealings with InnoDB have made me think that unless you _need_ transactions, foreign keys, etc, MyISAM is still the way to go for speed on large tables. If you can go MyISAM (you may need that stuff), fixed width t

Re: Getting rid of filesort

forum_id, parent, thread key and see what happens. Brian. - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Brian Moon" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, August 22, 2002 12:28 AM Subject: Re: Getting rid of f

Getting rid of filesort

I have a table: CREATE TABLE `single_table` ( `forum_id` int(10) unsigned NOT NULL default '0', `id` int(10) unsigned NOT NULL auto_increment, `datestamp` datetime NOT NULL default '-00-00 00:00:00', `thread` int(10) unsigned NOT NULL default '0', `parent` int(10) unsigned NOT NULL

Keys, Wheres, and Order bys

If I have a query like: select field1 from table where field2=0 order by field3 desc limit 30; and I have keys: key field2 (field2) key field3 (field3) Will MySQL use one key to select and one to order? Or do I need a: key field2_field3 (field2, field3) This is a big table and i don't want

Re: Exact word search

Use FullText indexing or a REGEXP. Brian. - Original Message - From: "Robert Macwange" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 21, 2002 9:18 AM Subject: Exact word search | Hello y'all, | | I guess this is easy, but it is defeating me. | I am having a proble

Re: NULL values in a JOIN

You might want to use the full join syntax here to be clear on what is happening. select title as Title, COALESCE(o.name,'None') as Organization from m left join o on o.ID = m.organization Also, notice COALESCE. Much less messy. Brian. - Original Message - From: "Quinten Steenhuis

Re: Suggestion on New MySQL Function

It used to do what you are saying. That was very bad. For example, we stored click data for articles. Whe the articles were archived for speed reasons, MySQL started filling in the holes. When we got back around to archiving those rows, we could not do so as the archive table already had rows

Re: MySQL and creating views......

gt; To: ""Brian Moon"" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 12:51 PM Subject: Re: MySQL and creating views.. | Thanks Brian. But another question is, I looked up CREATE TEMPORARY TABLE | What I want to know is can I do the followi

Re: MySQL and creating views......

That should work just fine. Brian. - Original Message - From: <[EMAIL PROTECTED]> To: ""Brian Moon"" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 12:51 PM Subject: Re: MySQL and creating views.. | Thanks Brian. But a

Re: MySQL and creating views......

Do you need to create a temp table or a heap table? Temp tables support those columns fine. Heap tables do not. Brian. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 11:44 AM Subject: MySQL and creating views.. | I am new to

Re: MySQL over NFS

equal the select server name we make two connections. The load saved on the main server is well worth the connection. MySQL is pretty fast with connections compared to other DBMS I have used. Brian. - Original Message - From: <[EMAIL PROTECTED]> To: "Brian Moon" <[E

Re: MySQL over NFS

Also, what we have done is used a replicating box as a select only server. This requires you to write your code in such a way that only selects get sent to the slave. A simple function wrapper in PHP is all we needed. Brian. - Original Message - From: "Brian Moon" <[EM

Re: MySQL over NFS

This is an interesting idea. I would be a happy man if it would actually work. My experiences with NFS would lead me to believe that this would not help and could hurt the performance of existing MySQL server even more. My use has been limited to a file server for our web nodes, so, this is a b

Re: Query slowing down, need advice

n it are really fast. There is a key on approved, datestamp as well. >From that I have the rows I am looking for. All in .4 seconds. This is with 1Mil+ rows. The speed is consistent for all search criteria. Brian Moon Phorum Dev Team -

Re: Query slowing down, need advice

have problems with. The query is not just slow, it does not return. Brian. - Original Message - From: "Thomas Spahni" <[EMAIL PROTECTED]> To: "Brian Moon" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, August 16, 2002 10:51 AM Subject: Re:

Query slowing down, need advice

Hi, I am the lead developer of Phorum . We are starting to see some users with 1 Million messages in their forums, including me at dealmac.com. I am trying to optimize the tables and I am having good luck analyzing the keys and building better ones. However, I am having a pr

Re: Slow updates with two keys in where.

Is this just something we have to live with or does MySQL 4 handle this better? Brian. - Original Message - From: "Andrew Schmidt" <[EMAIL PROTECTED]> To: "Brian Moon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 24, 2002 3:11

Slow updates with two keys in where.

`datestamp` (`datestamp`), KEY `subject` (`subject`), KEY `thread` (`thread`), KEY `parent` (`parent`), KEY `approved` (`approved`), KEY `msgid` (`msgid`), KEY `modifystam