#maria @ Freenode stats by MariaDB

Statistics generated on Thursday 14 December 2017 - 6:01:14
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"gunix: write load problem? galera writes on all nodes before ack'"
2 wlad1554429104463646596144339.353.6yesterday"this is where nagle and delayed ack conflict, multiple sends"
3 serg11091229635746601251611.365.72 days ago"database foo is visible, tables can be created all right."
4 montywi105010401263690431181232511.766.66 days ago"but then what is the name for the variable. Can't be -disabled"
5 dragonheart65331155586375907613.981.7today"is pc_flush_slot the coordinator thread? or the worker thread?"
6 salle_678178731693740889713.176.4today"IgorK_: Use LEFT JOIN as dragonheart says and don't forget to add"
7 dr-m_43720715558420804918.4107.5yesterday"sibiria: that reminds me of some prototype I made years ago. It w"
8 sibiria697105452901533789211.362.3today"no matter what sort of topology you approach"
9 sumitlakra40214575251594298760018.9106.9today"just got an idea to fix that"
10 jkavalik_25019602677470818.8108.1yesterday"mpingu, is sku numeric column or does it store text?"
11 PGNd25367015351936414116.4104.135 days ago"serg: Building on my usual box here ..."
12 lapinrigolo492307320856140768.349.839 days ago"in particular: "if (send type to server) [...]""
13 AspiringMind4356341303112788239469.157.544 days ago" AUTH_PLUGIN arg1, arg2;"
14 litheum24812292639392115.893.929 days ago"what exact error do you see after executing that statement?"
15 Ninpo^28236920512731463331011.766.08 days ago"I see thumbs speaks rmbeer"
16 danblack2856278391801326711.568.899 days ago"sounds like an easy check to do. thansk"
17 jkbzh1569052121302619.4108.5114 days ago"but that's another use case. Haproxy can only do this today."
18 hanshenrik2501509642689286511.567.537 days ago"im migrating to a new server... how should i all the mariadb user"
19 salle221802691548952284912.977.3113 days ago"vanch: https://hastebin.com/xijabusoni.rb"
20 LinuxJedi1363091754767283020.8116.29 days ago"ws2k3: ok, what does mysqld's log say about it now?"
21 ctcx217440892273280212.973.171 days ago"With system tables you mean the mysql database?"
22 markusjm276409164668727429.956.751 days ago"with all sensitive information removed, of course"
23 Xgc_164794895136765259015.890.5today"... t1 JOIN t2 ON t1.x = t2.y AND t1.z1 <> t2.z2"
24 Xgc1738613421173242314.084.883 days ago"ERROR 1064 (42000): You have an error in your SQL syntax; check t"
25 hojuruku86921227551396236527.5158.4138 days ago"bugger I keep getting my mariadb go down because of checksum fail"


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> VALUES (

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://mariadb.com/kb/en/mariadb/systemd/ 4 dragonheart
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:
     * vvaintroub_ vaguely recalls these were unicodes

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