Steve Strong wrote:
we are using php to connect to our mysql database and when we call the
php function with this line:
$dbh = mysql_connect("localhost", "george_full", "passwd") or die
(formatSQLError(""));
george_full has full priveleges on localhost with his password.
localhost resolves to
here is the entire function:
function readonlyConnect()
{
$dbh=mysql_connect ("localhost", "george_readonly", "tiWhs!asAt!") or
die (formatSQLError(""));
mysql_select_db ("george_crwash2");
return $dbh;
}
a die() statment before the first line of code in this function ech
On 7/18/06, Steve Strong <[EMAIL PROTECTED]> wrote:
we are using php to connect to our mysql database and when we call the
php function with this line:
$dbh = mysql_connect("localhost", "george_full", "passwd") or die
(formatSQLError(""));
That's the only line of your .php script?
george_f
we are using php to connect to our mysql database and when we call the
php function with this line:
$dbh = mysql_connect("localhost", "george_full", "passwd") or die
(formatSQLError(""));
george_full has full priveleges on localhost with his password.
localhost resolves to 127.0.0.1 using the ho
>
> Roberto Rodriguez Garrido wrote:
>
> > MySQL hangs every 30 minutes, it start to make a big process and when I
> make a
>
> > show variables I get that values:
I don't use Linux myself but I read a post on the Postgres list a while back
about the Linux Ou
Hello.
What system load do 'top' and 'free' show? Use 'SHOW PROCESSLIST' to
determine what queries are running on the server if you're able to
connect to it. Check that mysqld isn't swapping.
Roberto Rodriguez Garrido wrote:
> MySQL han
do wrote:
MySQL hangs every 30 minutes, it start to make a big process and when I make a
show variables I get that values:
+-+-+
| Variable_name
MySQL hangs every 30 minutes, it start to make a big process and when I make a
show variables I get that values:
+-+-+
| Variable_name | Value
On 12/3/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
>
> Hello.
>
>
>
> Check if you're able to start server manually using mysqld
>
> or mysqld_safe commands. Research error logs. See:
>
> http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
>
>
>
>
>
Thanks. Running mysqld directly show
Hello.
Check if you're able to start server manually using mysqld
or mysqld_safe commands. Research error logs. See:
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
Timothy Wu <[EMAIL PROTECTED]> wrote:
>Hi,
>
>I'm on Debian system. I tried to modify /etc/mysql/debian-log
Hi,
I'm on Debian system. I tried to modify /etc/mysql/debian-log-rotate to set
KEEP-BINARY-LOGS from 0 to 5. After doing so I attempted to let the change
register by stopping and restarting the server by running /etc/init.d/mysql
stop. However this command hanged. I rebooted the system and but t
Velu Shk wrote:
Related: http://lists.mysql.com/mysql/44164
No solutions mentioned here.
Slack 10.1 is booting and once the newly installed MySQL Standard
4.1.14 starts up with:
"Starting mysqld daemon with databases from /usr/local/mysql/data"
The system hangs and is dead to the world. I wi
Related: http://lists.mysql.com/mysql/44164
No solutions mentioned here.
Slack 10.1 is booting and once the newly installed MySQL Standard 4.1.14
starts up with:
"Starting mysqld daemon with databases from /usr/local/mysql/data"
The system hangs and is dead to the world. I will need some time
Hello.
In your file you have lots of threads in Closing_tables
state and only seven queries which make updates. Means
that the thread is flushing the changed table data to disk
and closing the used tables. This should be a fast operation.
If not, then you should verify that you don't have
Marcin Lewandowski wrote:
Hi,
I've got webserver with php and mysql-4.0.22
There I've got large phpbb2.
That's it. phpbb2 is known to consume ressources, if I were you i
wouldn't search further... not a mysql issue afaik
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For l
Hi,
I've got webserver with php and mysql-4.0.22
There I've got large phpbb2. Sometimes, server's system load rapidly
grows, and mysql are locked. Normally, there are 7-10 mysql processes,
at this strange situation, there are 30-40.
I don't know what can make such big system load in time of 1 mi
Hi,
I've got webserver with php and mysql-4.0.22
There I've got large phpbb2. Sometimes, server's system load rapidly
grows, and mysql are locked. Normally, there are 7-10 mysql processes,
at this strange situation, there are 30-40.
I don't know what can make such big system load in time of 1 mi
Ajay Kalambur wrote:
Hi
We have been having problems with a MySql database that runs on Linux.It
just occurred suddenly and was working fine before
Details:
MySql Version:# mysql Ver 14.7 Distrib 4.1.6-gamma
The filesystems which are accessed by MySql just hang.We cannot access any
of the tables.
Are you data files on a local filesystem? When this issue occurs can you
access any regular files on the drive?
Ajay Kalambur wrote:
Hi
We have been having problems with a MySql database that runs on Linux.It
just occurred suddenly and was working fine before
Details:
MySql Version:# mysql Ver 1
Ajay,
Could you send the error messages (.err file in the mysql dir)
and your my.cnf file?
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi
We have been having problems with a MySql database that runs on Linux.It
just occurred suddenly and was working fine before
Details:
MySql Version:# mysql Ver 14.7 Distrib 4.1.6-gamma
The filesystems which are accessed by MySql just hang.We cannot access any
of the tables.All clients just hang.
[EMAIL PROTECTED] wrote:
Hello,
since I moved to another dedicated server 1-2 months ago I'm
experiencing big problems with mysql.
Normally the server works fine for a website under heavy load but
after a week or so it hangs in a locked table forever and thus
preventig other processes to access it
Hello,
since I moved to another dedicated server 1-2 months ago I'm
experiencing big problems with mysql.
Normally the server works fine for a website under heavy load but
after a week or so it hangs in a locked table forever and thus
preventig other processes to access it. Then I have to shut do
Scott Wong writes:
>
> Version: Mysql 4.0.10-gamma
>
> Description: Mysql hangs and possibly can not recover from a query on an innodb
> table.
>
> How to Repeat :
>
> drop table if exists parent;
> drop table if exists child;
>
> CREATE TABLE parent(
Scott Wong writes:
>
> Hi, I havent received any response on this so i'll send this again.
> I did check again with 4.0.11-gamma and the problem is still there.
>
>
> Regards,
> Scott
>
Hi!
This will require a major re-write in multi table update's and will
not come up very soon. But should co
Hi, I havent received any response on this so i'll send this again.
I did check again with 4.0.11-gamma and the problem is still there.
Regards,
Scott
> Version: Mysql 4.0.10-gamma
>
> Description: Mysql hangs and possibly can not recover from a query on an innodb
> tab
Version: Mysql 4.0.10-gamma
Description: Mysql hangs and possibly can not recover from a query on an innodb
table.
How to Repeat :
drop table if exists parent;
drop table if exists child;
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT
-Original Message-
> From: David Brodbeck [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 27, 2002 9:09 AM
> To: '[EMAIL PROTECTED]'
> Subject: MySQL hangs on remote connections
>
>
> I'm having a rather bizarre problem...at least, it seems
>
I'm having a rather bizarre problem...at least, it seems bizarre to me.
We have a small MySQL database that was running great for about a month.
Last night, I rebooted the system it runs on. Now I can connect locally,
but remote connections fail. The server disconnects during the query and I
get
Thank you, Egor! It looks like Red Hat released an update to its glibc
libraries yesterday which fix this, so if anybody else is having
problems, they should be able to fix it by updating. :)
Sage
On Thu, 2002-11-07 at 17:46, Egor Egorov wrote:
> Sage,
> Wednesday, November 06, 2002, 3:31:21 PM,
Sage,
Wednesday, November 06, 2002, 3:31:21 PM, you wrote:
S> I'm running MySQL 3.23.49 on Red Hat 7.3, with the latest kernel
S> (2.4.18-17.7.x) installed. It is running in smp mode on a dual P3 1.0
S> gHz.
S> MySQL works perfectly fine when connecting from the localhost. However,
S> I have anot
I'm running MySQL 3.23.49 on Red Hat 7.3, with the latest kernel
(2.4.18-17.7.x) installed. It is running in smp mode on a dual P3 1.0
gHz.
MySQL works perfectly fine when connecting from the localhost. However,
I have another machine that needs to connect via ODBC. The ODBC client
can connect, bu
> Hardware?
> Operating System and version?
> MySql version?
> Precompiled, you compiled?
> Which compiler?
Intel Dual 1Ghz, 1Gb RAM, RedHat Linux 6.2, kernel 2.4.16, MySQL 3.23.52
from rpms (happened the same with 3.23.46). As I said before, this only
happens the last few days, we were runnin
Hardware?
Operating System and version?
MySql version?
Precompiled, you compiled?
Which compiler?
[EMAIL PROTECTED] wrote:
> Hi. These last days, after some months of running relatively smoothly,
>I've been having some trouble with MySQL. Sometimes (yesterday 4 times) it
>just goes astray an
Hi. These last days, after some months of running relatively smoothly,
I've been having some trouble with MySQL. Sometimes (yesterday 4 times) it
just goes astray and virtually hangs. Load goes up to +200%, all
connections are occupied and it just doesn't do anything. The only way to
stop it is
After a hard day of work I think I managed to isolate the problem which
looks a lot like a bug:
server: mysql-3.23.51
compiled with: CFLAGS="-fomit-frame-pointer -O3 -fPIC" ./configure
--prefix=/opt/mysql --disable-shared --with-mysqld-user=mysql
--with-debug
os: HP-UX 11.00
I have a small j
Pada 23 Jul 2002 15:40:17 +0200
Andrea Carpani <[EMAIL PROTECTED]> menulis :
> error: 'Can't create a new thread (errno 11). If you are not out of
> available memory, you can consult the manual for a possible OS-dependent
> bug'
well, if this the case
try to run : mysqladmin -p processlist
On Tue, 2002-07-23 at 12:28, Dicky Wahyu Purnomo wrote:
> I think the proper word for your case is "mysql busy" not "hang".
> you should check from your system (OS) side the cpu usage of mysql
> where the query is running
When the problem arises both cpu's (client and server) are 2% busy and
th
On Tue, 2002-07-23 at 15:27, Gerald Clark wrote:
> 20 simultaneous cartesian products on large tables would be expected to make
> any sql server busy, not to mention use a lot of temporary disk space.
> Are you sure you are not running out of disk space?
No, there's enough disk space and memory
tion. The script
>runs on another machine. If I leave the script running it hangs mysql db
>in , say, 20 minutes. If I launch simultaneously 20 such scripts 3
>minutes are enough.
>
>By "mysql hangs" I mean that there's no way to connect to get a
>"processlist&qu
gt; runs on another machine. If I leave the script running it hangs mysql db
> in , say, 20 minutes. If I launch simultaneously 20 such scripts 3
> minutes are enough.
>
> By "mysql hangs" I mean that there's no way to connect to get a
> "processlist" or a &q
connection. The script
runs on another machine. If I leave the script running it hangs mysql db
in , say, 20 minutes. If I launch simultaneously 20 such scripts 3
minutes are enough.
By "mysql hangs" I mean that there's no way to connect to get a
"processlist" or a "de
Hi again,
Little more information about the problem that I wrote about in my last
email.
As I said before, the database wont accept any query to that table. It just
hangs. However I'm not sure of which query that is executed the first time
the table hangs. I'm not sure if this matters. But i
Hi all,
I have a problem with a table in the database. I created it a while ago (a
month maby) and then everything worked fine. Now however, every time I query
the table the query hangs and I don't know why. I understand that it's
difficult to tell me what the problem is based on that little i
Hi,
I have this table:
CREATE TABLE FOR_SALE (
ISBN VARCHAR(10) NOT NULL,
STOREID MEDIUMINT(8) UNSIGNED NOT NULL,
MYDATE DATE NOT NULL,
PRICE SMALLINT UNSIGNED NOT NULL,
PRIMARY KEY (ISBN, STOREID, MYDATE)
);
When I execute this query:
SELECT count(*) FROM FOR_SALE
nothing hap
David Birnbaum writes:
> >Description:
> mysqld still seems to hang when nightly table checks are running.
> Formerly, this seemed to be due to a race condition that was
> hopefully fixed in 3.23.46. Server is up, but all queries are stuck
> in "opening tables". mysqld
>Description:
mysqld still seems to hang when nightly table checks are running.
Formerly, this seemed to be due to a race condition that was
hopefully fixed in 3.23.46. Server is up, but all queries are stuck
in "opening tables". mysqld is taking 100% of one CP
Hi,
I recently installed in MySql from binary distribution mysql-
max-3.23.38-pc-linux-gnu-i686.tar.gz. The install worked fine, the
database runs and performs fine but it refuses to shutdown short of a
'kill -9'. This is not so good:( I have tried 'mysqladmin shutdown' and
killing the safe_my
Hi,
I recently installed in MySql from binary distribution mysql-
max-3.23.38-pc-linux-gnu-i686.tar.gz. The install worked fine, the
database runs and performs fine but it refuses to shutdown short of a
'kill -9'. This is not so good:( I have tried 'mysqladmin shutdown' and
killing the safe_my
Hi,
I recently installed in MySql from binary distribution mysql-
max-3.23.38-pc-linux-gnu-i686.tar.gz. The install worked fine, the
database runs and performs fine but it refuses to shutdown short of a
'kill -9'. This is not so good:( I have tried 'mysqladmin shutdown' and
killing the safe_my
Upgrade to 2.4.4. 2.4.3 had some rwsem issues.
--
Vibol Hou
KhmerConnection
http://khmer.cc
-Original Message-
From: Hunter Hillegas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 2:20 PM
To: mySQL List
Subject: mySQL Hangs with Status 'D'
I have been having repeate
I have been having repeated problems with mySQL 3.23.36 on Linux (Red Hat
6.0, 2.4.3 kernel).
I think I've got traced the problem but I don't know how to fix it...
At some point after being started one or more of the mySQL threads hang with
the ps status of 'D' (my research suggests this can mea
Check permissions.
The var directory anad all subdirectories and files must
be accessible by the user under which MySQL runs.
The directory containing the mysql.lock file must be readable and
searchable by everyone.
Drew Degentesh wrote:
>
> >Description:
> mysql hangs. Th
-Hello
- If you are running FreeBSD 4.0 why not install mysql using
/usr/ports/database/mysql-server.3.xxx
make install
make clean
On Tue, 13 Feb 2001, pdewaha wrote:
> Hi,
> I've mysql 3.23.32 running on FreeBSD 4.0.
> It runs a site with heavy traffic and heavy
> database
>Description:
mysql hangs. This is really frustrating. History:
-had 3.23.27 running. Had to restart the machine.
-on reboot, no clients would connect (command line , Perl or PHP)
-tried to restart by rc.d/initd/mysql stop, that timed out
-killed off processes with kill -9
-tried to rest
February 12, 2001 11:21 AM
Subject: !!! Mysql hangs after some days on FreeBSD 4.0I
> Hi,
> I've mysql 3.23.32 running on FreeBSD 4.0.
> It runs a site with heavy traffic and heavy
> database interaction.
>
> After starting mysql it hangs after some days.
>
> Mysql serv
Hi,
I've mysql 3.23.32 running on FreeBSD 4.0.
It runs a site with heavy traffic and heavy
database interaction.
After starting mysql it hangs after some days.
Mysql server is still in the processlist, but
it is not possible to connect to the sql
57 matches
Mail list logo
