#maria @ Freenode stats by MariaDB

Statistics generated on Tuesday 19 June 2018 - 12:01:24
During this 165-day reporting period, a total of 607 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.3%
2896
4.1%
2782
3.7%
2479
3.1%
2081
3.3%
2236
3.1%
2087
2.8%
1872
2.9%
1961
3.6%
2460
4.0%
2699
4.7%
3165
4.6%
3154
4.0%
2706
4.9%
3300
4.5%
3046
4.8%
3285
5.1%
3450
5.0%
3394
4.8%
3262
4.8%
3280
4.8%
3248
4.8%
3248
3.9%
2631
4.6%
3115
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_8522652923543820371105013.076.1yesterday"jindraj: 10.1 -> 10.3 is quite big leap"
2 shmoon49655763290811970619.6108.44 days ago"sorry nvm, cardinality should not affect sorting speed."
3 dr-m_37636043798632803421.4124.68 days ago"last Saturday: commit 15419a558370aeed9521b498c34d50f20a8d47a5"
4 dragonheart40030562560334596314.990.9today""find out where the password for the root user gets stored when y"
5 montywi312106714831683819505216.291.915 days ago"https://mariadb.com/kb/en/library/aborting-statements/"
6 sibiria41210772856871480411.766.63 days ago"a handful of old broken articles mostly"
7 mgriffin343129113781411409211.968.719 days ago"assuming you used a test table"
8 dr-m23211642143596390316.897.9136 days ago"there must be some output from mysqld, right?"
9 grknight3025696692533377112.571.881 days ago"robink: the gentoo package of 10.2 in question forces the install"
10 markusjm33315471478292331710.057.3today"followed by `START SLAVE` which starts the replication"
11 stemid190523759918861306116.189.617 days ago"but when you say it's caused by large transactions..."
12 thumbs3581063111513128929768.348.143 days ago"with InnoDB, it'll roll back on its own"
13 LinuxJedi1021793896275627.0148.912 days ago"ws2k3: sorry, I'm at M|18 this week and have been giving a lot of"
14 grknight_2246443941678271612.170.6yesterday"note, alter user is mariadb 10.2.0+"
15 wlad22710813191149257611.369.410 days ago"ah, disable strict mode. sessionVariables=sql_mode="
16 DarkainMX1098011333213419.6114.2today"take off the --port from the command?"
17 Xgc_142508700465378205114.485.8yesterday"msno: Try formatting the SQL so that you can read it."
18 tpanarch1st204158538619719.753.762 days ago"reet so i've put this into my.cnf"
19 inthl77688872375193525.1133.010 days ago"salle, is there something obvious I am doing wrong perhaps?"
20 DrSlony982051268374184718.8103.718 days ago"Hello, I want to add columns to a table to be able to see what th"
21 jkavalik962591011420169017.6101.4123 days ago"what about "show explain for <connection_id>;"?"
22 jgnoss131821135408162512.468.64 days ago"salle: can I checkout that specific release from the git repo?"
23 Alec861174104200148417.394.9today"Dude you're using a RASPBERRY PI - what do you expect?"
24 jgnoss_15648266228414289.253.8156 days ago"mysql 5.7 to mariadb 10.2.12"
25 jak20002044294324451814237.041.2today"mysqld --tc-heuristic-recover=ROLLBACK"


These didn't make it to the top:
Razva (1254) Eric_Herman (1140) qwebirc59053 (1138) an3l (1091) frank-- (1046)
dviola (1019) conr (973) mejo (952) gunix (949) dracula590 (924)
jadew (844) average (840) MrBech (816) Enverex (774) Soltis (755)
Naktibalda_ (747) ctcx (740) [2ge] (734) EvanCarroll (729) fraggeln (727)
Jakdaw (714) quan (699) cereal__ (698) vpelletier (690) Oluranti (681)
bn_work (665) millican (665) msno (659) spetrunia (647) nemo (646)

By the way, there were 552 other nicks.

Most active nicks by hours
  0-5 6-11 12-17 18-23
1 dragonheart - 200 shmoon - 274 salle_ - 425 grknight - 211
2 salle_ - 190 dragonheart - 175 John_Paul_Bot - 317 salle_ - 156
3 tpanarch1st - 168 dr-m_ - 162 sibiria - 236 thumbs - 153
4 thumbs - 137 markusjm - 147 dr-m_ - 178 grknight_ - 134
5 mgriffin - 94 mgriffin - 141 shmoon - 166 mgriffin - 107
6 sibiria - 93 salle_ - 81 markusjm - 155 wlad - 95
7 montywi - 73 montywi - 77 dr-m - 134 sibiria - 83
8 average - 72 tnewman_ - 75 wlad - 125 DarkainMX - 74
9 CryptoSiD - 67 jak2000 - 74 montywi - 112 jak2000 - 72
10 Alec - 60 msno - 66 jgnoss - 94 gizmore|2 - 68

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

boubou_ just forgot to deactivate his/her Caps-Lock. He/She wrote UPPERCASE 5.7% of the time.
Nobody beat anyone up. Everybody was friendly.
evrardjp brings happiness to the world. 18.8% lines contained smiling faces. :)
gizmore|2 isn't a sad person either, smiling 17.1% 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 148.9 letters per line.
#maria average was 77.3 letters per line.
boubou_ wrote the shortest lines, averaging 26.1 characters per line.
ShalokShalom was tight-lipped, too, averaging 32.7 characters.
salle_ spoke a total of 11050 words!
salle_'s faithful follower, shmoon, didn't speak so much: 9706 words.
Adam__ wrote an average of 74.00 words per line.
Channel average was 13.12 words per line.

Most used words
 Word Number of Uses Last Used by
1 MariaDB 846 grknight_
2 table 692 jindraj
3 mysql 651 salle_
4 there 576 DarkainMX
5 would 354 Razva
6 should 312 Razva
7 SERVER 296 salle_
8 which 248 jindraj
9 about 220 inthl
10 innodb 217 qwebirc59053

Most referenced nicks
 Nick Number of Uses Last Used by
1 database 221 jak2000
2 salle_ 160 jindraj
3 dr-m_ 119 shmoon
4 shmoon 96 LinuxJedi
5 frank-- 62 ArjenAU

Most referenced URLs
 URL Number of Uses Last Used by
1 https://jira.mariadb.org/browse/MDEV-11035 5 dr-m_
2 https://mariadb.com/kb/en/library/setting-up-replication/ 5 Razva
3 https://stackoverflow.com/questions/48938900/sql-error-1467- 4 Jeff_Computers
4 https://jira.mariadb.org/browse/MDEV-15254 4 grknight
5 https://mariadb.com/kb/en/library/create-table/ 4 jgnoss

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

Also, dr-m_ tells us what's up with 5 actions.
stemid talks to him/herself a lot. He/She wrote over 5 lines in a row 10 times!
Another lonely one was mgriffin, who managed to hit 8 times.
lawrin1 couldn't decide whether to stay or go. 1274 joins during this reporting period!
marlies has quite a potty mouth. 0.3% words were foul language.
For example, like this:
     <marlies> it would be considerably less shit than some of the things you've come up with yourself tbh

Cronus- also makes sailors blush, 0.3% of the time.

Latest Topics
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/ 22 days ago at 16:19 by dbart
Welcome! MariaDB 10.2.15 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/ 27 days ago at 18:17 by dbart
Topic for #maria: Welcome! MariaDB 10.2.14 Stable (GA) is out! https://mariadb.org - Immediate feedback for beginner contributors on Mondays from 08h00 to 10h00 UTC - https://mariadb.org/liveqa/ 60 days ago at 18:28 by dbart
The topic was set 6 times.
Total number of lines: 67849.

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