date:20030217

Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.

2003-02-17 Thread Zak Greant

On Mon, Feb 17, 2003 at 01:37:59AM -0600, Jason Maskell wrote:
 Perhaps the subject will get someone to actually read this and offer even
 one reply with a suggestion?

  I admit that the topic got my attention - perhaps not in the best way
  though.

  I can offer a few suggestions:

  Provide more details:
   - How big is the table you are querying?
   - What is the query that you are running?
   - Do you have logging enabled? If so, does it report any error
 messages/slow queries/etc.
   - Is this the first time that you have encountered the issue?
   - etc...
  
  Can you upgrade? There have been bug fixes and enhancements in the
  versions that have been released since x.54. While I am not sure that
  they would fix your issues, this is a fairly quick thing to test - of
  course, make sure that you have back ups (just in case)!

  Also, keep in mind that it is the weekend and that this is a volunteer
  list.  I would guess that our resident FreeBSD guru (Jeremy Z.) is out
  working on his latest book. Assuming that you have not pissed him off,
  he may help you out. :)


Cheers!
-- 
Zak Greant [EMAIL PROTECTED]
  MySQL AB Community Advocate
  Personal Blog: http://zak.fooassociates.com

MySQL Tip: InnoDB in 4.0.8 supports ON UPDATE foreign key constraints
  See http://www.mysql.com/doc/en/SEC449.html for more details

-
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: CREATE INDEX is sooo slow! any ideas?

2003-02-17 Thread Sergei Golubchik

Hi!

On Feb 16, Dan Nelson wrote:
 In the last episode (Feb 16), Michael T. Babcock said:
   At 06:27 PM 2/16/2003 -0500, Peter Grigor wrote:
Well, MySql stores all its index information in one index file,
so when you add another index it has to rebuild the WHOLE file.
:)
  
  Anyone on the MySQL team feel like explaining that design decision,
  besides historical reasons?  I doubt its any more efficient except in
  file descriptor usage (although I've expressed the same doubts about
  InnoDB's avoidance of the filesystem too).
 
 Which decision, putting all the indexes in one file, or rebuilding all
 indexes whenever you ALTER TABLE or add an index?  If the latter, I
 agree with you.  Modifying unrelated indexes or columns should not
 force a rebuild of every index.

Of course not.
And it won't eventually - it's in the todo.
 
Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   ___/

-
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: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.

2003-02-17 Thread Jason Maskell

The tables I am querying the most are quite small. I just query them a lot.
The system processes about 500k requests a day, and each request involves
multiple queries.

I have just enabled a bunch of logging to try and puzzle out what is going
on, but I can't see it being a help.. The same queries execute over and over
and over, for 24 hours until eventually they stop working. Perhaps the logs
will have some errors messages or something that will be helpful. It really
seems to me (as a programmer) that MySQL is running itself out of something
internally, and then just finally dying.

I am not a big system admin guy, but I am going to get upgraded to .55 in
the next few minutes, to see if that helps at all.. Reading the changes list
I don't see anything that would affect me, but ya never know.

Thanks for the assistance.

Cheers,
Jason

- Original Message -
From: Zak Greant [EMAIL PROTECTED]
To: Jason Maskell [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, February 17, 2003 2:10 AM
Subject: Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.


 On Mon, Feb 17, 2003 at 01:37:59AM -0600, Jason Maskell wrote:
  Perhaps the subject will get someone to actually read this and offer
even
  one reply with a suggestion?

   I admit that the topic got my attention - perhaps not in the best way
   though.

   I can offer a few suggestions:

   Provide more details:
- How big is the table you are querying?
- What is the query that you are running?
- Do you have logging enabled? If so, does it report any error
 messages/slow queries/etc.
- Is this the first time that you have encountered the issue?
- etc...

   Can you upgrade? There have been bug fixes and enhancements in the
   versions that have been released since x.54. While I am not sure that
   they would fix your issues, this is a fairly quick thing to test - of
   course, make sure that you have back ups (just in case)!

   Also, keep in mind that it is the weekend and that this is a volunteer
   list.  I would guess that our resident FreeBSD guru (Jeremy Z.) is out
   working on his latest book. Assuming that you have not pissed him off,
   he may help you out. :)


 Cheers!
 --
 Zak Greant [EMAIL PROTECTED]
   MySQL AB Community Advocate
   Personal Blog: http://zak.fooassociates.com

 MySQL Tip: InnoDB in 4.0.8 supports ON UPDATE foreign key constraints
   See http://www.mysql.com/doc/en/SEC449.html for more details



-
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: CREATE INDEX is sooo slow! any ideas?

2003-02-17 Thread Sergei Golubchik

Hi!

On Feb 16, david wrote:
 
 Hi
 
 I have one table with 12 million records.   I'm trying to create an index 
 on one of the fields and it's taking hours ( over 6 so far)!  Am I doing 
 something wrong?
 
 The command I issued was
 create index title on article ( title);
 
  The table files are
 -rwxrwxrwx1 mysqlmysql8646 Feb 14 17:32 article.frm
 -rwxrwxrwx1 mysqlmysql   1406663720 Feb 14 23:27 article.MYD
 -rwxrwxrwx1 mysqlmysql   69661696 Feb 14 23:27 article.MYI
 
 As you can see the main file is 1.4Gb
 
 The table definition is
 mysql show columns from article;
 +---+--+--+-+-+---+
 | Field | Type | Null | Key | Default | Extra |
 +---+--+--+-+-+---+
 | ID| bigint(20)   | YES  | | NULL|   |
 | id2   | bigint(20)   | YES  | | NULL|   |
 | title | varchar(250) | YES  | | NULL|   |
 | body  | text | YES  | MUL | NULL|   |
 +---+--+--+-+-+---+
 4 rows in set (0.00 sec)
 
 I'm running this on linux redhat 7.3,  P500Mhz 512Mb ram  -- MySQL version 
 3.23.53a

Use MySQL-4.x

In 3.23 creating FULLTEXT index can easily take months, not hours.
In 4.0 this process is ~80-100 times faster.
 
Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   ___/

-
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: Extreme frustration with cryptic error messages

2003-02-17 Thread Sergei Golubchik

Hi!

On Feb 17, Brandon Young wrote:
 Hello, all.  I have been staring at this problem for an entire day. 
 Googling turns up very little in the way of helpful information for 
 solving my problem.

 I started a new tutorial, and ran into a problem.  When I attempt to add 
 a new database, I get the following error message: ERROR 1006: Can't 
 create database 'mydb'. (errno: 5).

 Googling turned up a very similar error, only it was errno: 28 instead 
 of errno: 5.  errno: 28 is related to disk space, but I have found 
 absolutely nothing on errno: 5.

Besides google there's also a manual ;o) that
describes a perror program from MySQL distribution.

% perror 5 28
Error code   5:  Input/output error
Error code  28:  No space left on device
serg:~ % 

So, indeed, error 28 could be a common case, but error 5 ?
'man errno' explains

  5 EIO Input/output error. Some physical input or output error occurred.
  This error will not be reported until a subsequent operation on
  the same file descriptor and may be lost (over written) by any
  subsequent errors.

If it won't ring any bells, try mysqld with strace to see what *exactly*
syscall caused errno 5.

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   ___/

-
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 Table locking

2003-02-17 Thread Rob

Hi all,

Can I just check, does MySql v.3.23.52 do table locking or row locking?  If
it only does table locking, are there any versions of mysql that do row
locking?

Thanks

---
Rob

**
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business Innovation
http://www.jamwarehouse.com
**



-
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 Table locking

2003-02-17 Thread Rob

Hi all,

Can I just check, does MySql v.3.23.52 do table locking or row locking?  If
it only does table locking, are there any versions of mysql that do row
locking?

Thanks

---
Rob

**
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business Innovation
http://www.jamwarehouse.com
**



-
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: Mysql Table locking

2003-02-17 Thread Zak Greant

On Mon, Feb 17, 2003 at 11:00:37AM +0200, Rob wrote:
 Hi all,
 
 Can I just check, does MySql v.3.23.52 do table locking or row locking?  If
 it only does table locking, are there any versions of mysql that do row
 locking?

  Detailed in the fine manual:
  http://www.mysql.com/search/index.php?q=locking

  Cheers!
-- 
Zak Greant [EMAIL PROTECTED]
  MySQL AB Community Advocate
  Personal Blog: http://zak.fooassociates.com

Managing MySQL
  MySQL Training: Washington DC, March 19-21, 2003
  Visit http://mysql.com/training for more information

-
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: Mysql Table locking

2003-02-17 Thread Alec . Cawley




 Can I just check, does MySql v.3.23.52 do table locking or row locking?
If
 it only does table locking, are there any versions of mysql that do row
 locking?

Always Read The Fine Manual:

From http://www.mysql.com/doc/en/Locking_methods.html:
Currently MySQL only supports table locking for ISAM/MyISAM and HEAP
tables, page-level locking for BDB tables and row-level locking for InnoDB
tables.

  Alec



-
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: Mysql Table locking

2003-02-17 Thread Rob

Thanks

It would appear that MySql does table locking.  Then I would like to ask the
following:

We have a documents table in our Document Management System, which obviously
gets used quite a
lot :-).  We're running stress tests on our application (which is a PHP,
Apache, MySql combo)
and we're finding that the database can't service requests when it comes to
the documents table.

The stress test approximatesw 30 users with a stress multiplier of three
(basically 90 users) who
both insert and query the database.  Would it be reasonable to assume that
when one insert occurs,
MySql locks the documents table, resulting in a backlog of queries for that
table?  From what I've read,
it would seem that SELECTS get a lower priority than INSERTS and UPDATES,
meaning that if all 30 users
insert into that table at the same time (given the way the stress test is
structured and the environment
the server will go into, this usage pattern will occur), any other select
queries simply get sent to the
back of the queue??

Does anyone have any suggestions here??

Thanks

---
Rob

**
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business Innovation
http://www.jamwarehouse.com
**


-Original Message-
From: Zak Greant [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 11:10 AM
To: Rob
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql Table locking


On Mon, Feb 17, 2003 at 11:00:37AM +0200, Rob wrote:
 Hi all,

 Can I just check, does MySql v.3.23.52 do table locking or row locking?
If
 it only does table locking, are there any versions of mysql that do row
 locking?

  Detailed in the fine manual:
  http://www.mysql.com/search/index.php?q=locking

  Cheers!
--
Zak Greant [EMAIL PROTECTED]
  MySQL AB Community Advocate
  Personal Blog: http://zak.fooassociates.com

Managing MySQL
  MySQL Training: Washington DC, March 19-21, 2003
  Visit http://mysql.com/training for more information

-
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



-
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: Mysql Table locking

2003-02-17 Thread Zak Greant

On Mon, Feb 17, 2003 at 11:22:27AM +0200, Rob wrote:
 Thanks
 
 It would appear that MySql does table locking.  Then I would like to
 ask the following:

  Hi Rob,

  I think that you missed some important details.
  
  Taken from the manual:
  MySQL only supports table locking for ISAM/MyISAM and HEAP tables,
  page-level locking for BDB tables and row-level locking for InnoDB
  tables. See section 5.3.1 How MySQL Locks Tables

  ...

 Does anyone have any suggestions here??

  - Ensure that the MyISAM tables are not fragmented. If a MyISAM table
is not fragmented, then INSERT and SELECT queries can run
concurrently without locking.

  - Switch to the InnoDB table type - it uses multi-versioning and fine
grained locking to improve concurrency.
  
  - Use replication to divide the reads and write between two servers
and reduce the lock contention.

Cheers!
-- 
Zak Greant [EMAIL PROTECTED]
  MySQL AB Community Advocate
  Personal Blog: http://zak.fooassociates.com

MySQL User Conference and Expo
  April 10-12, 2003, San Jose, California
  Visit http://mysql.com/training for more information

-
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

È«ÃæÖ§³ÖJSP/ASP/PHP/ASP.NETÆóÒµ½¨Õ¾¿Õ¼ä³ÏÑû´úÀí.

2003-02-17 Thread grace






È«ÃæÖ§³ÖJSP/ASP/PHP/ASP.NETÆóÒµ½¨Õ¾¿Õ¼ä³ÏÑû´úÀí.

ÎÒË¾ÍÆ³öÆóÒµ½¨Õ¾×¨ÓÃ¿Õ¼ä£¬È«ÃæÖ§³ÖJSP¡¢ASP¡¢PHP¡¢ASP.NET£¬ÏÖÕýÃæÏòÈ«¹ú¸÷µØ³ÏÑû´úÀí£¬ÀûÈó¿É´ï40%£¡

*ÉêÇëÊ±´´ÍøÂçµÄ´úÀí£¬³ýÁË¿ÉÒÔÏíÊÜÈ«·½Î»µÄ»¥ÁªÍø²úÆ··þÎñ£¬»¹¿ÉÒÔÃâ·Ñ»ñµÃÓòÃû¡¢¿Õ¼ä¡¢ÖÇÄÜ½¨Õ¾¡¢¶¯Ì¬IPµÈµÄÔÚÏß×¢²á´úÂë£¬·½±ãÄú¼°Ê±¿ªÕ¹ÒµÎñ¡£

*Ìá¹©ÏÈ½øµÄ´úÀí¹ÜÀíÆ½Ì¨£¬È«·½Î»µÄ¹ÜÀíÄúÉêÇëµÄËùÓÐ²úÆ·¼°×ÊÁÏ£¬°üÀ¨ÓòÃû¡¢¿Õ¼äÓÊÏä¡¢¶¯Ì¬IP¡¢ÖÇÄÜ½¨Õ¾¡¢ÍøÕ¾ÍÆ¹ãµÈµÈ¡£

*ÏµÍ³Ö÷»úÎ»ÓÚÖÐ¹úµçÐÅ³¬¼¶Êý¾Ý¸Û£¬¹ú¼Ò¼×¼¶»ú·¿£¬Í¨¹ý2XGE¹âÏËÖ±Á¬ChinaNET¹Ç¸ÉÍø£¬ÓÐÐ§±£ÕÏÍøÂçµÄÎÈ¶¨ÐÔºÍ¸ßËÙÐÔ¡£7*24Ð¡Ê±µÄ¼à¿Ø·þÎñ¼°ÏµÍ³ÓÅ»¯Î¬»¤£¬±£Ö¤ÁËÐéÄâÖ÷»úµÄ7*24µÄÔÚÏßÎÈ¶¨·ÃÎÊ¡£

Ìá¹©ÓòÃû×¢²á¡¢ÐéÄâÖ÷»ú¡¢ÖÇÄÜ½¨Õ¾¡¢¶¯Ì¬IP¡¢Í¨ÓÃÍøÕ¾ÔÚÏß×¢²áµÄ¿ìËÙÄ£°å£¬·½±ãÄú¿ªÕ¹ÒµÎñ£¡

ÉêÇë£ºhttp://www.pro.net.cn

²úÆ·ÓÅÊÆ¼°ÊÔÓÃÇë²Î¿¼ÒÔÏÂµÄÁ´½Ó¡£

1¡¢ÓòÃû£º¶ÀÌØµÄVDNS¿ÉÊÓ»¯ÓòÃû¹ÜÀíÏµÍ³ÈÃÄã³ÉÓòÃûÕæÕýµÄËùÓÐÕß£¬¿É×ÔÑ¡¹ÜÀíURL×ª·¢¼°URLÒþ±Î×ª·¢,AMXIPÖ¸ÏòµÈµÈ£¬²¢¿É²úÉú¶à¸ö´Î¼¶ÓòÃû£¬ÊµÏÖÒ»¸ö¶¥¼¶ÓòÃû½¨Á¢¶à¸öÍøÕ¾¡£¹¦ÄÜÑÝÊ¾:http://01isp.com/support/vdnsuse.net

2¡¢ÐéÄâÖ÷»ú£ºÈ«ÃæÖ§³ÖJSP¡¢PHP¡¢ASP.NETÐéÄâÖ÷»ú£¬ÖÐ¹úµçÐÅ2GÖ±½Ó½ÓÈëCHINANETÖ÷¸É!Ö§³Ö×î¸ß°æ±¾£¬¸ßËÙ¡¢ÎÈ¶¨£¡ÊÇ½¨Á¢ÆóÒµ¡¢¸öÈËÍøÕ¾µÄ×î¼ÑÑ¡Ôñ¡£Ìá¹©100MÊÔÓÃ¿Õ¼ä¡£ÉêÇë£ºhttp://01isp.com/host

3¡¢Êý¾Ý¿â£º¶àÖÖÖ§³Ö·½Ê½£Asp+Access¡¢Asp+sqlserver2000¡¢php/jsp+mysql¡¢php/jsp+sqlserver2000£¬»¶ÓÑ¡¹º¡£

4¡¢Í¨ÓÃÍøÖ·£ºCNNICÈÏÖ¤µÄ×¢²á»ú¹¹£¬Á¢¼´×¢²áÁ¢¿ÌÉúÐ§£¬Ìá¹©È«ÃæµÄÍ¨ÓÃÍøÖ·ÐÅÏ¢¹ÜÀíºóÌ¨¡£ÉêÇëÊÔÓÃ10Ìì£ºhttp://01isp.com/CNAddress

5¡¢ËÑË÷ÒýÇæ£ºÐÂÀË¡¢ËÑºü¡¢ÍøÒ×¡¢°Ù¶ÈÒýÇæµÇÂ¼£¬²»·Ñ´µ»ÒÖ®Á¦ÈÃÄúµÄ¹Ë¿ÍÕÒµ½Äú¡£ÉêÇë£ºhttp://01isp.com/promote

6¡¢·±¼òÍ¨£ºÊµÏÖ·±Ìå¡¢¼òÌåÁ½¸ö°æ±¾ÄÚÈÝ¡¢Êý¾Ý¿â×Ô¶¯»¥»»£¬¿ÉÃâ·ÑÊÔÓÃ£¡

7¡¢¶¯Ì¬IP:ÅäºÏÎÒÃÇµÄVDNS¶¯Ì¬ÓòÃû¼¼Êõ£¬°ÑÍøÕ¾·ÅÔÚ×Ô¼º¼ÒÖÐ¡£

ÑÝÊ¾£ºhttp://01isp.com/support/vdnsusex.net
ÉêÇë£ºhttp://01isp.com/cyberip

8¡¢ÖÇÄÜ½¨Õ¾£ºÈý·ÖÖÓ½¨Á¢ÄúµÄÍøÕ¾£¬ºÃÓÃ¼òµ¥·½±ã¡£¿ÉÃâ·ÑÊÔÓÃ15Ìì¡£ÉêÇëÊÔÓÃ£ºhttp://01isp.com/auto

´úÀíÒµÎñÆ½Ì¨Çë¼û£ºhttp://www.pro.net.cn¡¡

£ £ Ê±´´ÍøÂç×÷ÎªCNNICµÄÈÏÖ¤»ú¹¹£¬ÍÆ³öÐéÄâÖ÷»ú¡¢ÉÁËÙÓÊ¾Ö¡¢ÓòÃû×¢²á¡¢ÖÇÄÜ½¨Õ¾¡¢Í¨ÓÃÍøÖ·¡¢´úÀíÒµÎñÒ»ÌõÁú·þÎñ£¡

£ £ ÎÒÃÇÌá¹©µÄ·þÎñ×¨Òµ¡¢¿ìËÙ¡¢¿É¿¿£¬Ë«Ö¤ÈÏ¿É£¬¾ø¶Ô¿É¿¿£¬ÊÊºÏ¸ü×¨ÒµµÄÄú£¡

·þÎñÆ÷×âÓÃ£¬ºÃÅäÖÃ£¬µÍ¼Û¸ñhttp://idc.now.net.cn,Äê¸¶ÃâÁ½¸öÔÂ¡£

³ÏÑû¹ã¸æºÏ×÷»ï°é¡£

Öéº£Ê±´´ÍøÂç
http://www.01isp.com
0756--2125593212552321255832125563
´«Õæ£º0756--2229669
ÓÊ¼þÖ§³Ö:[EMAIL PROTECTED]
OICQ·þÎñ£º153203366¡¢108786612
¿Í»§·þÎñ£ºÐÇÆÚÒ»µ½ÐÇÆÚÈÕ
¡ïÓÊ¼þ²ÉÓÃ¹ú¼ÊÉÌÎñ¿ì³µ·¢ËÍ,½âÊÍÈ¨Êô·¢¼þÈËËùÓÐ¡£¡ï½ö¹©ºÏ·¨ÓÃÍ¾,Èí¼þÔÚÏßQQ:21677192 http://55028.126.com


-
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: Mysql Table locking

2003-02-17 Thread Alec . Cawley




It would appear that MySql does table locking.  Then I would like to ask
the
following:

 From what I've read,
 it would seem that SELECTS get a lower priority than INSERTS and UPDATES,
 meaning that if all 30 users
 insert into that table at the same time (given the way the stress test is
 structured and the environment
 the server will go into, this usage pattern will occur), any other select
 queries simply get sent to the
 back of the queue??

The LOW_PRIORITY modifier puts INSERTS and UPDATES behind SELECTS.
There are caveats about usew with MyISAM tables: it disables concurrent
inserts,
which can occur on non-fragmented tables. However, it sounds as if your
table is
going to be fragmented.

  Alec




-
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

Bug? Update on 3 tables crashes in InnoDB

2003-02-17 Thread Martin Thoma

Can somebody confirm this please?

Martin

Subject: UPDATE over 3 tables crashes in InnoDB

Description:
I have 3 InnoDB-tables with about 6000 records each:
customer 1:n orders 1:n invoices

When trying to make the following update:

update customer, orders, invoices set customer.locked=1 WHERE
invoices.id=1234 AND
invoices.order=orders.id AND
orders.customer=customer.id;

the database crashes with:
mysqld-nt: ready for connections.
Version: '4.0.10-gamma-nt'  socket: ''  port: 3302
030217 11:48:47  InnoDB: Assertion failure in thread 1428 in file
D:\mysql-4.0.10-gpl\innobase\btr\btr0pcur.c line 203
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
InnoDB: Thread 1460 stopped in file 
D:\mysql-4.0.10-gpl\innobase\sync\sync0arr.c line
126
InnoDB: Thread 1164 stopped in file D:\mysql-4.0.10-gpl\innobase\os\os0sync.c 
line 150

How-To-Repeat:
Build a table with 6000 customers, each with one order and one invoice. Then 
just
repeat the UPDATE above.

Fix:


Synopsis:   Update over 3 tables crashes in InnoDB
Submitter-Id:   
Originator: martin thoma
Organization:
MySQL support:  [none]
Severity:   [serious]
Priority:   [medium]
Category:   [mysqld]
Class:  [sw-bug]
Release:4.0.10-gamma

Exectutable:   [mysqld-nt]
Environment:   AMD XP1800+, 512 MB, 80 GB HDD
System:Win200 Prof.
Compiler:  VC++ 6.0
Architecture:  i


-
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: How to move database from one directory to another

2003-02-17 Thread Diana Soares

Hi,
If you only want to move database Protein (and not all your databses)
you can use symbolic links to do that. 
You can move your database to the desired path (external drive) and
create a symbolic link in /var/lib/mysql/ to it like:
localhost:/var/lib/mysql#  ln -s /desired_path/Protein Protein
Remember that /desired_path/Protein should be owned by mysql user..

Otherwise, if you want to move all databases, change the datadir of
mysqld. You can do that starting mysqld with --datadir=desired_path or
add datadir=desired_path to your /etc/my.cnf file in the [mysqld]
section. 

See:
http://www.mysql.com/doc/en/Configuring_MySQL.html
http://www.mysql.com/doc/en/Symbolic_links.html


On Sun, 2003-02-16 at 18:44, Liu, Zhu wrote:
 Hi, everybody, I have installed the mysql server in /var/lib/mysql and 
 created my database Protein under the this path as required in mysql
and linux(the operationg system is linux). But the problem is the space
for /var is not enough, there exists an exteral driver to try to solve
this problem.  My question is how to move my database Protein into the
exteral driver so I later can use the database in external driver
instead of current database? Do I need change mysql server from
/var/lib/mysql to new external drive? Any other thing I need care about?
I look at the command mysqlhotcopy which only can copy existing database
for backup purpose not for working database? Anybody know how to do it?
Thanks a lot!

 zhu liu
 
-- 
Diana Soares


-
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: Need Distinct and Min...

2003-02-17 Thread Roger Baklund

* Lewis Watson
 I have a table with three fields. In the first field I have a range of
 numbers 1-20; all repeated more than once. In the third field I have a
 number ranging from 1 to 20 in each row. I need to choose the
 lowest amount in the third column for each distinct value in the fist
 column. Will someone help me out with this query?

Maybe I am misinterpreting your question, because this seems like a standard
GROUP BY query creating some test data:

use test;
create table lewis (f1 int,f2 int,f3 int);
insert into lewis values (1,0,1);
insert into lewis values (1,0,10001);
insert into lewis values (2,0,10021);
insert into lewis values (2,0,10022);
insert into lewis values (3,0,10032);
insert into lewis values (3,0,10033);

mysql select * from lewis;
+--+--+---+
| f1   | f2   | f3|
+--+--+---+
|1 |0 | 1 |
|1 |0 | 10001 |
|2 |0 | 10021 |
|2 |0 | 10022 |
|3 |0 | 10032 |
|3 |0 | 10033 |
+--+--+---+
6 rows in set (0.00 sec)

mysql select f1,min(f3) from lewis group by f1;
+--+-+
| f1   | min(f3) |
+--+-+
|1 |   1 |
|2 |   10021 |
|3 |   10032 |
+--+-+
3 rows in set (0.09 sec)

Is this what you wanted?

Some related links:

URL: http://www.mysql.com/doc/en/example-Maximum-column-group.html 
URL: http://www.mysql.com/doc/en/Group_by_functions.html 
URL: http://www.mysql.com/doc/en/example-Maximum-column-group-row.html 

--
Roger


-
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: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.

2003-02-17 Thread Benjamin Pflugmann

On Mon 2003-02-17 at 03:38:07 -0600, [EMAIL PROTECTED] wrote:
 Reply when you have a job, dumbass.
 I have a system that makes more in a week than you make in a year
 crashing because of this buggy piece of shit.

If a system supposedly making millions a year is unstable you are a
fool that you haven't solved it already using your advanced support
contract (http://www.mysql.com/support/), that you surely have.

 I don't give a rats ass what your worthless opinion on my post is.
 Now fuck off, dumbass.

Yeah. That lack of respect is exactly why I refused to read your
original post about the problem to the end. As I said, that is a list
of volunteers and your attitude surely doesn't help you to get answers.

Bye,

Benjamin.


 - Original Message -
 From: Benjamin Pflugmann [EMAIL PROTECTED]
 To: Jason Maskell [EMAIL PROTECTED]
 Sent: Monday, February 17, 2003 3:35 AM
 Subject: Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.
 
 
  On Mon 2003-02-17 at 02:40:57 -0600, [EMAIL PROTECTED] wrote:
   Oh grow up.
 
  Exactly the kind of reply I expected from you.
 

-- 
[EMAIL PROTECTED]

-
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: CREATE INDEX is sooo slow! any ideas?

2003-02-17 Thread Michael T. Babcock

Sergei Golubchik wrote:


Which decision, putting all the indexes in one file, or rebuilding all
indexes whenever you ALTER TABLE or add an index?  If the latter, I
agree with you.  Modifying unrelated indexes or columns should not
force a rebuild of every index.
   


Of course not.
And it won't eventually - it's in the todo.




Wow, I love this list (and the MySQL team).  Go to bed with a question, 
wake up with an answer.

Well, in EST5EDT at least.  Thanks.

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
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: auto_increment every year

2003-02-17 Thread alx

On Mon, 2003-02-17 at 12:57, [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,queries,smallint
 
 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:
 
 HI all
 I'm searching in how to generate a auto_increment number starting form 1
 every year
 I mean
 
 ID DATE
 1  2003
 2  2003
 
 1  2004
 2  2004
 etc
 maybe possible or I've to use some c code to make it possible ?
 
 TIA
 Alx
 -- 
 int a=1,b,c=2800,d,e,f[2801],g;main(){for(;b-c;) f[b++]=a/5;
 for(;d=0,g=c*2;c-=14,printf(%.4d,e+d/a),e=d%a)for(b=c;d+=f[b]*a,
 f[b]=d%--g,d/=g--,--b;d*=b);}
 
 
-- 
int a=1,b,c=2800,d,e,f[2801],g;main(){for(;b-c;) f[b++]=a/5;
for(;d=0,g=c*2;c-=14,printf(%.4d,e+d/a),e=d%a)for(b=c;d+=f[b]*a,
f[b]=d%--g,d/=g--,--b;d*=b);}


-
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: Query relational tables

2003-02-17 Thread Roger Baklund

* Dee
 I have a table that contains ids for several other tables.  Setup is as
 followed:

 +--+--+--+-+-+
 +
 | Field| Type | Null | Key | Default | Extra
 |
 +--+--+--+-+-+
 +
 | id   | int(11)  |  | PRI | NULL|auto_increment |
 | title| varchar(100) | YES  | | NULL|
 |
 | rateID   | int(10) unsigned | YES  | | NULL|
 |
 | actorID  | int(10) unsigned | YES  | | NULL|
 |
 | actor2ID | int(10) unsigned | YES  | | NULL|
 |
 | actor3ID | int(10) unsigned | YES  | | NULL|
 |
 +--+--+--+-+-+
 +

 +-+--+--+-+-++
 | Field   | Type | Null | Key | Default | Extra  |
 +-+--+--+-+-++
 | actorID | int(10) unsigned |  | PRI | NULL| auto_increment |
 | first   | varchar(20)  | YES  | | NULL||
 | middle  | varchar(20)  | YES  | | NULL||
 | last| varchar(20)  | YES  | | NULL||
 +-+--+--+-+-++

 +--+--+-+-++
 | Field  | Type | Null | Key | Default | Extra  |
 ++--+--+-+-++
 | rateID | int(10) unsigned |  | PRI | NULL| auto_increment |
 | rating | varchar(15)  | YES  | | NULL||
 ++--+--+-+-++


 How can I query the movie tables so that it will get the names of the
 actors when each actor field may have a different name or may be null?

 I am unable to query on more than one actor.

Two things to remember:

- When you need to join the same table multiple times in the same query, you
have to use aliases for the table name.

- When there could be no row found for a join, but you still want a result
row, you need to use LEFT JOIN.

Try this:

SELECT title,a1.last,a2.last,a3.last
  FROM movie
  LEFT JOIN actor a1 ON
a1.actorID = movie.actorId
  LEFT JOIN actor a2 ON
a2.actorID = movie.actor2Id
  LEFT JOIN actor a3 ON
a3.actorID = movie.actor3Id

HTH,

--
Roger


-
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: mysql shutdown hangs-solaris

2003-02-17 Thread Sunil Gavaskar

Anybody can help this???

thanks
regards
sunil


  Hi,
I am facing mysql shutdown process hanging problem on Solaris 5.8, 
mysql 3.23.40

I am running our product Web NMS which uses MySQL DB,  on solaris 
machine.
While shutting down the application, except MySQL process, all other 
process are killed
and the application hangs.

On analysis I found that, mysqladmin -h localhost shutdown is hanging.

*But when I tried to take the dump, the process (mysqladmin -h 
localhost shutdown) gets killed.
*Kindly provide us the cause of the problem.

Herewith I have attached the files,
ps_before_shutdown.txt- Processes list before shutting down the Web NMS 

bash-2.03$ ps -aef|grep -i telesyn
   root  1541  1524  0   Feb 11 pts/57:25 
/opt/TelesynNMSBeta/jre1.4/bin/rmiregistry 1099
   root  1524  1516  0   Feb 11 pts/5   93:12 
/opt/TelesynNMSBeta/jre1.4/bin/java -cp 
/opt/TelesynNMSBeta/classes::/opt/Teles
 hmgaya   450   410  0   Feb 10 pts/20:00 /usr/dt/bin/sdt_shell 
-c  unset DT; DISPLAY=atn65.telesyn.corp:0;  
 hmgaya   452   450  0   Feb 10 pts/20:00 -bash -c  unset 
DT; DISPLAY=atn65.telesyn.corp:0;   /usr/dt/bin/
 nobody  1548  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1544  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1549  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
   root  1539  1526  0   Feb 11 pts/5   223:56 
/opt/TelesynNMSBeta/mysql/bin/mysqld -Sg 
--basedir=/opt/TelesynNMSBeta/mysql --
 nobody  1546  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1545  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
   root  1543 1  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1551  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1568  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1569  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1570  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1571  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
bash-2.03$


ps_during_hang.txt- Processes list while application is hanging 


bash-2.03$ ps -aef|grep -i telesyn
   root  1524  1516  2   Feb 11 pts/5   93:14 
/opt/TelesynNMSBeta/jre1.4/bin/java -cp 
/opt/TelesynNMSBeta/classes::/opt/Teles
 hmgaya   450   410  0   Feb 10 pts/20:00 /usr/dt/bin/sdt_shell 
-c  unset DT; DISPLAY=atn65.telesyn.corp:0;  
 hmgaya   452   450  0   Feb 10 pts/20:00 -bash -c  unset 
DT; DISPLAY=atn65.telesyn.corp:0;   /usr/dt/bin/
 nobody  1548  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1544  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1549  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1546  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1545  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
   root  1543 1  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1551  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1568  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1569  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1570  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
 nobody  1571  1543  0   Feb 11 ?0:00 
/opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f 
conf/http
   root  3769  1524  0 15:47:13 pts/50:00 
/opt/TelesynNMSBeta/mysql/bin/mysqladmin -u root -h localhost shutdown
   root  3768  3766  2 15:46:56 pts/40:04 
/opt/TelesynNMSBeta/jre1.4/bin/java 
com.adventnet.launcher.nms.ShutdownServer -
bash-2.03$



ps_after_ctrl_backslash.txt- Processes list after taking the  dump(dump). 

bash-2.03$ ps -aef|grep -i telesyn
 hmgaya   450   410  0   Feb 10

SSL connection from client

2003-02-17 Thread Maciej Bobrowski


Hi,

I have installed the 4.0.10-gamma with support from the openssl v. 0.9.7
on the Debian Woody:

mysqlstatus
...
SSL:Cipher in use is DHE-RSA-AES256-SHA
...

mysqlshow variables like '%openssl%';
+---+---+
| Variable_name | Value |
+---+---+
| have_openssl  | YES   |
+---+---+

O.K. when I want to connect to mysql from console I simply write
mysql --defaults-file=/./openssl/my.cnf -u root -p test
and I can log on (in the my.cnf there are definitions of the keys and
certificates for [client] and for [mysqld]):

But I would like to:

 - each client from any IP used SSL connection. Now when I use for example
   simple php program, it needs only the host,user,password and
   database_name. There is not any SSL connection between the user from
   a client and my mysql server with support from SSL.
   I have also a java program, which also doesn't need anything more then
   host,user,password and database_name to connect to data base.
   How can I do it? What the client has to know and/or have?
   Maybe something in the 'user' table in the mysql database and
   an access to files with the keys and certificates?

 - watch how many SSL connections were established.

 - make that some of users will not have to use SSL to connect to data
   base ( actually it is inconsistent with the 1-st point :) )

O.K. Can anybody help me?

Best regards,

Maciej Bobrowski



-
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: mysql shutdown hangs-solaris

2003-02-17 Thread Jerry

On Solaris I always use :

/etc/rc3.d/S99mysqld stop
/etc/rc3.d/S99mysqld start

Jerry

- Original Message -
From: Sunil Gavaskar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Sinisa Milivojevic [EMAIL PROTECTED]
Sent: Monday, February 17, 2003 2:50 PM
Subject: Re: mysql shutdown hangs-solaris


 Anybody can help this???

 thanks
 regards
 sunil

Hi,
  I am facing mysql shutdown process hanging problem on Solaris 5.8,
  mysql 3.23.40
 
  I am running our product Web NMS which uses MySQL DB,  on solaris
  machine.
  While shutting down the application, except MySQL process, all other
  process are killed
  and the application hangs.
 
  On analysis I found that, mysqladmin -h localhost shutdown is hanging.
 
  *But when I tried to take the dump, the process (mysqladmin -h
  localhost shutdown) gets killed.
  *Kindly provide us the cause of the problem.
 
  Herewith I have attached the files,
  ps_before_shutdown.txt- Processes list before shutting down the Web NMS

 bash-2.03$ ps -aef|grep -i telesyn
 root  1541  1524  0   Feb 11 pts/57:25
 /opt/TelesynNMSBeta/jre1.4/bin/rmiregistry 1099
 root  1524  1516  0   Feb 11 pts/5   93:12
 /opt/TelesynNMSBeta/jre1.4/bin/java -cp
 /opt/TelesynNMSBeta/classes::/opt/Teles
   hmgaya   450   410  0   Feb 10 pts/20:00 /usr/dt/bin/sdt_shell
 -c  unset DT; DISPLAY=atn65.telesyn.corp:0;
   hmgaya   452   450  0   Feb 10 pts/20:00 -bash -c  unset
 DT; DISPLAY=atn65.telesyn.corp:0;   /usr/dt/bin/
   nobody  1548  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1544  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1549  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
 root  1539  1526  0   Feb 11 pts/5   223:56
 /opt/TelesynNMSBeta/mysql/bin/mysqld -Sg
 --basedir=/opt/TelesynNMSBeta/mysql --
   nobody  1546  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1545  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
 root  1543 1  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1551  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1568  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1569  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1570  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1571  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
 bash-2.03$

 
  ps_during_hang.txt- Processes list while application is hanging


 bash-2.03$ ps -aef|grep -i telesyn
 root  1524  1516  2   Feb 11 pts/5   93:14
 /opt/TelesynNMSBeta/jre1.4/bin/java -cp
 /opt/TelesynNMSBeta/classes::/opt/Teles
   hmgaya   450   410  0   Feb 10 pts/20:00 /usr/dt/bin/sdt_shell
 -c  unset DT; DISPLAY=atn65.telesyn.corp:0;
   hmgaya   452   450  0   Feb 10 pts/20:00 -bash -c  unset
 DT; DISPLAY=atn65.telesyn.corp:0;   /usr/dt/bin/
   nobody  1548  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1544  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1549  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1546  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1545  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
 root  1543 1  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1551  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1568  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1569  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1570  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http
   nobody  1571  1543  0   Feb 11 ?0:00
 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f
 conf/http

Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.

2003-02-17 Thread Benjamin Pflugmann


On Mon 2003-02-17 at 12:14:12 +0100, [EMAIL PROTECTED] wrote:
[...]

Please disregard this mail. It was not supposed to go to the list.
(forgot to remove the CC that my mailer is set up to automatically
append for mails going to my -mysql address).

My apologies about that, Jason.

Bye,

Benjamin.

-- 
[EMAIL PROTECTED]

-
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: How to write delete query??

2003-02-17 Thread Joe Stump

What you have there is a subselect, which are not supported in mysql 3.2x,
but I *believe* are supported in 4.0+ (gamma and 4.1alpha). Don't take my
word for it and check the docs first.

--Joe


--
Joe Stump [EMAIL PROTECTED]
http://www.joestump.net
Label makers are proof God wants Sys Admins to be happy.

-Original Message-
From: Inandjo Taurel [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 6:35 AM
To: [EMAIL PROTECTED]
Subject: How to write delete query??


SQL SQL
hi all,
i have a query that works just fine on Dbase, but just crashes on mysql.
How can i write it in one statement for it to work both on Dbase and mysql?


the query:
- delete from table1 where table1.field1 in (select distinct field2 from
table2).

Thanx


_
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus


-
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



-
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: How to write delete query??

2003-02-17 Thread Inandjo Taurel

thanx joe, i checked.
I just thought that there could be a way around this problem!








From: Joe Stump [EMAIL PROTECTED]
To: Inandjo Taurel [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: How to write delete query??
Date: Mon, 17 Feb 2003 09:46:53 -0800
MIME-Version: 1.0
Received: from mail4.mxpath.net ([130.94.106.86]) by 
mc5-f9.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 17 Feb 
2003 06:41:02 -0800
Received: by mail4.mxpath.net (Postfix, from userid 89)id ACE4113BA62; Mon, 
17 Feb 2003 06:35:30 + (GMT)
Received: (qmail 21374 invoked from network); 17 Feb 2003 06:35:28 -
Received: from web.mysql.com (213.136.49.183)  by 130.94.106.86 with SMTP; 
17 Feb 2003 06:35:28 -
Received: (qmail 30777 invoked by uid 7797); 17 Feb 2003 14:40:03 -
Received: (qmail 30759 invoked from network); 17 Feb 2003 14:40:02 -
X-Message-Info: dHZMQeBBv44lPE7o4B5bAg==
Delivered-To: [EMAIL PROTECTED]
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm 
(http://www.ezmlm.org)
List-ID: mysql.mysql.com
Precedence: bulk
List-Help: mailto:[EMAIL PROTECTED]
List-Unsubscribe: 
mailto:[EMAIL PROTECTED]
List-Post: mailto:[EMAIL PROTECTED]
List-Subscribe: mailto:[EMAIL PROTECTED]
Delivered-To: mailing list [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
In-Reply-To: [EMAIL PROTECTED]
Importance: Normal
X-MxUser: [EMAIL PROTECTED]
X-MxHost: [EMAIL PROTECTED]
X-MxDest:Maildir
Return-Path: 
X-OriginalArrivalTime: 17 Feb 2003 14:41:03.0057 (UTC) 
FILETIME=[986BDC10:01C2D692]

What you have there is a subselect, which are not supported in mysql 3.2x,
but I *believe* are supported in 4.0+ (gamma and 4.1alpha). Don't take my
word for it and check the docs first.

--Joe


--
Joe Stump [EMAIL PROTECTED]
http://www.joestump.net
Label makers are proof God wants Sys Admins to be happy.

-Original Message-
From: Inandjo Taurel [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 6:35 AM
To: [EMAIL PROTECTED]
Subject: How to write delete query??


SQL SQL
hi all,
i have a query that works just fine on Dbase, but just crashes on mysql.
How can i write it in one statement for it to work both on Dbase and mysql?


the query:
- delete from table1 where table1.field1 in (select distinct field2 from
table2).

Thanx


_
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus


-
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



-
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



_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail


-
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: How to write delete query??

2003-02-17 Thread Stefan Hinz

Inandjo,

 - delete from table1 where table1.field1 in (select distinct field2 from
 table2).

Subselects (or nested queries) like that are supported as of MySQL
4.1. At this moment, you will have to compile 4.1 yourself; it's
expected to be out as a binary version in the next couple of weeks.
The most recent binary distribution is 4.0.10, just to make sure you
don't mix up version numbers ;)

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-
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: How to write delete query??

2003-02-17 Thread Bill Kratochvil

 Inandjo 
- delete from table1 where table1.field1 in (select distinct field2 from
table2)


From what I've read subqueries are not yet supported.   We worked around
this by converting the distinct list to a comma delimited list of
values. E.g.,


:

*- Create a delimited list of field1 from table1
lcDelimitedList = goQCApp.p_oFunc.m_CreateList(table1,field1)

*- Build our query string
sqlString = Delete from table1 where table.field1 in ( +
lcDelimitedList + )

*- Execute query string
If !goQCApp.m_SqlExec(sqlString)
return messagebox(Rutt, row Query Failed
=+sqlString,16,ABORTED)=6
endif


:

Note that where MySql is happy with both double and single quotes (for
strings), Microsoft Sql Server chokes on double quotes; we found it best
to use single quotes.

We're in the midst of our conversion (from Visual Foxpro to MySql/Sql
backend) and have not yet seen a limitation in using this approach.

- Bill K.


-Original Message-
From: Inandjo Taurel [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 17, 2003 8:35 AM
To: [EMAIL PROTECTED]
Subject: How to write delete query??


SQL SQL
hi all,
i have a query that works just fine on Dbase, but just crashes 
on mysql.
How can i write it in one statement for it to work both on 
Dbase and mysql?


the query:
- delete from table1 where table1.field1 in (select distinct 
.

Thanx


_
MSN 8 with e-mail virus protection service: 2 months FREE* 
http://join.msn.com/?page=features/virus


-
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




-
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

How to delete from only one side of a join?

2003-02-17 Thread Mayo, Chuck

Hi all,

Just jumped on the list, hoping someone can give me a hand. The query below
uses a join, I guess, to select records from table stat_1_1 based on
information in table stat. I'd like to be able to turn this query into a
delete query but only want records removed from stat_1_1. Can anyone tell me
how? I must be missing something really obvious.

Thanks,
Chuck Mayo

 SELECT DISTINCT
stat_1_1.event_id

 FROM
stat_1_1,
stat

 WHERE
stat_1_1.player_id=39
 stat_1_1.stat_id = stat.id
 stat.stat_group = Individual


-
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

2003-02-17 Thread cf

mysql:ÄúºÃ!

Èç¹ûÄãÏÖÔÚÏëÕõÇ®µÄ»°£¬http://platinum-mails.ebiz-enterprises.com/?r=chenggong´ò¿ªºó×¢²á£¬×¢²áÓÐ$50£¬Ã¿½éÉÜÒ»Î»ÓÐ$15,$200Æð¸¶


[×¢Òâ]Òª×¬Ç®¾Í¿´°¡~ºÃ¶«Î÷~
×¬Ç®µÄºÃ·½·¨£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡ 
²»ÂÛÄãÐÅ²»ÐÅ¶¼²»·ÁÊÔÊÔ°É 
·´Õý¶ÔÄãÃ»ËðÊ§¡£Ö»ÒªÄãÓÐÌ¨µçÄÔ£¬ÄÜ¹»ÉÏÍø¾ÍÐÐ¡£¶øÇÒÕâÖÖ·½·¨²»»áÕ¼ÓÃÄãÌ«¶àµÄÊ± 
¼äµ«Ò²²»»áÓÐÁ¢¸Ë¼ûÓ°µÄÐ§¹û£¬ÈÃÎÒÒ²¸æËßÄãÔõÃ´°ì°É¡£±¾À´ÎÒÒ²²»ÏàÐÅµÄ£¬µ«ÎÒÊÔ¹ý 
Ö®ºó£¬ÊÇÕæµÄÄÜ×¬µ½Ç®£¬ÎÒ¾Í×¬µ½ÁË300¶àÃÀ½ð¡£ÒòÎª±¾ÒâÊÇÊÔÊÔ°ÕÁË£¬ÊÔÁËÒ»¸öÔÂ£¬Ã» 
ÓÐ×ÅÁ¦È¥·¢±í¶àÉÙ£¬ËùÒÔ²Å300ÃÀ½ð¡£µ«300¶àÃÀ½ðÒÑ¾ÓÐÈËÃñ±Ò2000¶àÁË£¬¹þ¹þ£¡ºóÀ´ÎÒ 
¾ÍÓÖ·¢±íÁËºÃ¶à£¬×¬µÃÒ²¶à¡£  
   ÄÑµÀÌìÏÂ¾¹ÓÐÃâ·ÑµÄÎç²Í£¿´ð°¸ÊÇ--Ã»ÓÐ.ËùÒÔÓÐºÜ¶àÈË¾Í»á²»ÏàÐÅÎÒÕâÀïËùÐ´µÄ»°£¬Òò 
´Ë£¬ÎÒÌØµØÔÚÕâÀï×¢Ã÷Ò»ÏÂ£ºÕâ²»ÊÇÃâ·ÑµÄ£¬µ«Ò²²»ÓÃ½»Ç®ºÍÊ²Ã´µÄ£¬Ö»ÒªÎªÕâ¸öÍøÕ¾½é 
ÉÜºÍÕÐÈË¼ÓÈë¡£ÕâÐ©¾ÍÊÇ¹¤×÷£¬Õâ¾ÍÊÇ×¬Ç®¡£ 
ÎªÊ²Ã´ÄÜ×¬Ç®ÄØ£¿ÀíÓÉºÜ¼òµ¥£¬ÎÒÃÇ 
°ïÕâ¸öÍøÕ¾×÷¹ã¸æ¡¢Ðû´«³öÈ¥£¬ÄÇ¾ÍÓÐÈËÀ´Õâ¸öÍøÕ¾ä¯ÀÀ£¬ÄÇÉêÇë¼ÓÈëµÄÈËÒ²¾ÍÔ½À´Ô½¶à 
£¬Õâ¸öÍøÕ¾¾ÍÐËÍúÆðÀ´ÁË¡£ÕâÊÇËüËùÏ£ÍûºÍ»¶ÓµÄ£¬Ëü¾ÍÒª½±ÀøÄã£¡Ã¿¼ÓÈëÒ»¸öÈËÓÐ15ÃÀ½ð¡£ 
ÔõÃ´ÄÜ¹»×¬Ç®ÄØ£¿¼ÓÈëÁË»áÔ±ºó£¬Òª¶à·¢±í£¬¾ÍÄÜ¹»×¬Ç®¡£ÔõÃ´·¢±íÄØ£¿¾Í 
ÊÇ°Ñ±¾ÎÄ¸´ÖÆ£¬È»ºóµ½¸÷¸öÍøÕ¾µÄÁôÑÔ°æÉÏÕ³Ìù·¢±íÐû´«¡£ÓÐÈË¼ÓÈëÁË£¬Äã¾ÍÓÐÇ®×¬ÁË£» 
¼ÓÈëµÄÈËÔ½¶à£¬Äã×¬µÄÇ®Ò²Ô½¶à¡£
ÄÑÒÔÖÃÐÅ°¡£¡ÌìÏÂÄÄÓÐÃâ·ÑµÄÎç²Í£¿£¡(ºóÀ´²ÅÅªÇåÊÇ¹ã¸æÉÌÂòµ¥)±¾À´ÎÒÒ²ÊÇ²»ÏàÐÅµÄ£¬¿É´ô×ÅÊµÔÚÊÇÎÞÁÄ°¡¡£·´ÕýÏÐ×ÅÒ²ÊÇÏÐ×Å£¡µ«ÎÒµÄÉí·ÝÊÇ²»ÄÜ
 
¹»Ð¹Â¶¸øÍâÈËµÄ£¬µ±È»Éí·ÝÖ¤ºÅÂë¡¢ÊÖ»úºÅÂë(ÒòÎª»ØµçÊÇÒª¸¶Ç®µÄàÞ)¡¢ÐÅÓÃ¿¨ºÅÂëµÈµÈÖØÒªÐÅÏ¢¶¼²»ÄÜÐ¹Â¶µÄàÞ¡£ÓÚÊÇÕÒÁËÒ»¸ö²»ÒªÉí·ÝÖ¤¡¢²»Òª»áÔ±·Ñ£¬Ö»ÒªÓÐ¸öµØÖ·¡¢µç
 »°ºÅÂë¾ÍÄÜÕõµ½Ç®µÄÍøÕ¾£¬ÉêÇë³ÉÁË»áÔ±¡¡(·´ÕýÕõ²»µ½Ç®Ò²²»»á³Ô¿÷£¬ºß!)µÈÁËÒ» 
¸öÔÂ£¬Ê²Ã´»ã¿îµ¥£¿Á¬¸öÓ°×Ó¶¼Ã»ÓÐ£¡²»¹ýÒ»Ïë£¬ÎÞËùÎ½ÁË£¬·´ÕýÒ²Ã»³Ô¿÷!¾Íµ±ÊÇ¹íÃÔ 
ÐÄÇÏÒ»»Ø°É!--¹þ¹þ! ¿ÉÒ»Ö±µ½ÁËµÚ¶þ¸öÔÂ¡¡ 
Í»È»£¬»ã¿îµ¥µ½ÁË!²»¿´²»ÖªµÀ 
£¬Ò»¿´ÏÅÒ»Ìø£¡--300¶àÃÀ½ð£¿ÕÛºÏÈËÃñ±Ò²»¾ÍÊÇ2000¶àÁËÂð£¿ 
°ëÐÅ°ëÒÉ¡£µ½ÁËÒøÐÐ £¬½»ÁË¼¸Ê®ÔªµÄÊÖÐø·Ñ£¬»»»ØÁË2000¶à!ÕæÏñ×öÃÎÒ»Ñù¡¡ 
ÂòÁËÒ»Ð©Ò»Ö±ÏëÂòµÄ¶«¶«£¬ÕâÊ±ÎÒ²ÅÈ·ÐÅ²»ÒÉ¡£ÐË·ÜÖ®Óà£¬ÓÖ¿ªÊ¼ÁËÎÒµÄÐû´«¡£²»ÊÇÐû´«µÃÔ½¶à£¬ÕõµÄÒ²¾ÍÔ½¶àÂð?
  
¡¡ Äã²»ÐÅ£¿ÄÇÃ»°ì·¨£¡Ö»¿ÉÏ§Õâ°×»¨»¨µÄÒø×Óà¶¡£ 
²»¹ý£¬¹ÅÈËÔÆ£º¡°Äþ¿ÉÐÅÆäÓÐ£¬ 
²»¿ÉÐÅÆäÎÞ¡±°¡£¡ ·´ÕýÒ²²»³Ô¿÷£¬¾Íµ±·èÒ»»ØÊÔÊÔ¿´Âï£¡ ÏàÐÅÎÒ£¬Ã»´íµÄ£¡ 
¼ÓÈë·½·¨ºÜ¼òµ¥µÄÅ¶£º ; http://platinum-mails.ebiz-enterprises.com/?r=chenggong 
½øÈëÉÏÃæÍøÕ¾£¨ÈçÈôµã»÷²»³É£¬¸´ÖÆ¡¢Õ³Ìùµ½µØÖ·À¸¡£ÓÐÊ±ºò½ø²»È¥£¬ÄÇÊÇÒòÎª·þÎñ 
Æ÷Ì«Ã¦£¬Äã¿ÉÒÔÔÚÁè³¿ÈËÉÙÊ±ÔÙÈ¥£¡£© ´ò¿ªÍøÒ³£¬µã»÷×ó·½²Ëµ¥Sign Up¡£ 
½øÈ¥ºó£¬¾ÍÒªÌîÄãµÄ×ÊÁÏÁË£¨Ò²²»ÊÇÊ²Ã´ÖØÒªµÄ×ÊÁÏ£©¡£ 
È»ºó£¬¸ú×ÅÌáÊ¾£¬Ò» ²½Ò»²½ÊäÈëÐÅÏ¢¾ÍOKÁË¡£ÏÂÃæÊÇÓ¢ÎÄµÄ½âÊÍ
use name   ÓÃ»§Ãû
password   ÃÜÂë
frist name   Ãû
last nameÐÕ
email adress ÓÊ¼þµØÖ·
adress  Í¨Ñ¶µØÖ·
state/province/country ÊÐ/Ê¡
zip/postal code   ÓÊÕþ±àÂë
country ¹ú¼Ò

ÄúÊÇ·ñÍ¬ÒâÓÊ¼þ·þÎñ (Í¬Òâ)

 Ìá½»

ÌîÍêºó£¬Õâ¸öÍøÕ¾¾Í»á·¢ 
Ò»¸öEmail¸øÄã£¬Õâ¸öEmailÀïÃæ¾ÍÒÔºóÄã¾ÍÓÃÄãµÃµ½µÄÕâ¸öIDÈ¥ÕÐÈË¡£ÆäÊµÒ²²»ÓÃÌØ±ðµØÈ¥ÕÐ£¬ÏñÎÒÕâÑù£¬·¢±íÎÄÕÂ£¬½ÌÈËÉêÇë¼ÓÈë²»¾ÍÄÜ×¬Ç®ÁËÂð£¿
 
¡¡ ºÃÁË£¬ÏÖÔÚµã»÷ Submit ¡£Äã»á¿´µ½Ò»¸ö½çÃæ,ÉÏÃæÐ´×ÅÄãµÄEmail,Ò»¶¨Òªµã»÷ 
Click Here(²»È»EmailÊÇ·¢²»µ½ÄãµÄÓÊÏäµÄ).ºÃ£¬ÉêÇëÍêÁË¡£ÏÖÔÚ£¬Äã¾ÍÈ¥ÄãµÄµç×ÓÓÊÏä £¬ 
Õâ¸öÍøÕ¾·¢¸øÄãÒ»¸öEmail¡£È¥¿´£¬ÔÚEmailÖÐÓÐÒ»Ìõ³¤³¤µÄÍøÖ·¡£ÉÏÃæÕâ¸öÊÇ¸øÎÒµÄÍøÖ· £¬ 
¶ø¸øÄãÃÇµÄÊÇ²»Í¬µÄ¡£Ã¿¸öÈË¶¼²»Í¬£¬ÄãÉÏËü¸øÄãµÄÍøÖ·¾ÍµÃÁË¡£½øÈ¥ºó£¬½Ó×Å£¬ÔÙ´ÎÊä 
Èë×ÊÁÏ¡£ 
µ«ÊÇÒª×¢ÒâÒ»µãµÄ¾ÍÊÇÏÈµÃ°ÑÄãµÄIEÖÐµÄINTERNETÑ¡ÏîÖÐµÄË½ÒþÏîÉè³É½ÓÊÜËùÓÐCOOKIE²Å 
ÐÐ¡£È»ºó£¬¾ÍÊÇ×¬Ç®Ö®·¨ÁË¡£ 
×¬Ç®µÄ·½·¨£º ¡¡ 
µ½¸÷¸öÍøÕ¾µÄÁôÑÔ°åÖÐ£¬°Ñ±¾ÎÄÄÚÈÝÈ«²¿¸´ÖÆ¡¢Õ³Ìù½øÈ¥£¡¶à¶àÒæÉÆàÞ£¡ 
£º£©Ö»ÒªÓÐÈËµã£¬Äã¾Í¿ÉÒÔÕõÇ®ÁË£¡¶àºÃ°¡£¡¶øÇÒ·´Õý×¬µÄÊÇÍâ¹úÈËµÄÇ®£¬²»×¬°×²»×¬£¡ 
ÕæµÄ£¬²»ÆÄãÃÇ~£¡~£¡GOGOGO!´ó¼ÒÒ»Æð×¬Ç®°¡ ºÇºÇºÇºÇ~~
  
 





ÖÂ
Àñ!
   cf
   6@74
   2003-02-17

-
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

Checking existence of a table.

2003-02-17 Thread ed


What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this possible
with MySQL or do I need to create a condition within PHP?

Thanks,

Ed


mysql


-
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: Checking existence of a table.

2003-02-17 Thread Simon Green

show tables from databasename;

Simon

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 17 February 2003 16:11
To: [EMAIL PROTECTED]
Subject: Checking existence of a table.

What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this possible
with MySQL or do I need to create a condition within PHP?

Thanks,

Ed

mysql

-
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

-
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: Checking existence of a table.

2003-02-17 Thread Paul DuBois

At 11:10 -0500 2/17/03, [EMAIL PROTECTED] wrote:

What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this possible
with MySQL or do I need to create a condition within PHP?


You can check the output of SHOW TABLES or you can issue the following
query and see if it produces an error (if so, the table doesn't exist):

SELECT * FROM tbl_name WHERE 0

The WHERE 0 part prevents the query from returning rows if the table
does exist.



Thanks,

Ed

mysql



-
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: How to delete from only one side of a join?

2003-02-17 Thread Paul DuBois

At 9:32 -0600 2/17/03, Mayo, Chuck wrote:

Hi all,

Just jumped on the list, hoping someone can give me a hand. The query below
uses a join, I guess, to select records from table stat_1_1 based on
information in table stat. I'd like to be able to turn this query into a
delete query but only want records removed from stat_1_1. Can anyone tell me
how? I must be missing something really obvious.


Replace SELECT DISTINCT with DELETE. :-)

You need MySQL 4.0.x for this to work.  Probably at least 4.0.2.



Thanks,
Chuck Mayo

 SELECT DISTINCT
stat_1_1.event_id

 FROM
stat_1_1,
stat

 WHERE
stat_1_1.player_id=39
 stat_1_1.stat_id = stat.id
 stat.stat_group = Individual



-
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: How to delete from only one side of a join?

2003-02-17 Thread Paul DuBois

At 9:32 -0600 2/17/03, Mayo, Chuck wrote:

Hi all,

Just jumped on the list, hoping someone can give me a hand. The query below
uses a join, I guess, to select records from table stat_1_1 based on
information in table stat. I'd like to be able to turn this query into a
delete query but only want records removed from stat_1_1. Can anyone tell me
how? I must be missing something really obvious.


Whoops, replace SELECT DISTINCT stat_1_1.event_id with DELETE stat_1_1.



Thanks,
Chuck Mayo

 SELECT DISTINCT
stat_1_1.event_id

 FROM
stat_1_1,
stat

 WHERE
stat_1_1.player_id=39
 stat_1_1.stat_id = stat.id
 stat.stat_group = Individual



-
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: Checking existence of a table. (finished)

2003-02-17 Thread ed


Thanks for all the replies. I've got a hnadle on it now.

Ed


On Mon, 17 Feb 2003, Paul DuBois wrote:

 At 11:10 -0500 2/17/03, [EMAIL PROTECTED] wrote:
 What query would I use to check for an existence of a table within a
 database? I'm currently writting a set of scripts in php. Is this possible
 with MySQL or do I need to create a condition within PHP?
 
 You can check the output of SHOW TABLES or you can issue the following
 query and see if it produces an error (if so, the table doesn't exist):
 
 SELECT * FROM tbl_name WHERE 0
 
 The WHERE 0 part prevents the query from returning rows if the table
 does exist.
 
 
 Thanks,
 
 Ed
 
 mysql
 
 
 -
 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
 


-
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

very slow count

2003-02-17 Thread Israel Yulzary

Hello,

When using the following on MySQL:

select count(xFld) from aTbl group by xFld;

I get twice the time it takes to process:

select xFld from aTbl group by xFld;

Can any one explain this and maybe help find a solution?

I'm using MySQL version 3.23.54 on NT and 3.23.41 on Linux, both
exhibit the same behavior.

Thanks,
Israel Yulzary

-
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: Checking existence of a table.

2003-02-17 Thread Don Read


On 17-Feb-2003 [EMAIL PROTECTED] wrote:
 
 What query would I use to check for an existence of a table within a
 database? I'm currently writting a set of scripts in php. Is this possible
 with MySQL or do I need to create a condition within PHP?
 
 Thanks,
 

function tableexists($tbl) {
$res = @mysql_query(SELECT 1 FROM $tbl LIMIT 1);
return ($res ? true : false);
}

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)

-
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: renaming temporary table

2003-02-17 Thread Arne . Muller

Hello,

I've tried to rename a temporary table, and I got an error 

ERROR 1017: Can't find file: './GOdevel/xgp.frm'). 

I guess it does not make too much sense to rename a temp table ... .
However,
I thought this might be worth mentioning.

regards,
 
Arne

not to be bounced: sql, query, smallint ... ;-)

-
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: Re: auto_increment every year

2003-02-17 Thread Paul DuBois

sql,query,queries,smallint



   HI all

  I'm searching in how to generate a auto_increment number starting form 1
  every year
  I mean

  ID DATE
  1  2003
  2  2003
  
  1  2004
  2  2004
  etc

   maybe possible or I've to use some c code to make it possible ?


Yes, this is possible.  Use a MyISAM table and set up a composite
index on the two columns, with the AUTO_INCREMENT column as the
second column in the index.

CREATE TABLE t
(
 yr   YEAR NOT NULL,
 id   INT UNSIGNED NOT NULL AUTO_INCREMENT,
 PRIMARY KEY(yr,id)
) TYPE = MyISAM;

This will generate an independent sequence of numbers for each distinct
yr value.

INSERT INTO t (yr) VALUES(2003),(2003),(2004),(2005),(2005);
SELECT * FROM t;

+--++
| yr   | id |
+--++
| 2003 |  1 |
| 2003 |  2 |
| 2004 |  1 |
| 2005 |  1 |
| 2005 |  2 |
+--++

-
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: Checking existence of a table.

2003-02-17 Thread Stefan Hinz

Ed,

 What query would I use to check for an existence of a table within a
 database? I'm currently writting a set of scripts in php. Is this possible
 with MySQL or do I need to create a condition within PHP?

In MySQL, you can issue:

 SHOW TABLES [FROM your_database] LIKE 'your_pattern'

Where 'your_pattern' might be a table name, or a pattern like 'tbl%'.

This statement will return the table name(s), or empty set if there
is no match.

With PHP, you could send a query to the MySQL server, like that:

 mysql_query(SHOW TABLES LIKE 'your_pattern');

And find out what it returns.
 
Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-
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: Bug? Update on 3 tables crashes in InnoDB

2003-02-17 Thread Heikki Tuuri

Martin,

this bug in multi-table UPDATE on InnoDB tables was reported 3 weeks ago and
Sinisa has fixed it to upcoming 4.0.11.

Regards,

Heikki
Innobase Oy
sql query

..
Subject: Bug? Update on 3 tables crashes in InnoDB
From: Martin Thoma
Date: Mon, 17 Feb 2003 11:57:12 +0100



Can somebody confirm this please?

Martin

Subject: UPDATE over 3 tables crashes in InnoDB

Description:
 I have 3 InnoDB-tables with about 6000 records each:
 customer 1:n orders 1:n invoices

 When trying to make the following update:

 update customer, orders, invoices set customer.locked=1 WHERE
 invoices.id=1234 AND
 invoices.order=orders.id AND
 orders.customer=customer.id;

 the database crashes with:
 mysqld-nt: ready for connections.
 Version: '4.0.10-gamma-nt'  socket: ''  port: 3302
 030217 11:48:47  InnoDB: Assertion failure in thread 1428 in file
D:\mysql-4.0.10-gpl\innobase\btr\btr0pcur.c line 203
 InnoDB: We intentionally generate a memory trap.
 InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
 InnoDB: Thread 1460 stopped in file
D:\mysql-4.0.10-gpl\innobase\sync\sync0arr.c
line
126
 InnoDB: Thread 1164 stopped in file
D:\mysql-4.0.10-gpl\innobase\os\os0sync.c line
150

How-To-Repeat:
 Build a table with 6000 customers, each with one order and one invoice.
Then just
repeat the UPDATE above.

Fix:
 

Synopsis: Update over 3 tables crashes in InnoDB
Submitter-Id: 
Originator: martin thoma
Organization:
MySQL support:  [none]
Severity: [serious]
Priority: [medium]
Category: [mysqld]
Class:  [sw-bug]
Release: 4.0.10-gamma

Exectutable:   [mysqld-nt]
Environment:   AMD XP1800+, 512 MB, 80 GB HDD
System:Win200 Prof.
Compiler:  VC++ 6.0
Architecture:  i


-
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: Red Hat 8.0 compile problems with 4.0.10

2003-02-17 Thread Heikki Tuuri

Hi!

I have the same problem in my new Red Hat 8.0 / Athlon 1.8 GHz laptop.

If I build MySQL-4.0.10 from source with

./BUILD/compile-pentium-debug

it crashes in installing MySQL system tables. If I use a MySQL binary distro
to install the system tables, then the mysqld I built may crash in
mysqladmin shutdown or SHOW TABLES.

I guess this is yet another problem with thread stack size overruns and the
glibc in Red Hat 8.0, or a bug in gcc-3.2.

MySQL AB's official binaries work fine.

Regards,

Heikki
Innobase Oy
sql query

.

Subject: Re: Red Hat 8.0 compile problems with 4.0.10
From: Mark Matthews
Date: Sun, 16 Feb 2003 16:10:51 -0600



-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Mark T. Dame wrote:
 On 2/16/03 8:40 AM, Mark Matthews wrote:

 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 Mark T. Dame wrote:

 On 2/15/03 1:25 AM, Duncan Maitland wrote:

 I am having trouble compiling a custom mysqld (version 4.0.10) under
 Red
 Hat 8.0 - I did email this list a few weeks ago and I have tried a few
 things since then but I am asking again in the hope that someone more
 knowledgeable might be able to help.




 This is a known problem (in that I've seen several people post
 about it, including myself), but I have not seen any answers other
 than use the binary distribution or binary RPMS.  I have
 successfully tested the RPM distribution, but I would prefer to use
 the source.


 As far as I can tell this is a compiling or linking problem.




  From what I've been able to figure out, the MySQL server will start
 up, but when you attempt to connect to it, it seg vaults.  I haven't
 had time to track it down, but it doesn't appear to be a simple
 resolver library problem, as I've seen suggested.  Also, 4.0.10 is
 increases the thread-stack size, supposedly to fix this (or maybe a
 related) problem. It hasn't helped, as far as I can tell.

 Anyway, I would be interested in an answer to this as well.



 I just tried compiling and using MySQL-4.0.11 (from the BitKeeper
 repository) on RedHat 8.0, and this problem seems to have gone away:


 Can you repeat the problem using 4.0.10?

Nope. From a source install of MySQL-4.0.10 on RH-8.0:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.10-gamma

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql status;
- --
/usr/local/mysql/mysql-4.0.10/bin/mysql  Ver 12.17 Distrib 4.0.10-gamma,
for intel-linux (i686)

Connection id:  3
Current database:
Current user:   [EMAIL PROTECTED]
SSL:Not in use
Current pager:  stdout
Using outfile:  ''
Server version: 4.0.10-gamma
Protocol version:   10
Connection: 127.0.0.1 via TCP/IP
Client characterset:latin1
Server characterset:latin1
TCP port:   3308
Uptime: 46 sec

Threads: 1  Questions: 13  Slow queries: 0  Opens: 12  Flush tables: 1
Open tables: 1  Queries per second avg: 0.283
- --

mysql show variables like '%stack%';
+---++
| Variable_name | Value  |
+---++
| thread_stack  | 196608 |
+---++
1 row in set (0.00 sec)

mysql

It seems that the thread stack is set to 192K by default in 4.0.10.

 -Mark


- --
MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

 __  ___ ___   __
/  |/  /_ __/ __/ __ \/ /  Mark Matthews [EMAIL PROTECTED]
   / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
  /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
 ___/ www.mysql.com


-
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: List

2003-02-17 Thread David T-G

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Jerry, et al --

...and then Jerry said...
% 
% Is it just me or is everyone on the list getting junk/spam from naver.com ?

Haven't seen any, assuming you spelled it right.  I just checked through
my entire mysql folder and have only your and Stefan's messages mentioning
it.


HTH  HAND

mysql query,
:-D
- -- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/  Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+USGFGb7uCXufRwARAhv0AKCFf/t0TxdOHnN7bEaPJIJRqCCICQCfVeju
yDoNRzqOm/dCDaUgrNc7i5I=
=bAig
-END PGP SIGNATURE-

-
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 3.23.55 broken if compiled with -all-static

2003-02-17 Thread Carlos

Hi,

Compilation of mysql 3.23.55 fails ONLY when using --with-mysqld-ldflags=-all-static 
results in broken mysqld.
Segmentation fault?


Resolving stack trace:

0x808f4d4 _Z15handle_segfaulti + 404
0x81bc67a __pthread_sighandler + 122
0x81ceb4d __strtol_internal + 1421
0x8096cf6 _Z17add_field_to_listPc16enum_field_typesS_S_jP4ItemS_P10st_typelib + 310
0x8099310 _Z7yyparsev + 3376
0x8091f48 _Z16handle_bootstrapPv + 648



If compiled with dynamic libraries, it works fine.

Some info:

uname -a
Linux atlas 2.4.20 #1 Sat Feb 1 10:39:59 CET 2003 i586 unknown

glibc with libpthreads 2.3.1

 gcc -v
Reading specs from /usr/lib/gcc-lib/i586-pc-linux-gnu/3.2.1/specs
Configured with: ./configure --prefix=/usr --sysconfdir=/etc --localstatedir=/var 
--enable-threads=posix --with-gnu-ld --enable-shared --enable-languages=c,c++
Thread model: posix
gcc version 3.2.1


Compilation options:
CFLAGS=-O3 -mcpu=k6-2 CXX=gcc CXXFLAGS=-O3 -mcpu=k6-2 -felide-constructors 
-fno-exceptions -fno-rtti ./configure --prefix=/usr/mysql --enable-thread-safe-client 
--enable-local-infile --enable-assembler --with-berkeley-db --with-gnu-ld 
--libdir=/usr/lib --includedir=/usr/include --mandir=/usr/man 
--with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --disable-shared


No errors, and compilation successfull.

But mysqld is broken:
When running mysqld_install_db:

-

 ./scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail

key_buffer_size=8388600
record_buffer=131072
sort_buffer=2097144
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation

Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Stack range sanity check OK, backtrace follows:
0x808f4d4
0x81bc4ba
0x81ce98d
0x8096cf6
0x8099310
0x8091f48
Stack trace seems successful - bottom reached
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow 
instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd-query at 0x8312678 =  CREATE TABLE db (   Host char(60) binary DEFAULT '' NOT 
NULL,   Db char(64) binary DEFAULT '' NOT NULL,   User char(16) binary DEFAULT '' NOT 
NULL,   Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,   Insert_priv enum('N','Y') 
DEFAULT 'N' NOT NULL,   Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,   Delete_priv 
enum('N','Y') DEFAULT 'N' NOT NULL,   Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,  
 Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,   Grant_priv enum('N','Y') DEFAULT 'N' 
NOT NULL,   References_priv enum('N','Y') DEFAULT 'N' NOT NULL,   Index_priv 
enum('N','Y') DEFAULT 'N' NOT NULL,   Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL, 
PRIMARY KEY Host (Host,Db,User), KEY User (User) ) comment='Database privileges'
thd-thread_id=1

Successfully dumped variables, if you ran with --log, take a look at the
details of what thread 1 did to cause the crash.  In some cases of really
bad corruption, the values shown above may be invalid
...

--

Resolving stack trace:

0x808f4d4 _Z15handle_segfaulti + 404
0x81bc67a __pthread_sighandler + 122
0x81ceb4d __strtol_internal + 1421
0x8096cf6 _Z17add_field_to_listPc16enum_field_typesS_S_jP4ItemS_P10st_typelib + 310
0x8099310 _Z7yyparsev + 3376
0x8091f48 _Z16handle_bootstrapPv + 648



Any help would be apreciated.

Thanks



-
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

Bug in ORDER BY

2003-02-17 Thread Ken Goff

I have encountered what appears to be a bug in MySQL regarding ORDER 
BY related to a date field when also used in conjunction with 
DATE_FORMAT() or UNIX_TIMESTAMP(). When these functions are applied 
to my date field, MySQL ignores any included ORDER BY within the 
query. I first noticed this bug using PHP with MySQL but have 
confirmed it occurs when entering the query directly within Terminal.

The table consists of the following 4 fields with their data types described:

EventId - number - mediumint(10) - auto_increment
EventDate - date
Event - text
EventOrder - number - mediumint(5)

The following query sorts properly:

SELECT * FROM EventList ORDER BY 'EventDate', 'EventOrder' LIMIT 50;

The following ignores ORDER BY and instead sorts by EventId:

SELECT EventId, DATE_FORMAT(EventDate, '%c-%e-%Y') as 
FormattedEventDate, Event, EventOrder FROM EventList ORDER BY 
'EventDate', 'EventOrder' LIMIT 50;

So does the following sort by EventId instead of using the ORDER BY:

SELECT EventId, UNIX_TIMESTAMP(EventDate), Event, EventOrder FROM 
EventList ORDER BY 'EventDate', 'EventOrder' LIMIT 50;

Is there any way around this bug? I want to list dates in US style of 
m-d- instead of -m-d.
--
-Ken Goff
MacEssentials

-
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: Need Distinct and Min...

2003-02-17 Thread Egor Egorov

On Monday 17 February 2003 04:20, Lewis Watson wrote:

 I have a table with three fields. In the first field I have a range of
 numbers 1-20; all repeated more than once. In the third field I have a
 number ranging from 1 to 20 in each row. I need to choose the
 lowest amount in the third column for each distinct value in the fist
 column. Will someone help me out with this query?

Something like:

SELECT MIN(third_column) FROM table_name GROUP BY first_column;



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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

max_user_connections

2003-02-17 Thread Michael T. Babcock

It would be nice to extend the user permissions table to have per-user 
limits like max_user_connections and the various timeouts applying 
directly to specific user/host combinations.

Just a thought / suggestion.

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.  SQL
http://www.fibrespeed.net/~mbabcock



-
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

Invalid domain names

2003-02-17 Thread Bob Balsover

6@74 is obviously not a real email address but this is happening on a
fairly regular basis from this mailing list. I can't see the message so
I can't tell if it is spam or not but if you are not seeing your
messages on the group then you might want to see if your email client is
confused about who you are or what domain you are stating that you are
in.

Isn't the mailing list supposed to reject messages from invalid domains
without forwarding them to the list?

-Original Message-
From: FETCHMAIL-DAEMON
Sent: Monday, February 17, 2003 7:53 AM
To: 6@74
Subject: 


Invalid address in MAIL FROM (SMTP error 553).


Reporting-MTA: dns; localhost

Final-Recipient: rfc822; bob@localhost
Last-Attempt-Date: Mon, 17 Feb 2003 07:53:26 -0800 (PST)
Action: failed
Status: 5.1.8
Diagnostic-Code: 553 5.1.8 6@74... Domain of sender address 6@74 does not exist

Received: from pop2-ext.prodigy.net by mailapps4 with SMTP; Mon, 17 Feb 2003 10:50:22 -0500
X-Originating-IP: [213.136.49.183]
Received: from web.mysql.com (web.mysql.com [213.136.49.183])
	by pop2-ext.prodigy.net (8.12.3 da nor stuldap/8.12.3) with SMTP id h1HFoL02012480
	for [EMAIL PROTECTED]; Mon, 17 Feb 2003 10:50:21 -0500
Message-Id: [EMAIL PROTECTED]
Received: (qmail 25335 invoked by uid 7797); 17 Feb 2003 15:47:42 -
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org)
List-ID: mysql.mysql.com
Precedence: bulk
List-Help: mailto:[EMAIL PROTECTED]
List-Unsubscribe: mailto:[EMAIL PROTECTED]
List-Post: mailto:[EMAIL PROTECTED]
List-Subscribe: mailto:[EMAIL PROTECTED]
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 25304 invoked from network); 17 Feb 2003 15:47:39 -
From: cf 6@74
Subject: ×¬ÃÀÔª
To: [EMAIL PROTECTED]
Content-Type: text/plain;charset=GB2312
Reply-To: [EMAIL PROTECTED]
Date: Mon, 17 Feb 2003 23:52:47 +0800
X-Priority: 3
X-Mailer: FoxMail 3.11 Release [cn]


-
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

C API metadata bug

2003-02-17 Thread matt neuburg

Server version  3.23.55-entropy.ch
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Apple PowerBook G3 running Mac OS X 10.2.4
I'm using the distribution provided at Marc Liyanage's site:
  http://www.entropy.ch/software/macosx/mysql/
  
Make a small test table as follows:

mysql create database bugTest;
mysql use bugTest;
mysql CREATE TABLE `products` (
-   `ProductID` smallint(4) unsigned NOT NULL auto_increment,
-   `ProductName` varchar(64) NOT NULL default '',
-   PRIMARY KEY  (`ProductID`)
- ) TYPE=MyISAM
- ;
mysql CREATE TABLE `units` (
-   `UnitID` smallint(4) unsigned NOT NULL auto_increment,
-   `ProductID` smallint(4) unsigned NOT NULL default '0',
-   `sSize` enum('','S','M','L','X','Z') NOT NULL default '',
-   PRIMARY KEY  (`UnitID`),
-   KEY `ProductID` (`ProductID`),
-   KEY `sSize` (`sSize`)
- ) TYPE=MyISAM
- ;
mysql insert into products values (1,shirt), (2,pants);
mysql insert into units values (1, 1, S), 
   (2, 1, M), (3, 2, L);

Using the C API (my app is a Cocoa app linked to libmysql.a), connect to the test 
database and execute this query:

  select Products.ProductID, Products.ProductName from Products 
  left join Units using (ProductID) 
  order by Units.sSize
  
The BUG is that in the fields metadata returned with the results, the field 
Products.ProductID is not marked as being the primary key field. That is, in the 
information gathered with mysql_fetch_field, in field-flags, the test IS_PRI_KEY 
returns false for this field. The relevant bit is 0. It should be 1. 

If you change the query in its order by clause, as follows:

  select Products.ProductID, Products.ProductName from Products 
  left join Units using (ProductID) 
  order by Products.ProductID
  
then the test *does* work (the metadata is returned correctly).

If you change the query to use an inner join, as follows:

  select Products.ProductID, Products.ProductName
  from Products, Units where Products.ProductID = Units.UnitID
  order by Products.ProductID
  
then the BUG returns.

Apart from the fact that this bug occurs only when group by or order by clauses 
are present, I have not been able to work out a pattern here.

This bug has been causing us trouble since July 2002 (when we started using MySQL).

matt neuburg, phd = [EMAIL PROTECTED], http://www.tidbits.com/matt
pantes anthropoi tou eidenai oregontai phusei
Subscribe to TidBITS! It's free and smart. http://www.tidbits.com/

-
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: max_user_connections

2003-02-17 Thread Jeremy Zawodny

On Mon, Feb 17, 2003 at 02:33:05PM -0500, Michael T. Babcock wrote:
 It would be nice to extend the user permissions table to have per-user 
 limits like max_user_connections and the various timeouts applying 
 directly to specific user/host combinations.

Agreed.  We've had a few circumstances when that would have been
useful.

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED]  |  http://jeremy.zawodny.com/

MySQL 4.0.8: up 14 days, processed 444,998,774 queries (358/sec. avg)

-
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: MySQL DB structure for scrolling list

2003-02-17 Thread Frank Peavy

At 04:58 PM 2/17/03 +0100, you 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,queries,smallint

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:

I am in the process of designing a form and I am a little confused.
I would like to have a scrolling window, in which the user can select multiple
items. For example, the scrolling window may contain operating systems, 
and the
user has the ability to select multiple OS's (using the Control-Click
combination),
to describe themselves.

I am unsure how this data should be stored. I am using a MyISAM table, but 
I am
unsure about the type of field this information should be stored in. And,
when the individual
wants to update the information, how it should be displayed.

Any advice would be appreciated.



-
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: MySQL DB structure for scrolling list

2003-02-17 Thread Paul DuBois

sql,query,queries,smallint

I am in the process of designing a form and I am a little confused.
I would like to have a scrolling window, in which the user can 
select multiple
items. For example, the scrolling window may contain operating 
systems, and the
user has the ability to select multiple OS's (using the Control-Click
combination),
to describe themselves.

I am unsure how this data should be stored. I am using a MyISAM 
table, but I am
unsure about the type of field this information should be stored in. And,
when the individual
wants to update the information, how it should be displayed.

Any advice would be appreciated.

Take a look at the sample chapter available here:

http://www.kitebird.com/mysql-perl/

It discusses writing form-based web apps that use MySQL.

It's written with Perl in mind, but much of the discussion focuses on
principles and HTML, and thus tends to be relatively language-neutral.


-
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: max_user_connections

2003-02-17 Thread Stefan Hinz

Michael,

 It would be nice to extend the user permissions table to have per-user 
 limits like max_user_connections and the various timeouts applying 
 directly to specific user/host combinations.

As of MySQL 4.0.2, you can set some limits per user. Here's an excerpt
from my mysql.user table:

+---+-+-+
| max_questions | max_updates | max_connections |
+---+-+-+
| 0 |   0 |   0 |

Zero means the option is disabled for this user. The meaning is (all
numbers are per hour):
- max_question:number of commands user can send to server,
- max_updates: number of changes user can submit,
- max_connections: well, I let you guess ;-)

http://www.mysql.com/doc/en/User_resources.html

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-
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: max_user_connections

2003-02-17 Thread Michael T. Babcock

Stefan Hinz wrote:


It would be nice to extend the user permissions table to have per-user 
limits like max_user_connections and the various timeouts applying 
directly to specific user/host combinations.
   


As of MySQL 4.0.2, you can set some limits per user. Here's an excerpt
from my mysql.user table:

- max_question:number of commands user can send to server,
- max_updates: number of changes user can submit,
- max_connections: well, I let you guess ;-)
 


Maybe I'll have to take the plunge and upgrade after all.

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
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

Inserting '#' char as part of a field

2003-02-17 Thread Robby Tanner

Hello,

I tried to insert a # as part of a field and got an error from the server
saying that I had an error in my SQL statement at line 1 
F:\\BL. The error number is (8000) and the value is supposed to be F:\\BL#. 
I understand that MySQL is interpretting that as a comment identifier.  I 
should note that the problem is also intermittent.

However, when I run the same query through the ODBC (via database =
explorer) driver it works well enough.

The statement is:

INSERT INTO Xrefs Values ('base.dwg', 'F:\\accel\\rad\\', '1.dwg',
'F:\\else\\bl#\\');

How can I get MySQL (via ZeosDBO in Delphi 5) to accept the # 
sign? Add extra quotes or a backslash before the character?  Use double 
quotes?  Some other method?

ZeosDBO is a set of components for talking to MySQL via the LibMySQL.dll.

Regards,
Robby Tanner B.Sc. (EE), B.Sc. (Cmpt. Sci)
Controls Engineer
Canadian Light Source
University of Saskatchewan
101 Perimeter Road
Saskatoon, Saskatchewan
Canada
S7N 0X4

Ph:   (306) 657-3582
Fax:(306) 657-3535
http://www.lightsource.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 and Apache

2003-02-17 Thread Barry Fawthrop

Greetings,
In trying the MySQL and Apache links found on the page
doc/en/Apache.html

I was trying the second option


Why when I tried the CustomLog |mysql -host... option above it
didn't work ?
I like the second option over the first because the SQL database is
updated instantly a log entry is created ?

LogFormat INSERT INTO NTable (access, ip, pagename, status, size,
referer, browser) VALUES
('%t','%h','\%r\','%s','%b','\%{Referer}i\','\%{User-Agent}i\') 
mysql

CustomLog |mysql -ulog  Log  mysql


My   MySQLNTableall fields are varchar(value)

Thanks in advance
Barry



-
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

received 0 length packet from server

2003-02-17 Thread Jeremy Tinley

Howdy,

Running MySQL 3.23.54 on master, 3.23.55 on all slaves, I'm experiencing the
following situation:

slave1  slave4 both receive 0 length packets from the server.
slave2  slave3 both work fine.

slave1  2 are identical machines both in hardware and configuration
slave3  4 are different from 1  2, and from each other in hardware only

The my.cnf files are the same, same subnet, different switches (but a machine
that works, and one that doesn't are on the same switch).

Log files look like this (trimmed for neatness):

030217 15:16:47  Slave: received 0 length packet from server, apparent master
shutdown:
030217 15:16:47  Slave: Failed reading log event, reconnecting to retry, log
'binlog.010' position 531922547
030217 15:16:47  Slave: reconnected to master 'repl@master1:3306',replication
resumed in log 'binlog.010' at position 531922547
030217 15:16:47  Slave: received 0 length packet from server, apparent master
shutdown:
030217 15:16:47  Slave: Failed reading log event, reconnecting to retry, log
'binlog.010' position 531922771
030217 15:16:47  Slave: reconnected to master 'repl@master1:3306',replication
resumed in log 'binlog.010' at position 531922771


Troubleshooting thoughts, anyone?  The slaves are in an LVS cluster and can be
downed at any time.




-
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: Inserting '#' char as part of a field

2003-02-17 Thread Stefan Hinz

Robby,

 How can I get MySQL (via ZeosDBO in Delphi 5) to accept the #
 sign? Add extra quotes or a backslash before the character?  Use double 
 quotes?  Some other method?

I know about nothing of Delphi and Zeos, but I'd try a backslash
before the # character. Here's what I get with the mysql client:

mysql INSERT INTO mytest (bla) VALUES ('#'),('\#');
Query OK, 2 rows affected (0.03 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql SELECT bla FROM mytest;
+--+
| bla  |
+--+
| #|
| #|
+--+
2 rows in set (0.00 sec)

Obviously, the backslash changes nothing, so I guess it won't hurt
trying.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-
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: Inserting '#' char as part of a field

2003-02-17 Thread Robby Tanner

I solved the issue (eventually) by using a different control.

It seems the batch component interprets #'s differently than regular table and query 
components.  I'll use query components in the future.

Thanks anywaym,
Rob


 -Original Message-
 From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
 Sent: Monday, February 17, 2003 4:10 PM
 To: Robby Tanner
 Cc: [EMAIL PROTECTED]
 Subject: Re: Inserting '#' char as part of a field
 
 
 Robby,
 
  How can I get MySQL (via ZeosDBO in Delphi 5) to accept the #
  sign? Add extra quotes or a backslash before the character? 
  Use double 
  quotes?  Some other method?
 
 I know about nothing of Delphi and Zeos, but I'd try a backslash
 before the # character. Here's what I get with the mysql client:
 
 mysql INSERT INTO mytest (bla) VALUES ('#'),('\#');
 Query OK, 2 rows affected (0.03 sec)
 Records: 2  Duplicates: 0  Warnings: 0
 
 mysql SELECT bla FROM mytest;
 +--+
 | bla  |
 +--+
 | #|
 | #|
 +--+
 2 rows in set (0.00 sec)
 
 Obviously, the backslash changes nothing, so I guess it won't hurt
 trying.
 
 Regards,
 --
   Stefan Hinz [EMAIL PROTECTED]
   iConnect GmbH http://iConnect.de
   Heesestr. 6, 12169 Berlin (Germany)
   Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3
 
 [filter fodder: sql, mysql, query]
 
 

-
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

Oh GAWD somone HELP :)

2003-02-17 Thread Poodle

Just installed mysql nice one i though

set it all up read the nessasary docs nice one i thought

tried to connect remotly

[root@tasha root]# mysqladmin -h 192.168.0.2 version -uroot -ppassword
mysqladmin: connect to server at '192.168.0.2' failed
error: 'Lost connection to MySQL server during query'

oh bugger

played around with the configs for a few hours

tried everything i could think of

read some more docs

tried everything i could think of again

still the same

any ideas?



-
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

Finding an available index

2003-02-17 Thread Craig Woodford

Hi,

This is my first post to this mailing list, so please forgive me if my
message is not structured in the correct format.

My query is this.  Where a column used as a unique identifier for a
record contains the values 1,2,3,5.  Is a mysql query possible that will
retrieve 4 as an available index value?  If so, what is that query?

Sincerely,
Craig Woodford

-
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

Database Backup Question

2003-02-17 Thread Loren McDonald


This is actually more a PHP question but since it refers to a MySQL
database I thought I would ask here.
I may not be looking in the right places but, I can't seem to find a way
to do a database backup through PHP (other than BACKUP TABLE, which I
don't want to use if possible)

What I mean is this:  I want to create a page that will allow me to
click one button to initiate a backup process.  That action will then
start a dump of a specified database to a text file that could then be
shown on a succeeding (success) page as a link for download (If there's
a way to zip prior to downloading, which would be even better).  I
intend on using this as a manual backup process, so I want it to work
like the mysqldump.exe or mysqlhotcopy.exe.  (All the tables are MyISAM)

The only way I see this working would be to write in PHP a long script
that will manually create that dump file itself by using SELECT and so
forth.  This seems a bit redundant and extravagant a way to go. 

Any help would be appreciated.

-- 
Loren McDonald
[EMAIL PROTECTED]




-
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: Database Backup Question

2003-02-17 Thread KH Chiu

Sorry I am in a bit hurry and just post some hints on your question. It is 
more than one way to do your job. One of the trival way is to use php 
function 'exec'. This function can execute shell programs. It means that you 
can execute mysqldump etc. and create dump file.

From my experience, you should exp. with exec for a while to get thru. all 
the tricks like trustee and getting output back.

You should also zip or bzip the file using similar technique.

File download is trival.

If you need further help, you may let you know.

Regards,

 This is actually more a PHP question but since it refers to a MySQL
 database I thought I would ask here.
 I may not be looking in the right places but, I can't seem to find a 
 way to do a database backup through PHP (other than BACKUP TABLE,
  which I don't want to use if possible)
 
 What I mean is this:  I want to create a page that will allow me to
 click one button to initiate a backup process.  That action will then
 start a dump of a specified database to a text file that could then 
 be shown on a succeeding (success) page as a link for download (If there's
 a way to zip prior to downloading, which would be even better).  I
 intend on using this as a manual backup process, so I want it to work
 like the mysqldump.exe or mysqlhotcopy.exe.  (All the tables are 
 MyISAM)
 
 The only way I see this working would be to write in PHP a long 
 script that will manually create that dump file itself by using 
 SELECT and so forth.  This seems a bit redundant and extravagant a 
 way to go. 
 
 Any help would be appreciated.
 
 -- 
 Loren McDonald
 [EMAIL PROTECTED]
 
 -
 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 mysql-unsubscribe-
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


--
Yours,
KH Chiu
CA Computer Consultants Ltd.
Tel: 3104 2070 Fax: 3010 0896
Email: [EMAIL PROTECTED]
Website: www.caconsultant.com


-
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: Oh GAWD somone HELP :)

2003-02-17 Thread KH Chiu

You should add a user who allow to connect from 192.168.0.2 before you can 
connect to MySQL remotely.

Further more, make sure that your host can reverse lookup 192.168.0.2. This 
can be done by add an entry in the /etc/hosts or create a DNS entry.

Regards,

 Just installed mysql nice one i though
 
 set it all up read the nessasary docs nice one i thought
 
 tried to connect remotly
 
 [root@tasha root]# mysqladmin -h 192.168.0.2 version -uroot -
 ppassword mysqladmin: connect to server at '192.168.0.2' failed 
 error: 'Lost connection to MySQL server during query'
 
 oh bugger
 
 played around with the configs for a few hours
 
 tried everything i could think of
 
 read some more docs
 
 tried everything i could think of again
 
 still the same
 
 any ideas?
 
 -
 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 mysql-unsubscribe-
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


--
Yours,
KH Chiu
CA Computer Consultants Ltd.
Tel: 3104 2070 Fax: 3010 0896
Email: [EMAIL PROTECTED]
Website: www.caconsultant.com


-
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

Locked Threads

2003-02-17 Thread Peter Bryant

First, an update.  After waiting a few days for a FULLTEXT index to build on 
a 3.23.5* database, I updated the database server to MySQL 4.0.10 on advice 
from Sergei Golubchik on this list: 
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:132146:200302:cdpckkcecgnggcboabda

The index rebuild took 'only' several hours, then.  So, that problem is 
resolved.

I did had to run it twice after running out of /tmp space (I set TMPDIR to a 
partition with mroe space the second time around).  I'd be curious what 
MySQL is using the /tmp space for, but that is incidental to this post.

After the index was built, I started using the table.

Now onto the problem.

I found that there were 8 threads with a Sending data status and a long 
list of sql threads with a status of Locked (doing deletes, selects and 
replaces).  All threads looking solely at the table with the fulltext index.

Query1282  Sending data   SELECT MESSAGE_OID FROM IP_INDEXED_WORDS
Query1259  Sending data   SELECT MESSAGE_OID FROM IP_INDEXED_WORDS
Query1259  Sending data   SELECT MESSAGE_OID FROM IP_INDEXED_WORDS
Query1254  Sending data   SELECT MESSAGE_OID FROM IP_INDEXED_WORDS
Query1206  Sending data   SELECT MESSAGE_OID FROM IP_INDEXED_WORDS
Query1167  Sending data   SELECT MESSAGE_OID FROM IP_INDEXED_WORDS
Query1049  Sending data   SELECT MESSAGE_OID FROM IP_INDEXED_WORDS
Query957  Sending data   SELECT MESSAGE_OID FROM IP_INDEXED_WORDS
Query870  Locked REPLACE INTO IP_INDEXED_WORDS ( 
MESSAGE_BODY,SUBJECT,MESSAGE_OID,SITE_OID,DATETIME_POSTED,AUTHOR_OID
Query868  Locked SELECT MESSAGE_OID FROM IP_INDEXED_WORDS
Query862  Locked SELECT MESSAGE_OID FROM IP_INDEXED_WORDS
Query858  Locked SELECT MESSAGE_OID FROM IP_INDEXED_WORDS
Query856  Locked DELETE FROM IP_INDEXED_WORDS
Query847  Locked SELECT MESSAGE_OID FROM IP_INDEXED_WORDS

I'm sure the problem is exacerbated by the fact that the selects are taking 
too long to run.  I'm working to resolve that.

What is the reason for most of the threads having a locked status?  I 
understood MySQL could insert rows into tables that were being used in 
selects.

I notice that innodb_thread_concurrency is 8.  Is it a coincidence there 
were that many threads Sending data.  Obviously with a fulltext index, 
this is not an innodby table.

Since some of the threads were doing replace SQL I had a look at the insert 
delayed command.  However, it seems from the manual that this won't 
necessarily help much with MyISAM tables.

Any help appreciated,

Regards, Peter Bryant

_
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail


-
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

Is this possible with Linux

2003-02-17 Thread kk

Hello folks
(BIs it possible to install a MySQL server into the /home/*username*
(Bdirectory in a typical Linux Installation. If so
(B1. where to put those my.cnf files and set the global options for a
(Bparticular user.
(B2. How to connect to that database from a remote machine, knowing the IP of
(Bthe host machine and the *username* ( linux user )
(B
(BThanks for any help
(B
(Bregards
(B
(B
(B
(B-
(BBefore posting, please check:
(B   http://www.mysql.com/manual.php   (the manual)
(B   http://lists.mysql.com/   (the list archive)
(B
(BTo request this thread, e-mail [EMAIL PROTECTED]
(BTo unsubscribe, e-mail [EMAIL PROTECTED]
(BTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Slow Fulltext Search on Large Table

2003-02-17 Thread Peter Bryant

My problem is that my fulltext searches run quite slowly.

I have a 2300MB table with 4.3M rows and an index (primarily a fulltext 
index) of 1300M.  My hardware is a dual Athlon MP1500+ with 2GB of memory.  
I am running MySQL 4.0.10.

My my.cnf includes:
set-variable = key_buffer=16M
set-variable = key_buffer_size=128M
set-variable = max_allowed_packet=16M
set-variable = sort_buffer=4M
set-variable = max_connections=1024
set-variable = max_connect_errors=900
set-variable = table_cache=1200

I have found that:
1) Searching for non-existant words is fast (1s)
2) Searching for common words is slow (e.g. select a count of matches on a 
single word with 15135 matches on a 2300MB table takes 3 min 38.54 sec)
3) Boolean search for a +common word +nonexistant word completes 
immediately.
4) Add in a LIMIT n on a popular term and the results complete quicker.  
Completion time is less than O(n).  O(log n?)
5) A repeat search runs faster (1s vs. 35s).  Presumably because of OS file 
caching and the key_buffer_size variable.
6) against ('aword') limit 2000 and against ('+adifferentword' in boolean 
mode) limit 2000 take about the same time to reach their limits (2000).
7) match(subject, message_body) against ('Linux Kernel') and message_body 
like '%Linux%' and message_body like '%kernel%' limit 2000 returns in about 
the same time as against ('+Linux +kernel' in boolean mode) limit 2000 
(24s)

On smaller tables search runs 'acceptably fast'.  However, with this larger 
table, performance on certain searches is unacceptable.  I'm having to 
resort to killing database connections when they run too long.

So, onto my questions:
1) Are there any server settings I should be looking at to improve fulltext 
search performance?
2) Can my SQL be written differently (e.g. is boolean mode faster or not?)
3) Is there a way to get a list of the most commonly occuring words in a 
fulltext index?  Then I can avoid them in searches.  MySQL doesn't happen to 
drive it's queries by finding the word with lowest frequency first does it?
4) Are there any MySQL code changes on the horizon that could help to speed 
up fulltext word searching?
5) Is there anything else I could do that would allow me to get results 
faster (within about a 30 second timeframe).  Having searches that don't 
return all matching rows would be acceptable (but not desirable).  e.g. I'm 
thinking of just deleting less important rows from my large table.

Thanks in advance for any help,

Peter Bryant


_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail


-
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

AW: Checking existence of a table. query

2003-02-17 Thread Franz, Fa. PostDirekt MA

Hi Ed,

What query would I use to check for an existence of a table within a
database? 

SHOW TABLES LIKE 'table_name';

might help.

prosit
Klaus

-
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: Database Backup Question

2003-02-17 Thread Loren McDonald

That's exactly what I was looking for and the way I hoped it could be
done, only I hadn't seen anything about this 'exec' function.

Thanks. I should be able to figure it out myself but I will get back
with you if I need further help.

-- 
Loren McDonald AKA MisterrMac
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com


-Original Message-
From: KH Chiu [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 17, 2003 9:19 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Database Backup Question

Sorry I am in a bit hurry and just post some hints on your question. It
is 
more than one way to do your job. One of the trival way is to use php 
function 'exec'. This function can execute shell programs. It means that
you 
can execute mysqldump etc. and create dump file.

From my experience, you should exp. with exec for a while to get thru.
all 
the tricks like trustee and getting output back.

You should also zip or bzip the file using similar technique.

File download is trival.

If you need further help, you may let you know.

Regards,

 This is actually more a PHP question but since it refers to a MySQL
 database I thought I would ask here.
 I may not be looking in the right places but, I can't seem to find a 
 way to do a database backup through PHP (other than BACKUP TABLE,
  which I don't want to use if possible)
 
 What I mean is this:  I want to create a page that will allow me to
 click one button to initiate a backup process.  That action will then
 start a dump of a specified database to a text file that could then 
 be shown on a succeeding (success) page as a link for download (If
there's
 a way to zip prior to downloading, which would be even better).  I
 intend on using this as a manual backup process, so I want it to work
 like the mysqldump.exe or mysqlhotcopy.exe.  (All the tables are 
 MyISAM)
 
 The only way I see this working would be to write in PHP a long 
 script that will manually create that dump file itself by using 
 SELECT and so forth.  This seems a bit redundant and extravagant a 
 way to go. 
 
 Any help would be appreciated.
 
 -- 
 Loren McDonald
 [EMAIL PROTECTED]
 





-
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: Bug in ORDER BY

2003-02-17 Thread Steven Roussey

 SELECT * FROM EventList ORDER BY 'EventDate', 'EventOrder' LIMIT 50;

I'm surprised you happened to get anything in order. Maybe the message got
simplified by the list manager, but did you really mean to order by a
constant string?

Why not:
SELECT * FROM EventList ORDER BY `EventDate`, `EventOrder` LIMIT 50;
Or better:
SELECT * FROM EventList ORDER BY EventDate, EventOrder LIMIT 50;

This wasn't the query you had the issue with, but it is easier to quote. ;)

Same theory applies. Discard this if the list manager had mangled your post.

-steve-



-
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

rownum

2003-02-17 Thread geeta varu

does mySQL have 
rowid or rownum 
if yes please give an exampl

__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

-
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: Oh GAWD somone HELP :)

2003-02-17 Thread Poodle

i can coneect from localhost

and all machines can see all machines

i made users with access from hosts
i made users with database access from hosts

still the same 

- Original Message - 
From: Bryan Lipscy [EMAIL PROTECTED]
To: 'Poodle' [EMAIL PROTECTED]
Sent: Tuesday, February 18, 2003 12:23 AM
Subject: RE: Oh GAWD somone HELP :)


 Can you connect locally?
 Can the remote machine see the host machine?
 
 Try
 mysqladmin -h 192.168.0.2 -u root -p
 
 (note the space between -u and root)
 
 

-
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: Oh GAWD somone HELP :)

2003-02-17 Thread Poodle

Well thats the thing,

I did an more than one user that was allowed to connect TO 192.168.0.2 from
various hosts on my network
and all hosts can reverse lookup from my dns server.

no good
- Original Message -
From: KH Chiu [EMAIL PROTECTED]
To: Poodle [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 18, 2003 2:53 AM
Subject: Re: Oh GAWD somone HELP :)

 You should add a user who allow to connect from 192.168.0.2 before you can
 connect to MySQL remotely.

 Further more, make sure that your host can reverse lookup 192.168.0.2.
This
 can be done by add an entry in the /etc/hosts or create a DNS entry.

 Regards,

  Just installed mysql nice one i though

  set it all up read the nessasary docs nice one i thought

  tried to connect remotly

  [root@tasha root]# mysqladmin -h 192.168.0.2 version -uroot -
  ppassword mysqladmin: connect to server at '192.168.0.2' failed
  error: 'Lost connection to MySQL server during query'

  oh bugger

  played around with the configs for a few hours

  tried everything i could think of

  read some more docs

  tried everything i could think of again

  still the same

  any ideas?

  -
  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 mysql-unsubscribe-
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 --
 Yours,
 KH Chiu
 CA Computer Consultants Ltd.
 Tel: 3104 2070 Fax: 3010 0896
 Email: [EMAIL PROTECTED]
 Website: www.caconsultant.com

 -
 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

-
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

74 matches

Mail list logo