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
>
> 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 Out-of-memory Process Killer. This needs
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 hangs every 30 minutes, it start to make a big proces
Well Roberto,
it could be anything... analyzing your my.cnf file and variables would
be looking through spagetti (i like spagetti ... but not in this flavour).
the time your database hangs, are the intervals random
minutes/seconds/hours? or is there a constant interval like precise on
30 min
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
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]
[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
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(id INT NOT NULL,
> PRIMARY KEY (
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
> table.
>
> How to Re
Never mind, I found the answer to my own question when I got the archive
search engine to respond. (It's *very* slow from here, for some reason --
about 10 minutes per query.) I installed a newer version of the glibc fix
and all is well now.
Sorry for wasting everyone's time.
> -Original Me
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
> 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
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
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?
Andrea Carpani wrote:
>Here's my problem:
>
>I've just installed mysql version 3.23.51 (before
Pada 23 Jul 2002 12:11:18 +0200
Andrea Carpani <[EMAIL PROTECTED]> menulis :
> "select * FROM $table1 s,$table2 t"
>
> where the two tables are choosen randomly (some of the tables are quite
> big), then repeats this with another (not cached) connection. The script
> runs on another machine. If
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
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 repeated problems
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. This is really frustrati
-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
Hi Patric,
I believe you will have many problems of this kind with older
versions of FreeBSD. You should update, if you can, to
FreeBSD-stable. See this URL for easy instructions on how to update
if you don't know how.
http://www.mostgraveconcern.com/freebsd/ and look at the CVSUP
info.
Th
32 matches
Mail list logo
