Xenforo Xenforo 2.0.0 Beta 1 Released

eva2000 · Sep 6, 2017

Xenforo 2.0.0 Beta 1 has been released.

XenForo 2.0 is a significant upgrade from 1.x. Add-ons and customizations made for XenForo 1.x will not be compatible. Style customizations will need to be redone and will not be maintained after the upgrade. We strongly recommend you make a backup before attempting an upgrade.

This is beta software. It is not officially supported. We do not recommend running it in production.

All customers with active licenses may now download the new version from the customer area.
Click to expand...

Alongside the release of XenForo 2.0.0 Beta 1, we are also releasing updated versions of each of our official add-ons:

XenForo Media Gallery 2.0.0 Beta 1

XenForo Resource Manager 2.0.0 Beta 1

XenForo Enhanced Search 2.0.0 Beta 1

Each of these has been updated to use the new framework and systems present in XenForo 2.0.

While new features were not the primary focus, each add-on has several new features. These have been covered in the have you seen forum.

Customers with active licenses for these add-ons may download the new versions from their customer area.
Click to expand...

Xenforo 2.0.0 Beta 1 Install Guide on Centmin Mod LEMP Stack

Only do test installs separate from live XF database/instance.

Test XF 2.0.0 Beta 1 install on Centmin Mod 123.09beta01 and works fine. Used demo domain = newdomainx.com via local host file edit. With desired Xenforo 2 forum installed on web root of domain newdomainx.com. This is for HTTP (non-HTTPS based test setup). These are based on official Xenforo 2 Install docs at Getting started - XenForo 2.0 Documentation

1. Create the Centmin Mod Nginx vhost as per official guide. I use nv command via SSH client type:
Code (Text):
nv -d newdomainx.com -s n -u YOURFTPUSERNAME
Nginx vhost conf path will be at /usr/local/nginx/conf/conf.d/newdomainx.com.conf

Vhost public web root will be at /home/nginx/domains/newdomainx.com/public

Vhost log directory will be at /home/nginx/domains/newdomainx.com/log

Or if you have a working real domain/subdomain and DNS A record pointing to your Centmin Mod 123.09beta01 based server, you can use https://centminmod.com/acmetool addon to generate a Centmin Mod Nginx HTTP/2 based HTTPS vhost site and automatically obtain a free Letsencrypt SSL certificate using the guide outlined here Using Centmin Mod acmetool.sh addon for Nginx HTTP/2 based HTTPS with free Letsencrypt SSL certificates, the SSH commands would be after you follow the guide's instructions to enable addons/acmetool.sh addon.
Code (Text):
cd /usr/local/src/centminmod/addons
./acmetool.sh issue newdomainx.com lived
That would generate Centmin Mod Nginx HTTP/2 based HTTPS vhost and site and obtain the free Letsencrypt SSL certificate and setup the domain to default to HTTPS and auto redirect HTTP to HTTPS for requests.

Then the Nginx vhost path would change for the rest of below example from /usr/local/nginx/conf/conf.d/newdomainx.com.conf to /usr/local/nginx/conf/conf.d/newdomainx.com.ssl.conf

Nginx HTTP/2 HTTPS vhost conf path will be at /usr/local/nginx/conf/conf.d/newdomainx.com.ssl.conf

Vhost public web root will be at /home/nginx/domains/newdomainx.com/public

Vhost log directory will be at /home/nginx/domains/newdomainx.com/log

2. Configure your Nginx vhost file with Nginx rules for Xenforo 2 use the official Centmin Mod Nginx vhost generator https://centminmod.com/vhost.php and enter the domain name = newdomainx.com and in vhost type select Xenforo and hit submit to generate the Nginx vhost for the domain. That generates a 123.08stable Nginx vhost format which is slightly different to 123.09beta01 Nginx vhost format. For 123.09beta01 Nginx vhost format, you can see example for newdomainx.com at xenforo 2 developer preview newdomainx.com example vhost. Note I commented out the include file for /usr/local/nginx/conf/autoprotect/newdomainx.com/autoprotect-newdomainx.com.conf.
Code (Text):
# comment out for https://community.centminmod.com/threads/autoprotect-sh-apache-htaccess-check-migration-to-nginx-deny-all.7308/
# or setup .autoprotect-bypass files https://community.centminmod.com/posts/31027/ in /internal_data, /library and /src directories
#include /usr/local/nginx/conf/autoprotect/newdomainx.com/autoprotect-newdomainx.com.conf;
You may also want to add to Nginx vhost the following header to tell search engines not to index this test install
Code (Text):
add_header X-Robots-Tag "noindex, nofollow";
I placed it after the 503include-main.conf commented out includes file
Code (Text):
  # uncomment cloudflare.conf include if using cloudflare for
  # server and/or vhost site
  #include /usr/local/nginx/conf/cloudflare.conf;
  include /usr/local/nginx/conf/503include-main.conf;
  add_header X-Robots-Tag "noindex, nofollow";
Test nginx vhost config and restart Nginx and PHP
Code (Text):
nginx -t
nprestart
3. Download Xenforo 2.0.0 Beta1 zip and rename to xenforo_2.0.0b1.zip and upload entire zip to new directory created at /home/nginx/domains/newdomainx.com/zips so /home/nginx/domains/newdomainx.com/zips/xenforo_2.0.0b1.zip

Then to unzip file contents and give correct user/group permissions = nginx and copy the unziped upload/ directory files to newdomainx.com web root at /home/nginx/domains/newdomainx.com/public you do this via SSH client type:
Code (Text):
cd /home/nginx/domains/newdomainx.com/zips
unzip xenforo_2.0.0b1.zip
chown -R nginx:nginx upload
cd upload
\cp -Rpf * /home/nginx/domains/newdomainx.com/public
4. Download xf2_config.sh generator script I wrote specifically for Centmin Mod LEMP installs and XF2 so that in future can automate the Xenforo 2 installs via SSH command line type the following. The script will ask for mysql database name, mysql username, mysql password and auto create them on the server and then generate the /home/nginx/domains/newdomainx.com/public/src/config.php config file and auto populate the settings in it.

To download and setup /root/tools/xf2_config.sh type in SSH command
Code (Text):
mkdir -p /root/tools
cd /root/tools
rm -rf xf_config.sh
wget https://gist.github.com/centminmod/89e8bc024b9eae8873092fd56b10088e/raw/xf2_config.sh
chmod +x xf2_config.sh
Now to generate the Xenforo 2 src/config.php file at /home/nginx/domains/newdomainx.com/public/src/config.php, you need to run xf2_config.sh and pass the desired path where config.php will reside = /home/nginx/domains/newdomainx.com/public/src.

In SSH type:
Code (Text):
cd /root/tools
./xf2_config.sh /home/nginx/domains/newdomainx.com/public/src
output from run
Code (Text):
./xf2_config.sh /home/nginx/domains/newdomainx.com/public/src

Enter desired MySQL database name: xd5
Enter desired MySQL username: xu5
Enter desired MySQL password: xp5

GRANT USAGE ON *.* TO 'xu5'@'localhost' IDENTIFIED BY PASSWORD '*91DD20BB540FAAE3C54257D78203030A1BAC61F6'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON `xd5`.* TO 'xu5'@'localhost'

Grants for xu5@localhost
GRANT USAGE ON *.* TO 'xu5'@'localhost' IDENTIFIED BY PASSWORD '*91DD20BB540FAAE3C54257D78203030A1BAC61F6'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON `xd5`.* TO 'xu5'@'localhost'

Setup /home/nginx/domains/newdomainx.com/public/src/config.php

Created /home/nginx/domains/newdomainx.com/public/src/config.php
Contents of auto generated Xenforo 2 src/config.php /home/nginx/domains/newdomainx.com/public/src/config.php
Code (Text):
cat /home/nginx/domains/newdomainx.com/public/src/config.php
<?php

$config['db']['host'] = 'localhost';
$config['db']['port'] = '3306';
$config['db']['username'] = 'xu5';
$config['db']['password'] = 'xp5';
$config['db']['dbname'] = 'xd5';
$config['fullUnicode'] = 'true';
5. Now to install Xenforo 2 via CLI command line, you run cmd.php from the Nginx vhost site's web root or where you placed the Xenforo 2 extracted zip files i.e. public web root = /home/nginx/domains/newdomainx.com/public
Code (Text):
cd /home/nginx/domains/newdomainx.com/public
php cmd.php xf:install
Then ensure proper file permissions
Code (Text):
chown -R nginx:nginx /home/nginx/domains/newdomainx.com/public
example
Code (Text):
time php cmd.php xf:install
All 3514 checked files are present and correct. :)
Name of the administrator user (default: Admin): eva2000

Password of the administrator user:

Re-enter the administrator user password to confirm:

Primary board email and email for administrator user (default: example@example.com): myemail@domain.com

Board title (default: XenForo): Xenforo 2.0.0 Beta 1 on Centmin Mod LEMP Stack

Board URL (default: http://localhost): http://newdomainx.com

Creating tables...
 186/186 [============================] 100%
Done.
Creating default data...
 23/23 [============================] 100%
Done. Importing data...

Importing... Master data (Phrases)
Importing... Master data (Phrases: 33.0%)
Importing... Master data (Phrases: 57.5%)
Importing... Master data (Phrases: 71.5%)
Importing... Master data (Phrases: 82.8%)
Importing... Master data (Templates)
Importing... Master data (Templates: 50.3%)

Master data rebuilt successfully. Time taken to import and rebuild: 59.20s
Done. Apply installation configuration...

All finished. Installation has been completed.

Values set:
        * Username: eva2000
        * Email: myemail@domain.com
        * Password: **************** (Confirmed)
        * Title: Xenforo 2.0.0 Beta 1 on Centmin Mod LEMP Stack
        * URL: http://newdomainx.com

Running clean up tasks...

real    1m48.199s
user    0m17.522s
sys     0m2.131s
6. Backup and ensure file permissions are set to nginx user/group - follow guide at https://community.centminmod.com/th...kup-restore-file-directory-permissions.10633/

If you want to migrate to HTTPS based site, you can use Centmin Mod 123.09beta01's free Letsencrypt SSL certificate integration tools currently in beta testing. You can use the manual migration from HTTP to HTTPS guide at Migrating Existing Nginx Vhost From HTTP to HTTP/2 based HTTPS With Letsencrypt SSL Certificates to obtain free Letsencrypt SSL certificate and setup the Centmin Mod Nginx HTTPS vhost file.

Xenforo 2.0.0 Beta 1 Reinstall Guide

Xenforo 2.0.0 Beta 1 now allow you to upgrade in place instead of wiping preview instances to start again. So when a new release is made, you can do an in place upgrade.

However, if you want to reinstall fresh, you can follow the above guide to install Xenforo 2.0.0 Beta 1 from scratch again via the below guide and SSH commands to reinstall the newer released Xenforo 2.0.0 Betas

1. Upload new Xenforo 2.0.0 Beta release zip to /home/nginx/domains/newdomainx.com/zips renamed as xenforo_2.0.0b1.zip or as you desire

2. If you defined your MySQL database name as above as xd5, then assign it to the dbname variable below and assign to domain variable your domain name i.e. above example used newdomainx.com.
Code (Text):
dbname=xd5
domain='newdomainx.com'
Then run these below commands
Code (Text):
dbname=xd5
domain='newdomainx.com'
if [ ! "$(grep -w "$dbname" /home/nginx/domains/${domain}/public/src/config.php)" ]; then   echo "$dbname not listed in /home/nginx/domains/${domain}/public/src/config.php"; fi
echo 'y' | mysqladmin drop $dbname
mysqladmin create $dbname
rm -rf /home/nginx/domains/${domain}/zips/XF2-INSTALL.txt
rm -rf /home/nginx/domains/${domain}/zips/xenforo_2.0.0
rm -rf /home/nginx/domains/${domain}/zips/upload
rm -rf /home/nginx/domains/${domain}/public/data/*
rm -rf /home/nginx/domains/${domain}/public/internal_data/*
cd /home/nginx/domains/${domain}/zips
unzip xenforo_2.0.0b1.zip
chown -R nginx:nginx upload
cd upload
\cp -Rpf * /home/nginx/domains/${domain}/public
cd /home/nginx/domains/${domain}/public
php cmd.php xf:install
chown -R nginx:nginx /home/nginx/domains/${domain}/public
That's it new Xenforo 2.0.0 Beta release installed

Xenforo 2.0.0 Beta 1 Admin

Server Setup

CentOS 7.3 64bit

Nginx 1.13.5

PHP 7.1.19 + Zend Opcache

MariaDB 10.1.26 MySQL

Centmin Mod 123.09beta01 LEMP stack

2 CPU Intel Xeon E5-1650v2 OpenVZ VPS

2GB RAM

50GB DISK

Dallas, TX

US$25/yr OpenVZ VPS

eva2000 · Sep 6, 2017

XF 2 Beta 1 Addons

Installed

With Media Gallery, Resource Manage and Enhanced Search addons installed

eva2000 · Sep 6, 2017

Xenforo 2.0.0 Enhanced Search Beta 1 Options

eva2000 · Sep 6, 2017

Xenforo 2.0.0 Beta 1 Media Gallery

Seems a few bugs on image upload

Code (Text):

ErrorException: array_keys() expects parameter 1 to be array, null given in src/addons/XFMG/Notifier/Media/CategoryWatch.php at line 70
[LIST=1]
[*]XF::handlePhpError()
[*]array_keys() in src/addons/XFMG/Notifier/Media/CategoryWatch.php at line 70
[*]XFMG\Notifier\Media\CategoryWatch->getDefaultNotifyData() in src/XF/Service/AbstractNotifier.phpat line 258
[*]XF\Service\AbstractNotifier->ensureDataLoaded() in src/XF/Service/AbstractNotifier.php at line 31
[*]XF\Service\AbstractNotifier->notify() in src/XF/Service/AbstractNotifier.php at line 56
[*]XF\Service\AbstractNotifier->notifyAndEnqueue() in src/addons/XFMG/Service/Media/Creator.php at line 282
[*]XFMG\Service\Media\Creator->sendNotifications() in src/addons/XFMG/Pub/Controller/Media.php at line 664
[*]XFMG\Pub\Controller\Media->finalizeMediaItemCreate() insrc/addons/XFMG/Pub/Controller/Media.php at line 741
[*]XFMG\Pub\Controller\Media->actionSaveMedia() in src/XF/Mvc/Dispatcher.php at line 232
[*]XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 85
[*]XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
[*]XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1771
[*]XF\App->run() in src/XF.php at line 319
[*]XF::runApp() in index.php at line 13
[/LIST]

But images do upload

eva2000 · Sep 6, 2017

Xenforo 2.0.0 Beta 1 Resource Manager

Seems Resource Manager is buggy too right now, adding a new resource to example category gives

Code (Text):

ErrorException: A non-numeric value encountered in src/XF/Mvc/Entity/Entity.php at line 748
XF::handlePhpError() in src/XF/Mvc/Entity/Entity.php at line 748
XF\Mvc\Entity\Entity->_castValueToType() in src/XF/Mvc/Entity/Entity.php at line 614
XF\Mvc\Entity\Entity->set() in src/XF/Mvc/Entity/Entity.php at line 554
XF\Mvc\Entity\Entity->__set() in src/addons/XFRM/Pub/Controller/Category.php at line 296
XFRM\Pub\Controller\Category->actionAdd() in src/XF/Mvc/Dispatcher.php at line 232
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 85
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1771
XF\App->run() in src/XF.php at line 319
XF::runApp() in index.php at line 13

eva2000 · Sep 6, 2017

Xenforo 2.0.0 Beta 1 Enhanced Search

Test post & search

search for nginx

Enhanced Search stats

eva2000 · Sep 6, 2017

Xenforo 2.0.0 Beta 1 MySQL Info

Breakdown of MySQL Engines used for Xenforo 2.0.0 Beta 1 tables

Code (Text):

+--------+--------+-------+---------+--------+------------+---------+
| engine | tables | rows  | data    | idx    | total_size | idxfrac |
+--------+--------+-------+---------+--------+------------+---------+
| InnoDB |    214 | 44106 | 34.39MB | 8.80MB | 43.19MB    |    0.26 |
| MEMORY |      5 | 2     | 0.06MB  | 0.06MB | 0.12MB     |    1.00 |
| MyISAM |      4 | 6     | 0.00MB  | 0.01MB | 0.01MB     |    8.26 |
+--------+--------+-------+---------+--------+------------+---------+

Xenforo 2.0.0 Beta 1 tables

Code (Text):

+--------------------------------------------+----------------+----------------+-----------+------------+---------+------------+--------------------+
| Table Name                                 | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION    |
+--------------------------------------------+----------------+----------------+-----------+------------+---------+------------+--------------------+
| xd5.xf_addon                             | 4 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_admin                             | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_admin_log                         | 66 Rows        | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_admin_navigation                  | 136 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_admin_permission                  | 29 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_admin_permission_entry            | 28 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_advertising                       | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_advertising_position              | 23 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_approval_queue                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_attachment                        | 2 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_attachment_data                   | 2 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_attachment_view                   | 0 Rows         | MEMORY         | 0.00MB    | 0.00MB     | 0.00MB  | Fixed      | utf8mb4_general_ci |
| xd5.xf_ban_email                         | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_bb_code                           | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_bb_code_media_site                | 18 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_captcha_log                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_captcha_question                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_category                          | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_change_log                        | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_class_extension                   | 9 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_code_event                        | 61 Rows        | InnoDB         | 0.06MB    | 0.00MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_code_event_listener               | 18 Rows        | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_connected_account_provider        | 7 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_content_spam_cache                | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_content_type_field                | 183 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_conversation_master               | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_conversation_message              | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_conversation_recipient            | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_conversation_user                 | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_cron_entry                        | 22 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_css_cache                         | 24 Rows        | InnoDB         | 1.52MB    | 0.02MB     | 1.53MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_data_registry                     | 39 Rows        | InnoDB         | 0.25MB    | 0.00MB     | 0.25MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_deletion_log                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_draft                             | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_edit_history                      | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_email_bounce_log                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_email_bounce_soft                 | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_error_log                         | 5 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_es_index_failed                   | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_feed                              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_feed_log                          | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_file_check                        | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_find_new                          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_find_new_default                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_flood_check                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_forum                             | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_forum_field                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_forum_prefix                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_forum_prompt                      | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_forum_read                        | 1 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_forum_watch                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_help_page                         | 5 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_image_proxy                       | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_image_proxy_referrer              | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_import_log                        | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_ip                                | 6 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_ip_match                          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_job                               | 1 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_language                          | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_liked_content                     | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_link_forum                        | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_link_proxy                        | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_link_proxy_referrer               | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_login_attempt                     | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mail_queue                        | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_member_stat                       | 8 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_album                          | 1 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_album_comment_read             | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_album_view                     | 0 Rows         | MEMORY         | 0.00MB    | 0.00MB     | 0.00MB  | Fixed      | utf8mb4_general_ci |
| xd5.xf_mg_album_watch                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_category                       | 1 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_category_field                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_category_watch                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_comment                        | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_media_comment_read             | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_media_field                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_media_field_value              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_media_item                     | 2 Rows         | InnoDB         | 0.02MB    | 0.09MB     | 0.11MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_media_note                     | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_media_temp                     | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_media_user_view                | 2 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_media_view                     | 0 Rows         | MEMORY         | 0.00MB    | 0.00MB     | 0.00MB  | Fixed      | utf8mb4_general_ci |
| xd5.xf_mg_media_watch                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_rating                         | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_shared_map_add                 | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_shared_map_view                | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_mg_transcode_queue                | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_moderator                         | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_moderator_content                 | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_moderator_log                     | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_navigation                        | 52 Rows        | InnoDB         | 0.06MB    | 0.02MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_navigation_type                   | 3 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_news_feed                         | 1 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_node                              | 2 Rows         | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_node_type                         | 4 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_notice                            | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_notice_dismissed                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_oembed                            | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_oembed_referrer                   | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_option                            | 204 Rows       | InnoDB         | 0.06MB    | 0.00MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_option_group                      | 30 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_option_group_relation             | 240 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_page                              | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_payment_profile                   | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_payment_provider                  | 4 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_payment_provider_log              | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_permission                        | 197 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_permission_cache_content          | 8 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_permission_combination            | 2 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_permission_combination_user_group | 4 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_permission_entry                  | 212 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_permission_entry_content          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_permission_interface_group        | 19 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_phrase                            | 6317 Rows      | InnoDB         | 1.52MB    | 0.58MB     | 2.09MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_phrase_compiled                   | 13647 Rows     | InnoDB         | 2.52MB    | 0.00MB     | 2.52MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_phrase_map                        | 12374 Rows     | InnoDB         | 1.02MB    | 2.69MB     | 3.70MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_poll                              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_poll_response                     | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_poll_vote                         | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_post                              | 1 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_profile_post                      | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_profile_post_comment              | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_purchasable                       | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_purchase_request                  | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_registration_spam_cache           | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_report                            | 0 Rows         | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_report_comment                    | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_category                       | 1 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_category_field                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_category_prefix                | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_category_watch                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_resource                       | 0 Rows         | InnoDB         | 0.02MB    | 0.11MB     | 0.13MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_resource_download              | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_resource_feature               | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_resource_field                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_resource_field_value           | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_resource_prefix                | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_resource_prefix_group          | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_resource_rating                | 0 Rows         | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_resource_update                | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_resource_version               | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_rm_resource_watch                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_route                             | 178 Rows       | InnoDB         | 0.05MB    | 0.02MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_route_filter                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_search                            | 1 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_search_index                      | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  | Dynamic    | utf8mb4_general_ci |
| xd5.xf_session                           | 4 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  | Dynamic    | utf8mb4_general_ci |
| xd5.xf_session_activity                  | 2 Rows         | MEMORY         | 0.06MB    | 0.06MB     | 0.12MB  | Fixed      | utf8mb4_general_ci |
| xd5.xf_session_admin                     | 1 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  | Dynamic    | utf8mb4_general_ci |
| xd5.xf_session_install                   | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  | Dynamic    | utf8mb4_general_ci |
| xd5.xf_sitemap                           | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_smilie                            | 31 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_smilie_category                   | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_spam_cleaner_log                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_spam_trigger_log                  | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_stats_daily                       | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_style                             | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_style_property                    | 208 Rows       | InnoDB         | 0.08MB    | 0.02MB     | 0.09MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_style_property_group              | 28 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_style_property_map                | 416 Rows       | InnoDB         | 0.06MB    | 0.03MB     | 0.09MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_tag                               | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_tag_content                       | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_tag_result_cache                  | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_template                          | 830 Rows       | InnoDB         | 23.52MB   | 0.13MB     | 23.64MB | Compact    | utf8mb4_general_ci |
| xd5.xf_template_history                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_template_map                      | 2382 Rows      | InnoDB         | 0.17MB    | 0.23MB     | 0.41MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_template_modification             | 14 Rows        | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_template_modification_log         | 14 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_template_phrase                   | 5868 Rows      | InnoDB         | 0.39MB    | 0.28MB     | 0.67MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_tfa_attempt                       | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_tfa_provider                      | 3 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_thread                            | 1 Rows         | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_thread_field                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_thread_field_value                | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_thread_prefix                     | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_thread_prefix_group               | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_thread_prompt                     | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_thread_prompt_group               | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_thread_read                       | 1 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_thread_redirect                   | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_thread_reply_ban                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_thread_user_post                  | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_thread_view                       | 0 Rows         | MEMORY         | 0.00MB    | 0.00MB     | 0.00MB  | Fixed      | utf8mb4_general_ci |
| xd5.xf_thread_watch                      | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_trophy                            | 9 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_upgrade_job                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_upgrade_log                       | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user                              | 1 Rows         | InnoDB         | 0.02MB    | 0.19MB     | 0.20MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_alert                        | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_alert_optout                 | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_authenticate                 | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_ban                          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_change_temp                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_confirmation                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_connected_account            | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_field                        | 3 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_field_value                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_follow                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_group                        | 4 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_group_change                 | 2 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_group_promotion              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_group_promotion_log          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_group_relation               | 3 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_ignored                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_option                       | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_privacy                      | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_profile                      | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_reject                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_remember                     | 1 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_tfa                          | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_tfa_trusted                  | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_title_ladder                 | 4 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_trophy                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_upgrade                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_upgrade_active               | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_user_upgrade_expired              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_warning                           | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_warning_action                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_warning_action_trigger            | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_warning_definition                | 4 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_widget                            | 15 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_widget_definition                 | 22 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Compact    | utf8mb4_general_ci |
| xd5.xf_widget_position                   | 23 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8mb4_general_ci |
+--------------------------------------------+----------------+----------------+-----------+------------+---------+------------+--------------------+

eva2000 · Sep 6, 2017

Xenforo 2.0.0 Beta 1 Debug Mode

Some styling bugs it seems
Code (Text):
Page Time: 0.0233s
Memory: 2.4638 MB (Peak: 2.5486 MB)
Queries (15, time: 0.0040s, 17.1%)

eva2000 · Sep 6, 2017

Xenforo 2.0.0 Beta 1 Bugs

Bugs are reported at Bug reports [2.x]

Resolved bugs at Resolved bug reports [2.x] tag: Fixed bugs

eva2000 · Sep 6, 2017

Xenforo 2.0.0 Beta 1 Native Redis Server Support

Update, Xenforo 2.0.0 Beta 1 has a few bugs for Redis support which would be resolved in 2.0.0 Beta 2.

Xenforo 2.0 supports Redis server caching natively out of the box it seems.

Need to make sure PHP has Redis PHP extension installed. Centmin Mod 123.09beta01 by default installs Redis PHP extension

Code (Text):

php --ri redis

redis

Redis Support => enabled
Redis Version => 3.1.3
Available serializers => php, igbinary

You'd need to install Redis server via Remi YUM repo yourself if you haven't already as outlined at https://community.centminmod.com/threads/how-to-install-redis-server-on-centmin-mod-lemp-stack.4546/. Or use redis-install.sh script I wrote for redis-generator.sh project. Using these SSH commands on your Centmin Mod 123.09beta01 based LEMP stack server.

Code (Text):

cd /root/tools/
git clone https://github.com/centminmod/centminmod-redis
cd centminmod-redis
./redis-install.sh install

Edit /etc/redis.conf and remove the requiredpass line if it exists

Code (Text):

requirepass xfxxxxxx

restart Redis server

Code (Text):

service redis restart

check redis info via redis-cli info command

Code (Text):

redis-cli info 
# Server
redis_version:4.0.1
redis_git_sha1:00000000
redis_git_dirty:0
redis_build_id:b9e3021da3c16feb
redis_mode:standalone
os:Linux 2.6.32-042stab116.1 x86_64
arch_bits:64
multiplexing_api:epoll
atomicvar_api:atomic-builtin
gcc_version:4.8.5
process_id:2721
run_id:31560ad218d5daf8c4be9972fa5f236cf97e4f46
tcp_port:6379
uptime_in_seconds:3
uptime_in_days:0
hz:10
lru_clock:11499476
executable:/usr/bin/redis-server
config_file:/etc/redis.conf

# Clients
connected_clients:1
client_longest_output_list:0
client_biggest_input_buf:0
blocked_clients:0

# Memory
used_memory:513136
used_memory_human:501.11K
used_memory_rss:2437120
used_memory_rss_human:2.32M
used_memory_peak:513136
used_memory_peak_human:501.11K
used_memory_peak_perc:112.94%
used_memory_overhead:503982
used_memory_startup:454352
used_memory_dataset:9154
used_memory_dataset_perc:15.57%
total_system_memory:2147483648
total_system_memory_human:2.00G
used_memory_lua:37888
used_memory_lua_human:37.00K
maxmemory:0
maxmemory_human:0B
maxmemory_policy:noeviction
mem_fragmentation_ratio:4.75
mem_allocator:jemalloc-3.6.0
active_defrag_running:0
lazyfree_pending_objects:0

# Persistence
loading:0
rdb_changes_since_last_save:0
rdb_bgsave_in_progress:0
rdb_last_save_time:1504671697
rdb_last_bgsave_status:ok
rdb_last_bgsave_time_sec:-1
rdb_current_bgsave_time_sec:-1
rdb_last_cow_size:0
aof_enabled:0
aof_rewrite_in_progress:0
aof_rewrite_scheduled:0
aof_last_rewrite_time_sec:-1
aof_current_rewrite_time_sec:-1
aof_last_bgrewrite_status:ok
aof_last_write_status:ok
aof_last_cow_size:0

# Stats
total_connections_received:3
total_commands_processed:4
instantaneous_ops_per_sec:1
total_net_input_bytes:56
total_net_output_bytes:108
instantaneous_input_kbps:0.01
instantaneous_output_kbps:0.03
rejected_connections:0
sync_full:0
sync_partial_ok:0
sync_partial_err:0
expired_keys:0
evicted_keys:0
keyspace_hits:0
keyspace_misses:0
pubsub_channels:0
pubsub_patterns:0
latest_fork_usec:0
migrate_cached_sockets:0
slave_expires_tracked_keys:0
active_defrag_hits:0
active_defrag_misses:0
active_defrag_key_hits:0
active_defrag_key_misses:0

# Replication
role:master
connected_slaves:0
master_replid:d3038a0ae2a0573ae05fa86b05c31ef3d46c42b6
master_replid2:0000000000000000000000000000000000000000
master_repl_offset:403074
second_repl_offset:-1
repl_backlog_active:0
repl_backlog_size:1048576
repl_backlog_first_byte_offset:0
repl_backlog_histlen:0

# CPU
used_cpu_sys:0.00
used_cpu_user:0.00
used_cpu_sys_children:0.00
used_cpu_user_children:0.00

# Cluster
cluster_enabled:0

# Keyspace

add to src/config.php and ensure Redis server is installed as per above instructions within this post

Code (Text):

$config['cache']['enabled'] = true;
$config['cache']['sessions'] = true;
$config['cache']['config'] = [
   'host' => '127.0.0.1'
];
$config['cache']['provider'] = 'Redis';

eva2000 · Sep 11, 2017

Xenforo 2.0.0 Beta1 + ngx_pagespeed + Brotli

Testing Centmin Mod 123.09beta01's Nginx HTTP/2 HTTPS + Google ngx_pagespeed nginx module + Google Brotli compression replacing gzip/deflate HTTP compression

GTMetrix, Webpagetest and Google Insight numbers

eva2000 · Sep 12, 2017

Xenforo 2.0 Replication Master/Slave Adapter

Good news XF 2 will support splitting MySQL reads and writes via MySQL replication master/slave configurations Implemented - [SUGGESTION] MySQL Read-Slave, Write-Master

XF2 features a new "ReplicationAdapter" which allows separate read and write connections to be made.

You can see a typical example of configuration below:

PHP:

$config['db']['adapterClass'] = 'XF\Db\Mysqli\ReplicationAdapter'; $config['db']['write'] = [ 'host' => '192.168.10.1', // ... username, password, dbname etc. ]; $config['db']['read'] = [ 'host' => '192.168.10.2', // ... username, password, dbname etc. ];

Click to expand...

eva2000 · Sep 13, 2017

Xenforo 2.0.0 Beta 2 Release Upgrade

Xenforo 2.0.0 Beta 2 has been released along with official XF addons for Enhanced Search, Resource Manager and Media Gallery. You can upgrade the old XF 1.x method - upload files and run upgrade within admin area. Or use the new PHP CLI command line method via SSH from within the Xenforo 2 install directory.

For me using the above CLI install method, the upgrade would simply be the following SSH commands after you have uploaded the updated versions and a nginx + php-fpm restart via (nprestart) to clear Zend Opcache caching.

Code (Text):

domain='newdomainx.com'
cd /home/nginx/domains/${domain}/public
nprestart
time php cmd.php xf:upgrade
time php cmd.php xf:addon-upgrade XFES
time php cmd.php xf:addon-upgrade XFMG
time php cmd.php xf:addon-upgrade XFRM
nprestart

Example Xenforo 2.0.0 Beta 2 upgrade output where total combined time for upgrade was 75 seconds on 2 cpu core, 2GB memory OpenVZ server running Intel Xeon E5-1650v3 @3.5Ghz cpu.

Code (Text):

time php cmd.php xf:upgrade
Current version: 2000031
Upgrade target: 2000032 (2.0.0 Beta 2)
Are you sure you want to continue with the upgrade? [y/n] y

Running upgrade to 2.0.0 Beta 2, step 1... done.
Running upgrade to 2.0.0 Beta 2, step 2... done.
Importing... Master data (Templates)
Importing... Master data (Templates: 25.6%)
Importing... Master data (Templates: 56.5%)
Rebuilding... Phrases .

Upgrade completed successfully.

real    0m47.439s
user    0m18.573s
sys     0m1.570s

Code (Text):

time php cmd.php xf:addon-upgrade XFES
Please confirm that you want to upgrade the following add-on: (XenForo Enhanced Search 2.0.0 Beta 1) (y/n)y
Upgrading
Complete.

Importing add-on data
Importing... Add-on data (Admin navigation)
Importing... Add-on data (Code event listeners)
Importing... Add-on data (Cron)
Importing... Add-on data (Options)
Importing... Add-on data (Phrases)
Importing... Add-on data (Routes)
Importing... Add-on data (Templates)


real    0m14.042s
user    0m0.500s
sys     0m0.100s

Code (Text):

time php cmd.php xf:addon-upgrade XFMG
Please confirm that you want to upgrade the following add-on: (XenForo Media Gallery 2.0.0 Beta 1) (y/n)y
Upgrading .
Complete.

Importing add-on data
Importing... Add-on data (Admin navigation)
Importing... Add-on data (Admin permission)
Importing... Add-on data (Bb codes)
Importing... Add-on data (Class extensions)
Importing... Add-on data (Code events)
Importing... Add-on data (Code event listeners)
Importing... Add-on data (Content type fields)
Importing... Add-on data (Cron)
Importing... Add-on data (Member stats)
Importing... Add-on data (Navigation)
Importing... Add-on data (Options)
Importing... Add-on data (Option groups)
Importing... Add-on data (Permissions)
Importing... Add-on data (Permission interface groups)
Importing... Add-on data (Phrases)
Importing... Add-on data (Routes)
Importing... Add-on data (Style properties)
Importing... Add-on data (Style property groups)
Importing... Add-on data (Templates)
Importing... Add-on data (Template modifications)
Importing... Add-on data (Widget definitions)
Importing... Add-on data (Widget positions)


real    0m7.713s
user    0m2.655s
sys     0m0.197s

Code (Text):

time php cmd.php xf:addon-upgrade XFRM
Please confirm that you want to upgrade the following add-on: (XenForo Resource Manager 2.0.0 Beta 1) (y/n)y
Upgrading
Complete.

Importing add-on data
Importing... Add-on data (Admin navigation)
Importing... Add-on data (Admin permission)
Importing... Add-on data (Class extensions)
Importing... Add-on data (Code event listeners)
Importing... Add-on data (Content type fields)
Importing... Add-on data (Member stats)
Importing... Add-on data (Navigation)
Importing... Add-on data (Options)
Importing... Add-on data (Option groups)
Importing... Add-on data (Permissions)
Importing... Add-on data (Permission interface groups)
Importing... Add-on data (Phrases)
Importing... Add-on data (Routes)
Importing... Add-on data (Templates)
Importing... Add-on data (Template modifications)
Importing... Add-on data (Widget definitions)
Importing... Add-on data (Widget positions)


real    0m6.007s
user    0m2.478s
sys     0m0.170s

Thanks @Chris D for heads up on CLI upgrade instructions

eva2000 · Sep 13, 2017

Xenforo 2.0.0 Beta 2 MySQL Table Structures

If you're testing upgrades from an existing Xenforo 1.5.x install with 3rd party addons, then some of the standard Xenforo database tables may have additional fields, indexes or columns added which Xenforo 2.x upgrade installer might not expect. So you need to visually be able to compare the two if you run into upgrade issues.

You can use my mysqlmymonlite.sh script to do just that as outlined here. The mysqlmymonlite.sh has a showcreate option which can output a MySQL database's table structures either to SSH stdout screen which you copy and paste into a file or output to individual database table named text files (which is harder to do visual compare with). Example outlined here of showcreate option.

Install mysqlmymonlite.sh on Centmin Mod servers - this is one whole line command
Code (Text):
mkdir -p /root/tools; cd /root/tools; rm -rf /root/mysqltuner.pl; rm -rf mysqlmymonlite.sh; wget http://mysqlmymon.com/download/mysqlmymonlite.zip; unzip -o mysqlmymonlite.zip; mv centos/mysqlmymonlite.sh .; rm -rf mysqlmymonlite.zip centos centos_whm debian changelog*; chmod +x mysqlmymonlite.sh
run mysqlmymonlite.sh showcreate and output database tables for database named = DBNAME. The output is to screen so you need for your SSH client's scrollback buffer to be larger i.e. 256000 rows. Just highlight and copy and paste output to a text file. Do the same for both Xenforo 1.5.x and 2.x database names. So you end up with 2 text files and just use a file comparison tool to compare table structures. If you install a fresh test Xenforo 1.5.x instance, you can have a 3rd database showcreate text file for default XF 1.5 database table structure so you can do file compare between XF 1.5 default vs XF 1.5 your custom install vs XF 2.x.
Code (Text):
./mysqlmymonlite.sh showcreate
Code (Text):
./mysqlmymonlite.sh showcreate

What is your mysql database name ? DBNAME

Do you want to display all DBNAME tables' schema (how table was created) ? [y/n] y

Do you want save output to text file ? Answering no will output only to screen. [y/n] n
sample output would be
Code (Text):
*************************** 1. row ***************************
       Table: xf_addon
Create Table: CREATE TABLE `xf_addon` (
  `addon_id` varbinary(50) NOT NULL,
  `title` varchar(75) NOT NULL,
  `version_string` varchar(30) NOT NULL DEFAULT '',
  `version_id` int(10) unsigned NOT NULL DEFAULT '0',
  `json_hash` varbinary(64) NOT NULL DEFAULT '',
  `active` tinyint(3) unsigned NOT NULL,
  `is_legacy` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `is_processing` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`addon_id`),
  KEY `title` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
*************************** 1. row ***************************
       Table: xf_admin
Create Table: CREATE TABLE `xf_admin` (
  `user_id` int(10) unsigned NOT NULL,
  `extra_user_group_ids` varbinary(255) NOT NULL,
  `last_login` int(10) unsigned NOT NULL DEFAULT '0',
  `permission_cache` mediumblob,
  `admin_language_id` int(10) unsigned NOT NULL DEFAULT '0',
  `is_super_admin` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
*************************** 1. row ***************************
Example using file compare tool Beyondcompare for my XF 1.5 install database structure (left) and XF 2.0.0 beta2 (right)

Log in / Register

Forums

Get the most out of your Centmin Mod LEMP stack

Xenforo Xenforo 2.0.0 Beta 1 Released

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Install Guide on Centmin Mod LEMP Stack

Xenforo 2.0.0 Beta 1 Reinstall Guide

eva2000 Administrator Staff Member

XF 2 Beta 1 Addons

eva2000 Administrator Staff Member

Xenforo 2.0.0 Enhanced Search Beta 1 Options

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Media Gallery

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Resource Manager

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Enhanced Search

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 MySQL Info

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Debug Mode

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Bugs

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Native Redis Server Support

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta1 + ngx_pagespeed + Brotli

eva2000 Administrator Staff Member

Xenforo 2.0 Replication Master/Slave Adapter

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 2 Release Upgrade

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 2 MySQL Table Structures

.

Log in / Register

Useful Searches

Get the most out of your Centmin Mod LEMP stack

Xenforo Xenforo 2.0.0 Beta 1 Released

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Install Guide on Centmin Mod LEMP Stack

Xenforo 2.0.0 Beta 1 Reinstall Guide

eva2000 Administrator Staff Member

XF 2 Beta 1 Addons

eva2000 Administrator Staff Member

Xenforo 2.0.0 Enhanced Search Beta 1 Options

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Media Gallery

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Resource Manager

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Enhanced Search

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 MySQL Info

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Debug Mode

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Bugs

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 1 Native Redis Server Support

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta1 + ngx_pagespeed + Brotli

eva2000 Administrator Staff Member

Xenforo 2.0 Replication Master/Slave Adapter

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 2 Release Upgrade

eva2000 Administrator Staff Member

Xenforo 2.0.0 Beta 2 MySQL Table Structures

.