subject:"Re\: mysql problem"

Re: mysql problem

2009-04-21 Thread Thomas Pundt


Konrad,

AZZOPARDI Konrad schrieb:

Hello people,
 
I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45  {RedHat default package}. I have migrated DB data from one to the other and all data seems to be there including the structureMy problem is that I run a query like this :
 
SELECT x.application_name, y.role_name  FROM application x, role y  JOIN logical_app_role_link l  ON x.application_id = l.application_id AND y.role_id = l.role_id  WHERE l.logical_id = 15;


It works for the old mysql version but for the new mysql version I receive the 
following error :
 
ERROR 1054 (42S22): Unknown column 'x.application_id' in 'on clause'


and I am sure that application_id exists in table application.


read the upgrading instructions and pay special attention
to http://dev.mysql.com/doc/refman/5.0/en/join.html,
"Join Processing Changes in MySQL 5.0.12".


Best to avoid this issue is to not mix implicit and
explicit joins, as Gerald pointed out.

Ciao,
Thomas

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysql problem

2009-04-21 Thread Gerald L. Clark


AZZOPARDI Konrad wrote:

Hello people,
 
I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45  {RedHat default package}. I have migrated DB data from one to the other and all data seems to be there including the structureMy problem is that I run a query like this :
 
SELECT x.application_name, y.role_name  FROM application x, role y  JOIN logical_app_role_link l  ON x.application_id = l.application_id AND y.role_id = l.role_id  WHERE l.logical_id = 15;


It works for the old mysql version but for the new mysql version I receive the 
following error :
 
ERROR 1054 (42S22): Unknown column 'x.application_id' in 'on clause'


and I am sure that application_id exists in table application.
 
Thanks

konrad

 


Don't mix implicit and explicit joins.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysql++ problem(undefined symbol to)

2006-08-13 Thread Chris


ali asghar torabi parizy wrote:

  hello.
  i want to connect to mysql from c++ .
  i examine any version or platform.
  i use mysql5 and 4 in suse10 with gcc.then examine mingw and mysql5 and  4 
and 3 for severeal times but i can't solve this problem.when i want  to compile 
examples of mysql++ following error appeared:


It would be better to ask on the mysql++ list.

http://lists.mysql.com/plusplus

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MYSQL problem

2004-01-13 Thread Aron Bereket

Dear Mike,

Thanx for the quick reply. I did what you specified on
your rely. 

There is --with-mysql argument but is not set it is
just '--with-mysql'

does it mean I have to recompile it again?

cheers,

Bereket


--- Mike Johnson <[EMAIL PROTECTED]> wrote:
> From: Aron Bereket [mailto:[EMAIL PROTECTED]
> 
> > Hi there,
> > 
> > I have recently installed mysql and php on my
> mechine
> > and both work fine. But when i wrote an HTML/Php
> to
> > access my databse I got the following error
> message:
> > 
> > Fatal error: Call to undefined function:
> > mysql_pconnect() in /var/www/html/employee.php on
> line
> > 48
> > 
> > I tried also with mysql_real_connect() and
> > mysql_connect() functions bud didn't solve the
> > problem.
> > 
> > Does it mean that the mysql_pconnect() doesn't
> exitst
> > or is some configuration problem?
> > 
> > Your help is appriciated.
> 
> 
> Are you sure the MySQL API was compiled with your
> install of PHP?
> 
> Create a test script and just put the following in
> it:
> 
> 
> 
> Then view that in your web browser. Near the top
> should be a header "Configure Command" -- does it
> include an appropriate "--with-mysql=xxx" argument?
> 
> If that checks out, scroll further down to view
> information about PHP's planned interactions with
> MySQL.
> 
> HTH!
> 
> 
> -- 
> Mike Johnson
> Web Developer
> Smarter Living, Inc.
> phone (617) 886-5539

__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MYSQL problem

2004-01-13 Thread Aron Bereket

Thanx for the quick reply peter.

That of one of the things I did when I had the
problem. It was not enabled. But when I enable it it
gave me mysql.so doesn't exits. I checked it on the
path there is not mysql.so.

cheers,
Bereket 
--- Peter Lovatt <[EMAIL PROTECTED]> wrote:
> check your php.ini to make sure the mysql extensions
> are enabled.
> 
> Peter
> 
> 
> -Original Message-
> From: Aron Bereket [mailto:[EMAIL PROTECTED]
> Sent: 13 January 2004 23:36
> To: [EMAIL PROTECTED]
> Subject: MYSQL problem
> 
> 
> 
> Hi there,
> 
> I have recently installed mysql and php on my
> mechine
> and both work fine. But when i wrote an HTML/Php to
> access my databse I got the following error message:
> 
> Fatal error: Call to undefined function:
> mysql_pconnect() in /var/www/html/employee.php on
> line
> 48
> 
> I tried also with mysql_real_connect() and
> mysql_connect() functions bud didn't solve the
> problem.
> 
> Does it mean that the mysql_pconnect() doesn't
> exitst
> or is some configuration problem?
> 
> Your help is appriciated.
> 
> cheers,
> Bereket L
> 
> __
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus"
> Sweepstakes
> http://hotjobs.sweepstakes.yahoo.com/signingbonus
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
> http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 
> 
--- Peter Lovatt <[EMAIL PROTECTED]> wrote:
> check your php.ini to make sure the mysql extensions
> are enabled.
> 
> Peter
> 
> 
> -Original Message-
> From: Aron Bereket [mailto:[EMAIL PROTECTED]
> Sent: 13 January 2004 23:36
> To: [EMAIL PROTECTED]
> Subject: MYSQL problem


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MYSQL problem

2004-01-13 Thread Mike Johnson

From: Aron Bereket [mailto:[EMAIL PROTECTED]

> Hi there,
> 
> I have recently installed mysql and php on my mechine
> and both work fine. But when i wrote an HTML/Php to
> access my databse I got the following error message:
> 
> Fatal error: Call to undefined function:
> mysql_pconnect() in /var/www/html/employee.php on line
> 48
> 
> I tried also with mysql_real_connect() and
> mysql_connect() functions bud didn't solve the
> problem.
> 
> Does it mean that the mysql_pconnect() doesn't exitst
> or is some configuration problem?
> 
> Your help is appriciated.


Are you sure the MySQL API was compiled with your install of PHP?

Create a test script and just put the following in it:



Then view that in your web browser. Near the top should be a header "Configure 
Command" -- does it include an appropriate "--with-mysql=xxx" argument?

If that checks out, scroll further down to view information about PHP's planned 
interactions with MySQL.

HTH!


-- 
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql Problem...

2004-01-10 Thread robert_rowe


Did you stop and restart the server while you had the client up? This will break the 
client's connection and force it to try and re-establish it.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql Problem in Windows 2000 advanced server

2003-09-25 Thread Ganbold

Thanks Miguel.

I increased net_read_timeout and net_write_timout up to 300 sec, but 
problem still exists.
My queries are executing only in few seconds, but sometimes mysql shows 
"Can't connect to server, or Connection lost etc."
I used mysql-4.0.14 server and client, but problem was same and I upgraded 
to mysql-4.0.15.

Probably running mysql in Windows is not great as in Lunux/FreeBSD. It 
seems like it is better to switch into
Linux/FreeBSD.

Ganbold

At 07:44 PM 9/25/2003 -0300, you wrote:
At 12:33 25/9/2003 +0900, Ganbold wrote:
Hi,
I installed mysql-4.0.15 in Windows 2000 Advanced server. Mysql-max-nt is 
working fine, except some problems.
Sometimes when I try to use access web pages through php pages, mysql 
says "Connection to server lost" or
"Can't connect to mysql server" or sometimes query error. Query is tested 
and works fine most of the time.
And when I refresh web page again everything works fine.
Mysql log says nothing.

Is it problem related to mysql in Windows? Also I tested small C program 
to query mysql tables and it sometimes
hangs. Is there any solution for this kind of problem?
From the mysql.exe client:

(C) Copyright 1985-2000 Microsoft Corp.

c:\>c:\mysql\bin\mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.15-max-nt-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "%timeout%";
+--+---+
| Variable_name| Value |
+--+---+
| connect_timeout  | 5 |
| delayed_insert_timeout   | 300   |
| innodb_lock_wait_timeout | 50|
| interactive_timeout  | 28800 |
| net_read_timeout | 30|
| net_write_timeout| 60|
| slave_net_timeout| 3600  |
| wait_timeout | 28800 |
+--+---+
8 rows in set (0.01 sec)
You can see above the net_read_timeout and net_write_timeout,
if you are having queries that takes more than 30 seconds the
server disconnect the client because the client remains passive
and that time exceeds the net_read_timeout.
From 4.0.15 was introduced for socket time outs that before
on Windows didn't worked.
So try to configure your server starting it with a more high
value than the default according with the necessities.
However, when retrieved with a client 4.0.15 the above don't
works, please read:
http://bugs.mysql.com/bug.php?id=1370

for further details and follow up.

--
Regards,
For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/
Miguel Angel Solórzano <[EMAIL PROTECTED]>
São Paulo - Brazil


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql Problem in Windows 2000 advanced server

2003-09-25 Thread miguel solórzano

At 12:33 25/9/2003 +0900, Ganbold wrote:
Hi,
I installed mysql-4.0.15 in Windows 2000 Advanced server. Mysql-max-nt is 
working fine, except some problems.
Sometimes when I try to use access web pages through php pages, mysql says 
"Connection to server lost" or
"Can't connect to mysql server" or sometimes query error. Query is tested 
and works fine most of the time.
And when I refresh web page again everything works fine.
Mysql log says nothing.

Is it problem related to mysql in Windows? Also I tested small C program 
to query mysql tables and it sometimes
hangs. Is there any solution for this kind of problem?
From the mysql.exe client:

(C) Copyright 1985-2000 Microsoft Corp.

c:\>c:\mysql\bin\mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.15-max-nt-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "%timeout%";
+--+---+
| Variable_name| Value |
+--+---+
| connect_timeout  | 5 |
| delayed_insert_timeout   | 300   |
| innodb_lock_wait_timeout | 50|
| interactive_timeout  | 28800 |
| net_read_timeout | 30|
| net_write_timeout| 60|
| slave_net_timeout| 3600  |
| wait_timeout | 28800 |
+--+---+
8 rows in set (0.01 sec)
You can see above the net_read_timeout and net_write_timeout,
if you are having queries that takes more than 30 seconds the
server disconnect the client because the client remains passive
and that time exceeds the net_read_timeout.
From 4.0.15 was introduced for socket time outs that before
on Windows didn't worked.
So try to configure your server starting it with a more high
value than the default according with the necessities.
However, when retrieved with a client 4.0.15 the above don't
works, please read:
http://bugs.mysql.com/bug.php?id=1370

for further details and follow up.

--
Regards,
For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/
Miguel Angel Solórzano <[EMAIL PROTECTED]>
São Paulo - Brazil
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MYSQL problem

2003-02-13 Thread Stefan Hinz

Ellen,

> Error is : can't connect to mysql on localhost <10061)..
> I also try another method to solve this problem by typing
> mysqld-nt --install
> error prompts saying that the service already exists.
> The current server installed is : c:\Apache\mysql\bin\mysqld-nt.exe

Start c:\Apache\mysql\bin\winmysqladmin.exe and try again!

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


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

2003-02-13 Thread Paul DuBois

At 23:47 +0800 2/13/03, [EMAIL PROTECTED] wrote:

Hello Sir,

I have problem connecting to mysql in dos-prompt..

Error is : can't connect to mysql on localhost <10061)..
What does it mean?

I also try another method to solve this problem by typing
mysqld-nt --install

error prompts saying that the service already exists.
The current server installed is : c:\Apache\mysql\bin\mysqld-nt.exe


The --install option installs the server as a service but does not
actually _start_ the service.  Try either "net start mysql" from the
DOS prompt, or use the Services Manager to start the service.



i am puzzled because i m using IIS and already uninstalled Apache program...

can u please tell me how to solve this problem?
thanks

waiting for your reply.

Regards
Ellen



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

2002-11-20 Thread Ignatius Reilly

Syntax errors. Try:

SELECT studenti.*
FROM studenti LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid
WHERE ISNULL( valutazioni.sid )


Ignatius

- Original Message -
From: "Francesco" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 20, 2002 4:55 PM
Subject: mysql problem


> Hello,
> I tried to execute the following query:
> SELECT studenti.*
> FROM studenti,valutazioni LEFT JOIN valutazioni ON
studenti.sid=valutazioni.sid
> WHERE valutazioni.sid IS NULL;
> and give me the following error message:
> ERROR 1066: Not unique table/alias: 'valutazioni'
> I have the  Mysql 4.0.1 alpha version.
> I want to know what is the problem.
>
>
> -
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
> posting. To request this thread, e-mail [EMAIL PROTECTED]
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail [EMAIL PROTECTED] instead.
>
>


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

2002-11-20 Thread Iikka Meriläinen

On Wed, 20 Nov 2002, Francesco wrote:

> Hello,
> I tried to execute the following query:
> SELECT studenti.*
> FROM studenti,valutazioni LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid
> WHERE valutazioni.sid IS NULL;

Hi!

I think you don't have to specify valutazioni in the FROM subclause (is it
the correct term?). SELECT studenti.* FROM studenti LEFT JOIN valutazioni
...

Iikka

> and give me the following error message:
> ERROR 1066: Not unique table/alias: 'valutazioni'
> I have the  Mysql 4.0.1 alpha version.
> I want to know what is the problem.
>
>

**
* Iikka Meriläinen   *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**

-
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 problem...maybe...?

2002-08-12 Thread Victoria Reznichenko


dane,
Friday, August 09, 2002, 10:53:30 PM, you wrote:

dr> My phpBB forums, say if i make a post, then it goes to the post, but
dr> nothings there, so i have to go to index.php for it to show (and it will log 
dr> me out) is this a bug in 4.0.1 im pretty sure its mysql..usually it 
dr> would show the posta nd if i chnaged something (ex. colors) i would have to 
dr> TOTALY reload the page, not just refresh like its supposed to do...what do i 
dr> do?

Can you be more detailed? What is exactly wrong with MySQL 4.0.1?




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

2002-08-11 Thread Bhavin Vyas


Also, see what errors you are getting in mysql .err file

Regards,
Bhavin.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, August 11, 2002 3:30 AM
Subject: Re: Mysql Problem Query


> did you also install the databases that are part of the mysql
installation?
>
> -Ll
>
> on 8/11/02 5:59 AM, Anish  Mathew, typed:
>
> > my sqlserver is not running
> >
> > when i issue the command  " mysql"
> >
> > the response i got was " cant connect to local mysql
> > server through socket /var/lib/mysql.sock (111) "
> >
> > when i issued the command " mysql.server start "
> >
> > i got "starting mysql daemon with databases from
> > /var/lib/mysql
> >   mysqld ended"
> >
> >   and the daemon ended abruptly without starting
> > the server.
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


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

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

Re: Mysql Problem Query

2002-08-11 Thread trogers


did you also install the databases that are part of the mysql installation?

-Ll

on 8/11/02 5:59 AM, Anish  Mathew, typed:

> my sqlserver is not running
> 
> when i issue the command  " mysql"
> 
> the response i got was " cant connect to local mysql
> server through socket /var/lib/mysql.sock (111) "
> 
> when i issued the command " mysql.server start "
> 
> i got "starting mysql daemon with databases from
> /var/lib/mysql
>   mysqld ended"
> 
>   and the daemon ended abruptly without starting
> the server.


-
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: Problem Installing on RH 7.3

2002-07-23 Thread Trond Eivind Glomsrød

Philip Molter <[EMAIL PROTECTED]> writes:

> On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote:
> : The mysqld.log file says:
> : 
> : 020717 13:05:05  mysqld started
> : 020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
> : './mysql/host.frm' (errno: 13)
> : 020717 13:05:05  mysqld ended
> : 
> : But I do see the host.frm file:
> : 
> : -rw-rw1 root root 8958 Jul 17 13:04
> : /var/lib/mysql/mysql/host.frm
> : 
> : How did you fix this problem?
> 
> Permissions are wrong.  MySQL typically runs as mysql:mysql, not
> root:root.  If I remember correctly, there may have been a problem
> with the setup scripts that handled this.  Check the RH bug reports.
> The fix is simply to change owner/groups on the necessary
> files/directories.
> 
> But Trond can give you specifics.  It still may be user error. :)

If memory serves... There were some permission problems in RHL 7,
fixed in an errata a couple of days after release.

The most common problem for a while was people running
mysql_install_db as root - the dbs will be created, but owned by
root. The database doesn't run as root, and can't write to it.

There has been a workaround for that in the initscripts as well.
-- 
Trond Eivind Glomsrød
Red Hat, Inc.

-
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: Problem Installing on RH 7.3

2002-07-19 Thread jusob


En réponse à Philip Molter <[EMAIL PROTECTED]>:
Hi
I am sure that tehre is a bug in RH 7.3
I've said it several times in this mailing list, but nobody wants to belive me!
It's true that this information is difficult to find, but I've learned it on 
the documentation of www.mysql.org, the one with user comments.

Regards
Julien Sobrier

> On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote:
> : The mysqld.log file says:
> : 
> : 020717 13:05:05  mysqld started
> : 020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
> : './mysql/host.frm' (errno: 13)
> : 020717 13:05:05  mysqld ended
> : 
> : But I do see the host.frm file:
> : 
> : -rw-rw1 root root 8958 Jul 17 13:04
> : /var/lib/mysql/mysql/host.frm
> : 
> : How did you fix this problem?
> 
> Permissions are wrong.  MySQL typically runs as mysql:mysql, not
> root:root.  If I remember correctly, there may have been a problem
> with the setup scripts that handled this.  Check the RH bug reports.
> The fix is simply to change owner/groups on the necessary
> files/directories.
> 
> But Trond can give you specifics.  It still may be user error. :)
> 
> : I do have the /var/lib/mysql/mysql.sock file...
> 
> * Philip Molter
> * Texas.net Internet
> * http://www.texas.net/
> * [EMAIL PROTECTED]
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 

-
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: Problem Installing on RH 7.3

2002-07-18 Thread Philip Molter


On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote:
: The mysqld.log file says:
: 
: 020717 13:05:05  mysqld started
: 020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
: './mysql/host.frm' (errno: 13)
: 020717 13:05:05  mysqld ended
: 
: But I do see the host.frm file:
: 
: -rw-rw1 root root 8958 Jul 17 13:04
: /var/lib/mysql/mysql/host.frm
: 
: How did you fix this problem?

Permissions are wrong.  MySQL typically runs as mysql:mysql, not
root:root.  If I remember correctly, there may have been a problem
with the setup scripts that handled this.  Check the RH bug reports.
The fix is simply to change owner/groups on the necessary
files/directories.

But Trond can give you specifics.  It still may be user error. :)

: I do have the /var/lib/mysql/mysql.sock file...

* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]

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

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

Re: MySQL: Problem Installing on RH 7.3

2002-07-18 Thread Gerald Clark


You can see them because you are root, and you own them.
Mysql can't see them because it is mysql.
chown   -R  mysql  /var/lib/mysql

Richard Fox wrote:

>The mysqld.log file says:
>
>020717 13:05:05  mysqld started
>020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
>'./mysql/host.frm' (errno: 13)
>020717 13:05:05  mysqld ended
>
>But I do see the host.frm file:
>
>-rw-rw1 root root 8958 Jul 17 13:04
>/var/lib/mysql/mysql/host.frm
>
>How did you fix this problem?
>
>I do have the /var/lib/mysql/mysql.sock file...
>
>Thanks
>Rich
>
>>I'm near enough in the same position as you are. Check the file
>>/var/log/mysqld.log to see what the problem is. I had a problem accessing
>>the file './mysql/host.frm', but I think that I've fixed this now.
>>
>>What happens when you try the 'mysql' command? I get the response
>>"can't connect to local MySQL server through socket
>>'/var/usr/mysql/mysql.sock'"
>>And indeed there is no such file.
>>Do you have this file?
>>
>>-Original Message-
>>From: Richard Fox [mailto:[EMAIL PROTECTED]]
>>Sent: Wednesday, July 17, 2002 10:41 PM
>>To: [EMAIL PROTECTED]
>>Subject: MySQL: Problem Installing on RH 7.3
>>
>>
>>
>>The MySQL daemon does not run. I installed the binary RPM's from the RH
>>
>cd,
>
>>MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
>>execute correctly. The I run safe_mysqld &, and I get:
>>
>>[root@thor rfox]# /usr/bin/safe_mysqld &
>>[1] 2212
>>[root@thor rfox]# Starting mysqld daemon with databases from
>>
>/var/lib/mysql
>
>>020717 15:21:28  mysqld ended
>>
>>That's it! I tried both the rpm and compiling it myself from source with
>>BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior
>>
>>I just need a little hint, please! How do I troubleshoot this?
>>
>>Thanks,
>>
>>Rich
>>
>>sql
>>
>>
>>-
>>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: MySQL: Problem Installing on RH 7.3

2002-07-18 Thread Ryan Fox


First, nice username :)

Anyhow, use the /etc/init.d/mysqld script as root to start/stop mysql,
not the safe_mysqld binary.  The init.d script really calls the
safe_mysqld binary, but ti also makes a couple sanity checks like
ensuring that the initial database files exist and are owned by the
proper user.
 
Example:
# /etc/init.d/mysqld start

This should get you past the problem you are currently having, which is
that mysqld can't find it's database files.  This is mostly due to
redhat's mysql rpm installing the database files in a different location
than mysql's distibution does.

Hope this helps,
Ryan Fox
[EMAIL PROTECTED]


On Thu, 2002-07-18 at 11:44, Richard Fox wrote:
> The mysqld.log file says:
> 
> 020717 13:05:05  mysqld started
> 020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 020717 13:05:05  mysqld ended
> 
> But I do see the host.frm file:
> 
> -rw-rw1 root root 8958 Jul 17 13:04
> /var/lib/mysql/mysql/host.frm
> 
> How did you fix this problem?
> 
> I do have the /var/lib/mysql/mysql.sock file...
> 
> Thanks
> Rich
> 
> > I'm near enough in the same position as you are. Check the file
> > /var/log/mysqld.log to see what the problem is. I had a problem accessing
> > the file './mysql/host.frm', but I think that I've fixed this now.
> >
> > What happens when you try the 'mysql' command? I get the response
> > "can't connect to local MySQL server through socket
> > '/var/usr/mysql/mysql.sock'"
> > And indeed there is no such file.
> > Do you have this file?
> >
> > -Original Message-
> > From: Richard Fox [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 17, 2002 10:41 PM
> > To: [EMAIL PROTECTED]
> > Subject: MySQL: Problem Installing on RH 7.3
> >
> >
> >
> > The MySQL daemon does not run. I installed the binary RPM's from the RH
> cd,
> > MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
> > execute correctly. The I run safe_mysqld &, and I get:
> >
> > [root@thor rfox]# /usr/bin/safe_mysqld &
> > [1] 2212
> > [root@thor rfox]# Starting mysqld daemon with databases from
> /var/lib/mysql
> > 020717 15:21:28  mysqld ended
> >
> > That's it! I tried both the rpm and compiling it myself from source with
> > BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior
> >
> > I just need a little hint, please! How do I troubleshoot this?
> >
> > Thanks,
> >
> > Rich
> >
> > sql
> >
> >
> > -
> > 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: MySQL: Problem Installing on RH 7.3

2002-07-18 Thread Mark Schoonover


At first blush it looks like it's a rights problem. Need to have the
/var/lib/mysql owned by mysql.mysql... If you're starting mysql as the user
mysql...

HTH

.mark

> -Original Message-
> From: Richard Fox [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 18, 2002 8:44 AM
> To: Noamn; [EMAIL PROTECTED]
> Subject: Re: MySQL: Problem Installing on RH 7.3
> 
> 
> The mysqld.log file says:
> 
> 020717 13:05:05  mysqld started
> 020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 020717 13:05:05  mysqld ended
> 
> But I do see the host.frm file:
> 
> -rw-rw1 root root 8958 Jul 17 13:04
> /var/lib/mysql/mysql/host.frm
> 
> How did you fix this problem?
> 
> I do have the /var/lib/mysql/mysql.sock file...
> 
> Thanks
> Rich
> 
> > I'm near enough in the same position as you are. Check the file
> > /var/log/mysqld.log to see what the problem is. I had a 
> problem accessing
> > the file './mysql/host.frm', but I think that I've fixed this now.
> >
> > What happens when you try the 'mysql' command? I get the response
> > "can't connect to local MySQL server through socket
> > '/var/usr/mysql/mysql.sock'"
> > And indeed there is no such file.
> > Do you have this file?
> >
> > -Original Message-
> > From: Richard Fox [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 17, 2002 10:41 PM
> > To: [EMAIL PROTECTED]
> > Subject: MySQL: Problem Installing on RH 7.3
> >
> >
> >
> > The MySQL daemon does not run. I installed the binary RPM's 
> from the RH
> cd,
> > MySQL 3.23.49. I run mysql_install_db, outputs some text 
> and appears to
> > execute correctly. The I run safe_mysqld &, and I get:
> >
> > [root@thor rfox]# /usr/bin/safe_mysqld &
> > [1] 2212
> > [root@thor rfox]# Starting mysqld daemon with databases from
> /var/lib/mysql
> > 020717 15:21:28  mysqld ended
> >
> > That's it! I tried both the rpm and compiling it myself 
> from source with
> > BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior
> >
> > I just need a little hint, please! How do I troubleshoot this?
> >
> > Thanks,
> >
> > Rich
> >
> > sql
> >
> >
> > 
> -
> > 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: MySQL: Problem Installing on RH 7.3

2002-07-18 Thread Jan Kudrman


I am not sure, but are you sure that mysqld is running as a root? Or as a
mysql (user) and mysql (group).

Try to check rights of the mysqld user.

Jan


- Original Message -
From: "Richard Fox" <[EMAIL PROTECTED]>
To: "Noamn" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 5:44 PM
Subject: Re: MySQL: Problem Installing on RH 7.3


The mysqld.log file says:

020717 13:05:05  mysqld started
020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020717 13:05:05  mysqld ended

But I do see the host.frm file:

-rw-rw1 root root 8958 Jul 17 13:04
/var/lib/mysql/mysql/host.frm

How did you fix this problem?

I do have the /var/lib/mysql/mysql.sock file...

Thanks
Rich

> I'm near enough in the same position as you are. Check the file
> /var/log/mysqld.log to see what the problem is. I had a problem accessing
> the file './mysql/host.frm', but I think that I've fixed this now.
>
> What happens when you try the 'mysql' command? I get the response
> "can't connect to local MySQL server through socket
> '/var/usr/mysql/mysql.sock'"
> And indeed there is no such file.
> Do you have this file?
>
> -Original Message-
> From: Richard Fox [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 17, 2002 10:41 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL: Problem Installing on RH 7.3
>
>
>
> The MySQL daemon does not run. I installed the binary RPM's from the RH
cd,
> MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
> execute correctly. The I run safe_mysqld &, and I get:
>
> [root@thor rfox]# /usr/bin/safe_mysqld &
> [1] 2212
> [root@thor rfox]# Starting mysqld daemon with databases from
/var/lib/mysql
> 020717 15:21:28  mysqld ended
>
> That's it! I tried both the rpm and compiling it myself from source with
> BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior
>
> I just need a little hint, please! How do I troubleshoot this?
>
> Thanks,
>
> Rich
>
> sql
>
>
> -
> 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: MySQL: Problem Installing on RH 7.3

2002-07-18 Thread Richard Fox


The mysqld.log file says:

020717 13:05:05  mysqld started
020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020717 13:05:05  mysqld ended

But I do see the host.frm file:

-rw-rw1 root root 8958 Jul 17 13:04
/var/lib/mysql/mysql/host.frm

How did you fix this problem?

I do have the /var/lib/mysql/mysql.sock file...

Thanks
Rich

> I'm near enough in the same position as you are. Check the file
> /var/log/mysqld.log to see what the problem is. I had a problem accessing
> the file './mysql/host.frm', but I think that I've fixed this now.
>
> What happens when you try the 'mysql' command? I get the response
> "can't connect to local MySQL server through socket
> '/var/usr/mysql/mysql.sock'"
> And indeed there is no such file.
> Do you have this file?
>
> -Original Message-
> From: Richard Fox [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 17, 2002 10:41 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL: Problem Installing on RH 7.3
>
>
>
> The MySQL daemon does not run. I installed the binary RPM's from the RH
cd,
> MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
> execute correctly. The I run safe_mysqld &, and I get:
>
> [root@thor rfox]# /usr/bin/safe_mysqld &
> [1] 2212
> [root@thor rfox]# Starting mysqld daemon with databases from
/var/lib/mysql
> 020717 15:21:28  mysqld ended
>
> That's it! I tried both the rpm and compiling it myself from source with
> BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior
>
> I just need a little hint, please! How do I troubleshoot this?
>
> Thanks,
>
> Rich
>
> sql
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


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

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

Re: MySQL: Problem Installing on RH 7.3

2002-07-17 Thread Philip Molter


On Wed, Jul 17, 2002 at 04:40:50PM -0400, Richard Fox wrote:
: 
: The MySQL daemon does not run. I installed the binary RPM's from the RH cd,
: MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
: execute correctly. The I run safe_mysqld &, and I get:
: 
: [root@thor rfox]# /usr/bin/safe_mysqld &
: [1] 2212
: [root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql
: 020717 15:21:28  mysqld ended
: 
: That's it! I tried both the rpm and compiling it myself from source with
: BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior

If it's the RPMs from RH, have you tried /etc/init.d/mysqld start?
That's the standard way of starting services on RH.  Have you looked
in /var/log/mysqld.log for any errors?

* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]

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

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

RE: MySQL: Problem Installing on RH 7.3

2002-07-17 Thread Cal Evans


Dig around for a log file or an error file. Whenever it won't start it tells
you why (or gives you a hint) in the error file.  tail it and post if you
still need help.

=C=

*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*


-Original Message-
From: Richard Fox [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 3:41 PM
To: [EMAIL PROTECTED]
Subject: MySQL: Problem Installing on RH 7.3



The MySQL daemon does not run. I installed the binary RPM's from the RH cd,
MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
execute correctly. The I run safe_mysqld &, and I get:

[root@thor rfox]# /usr/bin/safe_mysqld &
[1] 2212
[root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql
020717 15:21:28  mysqld ended

That's it! I tried both the rpm and compiling it myself from source with
BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior

I just need a little hint, please! How do I troubleshoot this?

Thanks,

Rich

sql


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

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



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

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

Re: MYSQL Problem (Will not write to but will read)

2002-07-17 Thread Ralf Narozny


I guess your harddisk ran out of space. Delete some stuffwithout 
restarting the database.

Relihan, Daniel wrote:

>Hi,
>
>All of a sudden it seems that my MYSQL is incapable of being written to. I
>can still read from it, but cannot write to it. When I looked at the
>processes, all the processes that tried to write to the database are in a
>state of 'Locked'. Any ideas what to do?
>
>- Dan Relihan
>
>-
>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
>
>  
>

-- 
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de




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

2002-06-10 Thread Simona D'Ambrosio


Now it works!!!
My problem was that I didn't know that if I set up passwords for users I had
to tell it to the web pages where I connect to the database (postgres
doesn't work like that).
I know this is stupid, but I began my message with "I am new to mysql" :-)
Anyway thank you for your replies.
Simona

> What happend when you ran scripts/mysql_install_db ?
> Also when you run the databases with --skip-grant-tables as soon as you
> grant a user acess and flush privileges it will then use the grant tables
(I
> think)..
> Simon
>
> -Original Message-
> From: Simona D'Ambrosio [mailto:[EMAIL PROTECTED]]
> Sent: 10 June 2002 14:32
> To: [EMAIL PROTECTED]
> Subject: mysql problem
>
>
> Hi! I am new to mysql and this is my problem.
> The daemon runs well but I can start it only with --skip-grant-tables
> option, otherwise nothing will work.
> I set the password for the root user but when I exit the Mysql monitor and
> try to get in again, no password is request.
> When I set the password I entered flush privileges, but it returns "0 rows
> affected", if  I try with "mysqladmin" it returns "You have no
> privileges".
> Please, help me... I am almost out of mind for this!
>
> Simona
>
>
> -
> 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: mysql problem

2002-06-10 Thread Egor Egorov


Simona,
Monday, June 10, 2002, 4:31:33 PM, you wrote:

SDA> Hi! I am new to mysql and this is my problem.
SDA> The daemon runs well but I can start it only with --skip-grant-tables
SDA> option, otherwise nothing will work.
SDA> I set the password for the root user but when I exit the Mysql monitor and
SDA> try to get in again, no password is request.
SDA> When I set the password I entered flush privileges, but it returns "0 rows
SDA> affected", if  I try with "mysqladmin" it returns "You have no
SDA> privileges".
SDA> Please, help me... I am almost out of mind for this!

Simona, you provided incomplete info! Please, show full error
messages, full connection string and commands.

SDA> Simona





-- 
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: mysql problem

2002-06-10 Thread Simon Green


What happend when you ran scripts/mysql_install_db ?
Also when you run the databases with --skip-grant-tables as soon as you
grant a user acess and flush privileges it will then use the grant tables (I
think)..
Simon

-Original Message-
From: Simona D'Ambrosio [mailto:[EMAIL PROTECTED]]
Sent: 10 June 2002 14:32
To: [EMAIL PROTECTED]
Subject: mysql problem


Hi! I am new to mysql and this is my problem.
The daemon runs well but I can start it only with --skip-grant-tables
option, otherwise nothing will work.
I set the password for the root user but when I exit the Mysql monitor and
try to get in again, no password is request.
When I set the password I entered flush privileges, but it returns "0 rows
affected", if  I try with "mysqladmin" it returns "You have no
privileges".
Please, help me... I am almost out of mind for this!

Simona


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

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

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

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

Re: MySQL Problem

2002-05-03 Thread Victoria Reznichenko


Jagadeesh,
Friday, May 03, 2002, 8:06:12 AM, you wrote:

JS> We want to use MYSQl as a back end for one of our projects.
JS> We download following 4 zip to install MySQL.

JS> mysql-4.0.0a-alpha-win-src.zip
JS> mysql-4.0.0a-alpha-win.zip
JS> mysql-4.0.1a-alpha-win-src.zip
JS> mysql-4.0.1a-alpha-win.zip

*.win.src.zip is a source distribution.
*.win.zip is a binary package.

Read installation notes at:
 http://www.mysql.com/doc/W/i/Windows_installation.html

JS> After unzipping the file and MySQL is loaded successfully.
JS> But in programs it is not showing any shortcut or program name 
JS> for
JS> mysql.
JS> There are any other files to be downloaded to install MySQL 
JS> properly.
JS> When i check in the folder where it is loaded MySQL there are some 
JS> applications
JS> with names MySQLManager,WinMysqladmin in bin directory.
JS> When click on these applications it showing some screens but we 
JS> are unable to
JS> do anything on these screen i can only create new database but 
JS> unable to create
JS> any tables.
JS> So send me all the details asap

You should use client program mysql.exe or any graphical client.

You can download two different GUI clients: MyCC and MySQLGUI from MySQL site.

 http://www.mysql.com/downloads/index.html

Any other info about working with MySQL software is also in the manual.
Please, check it:
 http://www.mysql.com/doc/

JS> Thanks




-- 
For technical support contracts, goto https://order.mysql.com/
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 Problem

2002-05-03 Thread Dicky Wahyu Purnomo


On 3 May 2002 05:06:12 -
"Jagadeesh  Suryadevara" <[EMAIL PROTECTED]> wrote:

> When i check in the folder where it is loaded MySQL there are some 
> applications
> with names MySQLManager,WinMysqladmin in bin directory.
> When click on these applications it showing some screens but we 
> are unable to
> do anything on these screen i can only create new database but 
> unable to create
> any tables.
> So send me all the details asap

you should find in bin directory, a file called "mysql", you can run it from ms-dos 
prompt it's text based ;-) 

-- 
Let's call it an accidental feature.
-- Larry Wall

-
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 Problem in Slackware 8.0

2002-01-16 Thread Prasad Paranjape


Dear Gurus,

Yesterday I changed the ownership of /var/lib/mysql to
user mysql
chown -R mysql /var/lib/mysql

Then I started the mysql server with command
/usr/bin/safe_mysqld --skip-grant-tables
The daemon started without crashing immediately.

I then could get into mysql prompt


As per manual it stys that GRANT command is not
recognised but I then did mysqladmin reload and then
restarted the server in user mysql.
I then went to prompt mysql and gave grant all to
root(I mean root of MySQL) and did FLUSH
PRIVILEGES(Both SQL command were successfull)

Now one step I missed from manual before running
mysqladmin reload was to run mannually SQL scripts
from mysql_install_db.

I want to know whay I need to run scripts which are
creating system tables in this script or is it that I
need to run only sqls which are insert values.

When I give command mysql -u root -p and then give the
password (correctly)it gives me following error:
Access Denied for user 'root@localhost' (Using
password:YES)

Am I following the steps wrongly?

Should I uninstall the MySQL and also delete the
datadir and then again install mysql package in
Slack8?

Regards,

Prasad


--- Prasad Paranjape <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I also noticed one thing , will the entry in the
> file
> /etc/hosts make a diffrenece.
> 
> In Red Hat it is 
> 127.0.0.1 localhost
> 
> But in Slack it is
> 127.0.0.1 prasad( which is my name)
> 
> Regards,
> 
> Prasad
> --- Prasad Paranjape <[EMAIL PROTECTED]>
> wrote:
> > Hello gurus,
> > 
> > I have Slackware 8.0 and RHL7.1 both on my Linux
> > box.
> > In Red Hat mysql is working smoothly but I am
> having
> > having following problems in Slack8
> > In Slack8 mysql is installed as a per of standard
> > installtion but not under /usr/local.The scripts
> are
> > in /usr/bin and includes in /usr/include/mysql and
> > libs in /usr/lib/mysql etc..
> > I could see that there is a group mysql and user
> > mysql
> > added to it.
> > I could not loacte mention of mysqld in any of the
> > rc
> > scripts.when as root I give command 
> > /usr/bin/safe_mysqld &
> > It gives me following messages:
> > Starting mysqld daemon with databases from
> > /var/lib/mysql and on the next line it says
> > mysqld ended.
> > 
> > Also when as user mysql I give command
> > mysql -u mysql -p it prompts for the password but
> > after giving the password it gives error:
> > can't connect to loacl mysql server through socket
> > /var/run/mysql/mysql.sock
> > 
> > I also copied the file /etc/my-small.cnf to
> > ~mysql/.my.cnf (This is as per documentation in
> > my-small.cnf)
> > 
> > Still I am not able to log on to the database.
> > 
> > I am not able to understand why mysqld is
> ending.Is
> > there any other thing I am missing which would
> start
> > this daemon and then I can connect to database.
> > 
> > Regards,
> > 
> > Prasad
> > 
> > 
> > 
> > __
> > Do You Yahoo!?
> > Send FREE video emails in Yahoo! Mail!
> > http://promo.yahoo.com/videomail/
> > 
> >
>
-
> > 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 email alerts & NEW webcam video instant
> messaging with Yahoo! Messenger. http://im.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
> 


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/

-
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 Problem in Slackware 8.0

2002-01-16 Thread Prasad Paranjape


Hi,

I also noticed one thing , will the entry in the file
/etc/hosts make a diffrenece.

In Red Hat it is 
127.0.0.1 localhost

But in Slack it is
127.0.0.1 prasad( which is my name)

Regards,

Prasad
--- Prasad Paranjape <[EMAIL PROTECTED]> wrote:
> Hello gurus,
> 
> I have Slackware 8.0 and RHL7.1 both on my Linux
> box.
> In Red Hat mysql is working smoothly but I am having
> having following problems in Slack8
> In Slack8 mysql is installed as a per of standard
> installtion but not under /usr/local.The scripts are
> in /usr/bin and includes in /usr/include/mysql and
> libs in /usr/lib/mysql etc..
> I could see that there is a group mysql and user
> mysql
> added to it.
> I could not loacte mention of mysqld in any of the
> rc
> scripts.when as root I give command 
> /usr/bin/safe_mysqld &
> It gives me following messages:
> Starting mysqld daemon with databases from
> /var/lib/mysql and on the next line it says
> mysqld ended.
> 
> Also when as user mysql I give command
> mysql -u mysql -p it prompts for the password but
> after giving the password it gives error:
> can't connect to loacl mysql server through socket
> /var/run/mysql/mysql.sock
> 
> I also copied the file /etc/my-small.cnf to
> ~mysql/.my.cnf (This is as per documentation in
> my-small.cnf)
> 
> Still I am not able to log on to the database.
> 
> I am not able to understand why mysqld is ending.Is
> there any other thing I am missing which would start
> this daemon and then I can connect to database.
> 
> Regards,
> 
> Prasad
> 
> 
> 
> __
> Do You Yahoo!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/
> 
>
-
> 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 email alerts & NEW webcam video instant messaging with Yahoo! Messenger. 
http://im.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: MySQL Problem in Slackware 8.0

2002-01-16 Thread Chris Bolt


> when as root I give command 
> /usr/bin/safe_mysqld &
> It gives me following messages:
> Starting mysqld daemon with databases from
> /var/lib/mysql and on the next line it says
> mysqld ended.

What does /var/lib/mysql/`hostname`.err say?

-
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 problem with Traffic and Updates

2001-10-25 Thread Steve Meyers


> Today after my server got a real traffic hit for the first time since I
> installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. 
> Here's how
> it happened: watching the "top" load levels, I saw it slow creep 
> up about to
> 3, then rockets quickly to 30s, 40s, and on!! MySQL was at this 
> time taking
> up 100% of both of the processors in the server. There were about 40 or so
> MySQL processes spawned at this point. Doing a 'mysqladmin processlist'
> command on the server showed me a VERY LONG LIST of processes that were
> open, a lot of which were PhpAdsNew UPDATE commands.
> 
This can happen with MyISAM tables, where table locking is an issue.  It should only 
be a problem if some ugly queries are happening though...

Here's the rundown (all queries are assumed to be on the same table):

1. Somebody runs a SELECT that takes a while to complete
2. Somebody runs an UPDATE or DELETE (or possibly INSERT, depending on the 
circumstances)
3. The UPDATE has to wait for the SELECT to finish to begin processing
4. All subsequent queries have to wait for the UPDATE to finish
5. Depending on configuration, you may run out of active MySQL threads to handle the 
incoming queries
6. The CPU spends all of it's time spawning new threads to handle the incoming 
connections, instead of finishing the SELECT that's holding up traffic
7. The increase in memory usage is enormous...
8. If things are really bad, the server will eventually crash

Possible solutions:

1. Get rid of all long SELECT statements
2. Add proper indexes so that long SELECT statements become short
3. Switch to InnoDB if #1 and #2 aren't feasible, the multi-versioning and row-level 
locking will eliminate those problems

There are other possible solutions.  I've done some work in similar environments, if 
you'd like I can help you find the best way to get your database working smoothly.

Steve Meyers



-
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 problem with Traffic and Updates

2001-10-25 Thread Michael T. Babcock


On Thu, Oct 25, 2001 at 08:27:00AM -0700, Bill Adams wrote:
> > At http://www.mysql.com/doc/ do a search for multiple processors. There's
> > a refence to http://www.mysql.com/Downloads/Patches/linux-fork.patch that
> > might help.
> 
> And don't forget to make sure you have good/needed indexes.
> (e.g See the manual entry on "EXPLAIN", run myisamchk -a, etc..).
 
And make sure you're logging slow queries.  Then take each of the logged
queries (I log anything that takes more than two seconds) and run them through
EXPLAIN to see where you could modify the query and/or change indexes.
-- 
Michael T. Babcock
CTO, FibreSpeed Ltd.

-
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 problem with Traffic and Updates

2001-10-25 Thread Bill Adams


jim barchuk wrote:

> Hi Ryan!
>
> > Today after my server got a real traffic hit for the first time since I
> > installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how
> > it happened: watching the "top" load levels, I saw it slow creep up about to
> > 3, then rockets quickly to 30s, 40s, and on!! MySQL was at this time taking
> > up 100% of both of the processors in the server. There were about 40 or so
> > MySQL processes spawned at this point. Doing a 'mysqladmin processlist'
> > command on the server showed me a VERY LONG LIST of processes that were
> > open, a lot of which were PhpAdsNew UPDATE commands.
> >
> > The system it is on is a Dual-Athlon 1.2 GHz with 1 GB of memory.  I have
> > heard of systems that run at 450 MHz to be able to handle more ad views than
> > this system is taking.  I have the latest MySQL and PHP, all on Red Hat 7.1.
> > This is the second ad software that has done this, so I don't think the
> > problem is so much in the software, but something about my MySQL config or
> > setup.
>
> Obviously the system should handle the load.
>
> At http://www.mysql.com/doc/ do a search for multiple processors. There's
> a refence to http://www.mysql.com/Downloads/Patches/linux-fork.patch that
> might help.

And don't forget to make sure you have good/needed indexes.
(e.g See the manual entry on "EXPLAIN", run myisamchk -a, etc..).

b.



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

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

Re: MySQL problem with Traffic and Updates

2001-10-25 Thread jim barchuk


Hi Ryan!

> Today after my server got a real traffic hit for the first time since I
> installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how
> it happened: watching the "top" load levels, I saw it slow creep up about to
> 3, then rockets quickly to 30s, 40s, and on!! MySQL was at this time taking
> up 100% of both of the processors in the server. There were about 40 or so
> MySQL processes spawned at this point. Doing a 'mysqladmin processlist'
> command on the server showed me a VERY LONG LIST of processes that were
> open, a lot of which were PhpAdsNew UPDATE commands.
>
> The system it is on is a Dual-Athlon 1.2 GHz with 1 GB of memory.  I have
> heard of systems that run at 450 MHz to be able to handle more ad views than
> this system is taking.  I have the latest MySQL and PHP, all on Red Hat 7.1.
> This is the second ad software that has done this, so I don't think the
> problem is so much in the software, but something about my MySQL config or
> setup.

Obviously the system should handle the load.

At http://www.mysql.com/doc/ do a search for multiple processors. There's
a refence to http://www.mysql.com/Downloads/Patches/linux-fork.patch that
might help.

Have a :) day!

jb

ob-filter-words: table sql database

-- 
jim barchuk
[EMAIL PROTECTED]


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

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

RE: mysql problem

2001-07-09 Thread Noel Clarkson


Wouldn't that depend on if the MySQL db is on the same server as the web 
servers and the scripts that connect to them.  It could also depend on if 
the scripts use the -h option when making a connection and if this is the 
ip address (as in number) or is a resolvable name.  If it is all local, if 
the grants use an ip number instead of localhost to give the needed 
permissions then you might want to check that also.

I agree if you are using root to connect from web scripts etc you really 
need to change this.

cheers,

noel

On Tuesday, July 10, 2001 11:34 AM, Rolf Hopkins 
[SMTP:[EMAIL PROTECTED]] wrote:
> Changing your IP address shouldn't affect your MySQL access in that way. 
 I
> would say you have done something else to cause those errors.  You can 
look
> at skip grants in the manual.  From what you have written, your web pages
> are accessing the DB as root.  That spells D A N G E R.  You should 
create
> another user with less access.
>
> - Original Message -
> From: "Kevin Robertson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 10, 2001 1:43
> Subject: mysql problem
>
>
> > I changed IP numbers on the Cobalt RAQ i have mysql on. I no longer 
have
> > access to the databases. I think i have lost access as root. Is there a
> > way to restore the root user password and/or change it to something 
else
> > manually? I have many websites with many 'access denied' errors.
> >
> >
> > Any help would be appreciated.
> >
> > Thanks,
> > Kevin Robertson
> >
> >
> > -
> > 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: mysql problem

2001-07-09 Thread Rolf Hopkins

Changing your IP address shouldn't affect your MySQL access in that way.  I
would say you have done something else to cause those errors.  You can look
at skip grants in the manual.  From what you have written, your web pages
are accessing the DB as root.  That spells D A N G E R.  You should create
another user with less access.

- Original Message -
From: "Kevin Robertson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 1:43
Subject: mysql problem

> I changed IP numbers on the Cobalt RAQ i have mysql on. I no longer have
> access to the databases. I think i have lost access as root. Is there a
> way to restore the root user password and/or change it to something else
> manually? I have many websites with many 'access denied' errors.
>
>
> Any help would be appreciated.
>
> Thanks,
> Kevin Robertson
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

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

Re: MySQL Problem -- Please help

2001-06-09 Thread oltra jean-michel



> When I run test.php I get this:
>
> Warning: Supplied argument is not a valid MySQL result resource in common.php on 
>line 27
> 0
>
> Here are lines 25-27:
> 25: $sql = "select urate, arate, inhits from sitestats where id = $id";
> 26: $r = mysql_query($sql);
> 27: $row = mysql_fetch_array($r);
>
> I thought using the result identifier returned by mysql_query in mysql_fetch_array 
>was perfectly legal.

bonjour,

Try: ...where id = '$id'";
on line 25

jean-michel


-
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 Problem -- Please help

2001-06-09 Thread Chris Bolt


> I thought using the result identifier returned by mysql_query in
> mysql_fetch_array was perfectly legal.

mysql_query() doesn't always return a valid result identifier if an error
occurs (echo mysql_error()) or if no rows are returned.


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

2001-05-13 Thread webmaster


Hi

Here is my my.cnf. pls suggest the changes to make the 
performance better. I am upgrading to the latest version.

===
# Example mysql config file.
# You can copy this to one of:
# /usr/local/mysql/etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /usr/local/mysql/var) or
# ~/.my.cnf to set user-specific options.
# 
# 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  = /tmp/mysql.sock

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

# The MySQL server
[mysqld]
port= 3306
socket  = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=8M
set-variable= back_log=25
set-variable= max_allowed_packet=1M
set-variable= thread_stack=128K
set-variable= max_connections=50
set-variable= table_cache=32
set-variable= sort_buffer=500K
set-variable= record_buffer=100K
set-variable= net_buffer=5K
# Start logging
log

[mysqldump]
quick
set-variable= max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
set-variable= key_buffer=16M


=

with best wishes

Arun

Date sent:  Sun, 13 May 2001 18:41:50 -0700
From:   Jeremy Zawodny <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Copies to:  [EMAIL PROTECTED]
Subject:        Re: Mysql Problem
Send reply to:  [EMAIL PROTECTED]

> On Fri, May 11, 2001 at 07:48:04PM +0530, [EMAIL PROTECTED] wrote:
> > 
> > I am facing great problems beacuse of Mysql server which is not able
> > to take load.
> > 
> > My apache is working fine even when the load average shoots of to
> > 130 but my mysql server goes sleep when the load of apache shoots
> > above 30. I am on a dedicated server.
> > 
> > My Mysql Ver 3.22.32
> 
> You may try upgrading to 3.23.xx. There were some performance
> improvements in the newer versions.
> 
> > I have red hat linux 6.2 as OS and memory of 256 MB .
> > 
> > I am attaching my my.cnf file , pls look into it and suggest ways
> > for improving my server performance.
> 
> Attachements are filtered by this list, in case you didn't notice.
> 
> Jeremy
> -- 
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951
> 
> MySQL 3.23.29: up 130 days, processed 804,119,056 queries (71/sec. avg)
> 



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

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

Re: Mysql Problem

2001-05-13 Thread Jeremy Zawodny


On Fri, May 11, 2001 at 07:48:04PM +0530, [EMAIL PROTECTED] wrote:
> 
> I am facing great problems beacuse of Mysql server which is not able
> to take load.
> 
> My apache is working fine even when the load average shoots of to
> 130 but my mysql server goes sleep when the load of apache shoots
> above 30. I am on a dedicated server.
> 
> My Mysql Ver 3.22.32

You may try upgrading to 3.23.xx. There were some performance
improvements in the newer versions.

> I have red hat linux 6.2 as OS and memory of 256 MB .
> 
> I am attaching my my.cnf file , pls look into it and suggest ways
> for improving my server performance.

Attachements are filtered by this list, in case you didn't notice.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 130 days, processed 804,119,056 queries (71/sec. avg)

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

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

Re: mysql problem

2001-04-24 Thread Curtis Maurand



Hello,
  Your column counts don't match.  You call out 24 columns in in your
insert statement, but you only have 20 values.

Curtis


On Tue, 24 Apr 2001, J.Heegsma wrote:

> Dear Sir/Madam and mysql users,
>
> I have a mysql database which i can fill with phpadmin, everything is going fine, 
>but when I want to fill the database with php and a form. I got the following 
>problem. I don't know what to do anymore? Can anyone help me?
>
> I have made a form, which visitors can fill in, with a php-script I send the 
>information to the database. There is a database connection, but the information 
>isn't put in the database. When I try to this with phpadmin everything is going fine, 
>but with the user form not.
>
> I have put the code under this message, if anyone can help me, I hope to hear from 
>him or her by e-mail: [EMAIL PROTECTED]
>
> Thanks,
> Johan
>
>  Require ('connect2.php');
> $sqlquery="INSERT INTO Lid (Achternaam, Voornaam, Adres, Postcode, Woonplaats, 
>Telefoonnummer, Emailadres, Geslacht, Geboortedatum, Studentennummer, Hogeschool, 
>Opleiding, Studiejaar, Soortlid, Vereniging, Stage, Stageplaats, Stageduur, 
>Gratissport1, Gratissport2, Gratissport3, Extrasport1, Extrasport2, Extrasport3) 
>VALUES('$Achternaam','$Voornaam','$Adres','$Postcode','$Woonplaats','$Gebdatum','$Soortlid','$Hogeschool','$Collegekaart','$Studierichting','$Studiejaar','$stage','$Stageplaats','$Stageduur','$Keuze1','$Keuze2','$Keuze3','$Keuze4','$Keuze5','$Keuze6')";
> mysql_close();
>
> print " HBOSPORT Inschrijving 
> ";
> print " You
> Just send This Information to HBOSPORT";
> print "Naam : $Achternaam
> Voornaam : $Voornaam
> Adres :$Adres
> 
> Postcode :$Postcode
> 
> Woonplaats :$Woonplaats
> 
> Gebdatum :$Gebdatum
> 
> Soort Lid :$Soortlid
> 
> Hogeschool :$Hogeschool
> 
> Collegekaart :$Collegekaart
> 
> Studierichting :$Studierichting
> 
> Studiejaar :$Studiejaar
> 
> Stage JA/NEE :$Stage
> 
> Stageplaats :$Stageplaats
> 
> Stageduur :$Stageduur
> 
> Gratis sport
> 
> 
> Belangstelling voor: :$Keuze1
> 
> Belangstelling voor: :$Keuze2
> 
> Belangstelling voor: :$Keuze3
> 
> Betaalde sport
> 
> 
> 
> Belangstelling voor: :$Keuze4
> 
> Belangstelling voor: :$Keuze5
> 
> Belangstelling voor: :$Keuze6
> 
> 
> 
> 
> 
> ";
> ?>
>


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

2001-04-24 Thread Mirek Novak



My hint is inserted in code. This can help ,if you have connection established and 
proper database selected. If you dont't know what I'm talking about, try

http://www.php.net/manual/en/function.mysql-select-db.php

there is also small example included.

Mirek Novak

 Require ('connect2.php');
> $sqlquery="INSERT INTO Lid (Achternaam, Voornaam, Adres, Postcode, Woonplaats, 
>Telefoonnummer, Emailadres, Geslacht, Geboortedatum, Studentennummer, Hogeschool, 
>Opleiding, Studiejaar, Soortlid, Vereniging, Stage, Stageplaats, Stageduur, 
>Gratissport1, Gratissport2, Gratissport3, Extrasport1, Extrasport2, Extrasport3) 
>VALUES('$Achternaam','$Voornaam','$Adres','$Postcode','$Woonplaats','$Gebdatum','$Soortlid','$Hogeschool','$Collegekaart','$Studierichting','$Studiejaar','$stage','$Stageplaats','$Stageduur','$Keuze1','$Keuze2','$Keuze3','$Keuze4','$Keuze5','$Keuze6')";
>

mysql_query($sqlquery);

> mysql_close();
>
> print " HBOSPORT Inschrijving 
> ";
> print " You
> Just send This Information to HBOSPORT";
> print "Naam : $Achternaam
> Voornaam : $Voornaam
> Adres :$Adres
> 
> Postcode :$Postcode
> 
> Woonplaats :$Woonplaats
> 
> Gebdatum :$Gebdatum
> 
> Soort Lid :$Soortlid
> 
> Hogeschool :$Hogeschool
> 
> Collegekaart :$Collegekaart
> 
> Studierichting :$Studierichting
> 
> Studiejaar :$Studiejaar
> 
> Stage JA/NEE :$Stage
> 
> Stageplaats :$Stageplaats
> 
> Stageduur :$Stageduur
> 
> Gratis sport
> 
> 
> Belangstelling voor: :$Keuze1
> 
> Belangstelling voor: :$Keuze2
> 
> Belangstelling voor: :$Keuze3
> 
> Betaalde sport
> 
> 
> 
> Belangstelling voor: :$Keuze4
> 
> Belangstelling voor: :$Keuze5
> 
> Belangstelling voor: :$Keuze6
> 
> 
> 
> 
> 
> ";
> ?>


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

2001-04-24 Thread B. van Ouwerkerk


Here we go again

This is a PHP issue NOT MySQL.. more info: www.devshed.com 
www.phpnewbie.com www.phpbeginner.com www.php.net

One hint.. don't forget ?> to close PHP code..

Bye,


B.

mysql, query

At 14:46 24-4-01 +0200, J.Heegsma wrote:
>Dear Sir/Madam and mysql users,
>
>I have a mysql database which i can fill with phpadmin, everything is 
>going fine, but when I want to fill the database with php and a form. I 
>got the following problem. I don't know what to do anymore? Can anyone help me?
>
>I have made a form, which visitors can fill in, with a php-script I send 
>the information to the database. There is a database connection, but the 
>information isn't put in the database. When I try to this with phpadmin 
>everything is going fine, but with the user form not.
>
>I have put the code under this message, if anyone can help me, I hope to 
>hear from him or her by e-mail: [EMAIL PROTECTED]
>
>Thanks,
>Johan


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

2001-04-18 Thread Mani Murugesan


you need to login into MySQL with rights to create databases. Your being
root under linux has got nothing to do with root under mysql.

Mani. M


>and tried to create database with :
>mysql> create database cart;

>ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE
>'CART'





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

2001-04-18 Thread Ben Dimmock


"It does exactly what it says in the tin"

> ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE
'CART'

You'll have to get permission to create the database.

If you are the MySQL admin, lookup "grant" in order to give user "ABHI"
access. Something like:

grant all on cart.* to [EMAIL PROTECTED] identified by "somePassword"

If you are not, you will need to ask your ISP / DB admin to do this for you.

Hope this helps.

Ben

- Original Message -
From: "Anoop k gupta" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 11:08 AM
Subject: MySQL Problem


> Hi Everybody,
>
> I need your help.
> Thanks ..
>
> I was trying to create database on MySQL
> but it is giving error.
>
> I have done the following :-
>
> Login through telnet and become root.
> accessed :
>
> mysql -h server name -u username -p
> Password : password
>
> and tried to create database with :
> mysql> create database cart;
>
> ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE
'CART'
>
>
>
>
>
> _
> Chat with your friends as soon as they come online. Get Rediff Bol at
> http://bol.rediff.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: MySQL Problem

2001-04-18 Thread B. van Ouwerkerk



>I have done the following :-
>
>Login through telnet and become root.
>accessed :
>
>mysql -h server name -u username -p
>Password : password
>
>and tried to create database with :
>mysql> create database cart;
>
>ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE 'CART'

You say root.. would that be MySQL root user.. or the server root user..

You need to be mysql root user to create databases.. or at least you need 
the rights to create databases..

Bye,


B.


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

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

RE: MYSQL Problem

2001-04-17 Thread Grimes, Dean


Are you sure about that number? 1,000 queries per second is pretty high.
Assuming that 10k per second is correct, that translates to 36,000,000
queries per hour. That is quite a lot. BTW, what DB were you using before
and was its inability to handle your load a factor in your decision to
switch? Have you tried setting limitations on the number of concurrent
connections and such. Very possibly, your server is being completely
overwhelmed. Also, with that much activity, your database will soon grow
beyond your 10gb disk capacity.

If you could supply a little more information:

1. What web server and version are you using?
2. What threads library and version?
3. What OS and version?
4. What other applications might you have loaded on the system?
5. What version of MySQL are you using?
6. Which type of DB tables are you using? (MySQL supports a number of table
types).
7. Are you using binary distributions or did you compile from the source?
8. If compiled, which compiler and version did you use?
9. Are you using a server-side scripting language and if so what type and
version?

These basic questions need to get answered before moving forward.

Happy hunting

Dean



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 11:08 AM
To: [EMAIL PROTECTED]
Subject: MYSQL Problem


Hi Everybody,

We have a very popular greetings card site at http://gcards.com
We recently switched to MYSQL as our backend database..

But recently we noticed that MYSQL cannot handle high load under 
normal installation. In our system we get more than 10,000 
insert/update/delete/select queries per second sometime. And this 
creates the problem.

Under this circumstances MYSQL failed to respond or get hanged.
We have to restart MYSQL then.

We are on a dedicated server with 256 MB of RAM and 10 GB disk
space. 

We are trying to figure out the problem but if anybody could help 
on this that could be gr8. We've a good offer also for this. Whoever 
will solve this problem will get the source code of our card program
FREE. Only dedicated and sound developer/engineer are need to be 
contacted in the following email address

[EMAIL PROTECTED]


Best Wishes,

The Development Team
http://www.gcards.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: MYSQL Problem

2001-04-16 Thread Jan Bruvoll


Hi there,

> We have a very popular greetings card site at http://gcards.com We
> recently switched to MYSQL as our backend database..
>
> But recently we noticed that MYSQL cannot handle high load under
> normal installation. In our system we get more than 10,000
> insert/update/delete/select queries per second sometime. And this
> creates the problem.

If you actually were able to handle that kind of load before, on the same
hardware, what DB were you using? And why did you actually change?

> We are trying to figure out the problem but if anybody could help on
> this that could be gr8. We've a good offer also for this. Whoever will
> solve this problem will get the source code of our card program FREE.
> Only dedicated and sound developer/engineer are need to be contacted
> in the following email address

You might want to have a look into the manual about the threading and/or
file handle issues there are (this is assuming you're running things on
Linux.)

Regards,
Jan-Aage

--
Mr. Jan-Aage Bruvoll  Managing Director
Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK
Office/fax: +44 20 72408283  Mobile: +44 7740291600


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

2001-04-16 Thread Andrei Cojocaru


Okay just checking a few basic things, have you indexed your table properly? 
There is a manual section about performance, also make sure to play around 
with the mysql configuration file (global one in /etc/my.cnf)

>From: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: MYSQL Problem
>Date: Mon, 16 Apr 2001 21:37:47 +0530
>MIME-Version: 1.0
>Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id 
>MHotMailBCA465A9002A40043165C03AC5A20D8C0; Mon Apr 16 09:15:38 2001
>Received: (qmail 1297 invoked by uid 7797); 16 Apr 2001 16:05:38 -
>Received: (qmail 1280 invoked from network); 16 Apr 2001 16:05:31 -
>From mysql-return-71620-acojocaru Mon Apr 16 09:17:04 2001
>Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm 
>(http://www.ezmlm.org)
>List-ID: 
>Precedence: bulk
>List-Help: 
>List-Unsubscribe: 
>
>List-Post: 
>List-Subscribe: 
>Delivered-To: mailing list [EMAIL PROTECTED]
>Message-Id: <[EMAIL PROTECTED]>
>Priority: normal
>X-mailer: Pegasus Mail for Win32 (v3.11)
>
>Hi Everybody,
>
>We have a very popular greetings card site at http://gcards.com
>We recently switched to MYSQL as our backend database..
>
>But recently we noticed that MYSQL cannot handle high load under
>normal installation. In our system we get more than 10,000
>insert/update/delete/select queries per second sometime. And this
>creates the problem.
>
>Under this circumstances MYSQL failed to respond or get hanged.
>We have to restart MYSQL then.
>
>We are on a dedicated server with 256 MB of RAM and 10 GB disk
>space.
>
>We are trying to figure out the problem but if anybody could help
>on this that could be gr8. We've a good offer also for this. Whoever
>will solve this problem will get the source code of our card program
>FREE. Only dedicated and sound developer/engineer are need to be
>contacted in the following email address
>
>[EMAIL PROTECTED]
>
>
>Best Wishes,
>
>The Development Team
>http://www.gcards.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
>

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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 Problem

2001-04-16 Thread Huntress Gary B NPRI



If you are truly getting 10k queries per second, that would imply to me a roughly 
comparable number of webserver connections (maybe within a factor of 2).  If this is 
the case, I'd be amazed that it would work at all when hosted on a single box with 
"only" 256M of ram.  I believe your problem is with the overall architecture of your 
system, not mysql specifically.  I think that the first thing I would do is either add 
ram or move mysql to a dedicated server to try and distribute the load.

Then I would consult some apache (I'm assuming thats what your running) performance 
and tuning guides.

Also, I would examine the ratio of insert/updates to selects along with your use of 
indexing.  


Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 12:08 PM
To: [EMAIL PROTECTED]
Subject: MYSQL Problem


Hi Everybody,

We have a very popular greetings card site at http://gcards.com
We recently switched to MYSQL as our backend database..

But recently we noticed that MYSQL cannot handle high load under 
normal installation. In our system we get more than 10,000 
insert/update/delete/select queries per second sometime. And this 
creates the problem.

Under this circumstances MYSQL failed to respond or get hanged.
We have to restart MYSQL then.

We are on a dedicated server with 256 MB of RAM and 10 GB disk
space. 

We are trying to figure out the problem but if anybody could help 
on this that could be gr8. We've a good offer also for this. Whoever 
will solve this problem will get the source code of our card program
FREE. Only dedicated and sound developer/engineer are need to be 
contacted in the following email address

[EMAIL PROTECTED]


Best Wishes,

The Development Team
http://www.gcards.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

55 matches

Mail list logo