• 1 post
  • 36 comments
Joined 3 years ago
Cake day: September 6th, 2023
  • Try

    docker compose up - d && docker compose logs -f
    

    That should show you errors as things are starting.

    Also three backticks and a new linestart a code block on Lemmy. Add your logs, then end it with a new line and another three backticks.

  • I use an M1 (Pro 14" 8 core 16GB) with Asahi. It’s extremely usable. WiFi is solid. Sound is solid. I never considered keyboard to be an issue… Its not. Things like brigtheness buttons still work. I have a tonne of USB devices and none of them had issues. I don’t think the fingerprint reader or the built-in camera work but I can test them if that’s a sticking point.

    I very much like it and it’s easy to switch into OSX if you’re so inclined. I do for photo work. I know there are alternatives. I’m working on it.

    The things I would warn about:

    1. in my experience, battery life is worse. Maybe around 1/2 of what OSX gets. With my overall battery health around 80%, I think I’m getting 4 hours in Asahi.

    2. this could actually be a skill issue (Linux newb) but I’ve had trouble installing certain packages in Fedora and Python and I assume it has to do with the M1 being ARM-based

    Edit: remembered some things. As of the newest version, gaming is much MUCH better. I think you can do 720p or on medium or 1080p low with decent frames by just using proton on Stream. That’s wild to me.

    In case you didn’t know, Asahi is the Linux distro designed for Apple Silicon Macs. Its based on Fedora with KDE as the desktop so it has a solid backens and a familiar but customizable interface. Its extremely simple to install and is beginner friendly.

    Reply if you need more info!

  • While I get that SO can be monstrously unhelpful, database optimization is a whole profession so I think we need a bit more to help

    A few directions we could go here: Post your SQL query. This could be a structure or query issue. Best case, we could do some query optimization. Also, have you looked into indexing?

    Where are your bottlenecks coming from? Is your server desined for a I/O intensive workload like databases. Sequential read speed is not a good metrix.

    What about concurrency? If this is is super read/write intensive, optimization could depend on where data is written while you’re reading