I also tried with long_query_time = 5
but got the same error :(
On 7/12/07, thomas Armstrong <[EMAIL PROTECTED]> wrote:
Hi.
Using mySQL 3.23.58, I'm trying to log slow queries and I made:
log-slow-queries = /usr/local/mysql/log/slow-queries.log
long-query-time = 5
(into my '/e
Hi.
Using mySQL 3.23.58, I'm trying to log slow queries and I made:
log-slow-queries = /usr/local/mysql/log/slow-queries.log
long-query-time = 5
(into my '/etc/my.conf' file)
However, I get this error message:
unrecognized option `--long-query-time=5'
Is this parameter
Kwang Chin Lee wrote:
> Hello,
>
> I have several tables storing item information, keyword (mainly for
> searching), category and subcategory (also for searching). The query I am
> using now is:
>
> SELECT i.*, it.*, ic.*, c.*, cs.*, s.*, st.* FROM item i
> LEFT JOIN iteminfo it ON i.id = it
Hello,
I have several tables storing item information, keyword (mainly for searching),
category and subcategory (also for searching). The query I am using now is:
SELECT i.*, it.*, ic.*, c.*, cs.*, s.*, st.* FROM item i
LEFT JOIN iteminfo it ON i.id = it.id
LEFT JOIN itemkeyword ik ON i.id = ik
Hello,
I have several tables storing item information, keyword (mainly for searching),
category and subcategory (also for searching). The query I am using now is:
SELECT i.*, it.*, ic.*, c.*, cs.*, s.*, st.* FROM item i
LEFT JOIN iteminfo it ON i.id = it.id
LEFT JOIN itemkeyword ik ON i.id =
Ed,
That's not really what I meant. I know what the function SUM() does. But Sum() takes an _expression_ and '1' doesn't seem like much of an _expression_ to me. So what is that 1 equates to and where in the MySQL documentation can I find this explained.
The _expression_ here is '1', whi
Ed Reed wrote:
That's not really what I meant. I know what the function SUM() does. But Sum()
takes an expression and '1' doesn't seem like much of an expression to me. So
what is that 1 equates to and where in the MySQL documentation can I find this
explained.
Thanks again.
It doesn't car
That's not really what I meant. I know what the function SUM() does. But Sum()
takes an expression and '1' doesn't seem like much of an expression to me. So
what is that 1 equates to and where in the MySQL documentation can I find this
explained.
Thanks again.
>>> Peter Brawley <[EMAIL PROTEC
Hi Ed,
Count(1) works just as well. Sum(1) just adds 1 for each row so it's
logically equivalent.
PB
-
Ed Reed wrote:
WOW!!! THAT WAS AWESOME!!!
Thanks a lot Peter. Ok, so what is SUM(1)? How is it able to do this? And where can I learn more about it?
Thanks again.
WOW!!! THAT WAS AWESOME!!!
Thanks a lot Peter. Ok, so what is SUM(1)? How is it able to do this? And where
can I learn more about it?
Thanks again.
>>> Peter Brawley <[EMAIL PROTECTED]> 4/4/06 10:13:00 PM >>>
Ed,e: Thanks for the quick reply Peter. Unfortunately, this is all legacy stuff
th
You must be able to run it as a single call, or as a single TRANSACTION?
What do you mean by "single call"? One PHP command? One command on
the commandline? one script run?
-Sheeri
On 4/4/06, Ed Reed <[EMAIL PROTECTED]> wrote:
> Thanks for the quick reply Peter. Unfortunately, this is all leg
Ed,e:
Thanks for the quick reply Peter. Unfortunately, this is all legacy stuff that I have to make work together and the problemreport table does not reference the employeeid in the employees table. It was all create about ten years ago and the data has just always been migrated to the db d
Thanks for the quick reply Peter. Unfortunately, this is all legacy stuff that
I have to make work together and the problemreport table does not reference the
employeeid in the employees table. It was all create about ten years ago and
the data has just always been migrated to the db du jour. I'
Ed,
>Can someone help me simplify this query please? It's meant
>to return a single string result that looks something like this,
>"You have 12 open Problem Reports: Priorities(High=5, Med=6, Low=1)"
The big slowdown in your query is likely the join on
ProblemReports.Responsible = CONCAT
Sorry, here's the results. BTW the query works it just seems overly complex and
I'd like to streamline it.
CREATE TABLE `employees` (
`EmployeeID` int(11) NOT NULL auto_increment,
`FirstName` varchar(50) default NULL,
`LastName` varchar(50) default NULL,
`DateTerminated` datetime default
"Ed Reed" <[EMAIL PROTECTED]> wrote on 04/04/2006 04:34:29 PM:
> Can someone help me simplify this query please? It's meant to return
> a single string result that looks something like this,
>
> "You have 12 open Problem Reports: Priorities(High=5, Med=6, Low=1)"
>
> The relavent columns from th
Can someone help me simplify this query please? It's meant to return a single
string result that looks something like this,
"You have 12 open Problem Reports: Priorities(High=5, Med=6, Low=1)"
The relavent columns from the two tables are
Table: ProblemReports
Fields: PRNo, Status, Priority,
an index on any appropriate data (date, sum) should also help tremendously.
Thomas
"Danny Melton" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi all,
>
> I am curious to know if the query times I'm seeing are reasonable or not.
> Here's my situation:
> I am using a database to
At 09:43 AM 12/18/2003, you wrote:
Hi all,
I am curious to know if the query times I'm seeing are reasonable or not.
Here's my situation:
I am using a database to keep up with web statistics. The table is
currently growing at about 2 million records a day. The sample table I am
working with has
Hi all,
I am curious to know if the query times I'm seeing are reasonable or not.
Here's my situation:
I am using a database to keep up with web statistics. The table is
currently growing at about 2 million records a day. The sample table I am
working with has right at 4 million rows.
When I exe
From: Robert Citek [mailto:[EMAIL PROTECTED]
> How does one stop or abort a query?
>
> I was doing some experimenting with MySQL and created a table with
> 100,000 records. I then did a join like so:
>create table foo select foo.name, foo.val from foo, foo x,
> foo y, foo
> z ;
>
> This
Hello all,
How does one stop or abort a query?
I was doing some experimenting with MySQL and created a table with
100,000 records. I then did a join like so:
create table foo select foo.name, foo.val from foo, foo x, foo y, foo
z ;
This took a long time. So, I aborted with Ctrl-C (^C) whic
serably at
optimizing my query? (The two hour long query took 10s with
Straight_join).
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: ht
uld make a better choice?
Charles Vos wrote:
Thanks to everyone for their help, I actually managed to fix the problem by bypassing MySQL's optimization using STRAIGHT_JOIN. Out of curiosity can anyone tell me why MySQL failed so miserably at optimizing my query? (The two hour long quer
Thanks to everyone for their help, I actually managed to fix the problem by bypassing
MySQL's optimization using STRAIGHT_JOIN. Out of curiosity can anyone tell me why
MySQL failed so miserably at optimizing my query? (The two hour long query took 10s
with Straight_join).
mysql>
]
Sent: Friday, June 27, 2003 3:35 AM
To: [EMAIL PROTECTED]
Subject: very long query time
hi all,
i have a table in my mysql database with around 66 million rows in it.
when i query this table, it takes anywhere from 3 minutes to 10 minutes
to return the
Part of the problem may be the size of the returned set. If you are
having MySQL return the date on 11K rows, your bottleneck may be the
network or disk. Remeber, MySQL has to read all that data from the
database and transfer to your program or display it for the command
line. Even if you had a
On Friday, June 27, 2003, at 05:34 AM, Maurice Coyle wrote:
i have a table in my mysql database with around 66 million rows in
it. when i query this table, it takes anywhere from 3 minutes to 10
minutes to return the results. i've tried this both from within the
mysql command line and from j
Hi Maurice,
I would be interested to see how your SQL reuqest looks like. Perhaps it is
possible to optimize at this point, just a guess so.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 27日 金曜日 18:34、Maurice Coyle さんは書きました:
> hi all,
> i have a table in my mysql database with around 66 mil
select * from TableName LIMIT NumberOfRows
George Christoforakis
- Original Message -
From: Maurice Coyle
To: [EMAIL PROTECTED]
Sent: Friday, June 27, 2003 12:34 PM
Subject: very long query time
hi all,
i have a table in my mysql database with around 66
hi all,
i have a table in my mysql database with around 66 million rows in it. when i query this table, it takes anywhere from 3 minutes to 10 minutes to return the results. i've tried this both from within the mysql command line and from java programs.
Section 1.2.4 in the manual says th
-> ;
+---+---+
| user | host |
+---+---+
| everserve | localhost |
| root | localhost |
+---+---+
2 rows in set (0.00 sec)
mysql>
-Original Message-
From: geeta varu [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 9:05 PM
To: [EMAIL PROTECTED]
Subject
if there is a long query i want to continue it
in next like
eg>
Select canID from table1 where(text like '%a%' or text
lik
e '%b%') AND canID not in ( text like '%c%' or canID
like '%d%')
here i want to u
We have the following problem: on the server (quite fast) we have the
Mysqld-nt daemon running ; and the data resides in it. When a user
access the server with a very long query and another try to do the
same , but with a very simple query ; the last one has to wait a very
long time because of the
In my experience, you rarely want to fully normalize your data (unless it's
something simple). City and country codes I wouldn't split up because they
never change. Well, alright, there have been quite a few new "countries"
popup in Europe recently. But you don't need to change hundreds or thousan
>
To: <[EMAIL PROTECTED]>
Cc: "andy" <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 4:01 PM
Subject: RE: Join takes way too long. Query optimizing, or denormalizing?
> * andy
>
> > > > SELECT count(DISTINCT user_recommending)
> > > > FRO
* andy
> > > SELECT count(DISTINCT user_recommending)
> > > FROM recommendations t
> > > INNER JOIN geo.cities AS c ON t.city_id = c.ID AND
> > > c.country_code = 'gm'
> I guess this is not an issue on the index. Explain select says it is using
> the index. So I assume, that I did just write dow
I guess this is not an issue on the index. Explain select says it is using
the index. So I assume, that I did just write down the join syntax wrong.
MySQL is joining all 32000 records with the city table and then looks for
the country code. So this looks ok to me. Maybe I should denormalize my dat
day, 8 February 2002 1:30 a.m.
> To: 'MySQL list (E-mail)'
> Subject: RE: long query on php
>
>
> Have you tried just putting the querys into a variable and pass the var
> along to mysql_query() ? Did it not work?
>
> ---
> Alain Fontaine
Yesterday, from savaidis:
> The obious question is: (before I test it)
> This is concatenation to $query that is a string type, no?
Yea. The following works either:
mysql_query("create bla".
"bla".
"bla
bla blabla
".
"bla"
."bla"
);
> So the limit isn't
char(2) default "24" # doublequotes work
> hugo char(2) default '24' # singlequotes work either
> bla char(2) default '$bladefault' # inline vars work
> ...
> )
> eoq
>
> --
> > How is possible to pass a long query to MySQL server w
nd before the closing quotations) if you plan on continuing the query on
the next line, or else your SQL will be invalid.
Good luck,
Brett
Original Message Follows
From: "savaidis" <[EMAIL PROTECTED]>
To: "MySQL list \(E-mail\)" <[EMAIL PROTECTED]>
I can't read your structures or query from here.
[EMAIL PROTECTED] wrote:
>hi,
>
>i'm running a big query across a table containing more than 137 million rows
>comparing them to another one with about 4000 rows and i'm wondering how long it will
>still take...
>
>is there a way to see how many
l those lines are actually
just one line.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Brett Burgess [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 11:25 AM
To: [EMAIL PROTECTED]
Subject: Re: long query on php
He
It shouldn't be a problem as long as the syntax is right...
Gurhan
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:14 PM
To: MySQL list (E-mail)
Subject: long query on php
How is possible to pass a long query to MySQL server wit
hi,
i'm running a big query across a table containing more than 137 million rows comparing
them to another one with about 4000 rows and i'm wondering how long it will still
take...
is there a way to see how many operations have been made and how many are left?
as you can see it already took
MAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 8:14 PM
To: MySQL list (E-mail)
Subject: long query on php
How is possible to pass a long query to MySQL server with php?
I mean i.e a "create table" statement with more than 400 chars.
Have I to use shorter "create" and the
How is possible to pass a long query to MySQL server with php?
I mean i.e a "create table" statement with more than 400 chars.
Have I to use shorter "create" and then "alter"?
Thanks
Makis
Surprisingly it is mote than 64 KB! (I count strlen=74KB)
Bravo!!
Makis
> -Original Message-
> From: savaidis [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 9:08 AM
> To: [EMAIL PROTECTED]; 'Nathan'
> Cc: 'MySQL'
> Subject: RE: long
fs,
> .
> welcome to line 400";
Another way: (without test)
$bladefault=24;
$query = << How is possible to pass a long query to MySQL server with php?
> I mean i.e a "create table" statement with more than 400 chars.
> Have I to use shorter "create&qu
c has this high limit, no?
Makis
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 3:03 AM
> To: Nathan
> Cc: MySQL
> Subject: Re: long query on php
>
>
> Hi.
>
> I prefer doing like this
> $query
CTED]>, <[EMAIL PROTECTED]>
Subject: RE: long query on php
Date: Thu, 7 Feb 2002 22:29:47 +0200
The obious question is: (before I test it)
This is concatenation to $query that is a string type, no?
So the limit isn't also set to 255 chars too?
Or is a trick especially for this case?
, it's all
on the same line.
# Nathan
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 10:36 AM
Subject: RE: long query on php
Or you could do it like this:
$query="some query "
Surprisingly it is mote than 64 KB! (I count strlen=74KB)
Bravo!!
Makis
> -Original Message-
> From: savaidis [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 9:08 AM
> To: [EMAIL PROTECTED]; 'Nathan'
> Cc: 'MySQL'
> Subject: RE: long
c has this high limit, no?
Makis
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 3:03 AM
> To: Nathan
> Cc: MySQL
> Subject: Re: long query on php
>
>
> Hi.
>
> I prefer doing like this
> $query
fs,
> .
> welcome to line 400";
Another way: (without test)
$bladefault=24;
$query = << How is possible to pass a long query to MySQL server with php?
> I mean i.e a "create table" statement with more than 400 chars.
> Have I to use shorter "create&qu
Yesterday, from savaidis:
> The obious question is: (before I test it)
> This is concatenation to $query that is a string type, no?
Yea. The following works either:
mysql_query("create bla".
"bla".
"bla
bla blabla
".
"bla"
."bla"
);
> So the limit isn't
char(2) default "24" # doublequotes work
> hugo char(2) default '24' # singlequotes work either
> bla char(2) default '$bladefault' # inline vars work
> ...
> )
> eoq
>
> --
> > How is possible to pass a long query to MySQL server w
CTED]>, <[EMAIL PROTECTED]>
Subject: RE: long query on php
Date: Thu, 7 Feb 2002 22:29:47 +0200
The obious question is: (before I test it)
This is concatenation to $query that is a string type, no?
So the limit isn't also set to 255 chars too?
Or is a trick especially for this case?
Sent: Thursday, February 07, 2002 7:36 PM
> To: [EMAIL PROTECTED]
> Subject: RE: long query on php
>
>
>
> Or you could do it like this:
>
> $query="some query "
> ."some more of this query "
> ."still some more query "
>
M
> To: 'MySQL list (E-mail)'
> Subject: RE: long query on php
>
>
> Have you tried just putting the querys into a variable and
> pass the var
> along to mysql_query() ? Did it not work?
>
> ---
> Alain F
, it's all
on the same line.
# Nathan
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 10:36 AM
Subject: RE: long query on php
Or you could do it like this:
$query="some query "
l those lines are actually
just one line.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Brett Burgess [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 11:25 AM
To: [EMAIL PROTECTED]
Subject: Re: long query on php
He
I can't read your structures or query from here.
[EMAIL PROTECTED] wrote:
>hi,
>
>i'm running a big query across a table containing more than 137 million rows
>comparing them to another one with about 4000 rows and i'm wondering how long it will
>still take...
>
>is there a way to see how many
nd before the closing quotations) if you plan on continuing the query on
the next line, or else your SQL will be invalid.
Good luck,
Brett
Original Message Follows
From: "savaidis" <[EMAIL PROTECTED]>
To: "MySQL list \(E-mail\)" <[EMAIL PROTECTED]>
MAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 8:14 PM
To: MySQL list (E-mail)
Subject: long query on php
How is possible to pass a long query to MySQL server with php?
I mean i.e a "create table" statement with more than 400 chars.
Have I to use shorter "create" and the
How is possible to pass a long query to MySQL server with php?
I mean i.e a "create table" statement with more than 400 chars.
Have I to use shorter "create" and then "alter"?
Thanks
Makis
hi,
i'm running a big query across a table containing more than 137 million rows comparing
them to another one with about 4000 rows and i'm wondering how long it will still
take...
is there a way to see how many operations have been made and how many are left?
as you can see it already took
On Fri, Jul 27, 2001 at 02:52:08AM -0500, ryc wrote:
>
> The question is, when do you know when to give up, and when to keep
> on trucking?
If it's still running now, I'd give up. :-)
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-
To sum it all up, I am trying to import data from text files into an
innobase table (about 12m rows of data that is stored in text files created
by doing a select into outfile). First I tried dropping the indexes before
doing load data infile, but I found that I didnt have enough table space to
re
Hi,
I have trivial a question: how long can a MySQL query be?
Robert
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this th
Is a more complex single query going to run faster on a server than
several smaller queries where the results are set to variables and then
used as criteria in tertiary queries.
Bryan
-
Before posting, please check:
http://
72 matches
Mail list logo