Join us now at the IRC channel.
| -->rianne__ (~rianne@host81-154-169-2.range81-154.btcentralplus.com) has joined #techbytes | Jan 26 00:30 | |
| <--rianne has quit (Quit: Konversation terminated!) | Jan 26 00:30 | |
| schestowitz | the encoding in the last attachment of links was wrong, but I was able to manually search and replace (in Kate) to substitute the invalid characters | Jan 26 04:13 |
|---|---|---|
| schestowitz | prior to that I tried opening the file as various different encodings/charsets | Jan 26 04:13 |
| schestowitz | Re: Microsoft vs. IRS> https://www.propublica.org/article/the-irs-decided-to-get-tough-against-microsoft-microsoft-got-tougher?utm_content=buffer9b714&utm_medium=social&utm_source=twitter&utm_campaign=ProPublica+Main | Jan 26 04:19 |
| schestowitz | Techritghs covered it the same day: | Jan 26 04:19 |
| schestowitz | http://techrights.org/2020/01/23/microsoft-distractions/ | Jan 26 04:19 |
| -TechBytesBot/#techbytes-www.propublica.org | The IRS Decided to Get Tough Against Microsoft. Microsoft Got Tougher. — ProPublica | Jan 26 04:19 | |
| -TechBytesBot/#techbytes-techrights.org | Distractions From Microsoft’s Gigantic Tax Evasion and Contribution to Denial of Climate Science | Techrights | Jan 26 04:19 | |
| schestowitz | >>>> I think it's wordpress.posts that takes up all the time. It needs to | Jan 26 04:21 |
| schestowitz | >>>> scan like 6GB in that table alone. Is there an option for skipping a | Jan 26 04:21 |
| schestowitz | >>>> table? I have not checked. | Jan 26 04:21 |
| schestowitz | >>> Maybe the --fast option would help? After all if the table closed | Jan 26 04:21 |
| schestowitz | >>> properly, it should be ok. Then again with a crash, few if any closed | Jan 26 04:21 |
| schestowitz | >>> properly: | Jan 26 04:21 |
| schestowitz | >>> | Jan 26 04:21 |
| schestowitz | >>> https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html | Jan 26 04:21 |
| schestowitz | >>> | Jan 26 04:21 |
| schestowitz | >>> https://mariadb.com/kb/en/mysqlcheck/ | Jan 26 04:21 |
| schestowitz | >> It's not open connections that cause issues that are severe. | Jan 26 04:21 |
| -TechBytesBot/#techbytes-dev.mysql.com | MySQL :: MySQL 8.0 Reference Manual :: 4.5.3 mysqlcheck — A Table Maintenance Program | Jan 26 04:21 | |
| schestowitz | >> | Jan 26 04:21 |
| schestowitz | >> The other day, due to our album's issue (see IRC for pasted | Jan 26 04:21 |
| -TechBytesBot/#techbytes-mariadb.com | mysqlcheck - MariaDB Knowledge Base | Jan 26 04:21 | |
| schestowitz | >> support-related text :-)), I worked on repairing some schestowitz.com | Jan 26 04:21 |
| schestowitz | >> DBs (there are over 20 DBs). All the issues were associated with open | Jan 26 04:21 |
| schestowitz | >> connection, but the album actually failed to work because of the | Jan 26 04:21 |
| schestowitz | >> webhost, which gave /tmp too little space. | Jan 26 04:21 |
| schestowitz | >> | Jan 26 04:21 |
| schestowitz | >> AFAIK, wordpress.posts never had any issues reported/repaired. | Jan 26 04:21 |
| schestowitz | >> wordpress.users was likely closest to it. | Jan 26 04:21 |
| schestowitz | >> | Jan 26 04:21 |
| schestowitz | >> When you ran repair operations from the command line you can probably | Jan 26 04:21 |
| schestowitz | >> see which table makes the process 'hang' for a long time. | Jan 26 04:21 |
| schestowitz | > | Jan 26 04:21 |
| schestowitz | > There is a --analyse option, but I'm not familiar with it. | Jan 26 04:21 |
| schestowitz | > | Jan 26 04:21 |
| schestowitz | >> ... | Jan 26 04:21 |
| schestowitz | >>> Shall we do a test run of the existing script tomorrow to see how long | Jan 26 04:22 |
| schestowitz | >>> it takes on a healthy system? | Jan 26 04:22 |
| schestowitz | >> Sure, but I hope this won't mean 45 mins of downtime. afaik, this | Jan 26 04:22 |
| schestowitz | >> process which is run as su cannot be aborted halfway through. | Jan 26 04:22 |
| schestowitz | >> | Jan 26 04:22 |
| schestowitz | >> Can the DB be merely checked (scanned, RO) while httpd is up and running | Jan 26 04:22 |
| schestowitz | >> with mysqld serving pages? | Jan 26 04:22 |
| schestowitz | > Perhaps, though it does lock each table. The question is if it is more | Jan 26 04:22 |
| schestowitz | > than one table at a time and what kind of lock. The manual page makes | Jan 26 04:22 |
| schestowitz | > no mention of locking though. | Jan 26 04:22 |
| schestowitz | > | Jan 26 04:22 |
| schestowitz | >> The main goal is to assure data integrity while not compromising uptime. | Jan 26 04:22 |
| schestowitz | >> | Jan 26 04:22 |
| schestowitz | >> Tracy is the one who taught me to stop httpd when working on the DB. | Jan 26 04:22 |
| schestowitz | >> That was a looong time ago. | Jan 26 04:22 |
| schestowitz | >> | Jan 26 04:22 |
| schestowitz | > Yes, not having the SQL daemon trying to do multiple things at once | Jan 26 04:22 |
| schestowitz | > should speed up the repairs. That goes by extension into hard disk | Jan 26 04:22 |
| schestowitz | > activity too. So not quitting the HTTP daemon might slow it down | Jan 26 04:22 |
| schestowitz | > drastically. | Jan 26 04:22 |
| schestowitz | > It took about too long in searching but here's the non-YouTube edition> | Jan 26 04:29 |
| schestowitz | > https://lbry.tv/@TheLinuxGamer:f/the-linux-kernel-is-no-longer-free:a | Jan 26 04:29 |
| -TechBytesBot/#techbytes-lbry.tv | The Linux Kernel is no longer Free Software? | Jan 26 04:29 | |
| schestowitz | I thought it might have the text. | Jan 26 04:29 |
| schestowitz | > It wouldn't hurt to post that too so as he gets a little more publicity. | Jan 26 04:29 |
| schestowitz | > Apparently LBRY pays way more than YT. | Jan 26 04:29 |
| schestowitz | Not hard to beat YT at that. | Jan 26 04:29 |
| schestowitz | YT pay is laughable. They pay pittance. It's not even worth the time setting up unless you get millions of views per video. | Jan 26 04:29 |
| schestowitz | Those who can >really< profit from YT are spammers/astroturfers/marketers, nowadays dubbed (by themselves) "influeners". | Jan 26 04:29 |
| schestowitz | >>> Which links specifically? I can look at them in detail but I've just | Jan 26 04:35 |
| schestowitz | >>> taken a quick look in both Chromium and Firefox and am not able to | Jan 26 04:35 |
| schestowitz | >>> reproduce any errors in encoding or rendering. | Jan 26 04:35 |
| schestowitz | >> It seems to impact the first (manual) part in particular. Open the | Jan 26 04:35 |
| schestowitz | >> original and see if the invalid chars show up (showing as a wrong | Jan 26 04:35 |
| schestowitz | >> sequence for utf8 or others), depending perhaps on the editor used. | Jan 26 04:35 |
| schestowitz | > I've double-checked the original, manual page but it looks ok here. I | Jan 26 04:35 |
| schestowitz | > use vi to fill it in and then run the scripts over it to remove empty | Jan 26 04:35 |
| schestowitz | > branches, merge it with the automated links, and remove duplicates | Jan 26 04:35 |
| schestowitz | > | Jan 26 04:35 |
| schestowitz | > Just in case it was corrupted in transmission, I've reattached it. | Jan 26 04:35 |
| schestowitz | Oops. I think there was a misunderstanding. I was referring to yesterday's links, not today's. | Jan 26 04:35 |
| schestowitz | I actually drafted my message about 16 hours ago but only sent it an hour ago when I finally opened thunderbird. I sent is along with the IRC temp0late. | Jan 26 04:35 |
| schestowitz | > Good topic for the repost: | Jan 26 04:37 |
| schestowitz | > | Jan 26 04:37 |
| schestowitz | > http://techrights.org/2020/01/25/linux-kernel-drm-video/ | Jan 26 04:37 |
| schestowitz | > | Jan 26 04:37 |
| schestowitz | > I would have hoped that the LBRY option would be mentioned, too, or | Jan 26 04:37 |
| -TechBytesBot/#techbytes-techrights.org | The Linux Kernel is No Longer Free Software? | Techrights | Jan 26 04:37 | |
| schestowitz | > instead of the YT option: | Jan 26 04:37 |
| schestowitz | > | Jan 26 04:37 |
| schestowitz | > https://lbry.tv/@TheLinuxGamer:f/the-linux-kernel-is-no-longer-free:a | Jan 26 04:37 |
| -TechBytesBot/#techbytes-lbry.tv | The Linux Kernel is no longer Free Software? | Jan 26 04:37 | |
| schestowitz | I have added a link to that. | Jan 26 04:38 |
| schestowitz | >> YT pay is laughable. They pay pittance. It's not even worth the time | Jan 26 04:39 |
| schestowitz | >> setting up unless you get millions of views per video. | Jan 26 04:39 |
| schestowitz | >> | Jan 26 04:39 |
| schestowitz | >> Those who can >really< profit from YT are | Jan 26 04:39 |
| schestowitz | >> spammers/astroturfers/marketers, nowadays dubbed (by themselves) | Jan 26 04:39 |
| schestowitz | >> "influeners". | Jan 26 04:39 |
| schestowitz | > Or the nazis, islamists, and other harmful elements using YT to fish for | Jan 26 04:39 |
| schestowitz | > recruits and sympathizers. | Jan 26 04:39 |
| schestowitz | Lunduke is selling ''time/space' to advertisers, so they impact his actual output and take up people's time. | Jan 26 04:39 |
| schestowitz | >>> Just in case it was corrupted in transmission, I've reattached it. | Jan 26 04:43 |
| schestowitz | >> Oops. I think there was a misunderstanding. I was referring to | Jan 26 04:43 |
| schestowitz | >> yesterday's links, not today's. | Jan 26 04:43 |
| schestowitz | >> | Jan 26 04:43 |
| schestowitz | >> I actually drafted my message about 16 hours ago but only sent it an | Jan 26 04:43 |
| schestowitz | >> hour ago when I finally opened thunderbird. I sent is along with the IRC | Jan 26 04:43 |
| schestowitz | >> temp0late. | Jan 26 04:44 |
| schestowitz | >> | Jan 26 04:44 |
| schestowitz | > Ah. I see the problems with the 2020-01-25-merged.html file but not the | Jan 26 04:44 |
| schestowitz | > manual file that was fed into it. I haven't changed the scripts to | Jan 26 04:44 |
| schestowitz | > speak of lately at least not in regards to character sets. It might | Jan 26 04:44 |
| schestowitz | > take some investigation. | Jan 26 04:44 |
| schestowitz | Last time such a thing happened was over a month ago, so it might be a rare oddity rather than that norm. It takes me less than 5 minutes to fix it manually, so no big deal... | Jan 26 04:44 |
| schestowitz | I thought I should utter something to at least make you aware. | Jan 26 04:44 |
| schestowitz | >> Ah. I see the problems with the 2020-01-25-merged.html file but not the | Jan 26 05:27 |
| schestowitz | >> manual file that was fed into it. I haven't changed the scripts to | Jan 26 05:27 |
| schestowitz | >> speak of lately at least not in regards to character sets. It might | Jan 26 05:27 |
| schestowitz | >> take some investigation. | Jan 26 05:27 |
| schestowitz | > It's something in the links-cull-empty.pl script, but that has not been | Jan 26 05:27 |
| schestowitz | > changed since November. I'm looking into it later today. | Jan 26 05:27 |
| schestowitz | Maybe one single bad char from the input throws it off course, silently... | Jan 26 05:27 |
| schestowitz | >> I thought I should utter something to at least make you aware. | Jan 26 05:29 |
| schestowitz | >> | Jan 26 05:29 |
| schestowitz | > Thanks. It's good to know about the defects. I've just now tried six | Jan 26 05:29 |
| schestowitz | > permutations of settings what used to fix the problem but it has no | Jan 26 05:29 |
| schestowitz | > effect on that particular batch for some very strange reason. I'll try | Jan 26 05:29 |
| schestowitz | > again later today. | Jan 26 05:29 |
| schestowitz | The links are essential as they make the site's scope vast without incurring much (time) toll on me, so I can still focus on researching and writing about patents and FOSS. Which are areas I understand a bit better.... | Jan 26 05:29 |
| schestowitz | looks like there's a match here at 1pm (FA Cup), so the tram back home would be packed. Can we possible meet tomorrow instead? | Jan 26 05:29 |
| schestowitz | https://pleroma.site/notice/9rN0cLBLuKzoq2Izzs | Jan 26 05:31 |
| -TechBytesBot/#techbytes-pleroma.site | Pleroma | Jan 26 05:31 | |
| schestowitz | " That just makes it even more inexcusable that some demon^H^H^H^H^Hmarketing exec isn't allocating funds right now for the dirt-cheap publicity they're now receiving." | Jan 26 05:31 |
| schestowitz | https://pleroma.site/notice/9rN46EK0HM366wIPHk | Jan 26 05:31 |
| schestowitz | " | Jan 26 05:31 |
| schestowitz | Depending on what data the individual school collects, some principal could feel tempted to sell them to marketing companies or the like. | Jan 26 05:31 |
| schestowitz | Building a trough attracts pigs. | Jan 26 05:31 |
| schestowitz |  | Jan 26 05:31 |
| -TechBytesBot/#techbytes-pleroma.site | Pleroma | Jan 26 05:31 | |
| schestowitz | " | Jan 26 05:31 |
| schestowitz | https://pleroma.site/notice/9rN6cBMT1KAc6YoP1E | Jan 26 05:32 |
| schestowitz | " | Jan 26 05:32 |
| schestowitz | @schestowitz @anornymorse | Jan 26 05:32 |
| schestowitz | Grupo Modelo belongs to Anheuser-Busch InBev. | Jan 26 05:32 |
| schestowitz | The company owns Grupo Modelo, Mexico’s leading brewer and owner of the Corona brand as of 4 June 2013. This transaction was valued at US$20.1 billion. To satisfy US anti-trust demands, Grupo Modelo sold its US business, including US brand rights and the Piedras Negras Brewery in Mexico, for approx. US$4.75 billion to Constellation Brands, a competitor of AB Inbev in some beverage sectors.[28] | Jan 26 05:32 |
| -TechBytesBot/#techbytes-pleroma.site | Pleroma | Jan 26 05:32 | |
| schestowitz | Additionally, the group has a 51% controlling stock on Cerveceria Nacional Dominicana through the AmBev division. | Jan 26 05:32 |
| schestowitz | ' | Jan 26 05:32 |
| -->Klem_von_Met (~Klem_von_@ool-4579f809.dyn.optonline.net) has joined #techbytes | Jan 26 06:23 | |
| <--schestowitz has quit (Remote host closed the connection) | Jan 26 10:41 | |
| -->schestowitz (~roy@unaffiliated/schestowitz) has joined #techbytes | Jan 26 10:41 | |
| <--Klem_von_Met has quit (Ping timeout: 240 seconds) | Jan 26 11:38 | |
| <--X-Scale has quit (Ping timeout: 260 seconds) | Jan 26 12:50 | |
| -->X-Scale` (~ARM@131.61.158.5.rev.vodafone.pt) has joined #techbytes | Jan 26 12:51 | |
| ---X-Scale` is now known as X-Scale | Jan 26 12:51 | |
| <--X-Scale has quit (Ping timeout: 265 seconds) | Jan 26 13:01 | |
| -->X-Scale` (~ARM@92.250.99.4) has joined #techbytes | Jan 26 13:02 | |
| ---X-Scale` is now known as X-Scale | Jan 26 13:03 | |
| <--schestowitz has quit (Remote host closed the connection) | Jan 26 13:31 | |
| -->schestowitz (~roy@unaffiliated/schestowitz) has joined #techbytes | Jan 26 13:32 | |
| <--schestowitz has quit (Remote host closed the connection) | Jan 26 13:49 | |
| -->schestowitz (~roy@unaffiliated/schestowitz) has joined #techbytes | Jan 26 13:51 | |
| <--oiaohm has quit (Read error: Connection reset by peer) | Jan 26 20:18 | |
| -->oiaohm (~oiaohm@unaffiliated/oiaohm) has joined #techbytes | Jan 26 20:19 | |
| -->Klem_von_Met (~Klem_von_@ool-4579f809.dyn.optonline.net) has joined #techbytes | Jan 26 21:02 | |
| <--Klem_von_Met has quit (Ping timeout: 260 seconds) | Jan 26 22:03 | |
Generated by irclog2html.py 2.6 by Marius Gedminas - find it at mg.pov.lt!