Jump to content


Photo

What Is The Quota Of Sql Databases?

database quota

  • Please log in to reply
3 replies to this topic

#1 1s4ha

1s4ha

    Newbie

  • Members
  • 3 posts

Posted 22 November 2016 - 12:34 AM

Hi, I really love this free host, it's even better than the paid ones. One small question, is there a limit for database usage? Or it is depended on the disk usage?



#2 wolstech

wolstech

    Rank X Member

  • Root Admin
  • 12,416 posts
  • Gender:Male
  • Location:Pennsylvania

Posted 22 November 2016 - 01:05 AM

The database size just counts toward your account's disk space quota I believe.

The only other limit we have on it is overuse/abuse of CPU time. Running complex or badly written queries that monopolize the server (or crash it...) can get you suspended for high load. Pretty much all common software doesn't have any issues with the load though.

Finally, I recommend staying away from the innodb storage engine in MySQL if you're on Stevie, it is subject to going read only or just losing your data without notice if the database server crashes (can happen due to abuse on occasion).

Please do not PM me for support. Posting on our forums lets all of us learn.
Do you play Minecraft? | Server Monitors | And the Dumbass of the Decade award goes to...


#3 1s4ha

1s4ha

    Newbie

  • Members
  • 3 posts

Posted 23 November 2016 - 12:05 PM

The database size just counts toward your account's disk space quota I believe.

The only other limit we have on it is overuse/abuse of CPU time. Running complex or badly written queries that monopolize the server (or crash it...) can get you suspended for high load. Pretty much all common software doesn't have any issues with the load though.

Finally, I recommend staying away from the innodb storage engine in MySQL if you're on Stevie, it is subject to going read only or just losing your data without notice if the database server crashes (can happen due to abuse on occasion).

Thanks, I'm using phpBB that uses innodb storage engine on Stevie, can I change the engine? If not, what should I do?



#4 wolstech

wolstech

    Rank X Member

  • Root Admin
  • 12,416 posts
  • Gender:Male
  • Location:Pennsylvania

Posted 23 November 2016 - 12:20 PM

It's not as common as it sounds, but it has happened once or twice this year.

 

If you want to convert it, the safest way is export the database to a .sql file, replace all the Engine=InnoDB with Engine=MyISAM in the .sql file, then create a new database and import the edited file. After that, just point PhpBB to the new database, test, and drop the old one. Many people report newer PhpBB having trouble on MyISAM though, so if it acts strange, you may need to find other forum software or just make frequent backups (which we recommend anyway!) so you can restore it if InnoDB decides to go belly up.


Please do not PM me for support. Posting on our forums lets all of us learn.
Do you play Minecraft? | Server Monitors | And the Dumbass of the Decade award goes to...






Also tagged with one or more of these keywords: database, quota

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users