#maria @ Freenode stats by MariaDB

Statistics generated on Tuesday 24 April 2018 - 0:01:23
During this 108-day reporting period, a total of 457 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%
1872
3.9%
1761
3.7%
1677
3.0%
1328
3.2%
1441
3.0%
1348
2.8%
1268
2.9%
1308
3.6%
1636
3.9%
1757
4.4%
1975
4.8%
2151
3.8%
1690
4.9%
2219
4.8%
2133
4.8%
2165
5.3%
2382
5.3%
2366
4.7%
2106
4.9%
2199
4.9%
2183
4.4%
1962
4.1%
1855
4.7%
2111
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 shmoon44651002709795863319.4107.1yesterday"LinuxJedi: How does it compare to redshift ? :D"
2 dr-m_33032963221623714021.6125.617 days ago"forget the doublewrite buffer :)"
3 salle_551159263136861191710012.975.7today"Zgrokl: What do you mean by db1, 2 and 3? Different databases on"
4 montywi292106714831393819476216.392.52 days ago"yes, galera 4 is coming into 10.3 / 10.4"
5 sibiria3519862531614413111.867.3today"i actually don't know if you can set up a priority list for this"
6 mgriffin342129113781390407111.968.52 days ago"https://jira.mariadb.org/browse/MDEV-15660"
7 dragonheart26925231156334402615.092.5today"diveyez: did the grant exist already?"
8 dr-m23211642143596390316.897.979 days ago"so, the GUI tool could link to the MariaDB JDBC library?"
9 grknight3025696692533377112.571.824 days ago"robink: the gentoo package of 10.2 in question forces the install"
10 thumbs323864111475125227028.448.3today"ShalokShalom: by changing the CREATE TABLE statements."
11 stemid171337681918715265115.585.849 days ago"what is /tmp/#sql_45ab_0.MAD kind of file? there was also a .MAI"
12 tpanarch1st204158538619719.753.75 days ago"and which bit's where please?"
13 LinuxJedi74107871854185025.0137.64 days ago"the "Data Redundancy packages" section"
14 DrSlony952051234374181319.1104.332 days ago"Also, should valid_from and valid_to be DATETIME or TIMESTAMP?"
15 markusjm1711184384210177810.458.9today"phillijw: did you get it to work on the command line?"
16 wlad154880782169211.065.45 days ago"you need to hold LOCK_thread_count during this operation"
17 jkavalik962591011420169017.6101.466 days ago"qwebirc31012, did you change the service file? or is this after u"
18 jgnoss_15648266228414289.253.899 days ago"mysql 5.7 to mariadb 10.2.12"
19 DarkainMX65633747138021.2120.12 days ago"@JimmyNeutron: which MariaDB version?"
20 Xgc_94415153379341128813.783.2yesterday"jak2000: No need for the extra level of subquery."
21 conr1023981162252349739.553.054 days ago"sibiria: Yeah that's what I'll try first"
22 dracula5902992492431.9320.971 days ago"██•██████• ██████• ███"
23 an3l492279945310888718.1117.1today"How to get the content of temporary tables from thread ?"
24 qwebirc590536845642087612.971.48 days ago"vvaintroub: looks like backhole does not need any data"
25 jadew1004843608448.445.15 days ago"and I can ignore the binlogs?"


These didn't make it to the top:
jgnoss (778) Soltis (755) MrBech (753) grknight_ (747) [2ge] (734)
fraggeln (727) Jakdaw (714) ctcx (710) quan (699) vpelletier (690)
Oluranti (681) millican (665) nemo (646) mauzilla (644) msn (631)
matheiok (624) webbb (623) MariaDBstaff (622) gizmore|2 (615) dviola (613)
sigise (589) gunix (574) Naktibalda_ (567) jeffreylevesque (555) L4HLP (533)
CryptoSiD (532) janx_ (530) thebishop (524) Belliash (484) justAllgood (482)

By the way, there were 402 other nicks.

Most active nicks by hours
  0-5 6-11 12-17 18-23
1 tpanarch1st - 168 shmoon - 254 John_Paul_Bot - 317 grknight - 211
2 dragonheart - 164 dr-m_ - 144 salle_ - 298 thumbs - 148
3 thumbs - 114 mgriffin - 141 sibiria - 210 mgriffin - 106
4 salle_ - 109 markusjm - 110 dr-m_ - 151 salle_ - 87
5 mgriffin - 94 dragonheart - 80 shmoon - 137 gizmore|2 - 68
6 sibiria - 83 montywi - 77 dr-m - 134 wlad - 65
7 montywi - 73 dr-m - 61 montywi - 92 ctcx - 59
8 CryptoSiD - 67 diveyez - 60 wlad - 87 sibiria - 58
9 dviola - 52 salle_ - 57 jgnoss_ - 77 ShalokShalom - 55
10 jadew - 50 msn - 56 DrSlony - 67 shmoon - 53

Big numbers
Is sigise stupid or just asking too many questions? 60.0% lines contained a question!
spillere didn't know that much either. 42.3% of his/her lines were questions.
The loudest one was JimmyNeutron, who yelled 25.9% of the time!
Another old yeller was Renich, who shouted 13.6% of the time!
It seems that Renich's shift-key is hanging: 4.5% of the time he/she wrote UPPERCASE.
For example, like this:
     <Renich> OK

phillijw just forgot to deactivate his/her Caps-Lock. He/She wrote UPPERCASE 3.6% of the time.
Nobody beat anyone up. Everybody was friendly.
evrardjp brings happiness to the world. 18.8% lines contained smiling faces. :)
Cork isn't a sad person either, smiling 18.2% of the time.
CryptoSiD seems to be sad at the moment: 9.0% lines contained sad faces. :(
sigise is also a sad person, crying 5.7% of the time.
dracula590 wrote the longest lines, averaging 320.9 letters per line.
#maria average was 78.2 letters per line.
ShalokShalom wrote the shortest lines, averaging 32.7 characters per line.
jak2000 was tight-lipped, too, averaging 38.6 characters.
shmoon spoke a total of 8633 words!
shmoon's faithful follower, dr-m_, didn't speak so much: 7140 words.
Adam__ wrote an average of 74.00 words per line.
Channel average was 13.11 words per line.

Most used words
 Word Number of Uses Last Used by
1 mariadb 618 Zgrokl
2 table 546 vondel
3 MySQL 471 montywi
4 There 455 ShalokShalom
5 would 300 qwebirc83750
6 should 256 montywi
7 server 231 qwebirc83750
8 which 189 ShalokShalom
9 innodb 184 montywi
10 about 170 R1chR

Most referenced nicks
 Nick Number of Uses Last Used by
1 database 168 vondel
2 dr-m_ 111 shmoon
3 shmoon 82 LinuxJedi
4 salle_ 81 dasjoe
5 jgnoss_ 54 ahenders

Most referenced URLs
 URL Number of Uses Last Used by
1 https://jira.mariadb.org/browse/MDEV-11035 5 dr-m_
2 https://stackoverflow.com/questions/48938900/sql-error-1467- 4 Jeff_Computers
3 https://pastebin.com/zS1jWm1r 4 Jeff_Computers
4 https://jira.mariadb.org/browse/MDEV-15254 4 grknight
5 https://gist.github.com/diegoviola/7299a1d44fe9733b6334cae2d 3 dviola

Other interesting numbers
Nice opers here, no one got kicked!
ChanServ donated 29 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 4 actions.
stemid talks to him/herself a lot. He/She wrote over 5 lines in a row 9 times!
Another lonely one was mgriffin, who managed to hit 8 times.
lawrin1 couldn't decide whether to stay or go. 830 joins during this reporting period!
Cronus- has quite a potty mouth. 0.3% words were foul language.
For example, like this:
     <Cronus> listen man, i dont need some smart ass comments, i pasted a lot to see if you see something i dont

marlies also makes sailors blush, 0.3% of the time.

Latest Topics
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/ 3 days ago at 18:28 by dbart
Topic for #maria: Welcome! MariaDB 10.2.14 Stable (GA) is out! https://mariadb.org - Immediate feedback for beginners on Mondays from 08h00 to 10h00 UTC - https://mariadb.org/liveqa/ 3 days ago at 18:16 by dbart
Topic for #maria: Welcome! MariaDB 10.2.14 Stable (GA) is out! - Cork https://mariadb.org 3 days ago at 18:16 by dbart
The topic was set 4 times.
Total number of lines: 44902.

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