W3 Total Cacheがアクセスカウントを増やしていたの巻

スポンサーリンク
mysql> use wordpress_db;
mysql> select agentID from wp_Counterize where timestamp like "2011-11-12%" limit 20;
+---------+
| agentID |
+---------+
|    1925 |
|       8 |
|    1627 |
|    6233 |
|    6233 |
|    6233 |
|    6233 |
|    6233 |
|    6233 |
|    6233 |
|    6233 |
|    6233 |
|    6233 |
|    5225 |
|    5225 |
|    6233 |
|    6233 |
|    6233 |
|    6233 |
|    6233 |
+---------+
mysql> select * from wp_Counterize_UserAgents where agentID = 6233;
+---------+------------------------+-------+-------------+-------------+----------------+------------+---------+---------+-----------+-------+
| agentID | name                   | count | browserName | browserCode | browserVersion | browserURL | osName  | osCode  | osVersion | osURL |
+---------+------------------------+-------+-------------+-------------+----------------+------------+---------+---------+-----------+-------+
|    6233 | W3 Total Cache/0.9.2.4 |   940 | Unknown     | unknown     |                |            | Unknown | unknown |           |       |
+---------+------------------------+-------+-------------+-------------+----------------+------------+---------+---------+-----------+-------+
1 row in set (0.00 sec)

mysql> select count(1) from wp_Counterize where agentID = "6233";
+----------+
| count(1) |
+----------+
|      940 |
+----------+
1 row in set (0.04 sec)

mysql>
mysql> select count(1) from wp_Counterize where agentID = "6233" and timestamp like "2011-11-12%";
+----------+
| count(1) |
+----------+
|      890 |
+----------+
1 row in set (0.00 sec)

mysql>
mysql> select count(1) from wp_Counterize where agentID = "6233";
+----------+
| count(1) |
+----------+
|      940 |
+----------+
1 row in set (0.04 sec)

mysql>
mysql> delete from wp_Counterize where agentID = "6233";
Query OK, 940 rows affected (0.23 sec)

mysql> FLUSHPRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

以上

コメント

タイトルとURLをコピーしました