#author("2017-06-08T07:56:13+09:00","","")
#author("2017-06-09T01:09:59+09:00","","")
** [[WebTrack/102]] [#fc81b10a]
|~サマリ|リセットされたアクセスカウンタの補正|
|~お名前|[[umorigu]]|
|~優先度|低|
|~状態|完了|
|~カテゴリー|PukiWiki公式サイト 不具合|
|~投稿日|2017-05-24 (水) 02:33:44|
|~担当者|[[umorigu]]|

** メッセージ [#y448ef99]
アクセスカウンタが時々リセットされてしまう。[[dev:BugTrack/2422]]

過去の履歴を参照し、リセットされる前の値を復元する。


----
- これ以上アクセスカウンタがリセットされないよう、[[dev:BugTrack/2422]]で実装された、内部的にデータベースを利用したカウンタに切り替えました。しばらく様子を見ます -- [[umorigu]] &new{2017-05-29 (月) 02:37:52};
- アクセスカウンタを、OSDN.netでプロジェクトDB ( osdn.net/docs-ja/MySQL_Howto ) として提供されいてるMySQL利用に切り替えました -- [[umorigu]] &new{2017-06-02 (金) 01:46:03};
- WebArchive(web.archive.org)からPukiWikiサイトの過去スナップショットを取得し、カウンタの履歴を調査しました。詳細は、添付の調査結果ファイル(&ref(pw_site_counter_history.tsv.zip); &ref(pw_site_counter_history.ods);) で確認できます。 -- [[umorigu]] &new{2017-06-08 (木) 07:44:31};
- WebArchiveによる履歴は数カ月単位で間が空いているため、正確な値とは言えません。ですが、アーカイブの各スナップショットが正しいとすると、カウンタ消失分の下限値としては妥当です。調査結果から算出した、消失分のカウンタ値(official: 7,929,688, dev: 1,008,711)を現在のアクセスカウンタの値に加えることでカウンタの補正を行います。 -- [[umorigu]] &new{2017-06-08 (木) 07:45:00};
- アクセスカウンタの補正を実行しました -- [[umorigu]] &new{2017-06-08 (木) 07:49:56};
 SELECT page_name, total FROM official_page_counter WHERE page_name = 'FrontPage';
 UPDATE official_page_counter SET total = total+ 7929688 WHERE page_name = 'FrontPage';
 SELECT page_name, total FROM official_page_counter WHERE page_name = 'FrontPage';
 
 SELECT page_name, total FROM dev_page_counter WHERE page_name = 'FrontPage';
 UPDATE dev_page_counter SET total = total+ 1008711 WHERE page_name = 'FrontPage';
 SELECT page_name, total FROM dev_page_counter WHERE page_name = 'FrontPage';
- 本WebTrackは完了とします -- [[umorigu]] &new{2017-06-08 (木) 07:56:13};

#comment


----

** アクセスカウンタ履歴 [#yd501006]

Web Archive (web.archive.org) のデータを利用して、PukiWiki-officialおよびPukiWiki-devの過去のアクセスカウンタの値を調べました。

dateが進んだときに"total"の値が減少しているところが、アクセスカウンタがリセットされたことを表しています。特にofficialはリセットが頻繁に起きていたことがわかります。

PukiWiki-official, PukiWiki-dev それぞれトップページのみの調査です。サブページも含めるときりがないのでトップページのみを対象にしました。

各アーカイブのURLやその他の日付の値などの詳細は、調査結果ファイル(&ref(pw_site_counter_history.tsv.zip); &ref(pw_site_counter_history.ods);) で確認できます。

*** PukiWiki-dev [#h521ff39]

対象:
- pukiwiki.sourceforge.jp/dev/
- pukiwiki.osdn.jp/dev/

|	date	|	"total"の値	|	"today"の値	|	"yesterday"の値	|h
|	2003-02-07	|RIGHT:	1418	|RIGHT:	31	|RIGHT:	65	|
|	2006-02-08	|RIGHT:	391235	|RIGHT:	136	|RIGHT:	255	|
|	2006-04-11	|RIGHT:	559	|RIGHT:	219	|RIGHT:	236	|
|	2011-11-14	|RIGHT:	461340	|RIGHT:	75	|RIGHT:	0	|
|	2011-12-03	|RIGHT:	1750	|RIGHT:	52	|RIGHT:	0	|
|	2013-06-01	|RIGHT:	68073	|RIGHT:	63	|RIGHT:	0	|
|	2013-07-28	|RIGHT:	247	|RIGHT:	65	|RIGHT:	0	|
|	2017-01-12	|RIGHT:	88063	|RIGHT:	6	|RIGHT:	95	|
|	2017-04-29	|RIGHT:	608	|RIGHT:	5	|RIGHT:	68	|
|	2017-06-03	|RIGHT:	3274	|RIGHT:	19	|RIGHT:	74	|

"total"消失分: 1,008,711

*** PukiWiki-official [#idd25047]

対象:
- pukiwiki.org/
- pukiwiki.sourceforge.jp/
- pukiwiki.osdn.jp/

|	date	|	"total"の値	|	"today"の値	|	"yesterday"の値	|h
|	2003-01-30	|RIGHT:	30798	|RIGHT:	739	|RIGHT:	512	|
|	2003-05-25	|RIGHT:	135513	|RIGHT:	1072	|RIGHT:	410	|
|	2003-06-18	|RIGHT:	17715	|RIGHT:	59	|RIGHT:	1299	|
|	2004-08-19	|RIGHT:	751139	|RIGHT:	726	|RIGHT:	2924	|
|	2004-08-27	|RIGHT:	3138	|RIGHT:	702	|RIGHT:	2396	|
|	2005-07-25	|RIGHT:	1006260	|RIGHT:	519	|RIGHT:	2286	|
|	2005-10-13	|RIGHT:	55847	|RIGHT:	1134	|RIGHT:	2019	|
|	2005-10-30	|RIGHT:	86257	|RIGHT:	565	|RIGHT:	1215	|
|	2005-11-02	|RIGHT:	1416	|RIGHT:	1025	|RIGHT:	391	|
|	2005-11-07	|RIGHT:	10235	|RIGHT:	496	|RIGHT:	1560	|
|	2005-11-23	|RIGHT:	868	|RIGHT:	236	|RIGHT:	632	|
|	2005-11-24	|RIGHT:	1641	|RIGHT:	276	|RIGHT:	1365	|
|	2005-11-25	|RIGHT:	766	|RIGHT:	252	|RIGHT:	514	|
|	2005-11-30	|RIGHT:	7652	|RIGHT:	435	|RIGHT:	2027	|
|	2005-12-01	|RIGHT:	1647	|RIGHT:	469	|RIGHT:	1178	|
|	2006-01-18	|RIGHT:	82961	|RIGHT:	1301	|RIGHT:	2378	|
|	2006-01-26	|RIGHT:	1026	|RIGHT:	261	|RIGHT:	765	|
|	2006-02-16	|RIGHT:	40182	|RIGHT:	609	|RIGHT:	2124	|
|	2006-04-11	|RIGHT:	12794	|RIGHT:	1930	|RIGHT:	2218	|
|	2006-04-17	|RIGHT:	31026	|RIGHT:	121	|RIGHT:	3167	|
|	2006-04-23	|RIGHT:	4428	|RIGHT:	1017	|RIGHT:	1706	|
|	2006-06-15	|RIGHT:	31881	|RIGHT:	222	|RIGHT:	2364	|
|	2006-06-29	|RIGHT:	12280	|RIGHT:	1137	|RIGHT:	2592	|
|	2006-07-11	|RIGHT:	40020	|RIGHT:	151	|RIGHT:	2427	|
|	2006-07-16	|RIGHT:	3200	|RIGHT:	664	|RIGHT:	1392	|
|	2006-07-21	|RIGHT:	14117	|RIGHT:	1945	|RIGHT:	2337	|
|	2006-08-09	|RIGHT:	9790	|RIGHT:	285	|RIGHT:	2296	|
|	2006-09-14	|RIGHT:	79680	|RIGHT:	612	|RIGHT:	2158	|
|	2006-11-08	|RIGHT:	2816	|RIGHT:	213	|RIGHT:	2603	|
|	2006-11-08	|RIGHT:	2818	|RIGHT:	215	|RIGHT:	2603	|
|	2006-11-15	|RIGHT:	2353	|RIGHT:	1070	|RIGHT:	1283	|
|	2006-11-29	|RIGHT:	32003	|RIGHT:	1612	|RIGHT:	2429	|
|	2006-12-05	|RIGHT:	8950	|RIGHT:	335	|RIGHT:	2338	|
|	2006-12-19	|RIGHT:	36916	|RIGHT:	568	|RIGHT:	2411	|
|	2006-12-23	|RIGHT:	5203	|RIGHT:	852	|RIGHT:	2591	|
|	2007-01-09	|RIGHT:	34106	|RIGHT:	797	|RIGHT:	1833	|
|	2007-01-10	|RIGHT:	5170	|RIGHT:	405	|RIGHT:	3281	|
|	2007-01-25	|RIGHT:	42721	|RIGHT:	267	|RIGHT:	2711	|
|	2007-01-28	|RIGHT:	732	|RIGHT:	732	|RIGHT:	0	|
|	2007-02-02	|RIGHT:	12738	|RIGHT:	1094	|RIGHT:	2704	|
|	2007-02-05	|RIGHT:	644	|RIGHT:	306	|RIGHT:	338	|
|	2007-02-08	|RIGHT:	246	|RIGHT:	246	|RIGHT:	0	|
|	2007-04-05	|RIGHT:	128745	|RIGHT:	325	|RIGHT:	2809	|
|	2007-04-23	|RIGHT:	3397	|RIGHT:	347	|RIGHT:	2652	|
|	2007-05-26	|RIGHT:	78298	|RIGHT:	1525	|RIGHT:	2664	|
|	2007-06-10	|RIGHT:	12861	|RIGHT:	472	|RIGHT:	1707	|
|	2007-06-10	|RIGHT:	13209	|RIGHT:	820	|RIGHT:	1707	|
|	2007-06-15	|RIGHT:	3389	|RIGHT:	558	|RIGHT:	2831	|
|	2007-08-10	|RIGHT:	138492	|RIGHT:	1594	|RIGHT:	1	|
|	2007-09-02	|RIGHT:	41580	|RIGHT:	896	|RIGHT:	1895	|
|	2007-11-12	|RIGHT:	201817	|RIGHT:	962	|RIGHT:	1791	|
|	2007-11-15	|RIGHT:	1948	|RIGHT:	547	|RIGHT:	1401	|
|	2008-03-22	|RIGHT:	284810	|RIGHT:	1021	|RIGHT:	0	|
|	2008-03-28	|RIGHT:	10441	|RIGHT:	2140	|RIGHT:	0	|
|	2008-03-30	|RIGHT:	13520	|RIGHT:	685	|RIGHT:	0	|
|	2008-04-05	|RIGHT:	8539	|RIGHT:	382	|RIGHT:	0	|
|	2008-04-14	|RIGHT:	33632	|RIGHT:	606	|RIGHT:	0	|
|	2008-04-30	|RIGHT:	23959	|RIGHT:	2376	|RIGHT:	0	|
|	2008-04-30	|RIGHT:	24643	|RIGHT:	538	|RIGHT:	0	|
|	2008-05-10	|RIGHT:	873	|RIGHT:	812	|RIGHT:	0	|
|	2008-06-14	|RIGHT:	86462	|RIGHT:	1811	|RIGHT:	0	|
|	2008-06-25	|RIGHT:	5731	|RIGHT:	720	|RIGHT:	0	|
|	2008-09-06	|RIGHT:	163502	|RIGHT:	509	|RIGHT:	0	|
|	2008-09-07	|RIGHT:	1448	|RIGHT:	441	|RIGHT:	0	|
|	2008-11-08	|RIGHT:	133912	|RIGHT:	1270	|RIGHT:	0	|
|	2008-12-08	|RIGHT:	3660	|RIGHT:	194	|RIGHT:	0	|
|	2009-04-30	|RIGHT:	289569	|RIGHT:	632	|RIGHT:	0	|
|	2009-05-12	|RIGHT:	8012	|RIGHT:	971	|RIGHT:	0	|
|	2009-05-29	|RIGHT:	43362	|RIGHT:	1377	|RIGHT:	0	|
|	2009-12-18	|RIGHT:	34750	|RIGHT:	1562	|RIGHT:	0	|
|	2010-01-04	|RIGHT:	18531	|RIGHT:	1534	|RIGHT:	0	|
|	2010-01-16	|RIGHT:	23076	|RIGHT:	1226	|RIGHT:	0	|
|	2010-01-22	|RIGHT:	4588	|RIGHT:	1886	|RIGHT:	0	|
|	2010-02-09	|RIGHT:	42653	|RIGHT:	655	|RIGHT:	0	|
|	2010-03-01	|RIGHT:	14053	|RIGHT:	1554	|RIGHT:	0	|
|	2010-03-13	|RIGHT:	42321	|RIGHT:	1009	|RIGHT:	0	|
|	2010-03-23	|RIGHT:	20750	|RIGHT:	55	|RIGHT:	0	|
|	2010-04-29	|RIGHT:	100145	|RIGHT:	1570	|RIGHT:	0	|
|	2010-05-08	|RIGHT:	9296	|RIGHT:	928	|RIGHT:	0	|
|	2010-06-07	|RIGHT:	80540	|RIGHT:	1930	|RIGHT:	0	|
|	2010-06-14	|RIGHT:	8649	|RIGHT:	1253	|RIGHT:	0	|
|	2010-09-12	|RIGHT:	183256	|RIGHT:	870	|RIGHT:	0	|
|	2010-09-24	|RIGHT:	14544	|RIGHT:	53	|RIGHT:	0	|
|	2010-10-23	|RIGHT:	79217	|RIGHT:	599	|RIGHT:	0	|
|	2010-11-10	|RIGHT:	18451	|RIGHT:	1644	|RIGHT:	0	|
|	2011-02-04	|RIGHT:	207469	|RIGHT:	2152	|RIGHT:	0	|
|	2011-02-13	|RIGHT:	13727	|RIGHT:	529	|RIGHT:	0	|
|	2011-02-22	|RIGHT:	42365	|RIGHT:	1863	|RIGHT:	0	|
|	2011-03-02	|RIGHT:	8594	|RIGHT:	1241	|RIGHT:	0	|
|	2011-03-13	|RIGHT:	37307	|RIGHT:	2099	|RIGHT:	0	|
|	2011-03-20	|RIGHT:	9513	|RIGHT:	2054	|RIGHT:	0	|
|	2011-04-01	|RIGHT:	47645	|RIGHT:	285	|RIGHT:	0	|
|	2011-04-14	|RIGHT:	29706	|RIGHT:	2301	|RIGHT:	0	|
|	2011-04-24	|RIGHT:	64674	|RIGHT:	543	|RIGHT:	0	|
|	2011-04-29	|RIGHT:	7204	|RIGHT:	2514	|RIGHT:	0	|
|	2011-05-29	|RIGHT:	97122	|RIGHT:	2089	|RIGHT:	0	|
|	2011-06-01	|RIGHT:	4266	|RIGHT:	2605	|RIGHT:	0	|
|	2011-06-22	|RIGHT:	56695	|RIGHT:	311	|RIGHT:	0	|
|	2011-07-03	|RIGHT:	20151	|RIGHT:	3005	|RIGHT:	0	|
|	2011-07-09	|RIGHT:	40829	|RIGHT:	120	|RIGHT:	0	|
|	2011-07-13	|RIGHT:	463	|RIGHT:	463	|RIGHT:	0	|
|	2011-07-27	|RIGHT:	26399	|RIGHT:	812	|RIGHT:	0	|
|	2011-08-09	|RIGHT:	12789	|RIGHT:	1714	|RIGHT:	0	|
|	2011-08-28	|RIGHT:	77734	|RIGHT:	1783	|RIGHT:	0	|
|	2011-09-01	|RIGHT:	9757	|RIGHT:	1114	|RIGHT:	0	|
|	2011-09-13	|RIGHT:	19651	|RIGHT:	1159	|RIGHT:	0	|
|	2011-09-24	|RIGHT:	9644	|RIGHT:	964	|RIGHT:	0	|
|	2011-10-28	|RIGHT:	94062	|RIGHT:	496	|RIGHT:	0	|
|	2011-11-11	|RIGHT:	17571	|RIGHT:	761	|RIGHT:	0	|
|	2011-11-24	|RIGHT:	39793	|RIGHT:	768	|RIGHT:	0	|
|	2011-12-11	|RIGHT:	2944	|RIGHT:	206	|RIGHT:	0	|
|	2012-01-11	|RIGHT:	29122	|RIGHT:	495	|RIGHT:	0	|
|	2012-01-12	|RIGHT:	615	|RIGHT:	615	|RIGHT:	0	|
|	2012-01-14	|RIGHT:	4955	|RIGHT:	2493	|RIGHT:	0	|
|	2012-01-15	|RIGHT:	1380	|RIGHT:	1380	|RIGHT:	0	|
|	2012-01-22	|RIGHT:	14598	|RIGHT:	440	|RIGHT:	0	|
|	2012-02-01	|RIGHT:	7545	|RIGHT:	72	|RIGHT:	0	|
|	2012-03-08	|RIGHT:	42531	|RIGHT:	309	|RIGHT:	0	|
|	2012-03-22	|RIGHT:	22505	|RIGHT:	232	|RIGHT:	0	|
|	2012-04-07	|RIGHT:	50555	|RIGHT:	81	|RIGHT:	0	|
|	2012-04-13	|RIGHT:	7807	|RIGHT:	17	|RIGHT:	0	|
|	2012-04-20	|RIGHT:	18834	|RIGHT:	1242	|RIGHT:	0	|
|	2012-04-30	|RIGHT:	14827	|RIGHT:	1279	|RIGHT:	0	|
|	2012-05-12	|RIGHT:	33439	|RIGHT:	842	|RIGHT:	0	|
|	2012-05-26	|RIGHT:	5370	|RIGHT:	665	|RIGHT:	0	|
|	2012-07-17	|RIGHT:	65748	|RIGHT:	722	|RIGHT:	0	|
|	2012-08-15	|RIGHT:	40605	|RIGHT:	912	|RIGHT:	0	|
|	2012-09-20	|RIGHT:	91009	|RIGHT:	509	|RIGHT:	0	|
|	2012-11-03	|RIGHT:	28846	|RIGHT:	127	|RIGHT:	0	|
|	2012-11-03	|RIGHT:	28917	|RIGHT:	198	|RIGHT:	0	|
|	2012-11-21	|RIGHT:	8932	|RIGHT:	1428	|RIGHT:	0	|
|	2012-12-27	|RIGHT:	57324	|RIGHT:	1123	|RIGHT:	0	|
|	2013-01-14	|RIGHT:	12955	|RIGHT:	809	|RIGHT:	0	|
|	2013-02-15	|RIGHT:	31554	|RIGHT:	253	|RIGHT:	0	|
|	2013-03-30	|RIGHT:	17160	|RIGHT:	715	|RIGHT:	0	|
|	2013-03-30	|RIGHT:	17692	|RIGHT:	1247	|RIGHT:	0	|
|	2013-04-03	|RIGHT:	1902	|RIGHT:	1464	|RIGHT:	0	|
|	2013-05-01	|RIGHT:	51860	|RIGHT:	1433	|RIGHT:	0	|
|	2013-05-22	|RIGHT:	22285	|RIGHT:	362	|RIGHT:	0	|
|	2013-06-24	|RIGHT:	43474	|RIGHT:	647	|RIGHT:	0	|
|	2013-07-15	|RIGHT:	15188	|RIGHT:	515	|RIGHT:	0	|
|	2013-10-29	|RIGHT:	173315	|RIGHT:	487	|RIGHT:	0	|
|	2013-12-08	|RIGHT:	17191	|RIGHT:	164	|RIGHT:	0	|
|	2013-12-30	|RIGHT:	16711	|RIGHT:	682	|RIGHT:	0	|
|	2014-06-14	|RIGHT:	246164	|RIGHT:	538	|RIGHT:	0	|
|	2014-06-21	|RIGHT:	1742	|RIGHT:	571	|RIGHT:	0	|
|	2014-06-25	|RIGHT:	7354	|RIGHT:	870	|RIGHT:	0	|
|	2014-06-28	|RIGHT:	1972	|RIGHT:	751	|RIGHT:	0	|
|	2014-08-03	|RIGHT:	62747	|RIGHT:	429	|RIGHT:	0	|
|	2014-08-10	|RIGHT:	5064	|RIGHT:	365	|RIGHT:	0	|
|	2014-09-29	|RIGHT:	88743	|RIGHT:	651	|RIGHT:	0	|
|	2014-10-06	|RIGHT:	11352	|RIGHT:	815	|RIGHT:	0	|
|	2015-01-09	|RIGHT:	164812	|RIGHT:	1391	|RIGHT:	0	|
|	2015-01-16	|RIGHT:	3638	|RIGHT:	1356	|RIGHT:	0	|
|	2015-02-08	|RIGHT:	31395	|RIGHT:	861	|RIGHT:	0	|
|	2015-02-17	|RIGHT:	10749	|RIGHT:	1103	|RIGHT:	0	|
|	2015-05-07	|RIGHT:	106888	|RIGHT:	422	|RIGHT:	0	|
|	2015-05-15	|RIGHT:	10690	|RIGHT:	595	|RIGHT:	0	|
|	2015-05-15	|RIGHT:	10743	|RIGHT:	648	|RIGHT:	0	|
|	2015-05-27	|RIGHT:	6831	|RIGHT:	517	|RIGHT:	0	|
|	2015-06-15	|RIGHT:	33643	|RIGHT:	853	|RIGHT:	0	|
|	2015-06-21	|RIGHT:	8073	|RIGHT:	259	|RIGHT:	0	|
|	2015-08-25	|RIGHT:	96648	|RIGHT:	781	|RIGHT:	0	|
|	2015-09-01	|RIGHT:	814	|RIGHT:	16	|RIGHT:	0	|
|	2015-11-07	|RIGHT:	94785	|RIGHT:	1063	|RIGHT:	0	|
|	2015-11-10	|RIGHT:	1361	|RIGHT:	742	|RIGHT:	0	|
|	2015-11-17	|RIGHT:	7162	|RIGHT:	309	|RIGHT:	0	|
|	2015-11-21	|RIGHT:	4820	|RIGHT:	786	|RIGHT:	0	|
|	2015-12-31	|RIGHT:	68503	|RIGHT:	939	|RIGHT:	0	|
|	2016-01-01	|RIGHT:	658	|RIGHT:	223	|RIGHT:	0	|
|	2016-04-21	|RIGHT:	174208	|RIGHT:	1229	|RIGHT:	1439	|
|	2016-05-01	|RIGHT:	11961	|RIGHT:	492	|RIGHT:	1235	|
|	2016-05-04	|RIGHT:	16053	|RIGHT:	783	|RIGHT:	1327	|
|	2016-05-18	|RIGHT:	9804	|RIGHT:	668	|RIGHT:	1622	|
|	2016-05-22	|RIGHT:	5401	|RIGHT:	371	|RIGHT:	1248	|
|	2016-08-26	|RIGHT:	122919	|RIGHT:	1176	|RIGHT:	1343	|
|	2016-08-29	|RIGHT:	2959	|RIGHT:	400	|RIGHT:	1201	|
|	2016-09-13	|RIGHT:	23782	|RIGHT:	1255	|RIGHT:	1367	|
|	2016-09-16	|RIGHT:	3637	|RIGHT:	1002	|RIGHT:	1466	|
|	2016-11-08	|RIGHT:	76462	|RIGHT:	1203	|RIGHT:	1388	|
|	2016-11-15	|RIGHT:	2004	|RIGHT:	823	|RIGHT:	1181	|
|	2016-12-09	|RIGHT:	39840	|RIGHT:	258	|RIGHT:	1440	|
|	2016-12-26	|RIGHT:	8650	|RIGHT:	163	|RIGHT:	1575	|
|	2017-03-10	|RIGHT:	122729	|RIGHT:	1008	|RIGHT:	1495	|
|	2017-03-15	|RIGHT:	5073	|RIGHT:	1213	|RIGHT:	1434	|
|	2017-06-03	|RIGHT:	117550	|RIGHT:	1063	|RIGHT:	2052	|

"total"消失分: 7,929,688

*** 補正の実行 [#xa130707]

2017/06/08(Thu) 7:48 JSTに実行 (by umorigu)

 mysql> SELECT page_name, total FROM official_page_counter WHERE page_name = 'FrontPage';
 +-----------+--------+
 | page_name | total  |
 +-----------+--------+
 | FrontPage | 124007 |
 +-----------+--------+
 1 row in set (0.00 sec)
 
 mysql> UPDATE official_page_counter SET total = total+ 7929688 WHERE page_name = 'FrontPage';
 Query OK, 1 row affected (0.03 sec)
 Rows matched: 1  Changed: 1  Warnings: 0
 
 mysql> SELECT page_name, total FROM official_page_counter WHERE page_name = 'FrontPage';
 +-----------+---------+
 | page_name | total   |
 +-----------+---------+
 | FrontPage | 8053695 |
 +-----------+---------+
 1 row in set (0.00 sec)



 mysql> SELECT page_name, total FROM official_page_counter WHERE page_name = 'FrontPage';
 +-----------+---------+
 | page_name | total   |
 +-----------+---------+
 | FrontPage | 8053695 |
 +-----------+---------+
 1 row in set (0.00 sec)
 
 mysql> SELECT page_name, total FROM dev_page_counter WHERE page_name = 'FrontPage';
 +-----------+-------+
 | page_name | total |
 +-----------+-------+
 | FrontPage |  3636 |
 +-----------+-------+
 1 row in set (0.00 sec)
 
 mysql> UPDATE dev_page_counter SET total = total+ 1008711 WHERE page_name = 'FrontPage';
 Query OK, 1 row affected (0.03 sec)
 Rows matched: 1  Changed: 1  Warnings: 0
 
 mysql> SELECT page_name, total FROM dev_page_counter WHERE page_name = 'FrontPage';
 +-----------+---------+
 | page_name | total   |
 +-----------+---------+
 | FrontPage | 1012347 |
 +-----------+---------+
 1 row in set (0.00 sec)

トップ   編集 差分 バックアップ 添付 複製 名前変更 リロード   新規 一覧 検索 最終更新   ヘルプ   最終更新のRSS
Site admin: PukiWiki Development Team

PukiWiki 1.5.3+ © 2001-2020 PukiWiki Development Team. Powered by PHP 5.6.40-0+deb8u12. HTML convert time: 0.034 sec.

OSDN