How can I tell what is using MySQL?

Question

Just use mysql_query (or mysqli_query, even better, or use PDO, best of all) with: SELECT DATABASE() FROM DUAL;. Addendum: There is much discussion over .How do I tell what is using most memory in MySQL - Stack OverflowDetermine which MySQL configuration file is being usedHow to retrieve the current version of a MySQL database .Using MySQL Workbench, how can I tell if a column has the AUTO .Другие результаты с сайта stackoverflow.com

How do I know which database MySQL is using?

mysql> show databases; Here is the output that displays all the databases. As you can see above, we have both databases, and we can get the current database name with the help of DATABASE() method.

How can I see what processes are running in MySQL?

Type in MYSQL to get into the mysql command line. Type show processlist; in order to see current processes on the server.

How do I know which configuration file MySQL is using?

Support Network1Find the configuration files. By default, you can find the MySQL® configuration files in: /etc/mysql. ... 2my. cnf configuration file. ... 3Log files. Log files are the best place to start troubleshooting any program. ... 4mysqld and mysqld_safe. ... 5mysqladmin. ... 6Backups. ... 7Database engine. ... 8Related articles.

How do I know what engine is MySQL using?

To determine which engine a database table is currently using, type the following command at the mysql> prompt. Replace database with the name of the database that you want to check: Copy SELECT TABLE_NAME, ENGINE FROM information_schema. TABLES where TABLE_SCHEMA = 'database';

Expert · Answer