20K pages, 23Gb: Can Joomla 3.3 handle without any issues?
Moderator: General Support Moderators
Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
-
- Joomla! Enthusiast
- Posts: 221
- Joined: Sat May 31, 2008 12:15 am
- Location: Yokohama, Japan
- Contact:
20K pages, 23Gb: Can Joomla 3.3 handle without any issues?
I have been asked by a client with the question above title.
Questions:
1. MySQL capacity in Joomla 3.3?
2. Akeeba Backup can handle that big site with the big db size?
3. site traffic 20k pv / month currently
Server CPU XEON, Main Memory 14Gb, HDD 700Gb
If Joomla 2.5, can it handle without problems?
Norito
Questions:
1. MySQL capacity in Joomla 3.3?
2. Akeeba Backup can handle that big site with the big db size?
3. site traffic 20k pv / month currently
Server CPU XEON, Main Memory 14Gb, HDD 700Gb
If Joomla 2.5, can it handle without problems?
Norito
- sitesrus
- Joomla! Ace
- Posts: 1469
- Joined: Mon Nov 12, 2012 10:48 pm
Re: 20K pages, 23Gb: Can Joomla 3.3 handle without any issue
Yes. Things just bog down as your db gets larger, traffic loads too high, and etc. It's easy to identify bottle knecks though and then remedy either via hardware or software. But joomla is open source and tweaking/hacking isn't a good idea so you will have to focus on hardware solutions probably. And joomla has good developers so I'm sure it's optimized to run on the platform.
I like working with Joomla . I offer the following professional services: Custom extension development, SEO/marketing, maintenance/support, security and WCAG audits, and will work on websites at a reasonable rate.
-
- Joomla! Enthusiast
- Posts: 221
- Joined: Sat May 31, 2008 12:15 am
- Location: Yokohama, Japan
- Contact:
Re: 20K pages, 23Gb: Can Joomla 3.3 handle without any issue
Thank you for your input.
It seems 28Gb out of 29 may be PDF files, so I have to find ways to back them up smoothly.
It is impossible to get zipped file via FTP to my PC.
It seems 28Gb out of 29 may be PDF files, so I have to find ways to back them up smoothly.
It is impossible to get zipped file via FTP to my PC.
-
- Joomla! Apprentice
- Posts: 16
- Joined: Fri Aug 18, 2006 6:56 pm
Re: 20K pages, 23Gb: Can Joomla 3.3 handle without any issue
28GB of PDF files stored as binary objects in the database or are those files stored on flat file storage somewhere with references to file location in the database? If they are actually in mysql and you have a heavy read commit you are going to want to address that with better hardware.
-
- Joomla! Virtuoso
- Posts: 4025
- Joined: Mon Nov 25, 2013 4:35 pm
- Location: Montreal, Canada
- Contact:
Re: 20K pages, 23Gb: Can Joomla 3.3 handle without any issue
There is virtually no limit when it comes to MySQL. Your website traffic is not that huge, but your number of pages that you have (20,000) means one of the following:
- You'll have to use Joomla's page caching
- You'll have to do some series of optimizing on the actual site (starting with the template, and then the 3rd party extensions, and finally with Joomla's own core)
Your server seems to be more than ample to handle that load - one of our clients has a very similar website with traffic about 1,000,000/month (traffic is spread over 3 websites). You might want to check the case study here: Note that the post was written a year ago, and since then the traffic and the number of articles have doubled.
I wouldn't trust Akeeba to backup such a website (in fact, I don't trust Akeeba for backing up even tiny websites, but that's a personal opinion), the likelihood that it'll crash is extremely high. If you have cPanel, then you can do the backup from cPanel, which is better and much more stable and supported by your host (so, if something goes wrong, you can tell your host to restore your website from a cPanel backup).
- You'll have to use Joomla's page caching
- You'll have to do some series of optimizing on the actual site (starting with the template, and then the 3rd party extensions, and finally with Joomla's own core)
Your server seems to be more than ample to handle that load - one of our clients has a very similar website with traffic about 1,000,000/month (traffic is spread over 3 websites). You might want to check the case study here:
Code: Select all
http://www.itoctopus.com/how-we-optimized-a-large-joomla-2-5-website-and-made-it-over-200-times-faster
I wouldn't trust Akeeba to backup such a website (in fact, I don't trust Akeeba for backing up even tiny websites, but that's a personal opinion), the likelihood that it'll crash is extremely high. If you have cPanel, then you can do the backup from cPanel, which is better and much more stable and supported by your host (so, if something goes wrong, you can tell your host to restore your website from a cPanel backup).
http://www.itoctopus.com - Joomla consulting at its finest
https://twitter.com/itoctopus - Follow us on Twitter
https://twitter.com/itoctopus - Follow us on Twitter
-
- Joomla! Apprentice
- Posts: 23
- Joined: Wed Jul 23, 2014 6:43 pm
- Contact:
Re: 20K pages, 23Gb: Can Joomla 3.3 handle without any issue
It's depend on how many current connection (EP / user online at same time)
-
- Joomla! Apprentice
- Posts: 23
- Joined: Sat Jul 26, 2014 9:36 am
Re: 20K pages, 23Gb: Can Joomla 3.3 handle without any issue
@Hanjimail : Why do you use Joomla 2.5 instead of using Joomla 3.x ?
-
- Joomla! Fledgling
- Posts: 4
- Joined: Mon Jul 28, 2014 2:39 pm
Re: 20K pages, 23Gb: Can Joomla 3.3 handle without any issue
If they are actually in mysql and you have a heavy read commit you are going to want to address that with better hardware.
Best Regards
http://www.apktrunk.com/
http://www.apktrunk.com/
-
- Joomla! Apprentice
- Posts: 41
- Joined: Wed Jan 04, 2006 8:05 pm
- Location: Italy
- Contact:
Re: 20K pages, 23Gb: Can Joomla 3.3 handle without any issue
If it can help to evaluate, I’m working on a Joomla! 3.3.3 site with 10K contents and 270K page views monthly.
It is running on a VPS with 4 core, 2GB of RAM and SSD storage in FastCGI + APC and work fine. I’m investigating about table indexing in Joomla! to get less full table scan, but even now, from “Pingdom RUM report” I’m getting satisfied users.
I’ve placed large files on server (audio, video and PDF) in Amazon CloudFront, but before moving it, I had about 18GB of data and Akeeba Backup was managing it.
It is running on a VPS with 4 core, 2GB of RAM and SSD storage in FastCGI + APC and work fine. I’m investigating about table indexing in Joomla! to get less full table scan, but even now, from “Pingdom RUM report” I’m getting satisfied users.
I’ve placed large files on server (audio, video and PDF) in Amazon CloudFront, but before moving it, I had about 18GB of data and Akeeba Backup was managing it.