List:General Discussion« Previous MessageNext Message »
From:PRATIKSHA JAISWAL Date:August 9 2010 4:01pm
Subject:info on mysql
View as plain text  
Hi All,

How can i get following information from database or is there any query for
the same.

(1) mysql server uptime
(2) Total number of users connected to server
(3) Data file information / where it is located through mysql prompt / size
of data file
(4) each Database size
(5) Database I/O information
(6) Invalid object in database
(7) Database performance statistics queries
(8) Top 5 queries taking more time for executions.
(9) Engine information.


--
Thanks
Pratiksha

Thread
info on mysqlPRATIKSHA JAISWAL9 Aug
  • RE: info on mysqlGavin Towey9 Aug
  • Re: info on mysqlAnirudh Sundar10 Aug
    • Re: info on mysqlPRATIKSHA JAISWAL11 Aug
      • Re: info on mysqlPrabhat Kumar11 Aug
Re: info on mysqlPrabhat Kumar11 Aug