Skip Navigation

User banner

Otto

@ otto @programming.dev

Posts
70
Comments
37
Joined
3 yr. ago

  • MariaDB 11.8 LTS is now officially available

    Jump

  • MariaDB 11.8 LTS released, has vector support, automatic TLS and more

    Jump

  • What do users of MariaDB in Debian want to see in future versions?

    Jump

  • Stategies for scaling out MySQL/MariaDB when database gets too large for a single host?

    Jump

  • I am asking for general strategies, not for a solution to a specific case.

  • What to do when a MySQL/MariaDB database gets too large for a single host?

    Jump

  • By UV 3000 you probably don't mean the ultraviolet lamp that is the first page of Google is full of when searching with this term..? I doubt UV - whatever it is - is a common approach.

  • What do users of MariaDB in Debian want to see in future versions?

    Jump

  • What do you mean a default user? You can just run 'mariadb' to access to console with the same user that had permissions to run 'apt install'.

    For your actual application you need to plan what database name to use, what user, what permissions it needs, potentially remote connection and TLS etc. This indeed is some work and could perhaps be automated a bit, but it also needs sysadmin to make some decisions.

  • What do users of MariaDB in Debian/Ubuntu want to see in future versions?

    Jump

  • Yes, increasing the InnoDB buffer pool to use all available memory is the most important configuration change a sysadmin can do. But in order to do it, you need to know if the host is dedicated to one MariaDB instance or if there are multiple servers on the same host. Otherwise you would just have processes each hogging more memory when they can and not giving it up to others.

    I could think about having a dialog during the installation that asks something like "Is host dedicated to this MariaDB instance? If yes, automatically configure it to use most of the system RAM available."

  • What do users of MariaDB in Ubuntu want to see in future versions?

    Jump

  • MariaDB supports Galera clustering out-of-the-box, and also traditional primary/replica setups. But you need to have something that spans multiple hosts to monitor and manage it, and that is outside of what a single-host OS package management system can do.

  • What local LLMs are you using to create embeddings for RAG?

    Jump

  • You mean ollama? There are so many options, any favorites?

  • Instructions for Windows users who want have improved security without CrowdStrike

    Jump

  • Advanced git commands every senior software developer needs to know

    Jump

  • I just prefix all my git aliases with g-. So for status I type g-s<tab>.

  • Advanced git commands every senior software developer needs to know

    Jump

  • You need bisect only as a last resort. Effective use of git blame, git log -p -S <keyword> etc has always been enough for me. Also, the projects I work with take 10+ minutes to compile even when cached, so doing tens of builds to bisect is much slower than just hunting for strings in git commits and code.

  • Advanced git commands every senior software developer needs to know

    Jump

  • I had the same feeling until I started using gitk. I always have a gitk window open and press F5 to reload, so it shows me the state of everything after I've run git commands. Now I grasp everything much better.

  • Removed

    A coder's point of view: The optimal home office

    Jump

  • Only product from Microsoft I actually like using and trust. Quality from 1998, and still going :)

  • Removed

    A coder's point of view: The optimal home office

    Jump

  • One is enough if it is very big

  • Latest GPT-4-0125-preview and Bard-Feb-2024 are live at https://chat.lmsys.org

    Jump

  • Try again tomorrow, seems it got popular today

  • Building an open share button for the distributed social web

    Jump