If your server is suddenly down or having performance issues and you're not sure where to begin, this article outlines some first-aid troubleshooting steps for discovering the cause.
The MySQL version available on a server is determined by the server's Ubuntu release as shown in the table below.
The max_connections system variable sets the maximum permitted number of simultaneous client connections. If you are seeing "Too many connections"
Introduction Normally, you access each MySQL database using a separate database user. In some cases—such as accessing many different databases from the command line—it is easier to have a single MySQL account that can access any database.
If you're not familiar with using SSH, it's easier to export a database using PhpMyAdmin. However, if your database is very large (for example, more than 1GB), it can be easier to export a database using MySQL from the command line.
If you're not familiar with using SSH, it's easier to import a database using phpMyAdmin. However, if your database is very large (for example, more than 1GB), it can be easier to import a database using MySQL from the command line.
The InnoDB buffer pool is MySQL's in-memory cache of the contents of tables and indexes. For optimal performance, the InnoDB buffer pool should be large to hold the full contents of all databases.
MySQL's open table cache allows opened tables to be reused by subsequent queries. For every table used by a query, MySQL needs to load the table's metadata and open file descriptors.
The open files limit is the maximum number of file descriptors the operating system will allow processes such as MySQL to have.
To change a database user's password, follow the steps below. First, open your app in ServerPilot and click Databases.
Many PHP apps require a MySQL database. You can create MySQL databases for apps in ServerPilot. First, open your app in ServerPilot and go to the Databases tab.
If your app was written for older versions of MySQL and is not compatible with strict SQL mode in MySQL 5.
Don't upgrade unless you need to! Database upgrades are risky. If something goes wrong during the update, all of your data may be lost.
ServerPilot configures MySQL to manage databases on your server. Typically, when logged into SSH as the root user, you would only need to type the following at the command line (SSH) prompt to access MySQL:
This is an advanced tutorial. Careful! We cannot provide any assistance for this process nor can we help with any problems caused by it.
It is possible to replace MySQL with MariaDB; however, you should not do so unless you are an experienced system administrator.
There are two ways to export a database with phpMyAdmin depending on the version installed on your app. Exporting from a Newer Version of phpMyAdmin The latest version offers the simplest means.
After you've created a database in ServerPilot and installed phpMyAdmin on your app, you can import a database to your app.
In this tutorial, we'll show you how to install phpMyAdmin. This tutorial assumes you have already connected your server to ServerPilot and that you have created at least one app on the server.
One copy of phpMyAdmin installed on a single app on your server will allow you to access all of your apps' databases; however, if you don't want phpMyAdmin installed on one of your existing apps, you can install it on its own with the same result.
Introduction If you are configuring backups of a server, you need to know what data to back up. This information is useful whether you are making on-server backups or configuring automated backups to other servers or cloud storage services.
This is an advanced tutorial. Introduction For applications you are building where you've designed your own database schema, it is common to need to debug performance issues when databases grow very large.
Introduction MySQL is a database server that your apps such as WordPress use to store data. In some cases, you may want to interact with MySQL while SSH'd into your server.