Hello all,
a part of the german community (all member of the same big ISP as far as I
see) reported to me problems with the DNS of the toolserver. I doubt that the
problems are on our end, but just to be sure:
Have had anyone problems to reach the toolserver in the time since 20. Nov.
until now, that are related to DNS (and is not a customer by german vodafon or
arcor). I would be especialy interrested in non-germany-users.
Sincerly,
DaB.
--
Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885
This query compiles a list of external links (from the main namespace)
grouped by website:
select count(*), trim(leading 'www.' from substring_index(substring_index(el_to, '/', 3),'/',-1)) as site
from externallinks, page
where el_from = page_id and page_namespace=0
group by 2 having count(*)> 10 order by 1;
Running this for no.wikipedia (nowiki_p), these are the top 5 sites:
8073 | snl.no
8586 | vegvesen.no
8907 | imdb.com
21924 | commons.wikimedia.org
46662 | toolserver.org
I'd like to run this once a week for many of our sites, and compile
the statistics. Is anybody doing this already? Is it bad or impossible?
Where should I store the results? How do I select... from each database
(nowiki_p, dawiki_p, svwiki_p, ...) and insert into a one central
database table? Does MySQL handle that? The statistics table
should have columns also for site and date, e.g. the four columns:
no.wikipedia 2011-11-25 8907 imdb.com
Afterwards, we could select sum()...group by... any of the columns
and make all sorts of interesting statistics.
--
Lars Aronsson (lars(a)aronsson.se)
Aronsson Datateknik - http://aronsson.se
Hi,
this summer, River set up an Apache instance on wolfsbane.
Is there any roadmap to move off ZWS?
My interest in this soared today after wrestling (again)
with Perl's "@INC". "use" and "use libs" are parsed at com-
pile-time, so to use different paths for tests and produc-
tion I either need to patch the "use libs" line at deploy-
ment (and not forget to), or revert to "require" and
"import" which looks ugly.
I haven't tested it, but the possibility to "SetEnv
PERL5LIB" in an ".htaccess" file should be an elegant solu-
tion to this, and according to the Zeus documentation, there
seems to be no such thing in ZWS.
Tim
Hello all,
we finaly get a dump of the cluster s2 and s5 from the foundation (thanks to
Asher Feldman – if you see him, hug him). At the moment I transfer the dump-
files to the toolserver. Because some tools are already malfunctioning due the
corrupt data of s2 and s5, and because the next regular maintaince-day is
still quite far away, I hereby announce a unplaned maintaince-window for
Saturday, 19. Nov between 20:00 and 23:59 UTC
The import of the data will take longer of corse (I will send an eMail when it
is done), but Nosy plans to do some urgend maintaince on hyacinth too, that
will be finished when the maintaince-window is done. So during the maintaince-
window the cluster s2 and s5 will be away; the cluster s3, s4 (the instance
with user-databases, not the read-only one), s6 and s7 will be read-only
and/or away for some time.
There will be no software-updates or db-view changings and no server beside
hyacinth (and mayde daphne) will be rebooted.
If you have any questions, please use the mailing-list or the IRC-channel.
Sincerly,
DaB.
--
Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885
Ive been using crontab reliably for a long time. I havent modified my
crontab recently. At about 0230UTC 24 November crontab stopped working
correctly on willow. My scripts no longer work correctly and I am not
getting any emails from cron. Anyone have any idea what the issue is?
John
So, is anyone else seeing really horrible mysql performance on s1? I heard a mysql upgrade introduced regressions, but I'm seeing queries take 2x - 3x as long, sometimes worse.
- Jason
Just a thought that I came up today. We currently use bz and tz compression
for data in the stats directory. which is a about 2.3TB. If we switched to
7z compression we would gain at least a 25-30% gain in compression ratios.
This seems one way to help address the lack of space. Another would be to
make it public what directories are eating up the most space.
John
It would be practical, if those, who have root access or any kind of higher level access to Toolserver, would be automatically voiced on the IRC channel, like it's habit on some other channels. There could be classical "admins are voiced" note in welcome message or in topic as well. It doesn't cost anything and it is user friendly to visitors.
There are two experiences, which led me to this proposal:
1) Time to time there are people coming to the channel and looking for admins - this could help them.
2) River is changing his nick pretty often. I don't mind that at all - let everybody use the nick they like and it's actually quite pleasant refreshment. But it always take me (and so far I know I'm not alone) some time to find out, which nick he uses ATM... ;-)
Kind regards
Danny B.
Hello all,
I will be away tomorrow and this weekend. If there is a normal-level-problem,
please fill in a bug in JIRA and I will try to handle it when I am back (or
another root will do the same). If there is a more serious problem, try to
reach Nosy in IRC. I may have WLAN in my hotel, so I maybe I will be at IRC in
the evening too.
I also will be away the following weekend.
Sincerly,
DaB.
--
Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885