Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

What is the purpose of first volume when creating database?

CUBRID Official Forum » General Discussions » What is the purpose of first volume when creating database?

author
message
[Level:0]majidazimi

Post subject: What is the purpose of first volume when creating database?

registered: 03/09/2013

IP: *.42.54.159

views: 1

Hi,

What is the purpose of first volume when creating database which is generic volume? Why it is not data volume?

What is the usage of generic volume? It means it can hold both data and index?

Quote
[Level:3]Esen Sagynov

# Post subject:Re: What is the purpose of first volume when creating database?

profile

registered: 05/31/2011

IP: *.91.139.82

Hello Majid Azimi,

So you already know there are different volume types such as generic, data, index, temp, control, active log, and archive log. By default when you create a database using cubrid createdb command line utility, CUBRID will create a generic volume for you. This generic volume will be used to store everything: data, index, and temp data.

So, when your database grows, CUBRID automatically adds new volumes for you. The type of the new volume will be the same as the type of the first volume, which in our case is generic. Though this is a convenient option, there is a performance issue due to increased IO because everything is in one volume. When the engine needs to add new data it updates the generic volume, when it needs to update the indexes, it updates the generic volume, and so on, thus a lower performance. Therefore it is recommended to create/add a separate data volume, index volume, and a temp volume using cubrid addvoldb utility, because this would improve the overall performance.

As you know you can also create a database using CUBRID Manager (CM) GUI program. There is one difference though: CM automatically creates different volumes for your databases, i.e. it will create a separate data volume, index volume and temp volume.

Depending on your preference you may choose to use the default generic volume or create separate volumes. At NHN for real services we do create separate volumes. For testing or demo applications, there may be no need to separate anything.

Let me know if you have other questions.

Quote




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: