, not a summary of hits per IP, so I
don't think GROUP BY is what I need(?). I've run across a couple of sites that
seem to say that an INNER JOIN would give me what I want. If that's true, then
that's above my head.
BTW, this on MySQL 5.5.34-cll-lve
Thank you,
Jenni
Superior Shelving
of hits per IP, so I
don't think GROUP BY is what I need(?). I've run across a couple of sites that seem to
say that an INNER JOIN would give me what I want. If that's true, then that's above my
head.
BTW, this on MySQL 5.5.34-cll-lve
Thank you,
Jenni
Superior Shelving Systems
On Feb 17, 2014, at 10:17 AM, Roy Lyseng wrote:
please try filtering with a subquery that locates ip addresses with more than
1 attempt:
Hi Roy,
That did it! Thank you so much!!! Now I just need to study that IN
clause to see what's going on there.
If this is too slow, you may
Hi Jennifer,
great that it worked.
Try replacing the line
`ip` IN (temp_ip)
with
`ip` IN (SELECT ip FROM temp_ip)
Each subquery needs to be a complete SELECT query.
Thanks,
Roy
On 17.02.14 21:11, Jennifer wrote:
On Feb 17, 2014, at 10:17 AM, Roy Lyseng wrote:
please try filtering
Hi Jennifer,
On 2/17/2014 3:11 PM, Jennifer wrote:
CREATE TEMPORARY TABLE temp_ip AS
(SELECT `ip`
FROM `ip_addresses`
WHERE (`time_stamp` BETWEEN date_add( CURDATE(), INTERVAL -1 DAY ) AND
CURDATE() - INTERVAL 1 SECOND)
AND TRIM(`referrer`) LIKE ''
GROUP BY `ip`
HAVING
On Feb 17, 2014, at 12:36 PM, Roy Lyseng wrote:
Try... `ip` IN (SELECT ip FROM temp_ip)
Wow! Only 1 second to return the results now!! That's 15x faster!!!
Each subquery needs to be a complete SELECT query.
That's good to know. I figured that since temp_ip referenced a
Hello,
I have the following SQL statement that I'd like to add to. It's used
to create a report that's emailed to me showing hits to our site that didn't
provide a referrer. However, I only want to report on multiple hits from the
same IP address - not just a single hit by someone
On Wed, Feb 12, 2014 at 7:35 PM, Jennifer jenni...@superiorshelving.com wrote:
Hello,
I have the following SQL statement that I'd like to add to. It's
used to create a report that's emailed to me showing hits to our site that
didn't provide a referrer. However, I only want
Hello, I have been asked to replay the traffic load we have on one of our
5.1.4X servers against a new 5.5 test server we are getting ready to put into
production as a stand alone. My question is that I have 6GB of mysqld.log BUT
how to I figure out how MUCH to play back at a given time and
-Original Message-
From: Nunzio Daveri [mailto:nunziodav...@yahoo.com]
Sent: Friday, August 27, 2010 10:19 AM
To: mysql@lists.mysql.com
Subject: How To Duplicate Number of Hits from Prod Sever to NEW QA server?
Hello, I have been asked to replay the traffic load we have on one of our
Make sure you check you ulimit on file - I have hit that on AIX more than
once.
On Mon, Feb 9, 2009 at 2:42 PM, JD King jeff_d_k...@hotmail.com wrote:
I am running MySQL 5.1.30 on AIX 5.3. When a table reaches 1GB the table
gets marked as corrupt. Is there a setting that limits table size to
I am running MySQL 5.1.30 on AIX 5.3. When a table reaches 1GB the table
gets marked as corrupt. Is there a setting that limits table size to 1GB?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
JD,
Not have. pls input Error infomation from you r erro file. And ls
check your HDD space.
yours,
fire9
在 2009-2-10,上午4:42, JD King 写道:
I am running MySQL 5.1.30 on AIX 5.3. When a table reaches 1GB the
table
gets marked as corrupt. Is there a setting that limits table size to
1GB?
I wonder why with tre different MySQL administrator istances I have 3
different QueryCache Hitrate on the same database, in the same time :(
I'm trying with:
- MySQL administrator v.1.2.12 (Ubuntu 8.10): the query hitcache is
always at 100% (average 100)
- MySQL administrator v.1.2.5rc
how do I get the average number of hits per day
I have a table like:
DateTimeid ip
20050506190723 1 121.198.262
what I have so far
SELECT DateTime , count( * )
FROM userLog
GROUP BY DateTime
LIMIT 0 , 30
I assume that DateTime would have to be converted to a specific
how about this:
select substr(datetime,0,8) AS date, count(datetime) from userLog group by
date;
I could not clearly understand what you wanted to average upon.
HTH,
Anoop
On 5/6/05, Graham Anderson [EMAIL PROTECTED] wrote:
how do I get the average number of hits per day
I have
what you wanted to average upon.
HTH,
Anoop
On 5/6/05, Graham Anderson [EMAIL PROTECTED] wrote:
how do I get the average number of hits per day
I have a table like:
DateTime id ip
20050506190723 1 121.198.262
what I have so far
SELECT DateTime , count( * )
FROM
On Wednesday 23 March 2005 20:00, Chip Wiegand wrote:
count=count+1; --- This is the added bit ---
?
---
The count doesn't increment in the database. The table has a column called
'count'.
Two things: variables start with a $ and
I have an existing database/tables and would like to add a counter to a
table that would increment when a document is downloaded from the
database. I am sure it is an easy addition to the php page but struck-out
looking for info not related to auto-increment in the mysql manual. I
tried adding
Hi!
In MySQL 4.0, query cache hits are counted in Qcache_hits, but not in
Com_select. The documentation for Com_select implies that they should be
there. Is this the intended behavior, or is it a bug?
- JD
It is intended behaviour.
Com_select is incremented each time SELECT query
On Saturday 08 March 2003 23:38, John David Duncan wrote:
In MySQL 4.0, query cache hits are counted in Qcache_hits, but not in
Com_select. The documentation for Com_select implies that they should be
there. Is this the intended behavior, or is it a bug?
No, it's not a bug, but a known
In MySQL 4.0, query cache hits are counted in Qcache_hits, but not in
Com_select. The documentation for Com_select implies that they should be
there. Is this the intended behavior, or is it a bug?
- JD
-
Before posting
hi list,
Does anyone has experient in analyzing MySQL traffic? Is there any
method/tool to know how frequent a particular table is accessed / which
table is heavily used / which is the table that causing speed bottle neck
and et cetera.
Thanks.
Chee Peng
Hey Guys,
I'm working on a script that displays reviews by a category for my site and
I want the pull-down menu to be ordered by the amount of hits each category
or review
has, is it possible to sort by the amount of hits for a row value?
My table is structured as follows:
Name, Url, Author, E
UPDATE tbl SET Number = Number + 1 WHERE blah;
Alex Behrens wrote:
Hey Guys,
I'm working on a script that displays reviews by a category for my site and
I want the pull-down menu to be ordered by the amount of hits each category
or review
has, is it possible to sort by the amount
PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 4:17 PM
Subject: Re: hits
UPDATE tbl SET Number = Number + 1 WHERE blah;
Alex Behrens wrote:
Hey Guys,
I'm working on a script that displays reviews by a category for my site
and
I want the pull-down menu to be ordered
-unlimited.com
Send News:
[EMAIL PROTECTED]
- Original Message -
From: Mike [EMAIL PROTECTED]
To: Alex Behrens [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 4:37 PM
Subject: Re: hits
I don't think mysql has a feature like that. Check the manual at
www.mysql.com.
I think you
I don't think mysql has a feature like that. Check the manual at
www.mysql.com.
I think you will need to make another table to count the hits per category.
Then do a join between the two tables to get the results you want.
Mike
- Original Message -
From: Alex Behrens [EMAIL PROTECTED
28 matches
Mail list logo