Avatar

willie

willie

About

Username
willie
Joined
Visits
1,307
Last Active
Roles
Member, OG
Thanked
703

Comments

  • 5 year subscription? Lol.
  • Stay safe. I've done support from home but some stuff requires hands on the machines.
  • I chopped the facebook beacon from this url and downloaded it. It now says: http://www.amazingeducationalresources.com/ looks to me like spreadsheet contents and indicates that it's editable, but isn't for me, maybe due to my ublock settings. Aaand... after retrieving it, it looks like it has an iframe containing a google…
  • Just buy for a month like anyone else does, and if you don't like it then don't renew. Lots of providers take paypal, bitcoin, checks, or whatever.
  • Oh ok, I misunderstood, sorry. Yeah I think the usual solution is cloudflare then.
  • Can someone change the title of this thread? It says web hosting but OP is asking for Minecraft hosting. Requirements are completely different and in particular, buyshared.net is web hosting only. Buyvm.net can host minecraft in principle but its locations might not be the greatest for OP.
  • What is the query load? If you can afford 1/2 second to scan the big text file on every plate lookup, maybe that's the simplest approach. Alternatively go for indexing all those suffix strings like described above. Chuck it all in an SQL table with a btree index and search on LIKE 'XYZ%' and it should be very fast. It will…
  • 8x 61 million = 486 million and it doesn't have to be in ram, an index lookup on that many rows on ssd should be plenty fast enough. Even on hdd it should do much better than 0.5 sec per query. I mistakenly wrote 8 lookups before editing, so don't know if you saw that version.
  • Oh hmm, I didn't catch that, thanks.
  • You're going to throw a muticore dedi at this? Or at least something with multiple cores and enough cpu headroom to handle your query load? Better to do something sensible in the software. If the token is EC1D58C44 you can separately index EC1D58C44, C1D58C44, 1D58C44, D58C44, 58C44, 8C44, C44, and 44. Then you can do 1…
  • Serveria banned on LET for running on expired WHMCS, lol: https://www.lowendtalk.com/discussion/163347/new-2020-dedicated-server-prices-from-19-mo-fully-managed-100-confidential-in-riga-latvia
  • Oh, I thought you were talking about a website. If the players are near you for minecraft, then your server also has to be near you. Latency matters.
  • If this is for a web service, 0.5 sec per query is really too slow. We still haven't heard anything about the application though. Fulltext engines will be of no help with this since they search for tokens given prefixes. They won't look for substrings in the middle of tokens. All you can really do is index all the "tails"…
  • 100 daily visits and you're getting ddos'd? You are in Brazil? BuyVM offers ddos protection as an extra cost option for VPS. I don't know if it's available for shared hosting but I don't see why it shouldn't be. Other than that, you can filter through cloudflare, which probably has entry points in Brazil, if that is where…
  • Icecast doesn't particularly need root, beyond the way web servers in general need root to listen on low port numbers. If you put it on a high port you can run without root. But, at least when I did it, it was challenging enough to set up that I'd call it unsuitable for newbies. Enough people are now asking about stuff…
  • As this is a self-hosting forum we'd be remiss in not mentioning icecast. I managed to set it up for a conference a while back and it was a bit of a hassle, but it worked once a few snags were sorted. I don't know if it's easier now. I guess I should try it again. There are several seconds of lag between the live action…
  • What is the actual application if you don't mind my asking, and what is the total amount of text to be searched? What size vm are you running in? I'm still perplexed that you have to find "Mr_Tom" from "to". Maybe you can index trigraphs or substrings from the tokens in this text? If column length is 9 chars max, this is…
  • LIKE 'XX%' should also be fast, because of the index, and there is sometimes a way to make an index on the reverse spelling of the string so that LIKE '%XX' is also fast. The slow one is LIKE '%X%'. But really if the stuff you are parsing out of those strings is id numbers or something else you can identify when you import…
  • Don't forget to take mhz into account. The Epyc 7502P and TR 3970X are both around €2k and both have 32 cores, but the TR 3970X has over 2x the passmark because of its higher clock speed (I don't understand that passmark ratio since the mhz difference is less than 2x, but it's been measured). Similar things happen with the…
  • Power consumption yes; acquisition only in comparison to new Intel stuff. This is LES and providers here tend to use older equipment acquired on the used market for almost nothing. Epyc acquisition is also way more expensive per unit performance than AMD's own lower end lines, Threadripper and Ryzen. There are several very…
  • It's nice to have a bit more per-core performance but it's also a matter of how much cpu headroom is available. A small VM on a 4-core E3 box can easily be swamped by just a few noisy neighbors, but if it's on a 12+ core Ryzen or Epyc or E5, unless the product starts to attract cpu hogs, there is less likelihood of all…
  • That is a crazy db setup. You shouldn't have to scan strings at query time. Process each string when you insert it into the database, extracting any id's from the string. Make a new table that combines the extracted id's with the id of the row you just added. Add suitable indexes and do appropriate JOIN operations to find…
  • You mean your outgoing address? Spam filters use whatever probabilistic signals they can, and TLD is certainly one of them. Most mail coming from .biz is spam, so filters will weigh that in. You are probably best off with the traditional com/net/org or country codes that really do reflect where the sender is likely to be…
  • I guess so. I think the AX160 included some NVMe disks while with the AX161 you have to pay extra for those. I don't remember if the prices were similar. The 7502P is a lot faster from what I hear though. Neither one is a low end server and as such, rather than going into conniptions about setup fees, the users are more…
  • I think that was the AX160 (EPYC 7401P) being cleared out.
  • Hetzner uses a lot of desktop cpus in custom enclosures, but they also have server cpus such as the Epyc. If you compare the EX line (i7 desktop cpus) with the PX line (Xeons whose bare cpu cost is roughly the same), the PX line is considerably more expensive than the configuration difference alone really supports. Part of…
  • It would be nice if the topic lines like "flips 504 views 40 comments 12 new Most recent by flips March 2" (current display of this thread) had a direct link to the most recent comment, so clicking "March 2" would go immediately to the last page of the thread. That would allow easy catchup and checking out of current…
  • Is Dense Epyc a specific product / technology? I couldn't find anything with web search. It is definitely possible to get current-gen Epyc servers for data centers. E.g., the Hetzner AX161 uses the Epyc 7502P.
  • If you can offer it on Hetzner Cloud I'll be happy to try it for an hour ;). Scaleway has the older Epyc 7402P on their hourly cloud (bare metal even) and I might give that a try sometime too, but it's less interesting than the new Epycs.
  • Hetzner seems to keep it almost secret that you can upgrade that machine all the way to 1TB, by adding 64GB modules per here: https://wiki.hetzner.de/index.php/Root_Server_Hardware/en#RAM :)
  • The $3 is no big deal per se, but I figure if you're going to offer DA at some point, it's better for new customers to start out with it instead of starting with cpanel and switching later.
  • Fran, any news about DA web hosting on buyshared? Right now there's still only cpanel, I think. I may have missed something though.
  • Meh, can't edit the above any more: I got confused, the 7502P costs a little more than the 3970X does (around 2200 USD vs 2000 USD, I think). The 3990X is much more, 3900 USD ("$1 per X") and is only worth it for some specific workloads.

This Site is currently in maintenance mode.
Please check back here later.

→ Site Settings