Nexcess Knowledge Base
June 01, 2023
By Nexcess
How to truncate MySQL tables from the CLI
Learn how to truncate MySQL tables from the CLI using this article from Nexcess. Truncation of MySQL tables is simple with these eight simple steps.
Posted in:
Tags:
mysql database,mysql query optimization,database,data,mysql database management ,database tables,database tuning,wordpress database,database table names & sizes,database field names & details ,mysql servers and databases,tuning your mysql database for performance ,woocommerce setup,Magento,web applications,website design,website performance
November 02, 2022
How to monitor running MariaDB and MySQL queries
You need a way to check the status of your running MariaDB and MySQL queries, and so we will cover how to monitor them directly from your Nexcess Client Portal.
February 15, 2022
Tuning Your MySQL Database for Performance
Avoid a slow MySQL database and avoid a slow website! Delight your visitors with the performance! Reduce your server costs with MySQL database efficiency!
Grow your online business faster with news, tips, strategies, and inspiration.
- .htaccess
- Affiliates
- Applications
- Backups
- Billing
- Business
- CDN
- CDN SSL
- Client Portal
- Content Delivery Networks (CDNs)
- Control Panel Tools
- Craft CMS
- Cron Jobs
- Databases
- Dev Sites
- Domain Management
- Drupal
- Ecommerce
- Enterprise Hosting
- ExpressionEngine
- FTP
- File Management
- Getting Started
- Hosting
- IP Management
- Magento
- Magento 1
- Magento 2
- Membership sites
- Miscellaneous
- Nexcess
- Nexcess Email Services
- NodeWorx
- Other Applications
- Other Best Practices
- PCI DSS
- PWA
- Performance
- Reports and Monitoring
- SSH
- SSL
- Scripts
- Security
- SiteWorx
- StoreBuilder
- Third Party Clients
- WPQuickStart
- Web design
- Web development
- Website Management
- Websites
- WooCommerce
- WordPress