Conversation
Notices
-
age doesn't matter, some stats about amount of #conversations on some SN instances: indy.im has 18.4 mio, quitter.se has 1.9 mio, status.jbfavre.org has 1.4 mio, micro.fragdev.com has 0.5 mio
-
rainbowdash.net has 3 mio conversations, added to comparison of SN instances: http://federation.skilledtests.com/select_your_server.html
-
@boneidol@indy.im can you share more info about your database (with 18.4 mio conversations)? asking because e.g. @jpope@micro.fragdev.com (who had in January 0.5 mio conversations) said "retired due to mysql blowing up"
-
@coffecream@rainbowdash.net who's the admin of RDN? I'd ask also him what the infrastructure of your SN is, since you guys have 3 mio conversations so far
-
@erkanyilmaz You're looking for @ceruleanspark@rainbowdash.net
erkanyilmaz likes this. -
@coffeecream OMG I LOVE YOUR AVATAR!!! <3 <3 <3
-
@erkanyilmaz What was it you wanted to know about?
-
@erkanyilmaz Last I remember, before the upgrade there were closer to 400k conversations. 3 million definitely isn't right either way, since we have about that many posts total on the site.
erkanyilmaz likes this. -
basically, if you've just a standard LAMP configuration or something special. Though after some discussion @jpope's SN condition must have also had other influences contributing (traffic, ...)
-
hm, ok. I am looking e.g. at http://rainbowdash.net/conversation/3070621 - let's find out via #SQL? select count(*) from conversation;
-
ok, seems this shows it already: http://rainbowdash.net/conversation/3070620 if there are no private messages there hidden, also normal messages are counted into the conv. stat
-
@erkanyilmaz For #MySQL or #MariaDB, I think other database-using sites / processes on the server would also matter.
-
@erkanyilmaz Cloudflare, then nginx for our webserver, PHP-FPM for PHP, using APC as an opcode cache. Percona MySQL for the database, with memcached as a cache.
erkanyilmaz likes this. -
thx very much for the details, long live the #PONYverse :-)
-
@erkanyilmaz mysql> select count(*) from conversation;
+----------+
| count(*) |
+----------+
| 867158 |
+----------+
1 row in set (0.10 sec)erkanyilmaz likes this. -
hm, not sure anymore... on this SN: "SELECT count( * ) FROM conversation" gives 233k (verified on UI with newest thread oracle.skilledtests.com/conversation/233714) while e.g. notice count is 390k: oracle.skilledtests.com/notice/390053 cc @question
-
Hej Erkan! not affect structure of the trace in link 1408 were only #protecting the whales have #friends - who were not for a time I had a good thing for him to make a difference oh young #bot any #robot overlord do ya think Im crazy I smile at the end - and so he could have done with it - and it seems - that user changed name to New Bohemians (btw: it's been 30 years - and 71 long days since Richard Stallman launched the GNU Project) | my friend nearly cried when hearing this song: 那英 - 征服
-
