LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-03-2014, 02:31 PM   #1
cyberdome
Member
 
Registered: Mar 2014
Distribution: Fedora 23 - MariaDB 10.1 -
Posts: 130
Blog Entries: 2

Rep: Reputation: 8
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/


|
|
|
|_ _ _ _

Last edited by cyberdome; 06-03-2014 at 02:40 PM.
 
Old 06-03-2014, 02:37 PM   #2
jpollard
Senior Member
 
Registered: Dec 2012
Location: Washington DC area
Distribution: Fedora, CentOS, Slackware
Posts: 4,688

Rep: Reputation: 1259Reputation: 1259Reputation: 1259Reputation: 1259Reputation: 1259Reputation: 1259Reputation: 1259Reputation: 1259Reputation: 1259
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...

Last edited by jpollard; 06-03-2014 at 02:40 PM.
 
Old 06-03-2014, 02:43 PM   #3
szboardstretcher
Senior Member
 
Registered: Aug 2006
Location: Detroit, MI
Distribution: GNU/Linux systemd
Posts: 4,185

Rep: Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586
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.
 
Old 06-03-2014, 03:05 PM   #4
metaschima
Senior Member
 
Registered: Dec 2013
Distribution: Slackware
Posts: 1,982

Rep: Reputation: 491Reputation: 491Reputation: 491Reputation: 491Reputation: 491
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.

Last edited by metaschima; 06-03-2014 at 03:06 PM.
 
Old 06-03-2014, 03:12 PM   #5
szboardstretcher
Senior Member
 
Registered: Aug 2006
Location: Detroit, MI
Distribution: GNU/Linux systemd
Posts: 4,185

Rep: Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586Reputation: 1586
Quote:
Originally Posted by metaschima View Post
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.

Last edited by szboardstretcher; 06-03-2014 at 03:17 PM.
 
Old 06-03-2014, 03:47 PM   #6
cyberdome
Member
 
Registered: Mar 2014
Distribution: Fedora 23 - MariaDB 10.1 -
Posts: 130
Blog Entries: 2

Original Poster
Rep: Reputation: 8
Quote:
Originally Posted by szboardstretcher View Post
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.
 
Old 06-03-2014, 04:01 PM   #7
metaschima
Senior Member
 
Registered: Dec 2013
Distribution: Slackware
Posts: 1,982

Rep: Reputation: 491Reputation: 491Reputation: 491Reputation: 491Reputation: 491
Quote:
Originally Posted by szboardstretcher View Post
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.
 
Old 06-03-2014, 04:40 PM   #8
cyberdome
Member
 
Registered: Mar 2014
Distribution: Fedora 23 - MariaDB 10.1 -
Posts: 130
Blog Entries: 2

Original Poster
Rep: Reputation: 8
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
 
Old 06-03-2014, 06:44 PM   #9
evo2
LQ Guru
 
Registered: Jan 2009
Location: Japan
Distribution: Mostly Debian and Scientific Linux
Posts: 5,753

Rep: Reputation: 1288Reputation: 1288Reputation: 1288Reputation: 1288Reputation: 1288Reputation: 1288Reputation: 1288Reputation: 1288Reputation: 1288
Hi,

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

Evo2.
 
Old 06-04-2014, 05:53 AM   #10
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.9, Centos 7.3
Posts: 17,356

Rep: Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367Reputation: 2367
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
 
Old 06-04-2014, 12:24 PM   #11
metaschima
Senior Member
 
Registered: Dec 2013
Distribution: Slackware
Posts: 1,982

Rep: Reputation: 491Reputation: 491Reputation: 491Reputation: 491Reputation: 491
mariadb also has documentation:
https://mariadb.com/kb/en/
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
The free-ness of various portable storage (CF, SD, etc.) metamechanical Linux - Hardware 4 07-05-2010 09:31 PM
LXer: 10 free storage utilities LXer Syndicated Linux News 0 02-24-2007 10:31 PM
Free 4 CD versions randomthings Mandriva 4 01-23-2007 12:30 AM
Are all versions of SuSE not free? beatupbilly SUSE / openSUSE 3 11-24-2004 02:20 AM
What is the free version, compared to the purchasable versions? Konig Mandriva 7 04-21-2004 03:43 PM


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

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration