Fix slow reindexing on MariaDB

Reindexing on MariaDB 10.4 takes more time compared to other MariaDB or MySQL versions.
As a workaround, we suggest modifying the default MariaDB configuration and setting the following parameters:

optimizer_switch=’rowid_filter=off’
optimizer_use_condition_selectivity = 1

With this parameters catalog product reindex finish after 7 sec, without 5 min !!!
It will be useful for those who use Mark Shust docker-magento:

db:

image: mariadb:10.4

command:

--max_allowed_packet=64M

--optimizer_use_condition_selectivity=1

--optimizer_switch="rowid_filter=off"

ports:

- "3306:3306"

env_file: env/db.env

volumes:

- dbdata:/var/lib/mysql

extra_hosts: *appextrahosts

https://experienceleague.adobe.com/docs/commerce-operations/performance-best-practices/configuration.html

submitted by /u/netmouse_ua
[link] [comments]

Any advice for the Magento Commerce Developer Professional Certification?

Hi, I am a junior developer from the UK

Does anyone have any advice for said certification, as I will be doing this exam soon this year.

I have been studying Magento for nearly 4 months, and am running through all the topic areas. Making sure I am confident in each.

There are 6 sections here https://express.adobe.com/page/WBhc2rZlIxtWC/ I am making sure I am confident in each.

Any advice from people who have done it or a similar certification?

Thanks.

submitted by /u/CuriouslyGeorge17
[link] [comments]

Should I redo my whole ecommerce website using magento?

Me and my friend are opening up an ecommerce business that is launching soon. Since I am the developer I was tasked with building the website.

I have built the whole website using Laravel without any packages for ecommerce and now I’m having doubts.. I did not know that packages like magento were available before.

The only thing left to finish the website is online payment integration (currently only cash orders are available), but now I’m having doubts with the whole thing after I read about how using magento is way better for ecommerce.

What do you guys recommend me to do? Should I redo the whole thing in magento? I spent months on the website with only laravel.

submitted by /u/xCinemato
[link] [comments]

Docker / Devilbox / Magento 2 Speed Optimization in Windows WSL2

Hi,
My developer has set this up and I’m thinking of switching, are any of you using this setup?

Docker / Devilbox / Magento 2 / WSL2

Do you have any tips or guides as to the proper way to set this up in Windows 11 and get good speed?

The developer’s machine is currently running a bit slowly though he has an AMD 5800x and 32gb of ram. I have reviewed the devilbox docs but their speed troubleshooting is only for MacOS, not Windows.

submitted by /u/kjavitz
[link] [comments]

Warning to in-house ecommerce managers using agencies…

always buy modules on your own accounts, never allow your agency to buy them on your behalf through their accounts becuase, if you part ways on bad terms*, you will either have to have a fight them or have to just stump up the cash for those exact same modules again when your new agency come to do an upgrade.

Edit: *talking through expeience of dealing with an east London HQ’d, supposedly, Platinum Magento partner here who did not deliver on work, tried to charge for the uncompleted work, and when we refused to pay for uncompleted work, took us to court where we were easily able to prove they didn’t do the work.

submitted by /u/SeanReillyEsq
[link] [comments]