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
co
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 COUNT(
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 wit
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
there are 52 records, but still only returns one row. So I added GROUP BY `ip`
and that gave me 7 rows with counts that added up to 35. Closer, but each row
was a group of IP addresses where there was more than one hit.
I want each hit to be returned, not a "summary" of hits
han one hit.
I want each hit to be returned, 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
On Wed, Feb 12, 2014 at 7:35 PM, Jennifer 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 o
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 s
>-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
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 h
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 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 1GB?
>
>
>
> --
> MySQL
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 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:http://lists.mysql.com/mysql?unsub=arch...@jab.or
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 (De
;
> 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 a table like:
&
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 pe
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
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
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 ti
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
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
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" &l
p://www.3d-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
ROTECTED]>
To: "Alex Behrens" <[EMAIL 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,
> >
> >
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
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, Auth
28 matches
Mail list logo
