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
o back and read all the table locking stuff in the manual...
Do updates/inserts lock the table so that others can't read it? If so, is
there a way to make an update/insert fail if it just takes too long?
Hunter
> From: "Sander Pilon" <[EMAIL PROTECTED]>
> Date: Wed,
Here is the part of the processlist from when the server was full...
| Id | User | Host | db | Command | Time | State|
Info
|
+--+---+---+--+-+--+--+-
As I'm having a lot of problems with the source distro, I'm considering
moving to your RPMs.
The manual suggests that there are a lot of problems with Linux and threads,
etc... and to use the prebuilt binaries if you can...
I've been using a source distro for awhile. What do I have to do to inst
PROTECTED]>
> Date: Wed, 25 Apr 2001 15:13:24 -0400
> To: "Hunter Hillegas" <[EMAIL PROTECTED]>, "mySQL List"
> <[EMAIL PROTECTED]>
> Subject: Re: MySQL 3.23.36 STILL Having Major Problems
>
> Who are web users logging in as? Take away their pr
D]>
> Date: Wed, 25 Apr 2001 15:13:24 -0400
> To: "Hunter Hillegas" <[EMAIL PROTECTED]>, "mySQL List"
> <[EMAIL PROTECTED]>
> Subject: Re: MySQL 3.23.36 STILL Having Major Problems
>
> Who are web users logging in as? Take away their process_p
quot;Andrew Schmidt" <[EMAIL PROTECTED]>
> Date: Wed, 25 Apr 2001 14:46:48 -0400
> To: "Hunter Hillegas" <[EMAIL PROTECTED]>, "mySQL List"
> <[EMAIL PROTECTED]>
> Subject: Re: MySQL 3.23.36 STILL Having Major Problems
>
> taken from t
OS: Red Hat Linux 6.0 / Intel
1GB RAM
MySQL 3.23.36
PHP4.0.4PL1
Linux kernel 2.4.3
Using the my.cnf for medium sized sites
mySQL starts with safe_mysqld and there are three threads running. Queries
come in and out and it's quite fast. Using mysqladmin proc status shows no
queries running.
After
I am using 3.23.36 in conjunction with PHP 4.0.4pl1. When I compiled PHP, I
used --with-mysql and let it use it's own mySQL library, not compiling
against anything build under 3.23.36 (I tried the other way but the
configure failed, never finding mysqlclient libraries, even though they were
right
I have several mysqld processes that have 'D' status as shown by ps aux.
>From my limited understanding, that means they are waiting for disk and are
uninterruptible?
How do they get this way and what can I do to fix this?
Hunter
---
I have mySQL threads that are sleeping with LONG times from a PHP app. What
kind of PHP call could sleep that long w/o dying?
Hunter
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
Hello.
I wrote a few days ago when I was having trouble with too many connections
to my server.
Since then I upgraded to 3.23.36 to see if that would help...
Basically I have a PHP (4.0.4pl1) application that does both SELECTS and
INSERTS against mySQL and is very active. It's my understanding
I have a Web app that uses PHP4 to connect to a mySQL server (3.22.26) on
Red Hat 6.0 (Dual Pentium III).
The site is very popular and every once and a while PHP can't connect to
mySQL because of "Too Many Connections".
I log in to the server and I am unable to execute a mysqladmin shutdown
beca
I have a query question I can't figure out on my own. Any help is
appreciated...
I have three tables:
create table courses (
rec_num int(5) not null default '0' auto_increment,
name varchar(255),
description varchar(255),
class_time varchar(255),
professor_id int(5),
unit
14 matches
Mail list logo