Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 63 guests, and 388 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Morgan
Morgan
Sweden
Posts: 518
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 17
M4TT 12
FREAK 8
Ruben 8
mmkk 4
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
UBB Reccommended Maximums #257117
08/08/15 02:52 PM
08/08/15 02:52 PM
Joined: Jun 2008
Posts: 37
A
Abbott Offline OP
newbie
Abbott  Offline OP
newbie
A
Joined: Jun 2008
Posts: 37
Are there any recommended maximums for:

Number of forums?
Number of Topics in a forum?
Total Topics across all forums
Number of Posts in a Topic?
Total Posts across all Topics in a forum?
Number of posts across all forums?

Trying to get an idea if there are any key numbers I should be monitoring.

We have a relatively small forum with less than 500,000 posts but there are a few threads with over 5,000 replies to a single topic.

I searched the UBB forums but did not come up with an answer.

Version 7.5.9

Abbott

Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: UBB Reccommended Maximums [Re: Abbott] #257118
08/08/15 03:19 PM
08/08/15 03:19 PM
Joined: Apr 2004
Posts: 1,004
California
isaac Offline
UBB.threads Developer
isaac  Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,004
California
It mostly depends on your server's hardware, operating system, also the setting you have for each of the services you're running; such as files and connections allowed open at once, and input/output data transaction sizes, etc.

If your server is using MySQL, have a quick read through:
https://dev.mysql.com/doc/refman/5.0/en/table-size-limit.html

---
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. The following table lists some examples of operating system file-size limits. This is only a rough guide and is not intended to be definitive. For the most up-to-date information, be sure to check the documentation specific to your operating system.

Operating System -- File-size Limit
Win32 w/ FAT/FAT32 -- 2GB/4GB
Win32 w/ NTFS -- 2TB (possibly larger)
Linux 2.2-intel 32-bit -- 2GB (LFS: 4GB)
Linux 2.4+ (using ext3 file system) -- 4TB
Solaris 9/10 -- 16TB
MacOS X w/ HFS+ -- 2TB
NetWare w/NSS file system -- 8TB
---

Expanding upon that, here is another link that summarizes the first link a bit more:
http://nickduncan.co.za/maximum-mysql-database-size/

Quote:
...my max database size can be as much as 281,474,976,710,655 bytes which If I’m not mistaken, equates to 256 terabytes. With this being said, I think we are going to run into system limitations rather than MySQL limitations...

Last edited by id242; 08/08/15 03:31 PM.
Re: UBB Reccommended Maximums [Re: Abbott] #257119
08/09/15 05:02 PM
08/09/15 05:02 PM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,827
Lutz,FL
Also turning on zlib and
stats at the bottom of the page:
Control Panel » Primary Settings
Show Debug Information in Footer?
Enable zlib Compression?
Zlib if installed will help speed up the pages
and debug info will show you if your queries are slow or slowing down.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: UBB Reccommended Maximums [Re: Abbott] #257202
08/26/15 02:40 PM
08/26/15 02:40 PM
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
Joined: Apr 2007
Posts: 4,313
SoCal, USA
just as a benchmark -- i support ( make mods and do other stuff for the client ) 2 forums that run on the same box

1 forum is 9million posts
other forum is 7million posts

server load never goes over 2, which really means it's twiddling it's thumbs.

server just loaded up on RAM ( 32gig ) and SSDs ( RAID ) for the OS / data.

so UBB is very efficient smile

Re: UBB Reccommended Maximums [Re: Abbott] #257219
08/29/15 06:41 AM
08/29/15 06:41 AM
Joined: Jun 2006
Posts: 518
Sweden
Morgan Offline
addict
Morgan  Offline
addict
Joined: Jun 2006
Posts: 518
Sweden
Ruben, what will happen if I Enable zlib Compression ?
I have not that enabled and my databaze is 1.02 GB


Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php?
Re: UBB Reccommended Maximums [Re: Abbott] #257220
08/29/15 09:25 AM
08/29/15 09:25 AM
Joined: Apr 2004
Posts: 1,004
California
isaac Offline
UBB.threads Developer
isaac  Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,004
California
Enabling Zlib Data Compression will result in smaller page sizes, but could add to overall server load.
An explanation of zlib data compression can be read at https://en.wikipedia.org/wiki/Zlib

Zlib Data Compression is unrelated to database size.

Re: UBB Reccommended Maximums [Re: isaac] #257222
08/29/15 09:40 AM
08/29/15 09:40 AM
Joined: Jun 2008
Posts: 37
A
Abbott Offline OP
newbie
Abbott  Offline OP
newbie
A
Joined: Jun 2008
Posts: 37
Thank you id242 and Sir Dude.

We are a small community that holds onto posts for a very long time since many have technical information that remains valid over time.

Many of our posts have inline images but that is just a storage issue.

Abbott


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Users Unable to Upload Avatar [Not a Bug]
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,544
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)