#author("2017-06-07T23:48:08+09:00","","")
#author("2017-06-08T07:56:13+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の過去のアクセスカウンタの値を調べました。

"total"の値が減少しているところが、アクセスカウンタがリセットされたことを表しています。
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	|	1418	|	31	|	65	|
|	2006-02-08	|	391235	|	136	|	255	|
|	2006-04-11	|	559	|	219	|	236	|
|	2011-11-14	|	461340	|	75	|	0	|
|	2011-12-03	|	1750	|	52	|	0	|
|	2013-06-01	|	68073	|	63	|	0	|
|	2013-07-28	|	247	|	65	|	0	|
|	2017-01-12	|	88063	|	6	|	95	|
|	2017-04-29	|	608	|	5	|	68	|
|	2017-06-03	|	3274	|	19	|	74	|
|	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
- pukiwiki.osdn.jp/

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

OSDN