EMS logo

Products Navigation

SQL Manager for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for MySQL

On-line Documentation

Show host information


Show binary logs

Lists the binary log files on the server.

 

Show binary logs

 

Table displays log name and file size in respective columns.

 

 

Show binlogs events

Shows the events in the binary log. Binary log consists of files that store events describing changes in database.

 

Show binlogs events

 

Table displays log name, start log position, event type, server ID, end log position and additional info.

 

 

Show character set

Shows all available character sets.

 

Show character set

 

Table displays character set, its description, default collation (set of rules for data comparing, that is used by default for corresponding character set; these rules define table of codes and used for collation of current character set with Unicode and other formats) and max length (in bytes).

 

 

Show collation

Lists collations supported by the server.

 

Show collation

 

Table displays collation name, corresponding character set, collation ID, whether collation is default for its character set, is collation compiled on server and sorting length (memory size required for sorting string data).

 

 

Show databases

Lists the databases on the MySQL host.

 

Show databases

 

 

Show engines

Displays status information about the server's storage engines.

 

Show engines

 

Table displays engine name, whether engine is supported by server, brief comments, whether transactions, XA transactions and savepoints are supported by this engine.

 

 

Show errors

Shows the error messages that resulted from the last statement that generated messages in the current session.

 

Show errors

 

Table displays error level, error code and text of error message.

 

 

Show privileges

Shows the list of system privileges that the MySQL server supports. The list can vary depending on the current server version.

 

Show privileges

 

Table displays privilege name, context (objects, which this privilege can be applied to) and brief comments.

 

 

Show processlist

Lists threads which are currently running.

 

Show processlist

 

Table displays the connection ID, user who issued the statement, client host, default database (NULL if not selected), type of command the thread is executing, time in seconds that the thread has been is current state, state that indicates what the thread is doing, info - the statement the thread is executing (NULL if it is not executing any statement).

 

Show warnings

Shows the error, warning, and note messages that resulted from the last statement that generated messages in the current session.

 

Show warnings

 

Table displays warning level, its code and message.