Re: LOAD DATA FROM MASTER stops unfinished with Query OK

2008-01-21 Thread Neil Davis
The test box doesn't have incoming data when he's taking the snapshot. Lock the production database while taking snapshot and setting up replication or you will have this problem. I've tried all the methods (snapshot, dump, hotcopy etc) and the issue is always the same. You can't bootstrap replicat

Problem with update logging under Solaris

2001-02-01 Thread Dr Neil Davis
I am running MySQL 3.22.32 on a sun enterprise server, but I am having problems with update logging. When update logging is specified in the /etc/my.cnf file and the MySQl process restarted logging will commence but will stop after a few hours (the number of hours is variable!). Connecting to the

Re: how to put database into RAM?

2001-01-15 Thread Neil Davis
Yury, Can we see the code and queries in question? It may be a better solution to clean up the queries(and code), perhaps change multiple queries into one query ... Indexing the tables would undoubtedly help as well. If they already are indexed, when is the last time they were re-indexed and clea

Re: MySQL on a Windows Terminal Server

2001-01-15 Thread Neil Davis
Stefan, Your friend has the right idea; proceed with extreme caution. I have heard (from colleagues that work on this product) that Terminal server(TS) is a very different animal from the standard or enterprise NT. In fact they have spent many long nights troubleshooting it. Often there are lots o

Re: Lazy

2001-01-11 Thread Neil Davis
Guys, Amen. When I was 13 and got my first commodore 64, I decided to teach myself BASIC. All I had was the manual. (the MySQL manual is the library of congress compared to this manual!) There simply were no other resources for me since I couldn't afford a modem until 2 years later, when I got a