|
What is the maximum size of a MySQL database in version 5 and up?
I do not mean the maximum size of row or table, but the maximum size of the whole database.
Started by shouman on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
This documentation entry is very helpful in regards to this
The maximum size for MySQL databases is determined by operating system constraints on file.
On Windows its dependent on maximum folder size.
|
|
Hi folks,
i've got around 10 tables in my sql 2008 server.
Currently, my mdf is around 3.5Gig. (I also have some binary data in some of the tables). So, I'm wondering if there's a way i could see which tables are the biggest in size.
Is this possible?...
Started by Pure.Krome on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
*/ , [Index Size] varchar(18) /* Amount of space used] , [Number of Rows] , [Reserved....
This query shows the size of each table in the current database) /* Amount of space used by data in table.
The 'rows' column that may interest you.
|
|
Duplicate of: http://stackoverflow.com/questions/1496136/how-to-find-out-size-of-the-individual-databases-in-the-sql-server-2005
how to find out log size of each of the database in sql server 2005?
Started by srihari on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You will get both Data and Log file size....
These you can see one "Initial size" column which will be the size of your DB.
In SQL management studio , goto object explorer, right click database, goto "properties" , select "Files" .
|
Ask your Facebook Friends
|
How to get column size from database in .NET?
Started by Jolley on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
!!!
i am actually working on WPF and i ma using sql server 2008, and i want to put my textbox size as same as respective column size, so i need the max length of a column, how to do it in xaml.cs file?.
|
|
SQL Server 2005/2008 Express edition has the limitation of 4 GB per database. As far as I known the database engine considers data only, thus excluding log files, unused space, and index size.
Getting the length of the MDF file should not give the correct...
Started by Michael Damatov on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
According to SQL2000 help, sp_spaceused includes data), data VARCHAR(18), index_size VARCHAR....
Look at the "Size" figure.
Sp_spaceused
In SQL Management Studio, right-click on a database and select "Properties" from the context menu.
|
|
I'm interested in what is the potential of MSSQL when it comes to volume of data (size of the database, number of rows, etc.).
Started by Piotr Owsiak on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Possible database size...)
check this Link for all the other information and sizing numbers for sql Largest Database Size, All Environments More recently, check this out: Microsoft Applauds 1.1 Petabytes (as these are....
|
|
I have a strange problem. The size of my postgresql (8.3) is increasing. So I made a dump and then cleaned up the database and then re-imported the dump. The database size was reduced by roughly 50%.
Some infomation: (1) AUTOVACUUM and REINDEX are running...
Started by stanleyxu2005 on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
The end result is....
Run database wide you try a VACUUM FULL , too? (Warning, it locks your database for a long time.) I am not sure to free everything.
Interactive/routine-vacuuming.html#AUTOVACUUM
running reindex shouldn't be necessary.
|
|
Hi, How can I get the size of my UDB DB2 version 9.1 database? I tried firing getdbconfig from the command prompt. It gives all the configuration but not the size.
Thanks :)
Started by Rashmi Pandit on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
The size of a DB2 LUW database on a UNIX server using UNIX commands that will give you a more accurate the size of a DB2 database
If you want to calculate the size and maximum capacity of your database, you to....
|
|
I'm told that show table status is useful in finding the size of a database, but I get an unreadable mess. Is there any way to alter this command to get less information, or is there another way to find the size of a database or table?
Started by FarmBoy on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
Index_length
This is the size....
Data_length
This is the size of the data within the table in bytes.
Echo "Total MySQL db size: $size"; ?>
If you're looking for the actual size the databaseThe two fields you want are.
|
|
I have the following problem. We have a database that stores binaries in the database. We know the size of the database can be big so we removed all the binaries from the database and used the task "shrink" on it. This way we hoped that the database would...
Started by Sem Dendoncker on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
One possibility is that the table you've deleted.
Log backups (not just database backups as they will not keep the log small as you have found out backup just to keep the log a reasonable size.
|
