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...
Support Issues & Questions
Collapse
105 results in 0.0088 seconds.
Keywords
Members
Tags
-
Understanding MySQL's Table Status Output
- Created by: Wayne Luke
- Published: Thu 22 Feb '24, 10:13am
- 0 comments
in Reference -
The vBulletin upgrade took a long time is there any way to speed up
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...Last edited by Dikky Hardian; Wed 6 Dec '23, 11:26pm. -
Tables without primary key
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... -
Forums in Profile Activities?
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?
...2 PhotosLast edited by Danloona; Wed 25 Mar '20, 2:18am. -
vBulletin 5 Database Best Practices
- Created by: Wayne Luke
- Published: Sat 1 Dec '18, 8:09am
- 0 comments
vBulletin 5 Database Best Practices
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. ...Last edited by Wayne Luke; Wed 8 Apr '20, 8:06am. -
Message Center Moderation - pending posts redirects to forum home page
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... -
Can I use MySQL 8 with vBulletin 5.4.
Can I use MySQL 8 with vBulletin 5.4. The documentation says 5.6 or higher, but I think the documentation predates MySQL 8. -
Upgrade to MariaDB from mySQL 5.6 for a vb5 forum?
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...Last edited by Maltair; Sat 18 Nov '17, 11:30am. -
[RESOLVED] Sphinx indexer issue with MySQL 5.7.*
When you've decided move your forum search to ultimate fast Sphinx engine, you can got an indexer error:
Code:$ indexer --config /home/eham/sphinx.conf --all Sphinx 2.2.11-id64-release (95ae9a6)
-
I can't approve a new posts in admincp
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... -
Vbulletin Database error in vBulletin 4.2.3:
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... -
MySQL error upgrading from 3.8 tp 4.2.4
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... -
Creating a PHP Module using data from a MySQL database
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...Last edited by Wayne Luke; Fri 16 Oct '15, 9:28am.👍 2 -
Transfere Database Tables to over Server not Completed
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...Last edited by apache@93; Mon 14 Sep '15, 12:34am.