#maria @ Freenode stats by MariaDB

Statistics generated on Sunday 20 May 2018 - 18:02:12
During this 135-day reporting period, a total of 527 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%
2347
4.1%
2246
3.7%
2012
3.1%
1713
3.1%
1702
2.9%
1603
2.7%
1480
2.9%
1591
3.6%
1996
3.9%
2133
4.5%
2487
4.7%
2578
3.9%
2148
4.8%
2643
4.5%
2493
4.9%
2707
5.2%
2859
5.1%
2792
4.9%
2663
5.0%
2748
4.8%
2646
4.8%
2625
3.9%
2155
4.6%
2528
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 shmoon49355573253811965019.6108.33 days ago"LinuxJedi: Hey, watched your talk on columnstore. Had a few quest"
2 salle_711241870845371480914312.975.95 days ago"spetrunia: https://pastebin.com/82SQQ4wN"
3 dr-m_36136003472623769521.3123.72 days ago"sorry, I misread. default: 8k, minimum 512 bytes, maximum 16k"
4 montywi312106714831683819505216.291.96 days ago"jkroon, show processlist and performance schema is the main tools"
5 sibiria37910352543832441011.666.7today"but you really should consider using only one node for writes"
6 dragonheart29425541471334437214.991.3yesterday"so hence. basic questions."
7 mgriffin343129113781411409211.968.718 days ago"sibiria: yeah, so probably you want to reboot sometimes. and inst"
8 dr-m23211642143596390316.897.9106 days ago"jkavalik: fwiw, the 3-byte UTF-8 can represent the Basic Multilin"
9 grknight3025696692533377112.571.851 days ago"the INSERT can fill the entire row as needed"
10 thumbs3581063111513128929768.348.113 days ago"yes, I can't think of a deterministic approach now."
11 LinuxJedi1001781896273127.3150.53 days ago"shmoon: I have never used Redshift so can't really compare. As wi"
12 stemid171337681918715265115.585.876 days ago"or if that's the one that drops."
13 Xgc_137508700426341197514.485.7yesterday"erebel55: Window Functions. See RANK and DENSE_RANK. ROW_NUMBER"
14 tpanarch1st204158538619719.753.732 days ago"nope same error when i do mysql -p"
15 grknight_1664812641223196811.968.62 days ago"and ignore the one ' character.. that's a mistake"
16 wlad1681114782192611.568.511 days ago"do you need to hold lock on temp tables? they are per-user"
17 DrSlony952051234374181319.1104.359 days ago"Hello, I'm creating a new table which stores objects which have t"
18 markusjm1721184391210178510.458.811 days ago"so the events could be written as STATEMENT format events"
19 jkavalik962591011420169017.6101.493 days ago"backnforth: did it run before "outside of docker" ? there may be"
20 DarkainMX74665869153420.7118.92 days ago"If you really have a data set that small, want it in memory, extr"
21 jgnoss_15648266228414289.253.8126 days ago"Relay_Log_Space: 503534029"
22 Alec801083104200139317.496.03 days ago"I have uploaded files over telnet (SSH port forwarding FTW!)"
23 dviola11044217140610199.356.110 days ago"I don't want to change my my.cnf"
24 conr1023981162252349739.553.081 days ago"What's the minimum privs the replication user needs?"
25 gunix5933923536494916.189.06 days ago"you should also check the unix sockets: "ss -xlnp""


These didn't make it to the top:
dracula590 (924) an3l (887) qwebirc59053 (876) jadew (844) MrBech (816)
jgnoss (778) Enverex (774) Soltis (755) Naktibalda_ (741) [2ge] (734)
EvanCarroll (729) fraggeln (727) Jakdaw (714) ctcx (710) quan (699)
vpelletier (690) Oluranti (681) bn_work (665) millican (665) msno (659)
spetrunia (647) nemo (646) mauzilla (644) ShapeShifter499 (635) msn (631)
matheiok (624) webbb (623) MariaDBstaff (622) gizmore|2 (615) jak2000 (608)

By the way, there were 472 other nicks.

Most active nicks by hours
  0-5 6-11 12-17 18-23
1 salle_ - 170 shmoon - 272 salle_ - 362 grknight - 211
2 tpanarch1st - 168 dr-m_ - 161 John_Paul_Bot - 317 thumbs - 153
3 dragonheart - 165 mgriffin - 141 sibiria - 212 salle_ - 113
4 thumbs - 137 markusjm - 110 shmoon - 165 mgriffin - 107
5 mgriffin - 94 dragonheart - 104 dr-m_ - 165 grknight_ - 105
6 sibiria - 90 montywi - 77 dr-m - 134 sibiria - 77
7 montywi - 73 jak2000 - 68 montywi - 112 gizmore|2 - 68
8 CryptoSiD - 67 salle_ - 66 wlad - 101 wlad - 65
9 EvanCarroll - 54 msno - 66 jgnoss_ - 77 ctcx - 59
10 Alec - 54 dr-m - 61 DrSlony - 67 ShalokShalom - 55

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 JimmyNeutron, who yelled 25.9% of the time!
Another old yeller was spillere, who shouted 11.5% of the time!
It seems that Alec's shift-key is hanging: 7.5% of the time he/she wrote UPPERCASE.
For example, like this:
     <Alec> 6) 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. :(
thow is also a sad person, crying 8.3% of the time.
dracula590 wrote the longest lines, averaging 320.9 letters per line.
#maria average was 77.3 letters per line.
boubou_ wrote the shortest lines, averaging 26.1 characters per line.
lapinrigolo was tight-lipped, too, averaging 29.6 characters.
shmoon spoke a total of 9650 words!
shmoon's faithful follower, salle_, didn't speak so much: 9143 words.
Adam__ wrote an average of 74.00 words per line.
Channel average was 13.05 words per line.

Most used words
 Word Number of Uses Last Used by
1 mariadb 673 bn_work
2 table 616 grknight_
3 mysql 558 boubou_
4 there 496 spetrunia
5 would 314 bn_work
6 should 287 grknight_
7 server 237 qwebirc47027
8 which 224 salle_
9 InnoDB 205 grknight_
10 about 204 frank--

Most referenced nicks
 Nick Number of Uses Last Used by
1 database 190 jak2000
2 salle_ 126 spetrunia
3 dr-m_ 119 shmoon
4 shmoon 96 LinuxJedi
5 frank-- 56 Crashbit

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://jira.mariadb.org/browse/MDEV-15254 4 grknight
4 https://pastebin.com/zS1jWm1r 4 Jeff_Computers
5 https://pastebin.com/Q5FHMF7u 3 salle_

Other interesting numbers
Nice opers here, no one got kicked!
ChanServ donated 34 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. 1052 joins during this reporting period!
Alec has quite a potty mouth. 0.3% words were foul language.
For example, like this:
     <Alec> Get someone who knows their shit involved.

Cronus- 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/ 30 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/ 30 days ago at 18:16 by dbart
Topic for #maria: Welcome! MariaDB 10.2.14 Stable (GA) is out! - Cork https://mariadb.org 30 days ago at 18:16 by dbart
The topic was set 4 times.
Total number of lines: 54904.

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