#mysql @ freenode stats by mapreri

Statistics generated on Tuesday 1 August 2023 - 21:37:40
During this 2-day reporting period, a total of 65 different nicks were represented on #mysql.


Daily activity (last 2 days)
1901
54
45
1195
29
33
1 0
0-5 = 0-5 6-11 = 6-11 12-17 = 12-17 18-23 = 18-23

Most active times
4.1%
128
3.9%
120
3.0%
93
3.2%
98
3.4%
106
2.9%
89
3.0%
93
2.8%
87
2.7%
85
3.6%
111
3.7%
115
2.3%
70
0% 3.0%
93
2.9%
90
4.5%
139
10.5%
326
6.8%
211
3.2%
98
5.5%
171
5.1%
157
4.1%
127
9.0%
279
6.8%
210
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 salle19228672 19919228672 228111.567.0today"treeprogram: Databases are not spreadsheets by the way"
2 javalover174 174174 14738.541.3today"i'm just like creataSQLALL($tablenames);"
3 Xgc2048 682048 82512.169.3yesterday"linagee: INDEX (date, time)"
4 NET||abuse1248 601248 84414.177.7today"a one to many relationsihp?"
5 ebergen851 59851 3986.735.1today"it isn't completely covered but that isn't a terrible index"
6 guideX51 5151 78715.483.7yesterday"salle: the app complaining about the missing table"
7 Naktibalda9304 439304 3247.540.3today"anew: you said that they aren't :)"
8 seekwill336 39336 3338.547.3today"track7: Well, that'll be a problem"
9 adaro35 3535 47613.669.3today"how bad will that filesort be"
10 anew278 35278 43512.467.2yesterday"xgc but what i want has nothing to do with id..."
11 thumbs2211 3412211 2407.141.2today"krizoek: #php forwards to ##php anyway"
12 jtm31 3131 2156.939.8today"Eh that was from me before, I don't see anything actually."
13 amichair524 29524 42514.784.3today"salle: charset is encoding, collation is comparison, no?"
14 track727 2727 1806.738.2today"$email=$_POST['email']; $email=$_POST['email', NOW() ];"
15 hactor23 2323 30613.374.2today"Hey folks I use Navicat to browse my tables. I have all-UTF8 s..."
16 linagee21 2121 46922.3116.7yesterday"if I have a column called "date" and one called "time" (both h..."
17 Dovid21 2121 37617.988.1today"Hi. Can Anyone explain this to me? http://pastebin.com/H00MFnC..."
18 treeprogram19 1919 31516.687.7today"salle: so I should use a spreadsheet instead?"
19 torontoyes18 1818 18810.457.2yesterday"thumbs: reading up on EXPLAIN"
20 ubiquity_bot3365 173365 34520.3140.7today"OS error code 23: Too many open files in system"
21 mooncup14 1414 725.126.4yesterday"so it works with unreal's weird bans"
22 fritzroy1512 1212 16713.986.7today"but thanks for confirming :)"
23 multi_io11 1111 676.139.2yesterday"mysql -uoklischat -pxxx -h localhost --port=22222"
24 thaifood11 1111 676.131.6yesterday"how can i get rid of 'myuser'@'%' but keep 'myuser'@'localhost'"
25 VSpike92 1192 22820.7117.7today"Wierd. I have a master with several slaves. One of them is abo..."


These didn't make it to the top:
danblack (10) medusaXX (10) kgore (10) threnody (9) ircfox (9)
dupondje (9) martinrame (8) ModFather (8) johnleee (8) mgriffin (8)
ccha (8) mdoge (7) mrlnx (7) navetz (7) biggi_mat (6)
OrNix (6) kate_r_ (6) aias (6) charlie_sanders (5) diginet (5)
Bear10 (3) ikonia (3) elshaa (3) reversiblean (3) paul_uk (3)
somnium (2) AppError (2) OnkelTem (2) jthurman (2) altometer (2)

By the way, there were 10 other nicks.

Most active nicks by hours
  0-5 6-11 12-17 18-23
1 seekwill - 33 salle - 22 javalover - 174 salle - 72
2 track7 - 27 treeprogram - 19 salle - 86 ebergen - 51
3 hactor - 23 NET||abuse - 12 NET||abuse - 48 guideX - 51
4 Dovid - 21 VSpike - 9 Naktibalda - 30 Xgc - 48
5 salle - 19 dupondje - 9 anew - 27 adaro - 35

Big numbers
Is torontoyes stupid or just asking too many questions? 44.4% lines contained a question!
amichair didn't know that much either. 41.4% of his/her lines were questions.
The loudest one was linagee, who yelled 9.5% of the time!
Another old yeller was Naktibalda, who shouted 9.3% of the time!
It seems that Naktibalda's shift-key is hanging: 2.3% of the time he/she wrote UPPERCASE.
For example, like this:
     <Naktibalda> SELECT DATE_SUB(NOW() , INTERVAL 1 MONTH);
Nobody beat anyone up. Everybody was friendly.
linagee brings happiness to the world. 19.0% lines contained smiling faces. :)
amichair isn't a sad person either, smiling 13.8% of the time.
linagee seems to be sad at the moment: 14.3% lines contained sad faces. :(
jtm is also a sad person, crying 9.7% of the time.
ubiquity_bot wrote the longest lines, averaging 140.7 letters per line.
#mysql average was 63.6 letters per line.
ebergen wrote the shortest lines, averaging 35.1 characters per line.
track7 was tight-lipped, too, averaging 38.2 characters.
salle spoke a total of 2281 words!
salle's faithful follower, javalover, didn't speak so much: 1473 words.
jthurman wrote an average of 63.00 words per line.
Channel average was 11.57 words per line.

Users with most nicknames
 Nick Names Used
1 Bennish_disconne (3 names) Bennish_disconne, Bennish_gone, Bennish
2 Butt3rfly (2 names) Butt3rfly, Ametrine
3 Shakyj (2 names) Shakyj, Shakyj^
4 kate_r_ (2 names) kate_r_, kate__r
5 MarkyC (2 names) MarkyC, MarkyC_

Most active gender
 GenderNumber of linesNick
1 Male 1 1 mapreri (1)

Most used words
 Word Number of Uses Last Used by
1 table 106 salle
2 mysql 94 kate_r_
3 there 68 Naktibalda
4 select 62 salle
5 about 40 salle
6 Which 39 treeprogram
7 using 38 salle
8 column 38 treeprogram
9 tables 36 kate_r_
10 would 36 kate_r_

Most referenced nicks
 Nick Number of Uses Last Used by
1 salle 89 kate_r_
2 javalover 85 NET||abuse
3 anew 33 Xgc
4 Xgc 30 linagee
5 amichair 27 salle

Smileys :-)
 Smiley Number of Uses Last Used by
1 :) 42 NET||abuse
2 ): 6 ubiquity_bot
3 :-) 5 amichair
4 :( 3 hactor
5 :D 3 adaro
6 ;) 2 Dovid
7 :P 1 hactor
8 :-/ 1 linagee
9 \o/ 1 seekwill

Most referenced URLs
 URL Number of Uses Last Used by
1 http://www.parseerror.com/sql/select*isevil.html 4 ubiquity_bot
2 http://pastebin.com/3v5cs79i 2 Xgc
3 http://pastie.org/9717660 1 diginet
4 http://pastie.org/9717770 1 salle
5 http://pastie.org/private/udwppoznhhzsxkj8yhhwgw 1 paul_uk

Other interesting numbers
Nice opers here, no one got kicked!
Strange, no op was given on #mysql!
Wow, no op was taken on #mysql!
Strange, no voices were given on #mysql!
No voices were taken on #mysql!
mgriffin always lets us know what he/she's doing: 1 actions!
For example, like this:
     * mgriffin dislikes ubuntu 14.04
jtm talks to him/herself a lot. He/She wrote over 5 lines in a row 1 times!
Another lonely one was mdoge, who managed to hit 1 times.
Hakaslak couldn't decide whether to stay or go. 77 joins during this reporting period!
javalover has quite a potty mouth. 0.1% words were foul language.
For example, like this:
     <javalover> table 1 is fucking unique that's why

Latest Topics
A topic was never set on this channel.
Total number of lines: 3096.