Understanding MySQL's Table Status Output

AdminCP → Maintenance → Diagnostics → System Information MySQL's SHOW TABLE STATUS command helps gather information about tables in a database. When executed, it provides a detailed overview of various metrics related to each table in the database. This information can be valuable for database administrators and developers to optimize performance, troubleshoot issues, and better understand their databases' structure. Let's delve into the output of MySQL's SHOW TABLE STATUS command and underst...

[Dikky Hardian]

Is there any additional method to speed up the upgrade process?

my database size is 24GB
size table:


upgrade from :
vbulletin 4.2.5
to
vbulletin5...

[Ghugot]

Hi,

I noticed in MySQL some tables has no primary key set : humanverify and googlemapme_settings (I assume this is two tables created by default by vBulletin).
Is there a reason for...

[drew.wilsford]

Hi support,

I have an issue when trying to install vB 5 connect v5.6.4, using the install script. It seems to connect to the correct database, but then generates an error when it cannot find...

[Danloona]

Hello,

I've upgraded vBulletin 4.2.5 to 5.5.6 on testing instance.

And i have strange issue, on my profile only mine, i have forums in last activities than posts?

...

The database is the heart and soul of your vBulletin site. All content and user information is stored in the database. Protect the database and you protect your site. This document will go over the creation and usage of a MySQL database for the use of vBulletin 5 Connect. If you have shared hosting and are provided a web-based control panel like cPanel, you will need to access your hosting provider's documentation on how to carry out these operations. This document assumes a general familiarity with the command line operations of your Operating System. All commands listed assume that you are accessing your server via SSH. ...

[robomoth]

We are using vBulletin 5.4.2 and we've been having issues with moderating posts in the message center for a while, even with previous versions of vb5.

When a moderator or admin attempts to...

[RoyBrinkley]

Can I use MySQL 8 with vBulletin 5.4. The documentation says 5.6 or higher, but I think the documentation predates MySQL 8.

[Maltair]

I have been wondering about this for a while now. Hostgator VPS, running cpanel.

I am currently running mySQL 5.6.37 I believe that all or most all of my tables that may be converted are...

[qpo]

When you've decided move your forum search to ultimate fast Sphinx engine, you can got an indexer error:

$ indexer --config /home/eham/sphinx.conf --all
Sphinx 2.2.11-id64-release (95ae9a6)

...

[[email protected]]

Hello guys !
i get a problem after upgraded my forum from 4.2.3 to 5.3.0.
this problem i can't Moderate ( approve or ignore...... ) a new topics or posts in my forum. I repaired tables SQL...

[Trendri]

I was currently upgrading my vbulletin site to 4.2.3: and it came up with error on step 4/8
I click next and it came up with database error Step 3) Import latest language

Importing...

[mrmckoy]

Using php 5.5 via http://mymodeltalk.com/jobs/install/upgrade.php. I submitted ticket: 1511952. Not sure why but i'm getting this error as the upgrade processes:


Upgrading to 4.0.8...

[Wayne Luke]

Today, I am going to show you how to pull information out of a database and show it in PHP Module in vBulletin 5. We'll be covering several different PHP techniques here but none of them are extremely...

[apache@93]

Hello Guys,
I have one big problem, I start changing to new server hosting
Just after my Backup by Cpanel & phpmyadmin is not 100% ok
All time i have 250 Tables all work fine...