use Google :)
On Wed, Aug 11, 2010 at 10:02 PM, PRATIKSHA JAISWAL <
pratikshadjayswa...@gmail.com> wrote:
> Hi Prabhat,
>
> Thanks a ton for sharing your blogs with us.
>
> I am learning mysql database. I am very good at PostgreSQL.
>
> Do you have any other material where in i can go for Mysql C
check this,
http://adminlinux.blogspot.com/2009/12/mysql-tips-calculate-database-and-table.html
Thx
On Wed, Aug 11, 2010 at 5:23 PM, PRATIKSHA JAISWAL <
pratikshadjayswa...@gmail.com> wrote:
> Hi,
>
> Thanks all for your help.
>
> >>
> ---Database & Table wise Size in MB---
> SELECT TABLE_SCHE
Hi,
Thanks all for your help.
>>
---Database & Table wise Size in MB---
SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME AS 'Table',
CONCAT(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024),2),"
Mb") AS Size FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = "dbname";
>>---Database &
Hello Pratiksha,
To get the uptime of the MYSQL instance :-
mysql>\s
as given above just give the above command " \s "
For Total number of users connected to server :-
mysql>show global status like '%user%';
---Database & Table wise Size in MB---
SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME
For most of your questions, use:
SHOW GLOBAL STATUS;
SHOW GLOBAL VARIABLES;
(7) Database performance statistics queries
(8) Top 5 queries taking more time for executions.
(9) Engine information.
For these, you need to enable the slow query log, gather queries over a given
interval of time, the
