Viewing your database logs

 

Overview

This article provides information about various MySQL server types and the log viewing options for each one.

Background

DreamHost MySQL users do not have access to MySQL server logs. However, depending on which type of MySQL server your databases are running on, it may be possible for support to retrieve them for you.

Checking MySQL server type

Visit the MySQL Databases page, which shows you a list of all of your hostnames and databases. At the top of the section, your database server name is listed.

  • If the database server name starts with iad1, this means you're on a Shared MySQL server. For example, "iad1-mysql-e2-20a:rudie" MySQL Server.
  • If the database server name starts with sql and is followed by a number, this means you're using a private MySQL server. For example, "sql###:mysql" MySQL Server.

  • If the database server name starts with ds and is followed by a number, this means you're using a dedicated MySQL server. For example, "ds###:mysql" MySQL Server.

Log options per server

The following provides the available log options for each database server type.

Shared MySQL servers

Unfortunately, logs are not available on Shared MySQL servers. This means that even technical support would be unable to retrieve them for you.

Private MySQL servers

Logs on a private MySQL server are available only if you contact DreamHost support. Make sure to specify the database name and time frame you wish to retrieve logs from.

Dedicated Servers

On a Dedicated Server, the MySQL databases are on the same machine. This means you can retrieve them by logging into the server via SSH.

DreamCompute

DreamCompute is completely configured manually, so any configuration is completely up to you.

See also

Did this article answer your questions?

Article last updated PST.

Still not finding what you're looking for?