#maria @ Freenode stats by MariaDB

Statistics generated on Wednesday 23 August 2017 - 12:01:11
During this 229-day reporting period, a total of 943 different nicks were represented on #maria.

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

Most active times
4.3%
4793
4.4%
4855
3.9%
4307
3.0%
3349
3.1%
3454
3.1%
3404
2.6%
2877
2.7%
2961
2.8%
3063
3.5%
3887
4.0%
4473
4.1%
4536
4.2%
4616
4.1%
4502
4.3%
4748
5.3%
5862
5.3%
5859
5.4%
5934
5.4%
6017
5.3%
5822
5.0%
5529
5.1%
5619
4.6%
5107
4.6%
5041
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 grknight11983005398280011498812.573.7yesterday"guardian: what about: DROP TABLE `piwik`.`#sql-1526_3a`"
2 wlad1554429104463646596144339.353.6yesterday"but my question was about symptoms"
3 serg11091229635746601251611.365.72 days ago"must be something else...."
4 montywi105010401263690431181232511.766.66 days ago"dtm_: Regarding what performance? I have tested connect speed an"
5 dragonheart65331155586375907613.981.7today"making somehow the slot maps to a node in a fixed way?"
6 salle_678178731693740889713.176.4today"dr-m: So we suggested LEFT JOIN instead"
7 dr-m_43720715558420804918.4107.5yesterday"we should un-messify it more"
8 sibiria697105452901533789211.362.3today"(but returns result based on the current session's tz setting)"
9 sumitlakra40214575251594298760018.9106.9today"dragonheart: jplindst: Hi"
10 jkavalik_25019602677470818.8108.1yesterday"(SHOW WARNINGS; after that to see the "optimized" query)"
11 PGNd25367015351936414116.4104.135 days ago"I build 10.2 with CMAKE. I want to isolate [client] password in"
12 lapinrigolo492307320856140768.349.839 days ago"running the same query on mysql I get the right results"
13 AspiringMind4356341303112788239469.157.544 days ago"Can we specify auth_node in LEX_USER to make it working?"
14 litheum24812292639392115.893.929 days ago"man, your nickname is a good description of the situation"
15 Ninpo^28236920512731463331011.766.08 days ago"Dropped you a pm about what you're doing right this second hehe"
16 danblack2856278391801326711.568.899 days ago"wlad_: :-) thanks. pitty the interested one didn't stick around"
17 jkbzh1569052121302619.4108.5114 days ago"all of that is called higher up by thd_prepare_connection"
18 hanshenrik2501509642689286511.567.537 days ago"sibiria, yes it was the mysql docs"
19 salle221802691548952284912.977.3113 days ago"vanch: Better use some pastebin"
20 LinuxJedi1363091754767283020.8116.29 days ago"ws2k3: ok, what does mysqld's log say about it now?"
21 ctcx217440892273280212.973.171 days ago"I was not demanding anything, sorry if it sounded like that."
22 markusjm276409164668727429.956.751 days ago"cpg: is that caused by the ?the cracklib plugin"
23 Xgc_164794895136765259015.890.5today"IgorK_: Just check the error."
24 Xgc1738613421173242314.084.883 days ago"VlanX: Anything in [ ] is optional."
25 hojuruku86921227551396236527.5158.4138 days ago"i don't want jemalloc - and i don't want tcmmaloc :P"


These didn't make it to the top:
mneth1 (2307) elenst (2184) svoj_ (2133) tanj (2068) arthurl (2012)
ionas (2009) ws2k3 (1780) rmbeer__ (1755) dreas (1726) igor (1705)
jak2013 (1595) MariaDBstaff (1578) catphish (1572) knielsen (1557) stemid (1497)
styx-tdo^afk (1480) frank-- (1459) dr-m (1416) Naktibalda_ (1406) proprietarysucks (1389)
jkavalik (1387) WebDragon (1384) Soltis (1284) thumbs (1219) backnforth (1208)
MadMerlin|work__ (1193) sehh (1181) oluranti (1176) mgriffin (1152) JimmyNeutron (1143)

By the way, there were 884 other nicks.

Most active nicks by hours
  0-5 6-11 12-17 18-23
1 grknight - 249 dragonheart - 387 wlad - 715 wlad - 687
2 dragonheart - 222 sumitlakra - 264 montywi - 598 grknight - 645
3 hanshenrik - 132 AspiringMind - 148 serg - 576 serg - 409
4 salle_ - 123 wlad - 111 sibiria - 436 montywi - 270
5 sibiria - 108 jkavalik_ - 105 lapinrigolo - 389 salle_ - 267
6 sumitlakra - 97 dr-m_ - 96 dr-m_ - 318 ctcx - 173
7 montywi - 93 montywi - 89 grknight - 304 litheum - 170
8 igor - 86 serg - 87 salle_ - 272 sibiria - 150
9 AspiringMind - 85 jak2013 - 69 markusjm - 163 tanj - 127
10 hehehe - 80 Xgc_ - 62 danblack - 162 ionas - 121

Big numbers
Is azathoth99 stupid or just asking too many questions? 47.3% lines contained a question!
ws2k3 didn't know that much either. 43.4% of his/her lines were questions.
The loudest one was donttrustem_, who yelled 16.3% of the time!
Another old yeller was Barnerd_, who shouted 14.4% of the time!
It seems that NOC-Russ's shift-key is hanging: 4.2% of the time he/she wrote UPPERCASE.
For example, like this:
     <NOC-Russ> END IF;

mcdoogell just forgot to deactivate his/her Caps-Lock. He/She wrote UPPERCASE 2.9% of the time.
Nobody beat anyone up. Everybody was friendly.
DeadToo brings happiness to the world. 24.5% lines contained smiling faces. :)
FinalX isn't a sad person either, smiling 22.8% of the time.
donttrustem_ seems to be sad at the moment: 9.3% lines contained sad faces. :(
Peasant65 is also a sad person, crying 8.3% of the time.
hojuruku wrote the longest lines, averaging 158.4 letters per line.
#maria average was 71.7 letters per line.
musclewhite wrote the shortest lines, averaging 24.6 characters per line.
hehehe was tight-lipped, too, averaging 26.7 characters.
grknight spoke a total of 14988 words!
grknight's faithful follower, wlad, didn't speak so much: 14433 words.
dexcs wrote an average of 79.00 words per line.
Channel average was 12.46 words per line.

Most used words
 Word Number of Uses Last Used by
1 mariadb 1663 serg
2 there 1137 sumitlakra
3 mysql 1110 serg
4 TABLE 870 sumitlakra
5 server 664 andrei
6 would 642 dr-m_
7 should 599 MariaDBstaff
8 error 505 igor
9 which 455 sumitlakra
10 about 434 markusjm_

Most referenced nicks
 Nick Number of Uses Last Used by
1 grknight 313 igor
2 serg 256 grknight
3 salle_ 208 igor
4 wlad 138 LBV_User
5 montywi 129 dtm_

Most referenced URLs
 URL Number of Uses Last Used by
1 https://mariadb.com/kb/en/mariadb/com_stmt_execute/ 8 lapinrigolo
2 https://jira.mariadb.org/browse/MDEV-10332 6 PGNd
3 https://www.digitalocean.com/community/tutorials/how-to-rese 4 bumbar
4 https://jira.mariadb.org 4 martinus__
5 https://github.com/theGodlessLakra/server/tree/numa_one 4 sumitlakra

Other interesting numbers
Nice opers here, no one got kicked!
ChanServ donated 55 ops in the channel...
Wow, no op was taken on #maria!
wlad always lets us know what he/she's doing: 12 actions!
For example, like this:
     * wlad misuznderstood "normal OS" then :)

Also, montywi tells us what's up with 10 actions.
wlad talks to him/herself a lot. He/She wrote over 5 lines in a row 19 times!
Another lonely one was montywi, who managed to hit 13 times.
Cabanoss- couldn't decide whether to stay or go. 3165 joins during this reporting period!
slushpuppy has quite a potty mouth. 0.6% words were foul language.
For example, like this:
     <slushpuppy> but it will fuck over your fkids

sheml also makes sailors blush, 0.4% of the time.

Latest Topics
Welcome! MariaDB 10.2.7 Stable (GA) is out! - http://mariadb.org - Debian/Ubuntu upgrade & install info: http://goo.gl/KiM2So - Chan logs: http://marialog.archivist.info 36 days ago at 19:02 by dbart
Welcome! MariaDB 10.2.6 Stable (GA) is out! - http://mariadb.org - Debian/Ubuntu upgrade & install info: http://goo.gl/KiM2So - Chan logs: http://marialog.archivist.info 86 days ago at 08:55 by dbart
Welcome! MariaDB 10.1.22 Stable (GA) is out! - http://mariadb.org - Debian/Ubuntu upgrade & install info: http://goo.gl/KiM2So - Chan logs: http://marialog.archivist.info 156 days ago at 17:01 by dbart
The topic was set 4 times.
Total number of lines: 110631.

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