i'm just wondering: what hangs first: your scripts or the mysql database?
if (one of your) scripts is in a endless loop, for one reason or the other, the
symptons will be the same...
I would try to figure out if there's one particulair query that hangs, or if it
happens randomly.
For cgi i
just realised it:
another thing might be the linux threading problems. when spawning multiple threads at
once, the 2.2 kernel will delay the new threads more and more.
Upgrading to kernel 2.4 solves this.
read the lists' archives on this, there were several discussions on this subject.
Hi,
I am trying to set up Mysql on the following system (its only a test bed for home
useage, for a small scale internet based
project) Ideally, this system will be a MySQL, Apache, PHP setup. Low powered I know,
but I am assured possible and
OK for my purposes
Proc: 486 DX2 66
Mem: 40MB
i have 400 rows in my mysql database table
and i wont get each N row from table (say each sixth row)???
please help me???
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
supposed you numbered all rows in the table incrementally in field nid:
select mydata from mytable where mod(nid, N)=offset;
fill in N and offset (0..n-1)
On Sat, 28 Apr 2001 14:26:46 +0400
Igor V Yermakov [EMAIL PROTECTED] wrote:
i have 400 rows in my mysql database table
and i wont get
Eric K. Dickinson writes:
All seemed to be going well untill...
sr/local/include/mysql -c get_table.cc
g++ -O3 -g -pipe -fforce-mem -fforce-addr -I.
-I../mysql++-1.7.8/sqlplusint -I/usr/local/include/mysql -c admin.cc
g++ -O3 -g -pipe -fforce-mem -fforce-addr -I.
Darren Henderson writes:
This note is primarily meant to stuff something into the archives in case
other people have problems compiling mysql under AIX.
There are a number of changes that need to be made that aren't detailed in
the documentation, (some alteration to those docs could save
Roger Ramirez writes:
Why do I get the following results?
mysql select (1008306000-988344000)/86400/7,
mod((1008306000-988344000)/86400,7.);
++--
+
| (1008306000-988344000)/86400/7 |
I've been creating a site for someone using MySQL and PHP4.
Basically the table concerned is structured like this;
id int(5) UNSIGNED Noauto_increment Primary
ship varchar(50) NoIndex
year varchar(15) NoIndex
voyage varchar(50) Yes
sex varchar(50)Yes
Mysql : 3.23.33
server : NT 4.0 S.P.3
Client : Win98
This is the table structure:
CREATE TABLE `ordinit` (
`ID_Ordine` int(11) NOT NULL auto_increment,
`Cod_Cliente` int(11) default NULL,
.. OMISSIS ..
PRIMARY KEY (`ID_Ordine`)
) TYPE=MyISAM
the query 'select last_insert_id()' after an
Description:
The following output occures when using ASH as /bin/sh.
Your script seems to rely on non-POSIX features from bash
and therefore should be called with #!/bin/bash. This works.
-=(~/debian/mysql/ODBC/myodbc2.50.37-2.50.37)$ ./configure
Hi!
Difficult to say if InnoDB is alpha or beta.
You can look at the bugs and fixes diary at my website www.innobase.fi,
and form your own opinion. I am committed to fix all bugs you report,
and to this day a fix has been available for any bug within 10 days.
I have got bug reports from about
Howdy,
I posted this question over on the plusplus list, but so far I've not
received a response. This list seems more active, so perhaps someone here
can offer me a hand.
I'm trying to get the 1.7.8 distribution of MySQL++ to build as directed
in the README -- using automake. When I run
Howdy,
I posted this question over on the plusplus list, but so
far I've not received a response. This list seems more
active, so perhaps someone here can offer me a hand.
I'm trying to get the 1.7.8 distribution of MySQL++ to
build as directed in the README -- using automake.
I've been creating a site for someone using MySQL and PHP4.
Basically the table concerned is structured like this;
id int(5) UNSIGNED Noauto_increment Primary
ship varchar(50) NoIndex
year varchar(15) NoIndex
Sir, change the type of this column to Date, which
Actually, there is a way to do this by taking advantage of variables. If
you read my previous post on the matter, you can use variables to get a
cumulative total.
- Original Message -
From: Steve Ruby [EMAIL PROTECTED]
To: Roger Karnouk [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent:
isn't this the expected behavior?
(1008306000-988344000)/86400 = 231.04
select mod(231.04,7);
0
231.04 mod 7 is .04, rounded down to 0. 7*33=231
the mod function rounds the result - that's expected, right? Other than that
I don't see what the problem is.
braxton
-Original Message-
Well, cool. If that works I'm happy. I was trying to go by the README and
use automake. Thanks!
It'd sure be nice if somebody fixed the docs, or at least put a note on the
web site that said they're broken. That probably cost me at least a day of
confusion. :-(
Howdy,
I posted this
On Fri, Apr 27, 2001 at 04:08:20PM -0700, Patrick Calkins wrote:
How stable is InnoDB, BDB, MyISAM, etc?? I am developing a
production system using MySQL, and wanted to know that stability
status on these table types. I wanted to use transactions if I
could - is the transaction-enabled
On Sat, Apr 07, 2001 at 10:42:09AM -0600, Sasha Pachev wrote:
I have now installed the new spam filter on this list. It is very
simple - instead of having bad words, we now have good words. You
must mention one of the following: sql, database, query in the body
of your message to get past
I purchase web space on www.phpwebhosting.com, which offers PHP and
mySQL services in a shared server environment. Each user gets their own
database, in which they can create their own tables. Today, someone is
using a LOT of resources: mysqld is pegged at 96% CPU utilisation, and
I'm getting
How can I tell which user on the system is responsible for the lag?
Ideally there would be a command like 'top' that would show which
databases are being accessed most frequently, or taking the most time to
access.
-
I have a situation where a query should be using an index, running
the query from the mysql terminal using the explain ... command
indicates it will use the index, but the actual execution speed tells me
the index is not being used: Execution is very slow.
I have tried dropping and
23 matches
Mail list logo