#maria @ Freenode stats by MariaDB

Statistics generated on Friday 6 December 2019 - 0:01:01
During this 23-day reporting period, a total of 86 different nicks were represented on #maria.

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

Most active times
4.7%
235
4.3%
215
3.2%
161
2.5%
126
2.6%
132
2.6%
131
3.9%
194
2.4%
118
3.1%
153
2.9%
147
3.1%
157
3.7%
183
2.8%
138
3.5%
174
3.6%
182
4.5%
227
5.0%
252
6.4%
322
5.2%
263
7.5%
376
6.0%
302
4.7%
236
6.2%
310
5.5%
275
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 Xgc1794571004661671269415.189.0yesterday"how2hack: Then an image can be used only one."
2 how2hack1182911161167160613.671.83 days ago"if it's not unique then it has to be a many to many?"
3 grknight_684359634398214.481.8yesterday"the old way still works best"
4 sibiria94705063439199.855.2yesterday"best_would_probably_be_to_be_less_verbose_with_column_names"
5 HZun2211943514069431.5187.29 days ago"recovery." what does this refer to then?"
6 mikecmpb_6668068710.458.0yesterday"m3thos : down to 3gb swap now, only maybe an hour to go .. :)"
7 knielsen18206537746225.7152.13 days ago"sehh: for the mysql.gtid_slave_pos table, you can just drop the t"
8 andrelk2643944117.094.5yesterday"HZun, sync_binlog=1 && flush_at_commit=0 indeed should lead to mi"
9 inthl162938838123.8128.812 days ago"so yes, this is a shared env"
10 Akuw3236736711.555.1yesterday"i am using debian 9, but apparmor is not active"
11 tharkun121341803235129.2162.716 days ago"Good $DAY I am trying to connect to a database on my local comput"
12 koollman1934834818.3105.18 days ago"and for server, 60 is too high"
13 mgriffin271541915733012.275.9yesterday"alter table t1 add pkid serial primary key invisible first;"
14 niels_1115615931528.6147.910 days ago"usually one of the nodes is OK but the other 2 are not"
15 truexfan81177816924714.576.42 days ago"ok i'm not sure where i went wrong with this event"
16 techexo121766223819.8112.95 days ago"Hello everyone. I am a bit troubled by not finding an clear answe"
17 thumbs_scum272342348.748.02 days ago"mikecmpbll: and your system isnt using swap memory, right?"
18 rafaelweingartne1122622620.5135.97 days ago"Hello Mariadb folks, do you guys know a method to operate over th"
19 jkavalik113319122420.4112.8yesterday"the comparison itself should be negligible, but there may be a di"
20 dalvlexa522022044.0287.014 days ago"Hello! I have a MariaDB Galera cluster of three nodes which must"
21 jak20001294951420316.991.911 days ago"and like not work here in this case, right?"
22 kwhat4820220225.2147.413 days ago"Hi, I am running into an interesting problem with MariaDB mysql.e"
23 [TheBug]134614619214.885.410 days ago"697.4 MiB + 317.5 KiB = 697.7 MiB mysqld"
24 flexd618118130.2173.07 days ago"leucas: Hmm. I could try enabling the query log"
25 winem_718118125.9140.99 days ago"this really confuses me :("


These didn't make it to the top:
leeyaa (174) salle (166) rjCousineau (164) MacroMan (156) GoSox_ (155)
XC2299 (152) willemb (138) _stefanb (137) nsmeds (128) kyloren_ (126)
montywi (123) Zgrokl (121) ncopa (117) truff (115) dragonheart (108)
sehh (107) tom_work (104) moldy (101) gislaved90 (94) norwood67 (89)
agris (88) marco_n (73) Duality (71) mgolisch (69) z8z (68)
fengshaun (66) Tazmain (59) Guest40544 (56) m3thos (51) dongcarl (49)

By the way, there were 30 other nicks.

Most active nicks by hours
  0-5 6-11 12-17 18-23
1 Xgc - 29 agris - 10 sibiria - 45 Xgc - 111
2 how2hack - 23 willemb - 8 grknight_ - 43 how2hack - 80
3 mgriffin - 12 _stefanb - 8 Xgc - 32 mikecmpb_ - 65
4 sibiria - 11 Xgc - 7 andrelk - 25 sibiria - 38
5 fengshaun - 8 GoSox_ - 7 MacroMan - 13 Akuw - 32
6 gislaved90 - 8 niels_ - 6 how2hack - 13 thumbs_scum - 27
7 norwood67 - 7 z8z - 4 HZun - 12 grknight_ - 24
8 HarryFenice - 7 dragonheart - 3 ncopa - 11 koollman - 19
9 Guest40544 - 7 HZun - 3 rafaelweingartne - 11 knielsen - 14
10 dragonheart - 5 XC2299 - 3 inthl - 11 mgriffin - 12

Big numbers
Is HZun stupid or just asking too many questions? 45.5% lines contained a question!
how2hack didn't know that much either. 44.1% of his/her lines were questions.
The loudest one was inthl, who yelled 6.2% of the time!
Another old yeller was andrelk, who shouted 3.8% of the time!
Everybody had their shift-key under control. :)
Nobody beat anyone up. Everybody was friendly.
mikecmpb_ brings happiness to the world. 13.6% lines contained smiling faces. :)
inthl isn't a sad person either, smiling 12.5% of the time.
Akuw seems to be sad at the moment: 6.2% lines contained sad faces. :(
andrelk is also a sad person, crying 3.8% of the time.
HZun wrote the longest lines, averaging 187.2 letters per line.
#maria average was 84.5 letters per line.
agris wrote the shortest lines, averaging 31.8 characters per line.
thumbs_scum was tight-lipped, too, averaging 48.0 characters.
Xgc spoke a total of 2694 words!
Xgc's faithful follower, how2hack, didn't speak so much: 1606 words.
dalvlexa wrote an average of 44.00 words per line.
Channel average was 14.89 words per line.

Most used words
 Word Number of Uses Last Used by
1 table 74 knielsen
2 mariadb 56 sehh
3 unique 46 Xgc
4 column 34 how2hack
5 there 34 mgriffin
6 would 33 sehh
7 mysql 31 knielsen
8 should 29 sibiria
9 where 28 how2hack
10 about 28 how2hack

Most referenced nicks
 Nick Number of Uses Last Used by
1 how2hack 79 Xgc
2 truexfan81 23 Xgc
3 HZun 14 knielsen
4 mikecmpb_ 11 mgriffin
5 jak2000 9 Xgc

Most referenced URLs
 URL Number of Uses Last Used by
1 https://jira.mariadb.org/browse/MDEV-16545 2 willemb
2 https://mariadb.com/kb/en/library/foreign-keys/ 2 Guest40544
3 https://hastebin.com/ficofaciju.sql 1 how2hack
4 https://jira.mariadb.org/browse/MDEV-10512?focusedCommentId= 1 dongcarl
5 https://pastebin.com/rGr1AaLE 1 kyloren_

Other interesting numbers
Nice opers here, no one got kicked!
ChanServ donated 1 ops in the channel...
Wow, no op was taken on #maria!
tharkun always lets us know what he/she's doing: 1 actions!
For example, like this:
     * tharkun takes notes

Also, dimm tells us what's up with 1 actions.
Xgc talks to him/herself a lot. He/She wrote over 5 lines in a row 2 times!
Another lonely one was _stefanb, who managed to hit 1 times.
opsec couldn't decide whether to stay or go. 238 joins during this reporting period!
Nobody is foul-mouthed in #maria! Get out much?

Latest Topics
Welcome! MariaDB 10.3.12 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/ 17 days ago at 15:25 by dbart
The topic was set 1 times.
Total number of lines: 5011.

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 00 seconds