i've tried a flat insert without the () around the select, i just put them
there for easier readability to a coworker. i get the same result from the
query,
insert into summary
select sum(x) as x, .
from table
where condition = 'true'
group by whatever
error: FUNCTION: database_name.sum
Hi, I am having problems with result times. I run a search from my website
and it takes around 15 seconds to generate the mysql query and then 40
seconds to load the page!
Does anyone have any ideas on this because it is racking my brains!
The address is http://www.icoste.com
Thanks in
can u please let us know the mysql query that gets generated during your
search.
Also, get the explain plan of the sql.
regards
anandkl
On 4/18/07, icoste [EMAIL PROTECTED] wrote:
Hi, I am having problems with result times. I run a search from my website
and it takes around 15 seconds to
-Original Message-
From: John Comerford [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 17, 2007 10:50 PM
To: mysql@lists.mysql.com
Subject: Millisecond time stamp
Hi Folks,
I am putting together a table to hold log entries. I was going to index
it on a field with a type of
It all depends on how complicated your data and searches are. I've got tables that add 2-3 million per day and I don't have
performance problems. Although we only retain at most 500 millions records, not a full years worth.
That said, you can get horrible performance out of mysql with tables as
not the variable,
Its the sql statements which get fired at the database when you do the
search on you application.
May be you should check you app server for this sql statements.
regards
anandkl
On 4/18/07, Ananda Kumar [EMAIL PROTECTED] wrote:
can u please let us know the mysql query that
Brent Baisley wrote:
It all depends on how complicated your data and searches are. I've got
tables that add 2-3 million per day and I don't have performance
problems. Although we only retain at most 500 millions records, not a
full years worth.
That said, you can get horrible performance out
I am suddenly seeing this in my error log:
070418 08:43:57 mysqld started
070418 8:43:57 [ERROR] /usr/contrib/libexec/mysqld: Can't create/write to file
'/usr/contrib/var/doctor.nl2k.ab.ca.pid' (Errcode: 13)
070418 8:43:57 [ERROR] Can't start server: can't create PID file: Undefined
error: 0
The sheer number of tables and rows might be part of the problem with
displaying the page, although it's hard for me to say. At one point I put
some HTML comments inside a PHP loop, so they were generated for every line
item on a page, and was astonished at how long it took to load and render.
As
On 4/17/07, John Comerford [EMAIL PROTECTED] wrote:
Hi Folks,
A) One character string contain a string I build with the date and
milliseconds tagged onto the end
b) Two separate fields Field1 TimeStamp Field2 Milliseconds
I am leaning towards approach B, but saying that it's more gut
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
I am suddenly seeing this in my error log:
070418 08:43:57 mysqld started
070418 8:43:57 [ERROR] /usr/contrib/libexec/mysqld: Can't create/write to file
'/usr/contrib/var/doctor.nl2k.ab.ca.pid' (Errcode: 13)
On 4/18/07, Tim Lucia [EMAIL PROTECTED] wrote:
-Original Message-
From: John Comerford [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 17, 2007 10:50 PM
To: mysql@lists.mysql.com
Subject: Millisecond time stamp
Hi Folks,
I am putting together a table to hold log entries. I was going
i am using 5.0.22
but i found the problem. i'm an idiot. there was a space in one of my sum(x)
entries; sum (x), when i removed that, it worked fine.
thanks.
On 4/18/07, Tanner Postert [EMAIL PROTECTED] wrote:
5.0.22, does anyone know a workaround?
On 4/18/07, Michael Dykman [EMAIL
On Wed, Apr 18, 2007 at 12:42:56PM -0500, Gerald L. Clark wrote:
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
I am suddenly seeing this in my error log:
070418 08:43:57 mysqld started
070418 8:43:57 [ERROR] /usr/contrib/libexec/mysqld: Can't
I would like to be able to use variables for user and table names in grant
statements executed in a stroed procedure. It looks like grant statements are
not compatible with prepare. Does any one know a good way to do this.
Thanks
-
Ahhh...imagining
Thanks for the replies guys, banging my head against the wall for not
thinking of using an auto increment integer to handle the sequence, I've
got to cut back on those Friday night beers
On 4/17/07, John Comerford [EMAIL PROTECTED] wrote:
Hi Folks,
A) One character string contain a
John Comerford wrote:
Thanks for the replies guys, banging my head against the wall for not
thinking of using an auto increment integer to handle the sequence,
I've got to cut back on those Friday night beers
Okay, color me confused, but what exactly are you wanting to do anyway?
Hi, Baisley
How did you config your DB? Did you specify one single file or several
files to store your DB? I am not sure whether it affects the performance
as well.
And Could you give more details about your merge tables. Your experience
is greatly useful for us, thanks a lot.
-Original
I am writing a type of message stack that is built while a task is
processing and presented to the user at the end of processing. I do it
using a function like
Logit(Blah, blah, blah);
Which records the SessionID, Sequence and Message, which is presented to
the user in sequence at the end
Hi, Pipes
Is it reliable to use MySQL 5.1 in a commercial product now since it is
still a beta version?
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 18, 2007 10:04 PM
To: Brent Baisley
Cc: He, Ming Xin PSE NKG; mysql@lists.mysql.com
Subject: Re:
20 matches
Mail list logo