OP
- Thread Starter
- #41
Gigabytes. So not much in today's computing but in the context of a virtual server with X amount of RAM and CPU threads, it costs good amount of money.
-
Welcome to ASR. There are many reviews of audio hardware and expert members to help answer your questions. Click here to have your audio equipment measured for free!
Forum Search Index Not Updating
- Thread starter amirm
- Start date
wow! is it possible to rebuild or compress that table?Ironically, the table for all the likes has grown massively as well! It is in the top 10 larges files! But I happily accept that.
OP
- Thread Starter
- #43
It is scary stuff to mess with the forum tables and risk corrupting something that you won't find until days or weeks later. Someone who is more fluent than me in SQL could do it, assuming there is something to be compressed.
Jimster480
Major Contributor
Yep, I used pretty standard Splitters that were relatively cheap and had no issues with Comcast.
Yep, I got full gbit on my ActionTek units. I bet I still have them... should post them for sale since I have no use for them anymore.... but I would have to find them first haha.
They worked flawlessly for 4 years before I sold the house and moved.
Not too bad. Are you running this whole forum on a VPS? Or does the server you rent only have a single 256GB drive? Most server rentals today have 512-1024GB.
Sure, but you can always back up first. Make the changes and then re-import the table if it doesn't work out.
There is data compression
Disadvantages of using table compression
Are there any disadvantages of using table compression such as Row compression and Page compression, for example: ALTER TABLE A REBUILD WITH (DATA_COMPRESSION = PAGE) --or ROW If the above command
stackoverflow.com
Image Optimizer for XF 2.0
Add-on have provide a powerful settings in ACP options. You MUST settings option before running optimize images. All files will be overwrite; you cannot revert the file. DESCRIPTION Optimizing all images which stored in XenForo to lower size...
xenforo.com
Last edited:
What is the solution and how much does this solution cost?
OP
- Thread Starter
- #47
I have already provisioned a 240 gigabyte server. Just need to move everything over.
OP
- Thread Starter
- #48
Correct.
In my small way, I will soon renew my donation.
What kind of arcane hosting is this running at? Any decent VM system allows to simply expand the virtual disk and grow the filesystem if needed.
OP
- Thread Starter
- #51
It is digital ocean. We had get a new server because we are change OS.
This could be solved easily if we start posting only subjective impressions and audiofooleries.Ironically, the table for all the likes has grown massively as well! It is in the top 10 larges files! But I happily accept that.
Jimster480
Major Contributor
Wild that you run the whole thing on a VPS.... I would put this on a dedicated server for sure.
Ones from OVH are cheap enough.
DO was always way too expensive for what they offer.
If I knew you were running it all from a VPS; I would have made you a nice offer years ago. As my web hosting company does VPS hosting and we have better hardware than what DO was offering for several years. No idea their current offerings, they went deep into AI related hosting.
VPS should be insanely affordable, like under $30/mo max.
OP
- Thread Starter
- #55
It is not clear what we are running on. It certainly is not marketed as a VPS as we have actual core, memory and storage. And I manage it as if it is a raw hardware (no cpanel, etc.). I thought we were running on native iron but some of the later offerings they have make it seem like we are somewhere in between VPS and real hardware.
As you know, the trick is how over subscribed a VPS is. In the last forum I did, we were on real VPS and performance was extremely variable. With DO, it is quite consistent. DO is very reasonable as far as cost. There are one or two outfits that are cheaper but there are many complaints about over subscription. Our new server costs a lot more than $30 a month.
If you're keen to improve maintainability and decrease resource consumption, I'd suggest looking at meilisearch (which is pretty much API compatible) https://github.com/meilisearch/meilisearch
I replaced our elasticsearch cluster at work with a single *much* smaller box.
Jimster480
Major Contributor
Well if you do cat /proc/cpuinfo then you will see which cpu it is and you can see if it's virtualized. But if you haven't paid for a specific spec; then it's definitely virtualized.
The reason I say that any VPS should really cost less than $30 per month, because if it is a true VPS, then it is likely to be oversold. So if you have a VDS, similar to what my company does, then you have a certain portion of dedicated resources. However, you get to the point where it's too expensive and you just get a dedicated server.
I mean these days you can even co-locate a mini PC for a price under $50 per month and then you have basically all the processing power and storage that you need and the price is very low.
If you look here at dedicated options; it's $100/mo for a EPYC Zen4 w/ 32GB DDR5 and Dual 960GB NVMe enterprise drives... Combined with 1Gbit unmetered bandwidth.
Advance-1 Dedicated Server
Order our ADV-1 dedicated server, designed for hosting websites and applications. vRack 100 Mbps network + 500 Gb storage
Then the lowest server they have advertised (on this site, because there is still kimsufi) is $67 and offers a 6c Rocketlake cpu (definitely much slower than Zen4, but faster than most any virtualized system) with 32GB of ram and dual 512GB SSDs.
RISE-1
This is why "expensive" virtualization doesn't make sense to me outside of rapid deployment typically for testing environments.
Roland68
Major Contributor
Just do it like the bastard administrator from hell.Our server is near max space so the indexing system has decided to shut down.
I have provisioned a new server with double the storage but have not had the opportunity to bring it online. Plan to do so next week.
Note that this also impacts searching for yours and other people's posts.
User calls: "I urgently need more storage space, my 60 GB is full."
Admin: "Have you had this approved by your supervisor?"
User: "This is an important project with incredibly important data. I need more storage space immediately, otherwise I'll hold you responsible."
Admin: Keyboard clatter, "So, you now have 60 GB of free storage space, I hope that helps."
User: "Oh, that's great, so I now have a total of 120 GB of storage space?"
Admin: "No, you now have 60 GB of free storage space again."
User: Cries out loud, "But, but, my work, my data, you can't do that..."
Admin: Click, hang up, he won't be bothering me again anytime soon. Quickly post a few sex emails and obscene page views on his account. If he's stupid enough to catch such a nasty virus, then the infected data area obviously needs to be cleaned. Sad, but it was.
And now, a round of Tetris before the end of the day.
You definitely need to set up an alarm when certain partitions go beyond a threshold!
It's always worth taking a look at big tables, specially the ones that isn't clear what they contain, just in case something can be erased without trouble. I would search in the community of the software for those tables. Sometimes applications have design errors and some groom needs to be done to optimize space and performance. Developers not always think about the maintenance guy.
I wouldn't mess with anything else than safely deleting redundant information unless expert hands are available, and quite often it's cheaper to add more server than more people.
It's always worth taking a look at big tables, specially the ones that isn't clear what they contain, just in case something can be erased without trouble. I would search in the community of the software for those tables. Sometimes applications have design errors and some groom needs to be done to optimize space and performance. Developers not always think about the maintenance guy.
I wouldn't mess with anything else than safely deleting redundant information unless expert hands are available, and quite often it's cheaper to add more server than more people.
Last edited:
Pinkynator
Member
- Joined
- Jan 24, 2024
- Messages
- 62
- Likes
- 208
