Searching from 2023-11-18 00:00:00 to 2023-11-18 23:59:59.999999.
Query completed in 0.48 seconds
[2023-11-18 00:55:24] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 00:56:55] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 00:59:05] --> Armanelgtron has joined the channel
[2023-11-18 00:59:06] -!- lead.libera.chat set mode #armagetron +nt
[2023-11-18 00:59:06] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-11-18 00:59:38] --> Armanelgtron has joined the channel
[2023-11-18 00:59:38] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-11-18 00:59:38] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-11-18 00:59:40] -!- weber.oftc.net set mode #armagetron +nt
[2023-11-18 00:59:40] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-11-18 01:07:16] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 01:10:56] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 01:12:08] --> Armanelgtron has joined the channel
[2023-11-18 01:12:08] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-11-18 01:12:08] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-11-18 01:12:10] -!- weber.oftc.net set mode #armagetron +nt
[2023-11-18 01:12:10] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-11-18 01:12:26] --> Armanelgtron has joined the channel
[2023-11-18 01:12:27] -!- mercury.libera.chat set mode #armagetron +nt
[2023-11-18 01:12:27] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-11-18 02:00:16] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 02:01:36] <-- Armanelgtron has quit (No Ping reply in 210 seconds.)
[2023-11-18 02:04:43] --> Armanelgtron has joined the channel
[2023-11-18 02:04:45] -!- iridium.libera.chat set mode #armagetron +nt
[2023-11-18 02:04:45] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-11-18 02:05:31] --> Armanelgtron has joined the channel
[2023-11-18 02:05:31] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-11-18 02:05:31] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-11-18 02:05:32] -!- weber.oftc.net set mode #armagetron +nt
[2023-11-18 02:05:32] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-11-18 02:45:22] --> armagetronbridge has joined the channel
[2023-11-18 02:55:10] <Lucifer_arma> aaaaaaand indexes are awesome! Apparently the reason my poor database was having a nervous breakdown was because I forgot to add indexes to the two biggest tables
[2023-11-18 02:55:11] <armagetronbridge> 10irc:Lucifer_arma| aaaaaaand indexes are awesome! Apparently the reason my poor database was having a nervous breakdown was because I forgot to add indexes to the two biggest tables
[2023-11-18 02:55:14] <Lucifer_arma> um, oops
[2023-11-18 02:55:14] <armagetronbridge> 10irc:Lucifer_arma| um, oops
[2023-11-18 02:55:29] <Lucifer_arma> now it's gone from average load of 15.x down to 1.x
[2023-11-18 02:55:29] <armagetronbridge> 10irc:Lucifer_arma| now it's gone from average load of 15.x down to 1.x
[2023-11-18 02:56:10] <Lucifer_arma> now, I don't understand how it got all the way up to 15.x, since it's 8 cores, and my understanding is that 8.0 would be all 8 cores at maximum capacity
[2023-11-18 02:56:11] <armagetronbridge> 10irc:Lucifer_arma| now, I don't understand how it got all the way up to 15.x, since it's 8 cores, and my understanding is that 8.0 would be all 8 cores at maximum capacity
[2023-11-18 02:58:20] <Lucifer_arma> but I think I can say the reason it dropped so low is because I also did some performance tuning in config files, so now it's using a shitload of memory more than it was using before
[2023-11-18 02:58:20] <armagetronbridge> 10irc:Lucifer_arma| but I think I can say the reason it dropped so low is because I also did some performance tuning in config files, so now it's using a shitload of memory more than it was using before
[2023-11-18 02:59:36] <Lucifer_arma> until I hit the next dumb bottleneck (no doubt another table I forgot to create indexes on), it looks like I should be able to scale up over 20 worker nodes with this database before I have to consider upgrading it or creating a cluster for it
[2023-11-18 02:59:37] <armagetronbridge> 10irc:Lucifer_arma| until I hit the next dumb bottleneck (no doubt another table I forgot to create indexes on), it looks like I should be able to scale up over 20 worker nodes with this database before I have to consider upgrading it or creating a cluster for it
[2023-11-18 03:38:56] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 03:39:37] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 03:44:12] --> Armanelgtron has joined the channel
[2023-11-18 03:44:12] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-11-18 03:44:12] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-11-18 03:44:14] -!- weber.oftc.net set mode #armagetron +nt
[2023-11-18 03:44:14] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-11-18 03:44:14] --> Armanelgtron has joined the channel
[2023-11-18 03:44:15] -!- zirconium.libera.chat set mode #armagetron +nt
[2023-11-18 03:44:15] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-11-18 06:40:17] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 06:43:28] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 06:44:44] --> Armanelgtron has joined the channel
[2023-11-18 06:44:45] -!- zirconium.libera.chat set mode #armagetron +nt
[2023-11-18 06:44:45] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-11-18 06:45:11] --> Armanelgtron has joined the channel
[2023-11-18 06:45:11] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-11-18 06:45:11] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-11-18 06:45:12] -!- weber.oftc.net set mode #armagetron +nt
[2023-11-18 06:45:12] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-11-18 09:26:44] --> monr0e has joined the channel
[2023-11-18 10:35:58] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 10:35:58] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 10:38:30] --> Armanelgtron has joined the channel
[2023-11-18 10:38:31] -!- zirconium.libera.chat set mode #armagetron +nt
[2023-11-18 10:38:31] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-11-18 10:39:27] --> Armanelgtron has joined the channel
[2023-11-18 10:39:27] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-11-18 10:39:27] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-11-18 10:39:29] -!- weber.oftc.net set mode #armagetron +nt
[2023-11-18 10:39:29] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-11-18 11:55:58] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 11:57:04] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 11:59:19] --> Armanelgtron_ has joined the channel
[2023-11-18 11:59:19] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-11-18 11:59:19] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-11-18 11:59:19] -!- Armanelgtron changed nick to Guest7441
[2023-11-18 11:59:19] -!- Armanelgtron changed nick to Armanelgtron
[2023-11-18 11:59:21] -!- weber.oftc.net set mode #armagetron +nt
[2023-11-18 11:59:21] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-11-18 11:59:22] --> Armanelgtron has joined the channel
[2023-11-18 11:59:23] -!- silver.libera.chat set mode #armagetron +nt
[2023-11-18 11:59:23] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-11-18 11:59:45] <-- Guest7441 has quit (Ping timeout: 480 seconds)
[2023-11-18 14:42:30] <armagetron-bridge> 07discord:Nanu| indexes are great, I have close to 100m tron positional logs stored and querying that table started to make my server explode before I indexed it
[2023-11-18 14:42:30] <armagetronbridge> 07discord:Nanu| indexes are great, I have close to 100m tron positional logs stored and querying that table started to make my server explode before I indexed it
[2023-11-18 15:05:33] <armagetron-bridge> 08discord:delinquent| Lucifer_arma You would be surprised how much processing power bulk data transfer requires. It is precisely this reason why indexes exist
[2023-11-18 15:05:33] <armagetronbridge> 08discord:delinquent| Lucifer_arma You would be surprised how much processing power bulk data transfer requires. It is precisely this reason why indexes exist
[2023-11-18 19:26:28] <-- monr0e has quit (Ping timeout: 255 seconds)
[2023-11-18 19:43:51] <armagetron-bridge> 13discord:Juesto| apparently chromium lacks some chrome features
[2023-11-18 19:43:51] <armagetronbridge> 13discord:Juesto| apparently chromium lacks some chrome features
[2023-11-18 19:44:01] <armagetron-bridge> 13discord:Juesto| like memory saver
[2023-11-18 19:44:01] <armagetronbridge> 13discord:Juesto| like memory saver
[2023-11-18 19:44:44] <armagetron-bridge> 13discord:Juesto| @wwnelg build silicon and it will be faster
[2023-11-18 19:44:44] <armagetronbridge> 13discord:Juesto| @wwnelg build silicon and it will be faster
[2023-11-18 19:45:12] <armagetron-bridge> 13discord:Juesto| much faster, because rosetta 2 holds back performance
[2023-11-18 19:45:13] <armagetronbridge> 13discord:Juesto| much faster, because rosetta 2 holds back performance
[2023-11-18 22:36:20] <Lucifer_arma> Well, in this case, it was the select query that was taking up all the processing power. It was getting hit with 12 of the exact same queries at the same time (different parameters, same query otherwise)
[2023-11-18 22:36:20] <armagetronbridge> 10irc:Lucifer_arma| Well, in this case, it was the select query that was taking up all the processing power. It was getting hit with 12 of the exact same queries at the same time (different parameters, same query otherwise)
[2023-11-18 22:36:33] <Lucifer_arma> and without the index, it had to do a whole table scan.
[2023-11-18 22:36:33] <armagetronbridge> 10irc:Lucifer_arma| and without the index, it had to do a whole table scan.
[2023-11-18 22:36:59] <Lucifer_arma> I had to create three indexes for each of the two tables, one for symbol, interval, and date, where interval is the period in the moving average window
[2023-11-18 22:36:59] <armagetronbridge> 10irc:Lucifer_arma| I had to create three indexes for each of the two tables, one for symbol, interval, and date, where interval is the period in the moving average window
[2023-11-18 22:37:31] <Lucifer_arma> I thought I had already added indexes to these two tables. That's why I was surprised, and a bit perturbed, to be honest.
[2023-11-18 22:37:32] <armagetronbridge> 10irc:Lucifer_arma| I thought I had already added indexes to these two tables. That's why I was surprised, and a bit perturbed, to be honest.
[2023-11-18 22:37:56] <Lucifer_arma> I added them partway through yesterday's run, about 6 hours into it. I'm going to start an unnecessary run today just to see how long it takes.
[2023-11-18 22:37:56] <armagetronbridge> 10irc:Lucifer_arma| I added them partway through yesterday's run, about 6 hours into it. I'm going to start an unnecessary run today just to see how long it takes.
[2023-11-18 22:39:23] <Lucifer_arma> started
[2023-11-18 22:39:23] <armagetronbridge> 10irc:Lucifer_arma| started
[2023-11-18 22:39:33] <Lucifer_arma> (that message is just so I can have a timestamp for when I started it :) )
[2023-11-18 22:39:34] <armagetronbridge> 10irc:Lucifer_arma| (that message is just so I can have a timestamp for when I started it :) )
[2023-11-18 23:00:56] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 23:01:37] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-11-18 23:03:41] --> Armanelgtron_ has joined the channel
[2023-11-18 23:03:41] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-11-18 23:03:41] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-11-18 23:03:41] -!- Armanelgtron changed nick to Guest7487
[2023-11-18 23:03:41] -!- Armanelgtron changed nick to Armanelgtron
[2023-11-18 23:03:43] -!- weber.oftc.net set mode #armagetron +nt
[2023-11-18 23:03:43] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-11-18 23:03:44] --> Armanelgtron has joined the channel
[2023-11-18 23:03:45] -!- zirconium.libera.chat set mode #armagetron +nt
[2023-11-18 23:03:45] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-11-18 23:04:10] <-- Guest7487 has quit (Ping timeout: 480 seconds)
[2023-11-18 23:18:17] <Lucifer_arma> trying again
[2023-11-18 23:18:18] <armagetronbridge> 10irc:Lucifer_arma| trying again
[2023-11-18 23:38:46] <Lucifer_arma> ok, trying AGAIN
[2023-11-18 23:38:46] <armagetronbridge> 10irc:Lucifer_arma| ok, trying AGAIN
[2023-11-18 23:39:23] <Lucifer_arma> note to self: stockanalyst2 can't install its own dependencies that are needed before the "install-dependencies" function gets called
[2023-11-18 23:39:23] <armagetronbridge> 10irc:Lucifer_arma| note to self: stockanalyst2 can't install its own dependencies that are needed before the "install-dependencies" function gets called
View entire month
DISCLAIMER: These logs of public chat may contain some content which may not be appropriate for all audiences. Use at your own risk.
Logs from 2006-2009 pulled from wrtlprnft
Format changes at: 2015-08-25, 2017-02-20, and 2020-03-23. Times (2015 and later) should be Eastern.
• Website was created by nelg
• Design:
» Layout is loosely based on an old design by Durf.
» Icons on the tools page were originally by Royce, new icons added will try to follow some of the design language.
» Various other icon selections include icons from Crystal, crystalsvg, oxygen, and breeze icon themes.
» Other icons: fontawesome
is a site that has tools, maps, and other various items. It orignally only existed as a server control panel, but I slowly began adding stuff such as a homepage and tools.
Gridder
.