1 mo. ago • 96%

Linux processes

67 comments

It was little Bobby Tables

105
- Middle name Drop
  
  3
Alright who's running the database on the same machine as the server...👀

72
- If you can do this, do it. It's a huge boost to performance thanks to infinitely lower latency.
  
  68
  
  And infinitely lower reliability because you can't have failovers (well you can, but people that run everything in the same host, won't). It's fine for something non critical, but I wouldn't do it with anything that pays the bills.
  
  11
- Most beginner selfhosters.
  
  48
  
  and most every cpanel (and every other web host panel) box on the planet.
  
  web, ftp, database, mail, dns, and more. all on one machine.
  
  34
- For distributed that feed back to a centralized DB? Me. All the dang time.
  
  3
- I'm not that brave doing development by connecting to Production database
  
  2
Ok, now I need a 8 season animated show and at least 2 direct-to-TV movies of this

70
- Best I can do is a Netflix series that gets cancelled halfway through season 2 and a fan-made animation spoof on YouTube
  
  25
  
  As long as the animation is done by Don Hertzfeldt, you have yourself a goddamn deal!
  
  3
  
  I am in.
  
  1
Random guess, a php error caused Apache to log a ridiculous number of errors to /var/log and on this system that isn’t its own partition so /var filled up crashing MySQL. The user wiped /var/log to free up space.

60
- That's not far off of something that happened to me once a few years ago. My computer suddenly started struggling one day, and I quickly figured out that my hard drive suddenly had 500 gigs or so of extra data somewhere. I had to find a tool that would let me see how much space a given folder was taking up, and eventually I found an absolutely HUMONGOUS error log file. After I cleared it out, the file rapidly filled up again when I used a program I'd been using all the time. I think it was Minecraft or something. Anyway, my duck tape solution was to just make that log file read-only, since the error in question didn't actually affect anything else.
  
  6
Fuck MySQL, all my homies hate MySQL.

Postgres is the way to go.

60
- "MariaDB"
  
  26
  
  Yes, Maria too.
  
  Postgre is the way
  
  14
  
  I'm not sure what the future of MariaDB is... It lacks a bunch of newer MySQL features, and they've deviated far enough that I don't know if they can cleanly backport them from MySQL any more.
  
  1
- It was you! You killed it.
  
  22
  
  I do admit to moving the company cluster from MySQL to Postgres.
  
  But only most of the traffic, some traces still remain, so the original MySQL still works
  
  8
- why?
  
  8
  
  I did two rounds of very long presentations comparing those two systems.
  
  Personal reasons:
  
  SQL standard support is still very weak
  
  lack of WAL
  
  array support
  
  weird replication support
  
  utf8mb4 mess took too long to resolve
  
  many things started to get better only after Oracle takeover
  
  5
  
  Because it's proprietary
  
  -3
Plot twist: it was the user

54
- That's not even a plot twist, that's expected user behavior
  
  7
All evidence point to suicide.

50
- I hadn't realized this was a .ru domain....
  
  28
  
  Maybe it's a 'Windows' server...
  
  21
Systemd. SQL is now in Systemd.

32
- Dont spoil. That's the secret in Episode 5.
  
  9
I understand none of this.....

26
- "Among us" but for Linux nerds.
  
  16
It was Java, coaxing the Linux OOM killer into doing the job

24
It looks like the OOM killer has struck again.

22
/var/log has been deleted, you say...

I think we all know what this means, don't we?

22
- Hint
  
  ls -ld /var/log drwxrwxr-x 18 root syslog 4096 Aug 11 08:13 /var/log
  
  14
  
  I have no clue. Root nuked the logs? Why? OOM killer does not do that.
  
  8
  
  That seems so obvious I think we're missing something
  
  7
This process has been murdered mysteriously.

22
Oracle.

20
Will there be a follow up?

17
I did it like this: 🔫 BANG WhooOooOoopty doOoO

14
It was the kubelet after MySQL failed his liveness probes

12
Permanently Deleted

10
It was the BOFH

6
- It was taking away resources from the coffee cam. Had to go.
  
  6
Like everytime with natives, it was a race condition cascade of table locks followed by mysql suicide caused by bad cronjob scripts implemented by the user.

6
- So... bash ?
  
  1
Mariadb did it with the candlestick in the library.

5

You've viewed 67 comments.