What happens when your mysql database reaches it's limit? I was told the limit is 2GB,which is alot,but i'm just wondering what will happen. I have a few sites using the same mysql database so I just want to know. And for example,say you have a Forum that reaches it's mysql database limit,what happens to your forum? Can't people post anymore? Or do you create a new database and get your forum to start using the new one and keep the old one?
I think 2GB is enough for small sites. I think you should remove your DB log. it also count space with actuall DB space.
I am not exactly sure what happens, but I would imagine that once your limit is reached post will not be able to be made.
MySQL doesn't have 2GB database size limit. There is a limit for table size, but it is much more than that. Rows size limit is 64 KiB exlcluding BLOB and TEXT fields.
Perhaps 2 GB is the DB limit put by the Hosting provider. e.g. 1&1 have a 50 MB limit for each mysql database, but you can have multiple dbs. So if 2 GB is the limit per db, you can perhaps see if you can have multiple dbs.
i found out that my host uses the hard drive space for the mysql limit. so my server has 1000GB of space,so my mysql can be up to 1000GB large.
It gives a weird error saying the data is corrupt happened to me a few years ago... after increasing the space from the provider resumed working well...