LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   How much storage is available in the FREE versions of MariaDB 5.x and 10.x? (https://www.linuxquestions.org/questions/linux-newbie-8/how-much-storage-is-available-in-the-free-versions-of-mariadb-5-x-and-10-x-4175506929/)

cyberdome 06-03-2014 02:31 PM

How much storage is available in the FREE versions of MariaDB 5.x and 10.x?
 
How much storage is available in the FREE versions of MariaDB 5.x and 10.x?

I just want to know how much upto storage available in the MariaDB 5.0 and 10.0 free version?

For example, Oracle offers in their FREE Oracle express edition 11GB.
http://www.oracle.com/technetwork/da...iew/index.html


And Microsoft offers in their FREE SQL server edition 10GB.
http://www.microsoft.com/en-us/serve...id=maoaEr0DL5d

http://msdn.microsoft.com/en-us/eval.../dn434042.aspx


I am wondering how much storage available in the MariaDB free version OR MySQL?
https://mariadb.com/kb/en/which-is-t...on-55-mariadb/


|
|
|
|_ _ _ _

jpollard 06-03-2014 02:37 PM

All of the disk space you are willing to throw at it.

There are no limitations...

Practical limitations maybe - you likely can't afford to buy 100 TB, the power requirements, the mounting space, and the air conditioning really needed to support such a beast.

As your reference showed - 64 TB for a single table; but a database normally has multiple tables, indexes...

szboardstretcher 06-03-2014 02:43 PM

Correct.

Here is a backblaze 850 watt storage array, capable of 180 Terabytes for about $10,000 dollars. It fits in a 4U rack space.

If you need the space that is.

metaschima 06-03-2014 03:05 PM

MariaDB is not FREE, it is free-libre open-source software (FLOSS). Unlike FREEware there are no strings attached. So, there is no size limit on the database itself. In fact, even if there were a limit, you could edit it yourself and change the limit.

szboardstretcher 06-03-2014 03:12 PM

Quote:

Originally Posted by metaschima (Post 5181773)
MariaDB is not FREE, it is free-libre open-source software (FLOSS). Unlike FREEware there are no strings attached. So, there is no size limit on the database itself. In fact, even if there were a limit, you could edit it yourself and change the limit.

Saying free-libre is like saying free-free btw. You were looking to say free/libre/open source software i believe.

It's sort of accepted to say 'mariadb is free software.' Which has all the connotations we expect. No use in typing out the whole politically correct acronym to get your idea across. Unless you are talking in a legal manner that is... IMO.

cyberdome 06-03-2014 03:47 PM

Quote:

Originally Posted by szboardstretcher (Post 5181768)
Correct.

Here is a backblaze 850 watt storage array, capable of 180 Terabytes for about $10,000 dollars. It fits in a 4U rack space.

If you need the space that is.

http://blog.backblaze.com/2013/02/20...orage-pod-3-0/

thanks for mentioning Backblaze. Very interesting and love the Cool Red color. lol. :D

metaschima 06-03-2014 04:01 PM

Quote:

Originally Posted by szboardstretcher (Post 5181782)
Saying free-libre is like saying free-free btw. You were looking to say free/libre/open source software i believe.

It's sort of accepted to say 'mariadb is free software.' Which has all the connotations we expect. No use in typing out the whole politically correct acronym to get your idea across. Unless you are talking in a legal manner that is... IMO.

It is an important point to make in this case. There is huge difference between FREE and free-libre-open-source software. One of them is truly free and the other is free as in freedom. I'll let the reader figure out which one is which.

cyberdome 06-03-2014 04:40 PM

I am starting to learn executing queries on databases. I am a newbie at this. I am using http://www.mockaroo.com/ to generate random DATA for learning purposes. This website only allows 100,000 records. Is there any tool or free website that allows to export unlimited SQL file? Anyone, know where can I learn about executing COMPLEX queries?

I have started here - unable find any info on how to execute complex queries?

https://www.google.com/#q=learn+sql+online

http://www.w3schools.com/sql/default...238abeebb8869c

http://sqlzoo.net/wiki/Main_Page

http://www.tutorialspoint.com/sql/

http://beginner-sql-tutorial.com/sql.htm

evo2 06-03-2014 06:44 PM

Hi,

you can run the database on you own computer store as many records as you like.

Evo2.

chrism01 06-04-2014 05:53 AM

As above, run your own and google the manuals eg http://docs.oracle.com/cd/B19306_01/...b14200/toc.htm, http://dev.mysql.com/doc/refman/5.1/en/ etc etc

metaschima 06-04-2014 12:24 PM

mariadb also has documentation:
https://mariadb.com/kb/en/


All times are GMT -5. The time now is 05:33 PM.