1. zoldos

    How can I merge two *separate* MySQL databases into one, but avoid duplication?

    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...
  2. enivid

    Improving XenForo Database Backup Speed?

    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.
  3. Mouth

    3GB DB mysqldump import failure, MySQL -> MariaDB

    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...
  4. XenForo

    Developer IDE and server software setup guides

    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...
  5. Mr. Jinx

    max_user_connections (30) exceeded messages

    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...
  6. Moddis

    XF 1.5 Latest version of PHP/SQL compatible with 1.5 and 2.1

    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...
  7. eva2000

    Centmin Mod LEMP users get another 5-40% boost in performance

    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...
  8. AppleAndMango

    MySQL vs MariaDB

    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...
  9. Brent W

    100% Ground Up CentminMod Server Setup & Optimization Saving You Money On Hosting

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

    [HELP] Serious challenge - tuning server

    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...
Top Bottom