@pete-s said in MariaDB/MySQL Table Repair Eating TONS of disk space:

@anthonyh said in MariaDB/MySQL Table Repair Eating TONS of disk space:

I have a MariaDB database that is of moderate size (~48 GB) and two of the tables within this database have corruption. One of the offending tables is reportedly ~25 GB in size. When running REPAIR TABLE, the process eats up all the remaining disk space (which admittedly wasn't a lot, 14 GB).

I started growing the disk and gave it an additional 50 GB. The repair process gobbled it up. Gave it 50 GB more, repair process gobbled it up. Gave it 100 GB more (for a total of 200 GB additional disk), and the repair process still gobbled it all up. I'm a little baffled as to why and am wondering if anyone here can shed some light as to why a 25GB table would need over 200GB of working space for a repair?

The database is using MyISAM storage (I know, I'm working on it) and the table in question stores data (document images) in longblob format. From what I understand, MyISAM table repairs basically involve reconstructing the table, so I wouldn't be surprised at needing at least an equal amount of free space to the size of the table. This behavior has me a little confused.

I assume there are no database clients trying to access the database during your repair.

I don't know the answer to your question but have you had a look at the different settings for repair table?
https://dev.mysql.com/doc/refman/5.7/en/repair-table-optimization.html

Check myisam_max_sort_file_size for instance. If it's larger than your disk then it could outgrow the available space.

You are correct. No clients are accessing the database. I'm doing the repair on a clone of the actual host.

I will investigate myisam_max_sort_file_size and report back.

@jasgot said in Looking to learn/research MeshCentral:

@scottalanmiller said in Looking to learn/research MeshCentral:

Ability to have a large deployment with security built in already and not lose that.

Do you know if it is FIPS 140-2 certified?

Almost certainly not. That is a "pay the government for favours" cert that only big vendors can do. No small project can think about doing stuff like that because there's no way to make money from having done it and it doesn't just cost the developers an arm and a leg, but it directly takes away funding and development time from their actual users. So the developers don't wait to lose the money, and the real world customers don't want them focusing on something that's only for political reasons.

While I don't know 100% that either is certified, I'm certain that they are not and have no interest. It just doesn't make sense financially or ideologically.

@jaredbusch said in So WTF m.2 is this:

@pete-s said in So WTF m.2 is this:

, it's always best to find what Dell part number works.

it's not worth it, sata is sata. no reason to use m.2 when a 2.5 form factor will be just as fast.

That's not what I'm saying. I'm saying that as a general rule you need to look at the Dell's part number to find parts from other manufacturers that are compatible.

But yes I agree that sata is sata. For a desktop/laptop nvme or sata ssd doesn't matter though. Only matters in benchmarks.

@dbeato said in Sophos SSL VPN Client on Windows:

The old one you have to go where the application install and remove the config file you don't want
\Program Files (x86)\Sophos\Sophos SSL VPN Client\config

That's the answer!

Thanks

I got one of these a while back, works pretty good as a mouse/kbd or a remote.

Favormates Air Remote Mouse MX3 Pro,2.4G Backlit Kodi Remote Control,Mini Wireless Keyboard & Infrared Remote Control Learning, Best for Android Smart Tv Box HTPC IPTV PC Pad Xbox Raspberry pi 3 https://www.amazon.com/dp/B01N0SUUZS/

I use PRTG. https://www.paessler.com/es/prtg
Very easy to implement, You can have notifications in your smartphone.

@voip_n00b said in Nextcloud Sync 2.0 brings 10x faster syncing:

https://nextcloud.com/blog/nextcloud-sync-2-0-brings-10x-faster-syncing/

Can you please stop link dumping as a new thread?
It's spam.

It's bad enough when people do it in the news threads.

@dave247 said in best way to map various combinations of mapped drives to AD users?:

@pete-s said in best way to map various combinations of mapped drives to AD users?:

@dave247 said in best way to map various combinations of mapped drives to AD users?:

Problem: we have about 10 different shared folders as mapped drives and a handful of simple bat scripts used as AD logon scripts for users...

I think it would make more sense to just have one mapped drive and use sub directories for each department. That's probably how the files are organized anyway - at least judging from the looks of it.

The users that have permissions to a particular directory can use it and the other can't. That way you don't have to mess with the different drive mappings because everyone get the same one drive.

This also also how I have seen organizations with many departments do it. They basically use one drive mapping per entire file server. Everyone has gets the same shared drive(s) but permissions determine what directories they can access. It's more flexible to do it like that.

Yes actually that's one plan I've had for a long time, just haven't gotten around to doing it mainly since it will disrupt everyone's workflow for a bit.

If you have the directory structure in place, you could do it by adding the new drive share for all departments. Give people a couple of weeks to start using it and then slowly start to remove the older shares one by one. That will force everyone to migrate to using the new share - but not everyone at the same time.

@dbeato said in Unifi Controller Installer Script for Ubuntu 21.04:

@voip_n00b said in Unifi Controller Installer Script for Ubuntu 21.04:

@stacksofplates docker is worse than reddit. I can’t believe you would suggest such hot garbage.

How is it garbage @VoIP_n00b ? It is quite possible if someone wants to run their Controller as a container. I am not sure why you are also comparing Reddit with Docker, what is the comparison?

I think it's an attempt at trolling.

@gjacobse said in Naming discrepancies across Print Servers:

servers without

As a pratical way you would have centralized printing on a CLoud Service but with Windows Servers then you will have to manually match and correct or somehow script it.

@dbeato Thanks. I'll give this a try over the weekend.

@dustinb3403 said in RMM Service:

@fateknollogee said in RMM Service:

@dustinb3403 said in RMM Service:

@fateknollogee said in RMM Service:

@dustinb3403 said in RMM Service:

@fateknollogee said in RMM Service:

@dustinb3403 said in RMM Service:

@fateknollogee said in RMM Service:

Does the patch management in Tactical work or are those buttons just placeholders?

It works. On the demo it appears to be disabled

Have you actually tried it?

Yes I set it up in my lab and used it on some equipment/vms without issue.

I meant have you tried the patch management function?

Yes.

And the machines got patched?
Mine isn't working, that's why I'm asking.

Yeah mine did.

Ditto. Just have to invoke the scan or setup some automation

@stuartjordan said in Hyper V Server - Goodbye:

So No More Hyper-V-Server: https://www.theregister.com/2021/08/31/hyper_v_server_discontinued/

I have been using proxmox and XCP-NG for quite a while now with no issues. Whats your view on this move made by Microsoft. You have support until 2024 on the 2019 edition.

This is sad, but not surprising. You pay per core per month for Azure stack HCI (the replacement) according to what I found quick.

@mr-jones said in Control Panel>Devices and Printers object locations?:

https://mangolassi.it/post/413461

Oh look, G I Jones, I remember that guy.

Anyway, this is adding a network printer... I don't think this helps at all to be honest. Did you misread the post? Am I missing something?

it does have one line that removes a port

Remove-PrinterPort -name $PrinterPort

@dbeato said in MS O365 Autodiscovery: Failing:

@dustinb3403 said in MS O365 Autodiscovery: Failing:

@dbeato said in MS O365 Autodiscovery: Failing:

@dustinb3403 What do you mean disabling autodiscover for a user? Are you talking about a registry key?

No, within O365 you can either selectively disable authentication protocols because you're a glutton for punishment or you can do so with conditional access policies or Security Defaults.

Well you can disable Autodiscover as a whole organization through the modern authentication setting, however in order to have conditional access you have to have higher licensing than normal which is why I am confused at the disabling comment.

Just a P2 license to setup a conditional access license for the administrator account(s). The user accounts don't require this level of licensing.

Why is it a confusing question?

On a related subject, not looking forward to the eventual request(s) to have he/him, she/her etc added to AD and our automatically generated email signatures

@DustinB3403 I'd love to hear your thoughts so you downvoted my post. I have no problem debating you and anytime I downvote you it is because I don't agree with you. You also know that I upvote you as well even if we aren't best buds 💔

Any vote of yours that I've downvoted is because what you said is wrong or at a minimum disagree. You've been downvoting people out of spite, unless you have a really good argument to what I've posted then I recant the above statement and welcome your debate.

Also everyone that's downvoted you except maybe @stacksofplates has downvoted me before when they disagreed with stuff I've said. @JaredBusch @Obsolesce , @travisdh1 but they've had a reason or an argument to why they've disagreed with me. That's how it's supposed to work.

@scottalanmiller said in DNS Filtering Service:

@stacksofplates said in DNS Filtering Service:

@scottalanmiller said in DNS Filtering Service:

but the OP isn't looking for that.

Not sure why this is assumed. I took it to mean they wanted similar features of a pihole which include adding specific filters and reports.

Sorry, that was ambiguous. I meant that he wasn't looking "for the pihole", not that he was or wasn't looking for the whitelist/blacklist features.

I just meant that PiHole with CloudFlare was an obvious, super cheap, perfect solution - but the OP didn't want it so would need something to replicate it without being it in name.

Ah ok, no prob.