mysql> select table_schema,sum(data_length+index

maximum size of a database in mysql?

Question Posted / a.kishan kumar

Answer Posted / a.kishan kumar

mysql> select
table_schema,sum(data_length+index_length)/1024/1024 from
information_schema.tables group by table_schema;

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the difference between now() and current_date()?

975

What is row level locking in mysql?

1001

What is striped backup

2236

What is horizontally scalable?

978

Which is better sqlite or mysql?

1030

How do I change directories in mysql?

905

What is the default port number of mysql?

942

What is meant by mysqli?

895

Is mysql a server?

899

How to write date and time literals?

1024

What is bigint in mysql?

908

How can I compare two mysql databases?

960

What is the purpose of using timestamp data type?

914

What are the differences between a primary key and foreign key?

1087

How do I restore a mysql database dump file in linux?

964