mariadb

We've been stress testing a new xenforo installation on a galera cluster (preparing for a forum migration) and we've encountered a deadlock error, which we can't figure out: We already tried different galera settings for the nodes, none of the variables helps this issue (some other deadlocks...

I have two MySQL databases setup, with both having the table “xf_user”, and the columns “email” and “username”. They both have other columns, but not all match. I just want to merge those two particular columns, overwriting/skipping duplicates, to make one unified DB. I’m not quite sure how...

Hello all! Our forum got pretty large and with 160k+ posts it takes quite a long time to backup the database. Is there any guide or tips for improving the database backup speed for XenForo? We are using XF 2.2 with MariaDB 10.1.

I am attempting to migrate to a new hosting provider, thus mysqldump on the source for DB backup and mysql import on the target. On disk, my MySQL 5.7 source DB is 5.0GB and the mysqldump file is 3GB, thus importing the 3GB .sql into the target server with MariaDB 10.6 mysqldump with...

Here at XenForo, we like to keep our development environments up-to-date and as useful as possible, and from time to time we include some of our findings in our online documentation. Recently, we've published an easy setup guide for a Windows-based development environment and now we've added...

Lately I'm getting these max_user_connections exceeded messages from MySQL. I asked my hosting provider if they could raise the limit. However, they told me that only in very rare situations you would need 30+ connections. Even for extremely busy sites, 30 should be more than enough. Most...

I'm currently running Xenforo 1.5 with PHP 5.4 and SQL 5.6. I am testing an upgrade to 2.1 on the same server which recommends PHP 7.2. I'm happy to upgrade but don't want to break the production site if it is not compatible with the latest PHP version. What is the latest PHP version that is...

Seeing as there are some folks here using my Centmin Mod LEMP stack, I thought I'd share a quick guide I wrote for configuration tips to improve performance beyond the out of box automatic optimisations already done. In theory these configuration tips can provide an additional 5-40% improvement...

Hey. So I've been reading around and I've noticed that MariaDB is generally suggested more than MySQL as a database server, I've Googled and I can't seem to find a clear answer to my question of what's the difference and why do people prefer MariaDB over MySQL. Anyone feel like explaining...

Hello everyone, For over 3 years now I have been working with https://www.centminmod.com/ to setup all of our servers that we have used on https://www.whippmedia.com/ Through that time I have found the best things that works for us when it comes to XenForo through constant testing. What has...

Original post broken into several posts because of 10.000 character limit My forum is still alive on old server, from which I have to move in next few days. My plan is to setup vps server I have bought on Digital Ocean, and after optimization is done, I just upload xenforo files from old server...