Viewing posts from: mysqladmin

06
Dec

Learn how to view all the MySQL Server status variable and it’s current value

By admin|Computer, MySQL

Use mysqladmin extended-status command to view all the mysql server status variable and it’s current value. mysqladmin -u root -ptestpassword extended-status +——————————————+————-+ | Variable_name | Value | +——————————————+————-+ | Aborted_clients | 0 | | Aborted_connects | 1 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Binlog_stmt_cache_disk_use | 0 | | Binlog_stmt_cache_use […]

Continue Reading →
06
Dec

Learn how to find current status of MySQL server

By admin|Computer, MySQL

To find current status of mysql you can use mysqladmin status with username and password. # mysqladmin -u root -ptestpassword status Uptime: 93516 Threads: 2 Questions: 49 Slow queries: 0 Opens: 54 Flush tables: 1 Open tables: 47 Queries per second avg: 0.0 The status command displays the following information: Uptime: Uptime of the mysql […]

Continue Reading →
30
Nov

Learn how to find out what version of MySQL running?

By admin|Computer, MySQL

Apart from giving the ‘Server version’, this command also displays the current status of the mysql server. mysqladmin -u root -p version Enter password: /Applications/MAMP/Library/bin/mysqladmin Ver 8.42 Distrib 5.5.9, for osx10.6 on i386 Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. […]

Continue Reading →