#maria @ Freenode stats by MariaDB

Statistics generated on Wednesday 26 September 2018 - 0:01:07
During this 231-day reporting period, a total of 1002 different nicks were represented on #maria.

2010 Stats 2011 Stats 2012 Stats 2013 Stats 2014 Stats 2015 Stats 2016 Stats 2017 Stats Current Stats

Most active times
4.2%
3975
4.1%
3884
3.6%
3369
3.0%
2855
3.5%
3256
3.2%
2975
2.8%
2671
2.8%
2676
3.5%
3299
3.9%
3673
4.5%
4226
4.5%
4284
4.0%
3778
4.8%
4499
4.4%
4132
5.1%
4778
5.3%
5031
5.2%
4935
4.9%
4594
4.9%
4604
4.7%
4470
4.6%
4332
3.9%
3697
4.6%
4311
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
0-5 = 0-5 6-11 = 6-11 12-17 = 12-17 18-23 = 18-23

Most active nicks
 NickNumber of linesWhen?Number of WordsWords per lineChars per lineLast seenRandom quote
1 salle_126033511218868529921624612.976.0yesterday"t-ask: Before MySQL 8.0 that is"
2 sibiria8961706670419351034511.565.22 days ago"it just doesn't make sense"
3 shmoon49655763290811970619.6108.411 days ago"and your take on the indexing part?"
4 dr-m_44138504864632934621.2122.7today"service_manager_extend_timeout() being called too often"
5 dragonheart54340373504334799814.788.7today"replication is pretty easy. Failover to it is slightly harder."
6 markusjm62218453735825640510.359.9today"xevilstar: I'd say open up a bug report"
7 montywi3861067148321211254592515.387.38 days ago"Where the problem is that the test/t3 table already exists"
8 Xgc_380150985913091721539814.285.0today"Available disk space is ok?"
9 grknight_43277713583023515811.969.7today"did you restart the server and recheck have_ssl?"
10 ws2k32522733693129773454418.098.6today"so slave is not a galera node"
11 mgriffin343129113781411409211.968.759 days ago"assuming you used a test table"
12 dr-m23211642143596390316.897.9202 days ago"so, the GUI tool could link to the MariaDB JDBC library?"
13 grknight3025696692533377112.571.8147 days ago"you cannot do that in the INSERT?"
14 wlad33934521641179368810.967.07 days ago"I felt like Java naming nailed it"
15 DarkainMX19811202552161354617.9104.3today"https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html"
16 LinuxJedi1202113914309425.8141.136 days ago"yea, I didn't mean auto mounting, I meant manually mounting"
17 stemid190523759918861306116.189.683 days ago"no but you could setuid a script that does that."
18 frank--35296086682128030088.549.6today"salle: hrm, I thought I used cfg on the wiki. I used cfq."
19 ArjenAU22114491547299613.675.4today"dragonheart, astonishing. 2.6 is beyond ancient. goodness."
20 thumbs3581063111513128929768.348.1109 days ago"yes, I can't think of a deterministic approach now."
21 inthl106719872468473253223.9126.77 days ago"no, .8, just upgraded 2 days before"
22 DrSlony1402051607611242317.395.615 days ago"Hello, how do I get a total row count when using group by? i.e. S"
23 ionas1711984164214812.672.97 days ago"the problem starts when there are deep foreign key chains"
24 tpanarch1st204158538619719.753.7128 days ago"and then presumably, the first IP should be that of my laptop"
25 Alec1351174111167514196614.679.330 days ago"Oh it's the blind leading the blind"


These didn't make it to the top:
jak2000 (1698) jkavalik (1690) jgnoss (1625) Eric_Herman (1584) spaces (1459)
jgnoss_ (1428) phillijw (1400) Razva (1254) average (1238) qwebirc59053 (1138)
an3l (1091) dviola (1019) hal529 (1015) conr (973) mejo (952)
gunix (949) dracula590 (924) xevilstar (920) PlaidRabbit (895) MadMerlin|work__ (878)
rmbeer (856) jadew (844) MrBech (816) Barnerd_ (806) Enverex (774)
Jakdaw (757) Soltis (755) Naktibalda_ (747) ctcx (740) EvanCarroll (740)

By the way, there were 947 other nicks.

Most active nicks by hours
  0-5 6-11 12-17 18-23
1 dragonheart - 277 shmoon - 274 salle_ - 672 grknight_ - 246
2 salle_ - 246 dragonheart - 233 sibiria - 557 salle_ - 236
3 tpanarch1st - 168 markusjm - 184 markusjm - 361 grknight - 211
4 sibiria - 154 dr-m_ - 175 John_Paul_Bot - 317 sibiria - 185
5 thumbs - 137 mgriffin - 141 dr-m_ - 230 thumbs - 153
6 Xgc_ - 117 salle_ - 106 wlad - 213 frank-- - 148
7 frank-- - 117 ArjenAU - 105 ws2k3 - 179 DarkainMX - 122
8 ArjenAU - 116 jak2000 - 79 shmoon - 166 Xgc_ - 110
9 spaces - 95 tnewman_ - 78 ionas - 161 mgriffin - 107
10 mgriffin - 94 montywi - 77 montywi - 153 wlad - 97

Big numbers
Is bn_work stupid or just asking too many questions? 44.2% lines contained a question!
Zgrokl didn't know that much either. 43.1% of his/her lines were questions.
The loudest one was Razva, who yelled 13.2% of the time!
Another old yeller was Barnerd_, who shouted 11.8% of the time!
It seems that Alec's shift-key is hanging: 5.2% of the time he/she wrote UPPERCASE.
For example, like this:
     <Alec> 4) MAKE SURE THAT WRITE WENT THROUGH

norwood67 just forgot to deactivate his/her Caps-Lock. He/She wrote UPPERCASE 4.4% of the time.
Nobody beat anyone up. Everybody was friendly.
Barnerd_ brings happiness to the world. 19.6% lines contained smiling faces. :)
evrardjp isn't a sad person either, smiling 18.8% of the time.
CryptoSiD seems to be sad at the moment: 9.0% lines contained sad faces. :(
mejo is also a sad person, crying 6.8% of the time.
LinuxJedi wrote the longest lines, averaging 141.1 letters per line.
#maria average was 78.5 letters per line.
ShalokShalom wrote the shortest lines, averaging 32.7 characters per line.
rcp was tight-lipped, too, averaging 33.5 characters.
salle_ spoke a total of 16246 words!
salle_'s faithful follower, sibiria, didn't speak so much: 10345 words.
Adam__ wrote an average of 74.00 words per line.
Channel average was 13.31 words per line.

Most used words
 Word Number of Uses Last Used by
1 mariaDB 1211 xevilstar
2 table 874 AcTiWoRk
3 mysql 867 tilt
4 there 773 Furai
5 freenode 581 montywi
6 would 510 markusjm
7 should 460 markusjm
8 staff 407 qew
9 member 403 qew
10 server 365 markusjm

Most referenced nicks
 Nick Number of Uses Last Used by
1 By 793 nezZario_
2 database 301 markusjm
3 See 255 markusjm
4 salle_ 223 ws2k3
5 dr-m_ 139 ws2k3

Most referenced URLs
 URL Number of Uses Last Used by
1 https://bryanostergaard.com/ 223 qew
2 https://MattSTrout.com/ 180 qew
3 https://encyclopediadramatica.rs/Freenodegate 163 qew
4 https://williampitcock.com/ 160 qew
5 http://web.nba1001.net:8888/tj/tongji.js"></script 17 diogenese5

Other interesting numbers
Tux21 wasn't very popular, getting kicked 1 times!
For example, like this:
     *** Tux21 was kicked by dbart

GorillaWarfare24 seemed to be hated too: 1 kicks were received.
dbart is either insane or just a fair op, kicking a total of 2 people!
ChanServ donated 40 ops in the channel...
Wow, no op was taken on #maria!
Xgc_ always lets us know what he/she's doing: 9 actions!
For example, like this:
     * Xgc nods

Also, montywi tells us what's up with 9 actions.
markusjm talks to him/herself a lot. He/She wrote over 5 lines in a row 12 times!
Another lonely one was stemid, who managed to hit 10 times.
lawrin1 couldn't decide whether to stay or go. 1821 joins during this reporting period!
hehsec has quite a potty mouth. 0.7% words were foul language.
For example, like this:
     <hehsec> Any other tools for remotely working with a mysql database that aren't complete shit?

prsstnt also makes sailors blush, 0.6% of the time.

Latest Topics
Welcome! MariaDB 10.3.9 is out! https://mariadb.org - Immediate feedback for beginner contributors on Mondays from 08h00 to 10h00 UTC and Thursdays from 10h00 to 12h00 UTC - https://mariadb.org/liveqa/ 9 days ago at 21:39 by dbart
Welcome! MariaDB 10.3.8 is out! https://mariadb.org - Immediate feedback for beginner contributors on Mondays from 08h00 to 10h00 UTC and Thursdays from 10h00 to 12h00 UTC - https://mariadb.org/liveqa/ 52 days ago at 05:13 by dbart
Welcome! MariaDB 10.3.7 is out! https://mariadb.org - Immediate feedback for beginner contributors on Mondays from 08h00 to 10h00 UTC and Thursdays from 10h00 to 12h00 UTC - https://mariadb.org/liveqa/ 88 days ago at 16:19 by dbart
The topic was set 8 times.
Total number of lines: 94317.

all times are EET (UTC+2)
stats automatically refreshed at
0000, 0600, 1200 and 1800

Stats generated by pisg v0.72
pisg by Morten Brix Pedersen and others
Stats generated in 00 hours 00 minutes and 06 seconds