r/mariadb

I know I'm gonna get crap for asking this but, let's not pretend like none of us use a GUI client ever. :-)

I can and do use the command line but I prefer a GUI client when at all possible. I used PHP My Admin for years, then moved to TablePlus on my Mac. TablePlus does not currently support Chrome OS sadly so I am in search of an alternative that works on Chrome OS. I may end up going back to PHP My Admin while on my Chromebook but I'd rather not.

MySql Workbench seems to be popular, I've tinkered with it in the past so that's probably going to be what I'll use if I can get it installed on Chrome OS unless you fine folks have something newer/better that you recommend that will for sure work in Chrome OS.

I have been trying to love Chrome OS for some time and it seems with I'm almost able to use it 90% of the time in place of my Macbook. Not only far cheaper but in many ways better (mostly cheaper). The one thing I can't do on my newer better Chromebook Plus is use TablePlus. So, looking for a solution.

I thought about posting this in the Chromeos sub or is it chromebook?? But, there are far more people in there that will ask WTF MariaDB is than will ask in here what a Chromebook is :-)

Thanks in advance for any advice you can provide. Oh and don't forget, I already know many of you will say that the command line is your favorite GUI client, so thanks in advance for that as well Lol

I have an index on a 10 character date, YYYY-MM-DD. If I have a million records where most are in order, meaning today’s records are all stored today, BUT, I occasionally have some that are inserted well after. So today I might have records go in for 2024-01–10.

Should I periodically sort and rebuild the table or will the index be just as performant where the logical records are fragmented throughout?

It's recommended from what I read to use 70% system memory which is around 1.4G. When I type in 1.4G it rejects the config and won't start. Does the config not accept using decimals?

innodb_buffer_pool_size = 1.4G