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 a mysql view?

465

How to include character strings in sql statements?

471

Can we store files in mysql?

485

What is bdb (berkeleydb)?

539

Why do we use preparedstatement?

489

Is mysql free for enterprise?

495

Is mysql a programming language?

449

How many entries can mysql handle?

504

How can I create a database in mysql?

471

What is row?

571

What is not null in mysql?

516

What are date and time data types?

502

How do I grant privileges to a user in mysql phpmyadmin?

477

What is mysql procedure?

511

Can we save images in mysql database?

468