Re: mysql problem
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
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(undefined symbol to)
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
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: ? phpinfo() ? 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
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
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: ? phpinfo() ? 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...
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
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
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
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
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 http://iConnect.de 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
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
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...maybe...?
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
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 Query
Also, see what errors you are getting in mysql hostname.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 Installing on RH 7.3
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
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
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
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
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
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
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
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 (Will not write to but will read)
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 Installing on RH 7.3
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 Installing on RH 7.3
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
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
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
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
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
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 in Slackware 8.0
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 in Slackware 8.0
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 with Traffic and Updates
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
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
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 with Traffic and Updates
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
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
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 -- Please help
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 -- Please help
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
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
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
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
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
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
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
Re: MYSQL Problem
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: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Message-Id: [EMAIL PROTECTED] 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
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
