date:20030111

Re: reset auto_increment

2003-01-11 Thread Paul DuBois

At 16:06 -0500 1/10/03, "INVALID - TESTING ONLY.  IF YOU GET EMAIL 
WITH THIS ACCOUNT P wrote:
I need to reset the auto_increment in a table full of data.  I had a problem
recently where some script was putting InvoiceID numbers into an
auto_increment CustID column...I since fixed the problem and corrected the
data but I now have a huge gap in my number sequence and I cant get
auto_increment reset to a more reasonable value.



Now I have read the archives and the online manual with user comments and
nothing has worked as of yet.


What is your table type?





ALTER TABLE tbl_name AUTO_INCREMENT = 1


Should work.



this command gives me a successful response but when I do a SHOW TABLE
STATUS the Auto_increment is still unchanged.


What value does it show, and what is the maximum value still in your
table?  If you expect this to set the next value *lower than the current
maximum value in the table*, it won't.  That's not how it works.





myisamchk -A=1 /path/to/db.MYI


-A=1 is invalid syntax.  Should be -A1 (no space) or
--set-auto-increment=1




this command also gives me a successful message but never changes the
auto_increment when displayed by SHOW TABLE STATUS



in section 3.5.9 of the MySQL manual with user comments I noted the
following comment on Oct 23 20002 by Ethan Pooley

http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html

He stated that the ALTER TABLE tbl_name AUTO_INCREMENT = 1 will only work
when the table is empty.


That's incorrect.




So what I need is the ability to reset the auto_increment without having to
empty the table first.  Or I need someone to help me figure out why the
above mentioned commands fail to do what everyone tells me they are suppose
to do.



-Jason



-
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 backend for mailing list

2003-01-11 Thread Mike

Hi there,

I'm making a library website where users can store preferences about the
types of books/cds/etc... they like (e.g. romance, rock, cooking, etc).
Once a month the list of 'New Releases' is updated. Currently there is a New
Release box which shows releases based on the users preferences.

What I'd like to do is extend it to offer email functionality. Send out an
email once a month, if they wish, with information about titles relevant to
them. I know it would be a fairly trivial issue to send out a static email
to all the subscribers so everyone gets the same content. What I'd like to
do is email each user a list of new titles based on their preferences
(stored in a MySQL). I've already made a MySQL query to extract the 
preferences.
I'm estimating a maximum of about 8-10,000 users would use the service
(We have about 100,000 members in total).

We were going to use MS SQL which had some built in email functionality but
we moved over to open source and now I'm trying to find an alternative way.
The site will be on a shared webserver (And I only have FTP access) and the
large number of emails means I can't just just send them all using PHP --
I'm assuming it'd just take far too long.

I'm considering sending the emails out over a period of time each month to
reduce the load, e.g. A-H surnames at 11pm, I-M surnames midnight, M-Z
surnames at 1am or something like that. The other method, probably more of a
final resort, would be to make a PHP script to output (what will be) the
emails to a browser, download the file, have a seperate program actually
send the emails -- however I suspect this too might take up too much of PHPs
time, and too much bandwidth.

Has anyone tried to do something like this before, what did you end up
using, etc...?

Cheers,

Mike.

mysql , query


p.s. sorry for this second post, my last one only ever appeared in the 
newsgroups and not in the mailing list archives so I think it might have 
been flagged as spam.


-
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

reset auto_increment

2003-01-11 Thread INVALID - TESTING ONLY. IF YOU GET EMAIL WITH THIS ACCOUNT PLEASE REPLY TO [EMAIL PROTECTED] INSTEAD. OBVIOUSLY WE MADE A MISTAKE IF YOU ARE READING THIS

I need to reset the auto_increment in a table full of data.  I had a problem
recently where some script was putting InvoiceID numbers into an
auto_increment CustID column...I since fixed the problem and corrected the
data but I now have a huge gap in my number sequence and I cant get
auto_increment reset to a more reasonable value.
 
Now I have read the archives and the online manual with user comments and
nothing has worked as of yet.
 
ALTER TABLE tbl_name AUTO_INCREMENT = 1
this command gives me a successful response but when I do a SHOW TABLE
STATUS the Auto_increment is still unchanged.
 
myisamchk -A=1 /path/to/db.MYI
this command also gives me a successful message but never changes the
auto_increment when displayed by SHOW TABLE STATUS
 
in section 3.5.9 of the MySQL manual with user comments I noted the
following comment on Oct 23 20002 by Ethan Pooley
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
He stated that the ALTER TABLE tbl_name AUTO_INCREMENT = 1 will only work
when the table is empty.
 
So what I need is the ability to reset the auto_increment without having to
empty the table first.  Or I need someone to help me figure out why the
above mentioned commands fail to do what everyone tells me they are suppose
to do.
 
-Jason


-
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

version 4 or 3

2003-01-11 Thread Nuno Lopes

Hi,

I would like to know what are the main differencies between the version 4
and and version 3 of mysql.
I heard that sql changed in mysql 4. Is this true?? Must I change my
existing programs to update the queries??


Thanking in advance,
Nuno Lopes



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

2003-01-11 Thread Paul DuBois

At 16:36 -0600 1/10/03, Terry & Cheryl Haimann wrote:

Is there an easy way to see If and how much data I have written into a blob?


LENGTH(blob_col_name) might be what you want.




sql...tomakefilterhappy



-
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: cannot get foreign keys to work

2003-01-11 Thread Paul DuBois

At 18:45 +1100 1/10/03, Ben Mooney wrote:

i have been using the following sql to try and get foreign keys 
working, the table creation works fine but when i try and delete 
data from the parent table it deletes as would normally happen in 
mysql, also the desired results do not happen if i use RESTRICT.
is this a problem to do with indexes???

In a sense, yes.  ON DELETE RESTRICT isn't implemented, I believe.




DROP TABLE IF EXISTS parent;
CREATE TABLE parent(id INT NOT NULL, name char(5), PRIMARY KEY (id)) 
TYPE=INNODB;
DROP TABLE IF EXISTS child;
CREATE TABLE child(id INT NOT NULL, parent_id INT, INDEX par_ind 
(parent_id), PRIMARY KEY (id),
 FOREIGN KEY (parent_id) REFERENCES parent(id)
 ON DELETE RESTRICT
) TYPE=INNODB;

insert into parent(name) values('asdfg');
insert into child(parent_id) values(last_insert_id());


system
os x 10.2.3
mysql 3.23.53-entropy.ch


-
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 question (group by) - please help

2003-01-11 Thread Paul DuBois

At 14:41 +0100 1/10/03, Damir Dezeljin wrote:

Hi.

I want to calculate how many rows my query which uses 'GROUP BY' returns.

The query:

SELECT 
FROM test
WHERE (kid=1) OR (kid=2) OR (kid=4)
GROUP BY cid,aid;


Is it posible to get number of rows with such a query from MySQL v3.23.49?


You want both a list of rows, and a count of the number of rows -- with
a single query.  That doesn't make sense, because those two things are
incompatible.


If it isn't posible ... is it posible in MySQL 4.x?


MySQL 4.x won't change the fundamental nature of the incompatibility.
The strategy you use below is reasonable.



I think a lot about this problem and I realize only the following
solution:
CREATE TEMPORARY TABLE t (i INT);
INSERT INTO t (i) SELECT aid FROM 
SELECT COUNT(*) FROM t;
DROP TABLE t;

But this isn't so elegant.

I want to do so on data generated by:

CREATE TABLE test (
kid INT,
aid INT,
cid INT
);

INSERT INTO test
(kid, aid, cid) VALUES
(  1,   0,   1),
(  2,   2,   2),
(  1,   3,   2),
(  2,   3,   2),
(  4,   4,   2),
(  4,   0,   3),
(  3,   3,   4),
(  4,   3,   4);


Regards,
Dezo



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

2003-01-11 Thread Zak Greant

On Fri, Jan 10, 2003 at 04:36:07PM -0600, Terry & Cheryl Haimann wrote:
> Is there an easy way to see If and how much data I have written into a blob?

  You can find the length of a blob in bytes using the LENGTH function:

SELECT LENGTH(column) FROM table;

  You can also use BIT_LENGTH to find the length in bits.


  Cheers!

  :sql:
-- 
 Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate |  http://zak.fooassociates.com

Using and Managing MySQL
  MySQL Training: New York, January 13-17, 2003
  Visit http://mysql.com/training for more information

"While we are postponing, life speeds by."--Lucius Annaeus Seneca

-
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: host table in mysql database

2003-01-11 Thread Paul DuBois

At 15:15 +1100 1/10/03, Guy Waugh wrote:

Hi there,

I'm cleaning up MySQL permissions on one of my servers, and I see 
that in the mysql.host table, there are 8 rows. All 8 rows contain 
specific hosts in the 'Host' column (i.e. no wildcards) and specific 
databases in the 'Db' column. Further, all rows in all privilege 
columns in the host table contain 'Y'.

I see from reading Paul DuBois' MySQL book that MySQL ANDs 
privileges in the host table with privileges in the db table, 
allowing administrators to revoke particular privileges for users 
connecting from particular hosts.

Can anyone tell me, then, if the host table is currently having any 
effect on permissions? I'm thinking not, as a logical AND of the 
host table 'Y' and the db table 'Y' or 'N' will result in the 
privilege recorded in the db table.

True.

Also, given what you say in the next paragraph, the host table will never even
be consulted.



Also, Paul's book says that the host table is only checked if the 
'Host' column in the relevant client's row in the db table is blank, 
and all rows in the db table contain values in the 'Host' column. So 
on that fact alone, it looks like I can delete all rows in the host 
table without permissions being affected...?

On that fact alone, yes.  Perhaps you simply have rows in the host table
because you were experimenting with it at some earlier time?



Just wanted some opinion/advice before I potentially get myself into 
trouble ;-)

You can always back up the tables in the mysql database first. :-)



Thanks in advance,
Guy.



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

2003-01-11 Thread David T-G

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

George --

...and then Gman said...
% 
% How can I delete a database in MySQL so I recreate it?

  echo 'drop database dbname' | mysql -uuser -ppassword

where dbname is the name of your database, user is your mysql user name,
and pass is the password for that user.  More in the manual :-)


% 
% George Flatman


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+H6KTGb7uCXufRwARAilaAJsH9u1eyqKX4bB5gIN58hbsJ0DQfgCfZyiZ
SQVo1nCEczvLTl9usqYZyu4=
=/O72
-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

Re: Question

2003-01-11 Thread Paul DuBois

At 14:51 -0800 1/10/03, Gman wrote:

How can I delete a database in MySQL so I recreate it?

George Flatman


It's in the manual:

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

-
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: Hiding the password

2003-01-11 Thread Octavian Rasnita

Can you tell us what could be the security problem if Apache is set to
run as each user's accounts?
Is it a problem if you also allow SSH or Telnet access to users' accounts?

Thank you.

Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]

- Original Message -
From: "William R. Mussatto" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc: "Larry Brown" <[EMAIL PROTECTED]>; "MySQL List"
<[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 8:56 PM
Subject: Re: Hiding the password


On Thu, 9 Jan 2003, Octavian Rasnita wrote:

> Date: Thu, 9 Jan 2003 07:56:20 +0200
> From: Octavian Rasnita <[EMAIL PROTECTED]>
> To: "William R. Mussatto" <[EMAIL PROTECTED]>
> Cc: Larry Brown <[EMAIL PROTECTED]>,
> MySQL List <[EMAIL PROTECTED]>
> Subject: Re: Hiding the password
>
> Yes I know that Apache can be set to run using your own account, but most
> hosts don't do that because I heard that this can create other security
> problems.
We screen the users we allow to do this.  It isolates them, but does
allow that apache child to have more rights than 'nobody'.
these users already have ftp access, but they are chrooted to their own
area.
Part of the protection would have to be ensuring the files are not world
readable.

>
> Teddy,
> Teddy's Center: http://teddy.fcc.ro/
> Email: [EMAIL PROTECTED]
>
> - Original Message -
> From: "William R. Mussatto" <[EMAIL PROTECTED]>
> >
> Its possible to configure a single virtual host to run as a different
> user and group.  It still won't protect you from people at the hosting
> company, but other hosting clients should be isolated.
>

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27




-
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

给您一个成功的起点

2003-01-11 Thread cfplhhs

ÔÚÈËµÄÒ»ÉúÖÐ£¬Í¨³£ÓÐºÃ¶à»ú»á...ÓÐÈËÒÔÎª»ú»á´ÓÀ´²»»á½µÁÙÓÚËûµÄÍ·ÉÏ£¬Òò´Ë£¬Ëû´í¹ýÁË...ÓÐµÄÈËÓöµ½ÕâÑùµÄ»ú»á²¢
 
ÇÒ°ÑÎÕ×¡ÁË£¬Òò´ËËû±äµÄ¸»ÓÐÁË..³É¹¦ÆäÊµºÜ¼òµ¥..¾ÍÊÇÒ»ÄîÖ®¼ä..ÄãÒ»ÉúÖÐ·Ç³£ÄÑµÃµÄ»ú»áÏÖÔÚ¾ÍÔÚÄãµÄÑÛÇ°£¬Ò²ÐíÄã¶àÄêÃ»ÓÐÊµÏÖµÄÃÎÏë¾Í½«ÔÚÔÚ¶ÌÊ±¼äÄÚÇáËÉÊµÏÖ¡£Èç¹ûÕâ¸öÄÜ¸Ä±äÄãÒ»ÉúÃüÔËµÄ¼Æ»®ÄÜÈÃÄã¼ÓÈë²¢ÇÒ³äÂúÐÅÐÄ£¬ÄãÓ¦¸ÃÁªÏë»¹ÓÐ¶àÉÙÈËÒ²»á¼ÓÈë²¢ÇÒ³äÂúÐÅÐÄ¡£²»¹ýÄã±ÈËûÃÇÇÀÏÈÒ»²½¼ÓÈë£¬ËûÃÇ½«³ÉÎªÄãµÄÏÂ¼¶´úÀí»áÔ±...
 
×¬Ç®£¿±¾À´ÎÒÒ²²»ÏàÐÅµÄ£¬µ«ÎÒ¼ÓÈëÆÕ¹âÊÂÒµÖ®ºó£¬(218.5.79.211/soho/?mid=cfplhhs)ÊÇÕæµÄÄÜ×¬µ½Ç®£¬ÒòÎª±¾ÒâÊÇÊÔÊÔ°ÕÁË£¬ÊÔÁËÒ»
 ¸öÔÂ£¬ÊÕµ½ÁË100¶àÔªÈËÃñ±Ò£¬µÚ¶þ¸öÔÂ£¬ÊÕµ½ÁË1¶àÔª¡£ºóÀ´£¬ÎÒÓÖÅ¬Á¦¹¤×÷£¬×¬µÄÒ²²»ÉÙ¡£
¡¡
ÓÐºÜ¶àÈË²»ÏàÐÅÎÒÕâÀïËùÐ´µÄ»°£¬Òò´Ë£¬ÎÒÌØµØÔÚÕâÀï×¢Ã÷Ò»ÏÂ£ºÕâ²»ÊÇÃâ·Ñ 
µÄ£¬Ò²ÓÐÍ¶Èë£¬ÎªÍøÕ¾½éÉÜºÍÕÐÈË¼ÓÈë¡£ÕâÐ©¾ÍÊÇ¹¤×÷£¬Õâ¾ÍÊÇ×¬Ç®¡£Äã×¢²áÎªÐÂ»áÔ±Ê±¸øÉÏÏß¼ÄÇ®£¬·¢Õ¹ÁËÏÂÏßÊ±,ÏÂÏßÒ²¸øÄã¼ÄÇ®
 
£¬ÏÂÏßÔÙ·¢Õ¹µÄÏÂÏßÒ²»á¸øÄã¼ÄÇ®£¬ÄãµÄÇ®Ô½À´Ô½¶à¡£Äã¿ÉÄÜÈÏÎªÕâÊÇ´«Ïú£¬µ«ÕâÓë´«ÏúÓÐ±¾ÖÊµÄÇø±ð¡£´«ÏúµÄ¼ÛÖµÓë¼Û¸ñÑÏÖØ±³Àë£¬¶øÆÕ¹âÊÂÒµÍ¶Èë½ö50ÔªÇ®£¬¾Í¿ÉÒÔ»ñµÃ·áºñµÄÊÕÒæ¡£µ±È»ÁË£¬Õâ±ØÐëÔÚ³ÏÊµµÄÀÍ¶¯ÏÂ£¬ÐÁÇÚµÄÀÍ¶¯ÏÂ¶ø»ñµÃµÄ¡£
¡¡ ÎÒ×öµ½ÁË£¬ÏÖÔÚÄãÒ²ÓÐ»ú»á 
  
Ò»¸öÔÂ×¬ÍòÔªµÄ´´Òµ»ú»áÁ¢¿Ì¾Í°ÚÔÚÄãµÄÃæÇ°¡£¾ÝÍ³¼Æ£¬ÔÚ¸Õ¸Õ¹ýÈ¥µÄÉÏ¸öÔÂ£¬È«¹úÒÑÓÐ15341ÈËÔÚÉÏÃæµÄÍøÕ¾ÌÔ½ðÖÐÈË¾ùÔÂÊÕÈë³¬¹ý3000Ôª¡£Ä¿Ç°ÔÂÊÕÈë×î¸ßÕßÎªÌì½òµÄÂÞ¹úÖù147570Ôª/ÔÂ£»ÉÏº£µÄÁÖÓÂ139132Ôª/ÔÂ£¨·¢´ïµØÇøÈË½ÓÊÜÐÂÊÂÎï¿ì£©£¬¶øÕâÒ»ÇÐ¶¼ÊÇÔÚ¹¤×÷Ö®ÓàÔÚ¼Ò»òÔÚÍø°ÉÖÐÍê³É¡£Ò»Ìì¹¤×÷1-3Ð¡Ê±¾Í¿ÉÇáÇáËÉËÉ°ÑÇ®×¬¡£
  
Ö»ÒªÄã°´ÏµÍ³µÄÒªÇó×¢²áºó£¬±ã¿ÉÌìÌì×øÔÚ¼Ò¼æÖ°×öÊ±ÉÐsohoÒ»×å£¡ÅóÓÑ£¬Ç§ÔØÄÑ·êµÄ»ú»á£¬Ô¸ÓÑ±ð´í¹ý£¡ÔçÒ»ÌìÉÏÍø£¬ÔçÒ»Ìì±È±ðÈËÏÈ·¢²Æ£¡µ±È»ÁËÈç¹ûÄãµ½ÏÖÔÚ»¹Ã»Ñ§»áÍøÉÏ×¬Ç®£¬ÄÇ¿É¾ÍÌ«ÁîÈËÒÅº¶ËÀÁË£¡£¡
 ¡¡ »áÔ±È¨Àû 
£±.Ò»´Î×¢²áÖÕÉíÓµÓÐ´úÀí»áÔ±×Ê¸ñ¡£ 
£².Ã¿¸ö»áÔ±ÓµÓÐÒ»¸öÈ«Ì×¸öÐÔ»¯µÄÆÕ¹âÍøÂçÓªÏúÏµÍ³´úÀíÍøÕ¾¡£
3.»áÔ±ÓÐÎÞÏÞ´ÎÍÆ¼öÏÂ¼¶´úÀí¶ø»ñÈ¡»Ø±¨µÄÈ¨Àû¡£
4.»áÔ±µÄÊÕ¿îµØÖ·µÈ¸öÈËÐÅÏ¢ÄÜ´ÓÖ÷Ò³µÇÂ¼ÐÞ¸Ä¡£
¾ßÌå×¢²á·½·¨ÈçÏÂ£º 
Ê×ÏÈ½øÈë¸ÃÍøÕ¾¡££¨Èç¹ûÓÃÉÏ±ß½éÉÜµÄÍøÖ·½ø²»È¥£¬Çë°ÑÏÂÃæµÄÍøÖ·¸´ÖÆµ½µØÖ·À¸Àï½øÈë¸ÃÍøÕ¾£º
 
http://218.5.79.211/soho/?mid=cfplhhs 
µã»÷ÍøÒ³ÓÒ±ßÖÐÉÏ²¿µÄ¡°×¢²á¡±£¬½øÈë×¢²áÒ³Ãæ½øÐÐ×¢²á£º 
ÓÃ»§Ãû:±ØÐëÌîÐ´£¬ÓÃÓÚÒÔºóµÇÂ¼ÍøÕ¾ÓÃµÄ£¬Òª¼Ç×¡ßº £¡(Ö»ÄÜÌî×ÖÄ¸»òÊý×Ö) 
ÐÕÃû£º(ÌîÄãµÄÕæÊµÐÕÃû(ÖÐÎÄ)ÎªÁËÒÔºóµÄÊÕÇ®·½±ã£¬ÒÔºó²»ÄÜ¸Ä¶¯) 
ÒøÐÐ¿¨ºÅ/¿ª»§ÐÐ£ºÔÝÊ±¿ÉÒÔ²»ÌîÐ´£¬ÒÔºó¿ÉÒÔ¸ü¸ÄµÄ¡£ 
ÓÊ±à/µØÖ·£º ¿ÉÒÔ¼òµ¥ÔÚÏÈÌîÐ´Ò»¸öÓÊ±à¾Í¿ÉÒÔÁË£¬ÒÔºó¿ÉÒÔ¸ü¸ÄµÄ¡£ 
E-mail£º Èç¹ûÃ»ÓÐ¿ÉÒÔÈ¥ÉêÇëÒ»¸öÃâ·ÑµÄÐÅÏä¡£ 
êÇ ³Æ£º(ÄãÔÚÍøÉÏÓÃµÄÃû×Ö£¬¿ÉËæÒâÌî) 
½¨Òé»ã¿î·½Ê½£ºËæ±ãÑ¡Ò»¸ö¾ÍÐÐÁË£¬ÒÔºó¿ÉÒÔ¸ü¸ÄµÄ¡£ 
Éí·ÝÖ¤ºÅÂë£º 
Ò»¶¨ÒªÌîÐ´µÄ£¬µ±È»Èç¹ûÄãÏÖÔÚ¼Ç²»ÆðÀ´ÁË£¬Ò²¿ÉÒÔÂÒÐ´Ò»¸ö18Î»µÄÊý×Ö£¬µ«Òª·ûºÍÉí·ÝÖ¤±àÂë¹æÔò²¢¼Ç×¡ÁË£¬
 (ÈçÃÜÂë¶ªÊ§Ê±ÓÃÀ´È·¶¨ÄãµÄÉí·Ý) 
×¢²á³É¹¦ºó£¬Äã¾ÍÓÐÒ»¸öÏµÍ³·ÖÅäµÄÁÙÊ±ÍøÕ¾£¬ÉÏÃæÓÐÄãµÄ4¸öÉÏÏß£¬Äã°´ÕÕÒªÇó£¬·Ö±ð¼ÄÇ®¸øËûÃÇ£¬²¢·¢ÓÊ¼þ¸øËûÃÇÈ·ÈÏ¡£
ËûÃÇÊÕµ½Ç®ÒÔºó¾Í°ÑÄã¼¤»î£¬Äã¾ÍÓÐÒ»¸öÄãµÄÕýÊ½ÍøÕ¾¡£

Äã¿ÉÒÔÀûÓÃ¸÷ÖÖ±ãÀûµÄÍøÂçÊÖ¶Î½øÐÐÐû´«£¬½éÉÜÈË³ÉÎªÄãµÄÏÂÏß£¬Äã¾Í¿ÉÒÔ²»¶ÏµÄÊÜµ½ÏÂÏß¼ÄÀ´µÄÇ®¡£
ºÃÁË£¬×£ÄãÃÎÏë³ÉÕæÑ½£¡²»£¬Ó¦¸ÃÊÇ´ó¼ÒÒ»ÆðÃÎÏë³ÉÕæ£¡ 
 


mysql:ÄúºÃ!



ÖÂ
Àñ!
   cfplhhs
   [EMAIL PROTECTED]
   2003-01-11

-
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 monitoring

2003-01-11 Thread David Lubowa

i think he was speaking more of graphical stats ..if i am not
mistaken...mytop cant give you that or atleast i havent seen it..but it
wouldnt be bad if it could have those stats in a graphical format.

cheers
David Ziggy Lubowa
Network Engineer
One2net (U)
web: www.one2net.co.ug
Tel: +256 41 345466

-Original Message-
From: Dr. Poo [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 5:07 PM
To: Michael Weiner; [EMAIL PROTECTED]
Subject: Re: mysql monitoring

I didn't read the original thread...but go to CPAN and check out MyTop.pl.
Just like unix Top process watch application, but for mysql... pretty cool!

-Chris

On Thursday 09 January 2003 06:02 pm, Michael Weiner wrote:
> There are a few solutions out there for you. I recommend you check out
> RRDTOOL,
> and associated packages at
> http://people.ee.ethgz.ch/~oetiker/webtools/rrdtool/ and also look for a
> took called cactus, it absolutely rules. THere are others, but rrdtool,
> has a myriad of contributed packages it can work with to monitor email
> servers, bandwidth, and just about anything you can think of.
>
> Enjoy
> Michael Weiner
> 
> sql,query,queries,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

-
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: file permissions problem on ALTER TABLE

2003-01-11 Thread Mark

Can the MySQL AB folks please tell me whether this bug really exists in
3.23.54a? And, if so, can we look forward to 3.23.54b soonish? I am not
ready yet for the 4.x series, as I generally frown upon running such a major
engine for my server in gamma/beta software. But a shiny new 3.23 version
would just do the trick. :)

- Mark

System Administrator Asarian-host.org

---
"If you were supposed to understand it,
we wouldn't call it code." - FedEx


- Original Message -
From: "Manuzhai" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 11, 2003 12:31 AM
Subject: Re: file permissions problem on ALTER TABLE

> Hmm, okay, but isn't the 3.23 supposed to be stable and thus more bugless
> than a gamma like 4.0.7?
>
> And also, I was wondering when 4 is going to be released as stable.
> Looking over the changelogs, it shouldn't be too long, right?
>
> Zak: thanks for the advice. I got real pissed off about it, since it seems
> like a real bug. :) But I guess it helps pretty good.
>
> Regards,
>
> Dirkjan
>
> - Original Message -
> From: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>
> To: "Dirkjan Ochtman" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, January 10, 2003 11:45 PM
> Subject: Re: file permissions problem on ALTER TABLE
>
> > Dirkjan,
> >
> > > I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I
> > > encountered a weird problem: when trying to ALTER a TABLE, MySQL said
> > > that it no permissions to rename the *.myi file for that table.
> >
> > Last 3.23 I used was 3.23.49, and I didn't have an ALTER TABLE problem,
> > neither on Win98, Win2K, nor Linux. I did have problems like the ones
> > you describe with 4.0.1, 4.0.3 and 4.0.4 under Win98 and Win2K. Using
> > 4.0.7 now und Win98 and Win2K, the ALTER TABLE problems have gone.
> >
> > Reporting this problem to the list, I heard strange advices like "switch
> > lower_case_table_names to 0". I believe it's a MySQL on Win bug with the
> > 4.0.x versions mentioned above, and it might also affect 3.23 version
> > after 3.23.49.
> >
> > My advice is: Update, MySQL 4.0.7 is real funky :)
> >
> > Regards,
> >
> > --
> >
> > Stefan Hinz <[EMAIL PROTECTED]>
> > Geschäftsführer / CEO iConnect GmbH 
> > Heesestr. 6, 12169 Berlin (Germany)
> > Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
> >
> > - Original Message -
> >
> > From: "Dirkjan Ochtman" <[EMAIL PROTECTED]>
> >
> > To: <[EMAIL PROTECTED]>
> >
> > Sent: Friday, January 10, 2003 7:40 PM
> >
> > Subject: Bug: file permissions problem on ALTER TABLE
> >
> > > > Hi there,
> > > >
> > > > I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I
> > > > encountered a weird problem: when trying to ALTER a TABLE, MySQL
> > > > said that it no permissions to rename the *.myi file for that table.
> > > > I kept encountering this problem (trying to go from VARCHAR(6) to
> > > > CHAR(6) for an index field), but it would only work after I
> > > > restarted the mysqld-max-nt. Immediately after restarting the
> > > > server, it worked, but then after a few minutes I tried to ALTER
> > > > another field in the table, and it had the same problem. So I
> > > > restarted the server again, it went through, but the problem
> > > > persisted. I checked the file permissions, but everyone has full
> > > > control to the files.
> > > >
> > > > The table now looks like this:
> > > >
> > > > CREATE TABLE postcodes (
> > > > id mediumint(8) unsigned NOT NULL auto_increment,
> > > > postcode char(6) NOT NULL default '',
> > > > plaats smallint(5) unsigned NOT NULL default '0',
> > > > straat mediumint(8) unsigned NOT NULL default '0',
> > > > low mediumint(5) unsigned NOT NULL default '0',
> > > > high mediumint(5) unsigned NOT NULL default '0',
> > > > parity enum('0','1','2') NOT NULL default '2',
> > > > PRIMARY KEY  (id),
> > > > KEY postcode (postcode)
> > > > ) TYPE=MyISAM;
> > > >
> > > > It has 570,441 rows.
> > > >
> > > > Is this a bug in MySQL, or am I doing something wrong? I was using
> > > > phpMyAdmin to do the changes, but I don't think that should make any
> > > > difference.


-
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 question (group by) - please help

2003-01-11 Thread Damir Dezeljin

> >
> >SELECT 
> > FROM test
> > WHERE (kid=1) OR (kid=2) OR (kid=4)
> > GROUP BY cid,aid;
> >
> >Is it posible to get number of rows with such a query from MySQL v3.23.49?
>
> You want both a list of rows, and a count of the number of rows -- with
> a single query.  That doesn't make sense, because those two things are
> incompatible.
I make a mistake by not specifing my problem in more detail. I will try to
be more specific:

I'm writing my own search engine for my web site. I want to output for
each result on each page (20 results per page) the no_of_current_result /
no_of_total_results . So with a first query I want to get a count of the
number of rows. Then I will execute a query with LIMIT  to get
results for the current page.

Is it posible to get number of all results without geting all results in a
temporary table and then count them? If yes, how?

Thanks and regards,
Dezo


-
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 LOAD_FILE problems

2003-01-11 Thread Herbert Kunzmann


Using MySQL, I have a problem where I am attempting to upload a 16.4MB file
into a BLOB field, but the insert fails with a

ERROR 1030: Got error 139 from table handler

and after trying again I get

ERROR 1062: Duplicate entry 'bla' for key 1

BUT the entry was never made. I need to repair the table in order to
continue on.

Can anyone give me a hint on what to do ? I remain somewhat lost...




-
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

Question about JOIN behaviour - I can't figure out how it works

2003-01-11 Thread Damir Dezeljin

Hi.

I searched MySQL manual but I stil don't know how a JOIN works. I would
like to avoid diging into sources so I'm posting this mail.

I have two tables:
- a HUGE table having a row ID_keywords
- a SMALL table with keywords and columns ID_keywords and keyword_name

I have to select some rows from a HUGE table that have certain keywords
(there can be 10.000 or even more results). I can acomplish this in two
ways:

1. SELECT  FROM
 HUGE h LEFT JOIN SMALL s
   ON h.ID_keywords=s.ID_keywords
 WHERE (s.keyword_name='name1') OR (s.keyword_name='name2') OR ...
 GROUP BY ...
2. First get ID_keywords for , ,... and then do:
   SELECT  FROM
 HUGE
 WHERE (ID_keywords=) OR (ID_keywords=) OR
...
 GROUP BY ...

And now the question:
- How does the JOIN works? Does it first get IDs from the second table
(SMALL)
  and then use them for the WHERE clause?
- Which query from the above examples will be faster (on my test data I
get
  every time the response that the query finished in 0.0s , but I'm now
working
  only on a small set of data and not on read data which aren't available
to
  me right now)?
- Is there some diference if I made a join on a join? E.g.:
  SELECT  FROM
table1 LEFT JOIN table2
  ON 
LEFT JOIN table3
  ON 
WHERE 
GROUP BY ...


Thanks and regards,
Dezo




-
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

Lock Tables Timeout value?

2003-01-11 Thread Clyde

Hi,

I have searched the docs but can't seem to find information on the time out value for 
"Lock Tables" (probably just me)

When using "Lock Tables" how long does MySql wait before giving up if it can't get a 
lock?

Is there any way of changing this time out value?

Thanks
Clyde England




-
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: file permissions problem on ALTER TABLE

2003-01-11 Thread Dirkjan Ochtman

Hi there,

I still have problems with this when using MySQL 4.0.8. When I try to DROP a
DATABASE, it will go through and delete all the tables, except the last two,
apparently because it "can't delete the table.myi file". When I restart the
server, I can DROP one of the tables, then I get the error again for the
other table, so then I restart the server again and I can DROP the last
table. The problem also persists on ALTERing TABLEs.

Regards,

Dirkjan

> Dirkjan,
>
> > I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I
> encountered a
> > weird problem: when trying to ALTER a TABLE, MySQL said that it no
> > permissions to rename the *.myi file for that table.
>
> Last 3.23 I used was 3.23.49, and I didn't have an ALTER TABLE problem,
> neither on Win98, Win2K, nor Linux. I did have problems like the ones
> you describe with 4.0.1, 4.0.3 and 4.0.4 under Win98 and Win2K. Using
> 4.0.7 now und Win98 and Win2K, the ALTER TABLE problems have gone.
>
> Reporting this problem to the list, I heard strange advices like "switch
> lower_case_table_names to 0". I believe it's a MySQL on Win bug with the
> 4.0.x versions mentioned above, and it might also affect 3.23 version
> after 3.23.49.
>
> My advice is: Update, MySQL 4.0.7 is real funky :)
>
> Regards,
> --
>   Stefan Hinz <[EMAIL PROTECTED]>
>   Geschäftsführer / CEO iConnect GmbH 
>   Heesestr. 6, 12169 Berlin (Germany)
>   Tel: +49 30 7970948-0  Fax: +49 30 7970948-3
>
> > > Hi there,
> > >
> > > I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I
> encountered a
> > > weird problem: when trying to ALTER a TABLE, MySQL said that it no
> > > permissions to rename the *.myi file for that table. I kept
> encountering
> > > this problem (trying to go from VARCHAR(6) to CHAR(6) for an index
> field),
> > > but it would only work after I restarted the mysqld-max-nt.
> Immediately
> > > after restarting the server, it worked, but then after a few minutes
> I
> > tried
> > > to ALTER another field in the table, and it had the same problem. So
> I
> > > restarted the server again, it went through, but the problem
> persisted. I
> > > checked the file permissions, but everyone has full control to the
> files.


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

2003-01-11 Thread Zak Greant

On Fri, Jan 10, 2003 at 11:50:28PM -0500, David T-G wrote:
> George --
> 
> ...and then Gman said...
> % 
> % How can I delete a database in MySQL so I recreate it?
> 
>   echo 'drop database dbname' | mysql -uuser -ppassword
> 
> where dbname is the name of your database, user is your mysql user name,
> and pass is the password for that user.  More in the manual :-)

  I bet that he wants to be able to recover it after the delete! :)

  George, to truly recreate a database after delete, you will need to
  have a backup copy of the database.

  You can create the backup with the mysqldump utility, with replication
  or by copying the data files. See http://mysql.com/doc/en/Backup.html
  for more details.

  Cheers!
-- 
 Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate |  http://zak.fooassociates.com

MySQL Tip: Connect to a remote MySQL server using the mysql client
  % mysql --host=example.com --user=admin -p

"While we are postponing, life speeds by."--Lucius Annaeus Seneca

-
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: Enabling Cache feature in MySQL 4

2003-01-11 Thread Paul DuBois

At 18:22 +0100 1/10/03, Blaster wrote:

Happy as I was, I pulled out a test box, installed Linux Debian on 
it, downloaded MySQL 4 on it, everything worked smooth, now I wanted 
to enable
the cache feature, but it didn't let me! I want the change to be 
permanent, so I looked up the doc pages at mysql.com, and found info 
about the
/etc/my.cnf file, which I created and put in:

[mysqld]
set-variable = query_cache_size = 67108864

The MySQL deamon was restarted, but when I checked the run-time 
variables with SHOW STATUS, query_cache_size was still set to 0? I 
even tried

That's odd, since it's SHOW VARIABLES that displays query_cache_size.
SHOW STATUS displays the Qcache_% variables.  But anyway, the syntax
looks okay; I use a similar line on my laptop:

set-variable = query_cache_size=1M

(1M = 1 megabyte)


rebooting the entire machine after the changes to my.cnf, but it 
wouldn't work -- as if MySQL ignored my file? Now, I was thinking, 
either MySQL
reads the setting from somewhere else in my system, but since I 
cannot find a "config file" variable in SHOW STATUS, I cannot find 
out from where?
Another possibility is that it does read it, but for some reason 
ignores it, or even worse, reads a 2nd config file and the setting 
is overriden?

Possibly.  mysqld --help will show you the option files that it reads,
and mysqld --print-defaults will show you the option settings that it's
picking up from option files.



Now, this was quite odd I thought, so I tried to set the cache 
manually with a query,

"SET GLOBAL query_cache_size=67108864"

and that worked like a charm, it even updated "query_cache_type" to 
1, which, according to the manuals mean ON.

Now, I was wondering if any of you have a hint on what might be wrong?

Also, as a little sidenote, I'm kinda wondering, what is a _decent_ 
size for the Cache buffer? is 64 Mb enough? I'm getting an upgraded 
server aswell, it
will be 800 Mhz and have 256 MB of ram, this box will be 100% MySQL 
and I'll leave the Webserver on the old 400 Mhz. Any other hints on 
general
optimizing is appreciated!

I only use 1MB, but I don't have a lot of repeated huge queries.



Sorry if this post got too long, this is my first time posting on 
this list. Take it easy on my poor english skills =)


-
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

Hungarian FONT problem in MySQLCC!

2003-01-11 Thread Interware \(Roboz\)

Hi All,

Please help me. I can't use some hungarian characters (long accent mark ü
and ö) in the MySQL Control Center (version: 0.8.7-alpha, on op.sys.:
Windows 2000 proffesional), because the application changes my fonts to "?"
(question mark) in the query, altough the MySQL server (ver.: 3.23.51) and
its client can store/use this letters.

How can I solve this problem?

Thanks: Bela



-
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 question (group by) - please help

2003-01-11 Thread Joseph Bueno

Damir Dezeljin wrote:
>>>
>>>SELECT 
>>>FROM test
>>>WHERE (kid=1) OR (kid=2) OR (kid=4)
>>>GROUP BY cid,aid;
>>>
>>>Is it posible to get number of rows with such a query from MySQL v3.23.49?
>>
>>You want both a list of rows, and a count of the number of rows -- with
>>a single query.  That doesn't make sense, because those two things are
>>incompatible.
> 
> I make a mistake by not specifing my problem in more detail. I will try to
> be more specific:
> 
> I'm writing my own search engine for my web site. I want to output for
> each result on each page (20 results per page) the no_of_current_result /
> no_of_total_results . So with a first query I want to get a count of the
> number of rows. Then I will execute a query with LIMIT  to get
> results for the current page.
> 
> Is it posible to get number of all results without geting all results in a
> temporary table and then count them? If yes, how?

SELECT COUNT(*)
  FROM test
  WHERE (kid=1) OR (kid=2) OR (kid=4)
  GROUP BY cid,aid;

Should do it, or am I missing something ?

> 
> Thanks and regards,
> Dezo
> 
> 


Hope this Helps
Joseph Bueno


-
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 on large server

2003-01-11 Thread my5ql _

How many connections do you need?

1000? As many as possible I guess. I'd like to maximise usage of the new 
server..


This is what I have in /etc/my.cnf on my current MySQL 3.23 server (dual 
AthlonMP,2GB RAM)

[mysqld]
port		= 3306
socket		= /tmp/mysql.sock
skip-locking
log-slow-queries = slowqueries.log
set-variable	= key_buffer=256M
set-variable	= max_allowed_packet=1M
set-variable	= table_cache=1024
set-variable	= sort_buffer=2M
set-variable	= record_buffer=2M
set-variable	= thread_cache=24
set-variable= max_connections=510
set-variable	= thread_concurrency=16
set-variable	= myisam_sort_buffer_size=64M
set-variable= tmp_table_size=128M
set-variable	= wait_timeout=90

Whilst monitoring the server using 'mytop' is can see the server using 
between 250 & 400 threads, never dropping below 210 threads

'extended-status' reports: Max_used_connections=480

And these numbers are going to grow as the server gets busier, hence the 
Dual Xeon server with 6GB RAM. Instead of added more h/w in the future 
though, I'd like to be able to squeeze more out of Linux/MySQL

I used a C program (thread-limit.c) which tests the amount the threads Linux 
can create (am I correct in assuming these are the same thing?) (I can send 
the 4k file if required)

On my server, the program reports 255 threads max which I believe is down to 
glibc...

With that kind of RAM and horespower you should be able to go well
above 500 connections.


The MySQL binaries are reported to handle 1000-1500 connections. I was 
wondering if anybody has achieved this building with source? If so, what 
version of libs, etc were used?

We tend to use more boxes that cost less and replicate data

I'd like to pursue that route in the future, but our d/b's all need writes 
and I haven't looked into replication hard enough to see how it would fit 
into our scheme.


_
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: QUERY question (group by) - please help

2003-01-11 Thread Damir Dezeljin

Hi again ;)

> SELECT COUNT(*)
>   FROM test
>   WHERE (kid=1) OR (kid=2) OR (kid=4)
>   GROUP BY cid,aid;
This query returns:
+--+
| COUNT(*) |
+--+
|1 |
|1 |
|2 |
|1 |
|1 |
|1 |
+--+
6 rows in set (0.03 sec)

Inest of this I want to get back '6' << so numbers of rows in resulting
query;

The same query WITHOUT 'GROUP BY' returns:
mysql> SELECT COUNT(*) FROM test WHERE (kid=1) OR (kid=2) OR (kid=4);
+--+
| COUNT(*) |
+--+
|7 |
+--+
1 row in set (0.00 sec)

So two rows are grouped because of same cid,did

Any sugestion?

Regards,
Dezo


-
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: Lock Tables Timeout value?

2003-01-11 Thread Mark

Gee, I hope there is no such thing as a timeout value for "Lock Tables". :)
If two of my programs decide that one of them needs to wait for the other,
however long that may take, then I hope MySQL honors that chosen symbiosis.
I hope it behaves like a Perl flock(): it just waits, and waits, and
waits -- and that is how I want it. :)

- Mark

System Administrator Asarian-host.org

---
"If you were supposed to understand it,
we wouldn't call it code." - FedEx


- Original Message -
From: "Clyde" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 11, 2003 10:12 AM
Subject: Lock Tables Timeout value?


Hi,

I have searched the docs but can't seem to find information on the time out
value for "Lock Tables" (probably just me)

When using "Lock Tables" how long does MySql wait before giving up if it
can't get a lock?

Is there any way of changing this time out value?

Thanks
Clyde England


-
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

Beginners Running problems

2003-01-11 Thread alan.keith.simons

Hi

I have installed a downloaded version of mysql on my pc but am experiencing
problems when I try to run the MySQL monitor.

>From the command line:-

C:\mysql\bin

when I type in mysql to activate the monitor, I get the error message:

ERROR 2003: Can't connect to MySql server on 'localhost' (10061)

I cannot seem to find a solution to this problem on your site.

Best regrads

Alan Simons




-
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: Cannot connect after upgrading to mysql-4.0.8

2003-01-11 Thread Egor Egorov

On Saturday 11 January 2003 04:35, Claus Olesen wrote:

> >Description:
>
>   The problem described on
>
> http://bugzilla.redhat.com/bugzilla/long_list.cgi?buglist=75128
> with solution described on
> http://rhn.redhat.com/errata/RHSA-2002-197.html
>   comes back after upgrading to mysql-4.0.8 from 3.23.54a.
>
> >How-To-Repeat:
>
> Install the mysql-4.0.8 rpm posted by www.mysql.com using
> either rpm -U or rpm -e followed by rpm -i on stock Redhat 7.3 with all
> updates from Redhat using Redhat's up2date service.
> After that, connect attempts to the mysql server on Linux from
> a mysql client such as mysql or mysqlcc on W2000 all fail no matter
> how user accounting (host,user,privileges) is setup on either
> box.
>
> >Fix:
>
>   The above solution appears to work i.e. add the involved hosts in
> /etc/hosts and \WINNT\system32\drivers\etc\hosts.

This is already fixed in 4.0.9:
http://www.mysql.com/doc/en/News-4.0.9.html



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

re: version 4 or 3

2003-01-11 Thread Victoria Reznichenko

On Friday 10 January 2003 23:11, Nuno Lopes wrote:

> I would like to know what are the main differencies between the version 4
> and and version 3 of mysql.

Check the manual:
http://www.mysql.com/doc/en/News-4.0.x.html
http://www.mysql.com/doc/en/Nutshell_Other_features.html
http://www.mysql.com/doc/en/Upgrading-from-3.23.html

> I heard that sql changed in mysql 4. Is this true?? Must I change my
> existing programs to update the queries??

There were add new features (you can read about them checking the links 
above), but you can use your old queries as well.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [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

Re: MySQL LOAD_FILE problems

2003-01-11 Thread Stefan Hinz, iConnect \(Berlin\)

Herbert,

> Using MySQL, I have a problem where I am attempting to upload a 16.4MB
file
> into a BLOB field, but the insert fails with a
> ERROR 1030: Got error 139 from table handler

BLOB can store data up to 64 KB only. Use MEDIUMBLOB (up to 16 MB) or
LONGBLOB (up to 4 GB).

For MEDIUMBLOB, be aware that the default communication buffer size is 1
MB only. To increase it, put

 set-variable = max_allowed_packet=16M

in your my.cnf / my.ini file and restart the MySQL server.

For LONGBLOB, be aware that the communication buffer can only be set to
16 MB maximum. INSERTing data bigger than 16 MB means you will have to
use UPDATE to "insert" the data in pieces.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "Herbert Kunzmann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 11, 2003 9:03 AM
Subject: MySQL LOAD_FILE problems


>
> Using MySQL, I have a problem where I am attempting to upload a 16.4MB
file
> into a BLOB field, but the insert fails with a
>
> ERROR 1030: Got error 139 from table handler
>
> and after trying again I get
>
> ERROR 1062: Duplicate entry 'bla' for key 1
>
> BUT the entry was never made. I need to repair the table in order to
> continue on.
>
> Can anyone give me a hint on what to do ? I remain somewhat lost...
>
>
>
>
> -
> 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

errno 144

2003-01-11 Thread Mark

My own MySQL-based news server (or, rather, its fetch-news aid) just gave me
this horrible error:

--
On Sat, 11 Jan 2003 13:42:00 GMT,
(FETCH-NEWS) shutdown reason: 1016, Can't open file: 'my_table.MYD'.
(errno: 144)
--

Yep, the dreaded "Table is crashed and last repair failed" error. :) Whence
the smiley, you ask? Because though I was dumb enough to let my /var
partition run out of space, hence cause my table to become trashed beyond
recognition, I was not so stupid as to have no backup. :) I make one daily,
from cron, and for good reason.

All is well that ends well. :)

- Mark

System Administrator Asarian-host.org

---
"If you were supposed to understand it,
we wouldn't call it code." - FedEx


-
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 question (group by) - please help

2003-01-11 Thread Joseph Bueno

Damir Dezeljin wrote:
> Hi again ;)
> 
> 
>>SELECT COUNT(*)
>>  FROM test
>>  WHERE (kid=1) OR (kid=2) OR (kid=4)
>>  GROUP BY cid,aid;
> 
> This query returns:
> +--+
> | COUNT(*) |
> +--+
> |1 |
> |1 |
> |2 |
> |1 |
> |1 |
> |1 |
> +--+
> 6 rows in set (0.03 sec)
> 
> Inest of this I want to get back '6' << so numbers of rows in resulting
> query;
> 
> The same query WITHOUT 'GROUP BY' returns:
> mysql> SELECT COUNT(*) FROM test WHERE (kid=1) OR (kid=2) OR (kid=4);
> +--+
> | COUNT(*) |
> +--+
> |7 |
> +--+
> 1 row in set (0.00 sec)
> 
> So two rows are grouped because of same cid,did
> 
> Any sugestion?
> 
> Regards,
> Dezo
> 
> 

SELECT COUNT(DISTINCT cid,aid)
  FROM test
  WHERE (kid=1) OR (kid=2) OR (kid=4)

Should give you the number of groups.

Hope this helps
Joseph Bueno


-
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

Ram Usage, and processes

2003-01-11 Thread James M. Luedke

Hello:
I have a few questions about how MySQL uses Ram. I have a machine 
that I am using as a database server. The machine has close to 1G
of ram. It is running Slackware Linux 8.1 With a 2.4.18 kernel.
The main use of this server is a backend for Radius Authentication.

I have read all of the documentation I have been able to get my
hands on, and believe I have a very good understanding of how MySQL
works in general. However, this has me a little stumped.

Please take a look at the output from top, my.cnf, and the processlist
below.

---begin top output-
top - 15:21:46 up 56 days, 10:57, 11 users,  load average: 0.03, 0.16, 0.15
Tasks:  61 total,   1 running,  58 sleeping,   2 stopped,   0 zombie
Cpu(s):   5.6% user,   2.0% system,   0.0% nice,  92.5% idle
Mem:900472k total,   896048k used, 4424k free,22956k buffers
Swap:   907664k total, 3676k used,   903988k free,   744248k cached

  PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  Command   
  2361 mysql  9   0 53416  52m 2068 S  0.3  5.9   2:48.61 mysqld
  2357 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:00.18 mysqld
  2359 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:00.28 mysqld
  2360 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:11.29 mysqld
  2362 mysql  9   0 53416  52m 2068 S  0.0  5.9  17:28.20 mysqld
  2371 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:02.82 mysqld
  2386 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:00.12 mysqld
  2395 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:01.01 mysqld
  2419 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:00.21 mysqld
  2427 mysql  9   0 53416  52m 2068 S  0.0  5.9  17:00.51 mysqld
  2428 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:03.32 mysqld
  2458 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:01.15 mysqld
---end top output-

Notice that when viewing top output for user mysql that there are
12 seprate processes? I am assuming that this is done for connections
that the MySQL server may need to field. Does MySQL spawn a new 
process for every connection that comes in? And if so why do I have
12 processes when the output from show processlist returns 7 rows.
Is this how you would expect the MySQL server to behave? It appears
that MySQL is sucking up a large amount of system recourses even
when no-one is connected... There is little else running on this
system besides MySQL. I have read similar messages to this email
in the mysql list archive, and am familiar with the fact that MySQL
will use key_buffer amount of ram for the mysqld process. According
to the top output It would appear to me that MySQL is using
52M*12 of ram which is 624M. Am I correct in my understanding?
I would assume that MySQL would share the cache between processes.
Is there a reason why each process needs key_buffer ram?
Am I doing something horribly wrong?


-show processlist output -
+-+-+++-+---+-+--+
| Id  | User| Host   | db | Command | Time  | State
|   | Info |
+-+-+++-+---+-+--+
|   1 | radiusd | localhost  | radiusd_db | Sleep   | 0 |  
|   | NULL |
|  20 | root| localhost  | customers  | Sleep   | 23750 |  
|   | NULL |
|  49 | radiusd | 216.250.251.22 | radiusd_db | Sleep   | 23076 |  
|   | NULL |
|  80 | root| localhost  | customers  | Sleep   | 22168 |  
|   | NULL |
| 403 | radiusd | 64.139.37.2| radiusd_db | Sleep   | 2 |  
|   | NULL |
| 524 | replication | 64.139.37.2| NULL   | Binlog Dump | 9218  | Slave 
|connection: waiting for binlog update | NULL |
| 769 | root| localhost  | radiusd_db | Query   | 0 | NULL 
|   | show processlist |
+-+-+++-+---+-+--+
-end show processlist output -



-/etc/my.cnf options -
[client]
#password   = your_password
port= 3306
socket  = /tmp/mysql.sock

[mysqld]
port= 3306
socket  = /tmp/mysql.sock
skip-locking  
set-variable= net_buffer_length=512K
set-variable= key_buffer=64M
set-variable= max_allowed_pa

PHP4 Secure connection parameters

2003-01-11 Thread David Rock

I'm trying to use SSL connections with MySQL 4.0.8-MAX and FreeBSD 4.6 using
the online manual and have a question about section 4.3.9.2 Requirements
"Configure MySQL with --with-vio --with-openssl".  Since I installed the MAX
version isn't it already "SSL ready"?  Where do I add the --with-vio
--with-openssl parameters and does --with-openssl need a path also?  What
should it point to?  Any help appreciated.

Thanks,
David Rock


-
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: Re: UPDATE not working ...

2003-01-11 Thread Victoria Reznichenko

On Friday 10 January 2003 21:43, you wrote:

> > mysql> UPDATE t SET d=UNIX_TIMESTAMP(DATE_ADD(c, interval (b) day)) / 1;
> > ERROR 1105: Unknown error

Thanks for bug report!

This is a patch from Sinisa Milivojevic:

= sql/item.cc 1.24 vs edited =
*** /tmp/item.cc-1.24-3175  Tue Dec  3 13:08:21 2002
--- edited/sql/item.cc  Fri Jan 10 21:38:55 2003
***
*** 505,511 
{
  double nr=val();
  if (null_value)
!   return set_field_to_null(field);
  field->set_notnull();
  field->store(nr);
}
--- 505,511 
{
  double nr=val();
  if (null_value)
!   return set_field_to_null_with_conversions(field, no_conversions);
  field->set_notnull();
  field->store(nr);
}



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [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

Re: Lock Tables Timeout value?

2003-01-11 Thread Clyde

*** REPLY SEPARATOR  ***

On 11/01/2003 at 1:29 PM Mark wrote:

>Gee, I hope there is no such thing as a timeout value for "Lock Tables".
>:)
>If two of my programs decide that one of them needs to wait for the other,
>however long that may take, then I hope MySQL honors that chosen symbiosis.
>I hope it behaves like a Perl flock(): it just waits, and waits, and
>waits -- and that is how I want it. :)

H'mm. If this is so then how do you give feed back to a user when files are locked.

Scenario:

User 1 locks files for a long running job.
User 2 logs on, then try's to lock files but can't because user 1 already has the lock.

If there is no timeout value then the program for user 2 will just appear to hang. How 
do I give feed back to user 2 to say something like: "Unable to lock files after 
waiting 60 seconds, try again later" or whatever. IE I would like the program to be 
able to return control after a specific amount of time if the lock is not satisfied (I 
would think MySql would give an error message)  in order to give feedback to the user, 
rather than the the program just wait and appearing to hang.

This behavior occurs with record locks using  InnoDB files. I would have thought a 
similar approach would have applied to File locks?

Thanks
Clyde England

-
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

Thanks and SQL Syntax help

2003-01-11 Thread Steve Lefevre

First of, thanks to all who replied to my questions earlier!

Now I have another problem. I have a table of Classes and Workshops. Each
Class has a number of workshops. Each workshop has a date.

I have a query that gives me the date range of a class - the min and max
dates of its workshops.

"select ClassID, MIN(Date), MAX(Date), Classes.Name FROM Workshops LEFT JOIN
Classes ON ClassID=Classes.ID GROUP BY ClassID;"

gives me:

+-+++-+
| ClassID | MIN(Date)  | MAX(Date)  | Name|
+-+++-+
|  56 | 2002-05-15 | 2002-12-29 | XO-312  |
| 408 | 2002-05-15 | 2002-05-17 | PA-211a |
| 600 | 2002-05-15 | 2002-05-16 | XUL-001 |
+-+++-+
3 rows in set (0.00 sec)

Now I want to get *active* classes - WHERE Now() Between MIN(Date) and
Max(Date) -- but I can't figure out where to put the friggin clause. I get
errors all over the place. Can I use the between function with a group by
function?

select ClassID, MIN(Date), MAX(Date), Classes.Name
 FROM Workshops
 LEFT JOIN Classes ON ClassID=Classes.ID
 WHERE Now() BETWEEN MIN(Date) and MAX(Date)
 GROUP BY ClassID;

What am I doing wrong?



-
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-01-11 Thread root

>Description:
 1
>How-To-Repeat:

>Fix:


>Submitter-Id:  
>Originator:
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  
>Severity:  
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-4.0.9-gamma (Source distribution)

>C compiler:gcc (GCC) 3.2.1
>C++ compiler:  g++ (GCC) 3.2.1
>Environment:

System: Linux sql3 2.4.21-pre3 #2 SMP Fri Jan 10 12:07:26 EET 2003 ppc64 unknown 
unknown GNU/Linux
Architecture: ppc64

Some paths:  /usr/bin/perl /usr/bin/make /opt/ppc64/powerpc64-linux/bin/gcc 
/opt/ppc64/powerpc64-linux/bin/cc
GCC: Reading specs from /opt/ppc64/lib/gcc-lib/powerpc64-linux/3.2.1/specs
Configured with: /var/mef/glibc64/src/gcc-3.2.1/configure --build=powerpc-linux 
--host=powerpc-linux --target=powerpc64-linux --enable-languages=c,c++,f77 
--enable-__cxa_atexit --disable-nls --prefix=/opt/ppc64
Thread model: posix
gcc version 3.2.1
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''  ASFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Jan  8 02:31 /lib/libc.so.6 -> libc-2.3.1.so
-rwxr-xr-x1 root root  1275408 Jan  4 18:02 /lib/libc-2.3.1.so
-rw-r--r--1 root root  2718116 Jan  4 18:03 /usr/lib/libc.a
-rw-r--r--1 root root  178 Jan  4 18:03 /usr/lib/libc.so
Configure command: ./configure '--without-berkley-db' 
'--with-named-curses-libs=/opt/ncurses-5.3/lib/libncurses.a' '--build=powerpc64-linux' 
'--prefix=/usr/local/mysql' '--localstatedir=/var/lib/mysql' '--sysconfdir=/etc/mysql' 
'--sbindir=/usr/local/mysql/bin' '--libexecdir=/usr/local/mysql/bin' 
'--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--without-debug' 
'--without-isam' '--with-extra-charsets=complex' 'build_alias=powerpc64-linux'



-
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

install problem... (permissions?)

2003-01-11 Thread Christopher Bergeron

Hey guys, I'm having a little problem with my new mysql installation.  I 
built from source, and everything built find and installed okay (I 
think).  Here's the problem:  when I start safe_mysqld  it just ends. 
Here's the snippet from my error log:

/usr/local/libexec/mysqld: File './proto2-bin.1' not found (Errcode: 13)
030111 13:41:11  Could not use proto2-bin for logging (error 13)
030111 13:41:11  /usr/local/libexec/mysqld: Can't create/write to file 
'/usr/local/var/proto2.pid' (Errcode: 13)
030111 13:41:11  /usr/local/libexec/mysqld: Can't find file: 
'./mysql/host.frm' (errno: 13)
030111 13:41:11  /usr/local/libexec/mysqld: Error on delete of 
'/usr/local/var/proto2.pid' (Errcode: 13)
030111 13:41:11  mysqld ended

Is there an ownership or permission problem here?  

Can anyone help me out here?

Much thanks in advance,
CB


-
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: Lock Tables Timeout value?

2003-01-11 Thread Paul DuBois

At 17:12 +0800 1/11/03, Clyde wrote:

Hi,

I have searched the docs but can't seem to find information on the 
time out value for "Lock Tables" (probably just me)

When using "Lock Tables" how long does MySql wait before giving up 
if it can't get a lock?

Forever.

For table-level locks such as you acquire with LOCK TABLES, there is
no timeout.

This differs from (implicit) page- or row-level locking such as is
performed by the BDB and InnoDB handlers.  For such locking levels,
it's possible to get deadlock.  When the handler detects a deadlock,
it aborts one of the deadlocking requests.


Is there any way of changing this time out value?

Thanks
Clyde England



-
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: PHP4 Secure connection parameters

2003-01-11 Thread Paul DuBois

At 9:09 -0700 1/11/03, David Rock wrote:

I'm trying to use SSL connections with MySQL 4.0.8-MAX and FreeBSD 4.6 using
the online manual and have a question about section 4.3.9.2 Requirements
"Configure MySQL with --with-vio --with-openssl".  Since I installed the MAX
version isn't it already "SSL ready"?  Where do I add the --with-vio
--with-openssl parameters and does --with-openssl need a path also?  What
should it point to?  Any help appreciated.


--with-vio and --with-openssl are for configuring from source.  If you
installed a -max server from a binary version, those options don't apply.

To see whether your server is SSL capable, use this query:

mysql> SHOW VARIABLES LIKE 'have_openssl';
+---+---+
| Variable_name | Value |
+---+---+
| have_openssl  | YES   |
+---+---+

If it is, you'll see YES.  If not, you'll see NO or no output at all.




Thanks,
David Rock




-
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: SQL optimization problem

2003-01-11 Thread Bhavin Vyas

You might have to tweak the following a bit for syntax:

SELECT a.name, COUNT(b.id) as votes FROM poll_options as a LEFT JOIN
poll_votes as b ON  a.id=b.oid
 WHERE b.pid='' GROUP BY b.oid

Also, you can refer to:

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

Bhavin.


- Original Message -
From: "Blaster" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 11, 2003 12:35 PM
Subject: SQL optimization problem


> Hey,
>
> (this post is pretty long, a short version of the problem is listed at the
> bottom if you don't like reading long emails :P)
>
> I'm currently going through all my SQL queries for my webpage to see if
> there is anything I can do to optimize them.
> On my webpage, i have this poll where people can give their opinion in
> various subjects by casting a vote. To begin
> with, I'd like to tell you how I created my tables for this task, the poll
> uses in total 3 different tables as following:
>
> poll_list (this table contains the actual question of each poll)
> ===
> id (int) | stamp (datetime) | question (varchar 255) | active (tinyint)
>
> Id is simply an autoincrementing ID for each poll,
>
> Stamp is the creation date of the poll,
>
> Question holds the actual question (duh :P)
>
> If Active is 1, it means that this is the active poll right now.
> Only one poll can be active at the same time.
>
> poll_options (this table holds the valid answers for each poll. You may
use
> any number of answers in your poll)
>


> id (int) | pid (int) | name (varchar 255)
>
> id is again, autoinc field for this answer
>
> pid is a pointer to which poll this particular answer belongs to, i.e pid
=
> poll_list.id
>
> name holds the actual answer string
>
> poll_votes (this table holds all the casted votes, one row is one vote)
> =
> id (int) | pid (int) | oid (int) | uid (int)
>
> id, autoinc
>
> pid, pointer to poll_list.id, tells me which poll this vote belongs to
>
> oid, pointer to poll_options.id, tells me which option this user voted
>
> uid, pointer to user account. I won't include the user table, just think
of
> this as a unique identifier
> for the users, prevents the same user from voting twice in a poll..
>
>
> AND now! to the problem! Prior to my "optimzation" checking began, the
code
> to display the
> results of a poll was something like this:
>
> 1) Fetch the active poll:
> SELECT * FROM poll_list WHERE (active > 0) ORDER BY stamp DESC LIMIT 1
>
> 2) Fetch the answers for the poll ID we received from the prior query:
> SELECT * FROM poll_options WHERE pid=''
>
> 3) For each option received in step 2, I did:
> SELECT * FROM poll_votes WHERE pid='' AND oid=''
>
> 4) Output HTML formated code to web visitor.
>
> Now, I thought, it MUST be possible to make step 2 and 3 using 1 single
> query, because using this old
> system (as shown above), it requires 1 + n queries, where n is number of
> answers in that particular poll.
>
> So, I simply replaced it with:
>
> 1) Fetch the active poll:
> SELECT * FROM poll_list WHERE (active > 0) ORDER BY stamp DESC LIMIT 1
>
> 2) Fetch the answers & votes in the same query:
> SELECT a.name, COUNT(b.id) as votes FROM poll_options as a, poll_votes as
b
> WHERE b.pid='' AND b.oid=a.id GROUP BY b.oid
>
> 3) Print the results.
>
>  PROBLEM BEGINS HERE ##
>
> However! Here comes the problem, if no vote is cast on an option, it will
> not show up in the list! I want it to print 0%
> for any options that havn't received a vote, like it would with my old
> query system. This is basically what I want to
> do:
>
> Select all options from poll_options and, in the same query, count the
> number of rows in poll_votes which has that
> particular options "id" as "oid". Pretty hard to explain, but ideally, I'd
> like to do
>
> SELECT a.name, COUNT(b.id) as votes FROM poll_options as a, poll_votes as
b
> WHERE b.pid='' AND b.oid=a.id GROUP BY b.oid
>
> With one exception, if votes = 0, it should be listed in the result
aswell!
>
>
> -
> 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 
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


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

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

Re: file permissions problem on ALTER TABLE

2003-01-11 Thread miguel solórzano

At 10:17 11/01/2003 +0100, Dirkjan Ochtman wrote:
Hi,



server, I can DROP one of the tables, then I get the error again for the
other table, so then I restart the server again and I can DROP the last
table. The problem also persists on ALTERing TABLEs.




Please if possible for you send me a test case about the above issue and
the contents of the my.cnf/my.ini file.
Thanks.


--
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Miguel Angel Solórzano <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   São Paulo - Brazil
   <___/   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

Nothing about logs in startup options but logs created

2003-01-11 Thread Andrey V. Ignatov

From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Nothing about logs in startup options but logs created

>Description:
It's nothing in /etc/init.d/mysql.server and my.cnf files about logs. 
But if i start mysqld
with '/etc/init.d/mysql.server start' or standalane by 'mysqld 
--user=mysql' logs files immediately
created. Logs file created in mysql datadir:
-rw-rw1 mysqlmysql 4270959 Jan 11 22:47 
/var/lib/mysql/sql3-bin.001
-rw-rw1 mysqlmysql  260107 Jan 11 22:45 
/var/lib/mysql/sql3-slow.log
-rw-rw1 mysqlmysql21915456 Jan 11 22:47 
/var/lib/mysql/sql3.log

>How-To-Repeat:
Simply run mysqld.
>Fix:
I don't know.
>Submitter-Id:  
>Originator:
>Organization:
 
>MySQL support: none
>Synopsis:  
>Severity:  non-critical
>Priority:  medium
>Category:  mysql
>Class: sw-bug
>Release:   mysql-4.0.9-gamma (Source distribution)

>C compiler:gcc (GCC) 3.2.1
>C++ compiler:  g++ (GCC) 3.2.1
>Environment:
System: Linux sql3 2.4.21-pre3 #2 SMP Fri Jan 10 12:07:26 EET 2003 ppc64 unknown 
unknown GNU/Linux
Architecture: ppc64

Some paths:  /usr/bin/perl /usr/bin/make /opt/ppc64/powerpc64-linux/bin/gcc 
/opt/ppc64/powerpc64-linux/bin/cc
GCC: Reading specs from /opt/ppc64/lib/gcc-lib/powerpc64-linux/3.2.1/specs
Configured with: /var/mef/glibc64/src/gcc-3.2.1/configure --build=powerpc-linux 
--host=powerpc-linux --target=powerpc64-linux --enable-languages=c,c++,f77 
--enable-__cxa_atexit --disable-nls --prefix=/opt/ppc64
Thread model: posix
gcc version 3.2.1
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''  ASFLAGS=''
LIBC: (64-bit GLIBC)
-rwxr-xr-x1 root root  1668120 Jan 10 16:20 
/opt/ppc64/powerpc64-linux/lib/libc-2.3.1.so
-rw-r--r--1 root root  2375846 Jan 10 16:20 
/opt/ppc64/powerpc64-linux/lib/libc.a
-rw-r--r--1 root root  226 Jan  7 18:16 
/opt/ppc64/powerpc64-linux/lib/libc.so
lrwxrwxrwx1 root root   13 Jan  7 18:17 
/opt/ppc64/powerpc64-linux/lib/libc.so.6 -> libc-2.3.1.so
-rw-r--r--1 root root 7112 Jan 10 16:20 
/opt/ppc64/powerpc64-linux/lib/libc_nonshared.a
Configure command: ./configure '--without-berkley-db' 
'--with-named-curses-libs=/opt/ncurses-5.3/lib/libncurses.a' '--build=powerpc64-linux' 
'--prefix=/usr/local/mysql' '--localstatedir=/var/lib/mysql' '--sysconfdir=/etc/mysql' 
'--sbindir=/usr/local/mysql/bin' '--libexecdir=/usr/local/mysql/bin' 
'--with-unix-socket-path=/var/run/mysqld/mysqld.sock' /usr/local/mysql/bin' 
'--libexecdir=/usr/local/mysql/bin' 
'--with-unix-socket-path=/var/run/mysqld/mysqld.sock'
Output from mysqld --print-defaults:
mysqld would have been started with the following arguments:
--port=3306
--socket=/var/run/mysqld/mysqld.sock
--skip-locking
--set-variable=max_connect_errors=1000
--set-variable=max_connections=600
--default-character-set=win1251
--set-variable=key_buffer=128M
--set-variable=max_allowed_packet=1M
--set-variable=table_cache=512
--set-variable=sort_buffer=2M
--set-variable=record_buffer=2M
--set-variable=thread_cache=12
--set-variable=thread_concurrency=6
--set-variable=myisam_sort_buffer_size=64M
--set-variable=query_cache_size=64M
--set-variable=query_cache_limit=1M
--set-variable=query_cache_type=1
--innodb_data_home_dir=/var/lib/mysql/
--innodb_data_file_path=ibdata1:1500M;ibdata2:1500M;ibdata3:1500M;ibdata4:1500M;ibdata5:1500M:autoextend
--innodb_log_group_home_dir=/var/lib/mysql/
--innodb_log_arch_dir=/var/lib/mysql/
--set-variable=innodb_buffer_pool_size=256M
--set-variable=innodb_additional_mem_pool_size=20M
--set-variable=innodb_log_file_size=128M
--set-variable=innodb_log_buffer_size=8M
--innodb_flush_log_at_trx_commit=0
--set-variable=innodb_lock_wait_timeout=20
--set-variable=innodb_thread_concurrency=6



-
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: relations between tables

2003-01-11 Thread Adolfo Bello


> As far as I know and how I understand it, the relationships are basically all
> in your head... You just have to coordinate it in your queries and other functions

This is not true. Fot type innodb tables, you can define REFERENCES
using ON DELETE (CASCADE|RESTRICT) and/or ON UPDATE CASCADE

Adolfo


-
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: SQL optimization problem

2003-01-11 Thread Michael Brunson

LEFT JOIN


On Sat, 11 Jan 2003 18:35:44 +0100, Blaster used a few
recycled electrons to form:

| Hey,
| 
| (this post is pretty long, a short version of the problem is listed at the 
| bottom if you don't like reading long emails :P)
| 
| I'm currently going through all my SQL queries for my webpage to see if 
| there is anything I can do to optimize them.
| On my webpage, i have this poll where people can give their opinion in 
| various subjects by casting a vote. To begin
| with, I'd like to tell you how I created my tables for this task, the poll 
| uses in total 3 different tables as following:
| 
| poll_list (this table contains the actual question of each poll)
| ===
| id (int) | stamp (datetime) | question (varchar 255) | active (tinyint)
| 
| Id is simply an autoincrementing ID for each poll,
| 
| Stamp is the creation date of the poll,
| 
| Question holds the actual question (duh :P)
| 
| If Active is 1, it means that this is the active poll right now.
| Only one poll can be active at the same time.
| 
| poll_options (this table holds the valid answers for each poll. You may use 
| any number of answers in your poll)
| 
| id (int) | pid (int) | name (varchar 255)
| 
| id is again, autoinc field for this answer
| 
| pid is a pointer to which poll this particular answer belongs to, i.e pid = 
| poll_list.id
| 
| name holds the actual answer string
| 
| poll_votes (this table holds all the casted votes, one row is one vote)
| =
| id (int) | pid (int) | oid (int) | uid (int)
| 
| id, autoinc
| 
| pid, pointer to poll_list.id, tells me which poll this vote belongs to
| 
| oid, pointer to poll_options.id, tells me which option this user voted
| 
| uid, pointer to user account. I won't include the user table, just think of 
| this as a unique identifier
| for the users, prevents the same user from voting twice in a poll..
| 
| 
| AND now! to the problem! Prior to my "optimzation" checking began, the code 
| to display the
| results of a poll was something like this:
| 
| 1) Fetch the active poll:
| SELECT * FROM poll_list WHERE (active > 0) ORDER BY stamp DESC LIMIT 1
| 
| 2) Fetch the answers for the poll ID we received from the prior query:
| SELECT * FROM poll_options WHERE pid=''
| 
| 3) For each option received in step 2, I did:
| SELECT * FROM poll_votes WHERE pid='' AND oid=''
| 
| 4) Output HTML formated code to web visitor.
| 
| Now, I thought, it MUST be possible to make step 2 and 3 using 1 single 
| query, because using this old
| system (as shown above), it requires 1 + n queries, where n is number of 
| answers in that particular poll.
| 
| So, I simply replaced it with:
| 
| 1) Fetch the active poll:
| SELECT * FROM poll_list WHERE (active > 0) ORDER BY stamp DESC LIMIT 1
| 
| 2) Fetch the answers & votes in the same query:
| SELECT a.name, COUNT(b.id) as votes FROM poll_options as a, poll_votes as b 
| WHERE b.pid='' AND b.oid=a.id GROUP BY b.oid
| 
| 3) Print the results.
| 
|  PROBLEM BEGINS HERE ##
| 
| However! Here comes the problem, if no vote is cast on an option, it will 
| not show up in the list! I want it to print 0%
| for any options that havn't received a vote, like it would with my old 
| query system. This is basically what I want to
| do:
| 
| Select all options from poll_options and, in the same query, count the 
| number of rows in poll_votes which has that
| particular options "id" as "oid". Pretty hard to explain, but ideally, I'd 
| like to do
| 
| SELECT a.name, COUNT(b.id) as votes FROM poll_options as a, poll_votes as b 
| WHERE b.pid='' AND b.oid=a.id GROUP BY b.oid
| 
| With one exception, if votes = 0, it should be listed in the result aswell!
| 
| 
| -
| 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 
| Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
| 


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

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

Re: SQL optimization problem

2003-01-11 Thread Ryan Fox

Taking a blind stab, how about..

SELECT a.name, minimum(0,COUNT(b.id)) as votes FROM poll_options as a LEFT
JOIN poll_votes as b on a.id=b.oid
WHERE b.pid='' GROUP BY b.oid

Ryan Fox

- Original Message -
From: "Blaster" <[EMAIL PROTECTED]>

> However! Here comes the problem, if no vote is cast on an option, it will
> not show up in the list! I want it to print 0%
> for any options that havn't received a vote, like it would with my old
> query system. This is basically what I want to
> do:
>
> SELECT a.name, COUNT(b.id) as votes FROM poll_options as a, poll_votes as
b
> WHERE b.pid='' AND b.oid=a.id GROUP BY b.oid
>
> With one exception, if votes = 0, it should be listed in the result
aswell!

sql, 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: install problem... (permissions?)

2003-01-11 Thread Stefan Hinz, iConnect \(Berlin\)

Christopher,

> 030111 13:41:11  /usr/local/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)

Did you run the install_db script? If not, MySQL can't find the grant
tables.

See http://www.mysql.com/doc/en/Post-installation.html for details.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "Christopher Bergeron" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 11, 2003 7:29 PM
Subject: install problem... (permissions?)


> Hey guys, I'm having a little problem with my new mysql installation.
I
> built from source, and everything built find and installed okay (I
> think).  Here's the problem:  when I start safe_mysqld  it just ends.
>  Here's the snippet from my error log:
>
> /usr/local/libexec/mysqld: File './proto2-bin.1' not found (Errcode:
13)
> 030111 13:41:11  Could not use proto2-bin for logging (error 13)
> 030111 13:41:11  /usr/local/libexec/mysqld: Can't create/write to file
> '/usr/local/var/proto2.pid' (Errcode: 13)
> 030111 13:41:11  /usr/local/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 030111 13:41:11  /usr/local/libexec/mysqld: Error on delete of
> '/usr/local/var/proto2.pid' (Errcode: 13)
> 030111 13:41:11  mysqld ended
>
> Is there an ownership or permission problem here?
>
> Can anyone help me out here?
>
> Much thanks in advance,
> CB
>
>
> -
> 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 does the MySQL shutdown process works.

2003-01-11 Thread My Deja


I'd like to know how MySQL shuts down.

Where can I find more about the process, first with
mysqladmin shutdown, and when it shuts down as a
result of Windows shutting down, eirhter as a service
or from the command line or a batch file?

With InnoDb I always receive a message about
recovering when InnoDB starts. This is from a  batch
file in the Start Menu and it seems that MySQL does
not shutdown properly when Windows is shutdown. Is
there a mechanism for getting  MySQL to shutdown
properly when Windows is shutdown, besides using
mysqladmin shutdown?

I am now running MySQL as a service on Win2000, are
there errors on shutdown I do not see, or does the
service method shutdown smoothly?


__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.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: I need the full list of client options in my.cnf

2003-01-11 Thread My Deja

Where can I find the full list of  options which go
 under the [client] section?


ignore this part it is the spam filter bypass
(sql,query,queries,smallint)
 
--- [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:
> 
> 
> Where can I find the full list of  options which go
> under the [client] section?
> 
> __
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
>  

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.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: Ram Usage, and processes

2003-01-11 Thread Joseph Bueno

James M. Luedke wrote:
> Hello:
> I have a few questions about how MySQL uses Ram. I have a machine 
> that I am using as a database server. The machine has close to 1G
> of ram. It is running Slackware Linux 8.1 With a 2.4.18 kernel.
> The main use of this server is a backend for Radius Authentication.
> 
> I have read all of the documentation I have been able to get my
> hands on, and believe I have a very good understanding of how MySQL
> works in general. However, this has me a little stumped.
> 
> Please take a look at the output from top, my.cnf, and the processlist
> below.
> 
> ---begin top output-
> top - 15:21:46 up 56 days, 10:57, 11 users,  load average: 0.03, 0.16, 0.15
> Tasks:  61 total,   1 running,  58 sleeping,   2 stopped,   0 zombie
> Cpu(s):   5.6% user,   2.0% system,   0.0% nice,  92.5% idle
> Mem:900472k total,   896048k used, 4424k free,22956k buffers
> Swap:   907664k total, 3676k used,   903988k free,   744248k cached
> 
>   PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  Command   
>   2361 mysql  9   0 53416  52m 2068 S  0.3  5.9   2:48.61 mysqld
>   2357 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:00.18 mysqld
>   2359 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:00.28 mysqld
>   2360 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:11.29 mysqld
>   2362 mysql  9   0 53416  52m 2068 S  0.0  5.9  17:28.20 mysqld
>   2371 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:02.82 mysqld
>   2386 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:00.12 mysqld
>   2395 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:01.01 mysqld
>   2419 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:00.21 mysqld
>   2427 mysql  9   0 53416  52m 2068 S  0.0  5.9  17:00.51 mysqld
>   2428 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:03.32 mysqld
>   2458 mysql  9   0 53416  52m 2068 S  0.0  5.9   0:01.15 mysqld
> ---end top output-
> 
> Notice that when viewing top output for user mysql that there are
> 12 seprate processes? I am assuming that this is done for connections
> that the MySQL server may need to field. Does MySQL spawn a new 
> process for every connection that comes in? And if so why do I have
> 12 processes when the output from show processlist returns 7 rows.
> Is this how you would expect the MySQL server to behave? It appears
> that MySQL is sucking up a large amount of system recourses even
> when no-one is connected... There is little else running on this
> system besides MySQL. I have read similar messages to this email
> in the mysql list archive, and am familiar with the fact that MySQL
> will use key_buffer amount of ram for the mysqld process. According
> to the top output It would appear to me that MySQL is using
> 52M*12 of ram which is 624M. Am I correct in my understanding?
> I would assume that MySQL would share the cache between processes.
> Is there a reason why each process needs key_buffer ram?
> Am I doing something horribly wrong?
> 

mysqld uses threads, not processes; so all memory is shared.
mysqld is using 52Mb only (not 624Mb). This has already been discussed
several times on this list; you can also check MySQL documentation:
http://www.mysql.com/doc/en/MySQL_threads.html
http://www.mysql.com/doc/en/Memory_use.html

Chances are that all remaining memory is used by Linux kernel cache.

> 
> -show processlist output -
> 
>+-+-+++-+---+-+--+
> | Id  | User| Host   | db | Command | Time  | State  
> | Info |
> 
>+-+-+++-+---+-+--+
> |   1 | radiusd | localhost  | radiusd_db | Sleep   | 0 |
> | NULL |
> |  20 | root| localhost  | customers  | Sleep   | 23750 |
> | NULL |
> |  49 | radiusd | 216.250.251.22 | radiusd_db | Sleep   | 23076 |
> | NULL |
> |  80 | root| localhost  | customers  | Sleep   | 22168 |
> | NULL |
> | 403 | radiusd | 64.139.37.2| radiusd_db | Sleep   | 2 |
> | NULL |
> | 524 | replication | 64.139.37.2| NULL   | Binlog Dump | 9218  | Slave 
>connection: waiting for binlog update | NULL |
> | 769 | root| localhost  | radiusd_db | Query   | 0 | NULL   
>

Re: Beginners Running problems

2003-01-11 Thread Doug Thompson

To paraphrase Yogi Berra: You can see an awful lot just by looking.

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

Doug

-- For Happy Filters, use SQL, query

On Sat, 11 Jan 2003 12:50:29 -, alan.keith.simons wrote:

>Hi
>
>I have installed a downloaded version of mysql on my pc but am experiencing
>problems when I try to run the MySQL monitor.
>
>>From the command line:-
>
>   C:\mysql\bin
>
>when I type in mysql to activate the monitor, I get the error message:
>
>   ERROR 2003: Can't connect to MySql server on 'localhost' (10061)
>
>I cannot seem to find a solution to this problem on your site.
>
>Best regrads
>
>Alan Simons
>
>
>
>
>-
>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

Problems installing additional instances of mysql 4.0.x as a service

2003-01-11 Thread My Deja


I have been trying to install additional instances of
mysqld 4.0.x as a service on Windows 2000, but it
seems that only one set of parameters.

eg.

'mysqld --install connectionname --port=3307
--datadir=c:\mysql\datadir2' does not work  but 

mysqld --install connectionname --port=3307

and 

mysqld --install connectionname
--datadir=c:\mysql\datadir2

Is this a bug?

I am going to pass a customised options file
--defaults-file=c:/mydefaults to see if that will
work.

However I would prefer most of it to be on the command line.

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.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

PostgreSQL-OOo

2003-01-11 Thread Ruben I Safir

>From the Open Office . org list

On 2003.01.10 12:09 Josh Berkus wrote:
Ruben,

> Oh yes ... but it was in the short list of reasons to oppose using
> Mysql
> and it's what we call in Hebrew, Loshen Harah.. evil speach.  Monty
> and Dave
> do not deserve this reputation.  Say what you will about the
> technical merits of MYSQL
> but the team is wonderfully friendly and cooperative, especially to
> end users.

You seem to have a good relationship with Monty and/or Dave.   Could
you suggest to them that we could bury a lot of the animosity between
the MySQL and PostgreSQL camps if MySQL would take the 3-page "MySQL is
good, PostgreSQL is bad" section *out* of the MySQL documentation?  

No other Open Source project I know of has anything this critical of
another OSS project in print, and its presence is an ongoing testament
to a no-holds-barred competitive attitude on the part of MySQL AB.
 It's quite possible that that section no longer reflects the real
attitudes of the MySQL team, but it remains on the web site.  It's
particularly glaring since there is no comparison made with any
proprietary software products, just Postgres and mSQL.

Personally, I would love to see an "Open Source Database Alliance" to
allow MySQL, PostgreSQL, SAPDB and Phoenix to challenge the current
supremacy of Oracle and DB2.   I've already talked to some people on
the SAP-DB team about this.As with office productivity
applications, it's the only real way to challenge the $millions in
advertising the "big boys" have.

-Josh Berkus

-- 
__
Brooklyn Linux Solutions
__
DRM is THEFT - We are the STAKEHOLDERS http://fairuse.nylxs.com

http://www.mrbrklyn.com - Consulting
http://www.inns.net <-- Happy Clients
http://www.nylxs.com - Leadership Development in Free Software
http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from 
around the net
http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn

1-718-382-0585

-
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: PHP4 Secure connection parameters

2003-01-11 Thread Paul DuBois

At 16:52 -0700 1/11/03, David Rock wrote:

Show variables says have_openssl = NO for the binary version.  I compiled
and installed the source version using "--with-vio --with-openssl=/usr/bin"


Try --with-openssl without any argument and see if configure finds your
OpenSSL installation location by itself.  If not, use the pathname
to the directory where the libraries, header files, etc. are located.
The directory you supplied is the one where the openssl program is
located, which isn't what configure wants.

To see what kinds of things configure is looking for, pull it into
an editor and sure for "openssl".  You'll see which directories
it looks at trying to determine your OpenSSL installation location.


and it still says have_openssl = NO.  I'm not sure what path -with-openssl
is expecting but other than that I'm not sure where to look next.  FreeBSD
4.6 says OpenSSL is installed as part of the base system and indeed it does
seem to be installed, or at least something called the "OpenSSL Toolkit" is
installed and I have the /usr/bin/openssl command available.  I'm not
getting any errors in the mysqld log when I start the server, just no SSL
support.  I'm hoping someone can throw some thoughts out here.

Thanks,
David


-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 12:07 PM
To: David Rock; [EMAIL PROTECTED]
Subject: Re: PHP4 Secure connection parameters

At 9:09 -0700 1/11/03, David Rock wrote:

I'm trying to use SSL connections with MySQL 4.0.8-MAX and FreeBSD 4.6

using

the online manual and have a question about section 4.3.9.2 Requirements
"Configure MySQL with --with-vio --with-openssl".  Since I installed the

MAX

version isn't it already "SSL ready"?  Where do I add the --with-vio
--with-openssl parameters and does --with-openssl need a path also?  What
should it point to?  Any help appreciated.


--with-vio and --with-openssl are for configuring from source.  If you
installed a -max server from a binary version, those options don't apply.

To see whether your server is SSL capable, use this query:

mysql> SHOW VARIABLES LIKE 'have_openssl';
+---+---+
| Variable_name | Value |
+---+---+
| have_openssl  | YES   |
+---+---+

If it is, you'll see YES.  If not, you'll see NO or no output at all.




Thanks,
David Rock



-
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: PHP4 Secure connection parameters

2003-01-11 Thread David Rock

Show variables says have_openssl = NO for the binary version.  I compiled
and installed the source version using "--with-vio --with-openssl=/usr/bin"
and it still says have_openssl = NO.  I'm not sure what path -with-openssl
is expecting but other than that I'm not sure where to look next.  FreeBSD
4.6 says OpenSSL is installed as part of the base system and indeed it does
seem to be installed, or at least something called the "OpenSSL Toolkit" is
installed and I have the /usr/bin/openssl command available.  I'm not
getting any errors in the mysqld log when I start the server, just no SSL
support.  I'm hoping someone can throw some thoughts out here.

Thanks,
David

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 12:07 PM
To: David Rock; [EMAIL PROTECTED]
Subject: Re: PHP4 Secure connection parameters

At 9:09 -0700 1/11/03, David Rock wrote:
>I'm trying to use SSL connections with MySQL 4.0.8-MAX and FreeBSD 4.6
using
>the online manual and have a question about section 4.3.9.2 Requirements
>"Configure MySQL with --with-vio --with-openssl".  Since I installed the
MAX
>version isn't it already "SSL ready"?  Where do I add the --with-vio
>--with-openssl parameters and does --with-openssl need a path also?  What
>should it point to?  Any help appreciated.

--with-vio and --with-openssl are for configuring from source.  If you
installed a -max server from a binary version, those options don't apply.

To see whether your server is SSL capable, use this query:

mysql> SHOW VARIABLES LIKE 'have_openssl';
+---+---+
| Variable_name | Value |
+---+---+
| have_openssl  | YES   |
+---+---+

If it is, you'll see YES.  If not, you'll see NO or no output at all.

>
>Thanks,
>David Rock
>

-
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

Has anyone managed to get 4.0.8 Win32 working properly?

2003-01-11 Thread My Deja

Has anyone managed to get MySQL 4.0.8 Windows 2000
successfully?

I am trying to run it as an additional service. It
keeps crashing when I try to access data.

sql, query

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.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

Replication bug?

2003-01-11 Thread Ross Davis - DataAnywhere.net

I think I have found a replication bug.  We are using Mysql-Max 3.23.53
in a master and multiple slave situation.  That is working fine.  We are
using InnoDB

We have found a workaround to the problem but I thought you should know
about it.

We have 2 databases on the system call them dba and dbb.

If I have a connection to dba and and then run the following query the
update happens on the master but not on the slaves!!!

replace into dbb.tablename set field='somevalue' ...

The key to the problem is not the replace into, but the fact that we are
connected to one database and working on another.


-
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

Problem with query cache and comments

2003-01-11 Thread Christian Rabe

Hi,

I've been testing the query cache with mysql 4.0.8 and ran into a problem.

the query
select * from tablename where x=1;
is cached correctly and generates nice hits when run more than once

but if I add a comment like
/* any comment */ select * from tablename where x=1;
the query is cached, but there are no more hits

I dont think this is intended ...

Please reply or CC me directly, because I'm not on the list atm.

Thanx and Regards,
  Christian Rabe


-
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: Question -Subselect

2003-01-11 Thread Terence Ng

Please help!  I already know that my query is wrong. 
I have identified it.  But what is the solution to my
query?

 --- gerald_clark <[EMAIL PROTECTED]>
wrote: > I answered this yesterday.
> Your FROM must precede your WHERE.
> 
> Terence Ng wrote:
> 
> >How do I correct this SQL code:
> > 
> >2 tables there, 
> >lcopen: id, bank, unit_price_us, order_cbm
> >lcreceive: id, amount_us, due_date
> >
> >#this condition :lcreceive.due_date < current_date
> >#only affect to : SUM(lcreceive.amount_us)
> >#and NOT :
> >#SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8
> AS
> >open
> >
> >
> >SELECT
> >lcopen.bank, 
> >SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS
> >open,
> >#
> >SUM(lcreceive.amount_us) where lcreceive.due_date <
> >current_date,
> >#
> ># the above statement is not correct 
> ># 
> >FROM lcopen, lcreceive 
> >AND lcopen.id=lcreceive.id 
> >GROUP BY lcopen.bank;
> >
> >
> >
> > 
> > 
> > 
> >Terence Ng
> >
> >
>
>___
> >Do You Yahoo!?
> >Get your free @yahoo.com.hk address at
> http://mail.english.yahoo.com.hk
> >
>
>-
> >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
>  

___
Do You Yahoo!?
Get your free @yahoo.com.hk address at http://mail.english.yahoo.com.hk

-
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

need help on ODBC

2003-01-11 Thread dolly

Hi,

I installed MySQL 4.0 on Red Hat 8.0 server and able to connect from
mysqlgui application. I couldn't connect from ODBC ver 2.50 nor 3.51. Any
sugestion would be appriciated.


-
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 help on ODBC

2003-01-11 Thread Frederick R. Doncillo

Hello Dolly,

Kindly state and share with us the error encountered if there were any. 
Your source code would also be of help  :-)


Fred.

dolly wrote:

Hi,

I installed MySQL 4.0 on Red Hat 8.0 server and able to connect from
mysqlgui application. I couldn't connect from ODBC ver 2.50 nor 3.51. Any
sugestion would be appriciated.


-
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: Replication bug?

2003-01-11 Thread Frederick R. Doncillo

Are the slaves doing the replication process? If not, you may try it 
that way.  Slaves should do the updating and must request from the 
server and not the server to the slave. :-)

Fred.

Ross Davis - DataAnywhere.net wrote:

I think I have found a replication bug.  We are using Mysql-Max 3.23.53
in a master and multiple slave situation.  That is working fine.  We are
using InnoDB

We have found a workaround to the problem but I thought you should know
about it.

We have 2 databases on the system call them dba and dbb.

If I have a connection to dba and and then run the following query the
update happens on the master but not on the slaves!!!

replace into dbb.tablename set field='somevalue' ...

The key to the problem is not the replace into, but the fact that we are
connected to one database and working on another.


-
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: Has anyone managed to get 4.0.8 Win32 working properly?

2003-01-11 Thread Frederick R. Doncillo

I tried and is working perfectly. I am using MS2000server. Please share 
with us the error logs if there are any. thanks.

Fred.

My Deja wrote:

Has anyone managed to get MySQL 4.0.8 Windows 2000
successfully?

I am trying to run it as an additional service. It
keeps crashing when I try to access data.

sql, query

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.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


 




-
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: Has anyone managed to get 4.0.8 Win32 working properly?

2003-01-11 Thread JamesD

MY EXPERIENCE WITH MYSQL GAMMA 4.08 on win2000 professional SP 3
was not too bad:

PREPARE
A shutdown mysqlmax-nt (3.23.53) running as NT service,
B downloaded mysql-4.0.8-gamma-win.zip to desktop
C extracted zip to e:\mysql408
D installed to e:\mysql408\install
E opened the html manual
F skimmed 2.122 of the manual, and ignored recommendation
to remove old service. THIS WAS STUPID OF ME.
G. did not use named pipes. I always try to use TCP/IP
H  edited my-large.cnf, since i have about 170 million
records in my dev machine (I develop in windows, and deploy on linux)

ok ok, its just a hobby - but it keeps me out of trouble.

I. edits in my-large.cnf (i changed name to my.cnf and left it in the base
directory)  (THIS WAS STUPID) (Later on I changed name to my.ini and put it
into WINNT root.
set basedir=e:\\mysql408\\install  ##i used the double backslashes ok..
set datadir = e:\\mysql408\\install\data#used double backslashes
uncommented the Innobase tables lines and set
the path to e:\\mysql408\\install\\ibase\\data  #for the data
uncommented the Innobase tables lines and set the
path to e:\\mysql408\\install\\ibase\\logs  #for the logs
set the innobase arch dir to e:\\mysql408\\install\\ibase\\logs
made no changes to the rest of the innobase cnf lines. left as is.

J.  opened a dos shell , cd to the basedir\bin and ran
mysqld-max --standalone, then

GOT ERROR ON START
A. error message file e:\mysql\share\english\errmsg.sys had only 218
messages, should have 237.

FIX
It was looking at the old "my.ini" file in E:\WINNT, so i changed the base
directories there (Half of a fix really...)

Now i tried to install as service, since it ran standalone

K  TRIED TO RUN AS SERVICE

GOT SYSTEM ERROR 1067 - This is totally unintelligible ..its really
MicroSpeak for "GOTCHA"  :-)

FIX BELOW

1. used only my.ini in the windows NT directory. did not use my.cnf in the
nonstandard directory (this way I can install to my E drive)
2. used my-large.cnf as the base to create the my.ini file in E:\WINNT - the
others probably work fine too...
3. ran mysql-max --standalone --console #and got error messages
indicated i had bad syntax errors in my my.ini file in e:\winnt
4. fixed the bad entries in my.ini located in E:\WINNT
5. did mysqld-nt-max --remove  (removed old service)
6. did mysqld-nt-max  --install (install new service)
7.  did net start mysql -- with INNODB -- got lots of nice messages...ran
smooth
8. created JimTest database
9. imported 30 million records from testfile -  import took 2:33 -- went
smooth
10. ran select = select * from mytable where name REGEXP '^joe.*$'  LIMIT
5000  #select ran fine although it took 2:15
11 created index on name - went out for a walk(hey its 30 million
records!) 51:23
12 reran the select in #9 - now takes 2:14 -  a 1 second improvement --- but
lots of optimizations remain

CONCLUSION
it works fine, but if not using C drive be sure to use my.ini in the WINNT
root, and not my.cnf in the non-standard directory (OR just install to C,
like most people do...)

MY.ini file below===>>

# Example mysql config file.
# Copy this file to c:\my.cnf to set global options  (I copied this to
WINNT\my.ini)
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options

# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
set-variable= key_buffer=256M
set-variable= max_allowed_packet=1M
set-variable= table_cache=256
set-variable= sort_buffer=1M
set-variable= record_buffer=1M
set-variable= myisam_sort_buffer_size=64M
set-variable= thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable= thread_concurrency=8
log-bin
server-id   = 1

# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = e:\\mysql408\\install
datadir = e:\\mysql408\\install\data

# Uncomment the following if you are using BDB tables
#set-variable   = bdb_cache_size=64M
#set-variable   = bdb_max_lock=10

# Uncomment the following if you are using Innobase tables
innodb_data_file_path = ibdata1:1000M
innodb_data_home_dir = e:\\mysql408\\install\\ibase\\data
innodb_log_group_home_dir = e:\\mysql408\\install\\ibase\\logs
innodb_log_arch_dir = e:\\mysql408\\install\\ibase\\logs
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_file_io_thread

66 matches

Mail list logo