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 Table
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_SCHEMA AS
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
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,
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 :-
mysqlshow global status like '%user%';
---Database Table wise Size in MB---
SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME AS
Alfredo,
I have just a few additional questions that you did not already answer in
your very well-formed post. I normally wouldn't worry about ANY of these
issues but you seem to be exploring the envelope of performance on your
system and every little bit counts:
Which communication path are
Hi,
thank you very much for your reply.
Now I answer you about your additional questions:
Now the daemon is installed on a machine different than DB Server, so I
use DBServer NIC IP Address for connect to it from the daemon (So I don't
use Unix Sockets).
But, looking at the Network Bandwidth,
Yup, MySQL works quite well as a lock server; we've been using it as such
for years.
I would suggest looking at the get_lock() function specifically. It's
designed to do exactly what you're looking for, and it won't require
knowledge of any tables or rows.
Cheers.
-Dana
-Original
On Fri, Jan 03, 2003 at 11:10:38AM -0600, Dana Diederich wrote:
Yup, MySQL works quite well as a lock server; we've been using it as such
for years.
Yeah, do we.
I would suggest looking at the get_lock() function specifically. It's
designed to do exactly what you're looking for, and it
Hi
First of all this question belongs on the [EMAIL PROTECTED] mailing
list.
Secondly, you should not be sending this kind of a question to the MySQL
developers
Thirdly, the QMYSQL3 driver is part of the QtV3.0.x distribution. I presume
you have the X-11 Free Edition of Qt, so run ./configure
10 matches
Mail list logo