Do MySQL have data storing limitation?

We're on the initial stage of thesis study, and one of the requirements is unlimited data storing through a database. But I'm only familiar with MySQL's configurations and totally intimidated with SQL Server's methods.





Answer please, it means so much.|||MySQL can scale up, but you'll probably need to look into clustering (http://www.mysql.com/products/database/c鈥?/a> ). The only other I've any idea of is Oracle, their solution is called RAC ( have a look at http://en.wikipedia.org/wiki/Oracle_RAC ).


They are very different solutions as well - MySQL employs several servers with their own shard of the data ( i.e. a database containing a segment of the overall data ) whereas Oracle has several servers accessing the same database files ( usually stored on a SAN ).|||There is no such thing as unlimited data storage. It is impossible to store an infinite amount of data. Eventually you are limited based on the size of the disks you can give the database access to.





That being said. Each database has different limits on the size. mySQL was already answered.





PostgreSQL has a limit of 32TB in a single table but you can have a theoretically unlimited number of tables.|||Hi,





I won't elaborate on size limitation since other members did it well. For sure you are limited to the hardware (size of disk) and filesystem ... example a DB running on fat would be limited to 2GB. What I can suggest it's to limit the size of your db it's to avoid to save file on the database itself example if you need to save picture don't save inside the db but save it locally and save only the acess path in varchar to the db it avoid to oversize the DB for nothing and having files save on db also tend to slow the MySql Server ... Try also in software design to restrict your query at maximum example use SELECT col1, col2 instead of select * ... Having tables for redundant field is also a good idea let's sy table country with ID and name then refer to the country id in the other tables helps the performance and the size of db.





Hope it helps





Hope it help|||The database size is operating system dependent. http://dev.mysql.com/doc/refman/5.0/en/f鈥?/a>