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
, then use either mysql_dump_slow or maatkit's mk-query-digest
to parse the log.
-Original Message-
From: PRATIKSHA JAISWAL [mailto:pratikshadjayswa...@gmail.com]
Sent: Monday, August 09, 2010 9:01 AM
To: mysql@lists.mysql.com
Subject: info on mysql
Hi All,
How can i get foll
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 info
On Saturday 21 December 2002 15:14, Paul P Komkoff Jr wrote:
> I tracked down the bug
>
> I have one table with BLOB field in it
> Then I execute queries like
>
> SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% blabla %'))
>
> here, keywords is a blob fields
>
> when (LOWER(keywords) LI
I tracked down the bug
I have one table with BLOB field in it
Then I execute queries like
SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% blabla %'))
here, keywords is a blob fields
when (LOWER(keywords) LIKE LOWER('% blabla %')) is true, mysql dies
hope this helps
--
Paul P 'Stin