MySQL eats 99 CPU time problem help

2002-12-11 Thread shawn xu
We have MySQL 3.23.53 running on Intel machine with OS
BSDI 4.3.

The problem happened more often like this. 

MySQL eated up 99% cpu time which was told by running
top. When this happened, I guess it still answer
queries, but it is too slow to answer, which results
in the customers complaining.

What we have tried, none of them work except wiping
the disk and reinstalling everything.  

I`d appreciate any suggestions to fix this problem.

Shawn


__ 
Post your free ad now! http://personals.yahoo.ca

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Replication between Windows MSSQL and UNIX MYSQL

2002-12-08 Thread shawn xu
We have an application software which uses MSSQL 7.0
or 2000 server on Windows. Now we want to use the
MSSQL as a master, and MYSQL on UNIX as a slave. How
can we configure Windows MSSQL and UNIX MYSQL both
sides to implement replication?

Any idea? Thanks in advance.

Shawn

__ 
Post your free ad now! http://personals.yahoo.ca

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: I can not post to this list after I have joined

2002-12-05 Thread shawn xu

Mysql, sql,query


 --- [EMAIL PROTECTED] wrote:  Your message
cannot be posted because it appears to
 be either spam or
 simply off topic to our filter. To bypass the filter
 you must include
 one of the following words in your message:
 
 sql,query
 
 If you just reply to this message, and include the
 entire text of it in the
 reply, your reply will go through. However, you
 should
 first review the text of the message to make sure it
 has something to do
 with MySQL. Just typing the word MySQL once will be
 sufficient, for example.
 
 You have written the following:
 
 Why cannot I post questions to this list since I
 joined a month ago? Why?
 
 It says it cannot include attachment, but definately
 I
 didn't include attachment when I tried to post.
 
 Shawn
 

__
 
 Post your free ad now! http://personals.yahoo.ca
  

__ 
Post your free ad now! http://personals.yahoo.ca

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




mi_test_all error help

2002-12-05 Thread shawn xu
I am using BSDI 4.3, and downloaded MySql source code
3.23.53. 

After untarring it, it passed ./configure
--prefix=/usr/local/mysql. But when I run make,
finally it says

make: don't know how to make mi_test_all. Stop

*** Error code 1

Your help will be appreciated

Shawn Xu




__ 
Post your free ad now! http://personals.yahoo.ca

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




mysql@lists.mysql.com

2002-12-05 Thread shawn xu
I am using BSDI 4.3, and downloaded MySql source code
3.23.53. 

After untarring it, it passed ./configure
--prefix=/usr/local/mysql. But when I run make,
finally it says

make: don't know how to make mi_test_all. Stop

*** Error code 1

Your help will be appreciated

Shawn Xu


MySQL, MYSQL, mysql



__ 
Post your free ad now! http://personals.yahoo.ca

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




mi_test_all error help

2002-11-30 Thread shawn xu
 
 
I am using BSDI 4.3, and downloaded MySql source code
3.23.53. 

After untarring it, it passed ./configure
--prefix=/usr/local/mysql. But when I run make,
finally it says

make: don't know how to make mi_test_all. Stop

*** Error code 1

Your help will be appreciated

Shawn Xu


__ 
Post your free ad now! http://personals.yahoo.ca

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php