Revision: 97
http://svn.sv.gnu.org/viewvc/?view=rev&root=administration&revision=97
Author: karl
Date: 2014-08-18 23:20:45 +0000 (Mon, 18 Aug 2014)
Log Message:
-----------
trivially reformat
Modified Paths:
--------------
trunk/sviki/SqlQueries.mdwn
Modified: trunk/sviki/SqlQueries.mdwn
===================================================================
--- trunk/sviki/SqlQueries.mdwn 2014-08-14 22:02:21 UTC (rev 96)
+++ trunk/sviki/SqlQueries.mdwn 2014-08-18 23:20:45 UTC (rev 97)
@@ -1,23 +1,36 @@
- (The following are not related to stats, but making a new page seemed
worse.) Here are some queries to get a grip on the mysql databases for
savannah:
+SQL queries and info
+--------------------
- mysql savane # on the internal subhost
- show databases; # show all databases in the installation
- show tables from savane; # show tables in the main database
- show columns from savane.groups; # show columns in one of the main
tables
+Here are some queries to get a grip on the mysql databases for savannah:
- It seems the top-level "news" posts are saved in the savane.news_bytes
table, with the group_id field recording the project and the id field the
unique id for each post. The savane.forum table is apparently only for replies
to these news posts; its group_forum_id column matches up with the forum_id
column in news_bytes. Set display type of news comments to flat or
replies-to-comments will not be displayed.
+ mysql savane # on the internal subhost
+ show databases; # show all databases in the installation
+ show tables from savane; # show tables in the main database
+ show columns from savane.groups; # show columns in one of the main tables
- On the internal host, in /root/bin are some scripts:
- forum-remove-by-id, items-list-by-id, items-remove-by-id
- The first silently removes all forum posts for ids listed on the cmdline.
- The second lists all posts in all trackers, plus forum posts, for the
given id,
- the third removes all posts in all trackers, plus forum posts.
+It seems the top-level "news" posts are saved in the savane.news_bytes
+table, with the group_id field recording the project and the id field
+the unique id for each post. The savane.forum table is apparently only
+for replies to these news posts; its group_forum_id column matches up
+with the forum_id column in news_bytes. Set display type of news
+comments to flat or replies-to-comments will not be displayed.
- This was all to deal with the overwhelming accumulated spam in news posts
comments, sept 2011.
+On the internal host, in /root/bin are some scripts:
+ forum-remove-by-id, items-list-by-id, items-remove-by-id
+The first silently removes all forum posts for ids listed on the cmdline.
+The second lists all posts in all trackers, plus forum posts, for the given id,
+the third removes all posts in all trackers, plus forum posts.
- Some (old) stats, as of 20051217.
- As you can see, we have actually few CVS users; most of our traffic is
from people who browse resources.
+This was all to deal with the overwhelming accumulated spam in news
+posts comments, sept 2011.
+Old stats
+--------
+Some (old) stats, as of 20051217.
+
+As you can see, we have actually few CVS users; most of our traffic is
+from people (spiders?) who browse resources.
+
# Number of users with shell access (!)
mysql> select count(*) from user where authorized_keys is not null and
authorized_keys != "";
+----------+
